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

# syncswap_v1_scroll

> Tables in tt-contracts.syncswap_v1_scroll

## Tables

### ClassicPool\_Burn\_event

Liquidity removal events from SyncSwap V1 ClassicPool contracts on Scroll, capturing LP token burns with withdrawn token amounts and recipient addresses. Used for analyzing liquidity provider withdrawals and pool reserves changes.

<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_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
  | `in_amount0`       | `STRING`    | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_amount1`       | `STRING`    | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_liquidity`     | `STRING`    | Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.                 |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | in\_amount0       | in\_amount1           | block\_number | in\_liquidity       | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------- | --------------------- | ------------- | ------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x3aa964562fefa65434dfd6f5c0d52d3bb50615e3 | 0x054641825533d1bc3324df3c30cbc3baea812087 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 8          | 89008575838210634 | 587331305278789901770 | 15495461      | 5536563782894494997 | 2025-05-15T13:39:20.000Z | 0x33a5f28707cd6b52b694a1139dd1522efee811ea6eee5d3113a318ed36cd929b |
  | 0x1bcb73c5ac7ea75d816fb96ebfaf0c8f21f42b71 | 0x054641825533d1bc3324df3c30cbc3baea812087 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 8          | 89762419060117085 | 587675056949412384621 | 15492394      | 5561624935922609706 | 2025-05-15T12:35:35.000Z | 0x6638c6406592f8272a4b3d72c063830d866f7304bf84d5f98dc317c627a11940 |
  | 0x1048d64052f227b2a68ec7ad825b14c949cfe013 | 0x1452b3bc70087599b22086009bb6c179b7f47b37 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 5          | 42106143813594589 | 40756945487922306     | 15479872      | 38616075048179632   | 2025-05-15T08:04:07.000Z | 0xe8aac6f1ff3d45e7164ccfe30b5edc196c02d0b2f49075a0a8eaf7bf5229e537 |
</Accordion>

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

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

***

### ClassicPool\_Mint\_event

Liquidity provision events from SyncSwap V1 ClassicPool contracts on Scroll, capturing mint operations where users add token pairs to pools. Records deposited token amounts, minted liquidity shares, and recipient addresses for tracking liquidity provider positions and pool growth.

<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_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
  | `in_amount0`       | `STRING`    | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_amount1`       | `STRING`    | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_liquidity`     | `STRING`    | Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.                 |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | in\_amount0      | in\_amount1      | block\_number | in\_liquidity    | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------------- | ---------------- | ------------- | ---------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xeb2882ca0803c287d230264c7c585c849b099d63 | 0x1452b3bc70087599b22086009bb6c179b7f47b37 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 73         | 9799437020495664 | 9429937431348931 | 7903438       | 9136631371938355 | 2024-07-30T06:28:47.000Z | 0x9ebfa9a074c6410d2d34db2ae0bb250ffd4a3dbdc80e941a32f9fc5264d30f9a |
  | 0x8e112776eff3ddb710458a27bd4c0a444a9024c4 | 0x1452b3bc70087599b22086009bb6c179b7f47b37 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 61         | 8237953444607771 | 7927331476547149 | 7910464       | 7680431360475214 | 2024-07-30T11:59:43.000Z | 0x00df7b61934ae006c19f6afaab8371296dea59032a26d926c931c15e8d0b6e0c |
  | 0x7b536747adc6aed7e151996042feb24faf0e93c5 | 0x1452b3bc70087599b22086009bb6c179b7f47b37 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 5          | 7087441703253898 | 6820201167703084 | 7911450       | 6607750376878106 | 2024-07-30T12:45:50.000Z | 0x933ed1effafb754bcd8dc7ef4d4ce02d16f04e05fe34814349c95e95fc4953b7 |
</Accordion>

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

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

***

### ClassicPool\_Swap\_event

