DAY | SYMBOL | DAILY_AVG_PRICE | |
|---|---|---|---|
1 | 2025-03-31 00:00:00.000 | RON | 0.6947805 |
2 | 2025-03-30 00:00:00.000 | RON | 0.7110025 |
3 | 2025-03-29 00:00:00.000 | RON | 0.7168540417 |
4 | 2025-03-28 00:00:00.000 | RON | 0.7480625833 |
5 | 2025-03-27 00:00:00.000 | RON | 0.7835083333 |
6 | 2025-03-26 00:00:00.000 | RON | 0.803804 |
7 | 2025-03-25 00:00:00.000 | RON | 0.8042207917 |
8 | 2025-03-24 00:00:00.000 | RON | 0.8041130833 |
9 | 2025-03-23 00:00:00.000 | RON | 0.7841539167 |
10 | 2025-03-22 00:00:00.000 | RON | 0.777812875 |
11 | 2025-03-21 00:00:00.000 | RON | 0.7703435 |
12 | 2025-03-20 00:00:00.000 | RON | 0.78529525 |
13 | 2025-03-19 00:00:00.000 | RON | 0.7958287917 |
14 | 2025-03-18 00:00:00.000 | RON | 0.7808751667 |
15 | 2025-03-17 00:00:00.000 | RON | 0.7960532917 |
16 | 2025-03-16 00:00:00.000 | RON | 0.7928660833 |
17 | 2025-03-15 00:00:00.000 | RON | 0.830083625 |
18 | 2025-03-14 00:00:00.000 | RON | 0.83215975 |
19 | 2025-03-13 00:00:00.000 | RON | 0.8112282083 |
20 | 2025-03-12 00:00:00.000 | RON | 0.7843574167 |
permaryRon token price
Updated 2025-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
DATE_TRUNC('day', hour) AS day, -- Group by day
symbol,
AVG(price) AS daily_avg_price -- Calculate daily average price
FROM
ronin.price.ez_prices_hourly
WHERE
symbol = 'RON'
AND is_native = 'yes'
AND hour >= '2025-01-01'
AND hour < '2025-04-01' -- Use `<` to exclude April 1st
GROUP BY
day, symbol -- Group by day and symbol
ORDER BY
day DESC; -- Order chronologically
Last run: 25 days ago
90
4KB
1s