Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedin_token0in_token1log_indexblock_numberblock_timestamptransaction_hash
0x10aa510d94e094bd643677bd2964c3ee085daffc0x6d9de008a663c71dfdc5f1b0e84b1555d3b7023afalse0x825b0dc224c6738ed7844c77323c7a48d0948d880xbb859e225ac8fb6be1c7e38d87b767e95fef0ebd10251384302024-12-16T20:49:04.000Z0xcb102f356663c88c203d6f7ba535ed2a2b0735ae77b1f661769630f200b25ca6
0x10aa510d94e094bd643677bd2964c3ee085daffc0x6a593f6de6fb5857621f4a243bac7aecf6a422acfalse0xbb859e225ac8fb6be1c7e38d87b767e95fef0ebd0xead96d49439516a3e676a5949ea2f0bb8508aac910250695192024-12-16T14:09:39.000Z0x003d842474286384ab16011c380e3d25f5448a5a524063f3c460532aaa50be08
0x10aa510d94e094bd643677bd2964c3ee085daffc0xa809ce254fa446124a1b9ddcd994c60f126e4ca1false0xbb859e225ac8fb6be1c7e38d87b767e95fef0ebd0xdf8faff7726991e13a9a1c0b2e7e2a9a45d51b772251151802024-12-16T18:03:06.000Z0xc1b2eb5f776c4e243e03df89303f5e0fd4ad25eacad82c3bb6d74c4ee14a2ec4
Query with partition filter
SELECT *
FROM `tt-contracts.camelot_v3_gravityalpha.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_bottomTickINT64Lower 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_topTickINT64Upper 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_liquidityAmountSTRINGAmount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position’s tick range.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerlog_indexin_amount0in_amount1in_topTickblock_numberin_bottomTickblock_timestamptransaction_hashin_liquidityAmount
0xd1607a5a4b8e26ba0dd66a3b79f9f8ed048c1a0bfalse0x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e2300015078875-20082063190204-2046002025-05-12T05:18:10.000Z0x9372f04d7c8d356d8c4c3063b8e1ed4814c7d0031d6d501276b5769cad864d392008419266966
0xd1607a5a4b8e26ba0dd66a3b79f9f8ed048c1a0bfalse0x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e2300011929743-20082063260275-2046002025-05-12T11:55:37.000Z0x92fde17b2aff12b355fdb9bc2519ab4d2e4074e4a59aaf1f8a55d58f187c9a621588973045390
0xd1607a5a4b8e26ba0dd66a3b79f9f8ed048c1a0bfalse0x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e2300016031187-20058063393348-2035202025-05-12T23:53:20.000Z0xd1d3f75820ef9af85b817cff3c8c03d7715a0b4eac29fac0859a6033340331692657784718052
Query with partition filter
SELECT *
FROM `tt-contracts.camelot_v3_gravityalpha.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_bottomTickINT64Lower 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_topTickINT64Upper 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_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerlog_indexin_amount0in_amount1in_topTickblock_numberin_recipientin_bottomTickblock_timestamptransaction_hash
0xd1607a5a4b8e26ba0dd66a3b79f9f8ed048c1a0bfalse0x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e230334710202530662113999-196740422065730xa8d55e9f1dbd60f7da1fd53ad9e3a4d559f8e5c0-1987202025-02-17T12:42:37.000Z0x6758260b8ce0db6f41712eddf4a1fd64025e8820ae3976267b62da4ebb66a984
0x9f7c32c1d6160318f552f45780c8f7465edda4f3false0x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e23033891735267161589269663351880300850x2198c2e6fa4e49a0b53d90ba216a3d3844fdab403222025-08-21T07:38:58.000Z0x0356cef9049402a38f17d34be27c61abf1fee0b1a4b90f2311769bd0d1a7ba02
0x9f7c32c1d6160318f552f45780c8f7465edda4f3false0x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e23046943212078410558419359342880518920x86cd09ae3b34a79bfd7bab43c4eabb68bebc396f3222025-08-21T09:27:54.000Z0xbe323f534adbfdd8e316b09ef76684aa7e57b88396b5407e3270a795bddf8d58
Query with partition filter
SELECT *
FROM `tt-contracts.camelot_v3_gravityalpha.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_communityFee0NewINT64Updated community fee rate for token0 in basis points. Integer value representing the fee percentage allocated to the community, where 100 equals 1%.
in_communityFee1NewINT64Updated community fee rate for token1 in basis points. Integer value representing the fee percentage allocated to the community, where 100 equals 1%.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.camelot_v3_gravityalpha.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_feeZtoSTRINGFee rate charged when swapping from token zero to token one in the pool, expressed in basis points. Typically 500 (0.05%) or 5000 (0.5%) for Camelot V3 pools.
in_feeOtzSTRINGFee tier in basis points charged on swaps from token1 to token0 (one-to-zero direction). Typically 500 (0.05%) or 5000 (0.5%) for Camelot V3 pools.
addressremovedin_feeOtzin_feeZtolog_indexblock_numberblock_timestamptransaction_hash
0xfdc1548f522cb39255321bd8e6e1cf8447cb18fefalse50050033616373132025-05-05T11:46:46.000Z0x093cf7e7fa16ad38bd060437566e27189cb02f72c7b54706fe43bb1686f8a1d1
0xfdc1548f522cb39255321bd8e6e1cf8447cb18fefalse50050013616527972025-05-05T13:31:13.000Z0xbef1c04fabedef27f7950a852eee2e085d28de612a3cdcd1d27a81e1465b9eb8
0xfdc1548f522cb39255321bd8e6e1cf8447cb18fefalse50050020616482902025-05-05T13:03:46.000Z0x336d78f1b51ea6bdf21425f86370d100efe49b32ae9c3c01a46c2dc4ea8825fe
Query with partition filter
SELECT *
FROM `tt-contracts.camelot_v3_gravityalpha.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_paid0STRINGAmount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
in_paid1STRINGAmount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
addressremovedin_paid0in_paid1in_senderlog_indexin_amount0in_amount1block_numberin_recipientblock_timestamptransaction_hash
0x6d9de008a663c71dfdc5f1b0e84b1555d3b7023afalse0983000000000000000xac541896626f68133338d464f6d1847a9062502b110983000000000000000000338585460xeb401855f0ce19173bfd7790a9ba8b17bf8e85172025-01-18T21:58:19.000Z0x733f6b78abeeba0124eae501eab331ac159628ed5e2657ff489a779524cbe27a
0x6d9de008a663c71dfdc5f1b0e84b1555d3b7023afalse01310680000000000000xac541896626f68133338d464f6d1847a9062502b1101310680000000000000000275724490xeb401855f0ce19173bfd7790a9ba8b17bf8e85172024-12-26T05:38:24.000Z0x2500d7c543cdf7e7734bea63133df8a79f6ad853b69f103bf9f0a55df82d6071
Query with partition filter
SELECT *
FROM `tt-contracts.camelot_v3_gravityalpha.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_bottomTickINT64Lower 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_topTickINT64Upper 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_liquidityAmountSTRINGAmount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position’s tick range.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_senderlog_indexin_amount0in_amount1in_topTickblock_numberin_bottomTickblock_timestamptransaction_hashin_liquidityAmount
0xa3ffac3ebfa18b5bc4f2ae10086403e85fbf6b2bfalse0x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e2300x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e230415350755301567749808127274487545-31062014239076-3118202024-10-29T07:12:43.000Z0x0e51202db2c8d8ef6bb1bcccd9f7fc4ef50852d99e1055f0f9263e68aa1a6c9171881891743933437
0xf2f357520914c037f5736632de6f709232239b04false0x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e2300x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e2305468946747496286014323154-9602024-10-29T14:19:36.000Z0x05a59e6ce4cdb3704df51a74a77b9b90a553ccea2787897295d8d89d72b3127b187531706
0xd1607a5a4b8e26ba0dd66a3b79f9f8ed048c1a0bfalse0x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e2300x30a4bd5b1a9e9c0d80e9a45ef486bc1f1bc8e230465641028067090148000000-19752064672480-1984802025-05-18T02:21:49.000Z0x62d9ef0d96fd72bc2e9a6ca3d7ef6ace2529a6d62cb4fe8962114f46523931f410293368763745
Query with partition filter
SELECT *
FROM `tt-contracts.camelot_v3_gravityalpha.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_liquiditySTRINGTotal liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
in_tickINT64Current 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.
addressin_tickremovedin_pricein_senderlog_indexin_amount0in_amount1block_numberin_liquidityin_recipientblock_timestamptransaction_hash
0x3ea5753aa1962f77ad529fb792d01c3351952aac-686507false982485517239640x60a186019f81bfd04afc16c9c01804a04e79e68b6-14613826468498260625674046256249185065017830294065100000000000000037464687943441343326887651878718294300x20c6180ac86f4c4ef7ff91f37073bdf9949127c12024-09-06T04:26:43.000Z0xe284aacaaab66f4fafa62ce80c1cb90837472bf9997b9549710dd2b9b08a0fd7
0xc842d02fc47dbaaaf5485e6b419ad2adb986c54171false795125982977447757032298473750x60a186019f81bfd04afc16c9c01804a04e79e68b6-41640507068739420000000000003795799116403951393085350x246febbadc08809a13557a4434fde658c57d6fde2024-09-06T10:29:18.000Z0x2656ed64ae50f321c6fa0991e4fbc9d90792acbfb84e391d9b7bf6a62119ff2a
0xc842d02fc47dbaaaf5485e6b419ad2adb986c541143false797970340812252138129157444140x60a186019f81bfd04afc16c9c01804a04e79e68b6-41343652670854420000000000003796405116403951393085350x246febbadc08809a13557a4434fde658c57d6fde2024-09-06T10:34:03.000Z0x038f9c1d2202c0e53efd6e94297997d59da7d4ea5960707b2a759a02e6fe6ae0
Query with partition filter
SELECT *
FROM `tt-contracts.camelot_v3_gravityalpha.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100