Swap event records from SyncSwap v1 ClassicPool automated market maker (AMM) on Scroll, capturing token exchange amounts and participant addresses. Used for analyzing DEX trading volume, price impact, and liquidity pool 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_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                   |
  | `in_amount0In`     | `STRING`    | Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.   |
  | `in_amount1In`     | `STRING`    | Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.   |
  | `in_amount0Out`    | `STRING`    | Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
  | `in_amount1Out`    | `STRING`    | Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                       |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | block\_number | in\_amount0In     | in\_amount1In | in\_amount0Out | in\_amount1Out | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ----------------- | ------------- | -------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xb450ceba37789006c5b1e09e9163c1ab04afcd18 | 0x78ea8e533c834049de625e05f0b4deffe9db5f6e | false   | 0x80e38291e06339d10aab483c65695d004dbd5c69 | 0          | 3229578       | 13439276702861170 | 0             | 0              | 33494591       | 2024-02-10T23:08:22.000Z | 0x029fb871ce5c1a4ee9ea86f8c0174c6ffd9040f8d17aeb25523f07f5266dbe23 |
  | 0xf2e8488c00736a9aa9c06231c0171620f8bf2fdb | 0x78ea8e533c834049de625e05f0b4deffe9db5f6e | false   | 0x80e38291e06339d10aab483c65695d004dbd5c69 | 0          | 3218223       | 94160000000000000 | 0             | 0              | 233402886      | 2024-02-10T13:36:46.000Z | 0x2a581c2278cee1a2d7e324025af4cde40c56d96074aadeabf8e8cd3b446b1f52 |
  | 0x81c05d2746e07ab631e29c82a30ba8357110f988 | 0x78ea8e533c834049de625e05f0b4deffe9db5f6e | false   | 0x80e38291e06339d10aab483c65695d004dbd5c69 | 0          | 3212735       | 100000000000000   | 0             | 0              | 248601         | 2024-02-10T09:01:50.000Z | 0x46dee129f3185711c57942ced3f3f5f63e20a14c0a4ffc627f2a62abf858a9ad |
</Accordion>

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

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

***

### ClassicPool\_Sync\_event

Reserve balance updates from SyncSwap V1 ClassicPool contracts on Scroll. Captures token pair reserves (reserve0/reserve1) after each liquidity or swap event for tracking automated market maker (AMM) pool state changes.

<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_reserve0`      | `STRING`    | Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.  |
  | `in_reserve1`      | `STRING`    | Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_reserve0     | in\_reserve1          | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ---------------- | --------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x03fc29bc5f9398965264cf3fb76348dd414e0c67 | false   | 2          | 8829435530005352 | 253021224461199120182 | 11739091      | 2024-12-08T07:11:04.000Z | 0x3c8c1098c82fce3225b319eb09d2fa605720577dc9862f603aeb1ca02602d941 |
  | 0x03fc29bc5f9398965264cf3fb76348dd414e0c67 | false   | 3          | 8718920723247864 | 256101621349068056448 | 11734537      | 2024-12-08T02:13:30.000Z | 0xeb54829bf38375c73142b09b172f3ed0f75381fe71c0981a21e2024359aac353 |
  | 0x03fc29bc5f9398965264cf3fb76348dd414e0c67 | false   | 3          | 8629066002156035 | 258776171349068056448 | 11734645      | 2024-12-08T02:20:26.000Z | 0x04b19a93a21b3b6d83ea45e0f1650aaca77726d5bf1f99c52a98fe3d1b378acc |
</Accordion>

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

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

***

### ClassicPoolFactory\_PoolCreated\_event

Liquidity pool creation events from SyncSwap V1 decentralized exchange (DEX) on Scroll, capturing new trading pairs deployed through the ClassicPoolFactory contract. Used to track pool deployments, token pair listings, and DEX ecosystem growth over time.

<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_token0`        | `STRING`    | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                              |
  | `in_token1`        | `STRING`    | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                             |
  | `in_pool`          | `STRING`    | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.                                           |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pool                                   | removed | in\_token0                                 | in\_token1                                 | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x37bac764494c8db4e54bde72f6965bea9fa0ac2d | 0xbc7294c9d7f705e31c54a7a6cf16b8c71bb0175a | false   | 0x2b2e9a056ebaac66149789ee1da240aa62a28d71 | 0x5300000000000000000000000000000000000004 | 34         | 4772748       | 2024-04-11T00:28:32.000Z | 0x87fa1b45e64b6a930fcea0bf3f8402b3afa6215cb60779bb54fcbc4fbaa9c3ae |
  | 0x37bac764494c8db4e54bde72f6965bea9fa0ac2d | 0xee0e802b0f68023dc029d568d337f25e292cff8a | false   | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 0x32f451f49f0833d68afa02c7d987bdeec4084be6 | 4          | 706077        | 2023-11-10T15:21:52.000Z | 0xdbdcff7b0b71946423ad080951dc5e098c250cd54e4a7ad444bcaffe9a20bedb |
  | 0x37bac764494c8db4e54bde72f6965bea9fa0ac2d | 0xd03e4c80cc9594740154210f3b14d8c9d463baa2 | false   | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 0x412b71691317ffbde8d539986d9d62ca93de8233 | 1          | 706081        | 2023-11-10T15:22:04.000Z | 0x7285bd2857e5ffad4b0cc4153f412229de845799bef7671e61a2b45fc78bffce |
