aaronr3genvulnerable-magenta
    Updated 2025-02-17
    WITH wallet_addresses AS (
    SELECT 'Enzyme Operations Account' as wallet_name, '0xfc60416885f38adb121c6bd090d94cf9f0448f53' as address
    UNION ALL
    SELECT 'Treasury Wallet', '0xfECA27229A3801b34591582B66C46c82a9bC9994'
    )

    SELECT
    w.wallet_name,
    w.address,
    COUNT(cb.user_address) as number_of_tokens,
    MIN(cb.last_activity_block_timestamp) as earliest_activity,
    MAX(cb.last_activity_block_timestamp) as latest_activity
    FROM wallet_addresses w
    LEFT JOIN ethereum.core.ez_current_balances cb
    ON LOWER(w.address) = LOWER(cb.user_address)
    WHERE cb.current_bal > 0
    GROUP BY 1,2;
    QueryRunArchived: QueryRun has been archived