yasmin4 copy
    Updated 2025-01-26
    SELECT
    CASE
    WHEN LOWER(contract_address) IN (
    '0x4b07f2d19028a7fb7bf5e9258f9666a9673da331',
    '0x5656c4972827e93e921bcfe6d60148720fce8b55',
    '0xe41572a814d660d13b97d5bd33fbb4850b85b421',
    '0x21faa90e0c1ca27c1896b96942b1459cce01cb46'
    ) THEN 'PunchSwap V2'
    WHEN LOWER(contract_address) = '0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e' THEN 'Wrapped Flow'
    WHEN LOWER(contract_address) = '0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52' THEN 'Bridged USDC (Celer)'
    WHEN LOWER(contract_address) = '0x4bd2a1649e5698f97a1ab0515ee407ebc8a3abe7' THEN 'GreenConChicken'
    WHEN LOWER(contract_address) = '0x995258cea49c25595cd94407fad9e99b81406a84' THEN 'Avocado'
    WHEN LOWER(contract_address) = '0x68eb683a393c8a1c816255b4fc4b89d73c52ad4b' THEN 'pump.flow'
    WHEN LOWER(contract_address) = '0xd8ad8ae8375aa31bff541e17dc4b4917014ebdaa' THEN 'BETA'
    WHEN LOWER(contract_address) = '0x1b97100ea1d7126c4d60027e231ea4cb25314bdb' THEN 'Ankr Staked FLOW EVM'
    ELSE LOWER(contract_address)
    END AS contract_name,
    COUNT(DISTINCT origin_from_address) AS user_count
    FROM flow.core_evm.fact_event_logs
    GROUP BY contract_name
    ORDER BY user_count DESC
    LIMIT 10;



    -- Wrapped Flow 0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e

    -- Bridged USDC (Celer) 0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52

    -- PunchSwap V2 0x4b07f2d19028a7fb7bf5e9258f9666a9673da331----

    -- GreenConChicken 0x4bd2a1649e5698f97a1ab0515ee407ebc8a3abe7

    -- Avocado 0x995258cea49c25595cd94407fad9e99b81406a84

    -- 0x68eb683a393C8a1C816255b4FC4B89d73C52AD4b
    Last run: 20 days ago
    CONTRACT_NAME
    USER_COUNT
    1
    Wrapped Flow1376
    2
    PunchSwap V21071
    3
    Bridged USDC (Celer)867
    4
    GreenConChicken506
    5
    Avocado425
    6
    0xfd734fa1970f2750a4e54e4f12c54e670fda80ba421
    7
    pump.flow403
    8
    BETA340
    9
    0x576be17f4dfa0e4964034e2e3dd29465b225b8d4211
    10
    Ankr Staked FLOW EVM211
    10
    276B
    1s