zakkisyedUntitled Query
Updated 2021-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc('day', t.block_timestamp), avg(t.event_amount_usd/t.event_amount) as luna_price, sum(d.balance) as ust_supply
from terra.transfers as t
inner join terra.daily_balances as d
on t.block_timestamp = d.date
--
--where t.event_currency = 'ust'
--and d.currency = 'ust'
where d.date > CURRENT_DATE - 30
group by 1
order by 1 desc
Run a query to Download Data