zakkisyedUntitled Query
    Updated 2021-12-06
    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