Skip to main content

Tables

message_events

Events emitted during transaction message processing containing structured attribute data. Tracks state changes, transfers, and smart contract interactions across Cosmos SDK-based blockchains with event type classification and sequential ordering.
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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
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.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
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.
event_typeevent_indexblock_heightblock_timestampevent_attributestransaction_hashtransaction_index
tx11270576142025-01-19T11:11:51.852Z{“YWNjX3NlcQ==”:“c2VpMTVwdjhybW10YzIzYXR1OXp1c2ZxZHBjNTh6NHk2anJ0Z3B0cWZkLzUyNTA2MzY4”}3917D40ACB65D5B9A202ED4CD7F330BDD1EA8A6486CBF036A1EA03895E98E8804
tx21270084632025-01-19T04:12:56.317Z{“c2lnbmF0dXJl”:“MVhRLzM1bVJ0c2xIMnVSVTBDM0ZXOE8yK016MDhpcDkzSmgzT1YzQ29DbFIyQzVDVjVtSXdzbzBpU2pRSFM3OWJEV0pBbFNTNkcxK05RdDN4bzNSaFE9PQ==“}051A71C58CEF2C8BBA9D439222D8AEC61F7F41C3184FB5F195C21BB23046A4A44
tx21270410972025-01-19T08:50:27.554Z{“c2lnbmF0dXJl”:“K2hrdWFLMVBnZzViNXhFdERUSjEyYUdNMGlQMlQwamxtamlTTjhPYXZqUEhzdU1xVWV5UlhTa2F4SjVndzcyaHRSalVadyt2TDJHOWFpUUkySDJGaEE9PQ==“}33D6C3ED681AADEB82FAE5DA673F59D9EFD9BD64CD24E547DC5CD132380C56CE4
Query with partition filter
SELECT *
FROM `tt-blockchain.sei_cosmos.message_events`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100