boomer77Untitled Query
Updated 2022-01-25
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with raw as (select address, sum(balance) as total, currency, ROW_NUMBER() OVER(ORDER BY total desc) AS Rank
from terra.daily_balances
where currency in ('LUNA')
and address not in ('terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh')
and date = CURRENT_DATE - 1 and balance > 0
group by 1,3)
select address, total
from raw
order by total desc
limit 100
Run a query to Download Data