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
0x9c2abd632771b433e5e7507bcaa41ca3b25d85440x1a0ab181a5993d53491bd90024ac5c1ba6ec1e58false0x455b6b059a76dc02df7c2fadc7fe04a5121aa6d60x82af49447d8a07e3bd95bd0d56f35241523fbab11720090172023-03-21T04:59:39.000Z0x623ad58296b67aaefaa768bc51857b107108922a877bb50f6e58cf01ec635c35
0x9c2abd632771b433e5e7507bcaa41ca3b25d85440x12eeba3023f272e0e477eb56204e405ec092d609false0x82af49447d8a07e3bd95bd0d56f35241523fbab10x912ce59144191c1204e64559fe8253a0e49e654829720611502023-03-21T08:33:59.000Z0x79391794c32d2ebd9600739848738f43a6bb394c0fac6bb40c5a4bd3ccad49f1
0x9c2abd632771b433e5e7507bcaa41ca3b25d85440x9ba7c7d580e01ca6b6ee76ef00a54148d88d31dbfalse0x82af49447d8a07e3bd95bd0d56f35241523fbab10xda10009cbd5d07dd0cecc66161fc93d7c9000da15721929282023-03-21T17:36:23.000Z0xf219f0e18c856584ed089e1be4d18729996b3e9005eeb9630fc798df7539f222
Query with partition filter
SELECT *
FROM `tt-contracts.zyberswap_v3_arbitrum.AlgebraFactory_Pool_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AlgebraPool_Collect_event

Concentrated liquidity position fee collection events from Algebra protocol pools. Records token amounts withdrawn by position owners from specific tick ranges, including owner address, recipient address, and collected quantities of both token0 and token1.
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
0xa3acc615ff4687e3bf192ca8acbff1c428f5d0e1false0x35ea99ab62bcf7992136558e94fb97c7807fcd6a10251716358737293096456659403591290-998401436054180x35ea99ab62bcf7992136558e94fb97c7807fcd6a-1058402023-10-24T17:24:16.000Z0x38dd664ec2123f05af72e45ecb97ba6e56d9acf6e3254d8dea071b56e4139e6c
0xa3acc615ff4687e3bf192ca8acbff1c428f5d0e1false0x35ea99ab62bcf7992136558e94fb97c7807fcd6a39607480330272732863216256944228414-998401436054180x35ea99ab62bcf7992136558e94fb97c7807fcd6a-1119602023-10-24T17:24:16.000Z0x38dd664ec2123f05af72e45ecb97ba6e56d9acf6e3254d8dea071b56e4139e6c
0xa3acc615ff4687e3bf192ca8acbff1c428f5d0e1false0x35ea99ab62bcf7992136558e94fb97c7807fcd6a3122032202076355951868422986334852-998401434654320x35ea99ab62bcf7992136558e94fb97c7807fcd6a-1119602023-10-24T07:31:42.000Z0x5251f7c40936bdc5d817aa3238ccc98f5e92812c032351cb6d8dbd38fa1ae539
Query with partition filter
SELECT *
FROM `tt-contracts.zyberswap_v3_arbitrum.AlgebraPool_Collect_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AlgebraPool_CommunityFee_event

Community fee configuration change events from Algebra DEX (Decentralized Exchange) liquidity pools. Records protocol fee adjustments for token0 and token1, used for tracking fee policy changes across pool contracts.
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%.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_communityFee0Newin_communityFee1New
0x547371d4b4852dc9a77537eeb447c60bfddd1e0cfalse4780621092023-04-07T18:30:41.000Z0x5e8ba947e28853bf5f5d398aa59ee61378a4f3fddf0a653a7a7b99fdf194171b100100
0x12eeba3023f272e0e477eb56204e405ec092d609false3728361742023-03-23T13:31:54.000Z0xf4ca8f139a2ee8f0b9f593579a0119c6fb6030585a2f23ed6e9c9f4ef8f02223100100
0x308c5b91f63307439fdb51a9fa4dfc979e2ed6b0false10653885022023-02-28T10:46:51.000Z0x67de10e35d3d6f4e6a4372bab6fde29ad3fa5239534f78f91c3e3fd4374daf07100100
Query with partition filter
SELECT *
FROM `tt-contracts.zyberswap_v3_arbitrum.AlgebraPool_CommunityFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AlgebraPool_Fee_event

Fee change events emitted by Algebra-based liquidity pools when the pool’s fee tier is updated. Records the new fee amount in basis points, used for tracking dynamic fee adjustments in concentrated liquidity protocols.
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_feeSTRINGFee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
in_feeaddressremovedlog_indexblock_numberblock_timestamptransaction_hash
4990x12eeba3023f272e0e477eb56204e405ec092d609false1122228956552024-06-17T18:57:17.000Z0x12ed7d99f289a17c85fb312d42aedee9920555f4328e0edd9d9529b27f775a29
4990x12eeba3023f272e0e477eb56204e405ec092d609false952228225312024-06-17T13:50:37.000Z0x466be827f94a083b44157038f2982868d013e733206721595f10ca79c8992074
4990x12eeba3023f272e0e477eb56204e405ec092d609false622228504972024-06-17T15:47:40.000Z0xd32f45e04b8de4ef9868c7e606991775c2a236f9ed54105d61aab462192cb8b0
Query with partition filter
SELECT *
FROM `tt-contracts.zyberswap_v3_arbitrum.AlgebraPool_Fee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AlgebraPool_Flash_event

