Comment on page
Bitcoin
Bitcoin data tables available in SQL 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;
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