camelot_v2_arbitrum

Tables

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

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_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_length`	`STRING`	Total number of token pairs created by the Camelot V2 factory contract at the time of this event emission. Represents cumulative pair count, incrementing with each new liquidity pool deployment.

Sample Data

address	in_pair	removed	in_length	in_token0	in_token1	block_number	block_timestamp	transaction_hash
0x6eccab422d763ac031210895c81787e87b43a652	0xf7303eff1c7099c868c0a5389b31ba0986c28bc6	false	55	0x3c998a2c7408b1043a047a3fe10114483ed1958d	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	50817535	2023-01-04T14:27:41.000Z	0xe6660255e9ddbce13d646340bba42f22bccf7c7de886838c024097d92036f933
0x6eccab422d763ac031210895c81787e87b43a652	0xe3770e273985503a49727bb5062a61e0bdbcd799	false	326	0x070622449e7980a1709c576ecbfa1c02b3fd8681	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	64470869	2023-02-25T15:00:34.000Z	0xe5c68b006c25c4a739f7ae0807d0d439434792345691d66f92391a66e8e102a1
0x6eccab422d763ac031210895c81787e87b43a652	0x9db141742c3c508183b5b4337cb2a251832def17	false	328	0x7d250a5f7476e1f85c3c364e6a64125ee07839b4	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	64496900	2023-02-25T16:55:04.000Z	0xe9e173da9ce266a1bb25ea801620186735e5e9352f3d6b1633312187ad6a08eb

Example Query

Query with partition filter

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

NFTPool_HarvestPosition_event

NFT position harvest events from Camelot V2 liquidity pools on Arbitrum, recording when users claim pending rewards from their NFT-based LP positions. Tracks recipient addresses, token IDs, and unclaimed reward amounts for analyzing yield farming 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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pending`	`STRING`	Pending state information containing timestamp of last update, boolean flag for native token handling, pending amount, and exemption amount. String-encoded numeric values for timestamp and amounts.

Sample Data

in_to	address	removed	log_index	in_pending	in_tokenId	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	0x0f07c3d5dcadc6194a5ec2f9c4106ff5b0db3c18	false	50	28961115113	390	83643392	2023-04-24T01:18:35.000Z	0xfb21742cc654de5ac623d78465ca53e2f45711c314553ef4de2cb879f20ae5c3
0xccbb5eec512f1085cab86a10c29ba10e75290040	0x0f07c3d5dcadc6194a5ec2f9c4106ff5b0db3c18	false	32	7024254577460	451	83648262	2023-04-24T01:39:24.000Z	0x3ef2bf9e8397e3c91f18560c82eed45fdef0684919f16b1a1bab54fd41942fa8
0x39a236ebd2a6dc72f91d373efc4dd90c8f4bf121	0x2a9766a73999a7de16a4b4e345c8a6fc4e4288cc	false	124	1853037858772526	354	83637461	2023-04-24T00:53:15.000Z	0xa4bb409006096896bd7e84e3e126a68d410526bd6df46bc6b4c5d1c27f8a6972

Example Query

Query with partition filter

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

NFTPoolFactory_PoolCreated_event

NFT liquidity pool creation events from Camelot V2 DEX on Arbitrum, capturing new pool deployments with their LP token addresses. Used for tracking NFT-based liquidity pool launches and analyzing Camelot’s NFT pool ecosystem 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_lpToken`	`STRING`	Contract address of the liquidity provider (LP) token associated with the newly created NFT pool. Hex-encoded, 0x-prefixed 40-character string representing the token that liquidity providers receive when depositing assets.
`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	log_index	in_lpToken	block_number	block_timestamp	transaction_hash
0x6db1ef0df42e30acf139a70c1ed0b7e6c51dbf6d	0xfbe02a6d990f4f8b00934f2312135476f4834d68	false	2	0x80a1fe04e7c2cfb62cfee67361d1a3b57902766a	221226066	2024-06-12T22:58:03.000Z	0x738bcebd2b95179f069e51120e464bebf2b72d8b2e4be2310a5b00caa3852f63
0x6db1ef0df42e30acf139a70c1ed0b7e6c51dbf6d	0xc6c76422d0f9451b6e4742e7412908dc2c3d3c45	false	6	0xf8137c8cf3e049998dfd83c7b2fb680269e31b55	221225939	2024-06-12T22:57:32.000Z	0x33da458ed5064b1c2a193dc1e7e4767756c0c8327f810565b6ebba8227a62642
0x6db1ef0df42e30acf139a70c1ed0b7e6c51dbf6d	0x135bb634bcbf6ea2f90a80a96c161c0e360dc633	false	1	0x3fee6e8fbde48b727f82c55639ed2dd0cd9ba642	47384075	2022-12-19T18:53:37.000Z	0x26bc91f049a1b3fb8b3bc68b7d66f0b4f46dff619c36e47b3f82a95463185ba7

