Tobi_1elegant-violet
Updated 2024-09-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
⌄
WITH daily_prices AS (
SELECT
HOUR::DATE AS date,
AVG(PRICE) AS avg_daily_price
FROM
base.price.ez_prices_hourly;
WHERE
TOKEN_ADDRESS = '0x532f27101965dd16442e59d40670faf5ebb142e4'
GROUP BY
HOUR::DATE
ORDER BY
date ASC
)
-- Final query: Select the daily price trend
SELECT
date,
avg_daily_price
FROM
daily_prices;
QueryRunArchived: QueryRun has been archived