levelfinance_v1_bsc

Tables

LevelMaster_Harvest_event

Reward harvest events from Level Finance staking pools on BSC, recording user withdrawals of earned rewards by pool ID (PID) and harvest amount. Used for analyzing yield farming activity, reward distribution patterns, and user engagement across different liquidity pools.

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

in_pid	address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
4	0x1ab33a7454427814a71f128109fe5b498aa21e5d	0xf89e93e850550e30d6301c9b2efb69b6c26162e7	false	86402000000000000000000	69	25627272	2023-02-13T08:50:57.000Z	0x16d88dd38903a933e5e55be160368e97e6c27994843b79bbc2ced71fec3b6e5c
1	0x1ab33a7454427814a71f128109fe5b498aa21e5d	0x0cc4e5d07954fb2eb33ecded5d6b730e0cf219d8	false	48474828688647698268	41	24765448	2023-01-14T01:06:51.000Z	0xcdd65cd3f9a9794c7115d8fc774eb05a985b6cf59ad523f1555735ca996c4106
3	0x1ab33a7454427814a71f128109fe5b498aa21e5d	0x8cd7ae46beba2668aadb864c285b43f3aa2dd7fd	false	185466736013914557912	77	24792525	2023-01-14T23:53:58.000Z	0x93094f36961e04227796c9a00c694f216575e8baeaaea3eb06e085d87d30a4ae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.levelfinance_v1_bsc.LevelMaster_Harvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LevelReferralController_Claimed_event

Referral reward claim events from Level Finance protocol on BNB Smart Chain (BSC), capturing recipient addresses, reward amounts, epoch identifiers, and whether rewards were staked. Used for tracking referral program payouts and analyzing user incentive participation patterns.

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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`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_stake`	`BOOL`	Amount of staked or collateralized tokens denominated in the smallest unit of the asset. String-encoded decimal value representing wei for EVM chains or lamports for Solana.

Sample Data

in_to	address	removed	in_stake	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x16b00db74167b7469dda63b674ca9a3b1b70c439	0x22e7f559be09b6a758f02a84ddc64f45642206a1	false	true	229332491437752078775	241	25236898	2023-01-30T14:55:35.000Z	0xd15a7697c44a2388fe4bab79fcd3ee1bcf05056acc774897391060b0ebb54e56
0x41601c8acfbef0c1ebcb5652c448429bad3a0b1f	0x22e7f559be09b6a758f02a84ddc64f45642206a1	false	true	279771535692466704807	286	25236127	2023-01-30T14:16:12.000Z	0xc9b9ebad173f4da0200c8c44fe8a980e2f401e4579f33dfbca5c6ce85b236675
0x607ba59547edaec74a878f4137ed6e2b50c16af9	0x22e7f559be09b6a758f02a84ddc64f45642206a1	false	true	1593510971266700180	133	25236182	2023-01-30T14:18:57.000Z	0x37550f41ed54df81fd929e911630d45a1def54b035424750494d44b2eb643eee

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.levelfinance_v1_bsc.LevelReferralController_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LevelStake_RewardsClaimed_event

Reward claim events from Level Finance staking contracts on BNB Smart Chain, recording user addresses and claimed amounts. Used to track staking reward distribution patterns and user claim behavior across the protocol.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x842e1e3b8586cd1c53eb631e236465c755cb1713	0x87cc04d6fe59859cb7eb6d970ebc22dcdcbc9368	0x842e1e3b8586cd1c53eb631e236465c755cb1713	false	60669900000000	258	26028599	2023-02-27T11:04:06.000Z	0xc66c41d272d8ae31f833c7104ecc04307321157b3dc44c889928e0b4731aec19
0xb717065df864260c4490c5bf4d0df2f27363e407	0x87cc04d6fe59859cb7eb6d970ebc22dcdcbc9368	0xb717065df864260c4490c5bf4d0df2f27363e407	false	2578041461993	258	26034529	2023-02-27T16:04:30.000Z	0x5377dbdb049f9bcbc5b8c77ea09a8d3e017d4c50b059def359232206b5c076d7
0x5da66a9fdf4292dee0039ad18b281cfde2ff99a3	0x87cc04d6fe59859cb7eb6d970ebc22dcdcbc9368	0x5da66a9fdf4292dee0039ad18b281cfde2ff99a3	false	233541900000000	259	26025110	2023-02-27T08:07:43.000Z	0xad94a6c82a35c7a24c264c7dd47b570ee0f8f87b4181cec120b9665e76b9104b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.levelfinance_v1_bsc.LevelStake_RewardsClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LyLevel_Claimed_event

Claim events for lyLEVEL tokens from Level Finance on BNB Smart Chain, tracking reward distributions to users by batch ID. Used for analyzing reward claim patterns and recipient behavior in the Level Finance loyalty program.

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_batchId`	`STRING`	Identifier for the batch from which rewards or tokens are being claimed. Sequential numeric value stored as string, tracking different claim distributions or reward cycles.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	in_user	removed	in_amount	log_index	in_batchId	block_number	block_timestamp	transaction_hash
0x446683a4438e338ebc4c378177de24c2f5374673	0x95883611685a20936ec935b0a33f82e11d478e3d	0x446683a4438e338ebc4c378177de24c2f5374673	false	667500601990049750	334	8	25632730	2023-02-13T13:26:20.000Z	0xf6e81bfb97ac9f47db7c4684d1296bfb1116aaba63d604382694b23f1dcfa7a3
0x446683a4438e338ebc4c378177de24c2f5374673	0x95883611685a20936ec935b0a33f82e11d478e3d	0x446683a4438e338ebc4c378177de24c2f5374673	false	83487501372113645117	252	13	25632732	2023-02-13T13:26:26.000Z	0x5762355c90c4597f3e6a3fcc8b069cc4244e5b295dfd6abbd63f028ae328489b
0x446683a4438e338ebc4c378177de24c2f5374673	0x95883611685a20936ec935b0a33f82e11d478e3d	0x446683a4438e338ebc4c378177de24c2f5374673	false	720266579999999999	309	14	25632734	2023-02-13T13:26:32.000Z	0x469030c48845a03eb7f8b9fad3326810218e2e7e9624bffe8aede79295514546

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.levelfinance_v1_bsc.LyLevel_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_DaoFeeSet_event

DAO fee configuration changes for Level Finance liquidity pools on BSC, capturing when protocol governance updates fee parameters. Useful for tracking fee policy adjustments and governance decisions affecting pool economics.

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

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	false	5500000000	70	26401151	2023-03-12T12:47:28.000Z	0xcd3f5f99f3142db0a0d97b3126376fe67c97806f5f10f2e06876f9d203ec96d5
0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	false	5000000000	66	24088804	2022-12-21T06:31:27.000Z	0x02d0073a3899b193933121ef864acfe23c41fcad7596f4d61ff5d9399efc8350

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.levelfinance_v1_bsc.Pool_DaoFeeSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_DecreasePosition_event

Position closure and reduction events from Level Finance perpetual futures protocol on BSC. Records position size decreases with realized PnL, fees, collateral changes, and index prices for tracking trader exits and liquidations.

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 or removed from the position, denominated in the smallest unit of the collateral token. Precision varies by token decimals; typically 18 decimals for ERC-20 tokens.
`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`	`STRUCT<sig STRING, abs 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

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
0x03d67806d1120c777d66472aafcc12803251383246c449589bbfc9aac985beac	{“abs”:“574626775763731714019712787914351”,“sig”:“1”}	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	1	false	634	0x00025b6e165654bc0931b2f29a66be4852e6011b	29919412655754208252559717253398	32655143	27892580000000000	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	29919412655754208252559717253398800	2023-10-16T13:49:52.000Z	0x8d4b8d538e9a78f63e0f6e1d4b0197a3a194cd77669688ad5aa769f0473f63c2	0x55d398326f99059ff775485246999027b3197955	2994466324634892098315345120795579
0xdf69e1ea2d23b432a4d6225e210dc8971e3d65c3583efc088c30719b8364033d	{“abs”:“90184800053221070067772374515806”,“sig”:“1”}	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	1	false	542	0x2f63fef950f5834fadaa07472e6ae9f29818867f	5850679773498862570462353375900	32654815	29460947130500000	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	5850679773498862570462353375900000	2023-10-16T13:33:28.000Z	0xbd309546117cb8c26a0bbd42df997529e4f6e77461264d8ddd70cd8c33d7a3fb	0x55d398326f99059ff775485246999027b3197955	1155695842436419783878537646624100
0x03d67806d1120c777d66472aafcc12803251383246c449589bbfc9aac985beac	{“abs”:“8161755453708800512030152191791”,“sig”:“1”}	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	1	false	31	0x00025b6e165654bc0931b2f29a66be4852e6011b	1983331089108910875644102411179	32658267	28137940828000000	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	1980198019801980182599193966486400	2023-10-16T16:26:08.000Z	0xd5f555b96908b923b4806e216701ee1029a7c42086a564fb472f00b524bbec73	0x55d398326f99059ff775485246999027b3197955	198019801980198019817400806033514

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.levelfinance_v1_bsc.Pool_DecreasePosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_IncreasePosition_event

