Skip to main content

​
Tables

​
RewardsLocker_CollectRewards_event

Reward collection events from KapitalDAO’s RewardsLocker contract on Ethereum, tracking when beneficiaries claim rewards from specific lock agreements. Used for analyzing vesting schedules, token distribution patterns, and user claim behavior.
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_beneficiarySTRINGAddress that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_lockAgreementIdSTRINGUnique identifier for a specific lock agreement in the KapitalDAO rewards locker contract. Numeric string value that references the agreement under which rewards are being collected.
addressremovedlog_indexblock_numberin_beneficiaryblock_timestamptransaction_hashin_lockAgreementId
0xcb0460f5206ed006e6f2d012638027a255864f17false188208456280x39bbb8c321fdf88804c4f82487cb91115f1ec7802024-09-28T00:44:35.000Z0x156711a83297bafa51a73d083bef7045ae95c7f579e3ba0ac4ea0911f93b89ba35
0xcb0460f5206ed006e6f2d012638027a255864f17false92208456360x39bbb8c321fdf88804c4f82487cb91115f1ec7802024-09-28T00:46:11.000Z0x479b7ae46f55f90b0e8fd8554ea18f57cb2f974d869c8227fce2675e9b4bb01a37
0xcb0460f5206ed006e6f2d012638027a255864f17false199208456310x39bbb8c321fdf88804c4f82487cb91115f1ec7802024-09-28T00:45:11.000Z0x1f1c82dfd8fbdca988c8406e3e130c61bbbafe8ab728297551f391eb6964469236
Query with partition filter
SELECT *
FROM `tt-contracts.kapitaldao_v1_ethereum.RewardsLocker_CollectRewards_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100