from ethereum.core.fact_hourly_token_prices

where symbol='WETH'

group by 1

order by 1),

tab2 as (select date_trunc('day',block_timestamp) as day, sum(amount) as eth_vol, count(distinct eth_from_address) as staker_count,

count(tx_hash) as stake_count, sum(amount_usd) as eth_vol_usd

from ethereum.core.ez_eth_transfers

where eth_to_address='0x84db6ee82b7cf3b47e8f19270abde5718b936670' -- Ankr

or eth_to_address='0x39dc6a99209b5e6b81dc8540c86ff10981ebda29' --staked.us

or eth_to_address='0x0194512e77d798e4871973d9cb9d7ddfc0ffd801' --stakefish

group by 1

order by 1)

select tab1.day as date, avg_price, eth_vol, staker_count, stake_count, eth_vol_usd

from tab1 full outer join tab2 on tab1.day=tab2.DAY

where date>'2020-11-09'

order by 1