MLDZMNXAR8
    Updated 2023-01-27

    select
    date_trunc('week',first_transaction_stamp) as date,
    count (distinct sender) as new_users
    from (
    select
    distinct purchaser as sender,
    min(block_timestamp) as first_transaction_stamp
    from solana.core.fact_nft_sales
    where SUCCEEDED='TRUE'
    and MARKETPLACE ='exchange art'
    and SALES_AMOUNT>0
    group by 1
    )
    group by 1


    Run a query to Download Data