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

# clipper_v1_ethereum

> Tables in tt-contracts.clipper_v1_ethereum

## Tables

### ApproximateCaravelExchange\_AssetWithdrawn\_event

Liquidity withdrawal events from Clipper DEX (decentralized exchange) v1 on Ethereum, capturing when liquidity providers remove assets from pools in exchange for pool tokens. Includes withdrawn asset addresses (USDC, WETH), amounts, pool token quantities, and withdrawer addresses for analyzing LP activity and pool composition 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_withdrawer`    | `STRING`    | Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.                                                |
  | `in_poolTokens`    | `STRING`    | Amount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.                                  |
  | `in_assetAddress`  | `STRING`    | Contract address of the asset token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                        |
  | `in_assetAmount`   | `STRING`    | Amount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.                                        |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_poolTokens        | in\_withdrawer                             | in\_assetAmount   | block\_timestamp         | in\_assetAddress                           | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------- | --------------------- | ------------------------------------------ | ----------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 256        | 17905180      | 119734624922823054388 | 0xcd0d4cdb238eec15fcf4ff9d13d5a59051e507d7 | 122660380         | 2023-08-13T09:56:11.000Z | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0xb589259ef72aff474dac413d9a4adebe96b18005f779548d98c0c8d008dbbe69 |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 230        | 17902285      | 712478745211694894968 | 0x83f68939de5b679299de9d72b40a6e4688b6c587 | 729682116         | 2023-08-13T00:13:47.000Z | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0xd1e4185856f01c46ec420a9be02bf23c6fd2c87cd9e274149fc8c64e839d67c9 |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 188        | 17904666      | 26788986482904264830  | 0x868490398931ffead3c38d6d9af71f4f06d3f4f6 | 14835249873801058 | 2023-08-13T08:11:59.000Z | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xc76b5833ae20a301ec8d67ceaee045a7cf7d907fed4e098f8dbadbccd210e156 |
</Accordion>

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

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

***

### ApproximateCaravelExchange\_Deposited\_event

Liquidity deposit events from Clipper v1 DEX (Decentralized Exchange) on Ethereum, recording pool token amounts minted to depositors. Used for tracking 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_depositor`     | `STRING`    | Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.                                |
  | `in_poolTokens`    | `STRING`    | Amount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.                                  |
  | `in_nDays`         | `STRING`    | Number of days for which the deposited liquidity pool tokens are locked. String-encoded integer value.                                               |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_nDays | log\_index | block\_number | in\_depositor                              | in\_poolTokens         | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------- | ---------- | ------------- | ------------------------------------------ | ---------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 0         | 229        | 18189322      | 0x6e3fb8a019e78785e80cea1d413bc3ab650c2449 | 6231508480714637479    | 2023-09-22T05:30:59.000Z | 0x9d0272f039b19fd94437876af29d955212f98563ae8c67a950eb6905660c95b0 |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 0         | 252        | 17690873      | 0x12bb166f997146d3d33645146eedbc4a923195d7 | 1020537690188424410537 | 2023-07-14T09:41:11.000Z | 0x406ea9024c0327398fa6bec8e6b77ba16e164f31ab9bde5c76d031e874682258 |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 0         | 398        | 17694064      | 0x12bb166f997146d3d33645146eedbc4a923195d7 | 18163307850523739076   | 2023-07-14T20:27:11.000Z | 0x0df3dbec89810ff6d9a3fe1d310a0f58a89aed2a7096e4b7de105a2467dbe428 |
</Accordion>

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

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

***

### ApproximateCaravelExchange\_Swapped\_event

Token swap events from Clipper DEX (decentralized exchange) v1 on Ethereum. Records token pair exchanges with input/output amounts and recipient addresses for analyzing liquidity and trading volume.

