select date(hour) as date, avg(price ) as price

from ethereum.core.fact_hourly_token_prices

where date(hour) >= '2022-01-01' and symbol = 'WETH'

group by 1)

select date, case

when price >= 1122 then 'higher than now'

else 'lower than now' end as high_or_low_now, count(*) as count

from ethereum.core.ez_eth_transfers, eth_price

where eth_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and block_timestamp::date = date

group by 1, 2