DAY | SYMBOL | CLOSE_PRICE | |
---|---|---|---|
1 | 2024-08-01 00:00:00.000 | USDT | 0.999186 |
2 | 2024-08-02 00:00:00.000 | USDT | 0.998736 |
3 | 2024-08-03 00:00:00.000 | USDT | 0.999328 |
4 | 2024-08-04 00:00:00.000 | USDT | 0.999348 |
5 | 2024-08-05 00:00:00.000 | USDT | 0.999549 |
6 | 2024-08-06 00:00:00.000 | USDT | 1 |
7 | 2024-08-07 00:00:00.000 | USDT | 0.999095 |
8 | 2024-08-08 00:00:00.000 | USDT | 1 |
9 | 2024-08-09 00:00:00.000 | USDT | 1.001 |
10 | 2024-08-10 00:00:00.000 | USDT | 1.001 |
11 | 2024-08-11 00:00:00.000 | USDT | 0.999145 |
12 | 2024-08-12 00:00:00.000 | USDT | 0.999735 |
13 | 2024-08-13 00:00:00.000 | USDT | 0.999831 |
14 | 2024-08-14 00:00:00.000 | USDT | 1 |
15 | 2024-08-15 00:00:00.000 | USDT | 1.001 |
16 | 2024-08-16 00:00:00.000 | USDT | 0.999703 |
17 | 2024-08-17 00:00:00.000 | USDT | 1 |
18 | 2024-08-18 00:00:00.000 | USDT | 0.99971 |
19 | 2024-08-19 00:00:00.000 | USDT | 1 |
20 | 2024-08-20 00:00:00.000 | USDT | 1 |
datavortexPrice 2
Updated 2024-09-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
date_trunc('day', hour) AS day,
symbol,
price AS close_price
FROM
solana.price.ez_prices_hourly
WHERE
symbol = '{{token2}}'
AND EXTRACT(hour FROM hour) = 23
AND hour BETWEEN '{{start_date2}}' AND '{{end_date2}}'
GROUP BY
date_trunc('day', hour),
symbol,
price
ORDER BY
day;
Last run: about 1 month ago
29
1KB
1s