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: