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 BigQuerypage.
The following query is loaded into the Editorfield:
#
Average
daily
transactions
count
drop
since
announcement
of
Goerli
#
deprecation
(
two
weeks
around
Apr
1
st
,
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 BigQuerypage.
The following query is loaded into the Editorfield:
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 |
