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
BeginBlockcommission12105590102022-05-10T00:34:41.340Z{“amount”:“626449678723889.914681051917833893inj”,“mode”:“BeginBlock”,“validator”:“injvaloper1yqdrkyp37w46aant2u80v2rapuuz7eg3rl4arg”}
BeginBlockrewards25105592842022-05-10T00:46:43.385Z{“amount”:“10844213112969347.138289726134088509inj”,“mode”:“BeginBlock”,“validator”:“injvaloper1yqdrkyp37w46aant2u80v2rapuuz7eg3rl4arg”}
BeginBlockcommission16105599162022-05-10T01:14:29.287Z{“amount”:“1651829109718456.078426507293840080inj”,“mode”:“BeginBlock”,“validator”:“injvaloper1lsuqpgm8kgwpq96ewyew26xnfwyn3lh3ncrkrk”}
Query with partition filter
SELECT *
FROM `tt-blockchain.injective.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
2022-03-07T17:20:32.242Z8455316173062793CFB76AD9BB9112B50811B8B64A45D7D9ABAB32CE4CF3FDCB7BFFFDE25D1BD6EF4DC88B30A471082281E05951303606E0
2022-03-07T16:25:02.114Z8454007E72575BA9B0B71786B0E80400C6C5B926763F6C96BEB8CB70397FCC9C87BA8C79AAC0790FFF74F4050DBBBB55EBF59BF134C40380
2022-03-07T06:15:40.990Z8439591E43687A0D7A7460682EECF399AB1179EBF251BB885EA909D5A01160A93237B602F294679E3B781CE383ECF9AD010519019F0BC361
Query with partition filter
SELECT *
FROM `tt-blockchain.injective.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
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
injective.exchange.v1beta1.EventNewDerivativeOrders20450781332023-09-15T04:53:47.383Z{“buy_orders”:”[]”,“market_id”:""0xc559df216747fc11540e638646c384ad977617d6d8f0ea5ffdfc18d52e58ab01"",“msg_index”:“0”,“sell_orders”:”[{“order_info”:{“subaccount_id”:“0x8a3f89f79b5180ca75f37ddb0db1e9d4d3dc4a09000000000000000000000000”,“fee_recipient”:“inj13glcnaum2xqv5a0n0hdsmv0f6nfacjsfvrh5j9”,“price”:“6905000.000000000000000000”,“quantity”:“9526.600000000000000000”},“order_type”:“SELL_PO”,“margin”:“21927057667.000000000000000000”,“fillable”:“9526.600000000000000000”,“trigger_price”:null,“order_hash”:“/zf3nw/fCYKED9Y1Sv5he7WhLk6dGv69dNsYt8Cm7Gg=”}]“}31E34540ACD80D3A3B9E911EF5CFC6C7C91F3C440913E35598DC3DB862D87C7C0
coin_spent31450922072023-09-15T08:07:38.599Z{“amount”:“2295868776peggy0xdAC17F958D2ee523a2206206994597C13D831ec7”,“msg_index”:“0”,“spender”:“inj1akxycslq8cjt0uffw4rjmfm3echchptu52a2dq”}D55A77B5BF277C9126516D619BC4CE4CDC9D1CAAD4DD710537BB30BE1948186A5
message78450678312023-09-15T02:32:07.457Z{“msg_index”:“0”,“sender”:“inj1akxycslq8cjt0uffw4rjmfm3echchptu52a2dq”}0764CCDA59B481228AA087DE505C67DD9C66DB170EAAFFCDA2F2BC014F6931B73
Query with partition filter
SELECT *
FROM `tt-blockchain.injective.message_events`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
transaction_messages

Individual messages extracted from Cosmos SDK transactions with JSON-encoded payloads and type identifiers. Used for tracking specific blockchain operations like token transfers, staking actions, governance votes, and Inter-Blockchain Communication Protocol (IBC) updates within transaction execution.
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.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
message_indexINT64Sequential position of the message within its containing transaction. Zero-indexed integer indicating the order of messages in multi-message transactions.
message_typeSTRINGProtocol-specific identifier for the transaction message operation. Forward-slash delimited string indicating the message’s module and action, such as IBC (Inter-Blockchain Communication) client updates, governance votes, or protocol-specific operations.
messageSTRINGJSON-encoded payload containing the transaction message data and parameters. Structure and fields vary by message type, with nested objects representing protocol-specific operations and state changes.
messageblock_heightmessage_typemessage_indexblock_timestamptransaction_hashtransaction_index
{“proposalId”:“203”,“voter”:“inj1ns83m8s9hly2f9hdl39dcrwwmtgkcd89p4ym8p”,“option”:1,“metadata”:"",“@type”:“/cosmos.gov.v1beta1.MsgVote”}27290228/cosmos.gov.v1beta1.MsgVote02023-02-26T08:59:49.753ZB91FDEE07B0DF067BB7A60FCA34AB0C507EB8CD0F78B85A87DFDC7375D4FBC460
{“proposalId”:“203”,“voter”:“inj1hclxs654ylvwl4pchqh8mh8vnu0eucjtznwhrm”,“option”:1,“metadata”:"",“@type”:“/cosmos.gov.v1beta1.MsgVote”}27324942/cosmos.gov.v1beta1.MsgVote02023-02-26T19:06:32.065ZAB06155BA3D4B54F7FA10BFD87047111753B597979D89BACB3CC7A5AFDBB00200
{“proposalId”:“203”,“voter”:“inj1htf5wqnqqzj69rrj6e3h7fxanw93arkrs3m3wu”,“option”:1,“metadata”:"",“@type”:“/cosmos.gov.v1beta1.MsgVote”}27303155/cosmos.gov.v1beta1.MsgVote02023-02-26T12:43:07.994ZC5DD206FCF005F2F4A42260C34C1EF7A50D417975F066C30914C3756F43158590
Query with partition filter
SELECT *
FROM `tt-blockchain.injective.transaction_messages`
WHERE block_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.
fee_payerSTRINGAccount address responsible for paying the transaction fee on Injective. Typically null when the transaction sender pays their own fees.
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_usedfee_payergas_wantedblock_heightblock_timestamptransaction_feetransaction_logtransaction_codetransaction_hashtransaction_infotransaction_index
8315991172131358512022-07-21T07:37:26.275Z45586000000000inj[{“events”:[{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“/injective.exchange.v1beta1.MsgBatchUpdateOrders”}]}]}]0E2340626EA284C61FB353E0B4F0F32BA7231E247B98FD47CE3C9A8649087AD4E0
8329491307131557122022-07-21T21:02:21.637Z45653500000000inj[{“events”:[{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“/injective.exchange.v1beta1.MsgBatchUpdateOrders”}]}]}]033BA849975D1D2154F02FD238D1CF1C1A5871FEDD6AAAD86FA8F6DBC34836DB60
8329491307131543492022-07-21T20:08:21.190Z45653500000000inj[{“events”:[{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“/injective.exchange.v1beta1.MsgBatchUpdateOrders”}]}]}]05CD9C479FAA45FE3BE2A4BCAB039A80924C2116BEAC068DB8C9BB410113B1EA00
Query with partition filter
SELECT *
FROM `tt-blockchain.injective.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100