Skip to content
Dune Analytics

@tianqi / Acculate Claimed KEEP Rewards By Day

SQL query results

Loading
 

SQL query

1with daily_claimed as
2(select date_trunc('day',evt_block_time) as day, sum(amount)/1e18  as rewards from keep_v110."ECDSARewards_evt_RewardReceived"
3group by 1)
4
5select day,sum(rewards) over(order by day desc) from daily_claimed
6order by 1
7