Skip to main content

​
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.
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.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
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.
gas_usedINT64Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
gas_wantedINT64Maximum gas units allocated for the transaction execution. String-encoded integer representing the computational resource limit set by the transaction submitter.
gas_usedtimestampblock_hashgas_wantedblock_heightvalidators_hashproposer_addresstransaction_count
5462172022-09-13T14:21:52.000ZD4E67E6BE5DFDDBBA822D9DA7F3E0FCD140602BE5F58547783BA26398F2F7DDC93089315563848E6A1898796EFA0039E0ACF9F915C67C6595B3BD08664DEF50661A22D70D20A302F3E123E1191AEC6B41E11E700B00BE98BA638A1
1458482022-09-13T21:10:16.000Z7B6B7B0E1121D391136FF4DA38B01641B53C32A52F1C4B6DC44DDCE5AE22CD16260818156042762CAFAEEA95D83A30600F060671728BFBC0D1049434FF3C6E8253504D183518002F3E123E1191AEC6B41E11E700B00BE98BA638A1
2597542022-09-13T01:44:43.000Z0CB8D11E15F8042EB7117AED996D7F8581987DDF9EF4E76EF98A976EDE8DB811490988154891098132F74584C3C20B0F31132C90B904ADF4007B2F482E029D1D8334BAFD6946602F3E123E1191AEC6B41E11E700B00BE98BA638A1
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.
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.
event_indexINT64Sequential position of the event within its containing block. Zero-indexed integer indicating the order in which events occurred during block processing.
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.
attribute_indexINT64Sequential position of this attribute within its parent event starting from 0. Multiple attributes can belong to a single event, ordered by this index.
index_flagBOOLIndicates 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_keySTRINGKey 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_sourceSTRINGSource 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_valueSTRINGThe 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.
event_typeindex_flagevent_indexblock_heightevent_sourceattribute_keyattribute_indexattribute_valueblock_timestamptransaction_hashtransaction_index
coin_spenttrue0300823resultamount1500uluna2022-06-17T21:50:03.000ZA2D3D2AF2B1E519E0E40326B699E32EF493A684B4100F6DE96AC900084D8C90C0
coin_spenttrue0296624resultamount15635uluna2022-06-17T14:54:20.000Z4A132A8D0971FFEA137F3CB096ED64CF9857813C54C2AB165254006FF7F6A43B0
coin_spenttrue0294741resultamount17266uluna2022-06-17T11:47:26.000Z9FBB932C9D9C04B323F08743106588F14C87A66C88477C60F2C53B71E38C45C30
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.
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.
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.
attribute_keySTRINGName 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_valueSTRINGValue 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_indexINT64Sequential 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.
event_typeevent_indexblock_heightattribute_keymessage_indexattribute_indexattribute_valueblock_timestamptransaction_hashtransaction_index
burn06888899burner00terra1yl6hdjhmkf37639730gffanpzndzdpmhgmvf4r2023-09-18T18:37:36.000Z4CEC07CF766DE1AE8D39E3E22319F7729C83FEA1B3AFA464DF203FDD1A3C35940
burn06888899amount01180000000ibc/36A02FFC4E74DF4F64305130C3DFA1B06BEAC775648927AA44467C76A77AB8DB2023-09-18T18:37:36.000Z4CEC07CF766DE1AE8D39E3E22319F7729C83FEA1B3AFA464DF203FDD1A3C35940
burn06880875burner00terra1yl6hdjhmkf37639730gffanpzndzdpmhgmvf4r2023-09-18T05:17:24.000ZE9B22D2D53B1B68487D64FFE20862E8413E68D72ED3EDBAF8132E8FF1B51A58C0
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.
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_senderSTRINGTerra wallet address of the account that initiated this message within the transaction. Uses bech32 encoding with “terra” prefix, typically 44 characters in length.
message_actionSTRINGCosmos 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_indexINT64Sequential position of the event within its containing block. Zero-indexed integer indicating the order in which events occurred during block processing.
event_indexblock_heightmessage_indexmessage_actionmessage_senderblock_timestamptransaction_hashtransaction_index
085879240/cosmos.authz.v1beta1.MsgGrantterra10c04ysz9uznx2mkenuk3j3esjczyqh0j7gawjc2024-01-14T19:53:37.000ZB66A6D92E7010B5B7731A5F93F4AFA187C48DDF59FBD9515C75240A10386A8FC8
085879410/cosmos.authz.v1beta1.MsgGrantterra10c04ysz9uznx2mkenuk3j3esjczyqh0j7gawjc2024-01-14T19:55:19.000Z83A7B2C8D993CDFA1EE4C1BB50615F67D5A182538C5AEA7FC1770CE4BDE80D734
085878870/cosmos.authz.v1beta1.MsgGrantterra10c04ysz9uznx2mkenuk3j3esjczyqh0j7gawjc2024-01-14T19:49:58.000Z8FEBA14BF2F83B6570CF9D5BF7D1D7379E9755E4CA5CBCBA7870460973C2B3003
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.
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_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
gas_usedINT64Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
gas_wantedINT64Maximum gas units allocated for the transaction execution. String-encoded integer representing the computational resource limit set by the transaction submitter.
codeINT64Error 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.
codespaceSTRINGNamespace 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_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_succeededBOOLBoolean 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_dataSTRINGRaw 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.
codegas_usedcodespacegas_wantedblock_heightblock_timestamptransaction_logtransaction_datatransaction_hashtransaction_infotransaction_indextransaction_succeeded
040828566666617837902022-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.MsgExecuteContractCC32EB30C24E1B98C5B9A101F54A8444582C50FBC087682D7C461A786D4DE5475true
037518172147217846762022-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.MsgExecuteContract125271E02279571D262DD4086E37CDA5B5B6F8C839AD9303958A490C47380A624true
0707195110000017798572022-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.MsgExecuteContract2D0AEB31063B2D577DE64C1FAF638CE05546583570D32EECD4023D17DF3831A34true
Query with partition filter
SELECT *
FROM `tt-blockchain.terra.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100