</Accordion>

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

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

***

### FeeRecipient\_NotifyFees\_event

Fee notification events from SyncSwap v1 decentralized exchange on Scroll, recording token amounts, fee rates, and fee types collected by the protocol. Used for analyzing fee revenue distribution and liquidity provider earnings across trading pairs.

<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_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                          |
  | `in_feeType`       | `STRING`    | Enumerated identifier for the category or classification of fee being charged or updated. Integer or string-encoded numeric value representing distinct fee type codes.                                      |
  | `in_token`         | `STRING`    | Token address involved in the transaction or 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_feeRate`       | `STRING`    | Fee rate applied to this transaction expressed in basis points, where 20000 represents 2% (20000/1000000). This value determines the percentage of the transaction amount collected as fees by the protocol. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_token                                  | in\_amount         | in\_sender                                 | log\_index | in\_feeRate | in\_feeType | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ------------------ | ------------------------------------------ | ---------- | ----------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xa2a09f15c2ec6af1b8f9413c148334b231410bd8 | false   | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | 390433152615194175 | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | 94         | 20000       | 2           | 6293076       | 2024-06-05T10:06:28.000Z | 0x8e99ebd0ada2a8d2fac9608e59b8d024fb60a0461ca6ae2771d035c6b89750d4 |
  | 0xa2a09f15c2ec6af1b8f9413c148334b231410bd8 | false   | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | 18540210215367640  | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | 69         | 20000       | 2           | 6289506       | 2024-06-05T07:06:00.000Z | 0xaf287129bf9bf5defa831ade4b12fbd37963d42eaaea24d33eadb5cecb846e2e |
  | 0xa2a09f15c2ec6af1b8f9413c148334b231410bd8 | false   | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | 414902203557043311 | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | 63         | 20000       | 2           | 6291250       | 2024-06-05T08:33:12.000Z | 0xc730bb325a19de8ca31590798aa042d700d88358e851b537aa091d16f8ac75c4 |
</Accordion>

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

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

***

### StablePool\_Burn\_event

Liquidity removal events from SyncSwap V1 stableswap pools on Scroll, recording LP token burns and withdrawn token amounts. Tracks liquidity provider exits with sender/recipient addresses and token pair withdrawal quantities for analyzing pool depth changes and exit patterns.

<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_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
  | `in_amount0`       | `STRING`    | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_amount1`       | `STRING`    | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_liquidity`     | `STRING`    | Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.                 |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_liquidity          | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------- | ----------- | ------------- | ---------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x200db8540e00b024357db9b48a004b467401eeb7 | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 6          | 1499631228  | 0           | 8015432       | 1266000000000000000000 | 2024-08-03T01:30:00.000Z | 0x673b17c150753ae604ef4b239fdad326246dbac3799122f69375b767940826b8 |
  | 0x1ec700001faac176cc153b684a2c3400bad61131 | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 6          | 68356667    | 128941532   | 8022853       | 166440979138511548918  | 2024-08-03T07:36:36.000Z | 0x00105de40833377be55f9b662bcd682872ba97069b864f8cc7a44721c8f260f8 |
  | 0xd47db5c36febd1c002f9e157e2b3cabde7c72c4d | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 6          | 0           | 35566589    | 8024748       | 30000000000000000000   | 2024-08-03T09:06:55.000Z | 0x1e7819c9bd07999b878fc9dc6b932d646f55b83f262cf38d00edafe4a6d5dd83 |
</Accordion>

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

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

***

### StablePool\_Mint\_event

Liquidity provision events from SyncSwap V1 StablePool on Scroll, recording deposits of token pairs with amounts and LP tokens minted. Used to track liquidity provider positions and pool growth over time.

<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_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
  | `in_amount0`       | `STRING`    | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_amount1`       | `STRING`    | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_liquidity`     | `STRING`    | Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.                 |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_liquidity         | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------- | ----------- | ------------- | --------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xebd96a948262f7faff8a7b35207d5dea343892c3 | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 6          | 1000000     | 1000000     | 11867787      | 1675711218977084989   | 2024-12-13T02:55:30.000Z | 0xe2c49cc52c98297fba548eb717102008f0bd577e1b9c2f2ec78258b472f1556d |
  | 0xa9f3cc299a4acd6b3e486aa28700144bc2734f34 | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 7          | 555000000   | 555000000   | 11866258      | 930026255696992568471 | 2024-12-13T01:36:56.000Z | 0x2f677d9607585d8d592ec0c0635ba3868629820e37086969d9757a8457bacac5 |
  | 0x9326f2aa418f3647be2f861a46a1923009443c29 | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 6          | 521467426   | 489037949   | 9430734       | 850689948376490964993 | 2024-09-19T15:26:30.000Z | 0xc05f7f89c5cb1dab3b7ae7721a343c8098abb57c68951d8316f2e409b9fad685 |
</Accordion>

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

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

***

### StablePool\_Swap\_event

Swap events from SyncSwap V1 stablecoin pools on Scroll, capturing token exchanges with input/output amounts, sender addresses, and recipient addresses. Used for analyzing stablecoin trading activity, slippage patterns, and liquidity depth in stable pair pools.

<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_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                   |
  | `in_amount0In`     | `STRING`    | Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.   |
  | `in_amount1In`     | `STRING`    | Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.   |
  | `in_amount0Out`    | `STRING`    | Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
  | `in_amount1Out`    | `STRING`    | Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                       |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | block\_number | in\_amount0In | in\_amount1In | in\_amount0Out | in\_amount1Out | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | ------------- | -------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x000da32d6567a8e5dcc86f7164b1c9cbb57eb0e0 | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 6          | 7109305       | 0             | 41354806      | 41279884       | 0              | 2024-07-03T18:37:44.000Z | 0xaedb62d8a5eacd68fbbaa672e7c85a9b435070172ea77bb1e317230839aae880 |
  | 0x0037d9231eb18662463b4b74c062bba786bd5b31 | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | false   | 0x80e38291e06339d10aab483c65695d004dbd5c69 | 7          | 7095343       | 0             | 50468186      | 50374387       | 0              | 2024-07-03T06:56:38.000Z | 0x5900c44881dba6f6005d800a02d1ffc1510f4d9de0a716bec60735e3aa72551d |
  | 0x006e767bd3f7e51fe4408de1289ad1a24a67066a | 0x2076d4632853fb165cf7c7e7fad592dac70f4fe1 | false   | 0xfd541d0e2773a189450a70f06bc7edd3c1dc9115 | 9          | 7112556       | 0             | 60522563      | 60414035       | 0              | 2024-07-03T21:20:17.000Z | 0x54fa2cb7b19fb1cdcc30622f3a76717d7c59f981169bc8711abac3c0ad957015 |
</Accordion>

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

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

***

### StablePool\_Sync\_event

Reserve synchronization events from SyncSwap V1 stableswap pools on Scroll, capturing token pair reserve balances after each swap or liquidity operation. Used for tracking pool composition changes and analyzing stablecoin pair dynamics.

<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_reserve0`      | `STRING`    | Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.  |
  | `in_reserve1`      | `STRING`    | Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_reserve0       | in\_reserve1        | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------------ | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x0b6ca169b7afafe418c2a49911410e57bf987a65 | false   | 17         | 725347428722560971 | 3306329740793540495 | 7360082       | 2024-07-12T11:47:47.000Z | 0x6bbba690a03e08fc790077afb5490ea5e1607af1b9817e866aafcef5f6c9e505 |
  | 0x0b6ca169b7afafe418c2a49911410e57bf987a65 | false   | 22         | 725348428465527454 | 3306329740793540495 | 7360574       | 2024-07-12T12:12:23.000Z | 0x4663afda490aeea72bc101bc04853e8b526e5640692c159f764164087e77059b |
  | 0x0b6ca169b7afafe418c2a49911410e57bf987a65 | false   | 22         | 726347428722560971 | 3305326579651896278 | 7360546       | 2024-07-12T12:10:59.000Z | 0x16bc6ac2dad66978a7ed8b4717c3e17eba93a529f9b31e076a926f4dd687a70c |
