circle_v1_base

Tables

EURC_Burn_event

EURC token burn events on Basechain, recording the destruction of Euro Coin (EURC) stablecoin supply with burner addresses and amounts. Used for tracking EURC supply contraction and analyzing redemption patterns from Circle’s reserve.

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
0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42	false	269477940000	0x6a8b792db7c6cff061f721c5f3791a654ee1c9c6	403	26896337	2025-02-26T15:00:21.000Z	0x890bdc79042961877576a0fcdc402f532497f95011baa5a371e738c38fb2c675
0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42	false	20000	0xad72249c80699abc2eaed5c66b0300f8631fca96	584	26906476	2025-02-26T20:38:19.000Z	0x2f094d157f81b17a25706672db820280c853642f88061fb21613a025ab7fde1b
0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42	false	134310000	0x6a8b792db7c6cff061f721c5f3791a654ee1c9c6	528	30511690	2025-05-21T07:32:07.000Z	0x5d004d8584514f20ee36236efa041ba080edb63ec3cace52c108d9679f576787

Example Query

Query with partition filter

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

EURC_Mint_event

EURC token minting events on Base, tracking the creation of new Euro Coin (EURC) stablecoin supply with minter addresses, recipient addresses, and amounts. Used for monitoring EURC supply expansion and authorized minting activity.

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
0x6a8b792db7c6cff061f721c5f3791a654ee1c9c6	0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42	false	25000000000	0xe03e1ba6e5b1a15105e00d27a1000bfdda4fe686	563	28139298	2025-03-27T09:32:23.000Z	0xead30a9e5fdc4f985a6b5be2f7686154644221a0b2796cc6158046b5e9bd0d4c
0x6a8b792db7c6cff061f721c5f3791a654ee1c9c6	0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42	false	67898750000	0xe03e1ba6e5b1a15105e00d27a1000bfdda4fe686	207	19406259	2024-09-06T05:51:05.000Z	0xf378344bda933ab091f9263256739df03223a033b443688784953f0dd8d2939a
0x6a8b792db7c6cff061f721c5f3791a654ee1c9c6	0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42	false	526620000	0xe03e1ba6e5b1a15105e00d27a1000bfdda4fe686	132	17245575	2024-07-18T05:28:17.000Z	0x5bc0965583b23baf32e5504d95f378fee900dd6efff277fd69e483ee4366c049

Example Query

Query with partition filter

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

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
0x1682ae6375c4e4a97e4b583bc394c861a46d8962	false	238120	24800000	302	17375599	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0xb6615b2662b35fc3533f8479002e62d0523341de	2024-07-21T05:42:25.000Z	0x000000000000000000000000a20ef574645f50d67b9c1e15df3c864e52db4d60	0x45eff1272c802511810bb2312504e786ab94a68e284c21c69eddd0d63f28c9ab	0x000000000000000000000000691cf4641d5608f085b2c1921172120bb603d074	4	0x00000000000000000000000057d4eaf1091577a6b7d121202afbd2808134f117
0x1682ae6375c4e4a97e4b583bc394c861a46d8962	false	238132	19412402	232	17376285	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0xb6615b2662b35fc3533f8479002e62d0523341de	2024-07-21T06:05:17.000Z	0x000000000000000000000000a20ef574645f50d67b9c1e15df3c864e52db4d60	0x08b942a8ec17217b728bdeea3192ef64313a33581f705a3d8898fe635d8df893	0x000000000000000000000000691cf4641d5608f085b2c1921172120bb603d074	4	0x00000000000000000000000057d4eaf1091577a6b7d121202afbd2808134f117
0x1682ae6375c4e4a97e4b583bc394c861a46d8962	false	238118	19800000	136	17375345	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0xb6615b2662b35fc3533f8479002e62d0523341de	2024-07-21T05:33:57.000Z	0x000000000000000000000000a20ef574645f50d67b9c1e15df3c864e52db4d60	0xed204a31b623901daae86c895fe5ba109e16dd0c0042720b75e9f4288fd0cb7e	0x000000000000000000000000691cf4641d5608f085b2c1921172120bb603d074	4	0x00000000000000000000000057d4eaf1091577a6b7d121202afbd2808134f117

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.circle_v1_base.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
0x1682ae6375c4e4a97e4b583bc394c861a46d8962	false	1721290	2	15757945	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	2024-06-13T19:00:37.000Z	0x0afd1c5335eb7a4d32c49ed72cb6f9f58b3fe9ad	0x0c8b706ea56a4cd1791ce63ec8677f59a06d3c0b457ee9310b3024eff92ba0e9
0x1682ae6375c4e4a97e4b583bc394c861a46d8962	false	220903235	2	15762072	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	2024-06-13T21:18:11.000Z	0x27eae3744353fb77e3935f70a8a588ca9a6b7378	0xf8aa7b3e15d89a348daa1d553d56d63c0c04f49c2a0280e436c1c42f4478059f
0x1682ae6375c4e4a97e4b583bc394c861a46d8962	false	78472560650	2	15750920	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	2024-06-13T15:06:27.000Z	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	0xece4ff6fbe75f283f995e1548f9baf3fdaaad791cd0f97d46456092fba4e6525

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.circle_v1_base.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
0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	false	10000000	0xaac391f166f33cdaefaa4afa6616a3bea66b694d	9	3796636	2023-09-10T21:50:19.000Z	0x21963623dd53150a85b8f62a5898e8122d416c5dc18983cf14a4dc1275bcb708
0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	false	2000000000	0xaac391f166f33cdaefaa4afa6616a3bea66b694d	6	3793959	2023-09-10T20:21:05.000Z	0xaa9fd5762414eeb1ad24fa9cdebbf92dec37206cc0fb06c0dfdc9c4e14b0c97c
0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	false	6085469830000	0x6a8b792db7c6cff061f721c5f3791a654ee1c9c6	269	35966652	2025-09-24T14:04:11.000Z	0x41e12de788b66219e741ec23c1540281db5d07fa0c6e2abcbe0d42f8856b8442

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.circle_v1_base.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
0x804fd8228bc5a02db6cda3ffa96a9c6b6d49b1e7	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	false	99750000	0xe45b133ddc64be80252b0e9c75a8e74ef280eed6	0	30053032	2025-05-10T16:43:31.000Z	0x67d7d66533bfcc939f1311b71c2400aefda6a22b38d92b186e27dc0893b328e9
0x0b20a6140118be0235db1bcb0dfa96d5d656ca51	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	false	4000000000	0xe45b133ddc64be80252b0e9c75a8e74ef280eed6	7	30038812	2025-05-10T08:49:31.000Z	0x089fa92513387787c961f576c7af83528415f573f8fba5147ef7fe7c1906a4d4
0x855fa5b6194358142ffb487d5070176ea0d5f80a	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	false	7677000000	0xe45b133ddc64be80252b0e9c75a8e74ef280eed6	11	30026345	2025-05-10T01:53:57.000Z	0xe786d31a3878194536ca355b9b753019ef599c6ff019d1956df688fec45226d6

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

EURC_Burn_event

EURC_Mint_event

TokenMessenger_DepositForBurn_event

TokenMessenger_MintAndWithdraw_event

USDC_Burn_event

USDC_Mint_event

​Tables

​EURC_Burn_event

​EURC_Mint_event

​TokenMessenger_DepositForBurn_event

​TokenMessenger_MintAndWithdraw_event

​USDC_Burn_event

​USDC_Mint_event

Tables

EURC_Burn_event

EURC_Mint_event

TokenMessenger_DepositForBurn_event

TokenMessenger_MintAndWithdraw_event

USDC_Burn_event

USDC_Mint_event