Flipside Team2024 Prices
Updated 2025-04-28
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_prices_hourly
where
hour::date between ('2024-04-20'::date - 30) and ('2024-04-20'::date + 30)
group by
"Date"
order by
"Date"
QueryRunArchived: QueryRun has been archived