greyswanNFT users weekly
    Updated 2023-07-13
    with
    unique_NFT_users as (
    select distinct
    date_trunc('week', block_timestamp) as NFT_week,
    seller as seller_purchaser
    from
    solana.core.fact_nft_sales
    where
    block_timestamp >= '2022-03-01'
    AND BLOCK_TIMESTAMP < CURRENT_DATE
    UNION
    select distinct
    date_trunc('week', block_timestamp) as NFT_week,
    purchaser
    from
    solana.core.fact_nft_sales
    where
    block_timestamp >= '2022-03-01'
    AND BLOCK_TIMESTAMP < CURRENT_DATE
    ),
    NFTs_with_cohorts as (
    select
    NFT_week,
    seller_purchaser,
    signer,
    date_trunc('week', FIRST_TX_DATE) as cohort_week
    from
    unique_NFT_users
    left join solana.core.ez_signers on seller_purchaser = signer
    )
    select
    NFT_week,
    cohort_week,
    count(seller_purchaser) as NFT_users_cohort
    from
    NFTs_with_cohorts
    Run a query to Download Data