marquSol Perps - [all] common users
    Updated 2025-01-21
    with

    d2_users as (

    select distinct signers[0] as wallet_address
    from solana.core.fact_events events
    where succeeded
    and program_id = 'dRiftyHA39MWEi3m9aunc5MzRF1JYuBsbn6VPcn33UH'
    and block_timestamp >= '2023-01-01' ::date
    ),

    zeta_users as (

    select distinct signers[0] as wallet_address
    from solana.core.fact_events events
    where succeeded
    and program_id = 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD'
    and block_timestamp >= '2023-01-01' ::date
    ),

    user_list as (

    select

    wallet_address,
    case
    when d2_users.wallet_address is null then 'Zeta Markets'
    when zeta_users.wallet_address is null then 'Drift V2'
    else 'Common Users'
    end as label

    from d2_users
    full outer join zeta_users
    using(wallet_address)
    )

    Last run: about 1 month ago
    X
    LABEL
    USERS
    TOTAL
    PCT
    1
    Zeta Markets7503228661326.1789
    2
    Drift V216209728661356.5561
    3
    Common Users4948428661317.2651
    3
    121B
    70s