Skip to main content
The raw data schema includes blocks, transactions, transactions input, and transaction output of Bitcoin data.
Anatomy of Bitcoin UTXO. Image Source: Liu, Y., Zhang, L. & Zhao, Y. To select for all inputs and outputs a user is involved in, you can use the following query for inputs 
select spent_utxo_id, transaction_hash from bitcoin.raw.inputs where address0 = 'bc1...'
and the following query for outputs: 
select utxo_id, transaction_hash from bitcoin.raw.ouptuts where address0 = 'bc1...'
and union the two results if you want both
RawDescription
blocksBlocks data, including block size, difficulty and confirmations.
transactionsTransactions level data.
inputsInput data of Bitcoin transactions.
outputsOutput data of Bitcoin transactions.