Snowflake Datashare

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.

Available Blockchain Data

Primary Network

• C-chain:
  • Blocks
  • Transactions
  • Logs
  • Internal Transactions
  • Receipts
  • Messages
• P-chain:
  • Blocks
  • Transactions
  • UTXOs
• X-chain:
  • Blocks
  • Transactions
  • Vertices before the X-chain Linearization in the Cortina Upgrade
• 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

Available Avalanche L1s

• Gunzilla
• Dexalot
• DeFi Kingdoms (DFK)
• Henesys (MapleStory Universe)

L1 Data

• Blocks
• Transactions
• Logs
• Internal Transactions (currently unavailable for DFK)
• Receipts
• Messages

Access

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