camelot_v3_xai

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
0xd8676fbdfa5b56bb2298d452c9768f51e80e34ae	0x48a327c5594b98e0c4931552de473c7a603097e1	false	0x300a7b57dc85b6a9776e249614abf0fe5c9905fb	0x3fb787101dc6be47cfe18aeee15404dcc842e6af	2	2474699	2024-03-12T16:20:46.000Z	0xdcb52569ef9521768d6b79a4315651bbb690ffbb2fbb59b08f966656e221161d
0xd8676fbdfa5b56bb2298d452c9768f51e80e34ae	0x0cf7722d88594377323a266704c5b5d95c219c88	false	0x1e3769bd5fb2e9e9e7d4ed8667c947661f9a82e3	0xbee82cfdaff4a6aa4e4793cb81eb1c2e79ac463c	2	4403890	2024-04-10T15:35:32.000Z	0x5457947527ddff45cbd08a77d2fd819d13df24063cba8697917de83d37c9742b
0xd8676fbdfa5b56bb2298d452c9768f51e80e34ae	0x2b75aca0cd1ca0c966bbac3767fa48387f293ae3	false	0x89c49a3fa372920ac23ce757a029e6936c0b8e02	0xbee82cfdaff4a6aa4e4793cb81eb1c2e79ac463c	40	15079183	2024-07-07T01:13:09.000Z	0x25d639f1482c8e40f2724e9ee3591e9f753939272f60fe0f8ecb7c9b1d2cdf62

Example Query

Query with partition filter

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

Pool_Burn_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL 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_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	log_index	in_amount0	in_amount1	in_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	1	10529685513761545388	48853389195146	-78240	52060964	-95340	2024-10-26T19:05:20.000Z	0xfbe9ae68816fa398ef9f49fb8103db025f6059610b9a79fc23ac82929287b38b	165538938897171653
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	6	0	0	-91800	51912648	-95820	2024-10-26T08:16:36.000Z	0x046a8e86b2b84930848b1f1b6846da633cdf31dc08ca462145e3b880e0ed1057	0
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	3	1078960516172317489839	41918904149538264	-91800	51913044	-95820	2024-10-26T08:18:15.000Z	0xda3c106581f2fdcb1a188058b56454489b6d25de0aa0f090f06c9afecd9e4e76	75194249467358584414

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.camelot_v3_xai.Pool_Burn_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
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	4	5900717327365047166	459766477225533	-91020	26340250	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	-95760	2024-08-11T10:16:22.000Z	0x3fad2e5af1a447e5a56c7324bb01a484f01c792187baa7aaf191a5bd69679e8c
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	5	4697820798405339946698	422593194404479831	-91020	26340367	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	-95760	2024-08-11T10:16:51.000Z	0x38cbf812bcdd1ccc0f77f77e1db0c658c531d9a80a24ad29ef9a81d9f924e3ba
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	5	314999999999999999999	0	887220	26375175	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	69060	2024-08-11T12:44:44.000Z	0x56d15ad0accafed4ebaf0da23682d12a4097f1def0319524bbbd19e470bde8a9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.camelot_v3_xai.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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.camelot_v3_xai.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 token0-to-token1 swaps in this Camelot V3 pool on XAI chain. Values typically range from 1700-1900 basis points (17-19%), representing the pool’s fee tier configuration.
`in_feeOtz`	`STRING`	Fee amount in basis points for token one-to-zero swaps in the Camelot V3 pool. Represents the fee tier applied when swapping from the first token to the second token in the pool pair.

Sample Data

address	removed	in_feeOtz	in_feeZto	log_index	block_number	block_timestamp	transaction_hash
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	1765	1765	92	21946709	2024-07-29T00:25:28.000Z	0x14cda9410536f7346d53d371396aa5cd9a142a6b623bc7271d9e623df1286847
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	1836	1836	45	22040316	2024-07-29T07:16:13.000Z	0x421c7820be4bcc73313bc3c7086c6c8d1e8a4293a05c7ac76e8d00b154fe3121
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	1836	1836	37	22026857	2024-07-29T06:18:49.000Z	0xc24708a9044376e5b8f11c24cc8802419d8e7e73febaac192598bc39b4f07262

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.camelot_v3_xai.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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.camelot_v3_xai.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_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	3	5946000000000000000	46140	46380155	34560	2024-10-09T19:43:23.000Z	0xdd8a10c7e123735e389e3d5fa074c38589b1fddb208d4701d84bdeadf7a2274f	76149041048808507464
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	2	9174000000000000000	44640	46362356	34560	2024-10-09T18:23:29.000Z	0x2d7c37ab6bea2cfe5d0ed92c0ed0f8b1c4a214b762fb1024858082c9b447cade	130443838753865421436
0x6de5b03bcb24b82bb80a397a14cc4731ad4eb273	false	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	0xacdcc3c6a2339d08e0ac9f694e4de7c52f890db3	2	8215000000000000000	45420	46380404	34560	2024-10-09T19:44:37.000Z	0xcabc6bf9dea8b8ed1ee0542a113f28b8790b4ec999550f5d6fbd6456773d5bc1	110366167507308095358

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.camelot_v3_xai.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
0x0cf7722d88594377323a266704c5b5d95c219c88	198186	false	1593052569016138543072322902189734	0x74aa6977536f498c5ad4f30c02718c6c1988a112	11	-185573	75106147470198	54706691	5255928757274	0x74aa6977536f498c5ad4f30c02718c6c1988a112	2024-11-04T05:02:12.000Z	0xed2bf2646a4287fa43e00ec9b4d6c8e67d9781370f0083d6c8a2ea887780002c
0x0cf7722d88594377323a266704c5b5d95c219c88	198259	false	1598859635959841507750231109576034	0x74aa6977536f498c5ad4f30c02718c6c1988a112	6	185389	-75414452502340	54675806	5255928757274	0x74aa6977536f498c5ad4f30c02718c6c1988a112	2024-11-04T02:51:20.000Z	0xf2e6f097211ad1891c666507b284224c2da2e7d55ff49b57bd506381f87caf80
0x0cf7722d88594377323a266704c5b5d95c219c88	198388	false	1609236484618084312356046436449933	0x74aa6977536f498c5ad4f30c02718c6c1988a112	5	-430236	177516426936098	54867331	5255928757274	0x74aa6977536f498c5ad4f30c02718c6c1988a112	2024-11-04T16:22:38.000Z	0x08fcf7603cb5c54f80d69a1fbf57c5809776622e0a2523dd21b2a7da8b42c81d

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AlgebraFactory_Pool_event

Pool_Burn_event

Pool_Collect_event

Pool_CommunityFee_event

Pool_Fee_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AlgebraFactory_Pool_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_CommunityFee_event

​Pool_Fee_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

Tables

AlgebraFactory_Pool_event

Pool_Burn_event

Pool_Collect_event

Pool_CommunityFee_event

Pool_Fee_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event