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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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). |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter