terra

Tables

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.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`block_height`	`INT64`	Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transaction_count`	`INT64`	Number of transactions included in the block.
`validators_hash`	`STRING`	Cryptographic hash of the validator set for the block. Hex-encoded 64-character string without 0x prefix.
`proposer_address`	`STRING`	Address of the validator that proposed the block. Hex-encoded string without 0x prefix, 40 characters in length.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`gas_wanted`	`INT64`	Maximum gas units allocated for the transaction execution. String-encoded integer representing the computational resource limit set by the transaction submitter.

Sample Data

gas_used	timestamp	block_hash	gas_wanted	block_height	validators_hash	proposer_address	transaction_count
546217	2022-09-13T14:21:52.000Z	D4E67E6BE5DFDDBBA822D9DA7F3E0FCD140602BE5F58547783BA26398F2F7DDC	930893	1556384	8E6A1898796EFA0039E0ACF9F915C67C6595B3BD08664DEF50661A22D70D20A3	02F3E123E1191AEC6B41E11E700B00BE98BA638A	1
145848	2022-09-13T21:10:16.000Z	7B6B7B0E1121D391136FF4DA38B01641B53C32A52F1C4B6DC44DDCE5AE22CD16	260818	1560427	62CAFAEEA95D83A30600F060671728BFBC0D1049434FF3C6E8253504D1835180	02F3E123E1191AEC6B41E11E700B00BE98BA638A	1
259754	2022-09-13T01:44:43.000Z	0CB8D11E15F8042EB7117AED996D7F8581987DDF9EF4E76EF98A976EDE8DB811	490988	1548910	98132F74584C3C20B0F31132C90B904ADF4007B2F482E029D1D8334BAFD69466	02F3E123E1191AEC6B41E11E700B00BE98BA638A	1

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.terra.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

event_attributes

Raw blockchain event data from Terra chain with granular key-value attributes emitted during transaction execution. Used for detailed transaction analysis, event filtering, and parsing on-chain activity like token transfers, smart contract calls, and validator operations.

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.
`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_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.
`attribute_index`	`INT64`	Sequential position of this attribute within its parent event starting from 0. Multiple attributes can belong to a single event, ordered by this index.
`index_flag`	`BOOL`	Indicates whether this event attribute is marked for indexing by the Terra blockchain. Typically true for attributes that are queryable or included in event logs.
`attribute_key`	`STRING`	Key name of a specific attribute within a Terra blockchain event, such as “amount”, “sender”, or “contract_address”. Each event can have multiple key-value pairs that provide detailed information about the on-chain action.
`event_source`	`STRING`	Source component of the Terra blockchain that emitted this event, typically ‘result’ for transaction execution events or ‘begin_block’/‘end_block’ for block lifecycle events. Indicates whether the event originated from transaction processing or block-level operations.
`attribute_value`	`STRING`	The data value associated with the attribute_key for this Terra blockchain event. Contains various formats including token amounts with denominations (e.g., “500uluna”), addresses, or other event-specific data.

Sample Data

