clipper_v1_polygon

Tables

ClipperVerifiedExchange_AssetWithdrawn_event

Liquidity withdrawal events from Clipper DEX (decentralized exchange) on Polygon, recording when users remove assets from liquidity pools by burning pool tokens. Tracks withdrawer addresses, withdrawn asset amounts, and corresponding pool token amounts for analyzing liquidity provider behavior.

Columns

Column	Type	Description
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`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	log_index	block_number	in_poolTokens	in_withdrawer	in_assetAmount	block_timestamp	in_assetAddress	transaction_hash	transaction_index
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	206	35243046	49055184090610805399	0x8e2a341007f90b10aff2ee33ff5d01b94ea3df45	34421077064107520000	2022-11-05T19:20:47.000Z	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xdd45ca67b9fc9c6b74e210ef614e594f9f1a47dbb8ad64f43bc09d0282d164d7	41
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	607	35245136	6084350477281512404	0xf8014a5f9c8f2ed1a5b2b4e2a53495d37748c12d	5094843	2022-11-05T20:32:39.000Z	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x24cba4c693627662666da65a8d071d305e3c49d8f1357afea2d39e55dbde9493	27
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	307	35209881	64329413742616390925	0x0ee29122043c1645812b41bcfb6660f95f5a81fc	53589072	2022-11-05T00:00:52.000Z	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x23d8cf9aef8241d0e201f791f3afe7ade329e42b4cef6a13afea6f6eddd7311e	55

Example Query

Query with partition filter

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

ClipperVerifiedExchange_Deposited_event

Liquidity deposit events from Clipper DEX (Decentralized Exchange) on Polygon, recording when users add funds to liquidity pools with depositor addresses and pool token amounts. Useful for analyzing liquidity provider behavior and pool growth over time.

Columns

Column	Type	Description
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`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	log_index	block_number	in_depositor	in_poolTokens	block_timestamp	transaction_hash	transaction_index
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	167	32148961	0x2370cb1278c948b606f789d2e5ce0b41e90a756f	2007068417345557243	2022-08-21T10:50:12.000Z	0x75397cef713b5792d37ed8e70933956a0e1083e9ecc4e62bf627f70f1f1094c1	49
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	143	32163613	0x2370cb1278c948b606f789d2e5ce0b41e90a756f	47038451535785632208	2022-08-21T19:29:08.000Z	0x07dc35573ddb14249c74ef9a4ab3b45cd3fd83c9089088ec6b7ee30757fc824c	31
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	192	32145999	0x2370cb1278c948b606f789d2e5ce0b41e90a756f	130018828503384549110	2022-08-21T09:06:07.000Z	0x3460085b4bfeb9b75b5f58ffaaf5d7bdb0d4697c5134ba2498daa1b77138af84	58

Example Query

Query with partition filter

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

ClipperVerifiedExchange_Swapped_event

Token swap events from Clipper decentralized exchange (DEX) on Polygon. Records input/output token pairs, amounts, recipients, and routing metadata for analyzing trading volumes and price execution.

Columns

