BitqueryBitqueryData Store
CardanoBlocksTransactionsTransfersUTXO

Cardano

The full Cardano ledger since the 2017 Byron genesis: blocks, transactions, inputs, outputs and mints with ADA, native assets and USD values.

Coverage
Full historyto Sep 24, 2026 · yesterday
Tables
5Parquet, one prefix each
Columns
97across 5 tables
Coverage ends yesterday, UTC

Overview

Every Cardano block, transaction, input and output from the Byron genesis in September 2017 to yesterday, with ADA values in lovelace, ADA and USD at block time. Each input and output has one row for its ADA amount and one more row for every native asset it carries, so tokens and NFTs are traced with the same joins as ADA. Payment addresses come with their stake key, and transactions carry their metadata.

Inputs carry the hash and index of the output they spend, and a mints table records every native asset minted or burned, so supply and flow of any asset are two joins. Files are cut by block range and named by their first and last block, so any window can be assembled exactly.

Use cases

  • Extended UTXO graph analysis and address clustering by stake key
  • Native asset and NFT flow tracing across mints, inputs and outputs
  • Fee, deposit and withdrawal research from Byron to the current era
  • Coin-age and dormancy studies from spend links

5 tables

97 columns · free sample for each table

blocks

17 columns

One row per block: size, transaction count, fees, epoch, slot and slot leader.

cardano/blocks<start_block>_<end_block>.parquetone file per block range
Browse columns Sample fileSample updated Sep 25, 2026

transactions

28 columns

One row per transaction with input, output, fee and mined values in ADA, lovelace and USD.

cardano/transactions<start_block>_<end_block>.parquetone file per block range
Browse columns Sample fileSample updated Sep 25, 2026

inputs

21 columns

One row per transaction input, referencing the output it spends, with address, script type and value.

cardano/inputs<start_block>_<end_block>.parquetone file per block range
Browse columns Sample fileSample updated Sep 25, 2026

outputs

18 columns

One row per transaction output with address, script type, change heuristic and value.

cardano/outputs<start_block>_<end_block>.parquetone file per block range
Browse columns Sample fileSample updated Sep 25, 2026

mints

13 columns

One row per native asset minted or burned in a transaction, with the asset and the signed amount.

cardano/mints<start_block>_<end_block>.parquetone file per block range
Browse columns Sample fileSample updated Sep 25, 2026

Schema reference

copies a column name
97 columns
blocks17 columnsOne row per block: size, transaction count, fees, epoch, slot and slot leader.
ColumnTypeDescription
tx_dateUInt64Block date, UTC midnight (epoch ms)
tx_timeUInt64Block timestamp (epoch seconds)
blockchain_idInt64Internal chain id
blockUInt64Block height
hashStringBlock hash
sizeUInt64Size in bytes
txcountUInt64Transactions in the block
epochUInt64Cardano epoch
slotUInt64Absolute slot
slot_in_epochUInt64Slot within the epoch
feesUInt64Total fees in the block, lovelace
fees_decimalFloat64Total fees in the block, ADA
slot_leader_hashStringPool id (hash) of the slot leader
slot_leader_descriptionStringSlot leader label, e.g. Pool-<id>
op_certStringOperational certificate hash
vrf_keyStringVRF verification key
versionStringProtocol version
Sample file
transactions28 columnsOne row per transaction with input, output, fee and mined values in ADA, lovelace and USD.
ColumnTypeDescription
tx4
tx_dateUInt64Block date, UTC midnight (epoch ms)
tx_timeUInt64Block timestamp (epoch seconds)
tx_hashStringTransaction hash
tx_indexInt64Position of the transaction in the block
blockchain1
blockchain_idInt64Internal chain id
Other3
blockUInt64Block height
sizeUInt64Size in bytes
metadataStringTransaction metadata as JSON, empty when none
block1
block_hashStringBlock hash
input4
input_countInt64Number of inputs
input_value_decimalFloat64Total input value in ADA
input_valueUInt64Total input value in lovelace
input_value_in_usdFloat64Total input value in USD at block time
output4
output_countInt64Number of outputs
output_value_decimalFloat64Total output value in ADA
output_valueUInt64Total output value in lovelace
output_value_in_usdFloat64Total output value in USD at block time
withdrawal3
withdrawal_countInt64Reward withdrawals in the transaction
withdrawal_value_decimalFloat64Reward withdrawals in ADA
withdrawal_valueUInt64Reward withdrawals in lovelace
mint1
mint_countInt64Native assets minted or burned in the transaction
fee3
fee_value_decimalFloat64Fee in ADA
fee_valueUInt64Fee in lovelace
fee_value_in_usdFloat64Fee in USD at block time
deposit2
deposit_value_decimalFloat64Net deposits (registrations minus deregistrations) in ADA
deposit_valueInt64Net deposits in lovelace; negative when refunded
invalid2
invalid_beforeStringValidity interval start slot, empty when unset
invalid_hereafterStringValidity interval end slot, empty when unset
Sample file
inputs21 columnsOne row per transaction input, referencing the output it spends, with address, script type and value.
ColumnTypeDescription
tx3
tx_dateUInt64Block date, UTC midnight (epoch ms)
tx_timeUInt64Block timestamp (epoch seconds)
tx_hashStringTransaction hash
blockchain1
blockchain_idInt64Internal chain id
Other3
blockUInt64Block height
sourceStringinput, withdrawal or stake_deregistration
valueUInt64Raw amount: lovelace for ADA, asset units for native assets
transaction1
transaction_indexInt64Position of the transaction in the block
input2
input_indexInt64Index of the input in the transaction
input_addressStringPayment address spending the input
token1
token_indexInt32-1 for the ADA row; 0 and up for each native asset carried by the same input or output
stake1
stake_keyStringStake address of the payment address, when delegated
output3
output_blockUInt64Height of the block that created the spent output
output_tx_hashStringHash of the transaction that created the spent output
output_indexInt64Index of the output in the transaction
currency4
currency_idInt64Internal currency id
currency_symbolStringADA, or the native asset ticker when known, otherwise the asset name hex
currency_nameStringCardano, or the native asset name
currency_decimalsInt64Decimals used for value_decimal (6 for ADA, usually 0 for native assets)
value2
value_decimalFloat64Amount divided by currency_decimals
value_in_usdFloat64Value in USD at block time; null when no price is known
Sample file
outputs18 columnsOne row per transaction output with address, script type, change heuristic and value.
ColumnTypeDescription
tx_dateUInt64Block date, UTC midnight (epoch ms)
tx_timeUInt64Block timestamp (epoch seconds)
blockchain_idInt64Internal chain id
blockUInt64Block height
tx_hashStringTransaction hash
transaction_indexInt64Position of the transaction in the block
output_indexInt64Index of the output in the transaction
token_indexInt32-1 for the ADA row; 0 and up for each native asset carried by the same input or output
output_addressStringPayment address receiving the output
stake_keyStringStake address of the payment address, when delegated
directionStringChange heuristic: change, not_change, likely_change, likely_not_change, mining, fee, minting, genesis, stake_registration, deposit, unknown
currency_idInt64Internal currency id
currency_symbolStringADA, or the native asset ticker when known, otherwise the asset name hex
currency_nameStringCardano, or the native asset name
currency_decimalsInt64Decimals used for value_decimal (6 for ADA, usually 0 for native assets)
valueUInt64Raw amount: lovelace for ADA, asset units for native assets
value_decimalFloat64Amount divided by currency_decimals
value_in_usdFloat64Value in USD at block time; null when no price is known
Sample file
mints13 columnsOne row per native asset minted or burned in a transaction, with the asset and the signed amount.
ColumnTypeDescription
tx_dateUInt64Block date, UTC midnight (epoch ms)
tx_timeUInt64Block timestamp (epoch seconds)
blockchain_idInt64Internal chain id
blockUInt64Block height
tx_hashStringTransaction hash
transaction_indexInt64Position of the transaction in the block
token_indexInt32-1 for the ADA row; 0 and up for each native asset carried by the same input or output
currency_idInt64Internal currency id
currency_symbolStringADA, or the native asset ticker when known, otherwise the asset name hex
currency_nameStringCardano, or the native asset name
currency_decimalsInt64Decimals used for value_decimal (6 for ADA, usually 0 for native assets)
valueUInt64Raw amount: lovelace for ADA, asset units for native assets
value_decimalFloat64Amount divided by currency_decimals
Sample file

