clipper_v1_arbitrum

Tables

PackedVerifiedExchange_AssetWithdrawn_event

Liquidity withdrawal events from Clipper decentralized exchange (DEX) on Arbitrum, capturing when users redeem pool tokens for underlying assets. Used for tracking liquidity provider exits and analyzing pool token redemption patterns.

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

address	removed	log_index	block_number	in_poolTokens	in_withdrawer	in_assetAmount	block_timestamp	in_assetAddress	transaction_hash
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	2	56026535	6986193328257630208	0x6601ece318071cea07ed719c03933d19a9dac6b3	7901461	2023-01-28T03:34:16.000Z	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0xf6076b170dbec423984d76298997d52c29c5afe88d2e8be7b7c6386a8972e054
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	2	56207077	23155335736483381248	0x58d908a3a5931f3b744e3c442ac7624d2b20973e	26080016	2023-01-28T20:09:45.000Z	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0x85bf5711b998c261d021acc5fa9cecd5b212b9cd65b37eb56a9b7af8c2bbbcd2
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	2	56098597	33558913314966582645	0x157601da9cb976a5fa18ad335edad9742764be8e	37921806	2023-01-28T09:58:31.000Z	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0x62d5210fde67a391dff6a57ad6b356ae4565da4934d2f3731ceb58de26cd0aa1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.clipper_v1_arbitrum.PackedVerifiedExchange_AssetWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PackedVerifiedExchange_Deposited_event

Liquidity deposit events from Clipper DEX on Arbitrum, recording when users add funds to the exchange’s liquidity pool. Tracks depositor addresses, pool token amounts minted, and lock periods for analyzing liquidity provider behavior and pool growth.

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

address	removed	log_index	block_number	in_depositor	in_poolTokens	block_timestamp	transaction_hash
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	2	95970502	0xaf7bf051a26344b1863d05d4e20192613ddacd19	19696257138298409225	2023-05-30T10:33:54.000Z	0xb00b728fbc4939ffe86a4b8c85037eaeef9a6c31ae74e5ba269af4444d426e48
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	2	95826969	0x7e61104468731841729bb3f5788b8edd4342e8be	19732781117514711040	2023-05-30T00:20:46.000Z	0xaa654918c484de5a88633119058e07be24a8ecfb65af8da7318a53f7ba0e9ccd
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	3	95941276	0x3ed0326fe94eacb453f166be7803b7abb9790685	20117683636747108352	2023-05-30T08:32:39.000Z	0x81364a45e73b31e9a73b4cca49e538fefc4bd5348478f6df13467894fa0fc280

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.clipper_v1_arbitrum.PackedVerifiedExchange_Deposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PackedVerifiedExchange_Swapped_event

Token swap events from Clipper DEX (decentralized exchange) v1 on Arbitrum. Records input/output token addresses, amounts, and recipient data for analyzing trading volume and liquidity provision.

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

address	removed	log_index	in_inAsset	in_inAmount	in_outAsset	block_number	in_outAmount	in_recipient	block_timestamp	in_auxiliaryData	transaction_hash
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	3	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	8080	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	44645495	1368094	0xe1b66965333c01203fd50c3fb7c908fc10fe83b7	2022-12-08T16:33:51.000Z	0x00000000000000000000000000000000000000000000000000436c6970706572	0x44170cd5460be0f0cba3e7f363da05a4e36fc804c6aa962125628f2815bf1440
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	68	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	27691	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	44486550	4642536	0x9f887adb02858351fa2aaa5a8cb9f11ac2e10c5d	2022-12-08T02:15:36.000Z	0x6f646f732e78797a	0x5bf87340e82c1ead5cacf7cbd769d29c588017a0a7bf4d68e8c202f5db20a75e
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	3	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	30090	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	44663433	5105321	0xf7280f5b6ee18c30841a29110f6fe5366fe9c501	2022-12-08T18:05:38.000Z	0x00000000000000000000000000000000000000000000000000436c6970706572	0xfed0710efda58e161c2b5442f5d8b45f400d332ed124adf142a338936465360a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.clipper_v1_arbitrum.PackedVerifiedExchange_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PackedVerifiedExchange_Withdrawn_event

Liquidity withdrawal events from Clipper DEX (decentralized exchange) on Arbitrum, recording pool token redemptions with withdrawal amounts and pool share fractions. Used for tracking liquidity provider exit activity and pool composition changes over time.

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

address	removed	log_index	block_number	in_poolTokens	in_withdrawer	block_timestamp	transaction_hash	in_fractionOfPool
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	6	138459107	5013640196164419584	0x6d132b79c37b087fe3bebaab1fcd1ef6aaadd6d1	2023-10-07T15:59:50.000Z	0x7064962710b7d2bf9d2c62ae1151931f6a04653eb243712d0f1cb174b30a58e7	2977786
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	8	222735397	26769900298420879360	0x147a994978b6319b399425fa0d2c4fa3f7152f74	2024-06-17T07:46:56.000Z	0xd8b0a710436f12025dfa0ebfb7b2c476eda6861b45759c4821f92201318680cb	68185232
0xe7b0ce0526fbe3969035a145c9e9691d4d9d216c	false	6	67853865	219599239618465272024	0x3a42086e4c2511e502c0b6ca87e35c8455388d39	2023-03-08T08:46:51.000Z	0x303636e77ceebd34c0124e4ece50d6c02315650a822752e8005dac618a4383f4	3349101

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.clipper_v1_arbitrum.PackedVerifiedExchange_Withdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

PackedVerifiedExchange_AssetWithdrawn_event

PackedVerifiedExchange_Deposited_event

PackedVerifiedExchange_Swapped_event

PackedVerifiedExchange_Withdrawn_event

​Tables

​PackedVerifiedExchange_AssetWithdrawn_event

​PackedVerifiedExchange_Deposited_event

​PackedVerifiedExchange_Swapped_event

​PackedVerifiedExchange_Withdrawn_event

Tables

PackedVerifiedExchange_AssetWithdrawn_event

PackedVerifiedExchange_Deposited_event

PackedVerifiedExchange_Swapped_event

PackedVerifiedExchange_Withdrawn_event