[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-04 UTC."],[[["\u003cp\u003eThis page provides examples of Blockchain Analytics queries for the Fantom network using Google Cloud's BigQuery.\u003c/p\u003e\n"],["\u003cp\u003ePre-GA offerings, like the ones described here, are subject to the "Pre-GA Offerings Terms" and have limited support.\u003c/p\u003e\n"],["\u003cp\u003eYou can find the earliest and most recently indexed blocks on Fantom using a provided BigQuery query.\u003c/p\u003e\n"],["\u003cp\u003eAnother BigQuery query demonstrates how to identify the top 10 wallets on Fantom by their number of transactions.\u003c/p\u003e\n"]]],[],null,["# Fantom example queries\n\n| **Preview**\n|\n|\n| This product or feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA products and features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n\nThis page provides Blockchain Analytics query examples for Fantom.\n\nSee the [BigQuery documentation](/bigquery/docs/introduction) for\ninstructions on using BigQuery.\n\nView the earliest and most recently indexed block\n-------------------------------------------------\n\nIn the Google Cloud console, go to the **BigQuery** page.\n\n[Go to BigQuery](https://console.cloud.google.com/bigquery?sq=650023896125:7178314adf344543a494a344e146af5f)\n\nThe following query is loaded into the **Editor** field: \n\n SELECT\n MIN(block_number) AS `First block`,\n MAX(block_number) AS `Newest block`,\n COUNT(1) AS `Total number of blocks`\n FROM\n bigquery-public-data.goog_blockchain_fantom_opera_us.blocks;\n\n**Example result**:\n\nTop 10 wallets by number of transactions\n----------------------------------------\n\nIn the Google Cloud console, go to the **BigQuery** page.\n\n[Go to BigQuery](https://console.cloud.google.com/bigquery?sq=650023896125:2109b22594634ec38dd7be5fa5ec7c81)\n\nThe following query is loaded into the **Editor** field: \n\n SELECT \n from_address, \n COUNT(*) AS num_transactions \n FROM `bigquery-public-data.goog_blockchain_fantom_opera_us.transactions`\n GROUP BY from_address\n ORDER BY num_transactions DESC\n LIMIT 10;\n\n**Example result**"]]
