clipper_v1_optimism

Tables

PackedExchange_AssetWithdrawn_event

Liquidity withdrawal events from Clipper DEX automated market maker on Optimism. Records pool token burns and corresponding asset redemptions with withdrawer addresses for analyzing liquidity provider behavior.

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
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	2	5566258	13148942025329999872	0xcbad01980e700fbf6bea01b3c25adcd25c22e4b2	3787759730925977	2022-04-09T06:50:28.000Z	0x4200000000000000000000000000000000000006	0xb5bb7112ce3fad1ac5949435c4ddc08cc5933f56ee917050a7ee91d4401b7599
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	2	5571418	465191802387455541248	0x0caee49bdd3440735cea29f855afcc19c0214875	133835829631848512	2022-04-09T10:25:05.000Z	0x4200000000000000000000000000000000000006	0xb339460cd52322c0ef6f65cca7370c319a33fe94d92e76647e885944ed8df83d
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	2	5579109	848017632559353561088	0x0359f194b3b801a1cce464eb8367a5a7b796a69d	782404996	2022-04-09T14:38:20.000Z	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0xa984f60140dce276278263dc85c3867c490bfde208154929e0f4dbfcc88c7fc2

Example Query

Query with partition filter

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

PackedExchange_Deposited_event

Liquidity deposit events from Clipper DEX on Optimism, recording when users add pool tokens to liquidity positions with 30-day lock periods. Tracks depositor addresses, pool token amounts, and deposit timestamps 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	in_nDays	log_index	block_number	in_depositor	in_poolTokens	block_timestamp	transaction_hash
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	30	2	4161831	0x1a05dcaf88908855d2f5a4b99a62033fdb1d556a	1173180603730252267520	2022-03-06T04:57:55.000Z	0x92fd044112f3874c76e9dbefbd69660c94d0de425bf2b34de41416b86ec3c6d2
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	30	2	4169003	0x174eed5f04ac50dcb6d75ec680b2e26fac26b021	1544016627744374784	2022-03-06T11:02:27.000Z	0x11c930776e6549a1c4403a2b27c19c06de7d8012a59edb99c23e6fba63f60854
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	30	2	4169516	0x4c50dc9d37750690ea1814c359111c3b5b34f59a	1543553047228055552	2022-03-06T11:20:02.000Z	0x026976409047fbff19273434c065b40888e305d3208c4a8336d6a3a6662b606c

Example Query

Query with partition filter

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

PackedExchange_Swapped_event

Token swap event logs from Clipper decentralized exchange (DEX) on Optimism. Tracks individual swaps with input/output token addresses, amounts, recipients, and routing metadata for analyzing trading volumes and liquidity pool 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_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
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	2	0x4200000000000000000000000000000000000006	25353951958240792	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	4571369	5000000000000000000	0x3170b8bfbe8b8938c9c42006ddd5faec04232bbf	2022-03-18T13:45:04.000Z	0x436c697070657200000000000000000000000000000000000000000000000000	0xec6cd1c7f2f551cb9061430a1f86b3b9a26a2ce0f3b049d143087faf344b8771
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	4	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	8708682952666233789	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	4584346	594651138578054016	0x26271dfddbd250014f87f0f302c099d5a798bab1	2022-03-18T21:52:57.000Z	0x31494e4348000000000000000000000000000000000000000000000000000000	0x0c4f9a68386299df60e5b91b1a29346a7a3b8c0eb3e6e81ca3a87835f37dc1ca
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	8	0x68f180fcce6836688e9084f035309e29bf0a2095	476705	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	4581063	13741456254558855168	0x26271dfddbd250014f87f0f302c099d5a798bab1	2022-03-18T19:27:59.000Z	0x31494e4348000000000000000000000000000000000000000000000000000000	0xdc73dc84eaac8cf8374aa4f7e7dde7899764df003c40de892aa02e1c56b03d63

Example Query

Query with partition filter

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

PackedExchange_Withdrawn_event

Liquidity withdrawal events from Clipper DEX on Optimism, recording user withdrawals with pool token amounts and fractional pool ownership burned. Used for tracking liquidity provider exits 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
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	10	111827902	6567200681810198528	0x55f7c152b0c3cc1cd7479e4858ac07f50d7fcfad	2023-11-06T07:09:41.000Z	0x422634b608b01b1e0c5bf15f4d294e4c66b9be974b8e3ee8e1be3362f2a05bf6	777949
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	7	111821290	19743702550742827008	0x510bd31beeecb96deead3ff41def09c915a894d1	2023-11-06T03:29:17.000Z	0x927a494f575b8f6813bd84d337a7563830b85cc86f5540f0d5a6e4501ad22ba6	2338289
0xdbd4ffc32b34f630dd8ac18d37162ec8462db7db	false	7	34873937	111674824959216058368	0x19fc61b27c96e4c84375128b02ca5dcdaa11a075	2022-11-06T04:29:58.000Z	0xf0b195ec925ea016b919f2f300b2415e85074bf7681d074e231dccb37e1f5e9a	3322375

Example Query

Query with partition filter

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

PackedVerifiedExchange_AssetWithdrawn_event

