signers[0] as user,

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

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

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 user

order by fee_usd desc

limit 10