Fantom example queries

This page provides Blockchain Analytics query examples for Fantom.

See the BigQuery documentation for instructions on using BigQuery.

View the earliest and most recently indexed block

In the Google Cloud console, go to the BigQuery page.

Go to BigQuery

The following query is loaded into the Editor field:

SELECT
  MIN(block_number) AS `First block`,
  MAX(block_number) AS `Newest block`,
  COUNT(1) AS `Total number of blocks`
FROM
  bigquery-public-data.goog_blockchain_fantom_opera_us.blocks;

Example result:

Top 10 wallets by number of transactions

In the Google Cloud console, go to the BigQuery page.

Go to BigQuery

The following query is loaded into the Editor field:

SELECT 
  from_address, 
  COUNT(*) AS num_transactions 
FROM `bigquery-public-data.goog_blockchain_fantom_opera_us.transactions`
GROUP BY from_address
ORDER BY num_transactions DESC
LIMIT 10;

Example result