(sum(fee/pow(10,9)) * avg(close))/count(distinct block_id) as Fee_per_block

from solana.core.fact_transactions inner join solana.core.fact_token_prices_hourly p

on RECORDED_HOUR::date = block_timestamp::date and hour(p.RECORDED_HOUR) = hour(block_timestamp)

where block_timestamp > CURRENT_DATE - 31

and symbol = 'SOL'

and succeeded = 'TRUE'