Eman-RazAverage % of Price Changes on Weekdays
Updated 2024-07-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
WITH PRICE_CHANGE AS (with tab1 as (SELECT hour::date as date, price as open_price
from blast.price.ez_prices_hourly
where token_address='0x5ffd9ebd27f2fcab044c0f0a26a45cb62fa29c06'
and HOUR ilike '%00:00:00.000'
ORDER BY 1),
tab2 as (SELECT hour::date as date, price as close_price
from blast.price.ez_prices_hourly
where token_address='0x5ffd9ebd27f2fcab044c0f0a26a45cb62fa29c06'
and HOUR ilike '%23:00:00.000'
ORDER BY 1)
select tab1.date as "Date", ((close_price-open_price)/open_price)*100 as "%Price Change"
from tab1 left join tab2 on tab1.date=tab2.date
order by 1)
SELECT
CASE DAYOFWEEK("Date")
WHEN 0 THEN 'Sunday'
WHEN 1 THEN 'Monday'
WHEN 2 THEN 'Tuesday'
WHEN 3 THEN 'Wednesday'
WHEN 4 THEN 'Thursday'
WHEN 5 THEN 'Friday'
WHEN 6 THEN 'Saturday'
END AS "Day of Week",
AVG("%Price Change") AS "Average"
FROM
PRICE_CHANGE
GROUP BY 1
ORDER BY 1
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived