camelot_v3_arbitrum

Tables

AlgebraFactory_Pool_event

Pool creation events emitted by Algebra DEX (Decentralized Exchange) factory contracts, recording the deployment of new liquidity pools with their token pair addresses. Used for tracking pool deployments and identifying tradable pairs across Algebra-based DEX implementations.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x1a3c9b1d2f0529d97f2afc5136cc23e58f1fd35b	0x43994b979f67b0c51687b3d167b8dc9c6ed304f5	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xf5a27e55c748bcddbfea5477cb9ae924f0f7fd2e	16	124759593	2023-08-25T08:05:24.000Z	0x1a8054474d1d38bb43d9126c932a11622a6e53ff97d8aed0ec8480ad862331e4
0x1a3c9b1d2f0529d97f2afc5136cc23e58f1fd35b	0x4945d0ba3eff5b0752653cc37eaec7d1fc2e6a8c	false	0x1fb37105f63f5742bf368aa25b26048499aae557	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2	124803101	2023-08-25T11:06:33.000Z	0xa8a94da74be7e29e536444ba3c81308f7e3847e3a67985fea1898bf2e8d1267e
0x1a3c9b1d2f0529d97f2afc5136cc23e58f1fd35b	0x60451b6ac55e3c5f0f3aee31519670ecc62dc28f	false	0x3d9907f9a368ad0a51be60f7da3b97cf940982d8	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	3	107705810	2023-07-04T06:34:35.000Z	0x933d1fd31cee27d4952aa3f89e1e279cf72be5620df262c2fe5476943514c8ab

Example Query

Query with partition filter

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

Factory_Pool_event

Liquidity pool creation events from Camelot V3 decentralized exchange (DEX) factory contract on Arbitrum, recording new token pair pools with their constituent token addresses. Used for tracking pool deployment history and analyzing DEX market expansion.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x1a3c9b1d2f0529d97f2afc5136cc23e58f1fd35b	0x6b4a958b6ac212ce35fddfb57ef4fae0a123ed0b	false	0x000000000026839b3f4181f2cf69336af6153b99	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	3	181469510	2024-02-16T22:17:33.000Z	0x60f2c3fefd6e37fa75ecc9edb8c564b5f56a45f053c12a962088ccbb6e22b63e
0x1a3c9b1d2f0529d97f2afc5136cc23e58f1fd35b	0x77698345745548c305ad8ea7bec664e82e566121	false	0xad1a7e7ba3b215b034c74c6cc15d895b95439812	0xaf88d065e77c8cc2239327c5edb3a432268e5831	3	214822957	2024-05-25T08:14:20.000Z	0x83be4c65f3fdd502e1b41e6c6c5f0e2845555bed19b463c43c0b75d73a74af55
0x1a3c9b1d2f0529d97f2afc5136cc23e58f1fd35b	0x26a4a37fb7a69247006c8398edf252882de3cd8d	false	0x5b32a494da6c931f3d735c8e5a23f8b7c726b305	0xaf88d065e77c8cc2239327c5edb3a432268e5831	2	214826049	2024-05-25T08:27:14.000Z	0x9926c065ddfa3e6484f115bb30b09f56b9d7b12c8ac63be9da2ef4c13d25c155

Example Query

Query with partition filter

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

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	log_index	in_amount0	in_amount1	in_topTick	block_number	in_recipient	in_bottomTick	block_timestamp	transaction_hash
0xb1026b8e7276e7ac75410f1fcbbe21796e8f7526	false	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	5	38760328858172341	76887267	-200060	143472901	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	-203020	2023-10-24T08:02:53.000Z	0x4dc896460095da7dd7b8d14922c011e37ab8663ca3c8acbc897bd11209ab19b6
0xb1026b8e7276e7ac75410f1fcbbe21796e8f7526	false	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	7	8559224689197491	14763510	-200520	143450117	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	-203400	2023-10-24T06:27:39.000Z	0x8d6730fbe0e30b411355a395cd15e4fe4b3496b2d8ad785fe822296a07e2f390
0x521aa84ab3fcc4c05cabac24dc3682339887b126	false	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	14	6173617903753828	10442719	-201420	143450117	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	-203400	2023-10-24T06:27:39.000Z	0x8d6730fbe0e30b411355a395cd15e4fe4b3496b2d8ad785fe822296a07e2f390

