boomer77top staking balance
Updated 2021-12-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with raw as (select *, ROW_NUMBER() OVER (ORDER BY event_amount desc) as rank
from terra.staking
where action = 'delegate' and block_timestamp >= CURRENT_DATE - 7 and tx_status = 'SUCCEEDED'),
top10 as (select delegator_address, event_amount
from raw
where rank < 11
order by 2 desc)
select date, address, balance
from terra.daily_balances
where currency = 'LUNA' and balance_type = 'staked' and date >= CURRENT_DATE - 30
and address in (select delegator_address from top10)
Run a query to Download Data