Column	Type	Description
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`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	log_index	in_inAsset	in_inAmount	in_outAsset	block_number	in_outAmount	in_recipient	block_timestamp	in_auxiliaryData	transaction_hash
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	7	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	6730905	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	33791311	8667023101588711424	0x13927a60c7bf4d3d00e3c1593e0ec713e35d2106	2022-10-01T10:07:10.000Z	0x31494e4348000000000000000000000000000000000000000000000000000000	0x84812de8d6d810f46b980221d3fc0f6fd652e399b88ccb3977a4e2bc4114b327
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	3	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	5007249919521403	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	33811479	8573225471744080896	0x13927a60c7bf4d3d00e3c1593e0ec713e35d2106	2022-10-01T21:46:02.000Z	0x31494e4348000000000000000000000000000000000000000000000000000000	0x4ed0ce9b771475c79a3f6909bcf078228dc206d893632de0ad80bc1f6039f378
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	3	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	144000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	33808376	187852012613293473792	0x13927a60c7bf4d3d00e3c1593e0ec713e35d2106	2022-10-01T19:59:20.000Z	0x31494e4348000000000000000000000000000000000000000000000000000000	0x344ede907a6f6a481783b51e6c770496046c18b7a460d0677c71721ef5934d27

Example Query

Query with partition filter

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

ClipperVerifiedExchange_Withdrawn_event

Liquidity withdrawal events from Clipper decentralized exchange (DEX) on Polygon, recording when liquidity providers remove assets from trading pools. Contains withdrawal amounts in pool tokens, fractional pool ownership shares, and withdrawer addresses for tracking liquidity provider behavior.

Columns

Column	Type	Description
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`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	log_index	block_number	in_poolTokens	in_withdrawer	block_timestamp	transaction_hash	in_fractionOfPool	transaction_index
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	194	30826437	9831736989972733384	0x71cfafc5f334527fd65821c0cba69f000ad14f07	2022-07-17T14:51:50.000Z	0x22fc768906a397c40693e441fa4452c70c4ed174f6bc129ca9b26f1d676386e3	51994	45
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	180	30827143	10114160514053016779	0x71cfafc5f334527fd65821c0cba69f000ad14f07	2022-07-17T15:18:14.000Z	0xce29ebae368fff5957a3fcaef9f0b90fb41ea8689e64599fb6ea3bb7a1c3a870	53489	38
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	182	36557360	12835304006634531246	0x9533fdce9a91c93cb16076b1abc65b4a47bba397	2022-12-08T00:41:19.000Z	0x8bb6f51d5f9c5d044296bdba5dd826ac12b7554e2e4c0ae4edfd2f2fc3d697e7	160192	40

Example Query

Query with partition filter

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

DirectExchange_Deposited_event

Liquidity provider deposit events from Clipper DEX (Decentralized Exchange) on Polygon, recording pool token amounts and optional time-lock periods. Used for tracking LP participation patterns and analyzing locked versus unlocked liquidity deposits.

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	in_nDays	log_index	block_number	in_depositor	in_poolTokens	block_timestamp	transaction_hash
0xd01e3549160c62acabc4d0eb89f67aafa3de8eed	false	0	187	22801068	0xab83af831dfb4028ebfd3ffa74a828a4d5dcaac5	940050210703278080	2021-12-21T19:56:11.000Z	0x19eb03f8c00260307a2d5c887509b4e78d9fdc8481d27ee4fb391b1b75b0efb9
0xd01e3549160c62acabc4d0eb89f67aafa3de8eed	false	60	75	22797390	0xbe611f2433e0d61ec3a0f7f156248f6c915d1711	278593870250729537536	2021-12-21T17:40:35.000Z	0x418f412d6523f6189f8f8795f6b02f43fc20a5bb1c3537a200753625a795dfdc
0xd01e3549160c62acabc4d0eb89f67aafa3de8eed	false	60	71	22780373	0xbf8c9c73c58ae8a78cc4f58eeb4aef5914d0d574	754112957178099793920	2021-12-21T07:33:03.000Z	0xf342f3637e363968873ae5d35aa91f698bfd5af7493b3e250ca9d98d432b3154

Example Query

Query with partition filter

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

DirectExchange_Swapped_event

Swap event records from Clipper DEX (decentralized exchange) on Polygon, capturing token exchanges with input/output amounts, assets, and recipient addresses. Used for analyzing trading volume, slippage patterns, and liquidity provider performance on Clipper’s automated market maker.

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
0xd01e3549160c62acabc4d0eb89f67aafa3de8eed	false	47	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	185000000000000000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	22272528	184616387895861477376	0x32098992550f9b5aaefa32e33d169faa5cfaa738	2021-12-08T09:25:23.000Z	0x436c697070657200000000000000000000000000000000000000000000000000	0xecf59ead3af2a6cf4b0168c236d3da9ac463f2f0029a9cc8dc66101ac6ea466d
0xd01e3549160c62acabc4d0eb89f67aafa3de8eed	false	134	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	997000000000000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	22276947	995005604156487680	0x2e8029fe0e80987e6dba3c6511fab64581be94b4	2021-12-08T12:10:13.000Z	0x436c697070657200000000000000000000000000000000000000000000000000	0x204d8200d274338cbb131cc8db3d731a450f812e56b3ed7cf4f6af0351ce6311
0xd01e3549160c62acabc4d0eb89f67aafa3de8eed	false	116	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	195000000000000000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	22265624	194595023820131008512	0x1a393f18f3fb0fc6e0acbc24c873b2622e2a35a3	2021-12-08T04:28:05.000Z	0x436c697070657200000000000000000000000000000000000000000000000000	0x909f5084a7ece5e9501d3c96aac1b3977b1cc157fb5cdf8e035d12e4b359a7a5

