bachisweat3
    Updated 2022-09-21
    SELECT
    round(avg(PRICE_USD),2) AS avg_price,
    date(date_trunc('hour', timestamp)) AS date,
    case when date < '2022-09-13' then 'Before SWEAT Launch'
    when date >= '2022-09-13' then 'After SWEAT Launch'
    end as time_period
    FROM near.core.fact_prices
    WHERE lower(SYMBOL) = 'near'
    AND TIMESTAMP >= '2022-09-01'
    GROUP BY date, time_period
    ORDER BY date ASC
    Run a query to Download Data