headitmanagerHead to Head - UST
Updated 2022-03-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with max_data as (SELECT address,MAX(date) as max_date
FROM terra.daily_balances
where currency='UST' and balance>0 and date>'2022-01-01'
GROUP BY address)
, tbl_result as(Select t.address,balance,date from terra.daily_balances as t inner join max_data
on max_data.address = t.address and max_data.max_date = t.date
where t.currency='UST' and balance>0 and date>'2022-01-01')
select * from tbl_result
order by balance DESC
limit 20
Run a query to Download Data