with tab1 as (select date_trunc('hour',block_timestamp) as hour, sum(tx_fee) as hourly_fee, from_address as tx_sender
from arbitrum.core.fact_transactions
where block_timestamp::date>=current_date-30 and block_timestamp::date<>current_date
group by 1,3
order by 1),
tab2 as (select hour, price
from ethereum.core.fact_hourly_token_prices
where hour::date>=current_date-30 and hour::date<>CURRENT_DATE and symbol='WETH'
order by 1)
select tx_sender, sum(hourly_fee*price) as "Total Fee Paid ($USD)", sum(hourly_fee) as "Total Fee Paid ($ETH)"
from tab1 left join tab2 on tab1.hour=tab2.HOUR
group by 1
order by 2 desc
limit 10