<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_inAsset`       | `STRING`    | Contract address of the input token being swapped. Hex-encoded, 0x-prefixed, 42-character string.                                                         |
  | `in_outAsset`      | `STRING`    | Contract address of the output token received from the swap. Hex-encoded, 0x-prefixed, 42-character string.                                               |
  | `in_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                  |
  | `in_inAmount`      | `STRING`    | Amount of input tokens sent to the swap. String-encoded integer representing token quantity in the asset's smallest denomination.                         |
  | `in_outAmount`     | `STRING`    | Amount of output tokens received from the swap. String-encoded integer representing token quantity in the asset's smallest denomination.                  |
  | `in_auxiliaryData` | `STRING`    | Auxiliary data associated with the swap event. Hex-encoded byte string varying in length and content depending on the swap protocol or router identifier. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_inAsset                                | in\_inAmount           | in\_outAsset                               | block\_number | in\_outAmount       | in\_recipient                              | block\_timestamp         | in\_auxiliaryData | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ---------------------- | ------------------------------------------ | ------------- | ------------------- | ------------------------------------------ | ------------------------ | ----------------- | ------------------------------------------------------------------ |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 257        | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 99055346               | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 17273727      | 26755774132         | 0x88c9a972f47c82ada656889e5e5d8c97fe3df301 | 2023-05-16T17:25:59.000Z | 0x31494e4348      | 0x56789afb275519175bbfc6c11a62ca7e55518bebbf18db17ff363f79b00dc5c7 |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 164        | 0x6b175474e89094c44da98b954eedeac495271d0f | 1343651447354203392359 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 17273480      | 737889323779766144  | 0x276bf98428ac67014b04161fd51a4242a95871df | 2023-05-16T16:35:47.000Z | 0x31494e4348      | 0x6abff8451c270aa5f3c2353a16a723e9bc7dd58d5e6227b7decc1808fe57925f |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 128        | 0x6b175474e89094c44da98b954eedeac495271d0f | 2000000000000000000000 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 17271610      | 1099933376484159488 | 0x99f97a87073fb21d6e83442143d3ebf572a5f418 | 2023-05-16T10:14:47.000Z | 0x31494e4348      | 0xa09f30824e015e7a157e2c3298f7857cb02cf1a0509099948d34a09ee0c3690e |
</Accordion>

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

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

***

### ApproximateCaravelExchange\_Withdrawn\_event

Liquidity withdrawal events from Clipper DEX (Decentralized Exchange) on Ethereum, recording when liquidity providers remove tokens from the pool. Includes pool token amounts, withdrawal fractions, and withdrawer addresses for analyzing LP behavior and pool composition 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_withdrawer`     | `STRING`    | Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.                                                   |
  | `in_poolTokens`     | `STRING`    | Amount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.                                     |
  | `in_fractionOfPool` | `STRING`    | Proportional share of the liquidity pool being withdrawn, expressed as parts per ten million. Integer value where 10000000 represents 100% of the pool. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_poolTokens           | in\_withdrawer                             | block\_timestamp         | transaction\_hash                                                  | in\_fractionOfPool |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 168        | 18154553      | 28918585202730248457     | 0x60057786842aff287ebb0bbf96e082733a4a667f | 2023-09-17T08:22:47.000Z | 0xb98e861f7ce88f6990a545e4902ebdf8c45e9cc041305ff4a5e03e73cf318c4a | 38255              |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 182        | 17990460      | 36165803722863657243     | 0x4878b5496fda31ecf21f9e28e86e1ab80f23748e | 2023-08-25T08:16:47.000Z | 0x54a04eddbbd24d7cfaf941b604fc33527c5505d7e4ee9cff54622b2a8fec6251 | 46459              |
  | 0x655edce464cc797526600a462a8154650eee4b77 | false   | 174        | 18048567      | 105281584402254914782012 | 0x84d76e64be483a615e2447ccf3b52e938cb40688 | 2023-09-02T11:35:23.000Z | 0xbf4e649f798ba547d3ce5da6359f9371375b834b7aa3e67eafdca9eaa248dedc | 136498451          |
</Accordion>

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

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

***

### CaravelExchange\_AssetWithdrawn\_event

Liquidity withdrawal events from Clipper DEX (Decentralized Exchange) on Ethereum, recording when liquidity providers remove assets from the CaravelExchange pool. Contains withdrawer addresses, asset amounts, and pool tokens burned for analyzing liquidity provision patterns and exit behavior.

<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_withdrawer`    | `STRING`    | Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.                                                |
  | `in_poolTokens`    | `STRING`    | Amount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.                                  |
  | `in_assetAddress`  | `STRING`    | Contract address of the asset token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                        |
  | `in_assetAmount`   | `STRING`    | Amount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.                                        |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_poolTokens         | in\_withdrawer                             | in\_assetAmount | block\_timestamp         | in\_assetAddress                           | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------- | ---------------------- | ------------------------------------------ | --------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 89         | 15192152      | 713862784114833227776  | 0x97d3928a58cb7308fa7a95a1756111c3e633bf67 | 396263706       | 2022-07-22T11:42:02.000Z | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 0xc67500ff41eb31bc2640195f5fd744d1041c4fc5d2f3b430a2dad44ab4af3876 |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 426        | 15171490      | 1360234895067414790144 | 0x7626fba64deb1683a364c32f30370215f05c1f09 | 733609772       | 2022-07-19T06:38:15.000Z | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0x76104c6161919c4c0f5dc34f5a1067ae7d8a47937b7b2f7dc8c792a30db5e5eb |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 267        | 15243778      | 306183319640602574848  | 0xd1c805676244085838262806ffb92b21421e5b8d | 167696446       | 2022-07-30T12:29:27.000Z | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0x84ec8b2763f98367f6823de8bcf8d5faed24eb1365a09e39eb7caa2966b50f94 |
