greyswan2024-03-22 01:18 PM
    Updated 2024-03-22
    select
    date_trunc('month', first_tx_date) as first_month,
    count (distinct a.signers[0]) as number_of_users
    from
    solana.core.fact_events a
    left join solana.core.ez_signers b on a.signers [0] = b.signer
    where
    program_id = 'PERPHjGBqRHArX4DySjwM6UJHiR3sWAatqfdBS2qQJu'
    and BLOCK_TIMESTAMP >= current_date - 180
    group by date_trunc('month', first_tx_date)
    order by count (distinct a.signers[0]) desc





    QueryRunArchived: QueryRun has been archived