nsa2000Number of NFT buyers per month
    Updated 2022-12-18
    -- credit to Ali3N
    with flowtable1 as (
    select buyer,
    tx_id,
    block_timestamp::date as date,
    row_number () over (partition by buyer order by block_timestamp) as RN
    from flow.core.ez_nft_sales
    where block_timestamp >= '2022-01-01'),
    flowtable2 as (
    select buyer,
    tx_id,
    block_timestamp::date as date,
    row_number () over (partition by buyer order by block_timestamp) as RN
    from flow.core.ez_nft_sales
    where block_timestamp >= '2022-01-01'),

    ethtable1 as (
    select buyer_address,
    tx_hash,
    block_timestamp::date as date,
    row_number () over (partition by buyer_address order by block_timestamp) as RN
    from ethereum.core.ez_nft_sales
    where block_timestamp >= '2022-01-01'),
    ethtable2 as (
    select buyer_address,
    tx_hash,
    block_timestamp::date as date,
    row_number () over (partition by buyer_address order by block_timestamp) as RN
    from ethereum.core.ez_nft_sales
    where block_timestamp >= '2022-01-01'),

    solanatable1 as (
    select purchaser,
    tx_id,
    Run a query to Download Data