Position increase events from Level Finance perpetual futures protocol on BNB Smart Chain. Tracks leverage position openings and additions with account, collateral token, index token, size changes, fees, and entry prices for analyzing trader behavior and protocol utilization.

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

in_key	address	removed	log_index	in_account	in_feeValue	block_number	in_indexPrice	in_indexToken	in_sizeChanged	block_timestamp	transaction_hash	in_collateralToken	in_collateralValue
0x5c9466de546240fcfff5db7fd7732c3a9a0d0cc967a23dd6661958df86d7ecae	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	false	189	0xd8496d862320e94ba69b9c0da6c172f0bf67759a	147674551075567618889823819720	25451439	4476623520000	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	147674551075567618889823819720000	2023-02-07T04:56:40.000Z	0x20ef983b0060ebf1ed5d3c3b98bcf27258d06ad6af132bf461df9088f2ac0b4e	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	2228758943250925339
0x5c9466de546240fcfff5db7fd7732c3a9a0d0cc967a23dd6661958df86d7ecae	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	false	127	0xd8496d862320e94ba69b9c0da6c172f0bf67759a	151690324187459099310740274780	25454276	4498650890000	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	151690324187459099310740274780000	2023-02-07T07:19:52.000Z	0x4ec93e64a62448fce5c142274cbfe3d07db0932712a95ec55c04b896cf3cb80d	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	2281580367991876671
0x5c9466de546240fcfff5db7fd7732c3a9a0d0cc967a23dd6661958df86d7ecae	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	false	148	0xd8496d862320e94ba69b9c0da6c172f0bf67759a	11665880423153692614465351440	25455687	4496500920000	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	11665880423153692614465351440000	2023-02-07T08:31:50.000Z	0xef9866d302a3b698f734e4c91d7b3762cf46c8f1af1d8f7bc83e59283fcc0e93	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	1300000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.levelfinance_v1_bsc.Pool_IncreasePosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_LiquidatePosition_event

