Skip to main content

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.
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_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_pidSTRINGPool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_pidaddressin_userremovedin_amountlog_indexblock_numberblock_timestamptransaction_hash
00x0180dee5df18ebf76642e50faaef426f7b2874f70x0162a6c42e78268d1af8e266c203d700c67bd3d9false222088725105932615721140887692023-07-23T09:48:07.000Z0xa5d4975d391c97121839730ec1ba96fe102b64185e724cb47b9327cee6c93e56
10x0180dee5df18ebf76642e50faaef426f7b2874f70x01d4844db17f94f476119d613ac59d683e04242efalse350256854740441545101140710472023-07-23T08:33:56.000Z0x27d30ee4039d998b28cb237d1b8a763b9c43cab8835b334a798c51333c99a4c9
20x0180dee5df18ebf76642e50faaef426f7b2874f70x23b2a8dd3c929b75b4007ca7e1b1b1c4378724cbfalse061140563842023-07-23T07:32:25.000Z0x0bb2a7ccc5ccacaa853254be7aba5446702cab0025d667fdcefb57f07cd32c09
Query with partition filter
SELECT *
FROM `tt-contracts.levelfinance_v2_arbitrum.LevelMasterv2_Harvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
addressremovedin_valuelog_indexblock_numberblock_timestamptransaction_hash
0x32b7bf19cb8b95c27e644183837813d4b595dcc6false550000000010993334382023-06-09T09:14:17.000Z0x8ba87a784dc92a8f16bafef013b502cdb0385e109ea597ee54d150e469e53d49
0x32b7bf19cb8b95c27e644183837813d4b595dcc6false00993610672023-06-09T11:09:39.000Z0x1851693b54f1379ca9a08b68128439446369df68ca18a7d7851d2eb73144edb8
0x32b7bf19cb8b95c27e644183837813d4b595dcc6false450000000011010254332023-06-14T08:58:57.000Z0x1dd8d51ac3fd60a90c9e20e754cdaa453386f7c6e5ddb1fb052e51ca8c2eaa2d
Query with partition filter
SELECT *
FROM `tt-contracts.levelfinance_v2_arbitrum.Pool_DaoFeeSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_keySTRINGUnique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
in_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_collateralTokenSTRINGContract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_indexTokenSTRINGContract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string.
in_collateralChangedSTRINGAmount 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_sizeChangedSTRINGChange 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_sideINT64Direction of the trade or position. Integer value where 0 indicates long and 1 indicates short.
in_indexPriceSTRINGIndex 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_pnlSTRINGProfit 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_feeValueSTRINGFee 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.
in_keyin_pnladdressin_sideremovedlog_indexin_accountin_feeValueblock_numberin_indexPricein_indexTokenin_sizeChangedblock_timestamptransaction_hashin_collateralTokenin_collateralChanged
0x1760f14764d53c44217485eb3d08ed8a3376b95bb4775856fa78e2a5c5572df31316094921304435255163172274460x32b7bf19cb8b95c27e644183837813d4b595dcc61false260x61aebcc20e0758af3f4e75b2ced557d2e991214750608157187883911833930000002217020246689047717030000000000000000x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f100000000000000000000000000000002024-06-14T08:01:04.000Z0x25766c8ae5ac845ad0515fce3aff91a0efa5742bf7d67fe464087c0804c059a90xaf88d065e77c8cc2239327c5edb3a432268e58312000280341175640212703964393924
0x1760f14764d53c44217485eb3d08ed8a3376b95bb4775856fa78e2a5c5572df31292677644500486950868261614760x32b7bf19cb8b95c27e644183837813d4b595dcc61false110x61aebcc20e0758af3f4e75b2ced557d2e991214750000000000000000000000000002217022456690635000000000000000000000x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f100000000000000000000000000000002024-06-14T08:02:01.000Z0x0760e623d65493bfb626746a7317f64480adc9a6ea5539ba7d513fd98b23b95f0xaf88d065e77c8cc2239327c5edb3a432268e58312000230656304275822268528193925
0x5b97ac2b02ef25568f81fbfe8e172802d39f881e7db11228e665052a21248816-10009205305820883702849864272860x32b7bf19cb8b95c27e644183837813d4b595dcc61false190x76543892026eef73717d20a76b3d9187d50dd9261118398744514396039595500920312216906759477000000000x912ce59144191c1204e64559fe8253a0e49e65482236049306930693069290017400800002024-06-14T07:13:44.000Z0xd0302ed9aa498658715c2762fd694e5399b8136d8a629f7a41c3c3084d6c1aa80xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb911181682059355863878968947321425
Query with partition filter
SELECT *
FROM `tt-contracts.levelfinance_v2_arbitrum.Pool_DecreasePosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_keySTRINGUnique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
in_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_collateralTokenSTRINGContract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_indexTokenSTRINGContract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string.
in_collateralValueSTRINGValue 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_sizeChangedSTRINGChange 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_sideINT64Direction of the trade or position. Integer value where 0 indicates long and 1 indicates short.
in_indexPriceSTRINGIndex 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_feeValueSTRINGFee 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.
in_keyaddressin_sideremovedlog_indexin_accountin_feeValueblock_numberin_indexPricein_indexTokenin_sizeChangedblock_timestamptransaction_hashin_collateralTokenin_collateralValue
0x1bc570aaeb52e246b0d943f68ccd50f174175ad720dc2db1b12da6112bd615c10x32b7bf19cb8b95c27e644183837813d4b595dcc60false70x4415af1941df328b5ada8f93a7141abaec8296df137531574926524390243894103777425018625019834175884697000000x82af49447d8a07e3bd95bd0d56f35241523fbab127506314985304878048778820755485000002024-03-02T05:41:48.000Z0xa10e552e3133fd208b03edd1ea14347477715bff24f360ec275c3a2b4f4d11280x82af49447d8a07e3bd95bd0d56f35241523fbab156390209750050000000000000000000000
0x1bc570aaeb52e246b0d943f68ccd50f174175ad720dc2db1b12da6112bd615c10x32b7bf19cb8b95c27e644183837813d4b595dcc60false70x4415af1941df328b5ada8f93a7141abaec8296df137670868869036585365845314847563018625578534199284000000000x82af49447d8a07e3bd95bd0d56f35241523fbab127534173773807317073169062969512600002024-03-02T06:05:41.000Z0xf9d593c7f398a1c441a07ec680039c3daa25f1874a399e613c14b385572ee78a0x82af49447d8a07e3bd95bd0d56f35241523fbab156428818600000000000000000000000000
0x1bc570aaeb52e246b0d943f68ccd50f174175ad720dc2db1b12da6112bd615c10x32b7bf19cb8b95c27e644183837813d4b595dcc60false80x4415af1941df328b5ada8f93a7141abaec8296df56053732471395845388790005601805618624592734127244060000000x82af49447d8a07e3bd95bd0d56f35241523fbab127459268106707317073169067509250000002024-03-02T05:23:49.000Z0x68c00309e084d5755f6053d4be69a6a1f44d2eb64e3cbc1994bbd49b1bb7275a0x82af49447d8a07e3bd95bd0d56f35241523fbab156309952699000000000000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.levelfinance_v2_arbitrum.Pool_IncreasePosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_keySTRINGUnique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
in_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_collateralTokenSTRINGContract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_indexTokenSTRINGContract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string.
in_sideINT64Direction of the trade or position. Integer value where 0 indicates long and 1 indicates short.
in_sizeSTRINGSize 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_collateralValueSTRINGValue 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_reserveAmountSTRINGAmount 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_indexPriceSTRINGIndex 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_pnlSTRINGProfit 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_feeValueSTRINGFee 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.
in_keyin_pnladdressin_sidein_sizeremovedlog_indexin_accountin_feeValueblock_numberin_indexPricein_indexTokenblock_timestampin_reserveAmounttransaction_hashin_collateralTokenin_collateralValue
0x75da6b493ce0a5d7cb0729f521c06651b3038608739e1a82068a69b96d9f191e-1071976113704065039231757293539100x32b7bf19cb8b95c27e644183837813d4b595dcc615759640155812833245917886238999350false40xf60b822d9d07ae4f3dd31e675552329c465477a3406818820040677990552279364995515356221321001790490900000x82af49447d8a07e3bd95bd0d56f35241523fbab12023-11-24T09:39:38.000Z57596401550x23fce308fe9b9f5780b44b4475bb0b0a35ebe3eb48573cb7d6e3ecb22898f2bc0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9162377993953575497285626358096133
0x0f0158afbfdb60cc23f18a8167c7c5f4e7bd5ada734f08b2b606297c0ff9d725-4853216766743219272884997768496790x32b7bf19cb8b95c27e644183837813d4b595dcc6046215128067618243192021279981342750false60x1501cf2e9afd2624a485e675427609a1932772ec3671115797648640166708191423191515370907810490342900000x912ce59144191c1204e64559fe8253a0e49e65482023-11-24T20:20:25.000Z435922894293035180620570x695e430c8b34056d1071f8e2612650c415674d45ccbb2b39ad668d11552df1640x912ce59144191c1204e64559fe8253a0e49e6548924846239471418328403620127909329
0xa37c591ad6861fa13e7fb7cca7d6ba23c04fffceb41521b3ceba0ff9d06f8eb8-8324925376346837038783711767693340x32b7bf19cb8b95c27e644183837813d4b595dcc6020091564800526233985300000000000000false40xfa97761428da9686b65bfa73dd9f0b5e028dfcc7224119737749991696428600720100001371448582725724104189000000000000000x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f2023-10-03T15:55:13.000Z706567190x2314e6d8a230e447a53ab3a4aace0f063905309a7b2f29db18a2980f1b158f380x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f1003311247136698598114700000000000
Query with partition filter
SELECT *
FROM `tt-contracts.levelfinance_v2_arbitrum.Pool_LiquidatePosition_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_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenOutSTRINGContract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_amountInSTRINGAmount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
in_amountOutSTRINGAmount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
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_priceInSTRINGPrice 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_priceOutSTRINGPrice 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.
in_feeaddressremovedin_senderlog_indexin_priceInin_tokenInin_amountInin_priceOutin_tokenOutblock_numberin_amountOutblock_timestamptransaction_hash
254350x32b7bf19cb8b95c27e644183837813d4b595dcc6false0x2215298606c9d0274527b13519ec50c3a7f1c1ef910000845600000000000000000xaf88d065e77c8cc2239327c5edb3a432268e58311200000019507150545400000x82af49447d8a07e3bd95bd0d56f35241523fbab115169150261390701722753272023-11-18T15:45:40.000Z0xd514fa1e07fe4b3103e1914edd2741da38b029f799cf7f0262d32f4bf7fb241a
50530602891051410x32b7bf19cb8b95c27e644183837813d4b595dcc6false0x2215298606c9d0274527b13519ec50c3a7f1c1ef910389022100000x912ce59144191c1204e64559fe8253a0e49e6548173848402736716964419642486038000000x82af49447d8a07e3bd95bd0d56f35241523fbab11517454029168214548280272023-11-18T19:45:21.000Z0xc8bb2af9d009cd2baacba819814b421269362f7b6161e87cfcdf68bdfd82d3be
51850480x32b7bf19cb8b95c27e644183837813d4b595dcc6false0x2215298606c9d0274527b13519ec50c3a7f1c1ef910003675000000000000000000xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9127018563810221755100000x912ce59144191c1204e64559fe8253a0e49e654815164623712380119310862848882972023-11-18T12:32:46.000Z0x5906485ed528acbd5c9330c134dfc8f4649c23b10610e12515d2a4e368e4d570
Query with partition filter
SELECT *
FROM `tt-contracts.levelfinance_v2_arbitrum.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100