This page provides Blockchain Analytics query examples for Polygon Mainnet.
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.
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_polygon_mainnet_us.blocks; The following shows an example result:
| First Block | Newest Block |
|---|---|
| 0 | 54794165 |
Calculate TPS (transactions per second) by month on Polygon mainnet
The following query is loaded into the Editor field:
SELECT COUNT(*) AS TXN_COUNT_PER_MONTH, COUNT(*) / 2592000.0 AS TXN_PER_SECOND, # seconds in a month EXTRACT(YEAR FROM txn.block_timestamp) AS YEAR, EXTRACT(MONTH FROM txn.block_timestamp) AS MONTH, FROM `bigquery-public-data.goog_blockchain_polygon_mainnet_us.transactions` AS txn GROUP BY EXTRACT(YEAR FROM txn.block_timestamp), EXTRACT(MONTH FROM txn.block_timestamp) ORDER BY TXN_COUNT_PER_MONTH DESC; The following shows an example result:
| TXN_COUNT_PER_MONTH | TXN_PER_SECOND | YEAR | MONTH |
|---|---|---|---|
| 113,037,832 | 43.610274691358022 | 2024 | 2 |
| 103,680,742 | 40.0002862654321 | 2024 | 1 |
| 82,598,612 | 31.866748456790123 | 2024 | 3 |