Liquidity withdrawal events from Clipper DEX (decentralized exchange) on Optimism capturing when users remove assets from pools. Records withdrawer addresses, asset amounts in wei, pool token amounts burned, and the specific asset withdrawn for analyzing pool liquidity changes.

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
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	2	86399096	653722615961243204	0x0ec5e6656f15851072f67eeaee50fcf76174cd07	16829116988254772	2023-04-05T08:54:05.000Z	0x4200000000000000000000000000000000000006	0xab57ac825002f19eea50ff0e104912fecd2c7994bd4ec55de1b602bea9265f5a
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	2	86555429	857273950784736705	0x556bb6e2224c09b4552adf7548f7e2c23d31eaa7	21969912843369248	2023-04-05T19:26:20.000Z	0x4200000000000000000000000000000000000006	0x77af2cc2973d1e0aff9c183a80fca5d0c95a88a04d0a1efc7b3a38e70dfb892f
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	2	86417845	625079486147310539	0x32e90eee99ee013b6d33bd312490e202a186f4c6	16083071638798950	2023-04-05T10:07:10.000Z	0x4200000000000000000000000000000000000006	0xd55c54096f485add571e7c5dbf3893a305cd94fc886235840e693da451fd4a91

Example Query

Query with partition filter

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

PackedVerifiedExchange_Deposited_event

Liquidity deposit events from Clipper decentralized exchange (DEX) on Optimism, recording when users add pool tokens to the protocol with a 10-day lock period. Used for tracking liquidity provider activity and time-locked deposit 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_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
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	10	2	31869002	0x01676c9d76fe3794ac94b8c44309c466e622e135	610347562206867883	2022-10-27T05:11:26.000Z	0xa324c6b30b0e8c0438b98c14a4bd48d653c9ed9bfc434b6d1ac3e37108e84439
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	10	2	31911320	0x01fb3dfbd0661aa7ad086c01d3d7c9931b9d3dbe	633143606937575751	2022-10-27T08:10:14.000Z	0xb8003de018c1ecdf05b4b193343b033de14bfde57a516dcea14a91017e29dfe0
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	10	2	32047603	0x022fd217aa05e82c2e8fa3ebe77eff893329e97c	670216609511505920	2022-10-27T17:27:41.000Z	0xa2378ab43ca1bc1b487af30b8222f9cfed359dd691060c55e69da8aec4ce5bc7

Example Query

Query with partition filter

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

PackedVerifiedExchange_Swapped_event

Swap execution events from Clipper DEX (decentralized exchange) v1 on Optimism, recording token pair addresses, amounts exchanged, and recipient details. Used for analyzing trading volume, token pair liquidity, and swap routing patterns through 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
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	12	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	36552	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	105470491	7258252360093671	0xafea5601b0a894451955355e79ad3026515e500d	2023-06-12T03:15:59.000Z	0x31494e4348000000000000000000000000000000000000000000000000000000	0xcc5f12b508477b11029bc80e2142371487d5a23e26fe8e85fead587ad5157ca9
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	15	0x4200000000000000000000000000000000000006	587959766626274304	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	105468227	200000000000000000000	0x3a42086e4c2511e502c0b6ca87e35c8455388d39	2023-06-12T02:00:31.000Z	0x00000000000000000000436c69707065723a42086e4c2511e502c0b6ca87e35c	0x808a45180658943aa2f45a2f32d6057d64e2f0da75f3fc2f8fcc6e44ee8e90c4
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	22	0x68f180fcce6836688e9084f035309e29bf0a2095	8446	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	105470342	433372294272037952	0xafea5601b0a894451955355e79ad3026515e500d	2023-06-12T03:11:01.000Z	0x31494e4348000000000000000000000000000000000000000000000000000000	0x2faa75a4ad706827b125f71c418fccdf0d0438ca466f9b89ff0966a03913079c

Example Query

Query with partition filter

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

PackedVerifiedExchange_Withdrawn_event

Liquidity withdrawal events from Clipper decentralized exchange (DEX) on Optimism, recording when liquidity providers remove assets from trading pools. Tracks withdrawn pool token amounts, pool ownership fractions, and withdrawer addresses for analyzing LP behavior and pool liquidity changes.

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
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	566	114481502	601394248360962940	0x54e047e98c44b27f79dcfb6d2e35e41183b8dff6	2024-01-06T17:23:01.000Z	0xd7f153388e21a8cbecaaeb987aa631c2405e1d301635d859d91d72bcd0d48e6c	782501
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	36	114477865	404120665802670080	0xf2a9a48c0d2628a682d2ff3060741a81f97ff398	2024-01-06T15:21:47.000Z	0xb1212c579d74ac6614b0f561782a4f8cd174c07ace49b4cbfdea653ae53216c3	524656
0x5130f6ce257b8f9bf7fac0a0b519bd588120ed40	false	9	77570453	316982697508896561	0x7d78677ef3b9e71a5e5696171dc55301244f579c	2023-02-27T15:18:51.000Z	0x3820625af7e712b4c1f206954958529340b2ae4c834ed4492f3774276bcc1dca	183446

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

PackedExchange_AssetWithdrawn_event

PackedExchange_Deposited_event

PackedExchange_Swapped_event

PackedExchange_Withdrawn_event

PackedVerifiedExchange_AssetWithdrawn_event

PackedVerifiedExchange_Deposited_event

PackedVerifiedExchange_Swapped_event

PackedVerifiedExchange_Withdrawn_event

​Tables

​PackedExchange_AssetWithdrawn_event

​PackedExchange_Deposited_event

​PackedExchange_Swapped_event

​PackedExchange_Withdrawn_event

​PackedVerifiedExchange_AssetWithdrawn_event

​PackedVerifiedExchange_Deposited_event

​PackedVerifiedExchange_Swapped_event

​PackedVerifiedExchange_Withdrawn_event

Tables

PackedExchange_AssetWithdrawn_event

PackedExchange_Deposited_event

PackedExchange_Swapped_event

PackedExchange_Withdrawn_event

PackedVerifiedExchange_AssetWithdrawn_event

PackedVerifiedExchange_Deposited_event

PackedVerifiedExchange_Swapped_event

PackedVerifiedExchange_Withdrawn_event