Skip to main content

​
Tables

​
blocks

Block header data containing sequential numbering, cryptographic hashes linking to parent blocks, timestamps, and consensus metadata. Primary source for blockchain state verification and chain navigation.
ColumnTypeDescription
timestampTIMESTAMPTimestamp when the block was produced. UTC timezone.
heightINT64Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
block_subsidyINT64Block reward in satoshis (100 millionths of a BTC) issued to the miner for mining this block. This value halves approximately every 210,000 blocks and was 50 BTC (5,000,000,000 satoshis) in early blocks.
transaction_countINT64Number of transactions included in the block.
total_feeINT64Total sum of transaction fees collected in the block. Denominated in the smallest unit of the native token (satoshis for Bitcoin/Litecoin, lamports for Solana).
total_outINT64Total value of all outputs across all transactions in the block, denominated in satoshis (100 million satoshis = 1 BTC). Does not include the coinbase block subsidy, only outputs from non-coinbase transactions.
total_sizeINT64Total size in bytes of all transactions included in this block, excluding witness data. Zero for coinbase-only blocks as seen in early Bitcoin history.
total_weightINT64Total weight units consumed by all transactions in this block, used for block size calculation post-SegWit activation. Weight units account for witness data at a discounted rate compared to base transaction data.
avg_feeINT64Average transaction fee across all transactions in the block, denominated in satoshis. Zero for early Bitcoin blocks containing only coinbase transactions with no user-paid fees.
avg_fee_rateINT64Average transaction fee rate across all transactions in the block, measured in satoshis per virtual byte (sat/vB). Returns zero for blocks containing only coinbase transactions with no user-initiated transfers.
avg_transaction_sizeINT64Average transaction size in bytes across all transactions in the block. Calculated by dividing total_size by transaction_count, excluding coinbase-only blocks where this value is zero.
max_feeINT64Maximum transaction fee permitted for execution. Denominated in the smallest unit of the native token.
max_fee_rateINT64Maximum fee rate paid by any transaction in the block, measured in satoshis per virtual byte (sat/vB). Zero in early blocks containing only coinbase transactions with no fees.
max_transaction_sizeINT64Maximum transaction size in bytes among all transactions in the block, excluding the coinbase transaction. Zero in blocks containing only the coinbase transaction, as seen in early Bitcoin blocks.
median_feeINT64Median transaction fee across all transactions in the block, denominated in satoshis. Useful for understanding typical fee levels while avoiding skew from outlier transactions.
median_timeINT64Median timestamp of the previous 11 blocks. Unix timestamp in seconds since epoch (January 1, 1970).
median_transaction_sizeINT64Median size in bytes of all transactions included in this block. Returns 0 for blocks containing only the coinbase transaction with no user transactions.
min_feeINT64Minimum transaction fee paid in this block, measured in satoshis. Zero values indicate blocks containing only the coinbase transaction with no user-initiated transfers.
min_fee_rateINT64Minimum fee rate paid by any transaction in the block, measured in satoshis per virtual byte (sat/vB). Zero in early blocks containing only coinbase transactions with no user-paid fees.
min_transaction_sizeINT64Smallest transaction size in bytes among all transactions included in the block, excluding the coinbase transaction. Zero in early blocks that contained only coinbase transactions.
segwit_total_sizeINT64Total size in bytes of all SegWit transactions included in this block. Returns 0 for blocks before SegWit activation or blocks containing only non-SegWit transactions.
segwit_total_weightINT64Total weight units of all SegWit transactions in this block, where weight = (non-witness size × 3) + total size. Zero for blocks before SegWit activation in August 2017.
segwit_transaction_countINT64Number of transactions in the block that use Segregated Witness (SegWit) format. Zero for pre-SegWit blocks (before August 2017 activation) as shown in historical samples.
utxo_increaseINT64Net change in the number of unspent transaction outputs (UTXOs) created by this block. Calculated as the difference between new outputs created and inputs consumed, always positive for coinbase-only blocks.
utxo_size_increaseINT64Net change in total byte size of the UTXO set after this block is processed. Represents the difference between new outputs created and outputs consumed, measured in bytes.
feerate_percentilesARRAY<INT64>Array of fee rates in satoshis per byte at the 10th, 25th, 50th, 75th, and 90th percentiles for transactions included in the block. Represents distribution of fee rates paid across all transactions in the block.
insINT64Number of transaction inputs consumed across all transactions in this block. Excludes coinbase transaction inputs which are always zero for block reward transactions.
outsINT64Number of transaction outputs created across all transactions in this block. Includes both spent outputs and new unspent transaction outputs (UTXOs).
insoutsheightavg_feemax_feemin_feetimestamptotal_feetotal_outblock_hashmedian_feetotal_sizemedian_timeavg_fee_ratemax_fee_ratemin_fee_ratetotal_weightblock_subsidyutxo_increasesegwit_total_sizetransaction_countutxo_size_increasefeerate_percentilessegwit_total_weightavg_transaction_sizemax_transaction_sizemin_transaction_sizemedian_transaction_sizesegwit_transaction_count
01236710002009-09-26T05:12:59.000Z0000000000cb75a6abd2598cd8969ea867ab0007774c9b578eb41ba375adab05c200125393784800005000000000101117[0,0,0,0,0]000000
01236860002009-09-26T09:10:49.000Z000000000050b158d31fa2ad28efd65066c0601ca7d40cfe1658074320999941d400125395257400005000000000101117[0,0,0,0,0]000000
01236960002009-09-26T12:00:03.000Z00000000008ad771d0bdc5f90ce1679a1499a9ae017a9930e712f6849552a56af800125396283100005000000000101117[0,0,0,0,0]000000
Query with partition filter
SELECT *
FROM `tt-blockchain.bitcoin.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
transactions

Transaction records containing signed operations that modify blockchain state. Primary source for tracking value transfers, contract interactions, and account state changes across the network.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
block_heightINT64Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
txidSTRINGUnique identifier for the transaction. 64-character hex string without 0x prefix.
feeNUMERICTransaction fee paid to validators or network operators. Denominated in the blockchain’s native currency unit (microAlgos for Algorand, satoshis for Bitcoin, lamports for Solana, smallest divisible unit for other chains).
is_coinbaseBOOLBoolean flag indicating whether the transaction is a coinbase transaction that creates new coins as a block reward. True for the first transaction in each block that rewards the miner.
sizeINT64Block size in bytes. Represents the total serialized size of the block data structure.
vsizeINT64Virtual size of the transaction in bytes, accounting for SegWit witness data discount. For pre-SegWit transactions, vsize equals the actual transaction size.
weightINT64Transaction weight used for fee calculation and block capacity limits. Measured in weight units, typically 4 times the virtual size for SegWit transactions on Bitcoin-based chains.
inputsARRAY<STRUCT<coinbase STRING, sequence INT64, txid STRING, vout INT64, txinwitness ARRAY<STRING>, scriptSig STRUCT<asm STRING, hex STRING>, prevout STRUCT<generated BOOL, height INT64, value BIGNUMERIC, scriptPubKey STRUCT<asm STRING, desc STRING, hex STRING, type STRING, address STRING, addresses ARRAY<STRING>, reqSigs INT64>>>>Array of transaction inputs referencing previous transaction outputs being spent. JSON-encoded structures containing transaction identifiers, output indices, unlock scripts, and witness data.
outputsARRAY<STRUCT<value BIGNUMERIC, n INT64, scriptPubKey STRUCT<asm STRING, desc STRING, hex STRING, type STRING, address STRING, addresses ARRAY<STRING>, reqSigs INT64>>>Array of transaction outputs specifying amounts and destination addresses. JSON-encoded structures containing output indices, values, and locking scripts that define spending conditions.
feesizetxidvsizeinputsweightoutputsblock_hashis_coinbaseblock_heightblock_timestamp
0157d1e04b9b218e7eabbf90e2e9c4d15c105551f6e2911eebb997d0ffa051e4e99a157[{“txid”:“b8f4c67cb19fce6c9f04f35145844ef8bbc5f0f7688cd0fa46e756bd16edc0d3”,“vout”:0,“prevout”:null,“coinbase”:null,“sequence”:4294967295,“scriptSig”:{“asm”:“304402205032b0f4d09ffdc47bf80f60aa67c7a5e3bc855a0c8d4b212fa30487fc4523ea02205ae7d5c13898db5386196fc80b8ba08a63ed2b1b3993fbdd7b050fe1bc8ad343[ALL]”,“hex”:“47304402205032b0f4d09ffdc47bf80f60aa67c7a5e3bc855a0c8d4b212fa30487fc4523ea02205ae7d5c13898db5386196fc80b8ba08a63ed2b1b3993fbdd7b050fe1bc8ad34301”},“txinwitness”:[]}]628[{“n”:0,“value”:“50”,“scriptPubKey”:{“asm”:“OP_DUP OP_HASH160 d7f4d81e39194a3d983d24817d5565dff9391239 OP_EQUALVERIFY OP_CHECKSIG”,“hex”:“76a914d7f4d81e39194a3d983d24817d5565dff939123988ac”,“desc”:“addr(1LgsbKRKTcw7gYohUwntSUh6rtEWShxSH8)#g75zn7mm”,“type”:“pubkeyhash”,“address”:“1LgsbKRKTcw7gYohUwntSUh6rtEWShxSH8”,“reqSigs”:null,“addresses”:[]}}]00000000000fa61a0c668c9eba1000a2a03a1f23e16ec004b1e0163561d8064afalse818982010-09-25T06:21:57.000Z
0157e015fcd09d610986d3f9fca152ac246390878ce1cd8760e28de14efc99afbf7c157[{“txid”:“c227849219b96b569c14122646c9b3a17765dffd754c877fd3f38cc7583ced53”,“vout”:0,“prevout”:null,“coinbase”:null,“sequence”:4294967295,“scriptSig”:{“asm”:“3044022011afa24d28942b6b753795b59f0067a0718031d904909772cca400dce08f2c8102206c61c3a9fe58745e371f65e7bbf2bf096aea37c9436ede47de0967d9864936e3[ALL]”,“hex”:“473044022011afa24d28942b6b753795b59f0067a0718031d904909772cca400dce08f2c8102206c61c3a9fe58745e371f65e7bbf2bf096aea37c9436ede47de0967d9864936e301”},“txinwitness”:[]}]628[{“n”:0,“value”:“50”,“scriptPubKey”:{“asm”:“OP_DUP OP_HASH160 7f170fe2d4da3ccbaf70c7fc9c17a7a1ddb1d16c OP_EQUALVERIFY OP_CHECKSIG”,“hex”:“76a9147f170fe2d4da3ccbaf70c7fc9c17a7a1ddb1d16c88ac”,“desc”:“addr(1CazSk3Xf9Dx6rdoPPX6WDCZi9nrP3TdL7)#zuyt9zmr”,“type”:“pubkeyhash”,“address”:“1CazSk3Xf9Dx6rdoPPX6WDCZi9nrP3TdL7”,“reqSigs”:null,“addresses”:[]}}]0000000000424588100cbf6f79d24ce3134735d061e40446a3e08199c1fa7fa0false820082010-09-25T19:29:08.000Z
01570cb7f447b0abb412a7c83cf9e8d3a4dc59947b0d9f3e202783fc33f9006bf509157[{“txid”:“4fd2fbdc03f5d546446c88f3936f66ba73f4b4113c5d0517ec255b01b75f29be”,“vout”:0,“prevout”:null,“coinbase”:null,“sequence”:4294967295,“scriptSig”:{“asm”:“304402206f4204e0d2278801804f9227c0ce7695045257a502fa5d36c93390187d03ac92022006b3bceae4b5b91a4b82024614c2935cab411f32765d2e53c5e1b7ce305b213c[ALL]”,“hex”:“47304402206f4204e0d2278801804f9227c0ce7695045257a502fa5d36c93390187d03ac92022006b3bceae4b5b91a4b82024614c2935cab411f32765d2e53c5e1b7ce305b213c01”},“txinwitness”:[]}]628[{“n”:0,“value”:“50”,“scriptPubKey”:{“asm”:“OP_DUP OP_HASH160 6ddea8071439951115469d0d2e2b80ecbcdd48db OP_EQUALVERIFY OP_CHECKSIG”,“hex”:“76a9146ddea8071439951115469d0d2e2b80ecbcdd48db88ac”,“desc”:“addr(1B1wPLyrJ831sg1D8hnZLBG7SejXbqMMrH)#gnl6trdv”,“type”:“pubkeyhash”,“address”:“1B1wPLyrJ831sg1D8hnZLBG7SejXbqMMrH”,“reqSigs”:null,“addresses”:[]}}]00000000003c70777a40b5194d8cb0abb42b065d8448b5ee182cad4a02c8d990false819282010-09-25T10:24:31.000Z
Query with partition filter
SELECT *
FROM `tt-blockchain.bitcoin.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100