event_type	index_flag	block_height	event_source	attribute_key	attribute_index	attribute_value	block_timestamp	transaction_hash
coin_spent	true	300823	result	amount	1	500uluna	2022-06-17T21:50:03.000Z	A2D3D2AF2B1E519E0E40326B699E32EF493A684B4100F6DE96AC900084D8C90C
coin_spent	true	296624	result	amount	1	5635uluna	2022-06-17T14:54:20.000Z	4A132A8D0971FFEA137F3CB096ED64CF9857813C54C2AB165254006FF7F6A43B
coin_spent	true	294741	result	amount	1	7266uluna	2022-06-17T11:47:26.000Z	9FBB932C9D9C04B323F08743106588F14C87A66C88477C60F2C53B71E38C45C3

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.terra.event_attributes`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

message_event_attributes

Individual key-value attribute pairs emitted by Terra blockchain transaction events, containing granular event data like burner addresses, token amounts, and IBC (Inter-Blockchain Communication) denominations. Useful for analyzing specific event parameters within transactions such as burns, transfers, and contract interactions.

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.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`message_index`	`INT64`	Sequential position of the message within its containing transaction. Zero-indexed integer indicating the order of messages in multi-message transactions.
`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.
`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.
`attribute_key`	`STRING`	Name of the event attribute key emitted by the Terra blockchain message execution. Each event contains multiple key-value pairs that describe transaction details like “burner”, “amount”, “sender”, or other protocol-specific parameters.
`attribute_value`	`STRING`	Value corresponding to the attribute key within a Terra blockchain event (e.g., burner address, token amount with denomination). Contains diverse data types including addresses, amounts, and identifiers depending on the associated attribute_key.
`attribute_index`	`INT64`	Sequential position of this attribute within its parent event, starting from 0. Used to preserve the original ordering of key-value pairs emitted by the Terra blockchain during message execution.

Sample Data

event_type	block_height	attribute_key	attribute_index	attribute_value	block_timestamp	transaction_hash
burn	6888899	burner	0	terra1yl6hdjhmkf37639730gffanpzndzdpmhgmvf4r	2023-09-18T18:37:36.000Z	4CEC07CF766DE1AE8D39E3E22319F7729C83FEA1B3AFA464DF203FDD1A3C3594
burn	6888899	amount	1	180000000ibc/36A02FFC4E74DF4F64305130C3DFA1B06BEAC775648927AA44467C76A77AB8DB	2023-09-18T18:37:36.000Z	4CEC07CF766DE1AE8D39E3E22319F7729C83FEA1B3AFA464DF203FDD1A3C3594
burn	6880875	burner	0	terra1yl6hdjhmkf37639730gffanpzndzdpmhgmvf4r	2023-09-18T05:17:24.000Z	E9B22D2D53B1B68487D64FFE20862E8413E68D72ED3EDBAF8132E8FF1B51A58C

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.terra.message_event_attributes`
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.

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.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`message_index`	`INT64`	Sequential position of the message within its containing transaction. Zero-indexed integer indicating the order of messages in multi-message transactions.
`message_sender`	`STRING`	Terra wallet address of the account that initiated this message within the transaction. Uses bech32 encoding with “terra” prefix, typically 44 characters in length.
`message_action`	`STRING`	Cosmos SDK message type that defines the action being executed in this transaction message. Typically formatted as a slash-prefixed path (e.g., `/cosmos.authz.v1beta1.MsgGrant` for authorization grants).
`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.

Sample Data

block_height	message_action	message_sender	block_timestamp	transaction_hash	transaction_index
8587924	/cosmos.authz.v1beta1.MsgGrant	terra10c04ysz9uznx2mkenuk3j3esjczyqh0j7gawjc	2024-01-14T19:53:37.000Z	B66A6D92E7010B5B7731A5F93F4AFA187C48DDF59FBD9515C75240A10386A8FC	8
8587941	/cosmos.authz.v1beta1.MsgGrant	terra10c04ysz9uznx2mkenuk3j3esjczyqh0j7gawjc	2024-01-14T19:55:19.000Z	83A7B2C8D993CDFA1EE4C1BB50615F67D5A182538C5AEA7FC1770CE4BDE80D73	4
8587887	/cosmos.authz.v1beta1.MsgGrant	terra10c04ysz9uznx2mkenuk3j3esjczyqh0j7gawjc	2024-01-14T19:49:58.000Z	8FEBA14BF2F83B6570CF9D5BF7D1D7379E9755E4CA5CBCBA7870460973C2B300	3

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.terra.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.

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_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`gas_wanted`	`INT64`	Maximum gas units allocated for the transaction execution. String-encoded integer representing the computational resource limit set by the transaction submitter.
`code`	`INT64`	Error code returned by the transaction execution, where 0 indicates success. Non-zero values represent different failure types, with the specific error detailed in transaction_log and categorized by codespace.
`codespace`	`STRING`	Namespace for the error code when a transaction fails. Empty string for successful transactions; values like “wasm” or “sdk” indicate which module caused the failure.
`transaction_info`	`STRING`	Additional metadata or context information for the transaction. Empty string when no additional information is available.
`transaction_log`	`STRING`	Execution 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_succeeded`	`BOOL`	Boolean flag indicating whether the transaction executed successfully without errors. When false, the transaction consumed gas but reverted, with failure details available in transaction_log.
`transaction_data`	`STRING`	Raw transaction message data containing the protocol buffer encoded messages executed in this transaction. Typically includes message types like MsgExecuteContract for CosmWasm interactions or MsgVote for governance actions.

Sample Data

