Tables
LevelMasterv2_Harvest_event
Reward harvest events from Level Finance v2 yield farming pools on Arbitrum, tracking user reward claims by pool ID (pid) with claimed amounts. Used for analyzing yield distribution patterns and farmer reward accumulation across different staking pools.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_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_pid | STRING | Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| in_pid | address | in_user | removed | in_amount | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0 | 0x0180dee5df18ebf76642e50faaef426f7b2874f7 | 0x0162a6c42e78268d1af8e266c203d700c67bd3d9 | false | 2220887251059326157 | 2 | 114088769 | 2023-07-23T09:48:07.000Z | 0xa5d4975d391c97121839730ec1ba96fe102b64185e724cb47b9327cee6c93e56 |
| 1 | 0x0180dee5df18ebf76642e50faaef426f7b2874f7 | 0x01d4844db17f94f476119d613ac59d683e04242e | false | 350256854740441545 | 10 | 114071047 | 2023-07-23T08:33:56.000Z | 0x27d30ee4039d998b28cb237d1b8a763b9c43cab8835b334a798c51333c99a4c9 |
| 2 | 0x0180dee5df18ebf76642e50faaef426f7b2874f7 | 0x23b2a8dd3c929b75b4007ca7e1b1b1c4378724cb | false | 0 | 6 | 114056384 | 2023-07-23T07:32:25.000Z | 0x0bb2a7ccc5ccacaa853254be7aba5446702cab0025d667fdcefb57f07cd32c09 |
Example Query
Example Query
Query with partition filter
Pool_DaoFeeSet_event
DAO fee parameter change events from Level Finance V2 liquidity pools on Arbitrum. Tracks governance-controlled fee adjustments with values in basis points (e.g., 5500000000 = 55%) for analyzing protocol revenue distribution.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_value | STRING | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
Sample Data
Sample Data
| address | removed | in_value | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | false | 5500000000 | 10 | 99333438 | 2023-06-09T09:14:17.000Z | 0x8ba87a784dc92a8f16bafef013b502cdb0385e109ea597ee54d150e469e53d49 |
| 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | false | 0 | 0 | 99361067 | 2023-06-09T11:09:39.000Z | 0x1851693b54f1379ca9a08b68128439446369df68ca18a7d7851d2eb73144edb8 |
| 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | false | 4500000000 | 1 | 101025433 | 2023-06-14T08:58:57.000Z | 0x1dd8d51ac3fd60a90c9e20e754cdaa453386f7c6e5ddb1fb052e51ca8c2eaa2d |
Example Query
Example Query
Query with partition filter
Pool_DecreasePosition_event
Position close and reduction events from Level Finance V2 perpetual trading pools on Arbitrum. Captures size reductions, collateral changes, PnL (profit and loss), and fees for analyzing trader performance and position management activity.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_key | STRING | Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix. |
in_account | STRING | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_collateralToken | STRING | Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_indexToken | STRING | Contract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string. |
in_collateralChanged | STRING | Amount of collateral added to or removed from the position, denominated in the collateral token’s smallest unit. Negative values (represented as large numbers due to string encoding) indicate collateral removal, while positive values indicate collateral addition. |
in_sizeChanged | STRING | Change in position size resulting from the operation. String-encoded integer value representing the size adjustment in the smallest unit of the quote currency or USD-denominated value. |
in_side | INT64 | Direction of the trade or position. Integer value where 0 indicates long and 1 indicates short. |
in_indexPrice | STRING | Index price of the underlying asset at the time of the position change. String-encoded integer value representing the price with chain-specific precision, denominated in the smallest unit of the quote currency. |
in_pnl | STRING | Profit and loss realized from closing the position. String-encoded integer value representing the net gain or loss in the smallest unit of the relevant token or currency, where negative values indicate losses and positive values indicate profits. |
in_feeValue | STRING | Fee amount charged for the position operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or USD-denominated value. |
Sample Data
Sample Data
| in_key | in_pnl | address | in_side | removed | log_index | in_account | in_feeValue | block_number | in_indexPrice | in_indexToken | in_sizeChanged | block_timestamp | transaction_hash | in_collateralToken | in_collateralChanged |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x1760f14764d53c44217485eb3d08ed8a3376b95bb4775856fa78e2a5c5572df3 | 131609492130443525516317227446 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | 1 | false | 26 | 0x61aebcc20e0758af3f4e75b2ced557d2e9912147 | 5060815718788391183393000000 | 221702024 | 668904771703000000000000000 | 0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f | 10000000000000000000000000000000 | 2024-06-14T08:01:04.000Z | 0x25766c8ae5ac845ad0515fce3aff91a0efa5742bf7d67fe464087c0804c059a9 | 0xaf88d065e77c8cc2239327c5edb3a432268e5831 | 2000280341175640212703964393924 |
| 0x1760f14764d53c44217485eb3d08ed8a3376b95bb4775856fa78e2a5c5572df3 | 129267764450048695086826161476 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | 1 | false | 11 | 0x61aebcc20e0758af3f4e75b2ced557d2e9912147 | 5000000000000000000000000000 | 221702245 | 669063500000000000000000000 | 0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f | 10000000000000000000000000000000 | 2024-06-14T08:02:01.000Z | 0x0760e623d65493bfb626746a7317f64480adc9a6ea5539ba7d513fd98b23b95f | 0xaf88d065e77c8cc2239327c5edb3a432268e5831 | 2000230656304275822268528193925 |
| 0x5b97ac2b02ef25568f81fbfe8e172802d39f881e7db11228e665052a21248816 | -1000920530582088370284986427286 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | 1 | false | 19 | 0x76543892026eef73717d20a76b3d9187d50dd926 | 111839874451439603959550092031 | 221690675 | 947700000000 | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 223604930693069306929001740080000 | 2024-06-14T07:13:44.000Z | 0xd0302ed9aa498658715c2762fd694e5399b8136d8a629f7a41c3c3084d6c1aa8 | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 11181682059355863878968947321425 |
Example Query
Example Query
Query with partition filter
Pool_IncreasePosition_event
Perpetual position increase events from Level Finance V2 on Arbitrum, recording leverage trades with entry price, position size, collateral amounts, and trading fees. Used for analyzing trader behavior, leverage ratios, and position changes across markets.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_key | STRING | Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix. |
in_account | STRING | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_collateralToken | STRING | Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_indexToken | STRING | Contract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string. |
in_collateralValue | STRING | Value of collateral backing a position. String-encoded integer representing the collateral amount in the smallest unit of the collateral token or USD-denominated value. |
in_sizeChanged | STRING | Change in position size resulting from the operation. String-encoded integer value representing the size adjustment in the smallest unit of the quote currency or USD-denominated value. |
in_side | INT64 | Direction of the trade or position. Integer value where 0 indicates long and 1 indicates short. |
in_indexPrice | STRING | Index price of the underlying asset at the time of the position change. String-encoded integer value representing the price with chain-specific precision, denominated in the smallest unit of the quote currency. |
in_feeValue | STRING | Fee amount charged for the position operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or USD-denominated value. |
Sample Data
Sample Data
| in_key | address | in_side | removed | log_index | in_account | in_feeValue | block_number | in_indexPrice | in_indexToken | in_sizeChanged | block_timestamp | transaction_hash | in_collateralToken | in_collateralValue |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x1bc570aaeb52e246b0d943f68ccd50f174175ad720dc2db1b12da6112bd615c1 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | 0 | false | 7 | 0x4415af1941df328b5ada8f93a7141abaec8296df | 1375315749265243902438941037774250 | 186250198 | 3417588469700000 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 2750631498530487804877882075548500000 | 2024-03-02T05:41:48.000Z | 0xa10e552e3133fd208b03edd1ea14347477715bff24f360ec275c3a2b4f4d1128 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 56390209750050000000000000000000000 |
| 0x1bc570aaeb52e246b0d943f68ccd50f174175ad720dc2db1b12da6112bd615c1 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | 0 | false | 7 | 0x4415af1941df328b5ada8f93a7141abaec8296df | 1376708688690365853658453148475630 | 186255785 | 3419928400000000 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 2753417377380731707316906296951260000 | 2024-03-02T06:05:41.000Z | 0xf9d593c7f398a1c441a07ec680039c3daa25f1874a399e613c14b385572ee78a | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 56428818600000000000000000000000000 |
| 0x1bc570aaeb52e246b0d943f68ccd50f174175ad720dc2db1b12da6112bd615c1 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | 0 | false | 8 | 0x4415af1941df328b5ada8f93a7141abaec8296df | 560537324713958453887900056018056 | 186245927 | 3412724406000000 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 2745926810670731707316906750925000000 | 2024-03-02T05:23:49.000Z | 0x68c00309e084d5755f6053d4be69a6a1f44d2eb64e3cbc1994bbd49b1bb7275a | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 56309952699000000000000000000000000 |
Example Query
Example Query
Query with partition filter
Pool_LiquidatePosition_event
Position liquidation events from Level Finance perpetual futures on Arbitrum. Records forced closures with PnL, collateral values, and liquidation fees for analyzing trader risk and protocol solvency.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_key | STRING | Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix. |
in_account | STRING | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_collateralToken | STRING | Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_indexToken | STRING | Contract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string. |
in_side | INT64 | Direction of the trade or position. Integer value where 0 indicates long and 1 indicates short. |
in_size | STRING | Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value. |
in_collateralValue | STRING | Value of collateral backing a position. String-encoded integer representing the collateral amount in the smallest unit of the collateral token or USD-denominated value. |
in_reserveAmount | STRING | Amount of tokens reserved in the protocol for the position or operation. String-encoded integer value representing the reserved quantity in the smallest unit of the relevant token. |
in_indexPrice | STRING | Index price of the underlying asset at the time of the position change. String-encoded integer value representing the price with chain-specific precision, denominated in the smallest unit of the quote currency. |
in_pnl | STRING | Profit and loss realized from closing the position. String-encoded integer value representing the net gain or loss in the smallest unit of the relevant token or currency, where negative values indicate losses and positive values indicate profits. |
in_feeValue | STRING | Fee amount charged for the position operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or USD-denominated value. |
Sample Data
Sample Data
| in_key | in_pnl | address | in_side | in_size | removed | log_index | in_account | in_feeValue | block_number | in_indexPrice | in_indexToken | block_timestamp | in_reserveAmount | transaction_hash | in_collateralToken | in_collateralValue |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x75da6b493ce0a5d7cb0729f521c06651b3038608739e1a82068a69b96d9f191e | -107197611370406503923175729353910 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | 1 | 5759640155812833245917886238999350 | false | 4 | 0xf60b822d9d07ae4f3dd31e675552329c465477a3 | 4068188200406779905522793649955 | 153562213 | 2100179049090000 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 2023-11-24T09:39:38.000Z | 5759640155 | 0x23fce308fe9b9f5780b44b4475bb0b0a35ebe3eb48573cb7d6e3ecb22898f2bc | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 162377993953575497285626358096133 |
| 0x0f0158afbfdb60cc23f18a8167c7c5f4e7bd5ada734f08b2b606297c0ff9d725 | -485321676674321927288499776849679 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | 0 | 46215128067618243192021279981342750 | false | 6 | 0x1501cf2e9afd2624a485e675427609a1932772ec | 36711157976486401667081914231915 | 153709078 | 1049034290000 | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 2023-11-24T20:20:25.000Z | 43592289429303518062057 | 0x695e430c8b34056d1071f8e2612650c415674d45ccbb2b39ad668d11552df164 | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 924846239471418328403620127909329 |
| 0xa37c591ad6861fa13e7fb7cca7d6ba23c04fffceb41521b3ceba0ff9d06f8eb8 | -832492537634683703878371176769334 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | 0 | 20091564800526233985300000000000000 | false | 4 | 0xfa97761428da9686b65bfa73dd9f0b5e028dfcc7 | 22411973774999169642860072010000 | 137144858 | 272572410418900000000000000 | 0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f | 2023-10-03T15:55:13.000Z | 70656719 | 0x2314e6d8a230e447a53ab3a4aace0f063905309a7b2f29db18a2980f1b158f38 | 0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f | 1003311247136698598114700000000000 |
Example Query
Example Query
Query with partition filter
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
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_tokenIn | STRING | Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string. |
in_tokenOut | STRING | Contract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string. |
in_amountIn | STRING | Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination. |
in_amountOut | STRING | Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination. |
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. |
in_priceIn | STRING | Price of the input token at swap execution, denominated in the smallest unit of the protocol’s pricing mechanism. Typically represents wei-denominated price per token or other atomic unit depending on token decimals. |
in_priceOut | STRING | Price of the output token at the time of the swap, denominated in wei or smallest unit. Large values indicate price ratios scaled to maintain precision for tokens with different decimal places. |
Sample Data
Sample Data
| in_fee | address | removed | in_sender | log_index | in_priceIn | in_tokenIn | in_amountIn | in_priceOut | in_tokenOut | block_number | in_amountOut | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25435 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | false | 0x2215298606c9d0274527b13519ec50c3a7f1c1ef | 9 | 1000084560000000000000000 | 0xaf88d065e77c8cc2239327c5edb3a432268e5831 | 12000000 | 1950715054540000 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 151691502 | 6139070172275327 | 2023-11-18T15:45:40.000Z | 0xd514fa1e07fe4b3103e1914edd2741da38b029f799cf7f0262d32f4bf7fb241a |
| 5053060289105141 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | false | 0x2215298606c9d0274527b13519ec50c3a7f1c1ef | 9 | 1038902210000 | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 1738484027367169644 | 1964248603800000 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 151745402 | 916821454828027 | 2023-11-18T19:45:21.000Z | 0xc8bb2af9d009cd2baacba819814b421269362f7b6161e87cfcdf68bdfd82d3be |
| 5185048 | 0x32b7bf19cb8b95c27e644183837813d4b595dcc6 | false | 0x2215298606c9d0274527b13519ec50c3a7f1c1ef | 9 | 1000367500000000000000000 | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 1270185638 | 1022175510000 | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 151646237 | 1238011931086284888297 | 2023-11-18T12:32:46.000Z | 0x5906485ed528acbd5c9330c134dfc8f4649c23b10610e12515d2a4e368e4d570 |
Example Query
Example Query
Query with partition filter