Example Query

Query with partition filter

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

Pool_CommunityFee_event

Community fee rate update events from liquidity pools, recording the new fee percentages allocated to the protocol or community for each token in a trading pair. Used for tracking fee structure changes and protocol revenue distribution configurations.

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_communityFee0New`	`INT64`	Updated community fee rate for token0 in basis points. Integer value representing the fee percentage allocated to the community, where 100 equals 1%.
`in_communityFee1New`	`INT64`	Updated community fee rate for token1 in basis points. Integer value representing the fee percentage allocated to the community, where 100 equals 1%.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_communityFee0New	in_communityFee1New
0x521aa84ab3fcc4c05cabac24dc3682339887b126	false	4	102858569	2023-06-19T20:04:21.000Z	0xb5aaf7974d54ee896e5c0cf258804ef5a046d2af99242e30d14b6cb45fff7b66	150	150
0xd845f7d4f4deb9ff5bcf09d140ef13718f6f6c71	false	1	102859157	2023-06-19T20:06:51.000Z	0x346ea45ed91f235b7a988f976736cbfd42455b498e18bbbdc2a4dd9db269aa9d	150	150
0x9dc5708aaf0d45b12636c7ce2960e71a8ea210c8	false	2	102859157	2023-06-19T20:06:51.000Z	0x346ea45ed91f235b7a988f976736cbfd42455b498e18bbbdc2a4dd9db269aa9d	150	150

Example Query

Query with partition filter

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

Pool_Fee_event

Fee tier configuration events emitted by Automated Market Maker (AMM) pool contracts. Records updates to swap fee parameters measured in basis points for directional trades.

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_feeZto`	`STRING`	Fee rate in basis points for swaps from token Zero to token One direction in this Camelot V3 pool. Typically set to 1 basis point (0.01%) as shown in samples.
`in_feeOtz`	`STRING`	Fee percentage applied when swapping from token one to token zero in basis points, where 1 represents 0.01%. Typically set to 1 (0.01%) for Camelot V3 pools on Arbitrum.

Sample Data

address	removed	in_feeOtz	in_feeZto	block_number	block_timestamp	transaction_hash
0xc86eb7b85807020b4548ee05b54bfc956eebbfcd	false	1	1	231056549	2024-07-11T10:42:30.000Z	0x6683bdee75a1f372bf3475b8f45ab3a380a2c5ddf216fd28cc8950dc8e47e865
0xc86eb7b85807020b4548ee05b54bfc956eebbfcd	false	1	1	231116633	2024-07-11T14:54:25.000Z	0x3fd504dd40a1f057d45bf778a0acffaa79204abf0597a4de112c56962f9685c4
0xc86eb7b85807020b4548ee05b54bfc956eebbfcd	false	1	1	231014455	2024-07-11T07:47:00.000Z	0x854d9f2dfc52116c72e1b6fd8d4c5642fa1b7b5144ee23ffb1e3167baf8604b3

Example Query

