SnehaPYTH new wallets
    Updated 2024-02-11
    SELECT
    count(signer) as num_wallets,
    CASE
    WHEN NUM_TXS<50 THEN '<50'
    WHEN NUM_TXS<500 THEN '50-500'
    ELSE '>500'
    END AS CATEGORY
    FROM
    solana.core.ez_signers
    WHERE
    LOWER(first_program_id) = LOWER('EXxqB6XPLczReFcZyigfbdowB6WGYtnkLYC4XZ2ae9ch')
    group by category
    Last run: over 1 year ago
    NUM_WALLETS
    CATEGORY
    1
    172>500
    2
    11384<50
    3
    229250-500
    3
    44B
    3s