pavlyshynEversol users by day
    Updated 2022-08-10

    select
    a.BLOCK_TIMESTAMP::date as date,
    count(distinct (signers[0])) as wallets
    FROM solana.core.fact_events a
    join solana.core.fact_transactions b
    on a.tx_id = b.tx_id
    where a.PROGRAM_ID = 'EverSFw9uN5t1V8kS3ficHUcKffSjwpGzUSGd7mgmSks'
    and a.BLOCK_TIMESTAMP >='2022-01-01'
    and a.succeeded = True
    group by 1
    order by 1




    Run a query to Download Data