contracts as (

select

b.address

, c.label_type

from arbitrum.core.dim_contracts b inner join arbitrum.core.dim_labels c

on b.address = c.address

where

label_type in (

'dapp'

, 'games'

, 'dex'

, 'bridge'

, 'defi'

, 'nft'

, 'token'

)

group by 1,2

, top_fees as (

select

tx_hash

, tx_fee * price / 100 as fee

from arbitrum.core.fact_transactions tx

left join ethereum.price.ez_prices_hourly p

on date_trunc('hour', tx.block_timestamp) = p.hour and p.symbol = 'WETH'

where status = 'SUCCESS'

and block_timestamp >= '2024-11-01' and block_timestamp < '2024-12-01'

order by fee DESC

limit 100