greyswanNFT users cohorts
    Updated 2023-03-10
    with
    unique_NFT_users as (
    select distinct
    date_trunc('month', block_timestamp) as NFT_month,
    seller as seller_purchaser
    from
    solana.core.fact_nft_sales
    where
    block_timestamp >= '2022-03-01'
    and block_timestamp <= '2023-02-28'
    UNION
    select distinct
    date_trunc('month', block_timestamp) as NFT_month,
    purchaser
    from
    solana.core.fact_nft_sales
    where
    block_timestamp >= '2022-03-01'
    and block_timestamp <= '2023-02-28'
    ),
    NFTs_with_cohorts as (
    select
    NFT_month,
    seller_purchaser,
    signer,
    date_trunc('month', FIRST_TX_DATE) as cohort_month
    from
    unique_NFT_users
    left join solana.core.ez_signers on seller_purchaser = signer
    )
    select
    NFT_month,
    cohort_month,
    count(seller_purchaser) as NFT_users
    from
    NFTs_with_cohorts
    Run a query to Download Data