StangFASTmint - part 1
    Updated 2023-12-11
    SELECT
    date_trunc( 'day' , a.block_timestamp ) AS "date"

    , count( distinct a.instruction:"accounts"[1] ) AS "users"
    , count( distinct a.tx_id ) AS "transactions"

    , sum( "users" ) over ( ORDER BY "date" ASC ) AS "total users"
    , sum( "transactions" ) over ( ORDER BY "date" ASC ) AS "total transactions"
    FROM
    solana.core.ez_events_decoded a
    JOIN
    lateral flatten ( input => a.decoded_instruction ) b
    WHERE
    "date" >= '2023-02-01'
    AND "date" <= dateadd( 'day' , -1 , current_date )
    AND a.program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
    AND a.succeeded = 'true'
    AND a.signers[0] = '7TUxaYgxGqRdmgtddPFjfyD5RHSrfGRinGktevEtMRny'
    AND b.value = 'mintToCollectionV1'
    GROUP BY 1
    ORDER BY 1 DESC
    Run a query to Download Data