Overview

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

Raw	Description
blocks	Blocks data, including block size, difficulty and confirmations.
transactions	Transactions level data.
inputs	Input data of Bitcoin transactions.
outputs	Output data of Bitcoin transactions.

Overview Blocks

⌘I

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Overview