select

HOUR::date as date,

avg(Price) as SOL_PRICE_USD

from

ethereum.core.fact_hourly_token_prices

where

token_address = lower('0xD31a59c85aE9D8edEFeC411D448f90841571b89c')

AND

Price is not null

and

date >= '2021-10-07'

group by date

),

N_TRXs as (

select

BLOCK_TIMESTAMP::date as date,

count(tx_id) as Number_of_transactions

from

solana.core.fact_transactions

where

date >= '2021-10-07'

group by date

),

Sol_Volume_transferred as (

select

BLOCK_TIMESTAMP::date as date,

sum(amount) as Sol_Volume

from

solana.core.fact_transfers

where

MINT = 'So11111111111111111111111111111111111111112'

and

date >= '2021-10-07'

group by date

)