StangFAST005 - serum - min
    Updated 2023-10-26
    with

    min AS
    (
    SELECT
    min( a.block_timestamp ) AS "date"
    , a.signers[0] AS "swapper"

    FROM
    solana.core.fact_events a

    JOIN
    solana.core.fact_transfers c
    using ( block_timestamp , tx_id )

    WHERE
    a.block_timestamp::date >= '2023-02-01'
    AND a.block_timestamp::date <= dateadd ( 'week' , -1 , current_date )
    AND a.signers[0] = c.tx_to
    AND a.succeeded = 'true'
    AND a.program_id in (
    '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin'
    , '22Y43yTVxuUkoRKdm9thyRhQ3SdgQS7c7kB6UNCiaczD'
    )

    GROUP BY 2
    ORDER BY 1 DESC
    )
    SELECT
    date_trunc( 'week' , a."date" ) AS "date"
    , count( distinct a."swapper" ) AS "swapper"

    FROM
    min a

    GROUP BY 1
    Run a query to Download Data