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
BeginBlockcommission157223032552024-09-23T00:01:53.001Z{“amount”:“926.303911757037631953uatom”,“mode”:“BeginBlock”,“validator”:“cosmosvaloper1ddle9tczl87gsvmeva3c48nenyng4n56nghmjk”}
BeginBlockliveness372223034492024-09-23T00:21:02.490Z{“address”:“cosmosvalcons1kv2cr60l2ugy25cnwr3dfz2694h7mm8muyensh”,“height”:“22303449”,“missed_blocks”:“5459”,“mode”:“BeginBlock”}
BeginBlockrewards34223036762024-09-23T00:43:36.380Z{“amount”:“186330.237977935526012680uatom”,“mode”:“BeginBlock”,“validator”:“cosmosvaloper1wvt5zugk97mrl5rm9c3m573f9gj03w2gyh8m5v”}
Query with partition filter
SELECT *
FROM `tt-blockchain.cosmoshub.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
2021-09-29T04:09:14.703Z782832933D46E88C8F524E46E4ED57D55685489F2872BF03130EF5621BDBD04AC18DE99000001E443FD237E4B616E2FA69DF4EE3D49A94F0
2021-09-29T09:00:44.299Z7830637480B4EE25038171F60C63D1D64D11F726D253A77CC53097B8046EFCA8CEBC8D5000001E443FD237E4B616E2FA69DF4EE3D49A94F0
2021-09-29T23:36:56.441Z783756633FBB6F6C4B3799D4AEEAF6F0F743E52FC0F10149BA4730F5E5792557BB2D881000001E443FD237E4B616E2FA69DF4EE3D49A94F0
Query with partition filter
SELECT *
FROM `tt-blockchain.cosmoshub.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
delegate1190914772024-02-10T03:33:53.764Z{“amount”:“2014692uatom”,“new_shares”:“2014692.000000000000000000”,“validator”:“cosmosvaloper14qazscc80zgzx3m0m0aa30ths0p9hg8vdglqrc”}7F7B5394C71C500AE16D8F7539A7775E07E0C7237D479A152965F86E402EBA870
tx2190902392024-02-10T01:26:10.249Z{“signature”:“OqCy49f3AsUnkPEO1SD25fxqdkw+vqiHLkP51QYiCYQUexQWvEuvShTmMEQO7tTZG4zeugYKVVjIVZ+LqvS4yg==“}2482CEC43C8E28802BC705990DE7260036E84A06A90171044074C9AB3633946C3
message7190957092024-02-10T10:51:25.696Z{“sender”:“cosmos1zzfx8rxmvqw53lhjdq9hsce5hzl8dt3ecksx7j”}4A922808E99FF73883A32AD846566437DB1927EC03C1EC82D52EEE8465DDA4EA14
Query with partition filter
SELECT *
FROM `tt-blockchain.cosmoshub.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
{“grantee”:“cosmos164e53fz34nkc03vnncdl5w9xp420lkak5fp3vg”,“msgs”:[{“delegatorAddress”:“cosmos18wg9x0uw850ee9yng5yvx3nh5n3jwkfzjn4pvu”,“validatorAddress”:“cosmosvaloper16s96n9k9zztdgjy8q4qcxp4hn7ww98qkrka4zk”,“amount”:{“denom”:“uatom”,“amount”:“1096897”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”},{“delegatorAddress”:“cosmos1j4z46u5hwmdqtjhkk57wl53ttar7u23dsm5hy7”,“validatorAddress”:“cosmosvaloper16s96n9k9zztdgjy8q4qcxp4hn7ww98qkrka4zk”,“amount”:{“denom”:“uatom”,“amount”:“2071399”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”}],“@type”:“/cosmos.authz.v1beta1.MsgExec”}24214952/cosmos.authz.v1beta1.MsgExec02025-02-01T00:00:06.145Z3E8CD43A0971D9D6576771B72D21E1059B5432F53DD808FC9B8DF2164F455E351
{“grantee”:“cosmos1nlq3spfcqscxj3a8hesc4uqx0dd2ljd6vysr6f”,“msgs”:[{“delegatorAddress”:“cosmos1h9yqfst7rtwthx29wuv7mv7lm3wrvg9gzxh5n2”,“validatorAddress”:“cosmosvaloper1wdrypwex63geqswmcy5qynv4w3z3dyef2qmyna”,“amount”:{“denom”:“uatom”,“amount”:“43596”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”}],“@type”:“/cosmos.authz.v1beta1.MsgExec”}24214954/cosmos.authz.v1beta1.MsgExec02025-02-01T00:00:18.862Z818996310118684CE679F220C62921D31C9FEDEC7F14B22B63CE919F11B9DE2D3
{“grantee”:“cosmos1ltd3ynqjvy39r3lc48p4zlqa59hvam5t4n2nfq”,“msgs”:[{“delegatorAddress”:“cosmos1p2axxy8vcm052jmrvypw3qz6m86yspwdzyek2q”,“validatorAddress”:“cosmosvaloper1jlr62guqwrwkdt4m3y00zh2rrsamhjf9num5xr”,“amount”:{“denom”:“uatom”,“amount”:“1009096”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”},{“delegatorAddress”:“cosmos1p07s0lrcea2j9lfx5xdahagduh9xkugu678reh”,“validatorAddress”:“cosmosvaloper1jlr62guqwrwkdt4m3y00zh2rrsamhjf9num5xr”,“amount”:{“denom”:“uatom”,“amount”:“1014980”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”},{“delegatorAddress”:“cosmos1pk3d02urlqvxjzqmplds5yueujmau7vp0ekfkx”,“validatorAddress”:“cosmosvaloper1jlr62guqwrwkdt4m3y00zh2rrsamhjf9num5xr”,“amount”:{“denom”:“uatom”,“amount”:“1017775”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”},{“delegatorAddress”:“cosmos1f0k5nyutjgetxslhzclunq3p2j3gyuflpfdnzy”,“validatorAddress”:“cosmosvaloper1jlr62guqwrwkdt4m3y00zh2rrsamhjf9num5xr”,“amount”:{“denom”:“uatom”,“amount”:“1015256”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”},{“delegatorAddress”:“cosmos1f78fp2rmrvkjv4ll7vd2uk88cc82ffsklu52d6”,“validatorAddress”:“cosmosvaloper1jlr62guqwrwkdt4m3y00zh2rrsamhjf9num5xr”,“amount”:{“denom”:“uatom”,“amount”:“1332564”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”},{“delegatorAddress”:“cosmos12jcnte32w7nu8am9utkz7txv0nwnvfqazl340n”,“validatorAddress”:“cosmosvaloper1jlr62guqwrwkdt4m3y00zh2rrsamhjf9num5xr”,“amount”:{“denom”:“uatom”,“amount”:“1015260”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”},{“delegatorAddress”:“cosmos1vyx5e5uuvhgdxjka9e6a7tkpsyqu9wmzex47xt”,“validatorAddress”:“cosmosvaloper1jlr62guqwrwkdt4m3y00zh2rrsamhjf9num5xr”,“amount”:{“denom”:“uatom”,“amount”:“4048338”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”},{“delegatorAddress”:“cosmos1va2ceyawlvrcq3q6zdnvuf7pjgc6pnx428lvh4”,“validatorAddress”:“cosmosvaloper1jlr62guqwrwkdt4m3y00zh2rrsamhjf9num5xr”,“amount”:{“denom”:“uatom”,“amount”:“1161689”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”},{“delegatorAddress”:“cosmos10lkm6uyq6j7h293uh3fy7z09ddgc5s250n44x6”,“validatorAddress”:“cosmosvaloper1jlr62guqwrwkdt4m3y00zh2rrsamhjf9num5xr”,“amount”:{“denom”:“uatom”,“amount”:“1006875”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”},{“delegatorAddress”:“cosmos1s3dvs7gves4zzf3u73fseqc2h95cj4hhxktrl8”,“validatorAddress”:“cosmosvaloper1jlr62guqwrwkdt4m3y00zh2rrsamhjf9num5xr”,“amount”:{“denom”:“uatom”,“amount”:“1009166”},“@type”:“/cosmos.staking.v1beta1.MsgDelegate”}],“@type”:“/cosmos.authz.v1beta1.MsgExec”}24214961/cosmos.authz.v1beta1.MsgExec02025-02-01T00:00:59.128ZB299B76474190AA9AA3B748205A7C8CF805ABF7BF88CF0AABE323F45B3C84AB53
Query with partition filter
SELECT *
FROM `tt-blockchain.cosmoshub.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_feeINT64Transaction fee paid for processing the transaction. 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_codetransaction_hashtransaction_infotransaction_index
11381320000070864122021-07-27T21:49:56.776Z[{“events”:[{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“withdraw_delegator_reward”},{“key”:“sender”,“value”:“cosmos1jv65s3grqf6v6jl3dp4t6c9t9rk99cd88lyufl”},{“key”:“module”,“value”:“distribution”},{“key”:“sender”,“value”:“cosmos1s7jnk7t6yqzensdgpvkvkag022udk8429exc87”}]},{“type”:“transfer”,“attributes”:[{“key”:“recipient”,“value”:“cosmos1s7jnk7t6yqzensdgpvkvkag022udk8429exc87”},{“key”:“sender”,“value”:“cosmos1jv65s3grqf6v6jl3dp4t6c9t9rk99cd88lyufl”},{“key”:“amount”,“value”:“2230517uatom”}]},{“type”:“withdraw_rewards”,“attributes”:[{“key”:“amount”,“value”:“2230517uatom”},{“key”:“validator”,“value”:“cosmosvaloper1s7jnk7t6yqzensdgpvkvkag022udk842qdjdtd”}]}]},{“msg_index”:1,“events”:[{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“withdraw_validator_commission”},{“key”:“sender”,“value”:“cosmos1jv65s3grqf6v6jl3dp4t6c9t9rk99cd88lyufl”},{“key”:“module”,“value”:“distribution”},{“key”:“sender”,“value”:“cosmosvaloper1s7jnk7t6yqzensdgpvkvkag022udk842qdjdtd”}]},{“type”:“transfer”,“attributes”:[{“key”:“recipient”,“value”:“cosmos1s7jnk7t6yqzensdgpvkvkag022udk8429exc87”},{“key”:“sender”,“value”:“cosmos1jv65s3grqf6v6jl3dp4t6c9t9rk99cd88lyufl”},{“key”:“amount”,“value”:“12536913uatom”}]},{“type”:“withdraw_commission”,“attributes”:[{“key”:“amount”,“value”:“12536913uatom”}]}]}]0C548A79605341536106C783280BA4E023203F5F57373D40183D70897709D41940
11392320000070847212021-07-27T18:22:45.019Z[{“events”:[{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“withdraw_delegator_reward”},{“key”:“sender”,“value”:“cosmos1jv65s3grqf6v6jl3dp4t6c9t9rk99cd88lyufl”},{“key”:“module”,“value”:“distribution”},{“key”:“sender”,“value”:“cosmos1fqzqejwkk898fcslw4z4eeqjzesynvrdvhqz82”}]},{“type”:“transfer”,“attributes”:[{“key”:“recipient”,“value”:“cosmos1fqzqejwkk898fcslw4z4eeqjzesynvrdvhqz82”},{“key”:“sender”,“value”:“cosmos1jv65s3grqf6v6jl3dp4t6c9t9rk99cd88lyufl”},{“key”:“amount”,“value”:“2452412uatom”}]},{“type”:“withdraw_rewards”,“attributes”:[{“key”:“amount”,“value”:“2452412uatom”},{“key”:“validator”,“value”:“cosmosvaloper1fqzqejwkk898fcslw4z4eeqjzesynvrdfr5hte”}]}]},{“msg_index”:1,“events”:[{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“withdraw_validator_commission”},{“key”:“sender”,“value”:“cosmos1jv65s3grqf6v6jl3dp4t6c9t9rk99cd88lyufl”},{“key”:“module”,“value”:“distribution”},{“key”:“sender”,“value”:“cosmosvaloper1fqzqejwkk898fcslw4z4eeqjzesynvrdfr5hte”}]},{“type”:“transfer”,“attributes”:[{“key”:“recipient”,“value”:“cosmos1fqzqejwkk898fcslw4z4eeqjzesynvrdvhqz82”},{“key”:“sender”,“value”:“cosmos1jv65s3grqf6v6jl3dp4t6c9t9rk99cd88lyufl”},{“key”:“amount”,“value”:“10421547uatom”}]},{“type”:“withdraw_commission”,“attributes”:[{“key”:“amount”,“value”:“10421547uatom”}]}]}]030FD841E6ACD28D1F2A833669FC43E6F89DEAE27878E5E296808EEFB40855FD00
12168820000070803912021-07-27T09:30:37.000Z[{“events”:[{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“swap_within_batch”},{“key”:“sender”,“value”:“cosmos1qvsw99xe74pkgx5fvagtd33cxy5pl50eueg08h”},{“key”:“module”,“value”:“liquidity”}]},{“type”:“swap_within_batch”,“attributes”:[{“key”:“pool_id”,“value”:“1”},{“key”:“batch_index”,“value”:“8”},{“key”:“msg_index”,“value”:“7”},{“key”:“swap_type_id”,“value”:“1”},{“key”:“offer_coin_denom”,“value”:“uatom”},{“key”:“offer_coin_amount”,“value”:“14600”},{“key”:“offer_coin_fee_amount”,“value”:“21”},{“key”:“demand_coin_denom”,“value”:“ibc/14F9BC3E44B8A9C1BE1FB08980FAB87034C9905EF17CF2F5008FC085218811CC”},{“key”:“order_price”,“value”:“0.148900000000000000”}]},{“type”:“transfer”,“attributes”:[{“key”:“recipient”,“value”:“cosmos1tx68a8k9yz54z06qfve9l2zxvgsz4ka3hr8962”},{“key”:“sender”,“value”:“cosmos1qvsw99xe74pkgx5fvagtd33cxy5pl50eueg08h”},{“key”:“amount”,“value”:“14621uatom”}]}]}]042124FE7EEFBFA2F79C242D35A4DA77DA5A9B52767FCE05042F9AE1501F4F5120
Query with partition filter
SELECT *
FROM `tt-blockchain.cosmoshub.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100