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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, microsecond precision. |
block_height | INT64 | Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
event_type | STRING | Processing 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_index | INT64 | Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block. |
event_index | INT64 | Sequential position of the event within its containing block. Zero-indexed integer indicating the order in which events occurred during block processing. |
event_attributes | JSON | Structured data containing key-value pairs associated with the blockchain event. JSON object storing event-specific parameters such as amounts, addresses, validators, and transaction identifiers. |
Sample Data
Sample Data
| event_type | event_index | block_height | block_timestamp | event_attributes | transaction_hash | transaction_index |
|---|---|---|---|---|---|---|
| tx | 1 | 127057614 | 2025-01-19T11:11:51.852Z | {“YWNjX3NlcQ==”:“c2VpMTVwdjhybW10YzIzYXR1OXp1c2ZxZHBjNTh6NHk2anJ0Z3B0cWZkLzUyNTA2MzY4”} | 3917D40ACB65D5B9A202ED4CD7F330BDD1EA8A6486CBF036A1EA03895E98E880 | 4 |
| tx | 2 | 127008463 | 2025-01-19T04:12:56.317Z | {“c2lnbmF0dXJl”:“MVhRLzM1bVJ0c2xIMnVSVTBDM0ZXOE8yK016MDhpcDkzSmgzT1YzQ29DbFIyQzVDVjVtSXdzbzBpU2pRSFM3OWJEV0pBbFNTNkcxK05RdDN4bzNSaFE9PQ==“} | 051A71C58CEF2C8BBA9D439222D8AEC61F7F41C3184FB5F195C21BB23046A4A4 | 4 |
| tx | 2 | 127041097 | 2025-01-19T08:50:27.554Z | {“c2lnbmF0dXJl”:“K2hrdWFLMVBnZzViNXhFdERUSjEyYUdNMGlQMlQwamxtamlTTjhPYXZqUEhzdU1xVWV5UlhTa2F4SjVndzcyaHRSalVadyt2TDJHOWFpUUkySDJGaEE9PQ==“} | 33D6C3ED681AADEB82FAE5DA673F59D9EFD9BD64CD24E547DC5CD132380C56CE | 4 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-blockchain.sei_cosmos.message_events`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100