Avalanche example queries

This page provides Blockchain Analytics query examples for Avalanche.

See the BigQuery documentation for instructions on using BigQuery.

View the first and last block indexed

This query tells you how fresh the data is.

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_avalanche_contract_chain_us.blocks;

The following shows an example result:

View the blocks with largest AVAX value transfer

This query shows you which blocks had the largest total value of AVAX transferred between accounts. It only counts successful transactions.

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

Go to BigQuery

The following query is loaded into the Editor field:

SELECT block_hash, SUM(value.bignumeric_value / 1000000000000000000) value_total
FROM `bigquery-public-data.goog_blockchain_avalanche_contract_chain_us.transactions`
  JOIN `bigquery-public-data.goog_blockchain_avalanche_contract_chain_us.receipts` USING (block_hash, transaction_hash)
WHERE status = 1
GROUP BY block_hash
ORDER BY value_total DESC
LIMIT 5

The following shows an example result: