alitaslimi2024 Halving Prices
Updated 2024-04-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
hour::date as "Date",
case
when hour::date < '2024-04-20' then 'Pre-Halving'
when hour::date = '2024-04-20' then 'Halving'
when hour::date > '2024-04-20' then 'Post-Halving'
end as "Period",
avg(price) as "Price"
from
bitcoin.price.ez_hourly_token_prices
where
hour::date between ('2024-04-20'::date - 14) and ('2024-04-20'::date + 14)
group by
"Date"
order by
"Date"
QueryRunArchived: QueryRun has been archived