gokcinactive nft purchasers
    Updated 2022-12-19
    select 'FLOW' as chain,
    date_trunc('month',block_timestamp) as date,
    count (distinct BUYER) as users
    from flow.core.ez_nft_sales
    where date >= '2022-01-01'
    group by 1,2

    union all
    select 'Solana' as chain,
    date_trunc('month',block_timestamp) as date,
    count (distinct PURCHASER) as users
    from solana.core.fact_nft_sales
    where date >= '2022-01-01'
    group by 1,2
    union all

    select 'Ethereum' as chain,
    date_trunc('month',block_timestamp) as date,
    count (distinct BUYER_ADDRESS) as users
    from ethereum.core.ez_nft_sales
    where date >= '2022-01-01'
    group by 1,2

    Run a query to Download Data