</Accordion>

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

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

***

### CaravelExchange\_Deposited\_event

Liquidity deposit events from Clipper DEX's CaravelExchange contract on Ethereum, capturing depositor addresses, pool token amounts, and optional time-lock durations. Used for analyzing liquidity provider behavior and pool participation 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_depositor`     | `STRING`    | Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.                                |
  | `in_poolTokens`    | `STRING`    | Amount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.                                  |
  | `in_nDays`         | `STRING`    | Number of days for which the deposited liquidity pool tokens are locked. String-encoded integer value.                                               |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_nDays | log\_index | block\_number | in\_depositor                              | in\_poolTokens          | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------- | ---------- | ------------- | ------------------------------------------ | ----------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 10        | 130        | 15132779      | 0xd51be729978e0bcf6dcb1a8fd7d3d83323534d80 | 23133450165637087232    | 2022-07-13T06:42:46.000Z | 0xee5b7b8feda7e8a740f8e30896a9696629a1968ce1f8b54c5f4a126fc4f3e224 |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 10        | 156        | 15136225      | 0x6a5dbf2fb5206ec8192620810c3edb6d5e62b188 | 62506844133706545758208 | 2022-07-13T19:47:19.000Z | 0x82f60fb69e9a32c869d1a2944b8490beeb9840d49ec43fb2c7c19ef5cfceeb8e |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 0         | 573        | 15132598      | 0xfaab5716703bb76fb2402a94052ad336baf38d3a | 4332264907838026940416  | 2022-07-13T06:07:45.000Z | 0xf5fa0764b0cb90fae4b828c60b1b4171179a16e98f69e5ec90f29c03b3c61866 |
</Accordion>

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

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

***

### CaravelExchange\_Swapped\_event

Token swap events from Clipper DEX on Ethereum. Captures trade executions with input/output asset addresses, amounts, and recipient data for analyzing swap activity and liquidity routing.

<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_inAsset`       | `STRING`    | Contract address of the input token being swapped. Hex-encoded, 0x-prefixed, 42-character string.                                                         |
  | `in_outAsset`      | `STRING`    | Contract address of the output token received from the swap. Hex-encoded, 0x-prefixed, 42-character string.                                               |
  | `in_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                  |
  | `in_inAmount`      | `STRING`    | Amount of input tokens sent to the swap. String-encoded integer representing token quantity in the asset's smallest denomination.                         |
  | `in_outAmount`     | `STRING`    | Amount of output tokens received from the swap. String-encoded integer representing token quantity in the asset's smallest denomination.                  |
  | `in_auxiliaryData` | `STRING`    | Auxiliary data associated with the swap event. Hex-encoded byte string varying in length and content depending on the swap protocol or router identifier. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_inAsset                                | in\_inAmount | in\_outAsset                               | block\_number | in\_outAmount | in\_recipient                              | block\_timestamp         | in\_auxiliaryData                                                  | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------ | ------------------------------------------ | ------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 152        | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 4500000000   | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 15099934      | 20482229      | 0xf2f400c138f9fb900576263af0bc7fcde2b1b8a8 | 2022-07-08T05:02:21.000Z | 0x31494e4348000000000000000000000000000000000000000000000000000000 | 0x4acd4da15413ae7a86a55f97f1859234eebf19d35786a550fa012a30fc5c7bc9 |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 175        | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 25016964978  | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 15102786      | 113688027     | 0xf2f400c138f9fb900576263af0bc7fcde2b1b8a8 | 2022-07-08T15:42:22.000Z | 0x31494e4348000000000000000000000000000000000000000000000000000000 | 0xef2fabb146dc6f2fd132101a1fc3f5b3531d5a52bb0f8cf2579b1d22692cd756 |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 340        | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 28800000000  | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 15101424      | 133020520     | 0xf2f400c138f9fb900576263af0bc7fcde2b1b8a8 | 2022-07-08T10:40:09.000Z | 0x31494e4348000000000000000000000000000000000000000000000000000000 | 0xd7342fe8209c8c85c0a8d257ef192ea562b3275f10203a390ef263755a4a4db9 |