Example Query

Query with partition filter

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

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) pools.

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_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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xbb3fee27601b2739d410f3f723cb8a4c65b6abbe	0x01efed58b534d7a7464359a6f8d14d986125816b	false	0xc873fecbd354f5a56e00e710b90ef4201db2448d	7	63452150061203689346	60755137	146547673	2023-11-03T00:55:02.000Z	0x39d23d9f2a0b848cfc5963b942774827c3b6f3def792a4a5f26ccdf05dbe28ff
0xbb3fee27601b2739d410f3f723cb8a4c65b6abbe	0x01efed58b534d7a7464359a6f8d14d986125816b	false	0xc873fecbd354f5a56e00e710b90ef4201db2448d	7	3944040199872415873535	3776400058	146547559	2023-11-03T00:54:33.000Z	0x22c7625e5c6a9d295b0f338b0083ba6a3bc637dd29e77474cbf11557f1e83ba4
0x8ccaf951c46899aa11e96435261c271c3e5ba963	0x01efed58b534d7a7464359a6f8d14d986125816b	false	0xc873fecbd354f5a56e00e710b90ef4201db2448d	7	7527769427078341661034	7228117750	146583730	2023-11-03T03:31:39.000Z	0xe6c518167749b2a7dc6f0eda96b20adf03334baeed0055d59ad377c13f9687c2

Example Query

Query with partition filter

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

Pair_FeePercentUpdated_event

