agora_v1_ethereum

Tables

AgoraDollarErc1967Proxy_Burned_event

Token burn events from the Agora Dollar stablecoin contract on Ethereum. Records each burn transaction with the amount destroyed and the address from which tokens were burned, useful for tracking supply reduction and redemption 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_burnFrom`	`STRING`	Address from which Agora Dollar tokens were burned in this event. Hex-encoded, 0x-prefixed Ethereum address that authorized or held the tokens being destroyed.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	in_burnFrom	block_number	block_timestamp	transaction_hash
0x00000000efe302beaa2b3e6e1b18d08d69a9012a	false	10132023	10	0x4a4593c5d963473a95f0762bd6df4571542af651	20264584	2024-07-08T21:52:47.000Z	0x582218f12c524218c68221ebd7a0b39a3831d202db6f572c9e0769508e9811b8
0x00000000efe302beaa2b3e6e1b18d08d69a9012a	false	250000000000	223	0x4a4593c5d963473a95f0762bd6df4571542af651	20492003	2024-08-09T15:41:23.000Z	0xc301b986fe763a0dc2862aea6d19f5c8114370254be55174a35177c089700215
0x00000000efe302beaa2b3e6e1b18d08d69a9012a	false	100000000	533	0xc050b14efea76d16f4a06a16b3772e087237bd0c	20513091	2024-08-12T14:20:59.000Z	0xfbb0ae4b8bba1718dede8df79810d72af708aac8a1163869c54b4aace5ff6092

Example Query

Query with partition filter

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

AgoraDollarErc1967Proxy_Minted_event

Token minting events from the Agora Dollar (AUSD) stablecoin contract on Ethereum, recording each issuance with recipient address and minted amount. Used to track AUSD supply expansion and identify major minting recipients.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x00000000efe302beaa2b3e6e1b18d08d69a9012a	false	100000000	253	0x5208470dfd763ea987dfed21efb04661f91c5967	20262372	2024-07-08T14:25:11.000Z	0x2f7e75751b2fc3647a032ae9f9074f4cea0b165a00e3b80c1773e03e3cf9e13d
0x00000000efe302beaa2b3e6e1b18d08d69a9012a	false	4999988000000	168	0xa02318f858128c8d2048ef47171249e9b4a0deda	20342849	2024-07-19T20:04:35.000Z	0x385ec644f7aed961cb08991fb96e634a7f564c52da451346f52b95bf0232e607
0x00000000efe302beaa2b3e6e1b18d08d69a9012a	false	12000000	113	0xa02318f858128c8d2048ef47171249e9b4a0deda	20340225	2024-07-19T11:17:23.000Z	0x5e6fe4fbb96c1c2c531a22699a567c1826fc3a59c61765757834ce11bb785b78

Example Query

Query with partition filter

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

AgoraDollarErc1967Proxy_Transfer_event

Transfer events from the Agora Dollar (AUSD) stablecoin contract on Ethereum, tracking mints, burns, and transfers between addresses. Useful for analyzing token flows, supply changes, and holder activity for this ERC-20 stablecoin.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xa02318f858128c8d2048ef47171249e9b4a0deda	0x00000000efe302beaa2b3e6e1b18d08d69a9012a	0x0000000000000000000000000000000000000000	false	7000000000000	261	20278423	2024-07-10T20:15:11.000Z	0x3de2193d8a7de5557702fb11557d717bdb95a691879b1f422e728b41a869bc56
0xde789187e7a67337e859d005b38a345a98c891c0	0x00000000efe302beaa2b3e6e1b18d08d69a9012a	0xa02318f858128c8d2048ef47171249e9b4a0deda	false	10000000	182	20278467	2024-07-10T20:23:59.000Z	0x32392352a53d62caaba58d8e69c0ec188cbf51b48a0fa697d673b190545e046c
0xde789187e7a67337e859d005b38a345a98c891c0	0x00000000efe302beaa2b3e6e1b18d08d69a9012a	0xa02318f858128c8d2048ef47171249e9b4a0deda	false	6999990000000	278	20278533	2024-07-10T20:37:23.000Z	0xfc7d0c5bf45d9c60326050c74a86903fa213457a4b37c90ef8ca1d50dd115393

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AgoraDollarErc1967Proxy_Burned_event

AgoraDollarErc1967Proxy_Minted_event

AgoraDollarErc1967Proxy_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AgoraDollarErc1967Proxy_Burned_event

​AgoraDollarErc1967Proxy_Minted_event

​AgoraDollarErc1967Proxy_Transfer_event

Tables

AgoraDollarErc1967Proxy_Burned_event

AgoraDollarErc1967Proxy_Minted_event

AgoraDollarErc1967Proxy_Transfer_event