This page provides Blockchain Analytics query examples for Ethereum Goerli.
See the BigQuery documentation for instructions on using BigQuery.
Average daily transactions count drop since announcement of Goerli deprecation
This query looks at the drop in average daily transactions on Goerli once it was announced on April 1, 2023 that the Goerli testnet would be deprecated in favor of the Sepolia and Holesky testnets.
In the Google Cloud console, go to the BigQuery page.
The following query is loaded into the Editor field:
# Average daily transactions count drop since announcement of Goerli
# deprecation (two weeks around Apr 1st, 2023) In favor of new Sepolia chain
SELECT
DATE(block_timestamp) AS date,
COUNT(*) AS num_transactions
FROM
`bigquery-public-data.goog_blockchain_ethereum_goerli_us.transactions`
WHERE
block_timestamp >= TIMESTAMP('2023-03-24')
AND block_timestamp <= TIMESTAMP('2023-04-08')
GROUP BY
1
ORDER BY
1 DESC;
The following shows an example result:
| Date | Number of Transactions |
|---|---|
| 2023-04-08 | 80 |
| 2023-04-07 | 633,348 |
| 2023-04-06 | 530,415 |
| 2023-04-05 | 485,717 |
| 2023-04-04 | 478,859 |
| 2023-04-03 | 493,144 |
| 2023-04-02 | 514,925 |
| 2023-04-01 | 460,480 |
| 2023-03-31 | 524,960 |
| 2023-03-30 | 532,627 |
| 2023-03-29 | 596,644 |
| 2023-03-28 | 555,764 |
| 2023-03-27 | 541,082 |
| 2023-03-26 | 550,949 |
| 2023-03-25 | 541,940 |
| 2023-03-24 | 591,707 |
Daily transaction count for the last 7 days
In the Google Cloud console, go to the BigQuery page.
The following query is loaded into the Editor field:
SELECT
DATE(block_timestamp) AS date,
COUNT(*) AS num_transactions
FROM
`bigquery-public-data.goog_blockchain_ethereum_goerli_us.transactions`
WHERE
block_timestamp >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 10 DAY)
GROUP BY
1
ORDER BY
1 DESC;
The following shows an example result:
| date | num_transactions |
|---|---|
| 2023-09-08 | 181766 |
| 2023-09-07 | 278809 |
| 2023-09-06 | 209469 |
| 2023-09-05 | 265245 |
| 2023-09-04 | 260391 |
| 2023-09-03 | 240675 |
| 2023-09-02 | 243579 |
| 2023-09-01 | 220796 |
| 2023-08-31 | 216822 |
| 2023-08-30 | 208608 |
| 2023-08-29 | 52474 |