Skip to main content

Tables

FiatTokenV2_Burn_event

Token burn events from Circle’s USDC FiatTokenV2 contract on Ink, recording when tokens are permanently destroyed from circulation. Useful for tracking stablecoin supply contraction and redemption activity.
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
0x2d270e6886d130d724215a266106e6832161eaedfalse9997455390xfd78ee919681417d192449715b2594ab58f5d0023260685102025-10-04T08:35:21.000Z0x47015fa39aa14f53e843fead1a91d4765691a3b43f8752aaa23a7163d029f59c
0x2d270e6886d130d724215a266106e6832161eaedfalse9997504500xfd78ee919681417d192449715b2594ab58f5d0023260642092025-10-04T07:23:40.000Z0x26cf5a37f1886801ad48ff55a9b0c90eb1393abc563fe2c4b3c08ef7156cd8b5
0x2d270e6886d130d724215a266106e6832161eaedfalse9997433040xfd78ee919681417d192449715b2594ab58f5d0023260847882025-10-04T13:06:39.000Z0x99baf251a45fea494216efce5aa78cabcc00944494aa8fdbdd3612ab8954a149
Query with partition filter
SELECT *
FROM `tt-contracts.circle_v1_ink.FiatTokenV2_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FiatTokenV2_Mint_event

Circle USDC minting events on Ink L2 showing new token issuance by authorized minters to recipient addresses. Tracks fiat-backed stablecoin supply expansion for analyzing circulation growth and minter activity patterns.
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
0x4ddbcb71cea1850250204d13fbefd352f3975aaf0x2d270e6886d130d724215a266106e6832161eaedfalse17025803110xfd78ee919681417d192449715b2594ab58f5d0020293306552025-11-11T02:44:26.000Z0xe8a22c4a486ef1a3c2a7808f059249483e60141ada22d4ca1480e6ef473fceaf
0x4cee8248992bfc9fa9744979e239271ed97670e10x2d270e6886d130d724215a266106e6832161eaedfalse400000xfd78ee919681417d192449715b2594ab58f5d0023293513142025-11-11T08:28:45.000Z0xb6c0deba3153d136fbccd3f8b25f9cc17fe3340d7ccfbf03b0a79665c7e5ae81
0xe41770b84a0b691d30c580b12d0a8c048fb7426f0x2d270e6886d130d724215a266106e6832161eaedfalse3999600000xfd78ee919681417d192449715b2594ab58f5d0021293513142025-11-11T08:28:45.000Z0xb6c0deba3153d136fbccd3f8b25f9cc17fe3340d7ccfbf03b0a79665c7e5ae81
Query with partition filter
SELECT *
FROM `tt-contracts.circle_v1_ink.FiatTokenV2_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100