select date_trunc('day', hour) as date,

avg(price) as price

from ethereum.token_prices_hourly

where token_address = lower ('0xD31a59c85aE9D8edEFeC411D448f90841571b89c')

and date_trunc('day', hour) >= '2021-10-08'

group by 1),

transfers_ as (

select block_timestamp::date as date,

sum(Amount) as volume

from solana.core.fact_transfers

where block_timestamp::date >= '2021-10-08'

and mint ='So11111111111111111111111111111111111111112'

group by 1

)

select date , price , volume

from sol_price join transfers_ using (date)

group by 1,2,3