headitmanagerEthereum price in 2022
    Updated 2022-06-27
    with algo_price as (select price_usd,block_hour::date from algorand.prices_swap
    where asset_id=0 and hour(block_hour)=0 and block_hour::date>'2022-01-01')
    , eth_price as (select price,hour from ethereum_core.fact_hourly_token_prices
    where token_address is null and hour(hour)=0 and hour::date>'2022-01-01')
    , algo_transactions as (select count(*), block_timestamp::date from algorand.transactions
    where block_timestamp::date>'2022-01-01'
    group by block_timestamp::date )
    , algo_transfer as (select count(*), block_timestamp::date from algorand.transfers
    where block_timestamp::date>'2022-01-01'
    group by block_timestamp::date )
    select * from eth_price