datavortexTop Gainers
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_closing_price AS (
SELECT
symbol,
price AS closing_price_sept_1
FROM
solana.price.ez_prices_hourly
WHERE
hour = '2024-09-01 23:00:00'
),
sept_25_closing_price AS (
SELECT
symbol,
price AS closing_price_sept_25
FROM
solana.price.ez_prices_hourly
WHERE
hour = '2024-09-25 23:00:00'
)
SELECT
s1.symbol,
s1.closing_price_sept_1,
s25.closing_price_sept_25
FROM
sept_1_closing_price s1
JOIN
sept_25_closing_price s25 ON s1.symbol = s25.symbol
ORDER BY
s1.symbol;
*/
WITH sept_1_closing_price AS (
SELECT
symbol,
price AS closing_price_sept_1
QueryRunArchived: QueryRun has been archived