Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_withdrawerSTRINGAddress of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.
in_poolTokensSTRINGAmount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.
in_assetAddressSTRINGContract address of the asset token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_assetAmountSTRINGAmount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.
addressremovedlog_indexblock_numberin_poolTokensin_withdrawerin_assetAmountblock_timestampin_assetAddresstransaction_hash
0x655edce464cc797526600a462a8154650eee4b77false256179051801197346249228230543880xcd0d4cdb238eec15fcf4ff9d13d5a59051e507d71226603802023-08-13T09:56:11.000Z0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb480xb589259ef72aff474dac413d9a4adebe96b18005f779548d98c0c8d008dbbe69
0x655edce464cc797526600a462a8154650eee4b77false230179022857124787452116948949680x83f68939de5b679299de9d72b40a6e4688b6c5877296821162023-08-13T00:13:47.000Z0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb480xd1e4185856f01c46ec420a9be02bf23c6fd2c87cd9e274149fc8c64e839d67c9
0x655edce464cc797526600a462a8154650eee4b77false18817904666267889864829042648300x868490398931ffead3c38d6d9af71f4f06d3f4f6148352498738010582023-08-13T08:11:59.000Z0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20xc76b5833ae20a301ec8d67ceaee045a7cf7d907fed4e098f8dbadbccd210e156
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.ApproximateCaravelExchange_AssetWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_depositorSTRINGAddress of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
in_poolTokensSTRINGAmount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.
in_nDaysSTRINGNumber of days for which the deposited liquidity pool tokens are locked. String-encoded integer value.
addressremovedin_nDayslog_indexblock_numberin_depositorin_poolTokensblock_timestamptransaction_hash
0x655edce464cc797526600a462a8154650eee4b77false0229181893220x6e3fb8a019e78785e80cea1d413bc3ab650c244962315084807146374792023-09-22T05:30:59.000Z0x9d0272f039b19fd94437876af29d955212f98563ae8c67a950eb6905660c95b0
0x655edce464cc797526600a462a8154650eee4b77false0252176908730x12bb166f997146d3d33645146eedbc4a923195d710205376901884244105372023-07-14T09:41:11.000Z0x406ea9024c0327398fa6bec8e6b77ba16e164f31ab9bde5c76d031e874682258
0x655edce464cc797526600a462a8154650eee4b77false0398176940640x12bb166f997146d3d33645146eedbc4a923195d7181633078505237390762023-07-14T20:27:11.000Z0x0df3dbec89810ff6d9a3fe1d310a0f58a89aed2a7096e4b7de105a2467dbe428
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.ApproximateCaravelExchange_Deposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_inAssetSTRINGContract address of the input token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_outAssetSTRINGContract address of the output token received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_inAmountSTRINGAmount of input tokens sent to the swap. String-encoded integer representing token quantity in the asset’s smallest denomination.
in_outAmountSTRINGAmount of output tokens received from the swap. String-encoded integer representing token quantity in the asset’s smallest denomination.
in_auxiliaryDataSTRINGAuxiliary data associated with the swap event. Hex-encoded byte string varying in length and content depending on the swap protocol or router identifier.
addressremovedlog_indexin_inAssetin_inAmountin_outAssetblock_numberin_outAmountin_recipientblock_timestampin_auxiliaryDatatransaction_hash
0x655edce464cc797526600a462a8154650eee4b77false2570x2260fac5e5542a773aa44fbcfedf7c193bc2c599990553460xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb4817273727267557741320x88c9a972f47c82ada656889e5e5d8c97fe3df3012023-05-16T17:25:59.000Z0x31494e43480x56789afb275519175bbfc6c11a62ca7e55518bebbf18db17ff363f79b00dc5c7
0x655edce464cc797526600a462a8154650eee4b77false1640x6b175474e89094c44da98b954eedeac495271d0f13436514473542033923590xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2172734807378893237797661440x276bf98428ac67014b04161fd51a4242a95871df2023-05-16T16:35:47.000Z0x31494e43480x6abff8451c270aa5f3c2353a16a723e9bc7dd58d5e6227b7decc1808fe57925f
0x655edce464cc797526600a462a8154650eee4b77false1280x6b175474e89094c44da98b954eedeac495271d0f20000000000000000000000xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc21727161010999333764841594880x99f97a87073fb21d6e83442143d3ebf572a5f4182023-05-16T10:14:47.000Z0x31494e43480xa09f30824e015e7a157e2c3298f7857cb02cf1a0509099948d34a09ee0c3690e
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.ApproximateCaravelExchange_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_withdrawerSTRINGAddress of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.
in_poolTokensSTRINGAmount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.
in_fractionOfPoolSTRINGProportional share of the liquidity pool being withdrawn, expressed as parts per ten million. Integer value where 10000000 represents 100% of the pool.
addressremovedlog_indexblock_numberin_poolTokensin_withdrawerblock_timestamptransaction_hashin_fractionOfPool
0x655edce464cc797526600a462a8154650eee4b77false16818154553289185852027302484570x60057786842aff287ebb0bbf96e082733a4a667f2023-09-17T08:22:47.000Z0xb98e861f7ce88f6990a545e4902ebdf8c45e9cc041305ff4a5e03e73cf318c4a38255
0x655edce464cc797526600a462a8154650eee4b77false18217990460361658037228636572430x4878b5496fda31ecf21f9e28e86e1ab80f23748e2023-08-25T08:16:47.000Z0x54a04eddbbd24d7cfaf941b604fc33527c5505d7e4ee9cff54622b2a8fec625146459
0x655edce464cc797526600a462a8154650eee4b77false174180485671052815844022549147820120x84d76e64be483a615e2447ccf3b52e938cb406882023-09-02T11:35:23.000Z0xbf4e649f798ba547d3ce5da6359f9371375b834b7aa3e67eafdca9eaa248dedc136498451
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.ApproximateCaravelExchange_Withdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_withdrawerSTRINGAddress of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.
in_poolTokensSTRINGAmount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.
in_assetAddressSTRINGContract address of the asset token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_assetAmountSTRINGAmount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.
addressremovedlog_indexblock_numberin_poolTokensin_withdrawerin_assetAmountblock_timestampin_assetAddresstransaction_hash
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false89151921527138627841148332277760x97d3928a58cb7308fa7a95a1756111c3e633bf673962637062022-07-22T11:42:02.000Z0xdac17f958d2ee523a2206206994597c13d831ec70xc67500ff41eb31bc2640195f5fd744d1041c4fc5d2f3b430a2dad44ab4af3876
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false4261517149013602348950674147901440x7626fba64deb1683a364c32f30370215f05c1f097336097722022-07-19T06:38:15.000Z0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb480x76104c6161919c4c0f5dc34f5a1067ae7d8a47937b7b2f7dc8c792a30db5e5eb
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false267152437783061833196406025748480xd1c805676244085838262806ffb92b21421e5b8d1676964462022-07-30T12:29:27.000Z0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb480x84ec8b2763f98367f6823de8bcf8d5faed24eb1365a09e39eb7caa2966b50f94
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.CaravelExchange_AssetWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_depositorSTRINGAddress of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
in_poolTokensSTRINGAmount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.
in_nDaysSTRINGNumber of days for which the deposited liquidity pool tokens are locked. String-encoded integer value.
addressremovedin_nDayslog_indexblock_numberin_depositorin_poolTokensblock_timestamptransaction_hash
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false10130151327790xd51be729978e0bcf6dcb1a8fd7d3d83323534d80231334501656370872322022-07-13T06:42:46.000Z0xee5b7b8feda7e8a740f8e30896a9696629a1968ce1f8b54c5f4a126fc4f3e224
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false10156151362250x6a5dbf2fb5206ec8192620810c3edb6d5e62b188625068441337065457582082022-07-13T19:47:19.000Z0x82f60fb69e9a32c869d1a2944b8490beeb9840d49ec43fb2c7c19ef5cfceeb8e
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false0573151325980xfaab5716703bb76fb2402a94052ad336baf38d3a43322649078380269404162022-07-13T06:07:45.000Z0xf5fa0764b0cb90fae4b828c60b1b4171179a16e98f69e5ec90f29c03b3c61866
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.CaravelExchange_Deposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_inAssetSTRINGContract address of the input token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_outAssetSTRINGContract address of the output token received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_inAmountSTRINGAmount of input tokens sent to the swap. String-encoded integer representing token quantity in the asset’s smallest denomination.
in_outAmountSTRINGAmount of output tokens received from the swap. String-encoded integer representing token quantity in the asset’s smallest denomination.
in_auxiliaryDataSTRINGAuxiliary data associated with the swap event. Hex-encoded byte string varying in length and content depending on the swap protocol or router identifier.
addressremovedlog_indexin_inAssetin_inAmountin_outAssetblock_numberin_outAmountin_recipientblock_timestampin_auxiliaryDatatransaction_hash
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false1520xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb4845000000000x2260fac5e5542a773aa44fbcfedf7c193bc2c59915099934204822290xf2f400c138f9fb900576263af0bc7fcde2b1b8a82022-07-08T05:02:21.000Z0x31494e43480000000000000000000000000000000000000000000000000000000x4acd4da15413ae7a86a55f97f1859234eebf19d35786a550fa012a30fc5c7bc9
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false1750xdac17f958d2ee523a2206206994597c13d831ec7250169649780x2260fac5e5542a773aa44fbcfedf7c193bc2c599151027861136880270xf2f400c138f9fb900576263af0bc7fcde2b1b8a82022-07-08T15:42:22.000Z0x31494e43480000000000000000000000000000000000000000000000000000000xef2fabb146dc6f2fd132101a1fc3f5b3531d5a52bb0f8cf2579b1d22692cd756
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false3400xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48288000000000x2260fac5e5542a773aa44fbcfedf7c193bc2c599151014241330205200xf2f400c138f9fb900576263af0bc7fcde2b1b8a82022-07-08T10:40:09.000Z0x31494e43480000000000000000000000000000000000000000000000000000000xd7342fe8209c8c85c0a8d257ef192ea562b3275f10203a390ef263755a4a4db9
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.CaravelExchange_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_withdrawerSTRINGAddress of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.
in_poolTokensSTRINGAmount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.
in_fractionOfPoolSTRINGProportional share of the liquidity pool being withdrawn, expressed as parts per ten million. Integer value where 10000000 represents 100% of the pool.
addressremovedlog_indexblock_numberin_poolTokensin_withdrawerblock_timestamptransaction_hashin_fractionOfPool
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false284169100982371638078924421857280x90c984a67ea15e17bde75daa7ec0e2f4417fcaf02023-03-26T07:24:47.000Z0xd01e96f9fb3c08c556d85d8c3f35bb5e2490d27cbb592f99b33a204957c2f87a103075235
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false178153041053166051602422840000000000x5f317fdc121478b54f04154b1348babc44bdcbc22022-08-08T21:52:42.000Z0xbada61d77336e30f8c3ad31b2339d133380b715d989bbebf70e6561fbbcdbce92372437808
0xcc12532e95c2a6a4c53af153b9b739a3cc9218a7false200153011382754636665581973012480x53954a6191ad795e331cffdb1b035d389f2ac5162022-08-08T10:54:40.000Z0x614a37a326c824da7f6e12d81e1563b98df06518f39858c3e3d8f3b653ad3e3c1973668
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.CaravelExchange_Withdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_inAssetSTRINGContract address of the input token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_outAssetSTRINGContract address of the output token received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_inAmountSTRINGAmount of input tokens sent to the swap. String-encoded integer representing token quantity in the asset’s smallest denomination.
in_outAmountSTRINGAmount of output tokens received from the swap. String-encoded integer representing token quantity in the asset’s smallest denomination.
in_auxiliaryDataSTRINGAuxiliary data associated with the swap event. Hex-encoded byte string varying in length and content depending on the swap protocol or router identifier.
addressremovedlog_indexin_inAssetin_inAmountin_outAssetblock_numberin_outAmountin_recipientblock_timestampin_auxiliaryDatatransaction_hash
0x2e9c6dcdca22a5952a88c4b18edb5b54c5155bc9false2990xdac17f958d2ee523a2206206994597c13d831ec724750000000x00000000000000000000000000000000000000001406808610989783191632381850x1111111254fb6c44bac0bed2854e76f90643097d2022-01-24T11:33:42.000Z0x31494e43480000000000000000000000000000000000000000000000000000000xa38c4267bf3bd2912c213612aab1d372ad8fdfc2e578822156f9b5faa03ed84b
0x2e9c6dcdca22a5952a88c4b18edb5b54c5155bc9false100xdac17f958d2ee523a2206206994597c13d831ec7334963200000x000000000000000000000000000000000000000014066715136660266921939138680x137f48d01459944fefc1f637feeafe49c0f6e69c2022-01-24T06:29:50.000Z0x30782056495020504c5020526f757465720x142d1dee6579513ac67a91e6aea5847b97fb8a988d6ec43e2fb0b8ef21d9769e
0x2e9c6dcdca22a5952a88c4b18edb5b54c5155bc9false720xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48155105321600x00000000000000000000000000000000000000001406954769265316657588561270x137f48d01459944fefc1f637feeafe49c0f6e69c2022-01-24T16:56:17.000Z0x30782056495020504c5020526f757465720xab88e35050e6b7b4d20fb356f160a1a25901431eeedb07783e4fb7a8fee00da8
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.ExchangeInterface_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_depositorSTRINGAddress of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
in_depositAmountSTRINGAmount 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).
addressremovedlog_indexblock_numberin_depositorblock_timestampin_depositAmounttransaction_hash
0x51b0efa27ff4f29f8315496f01952377d581ce73false173165862680xbc62985faabed27a8f174cbd5ea1ee7b1ed8fc122023-02-08T19:57:47.000Z109254509132247153250x539055f7bc131544ef43e50799efadc1beac8c854c75bd3f1c26195f3f17052e
0x51b0efa27ff4f29f8315496f01952377d581ce73false309165833790x2522c45d1c497c5d46edadfaf9f74c9a381bf2222023-02-08T10:11:11.000Z966046868696396428910xbafcc520d00d22c2ef3a618f1d21f7b828cf0f0be953a51386661892e0161583
0x51b0efa27ff4f29f8315496f01952377d581ce73false59165838000xf63116029a4eea6f0e22e2e7725709fcfdc3e98a2023-02-08T11:35:23.000Z10000000000000000000000xc7455b23ce26de0ad49b829b4505b89b6a6b551ab237ebec3bb2630733e9b6c0
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.FeeSplit_LPDeposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_depositorSTRINGAddress of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
in_depositAmountSTRINGAmount 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_withdrawnTokensSTRINGAmount 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.
addressremovedlog_indexblock_numberin_depositorblock_timestampin_depositAmounttransaction_hashin_withdrawnTokens
0x51b0efa27ff4f29f8315496f01952377d581ce73false126160202950x710dc8c61b177687f1e3c085f694896cdc4382092022-11-21T18:51:35.000Z68997527167430142708310x192965f789ba53e7f91208ec786ff263ff0f0e291c5eef50d34fb40feab8fed76697857476689208812654
0x51b0efa27ff4f29f8315496f01952377d581ce73false355174483330xe219343e6dddd9d82ad44cac95a11111e5ec31a12023-06-10T07:36:23.000Z125939428162999155430x7d1203b99fdaf9fe29c1df554d71d05a39665a8a775b88984f57a6f4dbffdf4512072130529342572706
0x51b0efa27ff4f29f8315496f01952377d581ce73false284174483060x9452a94e92d3bf33f5f441c1b6dc4be58d1967f52023-06-10T07:30:59.000Z128176142307286166740x037af830e35a075e8eab82b80f30b9c3ab7b00260d1d2258d51cdd57054e603112286534433668007010
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.FeeSplit_LPWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_withdrawerSTRINGAddress of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.
in_poolTokensSTRINGAmount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.
in_assetAddressSTRINGContract address of the asset token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_assetAmountSTRINGAmount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.
addressremovedlog_indexblock_numberin_poolTokensin_withdrawerin_assetAmountblock_timestampin_assetAddresstransaction_hash
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse17415995202245175815290717470720x87df2b057cfcea2e21f8f0ac8f12d87f8acf6c4d167762353270297962022-11-18T06:47:35.000Z0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20x045d508c9cd5d9c1595f6ef13145f667fea817f2f6ecbb4b19c353f0390b6c1d
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse7415997788110170642693121638400xb3cd96103ce7cc6b17f834641e27f599a8e4394575444183003888262022-11-18T15:26:47.000Z0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20xbfc6ee1b634d0ceae052b6441aba5ebbbc70d06d52bcf738a539c55184e73b04
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse7116682922146404483080853361100x617711eceff56d7fbe72ccfa642beb402058842c150591342023-02-22T08:52:23.000Z0xdac17f958d2ee523a2206206994597c13d831ec70xa53d8d94fde7008abf1ecf7ce3e202a2a9909240204828fc1f4002d9e320ec23
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.VerifiedCaravelExchange_AssetWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_depositorSTRINGAddress of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
in_poolTokensSTRINGAmount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.
in_nDaysSTRINGNumber of days for which the deposited liquidity pool tokens are locked. String-encoded integer value.
addressremovedin_nDayslog_indexblock_numberin_depositorin_poolTokensblock_timestamptransaction_hash
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse10644153986060x73b811c882ec2ded70a90202dc869e8a8bc4a53c102562585567559680002022-08-23T19:57:29.000Z0x98d9b82f2d64531bf4fec446b9a5eacf989cc05a0ef88e20cb495e6b96e8e406
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse0202164714790x205e8c5b8b9ab41e934ebf394aa319ccbdedd3bb66515164298365320840912023-01-23T19:04:35.000Z0x84fbca83087135e6df182b570470335ce9d8c9f637a3a9e1e06ec016f5301d5b
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse096164718400x205e8c5b8b9ab41e934ebf394aa319ccbdedd3bb66431047695138459484162023-01-23T20:17:35.000Z0xc0bd0e3cb740e2b1483764ac79803cfe843ecdd4ca5ab7de5e5f7b7400702972
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.VerifiedCaravelExchange_Deposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_inAssetSTRINGContract address of the input token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_outAssetSTRINGContract address of the output token received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_inAmountSTRINGAmount of input tokens sent to the swap. String-encoded integer representing token quantity in the asset’s smallest denomination.
in_outAmountSTRINGAmount of output tokens received from the swap. String-encoded integer representing token quantity in the asset’s smallest denomination.
in_auxiliaryDataSTRINGAuxiliary data associated with the swap event. Hex-encoded byte string varying in length and content depending on the swap protocol or router identifier.
addressremovedlog_indexin_inAssetin_inAmountin_outAssetblock_numberin_outAmountin_recipientblock_timestampin_auxiliaryDatatransaction_hash
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse2600xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb482797685910x2260fac5e5542a773aa44fbcfedf7c193bc2c5991560143014646090xf2f400c138f9fb900576263af0bc7fcde2b1b8a82022-09-24T06:29:11.000Z0x31494e43480000000000000000000000000000000000000000000000000000000x9f1edca79817f28e40b6a06aa53d417a811a6fb81f2d872dc98c8d8a46223b6d
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse3370xdac17f958d2ee523a2206206994597c13d831ec75000000000x2260fac5e5542a773aa44fbcfedf7c193bc2c5991560211226266750xf2f400c138f9fb900576263af0bc7fcde2b1b8a82022-09-24T08:46:11.000Z0x31494e43480000000000000000000000000000000000000000000000000000000x38624c776433dbc8c7f05eca2d3f6a96dc6bf85a4cd2b44bea5ea06722b30812
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse2720xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb485210935110x2260fac5e5542a773aa44fbcfedf7c193bc2c5991560359027217470xc6cf51f57969129654c5014748e44e2a8f6ebd812022-09-24T13:42:59.000Z0x6f646f732e78797a0xa8175e7d3d515da47686171b028e05244e03d77d0f14a01f21895eb991c18516
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.VerifiedCaravelExchange_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_withdrawerSTRINGAddress of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.
in_poolTokensSTRINGAmount of liquidity pool tokens deposited or withdrawn. Integer value representing token quantity in smallest unit.
in_fractionOfPoolSTRINGProportional share of the liquidity pool being withdrawn, expressed as parts per ten million. Integer value where 10000000 represents 100% of the pool.
addressremovedlog_indexblock_numberin_poolTokensin_withdrawerblock_timestamptransaction_hashin_fractionOfPool
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse20017050928293846906018853161040xaf0f1b6443fb2c398ad3d10c62cb7288675ab88d2023-04-15T07:25:59.000Z0x5d4859c5c2a70ba63fe1241e06b596ad5806a515dd1d78a9c8291027eb4e25d2422921
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse56175408319298045116478828118640xbe76032c4aa5631a99e7439f10f0b72d9f5b84122023-06-23T07:36:47.000Z0x5d818b75d33f7af6b9371b3445116883fd6c716e1665e4a387720b30eb54f9d282495405
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216cfalse3361754263729176309525260628738780x12bb166f997146d3d33645146eedbc4a923195d72023-06-23T13:43:11.000Z0x33947f80d23b1a915ade5ffb571a5d7c579ec9279e14d307e52a17cd2aaf93e7261015356
Query with partition filter
SELECT *
FROM `tt-contracts.clipper_v1_ethereum.VerifiedCaravelExchange_Withdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100