</Accordion>

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

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

***

### CaravelExchange\_Withdrawn\_event

Liquidity withdrawal events from Clipper DEX (CaravelExchange) on Ethereum, capturing when liquidity providers remove assets from the automated market maker pool. Records pool token amounts burned and the proportional share of liquidity withdrawn for analyzing LP behavior and pool 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_withdrawer`     | `STRING`    | Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.                                                   |
  | `in_poolTokens`     | `STRING`    | Amount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.                                     |
  | `in_fractionOfPool` | `STRING`    | Proportional share of the liquidity pool being withdrawn, expressed as parts per ten million. Integer value where 10000000 represents 100% of the pool. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_poolTokens           | in\_withdrawer                             | block\_timestamp         | transaction\_hash                                                  | in\_fractionOfPool |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 284        | 16910098      | 237163807892442185728    | 0x90c984a67ea15e17bde75daa7ec0e2f4417fcaf0 | 2023-03-26T07:24:47.000Z | 0xd01e96f9fb3c08c556d85d8c3f35bb5e2490d27cbb592f99b33a204957c2f87a | 103075235          |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 178        | 15304105      | 316605160242284000000000 | 0x5f317fdc121478b54f04154b1348babc44bdcbc2 | 2022-08-08T21:52:42.000Z | 0xbada61d77336e30f8c3ad31b2339d133380b715d989bbebf70e6561fbbcdbce9 | 2372437808         |
  | 0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7 | false   | 200        | 15301138      | 275463666558197301248    | 0x53954a6191ad795e331cffdb1b035d389f2ac516 | 2022-08-08T10:54:40.000Z | 0x614a37a326c824da7f6e12d81e1563b98df06518f39858c3e3d8f3b653ad3e3c | 1973668            |
</Accordion>

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

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

***

### ExchangeInterface\_Swapped\_event

Token swap execution events from Clipper DEX (decentralized exchange) on Ethereum. Captures input/output token addresses, amounts, recipients, and auxiliary routing data for analyzing liquidity provision and trade flow 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_inAsset`       | `STRING`    | Contract address of the input token being swapped. Hex-encoded, 0x-prefixed, 42-character string.                                                         |
  | `in_outAsset`      | `STRING`    | Contract address of the output token received from the swap. Hex-encoded, 0x-prefixed, 42-character string.                                               |
  | `in_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                  |
  | `in_inAmount`      | `STRING`    | Amount of input tokens sent to the swap. String-encoded integer representing token quantity in the asset's smallest denomination.                         |
  | `in_outAmount`     | `STRING`    | Amount of output tokens received from the swap. String-encoded integer representing token quantity in the asset's smallest denomination.                  |
  | `in_auxiliaryData` | `STRING`    | Auxiliary data associated with the swap event. Hex-encoded byte string varying in length and content depending on the swap protocol or router identifier. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_inAsset                                | in\_inAmount | in\_outAsset                               | block\_number | in\_outAmount        | in\_recipient                              | block\_timestamp         | in\_auxiliaryData                                                  | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------ | ------------------------------------------ | ------------- | -------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0x2e9c6dcdca22a5952a88c4b18edb5b54c5155bc9 | false   | 299        | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 2475000000   | 0x0000000000000000000000000000000000000000 | 14068086      | 1098978319163238185  | 0x1111111254fb6c44bac0bed2854e76f90643097d | 2022-01-24T11:33:42.000Z | 0x31494e4348000000000000000000000000000000000000000000000000000000 | 0xa38c4267bf3bd2912c213612aab1d372ad8fdfc2e578822156f9b5faa03ed84b |
  | 0x2e9c6dcdca22a5952a88c4b18edb5b54c5155bc9 | false   | 10         | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 33496320000  | 0x0000000000000000000000000000000000000000 | 14066715      | 13666026692193913868 | 0x137f48d01459944fefc1f637feeafe49c0f6e69c | 2022-01-24T06:29:50.000Z | 0x30782056495020504c5020526f75746572                               | 0x142d1dee6579513ac67a91e6aea5847b97fb8a988d6ec43e2fb0b8ef21d9769e |
  | 0x2e9c6dcdca22a5952a88c4b18edb5b54c5155bc9 | false   | 72         | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 15510532160  | 0x0000000000000000000000000000000000000000 | 14069547      | 6926531665758856127  | 0x137f48d01459944fefc1f637feeafe49c0f6e69c | 2022-01-24T16:56:17.000Z | 0x30782056495020504c5020526f75746572                               | 0xab88e35050e6b7b4d20fb356f160a1a25901431eeedb07783e4fb7a8fee00da8 |
</Accordion>

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

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

***

### FeeSplit\_LPDeposited\_event

Liquidity provider (LP) deposit events from Clipper v1 DEX fee-splitting contract on Ethereum. Records depositor addresses and deposit amounts for tracking LP participation and capital flows into the protocol's revenue-sharing mechanism.

<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_depositor`     | `STRING`    | Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.                                                                              |
  | `in_depositAmount` | `STRING`    | Amount of tokens deposited into the liquidity pool or vault. String-encoded integer representing the value in the smallest denomination of the token (wei for ETH, atomic units for other tokens). |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_depositor                              | block\_timestamp         | in\_depositAmount      | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ---------------------- | ------------------------------------------------------------------ |
  | 0x51b0efa27ff4f29f8315496f01952377d581ce73 | false   | 173        | 16586268      | 0xbc62985faabed27a8f174cbd5ea1ee7b1ed8fc12 | 2023-02-08T19:57:47.000Z | 10925450913224715325   | 0x539055f7bc131544ef43e50799efadc1beac8c854c75bd3f1c26195f3f17052e |
  | 0x51b0efa27ff4f29f8315496f01952377d581ce73 | false   | 309        | 16583379      | 0x2522c45d1c497c5d46edadfaf9f74c9a381bf222 | 2023-02-08T10:11:11.000Z | 96604686869639642891   | 0xbafcc520d00d22c2ef3a618f1d21f7b828cf0f0be953a51386661892e0161583 |
  | 0x51b0efa27ff4f29f8315496f01952377d581ce73 | false   | 59         | 16583800      | 0xf63116029a4eea6f0e22e2e7725709fcfdc3e98a | 2023-02-08T11:35:23.000Z | 1000000000000000000000 | 0xc7455b23ce26de0ad49b829b4505b89b6a6b551ab237ebec3bb2630733e9b6c0 |
