> ## Documentation Index > Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # terra > Tables in tt-blockchain.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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | event\_type | index\_flag | event\_index | block\_height | event\_source | attribute\_key | attribute\_index | attribute\_value | block\_timestamp | transaction\_hash | transaction\_index | | ----------- | ----------- | ------------ | ------------- | ------------- | -------------- | ---------------- | ---------------- | ------------------------ | ---------------------------------------------------------------- | ------------------ | | coin\_spent | true | 0 | 300823 | result | amount | 1 | 500uluna | 2022-06-17T21:50:03.000Z | A2D3D2AF2B1E519E0E40326B699E32EF493A684B4100F6DE96AC900084D8C90C | 0 | | coin\_spent | true | 0 | 296624 | result | amount | 1 | 5635uluna | 2022-06-17T14:54:20.000Z | 4A132A8D0971FFEA137F3CB096ED64CF9857813C54C2AB165254006FF7F6A43B | 0 | | coin\_spent | true | 0 | 294741 | result | amount | 1 | 7266uluna | 2022-06-17T11:47:26.000Z | 9FBB932C9D9C04B323F08743106588F14C87A66C88477C60F2C53B71E38C45C3 | 0 | **Query with partition filter** ```sql theme={null} 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. | 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. | | event\_type | event\_index | block\_height | attribute\_key | message\_index | attribute\_index | attribute\_value | block\_timestamp | transaction\_hash | transaction\_index | | ----------- | ------------ | ------------- | -------------- | -------------- | ---------------- | ----------------------------------------------------------------------------- | ------------------------ | ---------------------------------------------------------------- | ------------------ | | burn | 0 | 6888899 | burner | 0 | 0 | terra1yl6hdjhmkf37639730gffanpzndzdpmhgmvf4r | 2023-09-18T18:37:36.000Z | 4CEC07CF766DE1AE8D39E3E22319F7729C83FEA1B3AFA464DF203FDD1A3C3594 | 0 | | burn | 0 | 6888899 | amount | 0 | 1 | 180000000ibc/36A02FFC4E74DF4F64305130C3DFA1B06BEAC775648927AA44467C76A77AB8DB | 2023-09-18T18:37:36.000Z | 4CEC07CF766DE1AE8D39E3E22319F7729C83FEA1B3AFA464DF203FDD1A3C3594 | 0 | | burn | 0 | 6880875 | burner | 0 | 0 | terra1yl6hdjhmkf37639730gffanpzndzdpmhgmvf4r | 2023-09-18T05:17:24.000Z | E9B22D2D53B1B68487D64FFE20862E8413E68D72ED3EDBAF8132E8FF1B51A58C | 0 | **Query with partition filter** ```sql theme={null} 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. | 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. | | event\_index | block\_height | message\_index | message\_action | message\_sender | block\_timestamp | transaction\_hash | transaction\_index | | ------------ | ------------- | -------------- | ------------------------------ | -------------------------------------------- | ------------------------ | ---------------------------------------------------------------- | ------------------ | | 0 | 8587924 | 0 | /cosmos.authz.v1beta1.MsgGrant | terra10c04ysz9uznx2mkenuk3j3esjczyqh0j7gawjc | 2024-01-14T19:53:37.000Z | B66A6D92E7010B5B7731A5F93F4AFA187C48DDF59FBD9515C75240A10386A8FC | 8 | | 0 | 8587941 | 0 | /cosmos.authz.v1beta1.MsgGrant | terra10c04ysz9uznx2mkenuk3j3esjczyqh0j7gawjc | 2024-01-14T19:55:19.000Z | 83A7B2C8D993CDFA1EE4C1BB50615F67D5A182538C5AEA7FC1770CE4BDE80D73 | 4 | | 0 | 8587887 | 0 | /cosmos.authz.v1beta1.MsgGrant | terra10c04ysz9uznx2mkenuk3j3esjczyqh0j7gawjc | 2024-01-14T19:49:58.000Z | 8FEBA14BF2F83B6570CF9D5BF7D1D7379E9755E4CA5CBCBA7870460973C2B300 | 3 | **Query with partition filter** ```sql theme={null} 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. | 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. | | code | gas\_used | codespace | gas\_wanted | block\_height | block\_timestamp | transaction\_log | transaction\_data | transaction\_hash | transaction\_info | transaction\_index | transaction\_succeeded | | -------------------------------------- | ---------------------------------------------------------------- | --------- | ----------- | ------------- | ------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------- | ----------------- | ----------------- | ------------------ | ---------------------- | | 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 | | | | | | | | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-blockchain.terra.transactions` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` ***