Skip to main content

​
Tables

​
MasterWombatV3_Harvest_event

Reward claiming events from Wombat Exchange V3 staking pools on Arbitrum, tracking harvested token amounts by user and pool ID (pid). Useful for analyzing yield distribution patterns and staker reward collection 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
00x62a83c6791a3d7950d823bb71a38e47252b6b6f40x24d2f6be2bf9cdf3627f720cf09d4551580c1ec1false424376504315738103118641191018792023-08-07T16:32:50.000Z0x9b22a7fe5ce0957b9ea2dc1d8940ebdc9af4c3a0da732ee8f430a81e4e1fb5e2
00x62a83c6791a3d7950d823bb71a38e47252b6b6f40x24d2f6be2bf9cdf3627f720cf09d4551580c1ec1false39785093582212090933631190573372023-08-07T13:25:00.000Z0xd57a46e462f26054020f34a97b9f75f3b8e2c57f574de94d27d57646e0dd57a2
00x62a83c6791a3d7950d823bb71a38e47252b6b6f40x24d2f6be2bf9cdf3627f720cf09d4551580c1ec1false2474220150747692450180171190156242023-08-07T10:29:13.000Z0xa508cc221607d828e0315291474c3c2da59688bdd5f18c7d0ab48a1f97b2b715
Query with partition filter
SELECT *
FROM `tt-contracts.wombat_v3_arbitrum.MasterWombatV3_Harvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100