MLDZMNsolt2 copy
    Updated 2023-08-22
    -- forked from solt2 @ https://flipsidecrypto.xyz/edit/queries/89281c87-5766-4172-985c-ff4339b1066e

    select
    date_trunc('day', first_transaction_stamp) as date,
    SWAP_PROGRAM,
    count (distinct sender) as new_users
    from (
    select
    distinct swapper as sender,
    SWAP_PROGRAM,
    min(block_timestamp) as first_transaction_stamp
    from solana.core.fact_swaps
    where block_timestamp>='2023-08-01'
    and SUCCEEDED = 'TRUE'
    and (SWAP_TO_MINT = '31k88G5Mq7ptbRDf3AM13HAq6wRQHXHikR8hik7wPygk' or SWAP_FROM_MINT = '31k88G5Mq7ptbRDf3AM13HAq6wRQHXHikR8hik7wPygk')
    group by 1,2
    )
    group by 1,2


    Run a query to Download Data