flipside

    The number of NFT buyers according to their number of months of buying NFTs (Ethereum blockchain)
    nsa2000The number of NFT buyers according to their number of months of buying NFTs (Ethereum blockchain)
    Updated 2022-12-19
    --credit to jackguy
    SELECT
    active_months,
    count(*) as users
    FROM (
    SELECT
    BUYER_ADDRESS,
    count(DISTINCT date_trunc('month', block_timestamp)) as active_months
    FROM ethereum.core.ez_nft_sales
    GROUP BY 1
    )
    GROUP BY 1
    Run a query to Download Data