Query with partition filter

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

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation 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_sender`	`STRING`	Address that initiated the transaction or operation. 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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_paid0	in_paid1	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0xdeb89de4bb6ecf5bfed581eb049308b52d9b2da7	false	0	100000000000	0x0c74f40b9ee1f70b06824c7ea8708349e5bba31e	54	0	1000000000000000	282812733	0x0c74f40b9ee1f70b06824c7ea8708349e5bba31e	2024-12-09T01:19:50.000Z	0xac48de639637a884132ac392eec35d38d9704fac91de3bfe9d0d416a8c4b984e
0x293dfd996d5cd72bed712b0eeab96dbe400c0416	false	20111114585053	0	0xc9d66f655b7b35a2b4958be2fb58e472736bbc47	74	201111145850523508	0	213598961	0xc9d66f655b7b35a2b4958be2fb58e472736bbc47	2024-05-21T17:26:50.000Z	0x215a58cbf693fd8af28a1c7ef6f58da59d395c29c28ebb713a36ccacb64f592d
0x293dfd996d5cd72bed712b0eeab96dbe400c0416	false	126118324790436	0	0xc9d66f655b7b35a2b4958be2fb58e472736bbc47	88	1261183247904355714	0	213602862	0xc9d66f655b7b35a2b4958be2fb58e472736bbc47	2024-05-21T17:43:29.000Z	0xd9a706d4111627f0523de47aa1dc5a0e10261fc9504483e95fd0cfa9c21eb875

Example Query

Query with partition filter

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

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_liquidityAmount`	`STRING`	Amount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position’s tick range.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	in_sender	log_index	in_amount0	in_amount1	in_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
0x521aa84ab3fcc4c05cabac24dc3682339887b126	false	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	4	19999999999999017	0	-199680	129642436	-201660	2023-09-10T00:14:00.000Z	0xa823e593821bf669d8166cd7ba6d6780eeffcc54cfc70133e69df1bfec4e32c7	8870811852480
0x521aa84ab3fcc4c05cabac24dc3682339887b126	false	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	2	19999999999999017	0	-199680	129641660	-201660	2023-09-10T00:09:57.000Z	0x6650b54b3ed6e5ec4647d3fae9c9debcd822b926135e7ec4edd82a7f8115bc95	8870811852480
0x47a52b2bee1a0cc9a34bb9ee34c357c054112c3e	false	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	0x00c7f3082833e796a5b3e4bd59f6642ff44dcd15	10	718780642326854765830	494840231091817733476	-3540	129892605	-15120	2023-09-10T19:35:59.000Z	0xb270bab0ec31ebf8687d751c173b2a539c7be625502d54b55c3c09f08347011f	2442986126830968672983

Example Query

Query with partition filter

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

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

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_sender`	`STRING`	Address that initiated the transaction or operation. 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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.

Sample Data

address	in_tick	removed	in_price	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	transaction_hash
0xd8043be1668fac205b9747e46d0c26c1eae2708f	-126	false	78733066155676974600947378052	0x00000000d8c99d4748f9f282c0004db2e37cd823	17	-84950318	84358300	141053400	278334650750	0x00000000d8c99d4748f9f282c0004db2e37cd823	2023-10-16T09:26:35.000Z	0xe0276794825dc69e7c4f9f9abdcf81cf0021c3fe8dd1f3a6418a7ac43cc37e90
0xd8043be1668fac205b9747e46d0c26c1eae2708f	-258	false	78215300978488370061801035971	0x00000000d8c99d4748f9f282c0004db2e37cd823	26	-79961577	78364785	141035207	278334650750	0x00000000d8c99d4748f9f282c0004db2e37cd823	2023-10-16T08:10:10.000Z	0x437d167864de41b1cc000a1df8041e6b8eec984025da7bd776079d1df518355a
0x22427d20480de289795ca29c3adddb57a568e285	202269	false	1953780173015133700288331766525510	0x00000000d8c99d4748f9f282c0004db2e37cd823	8	20361373	-12342221449969393	141151846	182041761687343	0x00000000d8c99d4748f9f282c0004db2e37cd823	2023-10-16T16:46:30.000Z	0xd34c0c83e3d38d688367dde36fa493d1170ec035e82531f3eced660faf165a99

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AlgebraFactory_Pool_event

Factory_Pool_event

Pool_Collect_event

Pool_CommunityFee_event

Pool_Fee_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

​Tables

​AlgebraFactory_Pool_event

​Factory_Pool_event

​Pool_Collect_event

​Pool_CommunityFee_event

​Pool_Fee_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

Tables

AlgebraFactory_Pool_event

Factory_Pool_event

Pool_Collect_event

Pool_CommunityFee_event

Pool_Fee_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event