Skip to main content

​
Tables

​
MultipleMerkleDistributor_Claimed_event

Reward claim events from Kwenta v2’s merkle distributor contract on Optimism, tracking token distributions to traders across numbered epochs. Used for analyzing trading incentive claims 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_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
in_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_epochSTRINGEpoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
addressremovedin_epochin_indexin_amountlog_indexin_accountblock_numberblock_timestamptransaction_hash
0x2787cc20e5ecb4bf1bfb79eae284201027683179false431094200340354901652440x752d5a59d9cd3ed8af87e0c8939d5d19db1683311119768752023-11-09T17:55:27.000Z0x34aa40a8837d0465e3fadebfac8d0f41e7d9629c6669efa6b35ad131cecef0a8
0x2787cc20e5ecb4bf1bfb79eae284201027683179false411072315183056857108390x752d5a59d9cd3ed8af87e0c8939d5d19db1683311119768752023-11-09T17:55:27.000Z0x34aa40a8837d0465e3fadebfac8d0f41e7d9629c6669efa6b35ad131cecef0a8
0x2787cc20e5ecb4bf1bfb79eae284201027683179false39140140395508953378342150x67d21ebd269d61ef8cd9f0f3698869b3d818a4b51124396622023-11-20T11:01:41.000Z0x600760fefd0fd769e874edca62fb23ea01619aa8d9397eef894176d137019f2b
Query with partition filter
SELECT *
FROM `tt-contracts.kwenta_v2_optimism.MultipleMerkleDistributor_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100