Skip to main content

​
Tables

​
MasterWombatV3_Harvest_event

Harvest events from Wombat Exchange V3 staking pools on BNB Smart Chain, recording reward claims by users from specific pool IDs with token amounts. Used for analyzing staking reward distribution patterns and user 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
360x489833311676b566f888119c29bd997dc6c958300x84d7bd6699cf400329989980ce87e3db3f03e869false22991443742714889394388277439732023-04-28T13:17:40.000Z0x9b5d07df67584a1970e096de5eb4767bc95f3438f67002236ffa4ded6d37eb7b
00x489833311676b566f888119c29bd997dc6c958300x7f5e95fa60ba1dedf71cd22934d345e20ef70410false725303303352843341881813277424272023-04-28T12:00:17.000Z0xd868a241e8bc3d81e6936c10dad4a6c4c1c3f026d6f72fca9ea055d74ec93405
220x489833311676b566f888119c29bd997dc6c958300x4c8f8089607ba1d370c7c62743a309bcb01d1eecfalse120112211312869198303277313752023-04-28T02:46:49.000Z0x5d2a8b977b3bf38615739c5fe97ec81fcae815619a8b32102aab74ee48d92d73
Query with partition filter
SELECT *
FROM `tt-contracts.wombat_v3_bsc.MasterWombatV3_Harvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100