Example Query

Query with partition filter

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

DirectExchange_Withdrawn_event

Liquidity withdrawal events from Clipper decentralized exchange (DEX) on Polygon, recording when liquidity providers remove pool tokens and their proportional share. Contains withdrawer addresses, pool token amounts, and fraction of total pool withdrawn for analyzing LP behavior and liquidity trends.

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
0xd01e3549160c62acabc4d0eb89f67aafa3de8eed	false	617	26545666	188178540285151674368	0x230a4a9cc3d57fe07c75ba1b063c779f328230fa	2022-03-30T16:44:33.000Z	0x5c85751a1b5d7cbab44b7c929a464a421e4522cb55c92b2b03be5de31e1c2e23	767287
0xd01e3549160c62acabc4d0eb89f67aafa3de8eed	false	258	26540028	130992140372383105024	0x1e38019066a2046c9e21d425f70ceea41f5a3153	2022-03-30T13:16:57.000Z	0x9c2cc59a3454f9f253a25e525dfbe2f791b5fb1e4d8f5e4e713d9c051b08bd7e	533901
0xd01e3549160c62acabc4d0eb89f67aafa3de8eed	false	436	26539268	188501477364309426176	0x0df7b9519341d71019b696c024d8e10910552322	2022-03-30T12:50:53.000Z	0x157642f824715b58c114703814526444a90c00b5164dca1a462e68e737e1abe5	768197

Example Query

Query with partition filter

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

VerifiedExchange_AssetWithdrawn_event

Liquidity withdrawal events from Clipper DEX (Decentralized Exchange) on Polygon, capturing when liquidity providers remove assets from pools with corresponding pool token burns. Records asset amounts, pool tokens redeemed, and withdrawer addresses for tracking LP (liquidity provider) exit activity.

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
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	124	34225093	2093920034233016967	0x165e4e022bc79afd1cf5464b85016d41cba53201	1810171006398393344	2022-10-11T21:32:17.000Z	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x2d647b88e1b515d36e8cc5347b8f1e18fae1914dac94af41447fb84a643bdbed
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	216	34202990	13742807455960532546	0x8e7458216cca00d8089ddf0c859393c0c3e93dd5	11777833975287312384	2022-10-11T08:49:29.000Z	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xd3f68c470ccd45d552f60c58260b0b253698e1cb544b4e650e3528cea79da7b5
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	297	34202920	13736502184271728414	0x09d5e6ea41956077237062b93e7b869761061ccd	11772143784532617216	2022-10-11T08:47:02.000Z	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xa0788774647657632dca0763b8a2339a0f1a5fbcb14546eb094f80b63566547b

Example Query

Query with partition filter

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

VerifiedExchange_Deposited_event

Liquidity deposit events from Clipper DEX on Polygon, recording when users add funds to pools and receive pool tokens in return. Used to track liquidity provider activity and pool token issuance 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_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
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	8	36632308	0xac91b904fe317c9a3d447f7ae8934deb94fa210e	44122598466447312	2022-12-09T20:53:25.000Z	0x02c096192576f051ffc212cb11cf70fc6c32e3f40e6d2ab31107852c4af8c6a4
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	57	36605162	0x8fc642d66492c830da43d95da7fe3f027f4f3246	20198710503154789268	2022-12-09T04:58:47.000Z	0xf5ece8470248265879d3246f7874ea0b677a141c3bd419cfcc37d01fcb2c8313
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	70	36599138	0x3028e8434cddd7c13e0309fc894f1a18e821352f	13605980441503671258	2022-12-09T01:23:02.000Z	0xf67ccad7d3719e3186d071b1e243ef68355c7fa87aed5089054ff44a5f57975c

