Avalanche Primary Network data (C-chain, P-chain, and X-chain blockchains) can be accessed in a sql-based table format via the Snowflake Data Marketplace.

Explore the blockchain state since the Genesis Block. These tables provide insights on transaction gas fees, DeFi activity, the historical stake of validators on the primary network, AVAX emissions rewarded to past validators/delegators, and fees paid by Avalanche L1 Validators to the primary network.

Features

Blockchain Data Available:

  • C-chain:
    • Blocks
    • Transactions
    • Logs
    • Internal Transactions
    • Receipts
    • Messages
  • P-chain:
    • Blocks
    • Transactions
    • UTXOs
  • X-chain:
  • Dictionary: A data dictionary is provided with the listing with column and table descriptions. Example columns include:
    • c_blocks.blockchash
    • c_transactions.transactionfrom
    • c_logs.topichex_0
    • p_blocks.block_hash
    • p_blocks.block_index
    • p_blocks.type
    • p_transactions.timestamp
    • p_transactions.transaction_hash
    • utxos.utxo_id
    • utxos.address
    • vertices.vertex_hash
    • vertices.parent_hash
    • x_blocks.timestamp
    • x_blocks.proposer_id
    • x_transactions.transaction_hash
    • x_transactions.type

Access

Search for the Ava Labs profile on the Snowflake Data Marketplace.