select

date_trunc('day', hour) as day,

avg(price) as price

from ethereum.core.fact_hourly_token_prices

where token_address is null

group by 1

select

from_address,

address_name,

concat(from_address, ' - ', iff(address_name is not null, address_name, '')),

avg(price) * sum(tx_fee) as fee_usd

from arbitrum.core.fact_transactions join token_price on block_timestamp::date = day left join arbitrum.core.dim_labels on from_address = address

where block_timestamp::date >= current_date - 30 and block_timestamp::date < current_date

group by 1, 2, 3

order by 4 desc

limit 10