Ask an AI about this data

Send this dataset’s full schema to an assistant and ask it anything. It reads the plain-text brief first, so the answer comes from the real column list rather than a guess.

Start with

Opens a new chat with the question filled in. Nothing about you is sent to Bitquery, and the assistant sees only the public brief.

Delivery

Parquet files, delivered as signed download links by email after payment, in this layout:

# blocks: one file per block range
cardano/blocks<start_block>_<end_block>.parquet

# transactions: one file per block range
cardano/transactions<start_block>_<end_block>.parquet

# inputs: one file per block range
cardano/inputs<start_block>_<end_block>.parquet

# outputs: one file per block range
cardano/outputs<start_block>_<end_block>.parquet

# mints: one file per block range
cardano/mints<start_block>_<end_block>.parquet
  1. Download a free sampleNo email needed.
  2. Pay nowName, work email and licence check.
  3. Pay the invoiceBy card or bank transfer.
  4. Get signed linksThe team prepares the export and emails the links.

Price

Full history
Genesis → Sep 24, 2026
$12,000one-time, USD
  • All 5 tables, 97 columns
  • Parquet files in the layout under Delivery
  • Signed download links by email
  • Licensed under the Data License
Pay now

FAQ

7 questions
What is included in Cardano?

Five Parquet tables: blocks, transactions, inputs, outputs and mints, covering full history from the Byron genesis to yesterday. Every input and output carries its payment address, stake key, currency and value; native assets are separate rows keyed by token_index.

Are native tokens and NFTs included?

Yes. An output that carries ADA and two native assets is three rows: token_index -1 for ADA and 0 and 1 for the assets, each with its currency id, symbol, name, decimals and raw amount. The mints table lists every asset minted or burned, with negative amounts for burns.

How is the data delivered?

As flat Parquet files under a stable S3 layout, one prefix per table, files named by block range. Signed HTTPS links are emailed once the files are prepared.

How do I trace where coins went?

Join inputs.output_tx_hash to outputs.tx_hash and inputs.output_index to outputs.output_index. Each input names the output it spends, so a spend chain is a repeated self-join rather than a node replay.

How do I load it?

One DuckDB line reads a whole table: SELECT * FROM read_parquet('outputs/*.parquet'). Values come in ADA, the smallest unit and USD at block time, so no decimal adjustment is needed.

How current is the data?

A purchase covers full history from the genesis block to the day before the files are cut. Files are cut by block range, so any window can be assembled exactly.

Can I try before I buy?

Yes. Every table links to a public sample Parquet file with real records from one day, and the sample repository shows the first rows of each in the browser.