Fee tier adjustment events from Camelot V2 automated market maker (AMM) liquidity pairs on Arbitrum. Tracks changes to swap fee percentages for token0 and token1 in basis points (e.g., 500 = 0.05%), useful for analyzing fee structure evolution and liquidity pool economics.

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_token0FeePercent`	`STRING`	Fee percentage charged on token0 in the Camelot V2 liquidity pair, expressed in basis points where 1000 = 1%. Values typically range from 50 (0.05%) to 2000 (2%) and can be updated asymmetrically from the token1 fee.
`in_token1FeePercent`	`STRING`	Fee percentage charged for swaps involving token1 in the liquidity pair, expressed in basis points (e.g., ‘500’ = 5%, ‘1000’ = 10%). Updated via governance or pool admin action when fee structures are adjusted.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_token0FeePercent	in_token1FeePercent
0xaa6d06ceb39132b720b54259b70f41f9c975782a	false	1	70440946	2023-03-16T15:03:43.000Z	0x5c44950fdb0dfb49fa32b6292bc61b0ce6df3a880a2e3f003e1d7792e0a86507	1000	300
0xaa6d06ceb39132b720b54259b70f41f9c975782a	false	0	70441247	2023-03-16T15:04:59.000Z	0x0244d0213e546b1eea0044295b381f73820c339675023c86afb274da7d0739f9	1000	500
0x400ebc22c31bedcdab38a6b27963912df71840ed	false	6	76735127	2023-04-03T21:13:39.000Z	0x65668e9d893a51674c3b88d52b9c0e77fd89a6007e99be6badd26e203c5ed2a2	50	50

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

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_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_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x5201f6482eea49c90fe609ed9d8f69328bac8dda	false	0xe458018ad4283c90fb7f5460e24c4016f81b8175	6	571454224375065	1335670409495539	126301434	2023-08-30T06:37:45.000Z	0x7dcc7eae224aa0da30ba37f4034008140287b355564f1ab4b93cb0871d423a68
0x6b8b78554db2f017cca749dad38e445cd8a3b5b4	false	0xe458018ad4283c90fb7f5460e24c4016f81b8175	6	250080069597874974100	57483090	126431723	2023-08-30T15:57:53.000Z	0x72e727ddf2b4c0d884ad1e73f37b34857342a05aec886f4df770ca6902f8aa7e
0x85c3e0f63e50a994215969ba9f5259ee9b96ff52	false	0xc873fecbd354f5a56e00e710b90ef4201db2448d	7	15000000000000000000	1284512995909323623613	126394140	2023-08-30T13:13:20.000Z	0x76d45e69fae79142264d738228831aed7b51855e3b53057daec071183c769de5

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash
0x0000000000bf41eb500675cabaa1223e3c1ab90f	0xa6c5c7d189fa4eb5af8ba34e63dcdd3a635d433f	false	0x0000000000bf41eb500675cabaa1223e3c1ab90f	46	150049302	379236722433715537	0	0	672986892345247850746	2023-11-13T16:01:39.000Z	0x85f52cc466c82d54d02b27b395c9d3632a965462aa4a4ed8b56af5230037913a
0x0000000000bf41eb500675cabaa1223e3c1ab90f	0x84652bb2539513baf36e225c930fdd8eaa63ce27	false	0x0000000000bf41eb500675cabaa1223e3c1ab90f	34	150112371	221443575686691778	0	0	463317100	2023-11-13T20:56:30.000Z	0x1b807766cb4ba3bf1da0cce828b7d71290d9484aeacc1e55373995d7964307d0
0x0000000000bf41eb500675cabaa1223e3c1ab90f	0x84652bb2539513baf36e225c930fdd8eaa63ce27	false	0x0000000000bf41eb500675cabaa1223e3c1ab90f	25	149845300	0	460733589	223951612458027886	0	2023-11-13T01:02:30.000Z	0x2ed51231da99084f69d8423e2f2ace1edd6a401901f93b0fd6c15585d1bbcfa2

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x367eb9df4c366438ae0e6f90748ca7dc7a50001d	false	53	308813234540942042795	5780756	289679200	2024-12-29T01:44:32.000Z	0x6061617ffc763c99f1b860200dcd159f306d2214eedd047d8430d09c622c9459
0x138c115bdcc8709d7f782ecc29dfb3829907d74b	false	71	138259090856753784377	102369227	289974829	2024-12-29T22:20:58.000Z	0x7c811aaea75932bc34d6cdcdb5e0056e49e4c8283012aaab0f205d17e9cf8dbe
0xd40b7b05ab39a39658de1d7c9301a9ed765b3472	false	68	164337049180554281272	125187910	289881585	2024-12-29T15:49:24.000Z	0x9b57c45912110ca340ab0e4f00a736a03b85e40cbf46a43fa8394fbe563ba522

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x8554792f0ecc2464122ddc5348acd86f4fb6ec8c	0x01efed58b534d7a7464359a6f8d14d986125816b	0x579942f9cce581ee83fae0b51cb40fc01391a169	false	1960501625340337	18	50213093	2023-01-01T20:10:01.000Z	0x0ad54e00a419ea0618783884a1ba023682a3e61e25fc971956cac3da44ff809e
0x0000000000000000000000000000000000000000	0x01efed58b534d7a7464359a6f8d14d986125816b	0x01efed58b534d7a7464359a6f8d14d986125816b	false	1960501625340337	3	50213432	2023-01-01T20:12:32.000Z	0x18a74d1b346d6ed5b22052a0d2dc506c6beffff589ebc5b5283396ad924507ce
0x01efed58b534d7a7464359a6f8d14d986125816b	0x01efed58b534d7a7464359a6f8d14d986125816b	0x8554792f0ecc2464122ddc5348acd86f4fb6ec8c	false	1960501625340337	2	50213432	2023-01-01T20:12:32.000Z	0x18a74d1b346d6ed5b22052a0d2dc506c6beffff589ebc5b5283396ad924507ce

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

NFTPool_HarvestPosition_event

NFTPoolFactory_PoolCreated_event

Pair_Burn_event

Pair_FeePercentUpdated_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​NFTPool_HarvestPosition_event

​NFTPoolFactory_PoolCreated_event

​Pair_Burn_event

​Pair_FeePercentUpdated_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

NFTPool_HarvestPosition_event

NFTPoolFactory_PoolCreated_event

Pair_Burn_event

Pair_FeePercentUpdated_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event