name,

--symbol,

--count(distinct tx_hash) as Number_of_Transactions,

--count(distinct from_address) as Unique_Users,

sum(eth_value) as Total_eth_Volume

--sum(tx_fee) as Tx_Fee

FROM arbitrum.core.fact_transactions

JOIN arbitrum.core.dim_contracts

ON address = to_address

WHERE BLOCK_TIMESTAMP:: DATE >= CURRENT_DATE -7

AND name IS NOT NULL

GROUP BY 1

ORDER BY 2 DESC

LIMIT 10;