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
0x176211869ca2b568f2a7d4ee941e073a821ee1fffalse400000000000xa2ee6fce4acb62d95448729cdb781e3beb62504a1104952332024-10-08T21:07:36.000Z0xefb30b6f89397c192c0262f22d70ae3c3f1823d38279a68b04e71369afa37b8c
0x176211869ca2b568f2a7d4ee941e073a821ee1fffalse37500000000xa2ee6fce4acb62d95448729cdb781e3beb62504a3104686392024-10-08T06:12:40.000Z0x4ccd94630fc62e45f814983fde31545fe521e4bfaab2643d818f994d755bb7e1
0x176211869ca2b568f2a7d4ee941e073a821ee1fffalse681827868390xa2ee6fce4acb62d95448729cdb781e3beb62504a4104707552024-10-08T07:23:13.000Z0x426582c9ee7fd46e2b4f8f649d81e9f7bd89103430d6a19d3a440c719aaef3cb
Query with partition filter
SELECT *
FROM `tt-contracts.circle_v1_linea.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
0x3d9d1ca502b1e74d2298b719ad002909087561600x176211869ca2b568f2a7d4ee941e073a821ee1fffalse1181234690xa2ee6fce4acb62d95448729cdb781e3beb62504a1086912482024-08-27T21:35:00.000Z0x5cae91af8dcf180d13948fe9c5768b461e6d431061e71790388f9631e8d206e8
0x157f775bac0e960bb2f7a72c7cc8f8eb06e40b710x176211869ca2b568f2a7d4ee941e073a821ee1fffalse36988100000xa2ee6fce4acb62d95448729cdb781e3beb62504a086771272024-08-27T13:40:59.000Z0xde0de2b5cb4e6c156cb75ee40794a47bb5a7e7e10281eea63fb2b6ccfbfe3232
0x4d396974c5813159c704e96acdada21eb01005ed0x176211869ca2b568f2a7d4ee941e073a821ee1fffalse353625956250xa2ee6fce4acb62d95448729cdb781e3beb62504a086525702024-08-27T00:01:55.000Z0xef0c93b75cc7c08d8e8c2eb8659ff3d3e86b2954c87c3e585959cffe6f37896c
Query with partition filter
SELECT *
FROM `tt-contracts.circle_v1_linea.USDC_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100