Skip to main content
The raw data schema includes blocks, transactions, transaction input, and transaction output of Bitcoin data.

Anatomy of Bitcoin UTXO. Image Source: Liu, Y., Zhang, L. & Zhao, Y.

Anatomy of Bitcoin UTXO. Image Source: Liu, Y., Zhang, L. & Zhao, Y. Our realtime Bitcoin raw schema contains the following tables:
Raw Data TypeDescription
blocksBlocks data, including block size, difficulty, and confirmations.
transactionsTransaction level data.
inputsInput data of Bitcoin transactions.
outputsOutput data of Bitcoin transactions.

​
Common Query Patterns

To retrieve the inputs of a certain transaction, you can use the following queries: 
select * from bitcoin.enriched_inputs where transaction_hash = '82794a9ee221453c8da04ea1f876a379cc70512edcd8b3dbc2349c84c4265ce0';

select * from bitcoin.outputs where transaction_hash = '82794a9ee221453c8da04ea1f876a379cc70512edcd8b3dbc2349c84c4265ce0';
To retrieve the inputs and outputs of a user, you can use the following queries: 
select * from bitcoin.enriched_inputs where address0 = 'bc1qcr393nj4ps806qjarqnrd68yl9pl2klqc5c225' limit 10;

select * from bitcoin.outputs where address0 = 'bc1qcr393nj4ps806qjarqnrd68yl9pl2klqc5c225' limit 10;
Additional resources:
⌘I