circle_v1_optimism

Tables

TokenMessenger_DepositForBurn_event

Circle Cross-Chain Transfer Protocol (CCTP) token burn event initiated by depositors requesting cross-chain USDC transfers. Records burn amounts, destination chain domains, recipient addresses, and fee parameters for attestation-based minting on target 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_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_burnToken`	`STRING`	Contract address of the token being burned in the cross-chain transfer 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.
`in_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in_mintRecipient`	`STRING`	Address designated to receive the minted tokens on the destination chain. Hex-encoded string, zero-padded to 66 characters for cross-chain compatibility.
`in_destinationDomain`	`STRING`	Numeric identifier for the blockchain where tokens will be minted after the cross-chain transfer. Circle CCTP (Cross-Chain Transfer Protocol) domain identifier represented as a string.
`in_destinationTokenMessenger`	`STRING`	Contract address of the TokenMessenger contract on the destination chain that will handle the minting operation. Hex-encoded string, zero-padded to 66 characters for cross-chain compatibility.
`in_destinationCaller`	`STRING`	Address authorized to call the mint function on the destination chain. Hex-encoded string, zero-padded to 66 characters, or zero address if no specific caller is designated.

Sample Data

address	removed	in_nonce	in_amount	log_index	block_number	in_burnToken	in_depositor	block_timestamp	in_mintRecipient	transaction_hash	in_destinationCaller	in_destinationTokenMessenger
0x2b4069517957735be00cee0fadae88a26365528f	false	332537	1554799437	89	138614461	0x0b2c639c533813f4aa9d7837caf62653d097ff85	0x00071508db163ee69814aad31562f44b787c2d4d	2025-07-18T08:34:59.000Z	0x00000000000000000000000000071508db163ee69814aad31562f44b787c2d4d	0x8977b22b78c6b81a964ed834e25a9b4e1d524b0dd3e76ff479091843abee632b	0x0000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000bd3fa81b58ba92a82136038b25adec7066af3155
0x2b4069517957735be00cee0fadae88a26365528f	false	332580	1430798812	73	138622027	0x0b2c639c533813f4aa9d7837caf62653d097ff85	0x08b00ceee2fb66029b53d76110b19eeaabfd1e65	2025-07-18T12:47:11.000Z	0x00000000000000000000000008b00ceee2fb66029b53d76110b19eeaabfd1e65	0x85f0a45d5c5b495d3b6a00590aec2d04e5b788213577fa89d1a0b2fda734cfcb	0x0000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000bd3fa81b58ba92a82136038b25adec7066af3155
0x2b4069517957735be00cee0fadae88a26365528f	false	332569	221958	233	138619449	0x0b2c639c533813f4aa9d7837caf62653d097ff85	0x3a23f943181408eac424116af7b7790c94cb97a5	2025-07-18T11:21:15.000Z	0x000000000000000000000000190bfe3b938de0f123e0ba6a212aa7606ec29152	0xc1ba63b04d57a27803d080587358df0efeee5db528424942d376dad3572754ef	0x0000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000bd3fa81b58ba92a82136038b25adec7066af3155

Example Query

Query with partition filter

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

TokenMessenger_MintAndWithdraw_event

Circle Cross-Chain Transfer Protocol (CCTP) events recording successful token mints with simultaneous withdrawals to recipients. Captures the token address, mint amount, recipient address, and optional fees collected during cross-chain USDC transfers 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_mintRecipient`	`STRING`	Address designated to receive the minted tokens on the destination chain. Hex-encoded string, zero-padded to 66 characters for cross-chain compatibility.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_mintToken`	`STRING`	Contract address of the token being minted. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	in_mintToken	block_timestamp	in_mintRecipient	transaction_hash
0x2b4069517957735be00cee0fadae88a26365528f	false	5200000	83	133023817	0x0b2c639c533813f4aa9d7837caf62653d097ff85	2025-03-10T22:40:11.000Z	0x00b9228eb19a13c6a943b350916dd2aa7f182c21	0xf00a707141f3d4ecc6eb42e6fb423266d913da82b5c785350dff11c20bb5d13d
0x2b4069517957735be00cee0fadae88a26365528f	false	1228000000	15	133005596	0x0b2c639c533813f4aa9d7837caf62653d097ff85	2025-03-10T12:32:49.000Z	0x03aa0bd3e460e6c49c011d5d090b166cefaebb18	0x2581b8195fdc0f39948cf08b0a83e6cf43d5af87b06b23330a6c0acff485d5b4
0x2b4069517957735be00cee0fadae88a26365528f	false	379989950	113	133002546	0x0b2c639c533813f4aa9d7837caf62653d097ff85	2025-03-10T10:51:09.000Z	0x058039c7d560d2c21fea88ccd3c7cbd6f2500201	0x0d003f90200030681dbf23a566c5a66bcfde6f24db0be1b16ea575f1c653a1b1

Example Query

Query with partition filter

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

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
0x0b2c639c533813f4aa9d7837caf62653d097ff85	false	3550667870000	0x0a22ea6f459432220c407bf15e18946ab11e81a3	4	114312882	2024-01-02T19:42:21.000Z	0x8988cd66b4a6f4c40782c3a1cf6c1ed4d7c44377a167f0ca44bed0ae71cad95e
0x0b2c639c533813f4aa9d7837caf62653d097ff85	false	52846470000	0x0a22ea6f459432220c407bf15e18946ab11e81a3	4	114306009	2024-01-02T15:53:15.000Z	0x2a03128f8fca95fcb9a1740975f4a0098b65de0f03b7715bafecf42d9191623f
0x0b2c639c533813f4aa9d7837caf62653d097ff85	false	48396000000	0x0a22ea6f459432220c407bf15e18946ab11e81a3	10	114306069	2024-01-02T15:55:15.000Z	0x16cdbdaabd4847d058a7b26022390932dbb7dca6816e684d6c58c09d7f1a68a6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.circle_v1_optimism.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
0x04486546cddd63388d180eab0c7ab693fb012e8e	0x0b2c639c533813f4aa9d7837caf62653d097ff85	false	50000000	0x33e76c5c31cb928dc6fe6487ab3b2c0769b1a1e3	3	136320989	2025-05-26T06:25:55.000Z	0x2a20eb1f144d54882e739357113ce2608ad39bfa4882071c249dbd748df503fe
0x07df760dd27858ead253a32e63beb00f7965c263	0x0b2c639c533813f4aa9d7837caf62653d097ff85	false	32590853	0x33e76c5c31cb928dc6fe6487ab3b2c0769b1a1e3	20	136335956	2025-05-26T14:44:49.000Z	0x32d80c7c64ba257220bd82928cfbbfafa49d6e5e58af85cc65a50d73cbad5d08
0x084e84446fe08b27d1b7106ef4d29f813708d729	0x0b2c639c533813f4aa9d7837caf62653d097ff85	false	3013126591	0x33e76c5c31cb928dc6fe6487ab3b2c0769b1a1e3	6	136350740	2025-05-26T22:57:37.000Z	0x11c3a6a8c6f5f874872e72fc5836c5c93b77b81b11367d42d4a37a2cf1f5b6d8

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

TokenMessenger_DepositForBurn_event

TokenMessenger_MintAndWithdraw_event

USDC_Burn_event

USDC_Mint_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​TokenMessenger_DepositForBurn_event

​TokenMessenger_MintAndWithdraw_event

​USDC_Burn_event

​USDC_Mint_event

Tables

TokenMessenger_DepositForBurn_event

TokenMessenger_MintAndWithdraw_event

USDC_Burn_event

USDC_Mint_event