circle_v1_sonic

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
0x29219dd400f2bf60e5a23d13be72b486d4038894	false	13258416044	0xfd78ee919681417d192449715b2594ab58f5d002	1	41737787	2025-08-05T13:51:24.000Z	0x4fa77f4ade2b36f33fd10ceb908021b1fc2a0e923a3748805d022a3c44e0c60d
0x29219dd400f2bf60e5a23d13be72b486d4038894	false	1100000000	0xfd78ee919681417d192449715b2594ab58f5d002	1	41666971	2025-08-05T00:47:45.000Z	0xb8e364adc1bd7959a9bf08c1b2cbcd07867531fa2f34fd9c6937592e1c5a0dce
0x29219dd400f2bf60e5a23d13be72b486d4038894	false	80009990000	0xfd78ee919681417d192449715b2594ab58f5d002	1	41732052	2025-08-05T12:53:20.000Z	0xcc8a3ffd2e24587b64d10dca51b8cc2818d02034a960cf8e1cf72f6fcf832094

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.circle_v1_sonic.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	block_number	block_timestamp	transaction_hash
0x98345a8b0dafa92c062ede7679ef2d679de78535	0x29219dd400f2bf60e5a23d13be72b486d4038894	false	50000000	0xe6dcd54b4cde2e9e935c22f57ebbbaaf5cc3bc8a	18654416	2025-04-07T05:43:57.000Z	0xf322601e14e350be3d7894dee139454fabde7d1715e75b1ece7866ce130e4a0c
0x76f81e3aa16771d558c71e9890cb6e075b4dd8e0	0x29219dd400f2bf60e5a23d13be72b486d4038894	false	66837471900	0xe6dcd54b4cde2e9e935c22f57ebbbaaf5cc3bc8a	18805443	2025-04-07T20:51:52.000Z	0x7496c2c385a0e9933fa1af39b2230a11a2c74624d2ac0529a7e319cb9370a663
0xdf6c8b21a08c21d6eacc1d315dbf78884d34aafe	0x29219dd400f2bf60e5a23d13be72b486d4038894	false	4999253147	0xe6dcd54b4cde2e9e935c22f57ebbbaaf5cc3bc8a	18783875	2025-04-07T18:31:55.000Z	0xefe1649250d73a910479172a4c447db368af91956e2674ed92cb03f6fd46b1ec

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

USDC_Burn_event

USDC_Mint_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​USDC_Burn_event

​USDC_Mint_event

Tables

USDC_Burn_event

USDC_Mint_event