ZcashBlocksTransactionsTransfersUTXO

Zcash

Name: Zcash
Creator: Bitquery
License: https://bitquery.io/datastore/legal/data-license

The full Zcash ledger since October 2016: blocks, transactions with shielded counts, and transparent inputs and outputs with ZEC and USD values.

By Bitquery Research · Updated Sep 25, 2026

Coverage: Full historyto Sep 24, 2026 · yesterday
Tables: 4Parquet, one prefix each
Columns: 76across 4 tables

Coverage ends yesterday, UTC

Overview

Every Zcash block and transaction from the genesis block in October 2016 to yesterday, with the transparent inputs and outputs of each transaction decoded to address, script type and value in ZEC, zatoshi and USD at block time.

Shielded transfers (Sprout, Sapling and Orchard) hide their amounts and addresses on chain, so they have no input or output rows. Each transaction row counts its shielded spends, shielded outputs and JoinSplits and carries the net value that moved between the transparent and shielded pools, so pool flows are a sum over transactions. Files are cut by block range and named by their first and last block.

Use cases

Transparent UTXO graph analysis and address clustering
Shielded pool inflow and outflow measurement from transaction balances
Fee market and block-space research
Fund-flow tracing across transparent transactions

4 tables

76 columns · free sample for each table

blocks

12 columns

One row per block: size, difficulty, chainwork and transaction count.

zcash/blocks<start_block>_<end_block>.parquetone file per block range

Browse columns Sample fileSample updated Sep 25, 2026

transactions

29 columns

One row per transaction with input, output, fee and mined values in ZEC, zatoshi and USD.

zcash/transactions<start_block>_<end_block>.parquetone file per block range

Browse columns Sample fileSample updated Sep 25, 2026

inputs

17 columns

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

zcash/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.

zcash/outputs<start_block>_<end_block>.parquetone file per block range

Browse columns Sample fileSample updated Sep 25, 2026

Schema reference

copies a column name

Search all columns76 columns

blocks12 columnsOne row per block: size, difficulty, chainwork and transaction count.

ColumnTypeDescription

tx_dateUInt64Block date, UTC midnight (epoch ms)

tx_timeUInt64Block timestamp (epoch seconds)

blockchain_idInt64Internal chain id

blockUInt64Block height

nonceUInt64Block nonce

difficultyFloat64Mining difficulty

hashStringBlock hash

strippedsizeUInt64Block size without witness data, bytes

sizeUInt64Size in bytes

versionUInt64Version field

txcountUInt64Transactions in the block

chainworkStringCumulative chain work, hex

Sample file

transactions29 columnsOne row per transaction with input, output, fee and mined values in ZEC, zatoshi 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

Other4

blockUInt64Block height

locktimeUInt64Transaction locktime

versionInt64Version field

expiryheightUInt64Block height after which the transaction expires; 0 for none

is2

is_coinbaseInt641 for the coinbase transaction

is_overwinteredInt641 if the transaction uses the Overwinter format

input4

input_countInt64Number of inputs

input_value_decimalFloat64Total input value in ZEC

input_valueInt64Total input value in zatoshi

input_value_in_usdFloat64Total input value in USD at block time

output4

output_countInt64Number of outputs

output_value_decimalFloat64Total output value in ZEC

output_valueInt64Total output value in zatoshi

output_value_in_usdFloat64Total output value in USD at block time

fee3

fee_value_decimalFloat64Fee in ZEC

fee_valueInt64Fee in zatoshi

fee_value_in_usdFloat64Fee in USD at block time

mined2

mined_value_decimalFloat64Newly mined ZEC (coinbase only)

mined_valueInt64Newly mined zatoshi (coinbase only)

shielded4

shielded_spent_countInt64Shielded spends (Sapling and Orchard) in the transaction

shielded_output_countInt64Shielded outputs in the transaction

shielded_balance_decimalFloat64Net value moving between the transparent and shielded pools, in ZEC

shielded_balanceInt64Net value moving between the transparent and shielded pools, in zatoshi

joinsplit1

joinsplit_countInt64Sprout JoinSplit descriptions in the transaction

Sample file

inputs17 columnsOne row per transaction input, referencing the output it spends, with address, script type 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

input_indexInt64Index of the input in the transaction

output_tx_hashStringHash of the transaction that created the spent output; empty for coinbase

output_indexInt64Index of the output in the transaction

input_addressStringAddress spending the input; empty for coinbase

input_address_annotationNullable(String)Entity label for the address, when known

input_scriptStringInput script: hex witness or scriptSig

input_script_typeStringInput script type, e.g. txinwitness, scriptSig, coinbase

script_templateInt64Script template id

value_decimalFloat64Value in ZEC; a coinbase input carries the newly mined amount

value_in_usdFloat64Value in USD at block time

valueInt64Value in zatoshi; a coinbase input carries the newly mined amount

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

dateStringBlock date, YYYY-MM-DD

tx_hashStringTransaction hash

transaction_indexInt64Position of the transaction in the block

output_indexInt64Index of the output in the transaction

output_addressStringAddress receiving the output

output_address_annotationNullable(String)Entity label for the address, when known

directionStringChange heuristic: change, not_change, likely_change, likely_not_change, mining, fee, unknown

output_scriptStringOutput script as opcodes and hex

script_typeStringOutput script type, e.g. pubkeyhash, scripthash, witness_v0_keyhash, nulldata

script_templateInt64Script template id

req_sigsInt64Signatures required to spend

value_decimalFloat64Value in ZEC; a coinbase input carries the newly mined amount

value_in_usdFloat64Value in USD at block time

valueInt64Value in zatoshi; a coinbase input carries the newly mined amount

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 withCan it answer my question?Explain the schemaWrite me a queryHow is it different from the API?

Ask Claude Ask ChatGPT

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
zcash/blocks<start_block>_<end_block>.parquet

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

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

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

Download a free sampleNo email needed.
Pay nowName, work email and licence check.
Pay the invoiceBy card or bank transfer.
Get signed linksThe team prepares the export and emails the links.

Price

Full history

Genesis → Sep 24, 2026

$8,000one-time, USD

All 4 tables, 76 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 Zcash?

Four Parquet tables: blocks, transactions, inputs and outputs, covering full history from the genesis block to yesterday. Inputs and outputs are the transparent ones; every row carries its address, script type and value in ZEC, zatoshi and USD.

Are shielded transactions included?

Every transaction is listed in the transactions table, including fully shielded ones, with its shielded spend, shielded output and JoinSplit counts and its shielded balance. Their shielded amounts and addresses are not on chain, so they have no rows in inputs or outputs.

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 ZEC, 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.