DATE | PRICE | DAILY PRICE DIFF % | |
|---|---|---|---|
1 | 2025-03-26 00:00:00.000 | 0.003270032308 | 10.12 |
2 | 2025-03-25 00:00:00.000 | 0.002969530417 | 5.45 |
3 | 2025-03-24 00:00:00.000 | 0.002815975833 | 9.74 |
4 | 2025-03-23 00:00:00.000 | 0.002566082083 | 0.4 |
5 | 2025-03-22 00:00:00.000 | 0.002555931667 | 0.12 |
6 | 2025-03-21 00:00:00.000 | 0.0025529275 | -14.21 |
7 | 2025-03-20 00:00:00.000 | 0.002975905417 | 8.34 |
8 | 2025-03-19 00:00:00.000 | 0.002746802917 | 21.65 |
9 | 2025-03-18 00:00:00.000 | 0.0022580075 | -25.46 |
10 | 2025-03-17 00:00:00.000 | 0.00302926375 | -19.12 |
11 | 2025-03-16 00:00:00.000 | 0.003745309583 | -18.71 |
12 | 2025-03-15 00:00:00.000 | 0.004607280833 | -6.91 |
13 | 2025-03-14 00:00:00.000 | 0.004949444583 | -0.42 |
14 | 2025-03-13 00:00:00.000 | 0.0049704025 | 0.6 |
15 | 2025-03-12 00:00:00.000 | 0.004940738333 | 5.94 |
16 | 2025-03-11 00:00:00.000 | 0.004663674583 | -21.24 |
17 | 2025-03-10 00:00:00.000 | 0.005921362917 | -20.62 |
18 | 2025-03-09 00:00:00.000 | 0.007459884583 | 5.71 |
19 | 2025-03-08 00:00:00.000 | 0.007057263333 | -0.25 |
20 | 2025-03-07 00:00:00.000 | 0.007075035417 | -12.43 |
feyikemiPrice % diff
Updated 2025-03-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH tb1 AS (
SELECT
Date_trunc('day', HOUR) AS Date,
AVG(Price) AS Price
FROM ronin.price.ez_prices_hourly
WHERE Token_Address = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb' --Ronke address
GROUP BY 1
)
SELECT
Date,
Price,
ROUND(((price - LAG(price)over(ORDER BY date))/LAG(price)over(ORDER BY date))*100, 2) as "DAILY PRICE DIFF %"
FROM tb1
ORDER BY Date DESC
Last run: 2 months ago
33
2KB
1s