datavortexStable 1
Updated 2024-09-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH sept_1_price AS (
SELECT
symbol,
MAX(price) AS closing_price,
date_trunc('day', hour) AS date
FROM
solana.price.ez_prices_hourly
WHERE
date_trunc('day', hour) = '2024-09-01'
GROUP BY
symbol, date
),
latest_price AS (
SELECT
symbol,
MAX(price) AS closing_price,
date_trunc('day', hour) AS date
FROM
solana.price.ez_prices_hourly
WHERE
date_trunc('day', hour) = '2024-09-25'
GROUP BY
symbol, date
)
SELECT
s1.symbol,
s1.closing_price AS closing_price_sept_1,
s2.closing_price AS closing_price_sept_25,
((s2.closing_price - s1.closing_price) / s1.closing_price) * 100 AS percentage_change
FROM
sept_1_price s1
JOIN
latest_price s2
ON
QueryRunArchived: QueryRun has been archived