Skip to main content

​
Tables

​
StakingV2_RewardPaid_event

Staking reward distribution events emitted when users claim accrued rewards from staking contracts. Records the recipient address, reward token contract, and reward amount paid out.
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_rewardsTokenSTRINGContract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
addressin_userremovedin_rewardlog_indexblock_numberblock_timestampin_rewardsTokentransaction_hash
0xaeaf7948c38973908ffa97c92f3384595d0571350x9284a936a907a15429396346f99cc1c800f8af00false26650240384849875148180084952023-08-27T20:51:35.000Z0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20x62d97d172f9b5b8326e00a7c8dd6b6c5e5a2f448b3ba4e74049d5979431dab2b
0xaeaf7948c38973908ffa97c92f3384595d0571350x35119741d2d3c40fcd456a93860f68c1754a4f56false2830425207859422047182041062023-09-24T07:15:23.000Z0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20x359303ceff0fe7a2a1439bcb0242677863d149f856a85dc091286745fdfbcffb
0xaeaf7948c38973908ffa97c92f3384595d0571350xf9b16de65d501fe05ca3373a8134d1e176e964b8false17739382353204232182029152023-09-24T03:14:35.000Z0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20x36677825c4e9cada57fb53a098cb4b7d95573c0be8fcca577be6700fb82ebf91
Query with partition filter
SELECT *
FROM `tt-contracts.betswirl_v2_ethereum.StakingV2_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100