bachisweat3
Updated 2022-09-21
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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