select block_hour::date as day,

avg (price_usd) as usdprice

from algorand.core.ez_price_pool_balances

where asset_id = '0'

group by 1)

select 'wallet: '|| tx_sender,

coalesce(address_name,tx_sender) as Wallet_Label,

sum (fee) as Gas,

sum (fee*usdprice) as USD_Gas,

avg (fee*usdprice) as Average_USD_Gas

from algorand.core.fact_transaction t1 join algopricet t2 on t1.block_timestamp::Date = t2.DAY

full outer join algorand.core.dim_label t3 on t1.tx_sender = t3.address

where block_timestamp >= CURRENT_DATE - 30

group by 1,2

order by Gas DESC

limit 10