levelfinance_v2_bsc

Tables

LevelMasterv2_Harvest_event

Reward harvest events from Level Finance v2 yield farming pools on BNB Smart Chain, recording when users claim earned tokens from specific pool IDs (pid). Used to track farming reward distributions and user yield claiming behavior 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
0	0x5ae081b6647aef897dec738642089d4bda93c0e7	0xfd03dfe0a2c17356420252d63546f04aa2356359	false	65368499373370088206	117	28548818	2023-05-26T13:01:40.000Z	0xc70e926ac21254da61a0f1225b3c9372fe22e58107cb1a770af491dea1a6988e
2	0x5ae081b6647aef897dec738642089d4bda93c0e7	0x67bcd41adbf12d1ecffd86e17af2b14179b556a3	false	10775586358615746456	192	28549914	2023-05-26T13:56:31.000Z	0xe5f31e00d05b730063d3662fa7d6dab86abe9bc0adc70be789d5aca5ffe77a96
2	0x5ae081b6647aef897dec738642089d4bda93c0e7	0xaf79312eb821871208ac76a80c8e282f8796964e	false	9247294154818230	137	28535343	2023-05-26T01:47:20.000Z	0x342d944e1efafe4969463714b4a7a8fdf9e7325d908cb58e3ea9ed425f950797

Example Query

Query with partition filter

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

LevelReferralControllerv2_Claimed_event

Referral reward claim events from Level Finance V2 protocol on BNB Smart Chain, tracking when users claim their referral incentives by epoch with reward amounts and recipient addresses. Used for analyzing referral program participation and reward distribution 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.

Sample Data

in_to	address	removed	in_epoch	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xd7c443e9960c55fa217a5ac9564f10a58fc87551	0x977087422c008233615b572fbc3f209ed300063a	false	5	1144848042889480152	355	26908278	2023-03-30T07:52:43.000Z	0xf8979e376d29bd96e8e101bcaadfc8b1e1365b3b3a6bb6e07e210137707e6fec
0xa2d31a949c69a67ee86b48d029c0d546162642f3	0x977087422c008233615b572fbc3f209ed300063a	false	8	75295971573671767788	98	26925561	2023-03-30T22:22:40.000Z	0xbcc77e082ef68c8c2e2372176613549ddf3312277bcb6d05f273d4ea76597c07
0xc202a99c8b8ef80502876515e559459db02c7971	0x977087422c008233615b572fbc3f209ed300063a	false	8	41513427314739392502	199	26912799	2023-03-30T11:39:34.000Z	0x07e8a42cca2470f61acdcd07115295766ef4c3b9ec8edb4e6ad5ae234ab5fd33

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

LevelMasterv2_Harvest_event

LevelReferralControllerv2_Claimed_event

​Tables

​LevelMasterv2_Harvest_event

​LevelReferralControllerv2_Claimed_event

Tables

LevelMasterv2_Harvest_event

LevelReferralControllerv2_Claimed_event