circle_v1_unichain

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_destinationDomain	in_destinationTokenMessenger
0x4e744b28e787c3ad0e810ed65a24461d4ac5a762	false	7	1	4	2695508	0x078d782b760474a361dda0af3839290b0ef57ad6	0x1bbeece1f6cf04677b618bbf811e47d5339f3121	2024-12-06T00:11:07.000Z	0x00000000000000000000000010b4cd310e8168727bfd96fa2d9192dc84d336d8	0x9f9d9b01fe4b2d20ba5d02c51e60be2d3d21378b16c6e6e36e58e736e3c8957d	0x0000000000000000000000000000000000000000000000000000000000000000	4	0x00000000000000000000000057d4eaf1091577a6b7d121202afbd2808134f117
0x4e744b28e787c3ad0e810ed65a24461d4ac5a762	false	8	1	4	2700292	0x078d782b760474a361dda0af3839290b0ef57ad6	0x1bbeece1f6cf04677b618bbf811e47d5339f3121	2024-12-06T01:30:51.000Z	0x0000000000000000000000001bbeece1f6cf04677b618bbf811e47d5339f3121	0x1986cf38832b319bc66e548939ca0ca82b974870ec6074d9b84fcc5102e9b911	0x0000000000000000000000000000000000000000000000000000000000000000	3	0x00000000000000000000000019330d10d9cc8751218eaf51e8885d058642e08a
0x4e744b28e787c3ad0e810ed65a24461d4ac5a762	false	10	1	4	2701445	0x078d782b760474a361dda0af3839290b0ef57ad6	0x1bbeece1f6cf04677b618bbf811e47d5339f3121	2024-12-06T01:50:04.000Z	0x9bc411a2033b51c4e3fe79229dd4474901efa7b44d53475f1ea59f8f458c7428	0x3a95a1743813a4441f5a72d7a33e579a80f6bd8c6f3c47a7db0e50e9c7e26974	0x0000000000000000000000000000000000000000000000000000000000000000	5	0xa65fc943419a5ad590042fd67c9791fd015acf53a54cc823edb8ff81b9ed722e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.circle_v1_unichain.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
0x4e744b28e787c3ad0e810ed65a24461d4ac5a762	false	331538245	2	14271727	0x078d782b760474a361dda0af3839290b0ef57ad6	2025-04-18T23:48:06.000Z	0x875d6d37ec55c8cf220b9e5080717549d8aa8eca	0x81051331361478276d4b2a98dd86057096f47fe13f8f463df1f21b948ba505ae
0x4e744b28e787c3ad0e810ed65a24461d4ac5a762	false	202321420408	2	14200328	0x078d782b760474a361dda0af3839290b0ef57ad6	2025-04-18T03:58:07.000Z	0xcf303b88667f5da7031c7c84e9cf2195e1482220	0xc18e9abaa93d8263ad50060f75c572ec9a244163900761ccb404c12b1a0eea98
0x4e744b28e787c3ad0e810ed65a24461d4ac5a762	false	141359558710	2	14205543	0x078d782b760474a361dda0af3839290b0ef57ad6	2025-04-18T05:25:02.000Z	0xcf303b88667f5da7031c7c84e9cf2195e1482220	0xc47f6e0d0d3378f89f589550917ccee6659a14e6772ae5d125dc889431c690e0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.circle_v1_unichain.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
0x078d782b760474a361dda0af3839290b0ef57ad6	false	101228814	0x726bfef3cbb3f8af7d8cb141e78f86ae43c34163	1	12935086	2025-04-03T12:30:45.000Z	0xdde88b2f2a07a7d133b41533b68de0e998e3e08b559ca3d30a3cb4b314a6b6b1
0x078d782b760474a361dda0af3839290b0ef57ad6	false	101957453	0x726bfef3cbb3f8af7d8cb141e78f86ae43c34163	1	12935628	2025-04-03T12:39:47.000Z	0x83e2c567c1f9ba3269271ac105c500871db5f7269f3ff4e375e9f9c276eb3095
0x078d782b760474a361dda0af3839290b0ef57ad6	false	103837845	0x726bfef3cbb3f8af7d8cb141e78f86ae43c34163	1	12932357	2025-04-03T11:45:16.000Z	0xd5c9d8723157cde95a6f0b565a85b840d317e480b0fbdb2a66c7abb60fe00bdc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.circle_v1_unichain.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
0x04d7bcf273c5b0deb7ce3f59f70be6bf933c47c7	0x078d782b760474a361dda0af3839290b0ef57ad6	false	1111552364	0x726bfef3cbb3f8af7d8cb141e78f86ae43c34163	4	19391522	2025-06-17T05:58:01.000Z	0x4e1c646dd2666a4f26644aa162012ebd7443d962bf10afa5422c275246a4e367
0x07ae8551be970cb1cca11dd7a11f47ae82e70e67	0x078d782b760474a361dda0af3839290b0ef57ad6	false	97714647787	0x726bfef3cbb3f8af7d8cb141e78f86ae43c34163	0	19417600	2025-06-17T13:12:39.000Z	0x77c7f8a8712719e2a29875fe9a5d1bb2d11b9c626232071c6d803aa5dee3dcc8
0x07ae8551be970cb1cca11dd7a11f47ae82e70e67	0x078d782b760474a361dda0af3839290b0ef57ad6	false	72225523964	0x726bfef3cbb3f8af7d8cb141e78f86ae43c34163	1	19438657	2025-06-17T19:03:36.000Z	0xa2e1bd54bee81bda6b6500e1b34310e03f4728fe1684f38cb555fdf011bfcdf0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.circle_v1_unichain.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