kaibladeTop 10 Token Transactions (Arbitrum)
    Updated 2022-07-03
    WITH top10_raw AS
    (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



    Run a query to Download Data