block_timestamp::date as day,

sum(fee/pow(10,9)) as Fee_Sol,

(sum(fee/pow(10,9)) * avg(close)) as Fee_in_usd,

avg(close) as sol_price

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'

group by day