code	gas_used	gas_wanted	block_height	block_timestamp	transaction_log
0	408285	666666	1783790	2022-09-29T13:44:51.000Z	[{“events”:[{“type”:“coin_received”,“attributes”:[{“key”:“receiver”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“amount”,“value”:“36409719uluna”},{“key”:“receiver”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“amount”,“value”:“36409719uluna”},{“key”:“receiver”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“amount”,“value”:“88677967ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”},{“key”:“receiver”,“value”:“terra14ps3ldhwzmpmap5cft49295h7v229lnrny3k8e”},{“key”:“amount”,“value”:“88677967ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”}]},{“type”:“coin_spent”,“attributes”:[{“key”:“spender”,“value”:“terra14ps3ldhwzmpmap5cft49295h7v229lnrny3k8e”},{“key”:“amount”,“value”:“36409719uluna”},{“key”:“spender”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“amount”,“value”:“36409719uluna”},{“key”:“spender”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“amount”,“value”:“88677967ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”},{“key”:“spender”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“amount”,“value”:“88677967ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”}]},{“type”:“execute”,“attributes”:[{“key”:“_contract_address”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“_contract_address”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“_contract_address”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“_contract_address”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”}]},{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“/cosmwasm.wasm.v1.MsgExecuteContract”},{“key”:“module”,“value”:“wasm”},{“key”:“sender”,“value”:“terra14ps3ldhwzmpmap5cft49295h7v229lnrny3k8e”}]},{“type”:“transfer”,“attributes”:[{“key”:“recipient”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“sender”,“value”:“terra14ps3ldhwzmpmap5cft49295h7v229lnrny3k8e”},{“key”:“amount”,“value”:“36409719uluna”},{“key”:“recipient”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“sender”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“amount”,“value”:“36409719uluna”},{“key”:“recipient”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“sender”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“amount”,“value”:“88677967ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”},{“key”:“recipient”,“value”:“terra14ps3ldhwzmpmap5cft49295h7v229lnrny3k8e”},{“key”:“sender”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“amount”,“value”:“88677967ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”}]},{“type”:“wasm”,“attributes”:[{“key”:“_contract_address”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“swap_1”,“value”:“0.409351851829990602”},{“key”:“_contract_address”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“action”,“value”:“swap”},{“key”:“sender”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“receiver”,“value”:“terra1rfplw0843f4s2tfhaag7np0llnf7a3c92kq2zz5pelrdh2ufu8dqdtnynu”},{“key”:“offer_asset”,“value”:“uluna”},{“key”:“ask_asset”,“value”:“ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”},{“key”:“offer_amount”,“value”:“36409719”},{“key”:“return_amount”,“value”:“88677967”},{“key”:“spread_amount”,“value”:“155352”},{“key”:“commission_amount”,“value”:“266834”}]}]}]
&
$/cosmwasm.wasm.v1.MsgExecuteContract	CC32EB30C24E1B98C5B9A101F54A8444582C50FBC087682D7C461A786D4DE547	5	true
0	375181	721472	1784676	2022-09-29T15:14:51.000Z	[{“events”:[{“type”:“execute”,“attributes”:[{“key”:“_contract_address”,“value”:“terra1g2qz9sdxev6787hctt4cg0et4js7zw863vc3ysc0aunxnvlt6edq8adexs”}]},{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“/cosmwasm.wasm.v1.MsgExecuteContract”},{“key”:“module”,“value”:“wasm”},{“key”:“sender”,“value”:“terra1m4hq3r4xacwam3zk40kh0892gwlfzdpcxafd7u”}]},{“type”:“wasm”,“attributes”:[{“key”:“_contract_address”,“value”:“terra1g2qz9sdxev6787hctt4cg0et4js7zw863vc3ysc0aunxnvlt6edq8adexs”},{“key”:“action”,“value”:“create_round”},{“key”:“round_number”,“value”:“14”}]}]}]
&
$/cosmwasm.wasm.v1.MsgExecuteContract	125271E02279571D262DD4086E37CDA5B5B6F8C839AD9303958A490C47380A62	4	true
0	707195	1100000	1779857	2022-09-29T07:05:20.000Z	[{“events”:[{“type”:“coin_received”,“attributes”:[{“key”:“receiver”,“value”:“terra1fd68ah02gr2y8ze7tm9te7m70zlmc7vjyyhs6xlhsdmqqcjud4dql4wpxr”},{“key”:“amount”,“value”:“191136192ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”},{“key”:“receiver”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“amount”,“value”:“77502104uluna”},{“key”:“receiver”,“value”:“terra1ygcvxp9s054q8u2q4hvl52ke393zvgj0sllahlycm4mj8dm96zjsa45rzk”},{“key”:“amount”,“value”:“77727uluna”},{“key”:“receiver”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“amount”,“value”:“77502104uluna”},{“key”:“receiver”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“amount”,“value”:“191343989ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”}]},{“type”:“coin_spent”,“attributes”:[{“key”:“spender”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“amount”,“value”:“191136192ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”},{“key”:“spender”,“value”:“terra1fd68ah02gr2y8ze7tm9te7m70zlmc7vjyyhs6xlhsdmqqcjud4dql4wpxr”},{“key”:“amount”,“value”:“77502104uluna”},{“key”:“spender”,“value”:“terra1fd68ah02gr2y8ze7tm9te7m70zlmc7vjyyhs6xlhsdmqqcjud4dql4wpxr”},{“key”:“amount”,“value”:“77727uluna”},{“key”:“spender”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“amount”,“value”:“77502104uluna”},{“key”:“spender”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“amount”,“value”:“191343989ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”}]},{“type”:“execute”,“attributes”:[{“key”:“_contract_address”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“_contract_address”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“_contract_address”,“value”:“terra1fd68ah02gr2y8ze7tm9te7m70zlmc7vjyyhs6xlhsdmqqcjud4dql4wpxr”},{“key”:“_contract_address”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“_contract_address”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“_contract_address”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”}]},{“type”:“message”,“attributes”:[{“key”:“action”,“value”:“/cosmwasm.wasm.v1.MsgExecuteContract”},{“key”:“module”,“value”:“wasm”},{“key”:“sender”,“value”:“terra1yg57sejzex9mya0tzg95rqvyjfe2yrahys6xs7”}]},{“type”:“reply”,“attributes”:[{“key”:“_contract_address”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“_contract_address”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”}]},{“type”:“transfer”,“attributes”:[{“key”:“recipient”,“value”:“terra1fd68ah02gr2y8ze7tm9te7m70zlmc7vjyyhs6xlhsdmqqcjud4dql4wpxr”},{“key”:“sender”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“amount”,“value”:“191136192ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”},{“key”:“recipient”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“sender”,“value”:“terra1fd68ah02gr2y8ze7tm9te7m70zlmc7vjyyhs6xlhsdmqqcjud4dql4wpxr”},{“key”:“amount”,“value”:“77502104uluna”},{“key”:“recipient”,“value”:“terra1ygcvxp9s054q8u2q4hvl52ke393zvgj0sllahlycm4mj8dm96zjsa45rzk”},{“key”:“sender”,“value”:“terra1fd68ah02gr2y8ze7tm9te7m70zlmc7vjyyhs6xlhsdmqqcjud4dql4wpxr”},{“key”:“amount”,“value”:“77727uluna”},{“key”:“recipient”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“sender”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“amount”,“value”:“77502104uluna”},{“key”:“recipient”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“sender”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“amount”,“value”:“191343989ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”}]},{“type”:“wasm”,“attributes”:[{“key”:“_contract_address”,“value”:“terra1fd68ah02gr2y8ze7tm9te7m70zlmc7vjyyhs6xlhsdmqqcjud4dql4wpxr”},{“key”:“action”,“value”:“swap”},{“key”:“sender”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“receiver”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“offer_asset”,“value”:“ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”},{“key”:“ask_asset”,“value”:“uluna”},{“key”:“offer_amount”,“value”:“191136192”},{“key”:“return_amount”,“value”:“77502104”},{“key”:“tax_amount”,“value”:“0”},{“key”:“spread_amount”,“value”:“9034”},{“key”:“commission_amount”,“value”:“233205”},{“key”:“maker_fee_amount”,“value”:“77727”},{“key”:“_contract_address”,“value”:“terra1zrs8p04zctj0a0f9azakwwennrqfrkh3l6zkttz9x89e7vehjzmqzg8v7n”},{“key”:“action”,“value”:“swap”},{“key”:“sender”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“receiver”,“value”:“terra1e2lzl3czsv6vexqxg0ssw906xjgqtg2pyeu3f76rtw2sal6s33mqx2uv4x”},{“key”:“offer_asset”,“value”:“uluna”},{“key”:“ask_asset”,“value”:“ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4”},{“key”:“offer_amount”,“value”:“77502104”},{“key”:“return_amount”,“value”:“191343989”},{“key”:“spread_amount”,“value”:“719153”},{“key”:“commission_amount”,“value”:“575759”}]}]}]
&
$/cosmwasm.wasm.v1.MsgExecuteContract	2D0AEB31063B2D577DE64C1FAF638CE05546583570D32EECD4023D17DF3831A3	4	true

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.terra.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

event_attributes

message_event_attributes

transaction_messages

transactions

​Tables

​blocks

​event_attributes

​message_event_attributes

​transaction_messages

​transactions

Tables

blocks

event_attributes

message_event_attributes

transaction_messages

transactions