Blazepyth new wallets agg
    Updated 2024-02-11
    -- forked from jup new wallets agg @ https://flipsidecrypto.xyz/edit/queries/25b14102-01c0-465a-8f00-7c2197da0c75

    select count(*),
    avg(num_days_active),
    max(num_days_active),
    min(num_days_active),
    median(num_days_active) from solana.core.ez_signers
    where
    lower(first_program_id)= lower('EXxqB6XPLczReFcZyigfbdowB6WGYtnkLYC4XZ2ae9ch')



    Last run: about 1 year ago
    COUNT(*)
    AVG(NUM_DAYS_ACTIVE)
    MAX(NUM_DAYS_ACTIVE)
    MIN(NUM_DAYS_ACTIVE)
    MEDIAN(NUM_DAYS_ACTIVE)
    1
    138487.31614712813
    1
    26B
    1s