select

hour as hours ,

avg(price) as price

from ethereum.core.fact_hourly_token_prices

where token_address ='0xd31a59c85ae9d8edefec411d448f90841571b89c'

and hour::date >= '2022-05-01'

group by hours

)

, tx as (

select count(DISTINCT TX_ID) as txs , count(DISTINCT TX_FROM) as senders , date_trunc(hour, BLOCK_TIMESTAMP) as hours ,

sum(AMOUNT) as sol

from solana.core.fact_transfers

where

MINT = 'So11111111111111111111111111111111111111112' and BLOCK_TIMESTAMP::date >= '2022-05-01'

group by hours

select a.* , b.price from tx a LEFT JOIN sol_price b on a.hours = b.hours