Ali3NETH vs AVAX vs BNB vs OP vs OP Price During Holiday 2022-2023
Updated 2023-01-07
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
33
34
35
36
›
⌄
with ethpricet as (
select hour::date as day,
case when day >= '2022-12-24' and day < '2023-01-04' then 'Holidays'
else 'Other Days' end as timespan,
avg (price) as USDPrice
from ethereum.core.fact_hourly_token_prices
where symbol = 'WETH'
and hour::date >= '2022-12-17'
group by 1,2),
avaxpricet as (
select hour::date as day,
case when day >= '2022-12-24' and day < '2023-01-04' then 'Holidays'
else 'Other Days' end as timespan,
avg (price) as USDPrice
from ethereum.core.fact_hourly_token_prices
where symbol = 'WAVAX'
and hour::date >= '2022-12-17'
group by 1,2),
bnbpricet as (
select hour::date as day,
case when day >= '2022-12-24' and day < '2023-01-04' then 'Holidays'
else 'Other Days' end as timespan,
avg (price) as USDPrice
from ethereum.core.fact_hourly_token_prices
where symbol = 'WBNB'
and hour::date >= '2022-12-17'
group by 1,2),
oppricet as (
select hour::date as day,
case when day >= '2022-12-24' and day < '2023-01-04' then 'Holidays'
else 'Other Days' end as timespan,
avg (price) as USDPrice
from Optimism.core.fact_hourly_token_prices
Run a query to Download Data