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
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
Sample Data
| address | in_pool | removed | in_token0 | in_token1 | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x9c2abd632771b433e5e7507bcaa41ca3b25d8544 | 0x1a0ab181a5993d53491bd90024ac5c1ba6ec1e58 | false | 0x455b6b059a76dc02df7c2fadc7fe04a5121aa6d6 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 1 | 72009017 | 2023-03-21T04:59:39.000Z | 0x623ad58296b67aaefaa768bc51857b107108922a877bb50f6e58cf01ec635c35 |
| 0x9c2abd632771b433e5e7507bcaa41ca3b25d8544 | 0x12eeba3023f272e0e477eb56204e405ec092d609 | false | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 29 | 72061150 | 2023-03-21T08:33:59.000Z | 0x79391794c32d2ebd9600739848738f43a6bb394c0fac6bb40c5a4bd3ccad49f1 |
| 0x9c2abd632771b433e5e7507bcaa41ca3b25d8544 | 0x9ba7c7d580e01ca6b6ee76ef00a54148d88d31db | false | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0xda10009cbd5d07dd0cecc66161fc93d7c9000da1 | 5 | 72192928 | 2023-03-21T17:36:23.000Z | 0xf219f0e18c856584ed089e1be4d18729996b3e9005eeb9630fc798df7539f222 |
Example Query
Example Query
Query with partition filter
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.Columns
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
Sample Data
| address | removed | in_owner | log_index | in_amount0 | in_amount1 | in_topTick | block_number | in_recipient | in_bottomTick | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xa3acc615ff4687e3bf192ca8acbff1c428f5d0e1 | false | 0x35ea99ab62bcf7992136558e94fb97c7807fcd6a | 10 | 2517163587372930964 | 56659403591290 | -99840 | 143605418 | 0x35ea99ab62bcf7992136558e94fb97c7807fcd6a | -105840 | 2023-10-24T17:24:16.000Z | 0x38dd664ec2123f05af72e45ecb97ba6e56d9acf6e3254d8dea071b56e4139e6c |
| 0xa3acc615ff4687e3bf192ca8acbff1c428f5d0e1 | false | 0x35ea99ab62bcf7992136558e94fb97c7807fcd6a | 3 | 9607480330272732863 | 216256944228414 | -99840 | 143605418 | 0x35ea99ab62bcf7992136558e94fb97c7807fcd6a | -111960 | 2023-10-24T17:24:16.000Z | 0x38dd664ec2123f05af72e45ecb97ba6e56d9acf6e3254d8dea071b56e4139e6c |
| 0xa3acc615ff4687e3bf192ca8acbff1c428f5d0e1 | false | 0x35ea99ab62bcf7992136558e94fb97c7807fcd6a | 3 | 1220322020763559518 | 68422986334852 | -99840 | 143465432 | 0x35ea99ab62bcf7992136558e94fb97c7807fcd6a | -111960 | 2023-10-24T07:31:42.000Z | 0x5251f7c40936bdc5d817aa3238ccc98f5e92812c032351cb6d8dbd38fa1ae539 |
Example Query
Example Query
Query with partition filter
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.Columns
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
Sample Data
| address | removed | log_index | block_number | block_timestamp | transaction_hash | in_communityFee0New | in_communityFee1New |
|---|---|---|---|---|---|---|---|
| 0x547371d4b4852dc9a77537eeb447c60bfddd1e0c | false | 4 | 78062109 | 2023-04-07T18:30:41.000Z | 0x5e8ba947e28853bf5f5d398aa59ee61378a4f3fddf0a653a7a7b99fdf194171b | 100 | 100 |
| 0x12eeba3023f272e0e477eb56204e405ec092d609 | false | 3 | 72836174 | 2023-03-23T13:31:54.000Z | 0xf4ca8f139a2ee8f0b9f593579a0119c6fb6030585a2f23ed6e9c9f4ef8f02223 | 100 | 100 |
| 0x308c5b91f63307439fdb51a9fa4dfc979e2ed6b0 | false | 10 | 65388502 | 2023-02-28T10:46:51.000Z | 0x67de10e35d3d6f4e6a4372bab6fde29ad3fa5239534f78f91c3e3fd4374daf07 | 100 | 100 |
Example Query
Example Query
Query with partition filter
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.Columns
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_fee | STRING | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
Sample Data
Sample Data
| in_fee | address | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 499 | 0x12eeba3023f272e0e477eb56204e405ec092d609 | false | 112 | 222895655 | 2024-06-17T18:57:17.000Z | 0x12ed7d99f289a17c85fb312d42aedee9920555f4328e0edd9d9529b27f775a29 |
| 499 | 0x12eeba3023f272e0e477eb56204e405ec092d609 | false | 95 | 222822531 | 2024-06-17T13:50:37.000Z | 0x466be827f94a083b44157038f2982868d013e733206721595f10ca79c8992074 |
| 499 | 0x12eeba3023f272e0e477eb56204e405ec092d609 | false | 62 | 222850497 | 2024-06-17T15:47:40.000Z | 0xd32f45e04b8de4ef9868c7e606991775c2a236f9ed54105d61aab462192cb8b0 |
Example Query
Example Query
Query with partition filter
AlgebraPool_Flash_event
No description available.Columns
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
Sample Data
No sample data available.
Example Query
Example Query
Query with partition filter
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.Columns
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
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x12eeba3023f272e0e477eb56204e405ec092d609 | false | 0xb5c335cfaf1769ee02597c6ac2db883f793a020d | 0xb5c335cfaf1769ee02597c6ac2db883f793a020d | 40 | 1 | 2 | 81600 | 217901341 | 81000 | 2024-06-03T07:32:48.000Z | 0x8d922b1b80fdc91e9002bb9c84a05252828ff642fd09ad443b05b73b1a8e104c | 2 |
| 0x12eeba3023f272e0e477eb56204e405ec092d609 | false | 0xb5c335cfaf1769ee02597c6ac2db883f793a020d | 0xb5c335cfaf1769ee02597c6ac2db883f793a020d | 37 | 6772038035942465 | 144451091932968144436 | 81960 | 217901341 | 76260 | 2024-06-03T07:32:48.000Z | 0x8d922b1b80fdc91e9002bb9c84a05252828ff642fd09ad443b05b73b1a8e104c | 11262047414742558968 |
| 0xa3acc615ff4687e3bf192ca8acbff1c428f5d0e1 | false | 0x35ea99ab62bcf7992136558e94fb97c7807fcd6a | 0x35ea99ab62bcf7992136558e94fb97c7807fcd6a | 31 | 77172654712105009373 | 651737793748418 | -112860 | 217970308 | -124980 | 2024-06-03T12:21:24.000Z | 0x2d4c4698f245b71739e53be84e77ffca280b925a588414155e341762e12497f9 | 861466468318480243 |
Example Query
Example Query
Query with partition filter
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.Columns
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
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x8db6cf8e8ec31fcddb9c36e2becb20019b85ce37 | 57153 | false | 1380067568150511029593583659965 | 0xfa58b8024b49836772180f2df902f231ba712f72 | 122 | 4168560 | -1264653320 | 79972699 | 267828253489 | 0x101ec5d2f85df15df968caea715967f3ab098d5e | 2023-04-13T09:10:58.000Z | 0x6aca05d3171f1f146cd603c3b30504a062d49c57db80833cc4ab17f8afd114c5 |
| 0x8db6cf8e8ec31fcddb9c36e2becb20019b85ce37 | 57102 | false | 1376541997429561631394071100603 | 0xfa58b8024b49836772180f2df902f231ba712f72 | 62 | -4755366 | 1435633509 | 79968127 | 267828253489 | 0x10a12127867d3885ac64b51cc91a67c907ee51db | 2023-04-13T08:52:05.000Z | 0x266bbd7aa8055b62b6af4dd39615876c5f0483ff8c878734b8dabaa1f44149ad |
| 0x8db6cf8e8ec31fcddb9c36e2becb20019b85ce37 | 57085 | false | 1375366815555281958269700021482 | 0xfa58b8024b49836772180f2df902f231ba712f72 | 32 | -2859325 | 861856165 | 79964157 | 267828253489 | 0x10a12127867d3885ac64b51cc91a67c907ee51db | 2023-04-13T08:35:42.000Z | 0xb3b448ca4c22f584a55f47b78abea0b3604e049609f31e050e6bebb5d53455f5 |
Example Query
Example Query
Query with partition filter
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.Columns
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_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_reward | STRING | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
in_rewardAddress | STRING | Contract 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_owner | STRING | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| in_to | address | removed | in_owner | in_reward | log_index | block_number | block_timestamp | in_rewardAddress | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x2166deb36663fb602ac6e6016b37d103592199fb | 0x40f5af7171b35963dba9cd9952d3f11f5e32dd30 | false | 0x2166deb36663fb602ac6e6016b37d103592199fb | 885285759503489161999 | 3 | 107518397 | 2023-07-03T16:57:21.000Z | 0x3b475f6f2f41853706afc9fa6a6b8c5df1a2724c | 0x2ea21a59e5becf551d36a44d305aaf55c49036e0e6fa8240b4d3b9a2d3f363b2 |
| 0x2166deb36663fb602ac6e6016b37d103592199fb | 0x40f5af7171b35963dba9cd9952d3f11f5e32dd30 | false | 0x2166deb36663fb602ac6e6016b37d103592199fb | 0 | 5 | 107518397 | 2023-07-03T16:57:21.000Z | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 0x2ea21a59e5becf551d36a44d305aaf55c49036e0e6fa8240b4d3b9a2d3f363b2 |
| 0x544a40955ba1c7e56e161a59e1319e3313c25251 | 0x40f5af7171b35963dba9cd9952d3f11f5e32dd30 | false | 0x544a40955ba1c7e56e161a59e1319e3313c25251 | 0 | 4 | 107371356 | 2023-07-03T06:42:57.000Z | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 0xb4d4d70e35b0dc08a1d0564a94cfe399752d1e64ad3c312b9cd0cc08e6691bdb |
Example Query
Example Query
Query with partition filter