peteerTop 5 users : most amount of claims per month
Updated 2022-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
with amount_of_top5_claimed_each_users as
(
select sum(claimed_amount_usd) ,origin_from_address from optimism.velodrome.ez_claimed_rewards
where claimed_amount_usd>0
group by 2
order by 1 DESC
limit 5
)
,amount_of_top5_claimed_each_users_day as
(
select sum(claimed_amount_usd),date_trunc('day', block_timestamp),origin_from_address from optimism.velodrome.ez_claimed_rewards
where origin_from_address in (select origin_from_address from amount_of_top5_claimed_each_users)
group by 2,3
)
,amount_of_top5_claimed_each_users_week as
(
select sum(claimed_amount_usd),date_trunc('week', block_timestamp),origin_from_address from optimism.velodrome.ez_claimed_rewards
where origin_from_address in (select origin_from_address from amount_of_top5_claimed_each_users)
group by 2,3
)
,amount_of_top5_claimed_each_users_month as
(
select sum(claimed_amount_usd),date_trunc('month', block_timestamp),origin_from_address from optimism.velodrome.ez_claimed_rewards
where origin_from_address in (select origin_from_address from amount_of_top5_claimed_each_users)
group by 2,3
)
select * from amount_of_top5_claimed_each_users_month
Run a query to Download Data