(SELECT contract_address,

COUNT(tx_hash) as transactions

FROM arbitrum.core.fact_token_transfers

WHERE block_timestamp >= CURRENT_DATE - INTERVAL '1 week'

GROUP BY contract_address

ORDER BY transactions DESC

LIMIT 10)

SELECT tokens.contract_address, labels.address_name,

(CASE

WHEN labels.address_name = 'hop protocol: eth l2canonicaltoken' THEN 'Wrapped Ether (WETH)'

WHEN labels.address_name = 'hop protocol: eth l2hopbridgetoken' THEN 'ETH Hop Token (hETH)'

WHEN labels.address_name = 'hop protocol: usdc l2canonicaltoken' THEN 'USD Coin (Arb1) (USDC)'

WHEN labels.address_name = 'treasure dao: magic token' THEN 'Magic Token (MAGIC)'

WHEN labels.address_name = 'hop protocol: usdt l2canonicaltoken' THEN 'Tether USD (USDT)'

WHEN labels.address_name = 'hop protocol: dai l2canonicaltoken' THEN 'Dai Stablecoin (DAI)'

WHEN labels.address_name = 'hop protocol: usdc l2hopbridgetoken' THEN 'USD Coin Hop Token (hUSDC)'

WHEN tokens.contract_address = '0x4e971a87900b931ff39d1aad67697f49835400b6' THEN 'Fee GLP (fGLP)'

WHEN tokens.contract_address = '0x4277f8f2c384827b5273592ff7cebd9f2c1ac258' THEN 'GMX LP (GLP)'

WHEN tokens.contract_address = '0x45096e7aa921f27590f8f19e457794eb09678141' THEN 'USD Gambit (USDG)'

END

) AS token_name,

labels.project_name,

tokens.transactions

FROM top10_raw tokens

LEFT JOIN arbitrum.core.dim_labels labels

ON tokens.contract_address = labels.address

ORDER BY tokens.transactions DESC