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 paid to the miner in litoshi (1/100,000,000 LTC), excluding transaction fees. Currently 6.25 LTC (625,000,000 litoshi) per block based on Litecoin’s halving schedule.
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 in the block excluding the coinbase block subsidy, denominated in litoshis (1 LTC = 100,000,000 litoshis). Represents the economic activity transacted within the block.
total_sizeINT64Total size in bytes of all transactions included in this block. Represents the physical block size excluding witness data for SegWit transactions.
total_weightINT64Total weight units consumed by all transactions in the block, including witness data under SegWit accounting rules. Weight units account for the 4:1 discount applied to witness data versus base transaction data.
avg_feeINT64Average transaction fee in litoshis (smallest Litecoin unit) across all transactions in the block, excluding the coinbase transaction. Calculated by dividing total fees by transaction count, typically ranges from hundreds to thousands of litoshis.
avg_fee_rateINT64Average fee rate across all transactions in the block, measured in litoshis per virtual byte (sat/vB). Typically ranges from 1-10 sat/vB under normal network conditions.
avg_transaction_sizeINT64Average byte size of transactions included in the block, excluding the coinbase transaction. Typically ranges from 200-400 bytes for standard transfers, with larger values indicating complex multi-input/output transactions.
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 litoshis per virtual byte. Useful for identifying peak network demand and priority transactions within the block.
max_transaction_sizeINT64Maximum size in bytes of the largest transaction included in this block. Useful for identifying blocks containing unusually large or complex transactions.
median_feeINT64Median transaction fee across all transactions in the block, denominated in litoshis (the smallest unit of Litecoin, 10^-8 LTC). This represents the middle value when fees are sorted, useful for understanding typical fee levels while filtering outliers.
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, excluding the coinbase transaction. Provides a central tendency measure less affected by outliers than average transaction size.
min_feeINT64Lowest transaction fee paid in this block, denominated in litoshis (satoshis on Litecoin). Zero when the coinbase transaction is included in aggregate statistics.
min_fee_rateINT64Minimum fee rate paid per virtual byte (vbyte) across all transactions in the block, denominated in litoshis. Excludes the coinbase transaction which has a fee rate of zero.
min_transaction_sizeINT64Smallest transaction size in bytes within the block, typically 97 bytes for coinbase transactions. Useful for identifying block composition and detecting minimum-sized transactions.
segwit_total_sizeINT64Total byte size of all SegWit (Segregated Witness) transactions in the block, excluding witness data. This is always less than or equal to total_size since it only counts SegWit-enabled transactions.
segwit_total_weightINT64Total weight units consumed by SegWit transactions in this block, used for calculating block capacity under the SegWit protocol. Weight units replace raw bytes for blocks post-activation, with non-witness data weighted 4x and witness data 1x.
segwit_transaction_countINT64Count of transactions in the block that use Segregated Witness (SegWit) formatting. Represents adoption of the SegWit upgrade which separates signature data to reduce transaction size and enable Layer 2 scaling.
utxo_increaseINT64Net change in the number of unspent transaction outputs (UTXOs) created by this block, calculated as total outputs minus total inputs. Can be negative when transactions consolidate more UTXOs than they create.
utxo_size_increaseINT64Net change in bytes consumed by the UTXO set after processing this block. Negative values indicate the block consolidated more outputs than it created, reducing blockchain state size.
feerate_percentilesARRAY<INT64>Array of five fee rate percentiles (10th, 25th, 50th, 75th, 90th) across all transactions in the block, measured in litoshis per virtual byte. Useful for analyzing fee distribution and identifying typical transaction costs at different priority levels.
insINT64Total number of transaction inputs consumed across all transactions in this block. This count includes the coinbase transaction’s single input that claims the block reward and fees.
outsINT64Total number of transaction outputs across all transactions in this block. Represents the sum of all recipient addresses and change addresses created by transactions in the block.
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
929301935826662402025-12-12T05:30:52.000Z2134373265770261265117cbc002196d7f1ee8f08415f4d20901b7b38efe1b2c495d4f5b7e90b4cb9518821841765516491130642962500000020189691468[1,1,1,1,3]5289273780972226
53348301966136213905402025-12-12T19:40:14.000Z7605838662347926032d1f466c3ac716ffabda06b317052510bf526f36b6da6873376785f9629fb43504238142417655679401100174019625000000-4857201722-35070[1,1,1,2,2]1364033877407369722317
4103019714353113002025-12-12T21:35:38.000Z14153772247458746803ddacefd91429fae74cd20ffbb33f7374f81ac1076e2b44408429ff6314f7b81427691765573881250241062500000064475455[0,1,1,5,5]1134192225972232
Query with partition filter
SELECT *
FROM `tt-blockchain.litecoin.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.
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, used for fee calculation in SegWit transactions. Typically slightly smaller than the raw transaction size due to witness data discounting.
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<txid STRING, ismweb BOOL, vout INT64, scriptSig STRUCT<hex BYTES, asm STRING>, sequence INT64, coinbase STRING, txinwitness ARRAY<STRING>>>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 FLOAT64, n INT64, scriptPubKey STRUCT<addresses ARRAY<STRING>, hex BYTES, type STRING, reqSigs INT64, asm STRING, address STRING>, ismweb BOOL>>Array of transaction outputs specifying amounts and destination addresses. JSON-encoded structures containing output indices, values, and locking scripts that define spending conditions.
sizetxidvsizeinputsweightoutputsblock_hashis_coinbaseblock_heightblock_timestamp
97c900d070f80979b7400c51d80ea3703dfc71eec0030fe36d8f2a3b345a2d82dc94[{“txid”:“649c2c04b45e6d536b159e2a240fd53256cf14b9ac4f60ea76081f10b8670fbb”,“vout”:0,“ismweb”:false,“coinbase”:null,“sequence”:4294967295,“scriptSig”:{“asm”:"",“hex”:{“data”:[],“type”:“Buffer”}},“txinwitness”:[]}]376[{“n”:0,“value”:365997.72143428,“ismweb”:false,“scriptPubKey”:{“asm”:“8 49813f14bd37b8bcae0ea9284c1864ee96e52899d5a724d0fca8031b8454e058”,“hex”:{“data”:[53,56,50,48,52,57,56,49,51,102,49,52,98,100,51,55,98,56,98,99,97,101,48,101,97,57,50,56,52,99,49,56,54,52,101,101,57,54,101,53,50,56,57,57,100,53,97,55,50,52,100,48,102,99,97,56,48,51,49,98,56,52,53,52,101,48,53,56],“type”:“Buffer”},“type”:“witness_mweb_hogaddr”,“address”:null,“reqSigs”:null,“addresses”:[]}}]00de1492d6ad4b885bc87e9b833f567d2177722c154dba6a320101402be687c3false30194722025-12-12T10:38:31.000Z
97a197ce86425aa2e84f453bc01bcd08cf7c882806a7baab5718d64587095f3c7c94[{“txid”:“22f4b867d8f18b739e501321df6663cf06f90c4396f283ea6ad8d5869b53cb19”,“vout”:0,“ismweb”:false,“coinbase”:null,“sequence”:4294967295,“scriptSig”:{“asm”:"",“hex”:{“data”:[],“type”:“Buffer”}},“txinwitness”:[]}]376[{“n”:0,“value”:366016.25424126,“ismweb”:false,“scriptPubKey”:{“asm”:“8 d3e68762a8111def1f848166ee113b6369756015baa29c1e3ba3990ef3b8c3ff”,“hex”:{“data”:[53,56,50,48,100,51,101,54,56,55,54,50,97,56,49,49,49,100,101,102,49,102,56,52,56,49,54,54,101,101,49,49,51,98,54,51,54,57,55,53,54,48,49,53,98,97,97,50,57,99,49,101,51,98,97,51,57,57,48,101,102,51,98,56,99,51,102,102],“type”:“Buffer”},“type”:“witness_mweb_hogaddr”,“address”:null,“reqSigs”:null,“addresses”:[]}}]013406702ced6be058bfd85f553b2cfde74e3d2d4a20e9b520dfdc645c952005false30194212025-12-12T08:21:27.000Z
974c88a984901c81fbe307174cbbadeec99b70b662a675789acfbf28f1639d35d194[{“txid”:“78a82c87c234462d96c8375fdd36b85dafeeae06a406d1a4c340945893f37518”,“vout”:0,“ismweb”:false,“coinbase”:null,“sequence”:4294967295,“scriptSig”:{“asm”:"",“hex”:{“data”:[],“type”:“Buffer”}},“txinwitness”:[]}]376[{“n”:0,“value”:366077.38594387,“ismweb”:false,“scriptPubKey”:{“asm”:“8 3ce433d8e5cac94890f2a473c16761c3176ee2c4b6f0835f066628fc4df94937”,“hex”:{“data”:[53,56,50,48,51,99,101,52,51,51,100,56,101,53,99,97,99,57,52,56,57,48,102,50,97,52,55,51,99,49,54,55,54,49,99,51,49,55,54,101,101,50,99,52,98,54,102,48,56,51,53,102,48,54,54,54,50,56,102,99,52,100,102,57,52,57,51,55],“type”:“Buffer”},“type”:“witness_mweb_hogaddr”,“address”:null,“reqSigs”:null,“addresses”:[]}}]01554a401caa727f8e8b8dd16f8ae122ae52646c350140e9e6cafa590482a9e9false30192822025-12-12T01:34:05.000Z
Query with partition filter
SELECT *
FROM `tt-blockchain.litecoin.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100