Skip to main content

​
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.
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
00x5ae081b6647aef897dec738642089d4bda93c0e70xfd03dfe0a2c17356420252d63546f04aa2356359false65368499373370088206117285488182023-05-26T13:01:40.000Z0xc70e926ac21254da61a0f1225b3c9372fe22e58107cb1a770af491dea1a6988e
20x5ae081b6647aef897dec738642089d4bda93c0e70x67bcd41adbf12d1ecffd86e17af2b14179b556a3false10775586358615746456192285499142023-05-26T13:56:31.000Z0xe5f31e00d05b730063d3662fa7d6dab86abe9bc0adc70be789d5aca5ffe77a96
20x5ae081b6647aef897dec738642089d4bda93c0e70xaf79312eb821871208ac76a80c8e282f8796964efalse9247294154818230137285353432023-05-26T01:47:20.000Z0x342d944e1efafe4969463714b4a7a8fdf9e7325d908cb58e3ea9ed425f950797
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.
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_epochSTRINGEpoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_toaddressremovedin_epochin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0xd7c443e9960c55fa217a5ac9564f10a58fc875510x977087422c008233615b572fbc3f209ed300063afalse51144848042889480152355269082782023-03-30T07:52:43.000Z0xf8979e376d29bd96e8e101bcaadfc8b1e1365b3b3a6bb6e07e210137707e6fec
0xa2d31a949c69a67ee86b48d029c0d546162642f30x977087422c008233615b572fbc3f209ed300063afalse87529597157367176778898269255612023-03-30T22:22:40.000Z0xbcc77e082ef68c8c2e2372176613549ddf3312277bcb6d05f273d4ea76597c07
0xc202a99c8b8ef80502876515e559459db02c79710x977087422c008233615b572fbc3f209ed300063afalse841513427314739392502199269127992023-03-30T11:39:34.000Z0x07e8a42cca2470f61acdcd07115295766ef4c3b9ec8edb4e6ad5ae234ab5fd33
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