Links
Comment on page

Bitcoin

Bitcoin data tables available in SQL query

Bitcoin base type tables available to query

Table Name
Description
Block headers
Block headers from the last 30 minutes, ~3 blocks
Block transactions
Block transactions from the last 30 minutes, ~3 blocks
All inputs to transactions
Inputs to transactions from the last 30 minutes, ~3 blocks
All outputs from transactions
Outputs from transactions from the last 30 minutes, ~3 blocks
The table list is also available as a SQL query using show tables. For example:
SHOW TABLES IN btc
The columns and their schema available for each table can be viewed with the describe <table> command. For example:
/* Show the columns available */
DESCRIBE btc.blocks;
DESCRIBE btc.transactions;
DESCRIBE btc.transaction_inputs;
DESCRIBE btc.transaction_outputs;

Improving query performance - indexed columns

Table Name
Indexed Columns
btc.blocks
number timestamp
btc.transactions
block_number block_timestamp
btc.transaction_inputs
block_number block_timestamp
btc.transaction_outputs
block_number block_timestamp
Last modified 4mo ago