sarathterra
    Updated 2021-12-08
    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