Liquidation events from Level Finance perpetual futures protocol on BSC, capturing forced position closures with profit/loss, collateral value, fees, and reserve amounts. Used for analyzing liquidation patterns, risk management effectiveness, and market volatility impacts on leveraged positions.

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`	`STRUCT<sig STRING, abs 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

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
0x287765cdcaf32ebe2cab35947da06fd12607c8a48a362fe09302992afbdabc96	{“abs”:“220672183635354245241117268267”,“sig”:“0”}	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	0	158866560299089746658700000000000	false	18	0xabebdb7d35f38d519d1c3ed72d3975424f420417	158866560299089746658700000000	24785244	20821989494000000	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	2023-01-14T17:46:01.000Z	7628725431367791	0x6cff1839506e6375fb004ed7fab3d744e8bf18564d13e0798a0bd3502c5f62ca	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	5292327214075798810841604500000
0xd63c7a23121b624879032fb3c30b4e9fad088868560aaae80395ee842f9b2ae3	{“abs”:“13778161576612475438800680588497”,“sig”:“0”}	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	0	581059610937527550441800000000000	false	6	0x7759d4d8fa7d7350a790fe040ce729e8e78bdbec	592453434530518246920148123660	24776490	20355307255000000	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	2023-01-14T10:24:08.000Z	27927885590142183	0xc5881314f5dbfe4fa38815ab4a14d1b2435b09c65481d35dd45b6e1902f6f463	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	19307774622280631984973016000000
0x43fc0cbfd914e6f92c4b8bd3af7ffb54a5ca67ae1aa4cb3cc43ed3a21790099e	{“abs”:“486927243635489839426325219404713”,“sig”:“0”}	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	1	2487562189054726367879680000000000	false	45	0x9d0d14bc3a4ec7d857212432a7455df80f214d5c	2999842288557213930011170508288	24765465	21001740000000000	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	2023-01-14T01:07:42.000Z	2488308781221444049952	0x23d0975dcfeb8ca3ed56dd46868162c078da332b59d8b3bf6a7b776cb58bcc6b	0xe9e7cea3dedca5984780bafc599bd69add087d56	497362417810945273632120320000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.levelfinance_v1_bsc.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.

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.

Sample Data

in_fee	address	removed	in_sender	log_index	in_tokenIn	in_amountIn	in_tokenOut	block_number	in_amountOut	block_timestamp	transaction_hash
304301310000000	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	false	0xf584a17df21afd9de84f47842eceaf6042b1bb5b	170	0xe9e7cea3dedca5984780bafc599bd69add087d56	100000000000000000	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	25259415	24971127276114610	2023-01-31T10:04:33.000Z	0x20c86eabc5d31890e320c8adfe6da16f8f62362980daa90b105ee79cc85cf7a5
303963360000000000	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	false	0xf584a17df21afd9de84f47842eceaf6042b1bb5b	59	0xe9e7cea3dedca5984780bafc599bd69add087d56	100000000000000000000	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	25263624	24767663197060876200	2023-01-31T13:41:24.000Z	0x274acabd228d91cabe9dddc293afb23f11c165ae521df8d9e14fed524a2d2234
52542944000000	0xa5abfb56a78d2bd4689b25b8a77fd49bb0675874	false	0xf584a17df21afd9de84f47842eceaf6042b1bb5b	240	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	20000000000000000	0x2170ed0880ac9a755fd29b2688956bd959f933f8	25270739	3921084365852123	2023-01-31T19:43:48.000Z	0x1f8d88dfd7526d77ddec76ad276c6253a348bfb1017e69e0220a2ff2785ce296

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.levelfinance_v1_bsc.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

LevelMaster_Harvest_event

LevelReferralController_Claimed_event

LevelStake_RewardsClaimed_event

LyLevel_Claimed_event

Pool_DaoFeeSet_event

Pool_DecreasePosition_event

Pool_IncreasePosition_event

Pool_LiquidatePosition_event

Pool_Swap_event

​Tables

​LevelMaster_Harvest_event

​LevelReferralController_Claimed_event

​LevelStake_RewardsClaimed_event

​LyLevel_Claimed_event

​Pool_DaoFeeSet_event

​Pool_DecreasePosition_event

​Pool_IncreasePosition_event

​Pool_LiquidatePosition_event

​Pool_Swap_event

Tables

LevelMaster_Harvest_event

LevelReferralController_Claimed_event

LevelStake_RewardsClaimed_event

LyLevel_Claimed_event

Pool_DaoFeeSet_event

Pool_DecreasePosition_event

Pool_IncreasePosition_event

Pool_LiquidatePosition_event

Pool_Swap_event