</Accordion>

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

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

***

### FeeSplit\_LPWithdrawn\_event

Liquidity provider (LP) withdrawal events from Clipper DEX v1 on Ethereum, capturing deposit amounts and withdrawn token amounts with slippage. Used for analyzing LP position exits and fee-adjusted returns.

<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_depositor`       | `STRING`    | Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                           |
  | `in_depositAmount`   | `STRING`    | Amount of tokens deposited into the liquidity pool or vault. String-encoded integer representing the value in the smallest denomination of the token (wei for ETH, atomic units for other tokens).                                              |
  | `in_withdrawnTokens` | `STRING`    | Amount of tokens received by the liquidity provider upon withdrawal from the Clipper pool, denominated in the smallest unit of the token (wei). This value is typically less than the original deposit amount due to fees and trading activity. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_depositor                              | block\_timestamp         | in\_depositAmount      | transaction\_hash                                                  | in\_withdrawnTokens    |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ---------------------- | ------------------------------------------------------------------ | ---------------------- |
  | 0x51b0efa27ff4f29f8315496f01952377d581ce73 | false   | 126        | 16020295      | 0x710dc8c61b177687f1e3c085f694896cdc438209 | 2022-11-21T18:51:35.000Z | 6899752716743014270831 | 0x192965f789ba53e7f91208ec786ff263ff0f0e291c5eef50d34fb40feab8fed7 | 6697857476689208812654 |
  | 0x51b0efa27ff4f29f8315496f01952377d581ce73 | false   | 355        | 17448333      | 0xe219343e6dddd9d82ad44cac95a11111e5ec31a1 | 2023-06-10T07:36:23.000Z | 12593942816299915543   | 0x7d1203b99fdaf9fe29c1df554d71d05a39665a8a775b88984f57a6f4dbffdf45 | 12072130529342572706   |
  | 0x51b0efa27ff4f29f8315496f01952377d581ce73 | false   | 284        | 17448306      | 0x9452a94e92d3bf33f5f441c1b6dc4be58d1967f5 | 2023-06-10T07:30:59.000Z | 12817614230728616674   | 0x037af830e35a075e8eab82b80f30b9c3ab7b00260d1d2258d51cdd57054e6031 | 12286534433668007010   |
</Accordion>

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

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

***

### VerifiedCaravelExchange\_AssetWithdrawn\_event

Liquidity withdrawal events from Clipper v1 automated market maker (AMM) on Ethereum, recording when users redeem pool tokens for underlying assets like WETH (Wrapped Ether), USDT (Tether), and USDC (USD Coin). Useful for analyzing liquidity provider exit patterns and pool composition changes 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_withdrawer`    | `STRING`    | Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.                                                |
  | `in_poolTokens`    | `STRING`    | Amount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.                                  |
  | `in_assetAddress`  | `STRING`    | Contract address of the asset token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                        |
  | `in_assetAmount`   | `STRING`    | Amount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.                                        |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_poolTokens       | in\_withdrawer                             | in\_assetAmount   | block\_timestamp         | in\_assetAddress                           | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------- | -------------------- | ------------------------------------------ | ----------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 174        | 15995202      | 24517581529071747072 | 0x87df2b057cfcea2e21f8f0ac8f12d87f8acf6c4d | 16776235327029796 | 2022-11-18T06:47:35.000Z | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0x045d508c9cd5d9c1595f6ef13145f667fea817f2f6ecbb4b19c353f0390b6c1d |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 74         | 15997788      | 11017064269312163840 | 0xb3cd96103ce7cc6b17f834641e27f599a8e43945 | 7544418300388826  | 2022-11-18T15:26:47.000Z | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xbfc6ee1b634d0ceae052b6441aba5ebbbc70d06d52bcf738a539c55184e73b04 |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 71         | 16682922      | 14640448308085336110 | 0x617711eceff56d7fbe72ccfa642beb402058842c | 15059134          | 2023-02-22T08:52:23.000Z | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 0xa53d8d94fde7008abf1ecf7ce3e202a2a9909240204828fc1f4002d9e320ec23 |
