flipside

    BTC price last 6 months
    m0rt3zaBTC price last 6 months
    Updated 2022-06-12
    SELECT recorded_at::date AS date, avg(price) as btc_price
    FROM osmosis.core.dim_prices
    WHERE symbol = 'WBTC'
    AND recorded_at > dateadd(months, -6, getdate())
    GROUP BY date
    ORDER BY date DESC
    Run a query to Download Data