No description available.
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.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.zyberswap_v3_arbitrum.AlgebraPool_Flash_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AlgebraPool_Mint_event

Liquidity addition events from Algebra-based concentrated liquidity pools containing sender, owner, token amounts, tick range boundaries, and liquidity units. Used for tracking liquidity provider positions and pool depth changes across Algebra DEX deployments.
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
0x12eeba3023f272e0e477eb56204e405ec092d609false0xb5c335cfaf1769ee02597c6ac2db883f793a020d0xb5c335cfaf1769ee02597c6ac2db883f793a020d401281600217901341810002024-06-03T07:32:48.000Z0x8d922b1b80fdc91e9002bb9c84a05252828ff642fd09ad443b05b73b1a8e104c2
0x12eeba3023f272e0e477eb56204e405ec092d609false0xb5c335cfaf1769ee02597c6ac2db883f793a020d0xb5c335cfaf1769ee02597c6ac2db883f793a020d37677203803594246514445109193296814443681960217901341762602024-06-03T07:32:48.000Z0x8d922b1b80fdc91e9002bb9c84a05252828ff642fd09ad443b05b73b1a8e104c11262047414742558968
0xa3acc615ff4687e3bf192ca8acbff1c428f5d0e1false0x35ea99ab62bcf7992136558e94fb97c7807fcd6a0x35ea99ab62bcf7992136558e94fb97c7807fcd6a3177172654712105009373651737793748418-112860217970308-1249802024-06-03T12:21:24.000Z0x2d4c4698f245b71739e53be84e77ffca280b925a588414155e341762e12497f9861466468318480243
Query with partition filter
SELECT *
FROM `tt-contracts.zyberswap_v3_arbitrum.AlgebraPool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AlgebraPool_Swap_event

Swap events from Algebra Protocol concentrated liquidity pools containing sender, recipient, token amounts exchanged, post-swap price and tick, and liquidity depth. Used for DEX trade analysis and liquidity tracking.
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
0x8db6cf8e8ec31fcddb9c36e2becb20019b85ce3757153false13800675681505110295935836599650xfa58b8024b49836772180f2df902f231ba712f721224168560-1264653320799726992678282534890x101ec5d2f85df15df968caea715967f3ab098d5e2023-04-13T09:10:58.000Z0x6aca05d3171f1f146cd603c3b30504a062d49c57db80833cc4ab17f8afd114c5
0x8db6cf8e8ec31fcddb9c36e2becb20019b85ce3757102false13765419974295616313940711006030xfa58b8024b49836772180f2df902f231ba712f7262-47553661435633509799681272678282534890x10a12127867d3885ac64b51cc91a67c907ee51db2023-04-13T08:52:05.000Z0x266bbd7aa8055b62b6af4dd39615876c5f0483ff8c878734b8dabaa1f44149ad
0x8db6cf8e8ec31fcddb9c36e2becb20019b85ce3757085false13753668155552819582697000214820xfa58b8024b49836772180f2df902f231ba712f7232-2859325861856165799641572678282534890x10a12127867d3885ac64b51cc91a67c907ee51db2023-04-13T08:35:42.000Z0xb3b448ca4c22f584a55f47b78abea0b3604e049609f31e050e6bebb5d53455f5
Query with partition filter
SELECT *
FROM `tt-contracts.zyberswap_v3_arbitrum.AlgebraPool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EternalFarming_RewardClaimed_event

Liquidity mining reward claim events from ZyberSwap V3’s eternal (perpetual) farming program on Arbitrum, capturing reward token amounts, recipient addresses, and reward token contract addresses. Used for tracking yield farming incentive distributions and analyzing liquidity provider earnings across different reward token types.
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_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardAddressSTRINGContract address of the reward token being claimed from the ZyberSwap eternal farming contract on Arbitrum. Hex-encoded, 0x-prefixed 40-character EVM address identifying which incentive token the user is receiving.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_toaddressremovedin_ownerin_rewardlog_indexblock_numberblock_timestampin_rewardAddresstransaction_hash
0x2166deb36663fb602ac6e6016b37d103592199fb0x40f5af7171b35963dba9cd9952d3f11f5e32dd30false0x2166deb36663fb602ac6e6016b37d103592199fb88528575950348916199931075183972023-07-03T16:57:21.000Z0x3b475f6f2f41853706afc9fa6a6b8c5df1a2724c0x2ea21a59e5becf551d36a44d305aaf55c49036e0e6fa8240b4d3b9a2d3f363b2
0x2166deb36663fb602ac6e6016b37d103592199fb0x40f5af7171b35963dba9cd9952d3f11f5e32dd30false0x2166deb36663fb602ac6e6016b37d103592199fb051075183972023-07-03T16:57:21.000Z0xff970a61a04b1ca14834a43f5de4533ebddb5cc80x2ea21a59e5becf551d36a44d305aaf55c49036e0e6fa8240b4d3b9a2d3f363b2
0x544a40955ba1c7e56e161a59e1319e3313c252510x40f5af7171b35963dba9cd9952d3f11f5e32dd30false0x544a40955ba1c7e56e161a59e1319e3313c25251041073713562023-07-03T06:42:57.000Z0xff970a61a04b1ca14834a43f5de4533ebddb5cc80xb4d4d70e35b0dc08a1d0564a94cfe399752d1e64ad3c312b9cd0cc08e6691bdb
Query with partition filter
SELECT *
FROM `tt-contracts.zyberswap_v3_arbitrum.EternalFarming_RewardClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100