Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_burnerSTRINGAccount address that burned the tokens. Hex-encoded string with 0x prefix.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_amountin_burnerlog_indexblock_numberblock_timestamptransaction_hash
0xceba9300f2b948710d2653dd7b07f33a8b32118cfalse10000000x4f1e8edc116ec1b9469c5f5cd21258f5499853a730313002722025-03-28T22:30:30.000Z0x4d49740136776e5afd5f13f756f3e150226245bf7f503428e31f6f81d1fb9de3
0xceba9300f2b948710d2653dd7b07f33a8b32118cfalse1578547200000xbc7c8e7fc7a8ce54c50d17523fb031ffdc203fec486302494262025-02-07T09:32:18.000Z0xc8e72f12e44e17e20812fd6f20f0b3915740611900e227f8feca9b914b93869a
0xceba9300f2b948710d2653dd7b07f33a8b32118cfalse3478018000000xbc7c8e7fc7a8ce54c50d17523fb031ffdc203fec5254020932024-05-02T20:21:14.000Z0xd01632ba395efabe0bf9628fe4ec36acd2aa920315a10fab1867595b037a8145
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_minterSTRINGAddress authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_toaddressremovedin_amountin_minterlog_indexblock_numberblock_timestamptransaction_hash
0xbc7c8e7fc7a8ce54c50d17523fb031ffdc203fec0xceba9300f2b948710d2653dd7b07f33a8b32118cfalse12307307900000x2ffececf5a0618b9bb4e7134f838eec8e1c9004335336260422025-04-24T20:33:20.000Z0x921f9d2519f492cc7b4d542107d1db5eac63ca53ca0da167ac625d96e9155ecf
0xbc7c8e7fc7a8ce54c50d17523fb031ffdc203fec0xceba9300f2b948710d2653dd7b07f33a8b32118cfalse145761600000x2ffececf5a0618b9bb4e7134f838eec8e1c90043338265564922024-07-08T15:51:10.000Z0xe94c88b22ad4484261ca346ede17da5966c22f15cc781216e8b2bca0ce76b901
0xbc7c8e7fc7a8ce54c50d17523fb031ffdc203fec0xceba9300f2b948710d2653dd7b07f33a8b32118cfalse1472460300000x2ffececf5a0618b9bb4e7134f838eec8e1c90043584265612932024-07-08T22:31:19.000Z0x54e9aba2448ebec3a2088a615d193ee6e78f737e32b66907cc330e61d50447b6
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