kidaPrices
Updated 2023-03-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
recorded_at::date as date,
symbol,
AVG(
CASE
WHEN symbol = 'OSMO' AND recorded_at >= '2021-09-30' AND recorded_at < '2021-10-01' THEN 4.99 --adjust price
WHEN symbol = 'OSMO' AND recorded_at >= '2021-10-01' AND recorded_at < '2021-10-02' THEN 5.30 --adjust price
WHEN symbol = 'OSMO' AND recorded_at >= '2021-10-02' AND recorded_at < '2021-10-03' THEN 5.50 --adjust price
WHEN symbol = 'OSMO' AND recorded_at >= '2021-10-03' AND recorded_at < '2021-10-04' THEN 5.62 --adjust price
ELSE price
END
) as price
FROM osmosis.core.dim_prices
WHERE date >= '2021-06-01'
GROUP BY date, symbol
ORDER BY date DESC
Run a query to Download Data