eslamis-darkatprice3
Updated 2022-09-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with before_merge as (select date_trunc('hour', HOUR) as date, avg(price) as price
from ethereum.core.fact_hourly_token_prices
where symbol = 'WETH' AND date>='2022-09-8' And date<='2022-09-15 07:00:00.000'
GROUP BY 1)
,
after_merge as (select date_trunc('hour', HOUR) as date,avg(price) as price
from ethereum.core.fact_hourly_token_prices
where symbol = 'WETH' AND date>'2022-09-15 07:00:00.000' And date<='2022-09-21'
GROUP BY 1)
SELECT avg(price),'before_merge' as time
FROM before_merge
UNION
SELECT avg(price),'after_merge' as time
FROM after_merge
Run a query to Download Data