Example Query

Query with partition filter

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

VerifiedExchange_Swapped_event

Swap event records from Clipper decentralized exchange (DEX) on Polygon showing token pair trades with input/output amounts, asset addresses, and recipient details. Useful for analyzing trade volumes, price execution, and liquidity provider performance.

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
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	8	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	100000000000000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	69565880	865069700495514533888	0x3560a99b96b7fc8b516dbe1015b1a7821eb63b7a	2025-03-27T14:29:22.000Z	0x4a6f79	0xb1553dbc54db44a367439fa9e68e6bfbb4102531074842a9700e506a8b7f0723
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	8	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	100000000000000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	69549717	839227173772582322176	0x3560a99b96b7fc8b516dbe1015b1a7821eb63b7a	2025-03-27T04:55:10.000Z	0x4a6f79	0x6449aff0fa12f3d8f9faf3f07b9d8e596e1d96912e6583ab95f2756cc96a7c00
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	29	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	100000000000000000	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	69572625	864264084306952978432	0x3560a99b96b7fc8b516dbe1015b1a7821eb63b7a	2025-03-27T18:28:18.000Z	0x4a6f79	0xc57f4ba4004e19bfec13858c95ba103317f4862bbfc128da2bcea17ce3a84c97

Example Query

Query with partition filter

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

VerifiedExchange_Withdrawn_event

Liquidity withdrawal events from Clipper DEX on Polygon, recording when users remove funds from liquidity pools with pool token amounts and withdrawal share fractions. Used for tracking LP position exits and liquidity flow analysis.

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
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	200	70982532	14204087371425996899	0x3b55eba6479483ce906e736e1bd767aa4bd0455c	2025-05-01T14:16:19.000Z	0xfe2965ef7154580624bf1b8f6df5aa0ef3642e00a2400060f79863e1b5588010	335293
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	148	70993784	10941045103169432664090	0x93d511a0e69e01061d7e5c6c237872bf862c3396	2025-05-01T20:54:52.000Z	0xe04b705d48472df5a82b66c900bd59e6f482b42a7aa209c37e2ecfebca2cf893	258276842
0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	false	337	73074291	25853272913082823691	0xa788e0586409fa4eaf986e24604003adaa3dcc9d	2025-06-22T08:07:16.000Z	0xe74e7116a7df801cf51e7a04e512f3e74c1dce891b182dd5727afc77c1feb688	627252

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ClipperVerifiedExchange_AssetWithdrawn_event

ClipperVerifiedExchange_Deposited_event

ClipperVerifiedExchange_Swapped_event

ClipperVerifiedExchange_Withdrawn_event

DirectExchange_Deposited_event

DirectExchange_Swapped_event

DirectExchange_Withdrawn_event

VerifiedExchange_AssetWithdrawn_event

VerifiedExchange_Deposited_event

VerifiedExchange_Swapped_event

VerifiedExchange_Withdrawn_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ClipperVerifiedExchange_AssetWithdrawn_event

​ClipperVerifiedExchange_Deposited_event

​ClipperVerifiedExchange_Swapped_event

​ClipperVerifiedExchange_Withdrawn_event

​DirectExchange_Deposited_event

​DirectExchange_Swapped_event

​DirectExchange_Withdrawn_event

​VerifiedExchange_AssetWithdrawn_event

​VerifiedExchange_Deposited_event

​VerifiedExchange_Swapped_event

​VerifiedExchange_Withdrawn_event

Tables

ClipperVerifiedExchange_AssetWithdrawn_event

ClipperVerifiedExchange_Deposited_event

ClipperVerifiedExchange_Swapped_event

ClipperVerifiedExchange_Withdrawn_event

DirectExchange_Deposited_event

DirectExchange_Swapped_event

DirectExchange_Withdrawn_event

VerifiedExchange_AssetWithdrawn_event

VerifiedExchange_Deposited_event

VerifiedExchange_Swapped_event

VerifiedExchange_Withdrawn_event