adambalaHODL or Sell?
Updated 2022-06-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with
aa as (
SELECT
date_trunc('day',hour) as date,
avg(price) as prices,
case
WHEN date <'2021-01-01' or date between '2021-05-01' and '2022-02-01' THEN 'this time' else 'normal time '
end as ethtoken
FROM ethereum_core.fact_hourly_token_prices
WHERE lower(token_address) =lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2')
GROUP BY 1,3)
select * from aa