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.

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.

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gmotrust_v1_ethereum.ZUSD_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.

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.

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gmotrust_v1_ethereum.ZUSD_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

ZUSD_Burn_event

ZUSD_Mint_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ZUSD_Burn_event

​ZUSD_Mint_event

Tables

ZUSD_Burn_event

ZUSD_Mint_event