> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# circle_v1_zksyncera

> Tables in tt-contracts.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.

<Accordion title="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.                                 |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.circle_v1_zksyncera.USDC_Blacklisted_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.circle_v1_zksyncera.USDC_Burn_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.circle_v1_zksyncera.USDC_Mint_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                 |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.circle_v1_zksyncera.USDC_UnBlacklisted_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***