boomer77supply luna vs price
Updated 2021-12-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with supp as (select sum(balance) as total, currency, date
from terra.daily_balances
where currency in ('LUNA') and date > CURRENT_DATE - 89
and address not in ('terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh', 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6', '')
group by 2,3),
price as (select date_trunc('day', block_timestamp) as dt, avg(price_usd) as price
from terra.oracle_prices
where symbol = 'LUNA'
group by 1)
select a.date, a.currency, a.total, b.price
from supp a
left join price b on a.date = b.dt
Run a query to Download Data