</Accordion>

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

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

***

### StablePoolFactory\_PoolCreated\_event

Pool creation events emitted by StablePoolFactory contracts on decentralized exchange (DEX) platforms. Records the deployment of new stable swap pools with their contract addresses and constituent token pairs for tracking liquidity pool initialization.

<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_token0`        | `STRING`    | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                              |
  | `in_token1`        | `STRING`    | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                             |
  | `in_pool`          | `STRING`    | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.                                           |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pool                                   | removed | in\_token0                                 | in\_token1                                 | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xe4cf807e351b56720b17a59094179e7ed9dd3727 | 0xab2569f58650a5489384bfe4cce88c0d2c8ad8b3 | false   | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 0xd218db5f01f09e0f0391507d9252fd50966947ef | 33         | 4973287       | 2024-04-20T11:58:31.000Z | 0x33eff0bbb0b5c9a9987101e39c98da669387f3f9dd5e8c140d0798eaeb3c135e |
  | 0xe4cf807e351b56720b17a59094179e7ed9dd3727 | 0xdd85d453a0e4f762c80c773bef63eb4cf4cb9e3e | false   | 0x5300000000000000000000000000000000000004 | 0x76c5e7582149c9631021729e3f156b5fffcf1b60 | 2          | 219429        | 2023-10-22T18:35:31.000Z | 0x58ff33783ccbb629a1d849e96007664c4be3ab74dbd4defdf53e3af9dbeeb6f2 |
  | 0xe4cf807e351b56720b17a59094179e7ed9dd3727 | 0xf3beb3a99dde37a8dfb5e76506798bfb11dbf0fb | false   | 0x5300000000000000000000000000000000000004 | 0x53878b874283351d26d206fa512aece1bef6c0dd | 13         | 1905929       | 2023-12-26T07:07:11.000Z | 0x240c35aa7573e9b6465f18b9d52458434c502a5cda31cb8c18293ce811789cec |
</Accordion>

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

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

***

### Vault\_FlashLoan\_event

Flash loan events emitted by decentralized exchange (DEX) vault contracts, recording uncollateralized borrows of tokens with borrowed amount, fee charged, and recipient address. Used for arbitrage tracking and flash loan analytics across Balancer V2, Beethoven X, BEX, and SyncSwap protocols.

<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_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                             |
  | `in_token`         | `STRING`    | Token address involved in the transaction or 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_feeAmount`     | `STRING`    | Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.                        |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_token                                  | in\_amount | log\_index | block\_number | in\_feeAmount | in\_recipient                              | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x7160570bb153edd0ea1775ec2b2ac9b65f1ab61b | false   | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 1075737098 | 16         | 8165946       | 537868        | 0x349f52094179fd10c5a4409721cdcca851502256 | 2024-08-07T18:46:45.000Z | 0x428507f9867ec8c4dbfdb1426c131ba0ba135f8f6b4727ce164510f400ef09a9 |
  | 0x7160570bb153edd0ea1775ec2b2ac9b65f1ab61b | false   | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 34167879   | 16         | 8166025       | 17083         | 0xb0229744362acc8346017ff9433671c808dda23c | 2024-08-07T18:50:36.000Z | 0xe9c0e70b3889b8ff6f7d905f5572076f773cec83450725cb093e788a24a89106 |
  | 0x7160570bb153edd0ea1775ec2b2ac9b65f1ab61b | false   | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 81109818   | 33         | 8166395       | 40554         | 0xb0229744362acc8346017ff9433671c808dda23c | 2024-08-07T19:08:52.000Z | 0x6b0d12332a2f479bc7c24fcb7edd224f0cda686e2fe8cf965602f89b000aee6c |
</Accordion>

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

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

***