P-chain and X-chain blockchain data can be accessed in a sql-based table format via the Snowflake Data Marketplace.

Explore the blockchain state since the Genesis Block on both the P-chain and X-chain. These tables provide insights on transaction gas fees, 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:

  • P-chain:
    • Blocks
    • Transactions
    • UTXOs
  • X-chain:
  • Dictionary: A data dictionary is provided with the listing with column and table descriptions. Example columns include:
    • 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

Visit the Ava Labs profile on the Snowflake Data Marketplace.