nitsUntitled Query
Updated 2022-01-27
9
1
2
3
4
5
6
7
›
⌄
-- select sum(balance)/pow(10,6) as amt_held from
(select * from
(select address as addr, balance from terra.daily_balances
where CURRENcy = 'LUNA' and date = CURRENT_DATE -1 )
inner join terra.labels on address = addr )
where label is NULL and balance is not NULL
limit 100
Run a query to Download Data