DATE | AVG(CLOSE) | |
|---|---|---|
1 | 2024-01-25 00:00:00.000 | 87.48682968 |
2 | 2024-01-26 00:00:00.000 | 90.049809315 |
3 | 2024-01-27 00:00:00.000 | 92.428305228 |
4 | 2024-01-28 00:00:00.000 | 96.225265552 |
5 | 2024-01-29 00:00:00.000 | 98.19354352 |
6 | 2024-01-30 00:00:00.000 | 103.773151356 |
7 | 2024-01-31 00:00:00.000 | 99.818789982 |
8 | 2024-02-01 00:00:00.000 | 95.429753604 |
jackiehighnoonsolana_daily_price
Updated 2024-02-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
date_trunc(day, recorded_hour) as date,
avg(close)
FROM
solana.price.fact_token_prices_hourly
WHERE
symbol = 'SOL'
AND recorded_hour :: date >= current_date - 7
AND close > 1
GROUP BY
1
ORDER BY
1
Last run: about 1 year ago
8
328B
2s