</Accordion>

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

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

***

### VerifiedCaravelExchange\_Deposited\_event

Deposit events from Clipper's Caravel Exchange liquidity pools on Ethereum, capturing pool token amounts deposited by liquidity providers with optional time-lock periods. Used to track liquidity additions and LP (Liquidity Provider) participation in Clipper's automated market maker 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_depositor`     | `STRING`    | Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.                                |
  | `in_poolTokens`    | `STRING`    | Amount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.                                  |
  | `in_nDays`         | `STRING`    | Number of days for which the deposited liquidity pool tokens are locked. String-encoded integer value.                                               |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_nDays | log\_index | block\_number | in\_depositor                              | in\_poolTokens         | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | --------- | ---------- | ------------- | ------------------------------------------ | ---------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 10        | 644        | 15398606      | 0x73b811c882ec2ded70a90202dc869e8a8bc4a53c | 10256258556755968000   | 2022-08-23T19:57:29.000Z | 0x98d9b82f2d64531bf4fec446b9a5eacf989cc05a0ef88e20cb495e6b96e8e406 |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 0         | 202        | 16471479      | 0x205e8c5b8b9ab41e934ebf394aa319ccbdedd3bb | 6651516429836532084091 | 2023-01-23T19:04:35.000Z | 0x84fbca83087135e6df182b570470335ce9d8c9f637a3a9e1e06ec016f5301d5b |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 0         | 96         | 16471840      | 0x205e8c5b8b9ab41e934ebf394aa319ccbdedd3bb | 6643104769513845948416 | 2023-01-23T20:17:35.000Z | 0xc0bd0e3cb740e2b1483764ac79803cfe843ecdd4ca5ab7de5e5f7b7400702972 |
</Accordion>

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

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

***

### VerifiedCaravelExchange\_Swapped\_event

Swap event logs from Clipper DEX (VerifiedCaravelExchange) on Ethereum, capturing token exchanges with input/output assets, amounts, and recipient addresses. Used for analyzing trading volume, pricing efficiency, and liquidity pool activity across stablecoin and wrapped BTC 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_inAsset`       | `STRING`    | Contract address of the input token being swapped. Hex-encoded, 0x-prefixed, 42-character string.                                                         |
  | `in_outAsset`      | `STRING`    | Contract address of the output token received from the swap. Hex-encoded, 0x-prefixed, 42-character string.                                               |
  | `in_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                  |
  | `in_inAmount`      | `STRING`    | Amount of input tokens sent to the swap. String-encoded integer representing token quantity in the asset's smallest denomination.                         |
  | `in_outAmount`     | `STRING`    | Amount of output tokens received from the swap. String-encoded integer representing token quantity in the asset's smallest denomination.                  |
  | `in_auxiliaryData` | `STRING`    | Auxiliary data associated with the swap event. Hex-encoded byte string varying in length and content depending on the swap protocol or router identifier. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_inAsset                                | in\_inAmount | in\_outAsset                               | block\_number | in\_outAmount | in\_recipient                              | block\_timestamp         | in\_auxiliaryData                                                  | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------ | ------------------------------------------ | ------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 260        | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 279768591    | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 15601430      | 1464609       | 0xf2f400c138f9fb900576263af0bc7fcde2b1b8a8 | 2022-09-24T06:29:11.000Z | 0x31494e4348000000000000000000000000000000000000000000000000000000 | 0x9f1edca79817f28e40b6a06aa53d417a811a6fb81f2d872dc98c8d8a46223b6d |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 337        | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 500000000    | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 15602112      | 2626675       | 0xf2f400c138f9fb900576263af0bc7fcde2b1b8a8 | 2022-09-24T08:46:11.000Z | 0x31494e4348000000000000000000000000000000000000000000000000000000 | 0x38624c776433dbc8c7f05eca2d3f6a96dc6bf85a4cd2b44bea5ea06722b30812 |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 272        | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 521093511    | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 15603590      | 2721747       | 0xc6cf51f57969129654c5014748e44e2a8f6ebd81 | 2022-09-24T13:42:59.000Z | 0x6f646f732e78797a                                                 | 0xa8175e7d3d515da47686171b028e05244e03d77d0f14a01f21895eb991c18516 |
</Accordion>

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

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

***

### VerifiedCaravelExchange\_Withdrawn\_event

Liquidity withdrawal events from Clipper DEX (Decentralized Exchange) V1 on Ethereum, recording when users remove liquidity from pools. Contains pool token amounts, withdrawal fractions, and withdrawer addresses for tracking liquidity provider activity and pool composition 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_withdrawer`     | `STRING`    | Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.                                                   |
  | `in_poolTokens`     | `STRING`    | Amount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.                                     |
  | `in_fractionOfPool` | `STRING`    | Proportional share of the liquidity pool being withdrawn, expressed as parts per ten million. Integer value where 10000000 represents 100% of the pool. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_poolTokens         | in\_withdrawer                             | block\_timestamp         | transaction\_hash                                                  | in\_fractionOfPool |
  | ------------------------------------------ | ------- | ---------- | ------------- | ---------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 200        | 17050928      | 29384690601885316104   | 0xaf0f1b6443fb2c398ad3d10c62cb7288675ab88d | 2023-04-15T07:25:59.000Z | 0x5d4859c5c2a70ba63fe1241e06b596ad5806a515dd1d78a9c8291027eb4e25d2 | 422921             |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 56         | 17540831      | 929804511647882811864  | 0xbe76032c4aa5631a99e7439f10f0b72d9f5b8412 | 2023-06-23T07:36:47.000Z | 0x5d818b75d33f7af6b9371b3445116883fd6c716e1665e4a387720b30eb54f9d2 | 82495405           |
  | 0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c | false   | 336        | 17542637      | 2917630952526062873878 | 0x12bb166f997146d3d33645146eedbc4a923195d7 | 2023-06-23T13:43:11.000Z | 0x33947f80d23b1a915ade5ffb571a5d7c579ec9279e14d307e52a17cd2aaf93e7 | 261015356          |
</Accordion>

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

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

***