feyikemiDaily Change
Updated 2024-10-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH NEAR_Price AS (
SELECT
Date_trunc('day', HOUR) AS Date,
MEDIAN(Price) AS Price
FROM near.price.ez_prices_hourly
WHERE SYMBOL ilike 'NEAR'
GROUP BY 1
)
SELECT
Date,
Price,
((price - LAG(price)over(ORDER BY date))/LAG(price)over(ORDER BY date))*100 as daily_change
FROM NEAR_Price
ORDER BY Date DESC
QueryRunArchived: QueryRun has been archived