Ethereum Goerli example queries

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.

Go to BigQuery

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