> ## 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.

# gmotrust_v1_ethereum

> Tables in tt-contracts.gmotrust_v1_ethereum

## Tables

### ZUSD\_Burn\_event

ZUSD token burn events from GMO Trust's stablecoin contract on Ethereum, tracking token destruction transactions with burnee addresses and amounts. Used for analyzing ZUSD supply reduction and redemption patterns.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_burnee`        | `STRING`    | Address of the account whose tokens are being burned in this ZUSD burn event. Typically matches `in_sender`, indicating self-initiated burns.        |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_amount   | in\_burnee                                 | in\_sender                                 | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------ | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xc56c2b7e71b54d38aab6d52e94a04cbfa8f604fa | false   | 24000000     | 0x33d84c1ab187e891e7962964f2bff6b9267394a9 | 0x33d84c1ab187e891e7962964f2bff6b9267394a9 | 18         | 9087967       | 2019-12-11T09:11:20.000Z | 0xac71a9234cd284cfb0357cbba66d0797639e86ccce5bea0c69570c46f253e9c4 |
  | 0xc56c2b7e71b54d38aab6d52e94a04cbfa8f604fa | false   | 309540000000 | 0x2fd720cf3b131614a982ebed0fbdd6c322d9974d | 0x2fd720cf3b131614a982ebed0fbdd6c322d9974d | 446        | 15308011      | 2022-08-09T12:32:41.000Z | 0x4d4f932bfbcaf0c7a28d409a1ca46e845c63c3bff4fd17e6394c81663824c264 |
  | 0xc56c2b7e71b54d38aab6d52e94a04cbfa8f604fa | false   | 2155050      | 0xf7a60b9a8b1f7ff0105d3825be64aeb59f24d1be | 0xf7a60b9a8b1f7ff0105d3825be64aeb59f24d1be | 69         | 13617799      | 2021-11-15T02:51:05.000Z | 0x9a95a57d50601136b6f39d7f3b8ffc7aeceea1486ab9cc2958247399663c861b |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.gmotrust_v1_ethereum.ZUSD_Burn_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### ZUSD\_Mint\_event

ZUSD token minting events from GMO Trust's stablecoin contract on Ethereum. Records each mint operation with sender, recipient (mintee), and amount for tracking ZUSD supply expansion and authorized issuance activity.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_mintee`        | `STRING`    | Ethereum address of the recipient receiving newly minted ZUSD tokens. Can be the same as the sender address when users mint directly for themselves. |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_amount    | in\_mintee                                 | in\_sender                                 | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xc56c2b7e71b54d38aab6d52e94a04cbfa8f604fa | false   | 200000000000  | 0x82b619cce215a6cf2df67e31039924ccf71b1d0b | 0x8db3b1acd3e9e3a10285f8744bf3bc58df8038d6 | 250        | 15255779      | 2022-08-01T09:18:29.000Z | 0x20ce6e75aa618919ab7200e9f27a6bcc7a0b06c3c5bccc74a349bc69b5230161 |
  | 0xc56c2b7e71b54d38aab6d52e94a04cbfa8f604fa | false   | 1250657000000 | 0xaff9104e58d0123632f392d16b2a6e0db79c1363 | 0x656e5d35c8e8cd1f2d30ffee8cd74a367090c79f | 173        | 18188285      | 2023-09-22T02:01:47.000Z | 0x07bdc0e521536a4f4297e5ecfc64cbc839e5fa60decad7be50bbbdede4be31f9 |
  | 0xc56c2b7e71b54d38aab6d52e94a04cbfa8f604fa | false   | 100000000     | 0xe7fd03b5e4e94a5c2a8084075f1f3df8cee6ac51 | 0xe7fd03b5e4e94a5c2a8084075f1f3df8cee6ac51 | 96         | 11696220      | 2021-01-21T02:47:25.000Z | 0x570ded8b3074aa95233eb20eeedb6759161f2a24bf0fac080db5f3015cff5eba |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.gmotrust_v1_ethereum.ZUSD_Mint_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***