circle_v1_celo

Tables

USDC_Burn_event

USDC token burn events emitted when tokens are permanently destroyed from circulation. Records the burner address and amount removed from total supply for Circle’s USDC stablecoin across multiple blockchain networks.

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_burner`	`STRING`	Account address that burned the tokens. Hex-encoded string with 0x prefix.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	in_burner	log_index	block_number	block_timestamp	transaction_hash
0xceba9300f2b948710d2653dd7b07f33a8b32118c	false	1000000	0x4f1e8edc116ec1b9469c5f5cd21258f5499853a7	30	31300272	2025-03-28T22:30:30.000Z	0x4d49740136776e5afd5f13f756f3e150226245bf7f503428e31f6f81d1fb9de3
0xceba9300f2b948710d2653dd7b07f33a8b32118c	false	157854720000	0xbc7c8e7fc7a8ce54c50d17523fb031ffdc203fec	486	30249426	2025-02-07T09:32:18.000Z	0xc8e72f12e44e17e20812fd6f20f0b3915740611900e227f8feca9b914b93869a
0xceba9300f2b948710d2653dd7b07f33a8b32118c	false	347801800000	0xbc7c8e7fc7a8ce54c50d17523fb031ffdc203fec	5	25402093	2024-05-02T20:21:14.000Z	0xd01632ba395efabe0bf9628fe4ec36acd2aa920315a10fab1867595b037a8145

Example Query

Query with partition filter

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

USDC_Mint_event

USDC token minting events emitted by Circle’s smart contracts when new USDC tokens are created. Contains minter address, recipient address, and minted amount for tracking stablecoin supply expansion across supported blockchains.

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_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_amount	in_minter	log_index	block_number	block_timestamp	transaction_hash
0xbc7c8e7fc7a8ce54c50d17523fb031ffdc203fec	0xceba9300f2b948710d2653dd7b07f33a8b32118c	false	1230730790000	0x2ffececf5a0618b9bb4e7134f838eec8e1c90043	35	33626042	2025-04-24T20:33:20.000Z	0x921f9d2519f492cc7b4d542107d1db5eac63ca53ca0da167ac625d96e9155ecf
0xbc7c8e7fc7a8ce54c50d17523fb031ffdc203fec	0xceba9300f2b948710d2653dd7b07f33a8b32118c	false	14576160000	0x2ffececf5a0618b9bb4e7134f838eec8e1c90043	338	26556492	2024-07-08T15:51:10.000Z	0xe94c88b22ad4484261ca346ede17da5966c22f15cc781216e8b2bca0ce76b901
0xbc7c8e7fc7a8ce54c50d17523fb031ffdc203fec	0xceba9300f2b948710d2653dd7b07f33a8b32118c	false	147246030000	0x2ffececf5a0618b9bb4e7134f838eec8e1c90043	584	26561293	2024-07-08T22:31:19.000Z	0x54e9aba2448ebec3a2088a615d193ee6e78f737e32b66907cc330e61d50447b6

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

USDC_Burn_event

USDC_Mint_event

​Tables

​USDC_Burn_event

​USDC_Mint_event

Tables

USDC_Burn_event

USDC_Mint_event