greyswanNFT marketplaces_users
    Updated 2023-06-04
    -- forked from NFT marketplaces_average @ https://flipsidecrypto.xyz/edit/queries/b780188e-814f-492d-bab6-5001d2745f9b
    with
    relevant_trades as (
    select
    date_trunc('month', block_timestamp) as NFT_month,
    date_trunc('week', block_timestamp) as NFT_week,
    purchaser,
    seller,
    sales_amount,
    CASE
    WHEN marketplace = 'Magic Eden' THEN 'ME'
    WHEN marketplace = 'magic eden v2' THEN 'ME'
    ELSE 'tensorswap'
    end as platform
    from
    solana.core.fact_nft_sales
    WHERE
    marketplace = 'Magic Eden'
    or marketplace = 'magic eden v2'
    or marketplace = 'tensorswap'
    and BLOCK_TIMESTAMP >= (
    CURRENT_DATE - interval ' {{param_no9B}} days'
    )
    AND succeeded = True
    ),
    unique_users_ME as (
    select distinct
    NFT_week,
    seller as user
    from
    relevant_trades
    where
    platform = 'ME'
    UNION
    select distinct
    NFT_week,
    Run a query to Download Data