Skip to main content

​
Tables

​
block_events

Block-level events emitted during blockchain processing phases such as BeginBlock, EndBlock, and transaction execution. Contains event type identifiers, sequential indexes, structured attribute data, and block metadata for tracking state changes, validator operations, and protocol-level activities.
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.
event_typeSTRINGProcessing phase within the blockchain’s block lifecycle. Values include ‘initialize’ for events occurring during block initialization, ‘finalize’ for events during block finalization, and chain-specific event type identifiers for transaction-related events.
event_indexINT64Sequential position of the event within its containing block. Zero-indexed integer indicating the order in which events occurred during block processing.
event_attributesJSONStructured data containing key-value pairs associated with the blockchain event. JSON object storing event-specific parameters such as amounts, addresses, validators, and transaction identifiers.
sourceSTRINGOriginating address or processing mode of the blockchain event or message. Format varies by chain: Cosmos-based chains use “BeginBlock” or “EndBlock” for block lifecycle events, TON uses raw or user-friendly address strings, Celestia stores recipient addresses for coin events.
sourceevent_typeevent_indexblock_heightblock_timestampevent_attributes
end_slash_window1181185839992024-12-04T01:55:34.943Z{“YWJzdGFpbl9jb3VudA==”:“NjM=”,“b3BlcmF0b3I=”:“c2VpdmFsb3BlcjE0MGw2eTJncDNneHZheTZxdG43MHJlN3oyczBnbjU3emw2bnVwcw==”,“bWlzc19jb3VudA==”:“MQ==”,“c3VjY2Vzc19jb3VudA==”:“MTA3OTM2”}
end_slash_window1281185839992024-12-04T01:55:34.943Z{“YWJzdGFpbl9jb3VudA==”:“MTU3Ng==”,“b3BlcmF0b3I=”:“c2VpdmFsb3BlcjFtbTVwNmFrMnc5NGN3cnkwbjQycHgzc3Nhamd5dHhud2Z2ZDR3OA==”,“bWlzc19jb3VudA==”:“Mw==”,“c3VjY2Vzc19jb3VudA==”:“MTA2NDIx”}
new_epoch01186064842024-12-04T05:08:48.455Z{“ZXBvY2hfaGVpZ2h0”:“MTE4NjA2NDg0”,“ZXBvY2hfbnVtYmVy”:“ODA1NjY1”,“ZXBvY2hfdGltZQ==”:“MjAyNC0xMi0wNCAwNTowODo0OC40NTU2ODc4NDEgKzAwMDAgVVRD”}
Query with partition filter
SELECT *
FROM `tt-blockchain.sei.block_events`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
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.
block_heightINT64Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
transaction_countINT64Number of transactions included in the block.
validators_hashSTRINGCryptographic hash of the validator set for the block. Hex-encoded 64-character string without 0x prefix.
proposer_addressSTRINGAddress of the validator that proposed the block. Hex-encoded string without 0x prefix, 40 characters in length.
timestampblock_heightvalidators_hashproposer_addresstransaction_count
2025-04-08T03:50:41.380Z1409241780A829844CFF5C300348E6402FAC937A23921C74C10BF9D56F153656AA13066EB114C0350B9CE023F98518D9F22A2E2E7548DAF660
2025-04-08T07:19:49.748Z140949910AEB98CCA81E8E2383A0891EA857F0FBE0019E7C22BC9EEEE46735D45847E0B6B114C0350B9CE023F98518D9F22A2E2E7548DAF660
2025-04-08T15:00:43.641Z14100770060F5819950BA7C01534274B9EE4529AF670101FFF4D12C3332788331A7F63D4D114C0350B9CE023F98518D9F22A2E2E7548DAF660
Query with partition filter
SELECT *
FROM `tt-blockchain.sei.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_heightINT64Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
transaction_infoSTRINGAdditional metadata or context information for the transaction. Empty string when no additional information is available.
transaction_logSTRINGExecution event log data from the transaction. JSON-encoded array containing message indexes, event types, and key-value attribute pairs documenting state changes and actions performed during transaction execution.
transaction_codeINT64Status code indicating the transaction execution result. 0 represents successful execution, non-zero values indicate various error conditions.
transaction_feeSTRINGTransaction fee paid for processing the transaction. Denominated in the network’s native token with smallest unit precision.
transaction_tipSTRINGOptional gratuity paid to validators for transaction prioritization. Denominated in the network’s native token with smallest unit precision.
gas_wantedSTRINGMaximum gas units allocated for the transaction execution. String-encoded integer representing the computational resource limit set by the transaction submitter.
gas_usedSTRINGAmount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
gas_usedgas_wantedblock_heightblock_timestamptransaction_feetransaction_logtransaction_tiptransaction_codetransaction_hashtransaction_infotransaction_index
1290497952025-01-31T04:46:09.898Z0usei[{“events”:[{“type”:“aggregate_vote”,“attributes”:[{“key”:“voter”,“value”:“seivaloper1zv9z2wqt348dhxqn38xv8dvsu78cle4xs2cdf4”},{“key”:“exchange_rates”,“value”:“6.142293245996515982uatom,104280.431766568284235591ubtc,3225.060526484021068448ueth,0.391204446471739262uosmo,0.327299838231115220usei,0.999989460947671258uusdc,0.999984245555624176uusdt”}]},{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote”},{“key”:“module”,“value”:“oracle”},{“key”:“sender”,“value”:“sei1tmxrwgmdplqzq5kvq06778pwue06qzuynfc32e”}]}]}]9FD1F588563B80FF06522203F5C83CD1DB753C3A8B628623508D1E9F5B520C1B0
1290731532025-01-31T08:04:27.286Z0usei[{“events”:[{“type”:“aggregate_vote”,“attributes”:[{“key”:“voter”,“value”:“seivaloper1t9fq3qfm7ngau5gr8qgf5dpfzjqg79kf65cu04”},{“key”:“exchange_rates”,“value”:“6.247030437632858182uatom,104225.706073058395309906ubtc,3240.717535340121261094ueth,0.397910212926649246uosmo,0.337796933355332971usei,0.999972300321251277uusdc,0.999964801262306649uusdt”}]},{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote”},{“key”:“module”,“value”:“oracle”},{“key”:“sender”,“value”:“sei14n9fhykwk8rk7zln7rzd6uyhm2gzntuw2pv0e9”}]}]}]CF5F241F25BE117C954A08662E3B55CCE71322C031C669275B04AD9CE68CE9180
1291329252025-01-31T16:28:11.132Z0usei[{“events”:[{“type”:“aggregate_vote”,“attributes”:[{“key”:“voter”,“value”:“seivaloper1xm0pjt3qsdlc6u4n7fjpycqd5h7zwla7tz8m37”},{“key”:“exchange_rates”,“value”:“6.390947148982693462uatom,104945.421458309076023852ubtc,3404.750735693849940367ueth,0.414911459001258543uosmo,0.345559643277993016usei,0.999949380363265263uusdc,1.000136511179925676uusdt”}]},{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“/seiprotocol.seichain.oracle.MsgAggregateExchangeRateVote”},{“key”:“module”,“value”:“oracle”},{“key”:“sender”,“value”:“sei15pv8rmmtc23atu9zusfqdpc58z4y6jrtgptqfd”}]}]}]BD52EEE16EA424B1C375C890B3B7FE1420DC0161B7B35169DA2FD465A85F27D80
Query with partition filter
SELECT *
FROM `tt-blockchain.sei.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100