sarathterra
Updated 2021-12-08
9
1
2
3
4
5
6
7
8
9
›
⌄
with datas as(
SELECT date(block_timestamp)as date1,sum(luna_exchange_rate) from terra.oracle_prices
GROUP by 1
),
datas2 as(
SELECT balance_usd,date from terra.daily_balances
)
SELECT * from datas2 join datas on datas.date1=datas2.date
limit 10000
Run a query to Download Data