Skip to main content

​
Tables

​
MultipleMerkleDistributor_Claimed_event

Token claim events from Kwenta v1’s merkle distributor contract on Optimism. Records user claims of trading rewards by epoch, useful for analyzing reward distribution patterns and participant engagement across incentive periods.
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
0xf486a72e8c8143acd9f65a104a16990fdb38be14false21159217000267610496740xb8e1f0f1e0aab629ec07ae9e4fa680b58732c643895010672023-04-12T13:45:00.000Z0xe1739b7e176a251422841f6f9f66a1786f7b50edb8e09cf2e2923bd1de463485
0xf486a72e8c8143acd9f65a104a16990fdb38be14false41152101518126897901689940xa3e373ad4b28ce9b6a35253d7fddeb875df5fb77596276872023-01-03T15:03:16.000Z0x3072d1c1580f5b92cfd39ea4aff5c9997e9ce8091863fded534e20a2d53709c0
0xf486a72e8c8143acd9f65a104a16990fdb38be14false61091554405798355925355590xa3e373ad4b28ce9b6a35253d7fddeb875df5fb77596276872023-01-03T15:03:16.000Z0x3072d1c1580f5b92cfd39ea4aff5c9997e9ce8091863fded534e20a2d53709c0
Query with partition filter
SELECT *
FROM `tt-contracts.kwenta_v1_optimism.MultipleMerkleDistributor_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100