circle_v1_zksyncera

Tables

USDC_Blacklisted_event

Circle USDC blacklist events on zkSync Era showing addresses added to or removed from the USDC token’s blacklist. Used for tracking compliance actions and analyzing which accounts are restricted from transferring USDC.

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__account`	`STRING`	Account address that received or was affected by the token operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in__account	block_number	block_timestamp	transaction_hash
0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	769	0x4ea7eefc2dcb250c1f069ecaf1e2ae3488059ac2	30034219	2024-03-27T23:23:52.000Z	0x23f2bc0122505e27a28a18380c83e0002016cf1f868c36dfa578d7f7b18a8a88
0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	50	0xe950dc316b836e4eefb8308bf32bf7c72a1358ff	30034200	2024-03-27T23:23:21.000Z	0xaccf3cb6bbe6017268b438837ca8ac409215c0e3225f48885dc3e725f7358793
0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	173	0xdda5554510366179ddb442b8a82bc737c3ac77c5	29996071	2024-03-27T12:15:52.000Z	0x4595c6c0d381f264096800801f6e458ff668a264e50a53b282b407b786e21476

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.circle_v1_zksyncera.USDC_Blacklisted_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
0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	1843918390000	0x76857519a767acf1aa5b84f3a8d7ccff1918fc7f	15	63217309	2025-07-22T12:01:20.000Z	0xf0329adccbf3619cd16519290eb2a49690065f9c11402421fe8aa3d1db1102c2
0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	1000000	0xc683e9e12fbedac0bbe1baa97b7d1f9a3a957d25	4	63844149	2025-08-08T21:34:12.000Z	0x57c8d1c007ee4d9f6ed0c6e34be4e77fab1d28a097d2ba1458425cb04b50a7af
0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	1313304100000	0x76857519a767acf1aa5b84f3a8d7ccff1918fc7f	4	63832007	2025-08-08T13:33:03.000Z	0x92f16fe8feb97d55109475046b684dc3e0aa2c3055200a0e98c611dedf9b409e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.circle_v1_zksyncera.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
0x76857519a767acf1aa5b84f3a8d7ccff1918fc7f	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	40000000000	0xdb5c8b2e895c9ce6c648c34d828cd08d64cd472a	1	50109361	2024-11-29T21:25:23.000Z	0x976ae67ab708bd3c8a422b7b2cb3e6473a3ea80c2c1c7f564c5d14242b42b1fa
0x4504417aacba5e018fa66e7fcfd9a08016e7324e	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	26993990000	0xdb5c8b2e895c9ce6c648c34d828cd08d64cd472a	4	50114122	2024-11-29T23:08:24.000Z	0x095170d9d198659e8a5b10469b199541d7049aa40021518c2ca9568096051ca5
0x76857519a767acf1aa5b84f3a8d7ccff1918fc7f	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	310206480000	0xdb5c8b2e895c9ce6c648c34d828cd08d64cd472a	10	42679242	2024-08-26T22:00:24.000Z	0x6d1b68f4db1cbb54d4c462da7006b82ef562596da8380466a81034c3057817fe

Example Query

Query with partition filter

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

USDC_UnBlacklisted_event

Records of addresses removed from the USDC blacklist on zkSync Era, emitted by Circle’s USDC contract when accounts regain transfer permissions. Used for tracking compliance actions and monitoring Circle’s blacklist management 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__account`	`STRING`	Account address that received or was affected by the token operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in__account	block_number	block_timestamp	transaction_hash
0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	16	0xfa3576591b710cd8a68f22fc10281f39f88d8cb1	64613765	2025-09-12T14:35:22.000Z	0xb9250c52e62548b3b1b0e3d4ff48918bfb2f0b387a0f9af0a79d926a14a3a6da
0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	13	0x6acdfba02d390b97ac2b2d42a63e85293bcc160e	25948276	2024-02-06T22:57:07.000Z	0x0e8732c1bfeaae3791707a4137058e34d331f5b7e7b78632c6ec22b7a190075f
0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	false	85	0x21b743e73d63d300d986910681d45387880b334b	27084436	2024-02-20T20:59:30.000Z	0xce54abc00d94e5359300a29fed803677afac031a576cc73ca41af3cf6cbf8002

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

USDC_Blacklisted_event

USDC_Burn_event

USDC_Mint_event

USDC_UnBlacklisted_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​USDC_Blacklisted_event

​USDC_Burn_event

​USDC_Mint_event

​USDC_UnBlacklisted_event

Tables

USDC_Blacklisted_event

USDC_Burn_event

USDC_Mint_event

USDC_UnBlacklisted_event