0xaimanMonthly NFT Sales and Unique Buyers
    Updated 2022-07-15
    with raw as( select * from (with s1 as (select block_timestamp, tx_id,contract_address, event_inputs:tokenId as token_id, event_inputs:from as NFT_seller ,event_inputs:to as nft_buyer from flipside_prod_db.polygon.events_emitted

    where event_name='Transfer' and event_inputs:tokenId is not null
    and event_removed='FALSE'),

    s2 as (

    select tx_id, event_inputs:takerAssetFilledAmount/10e17 as price_paid from flipside_prod_db.polygon.events_emitted

    where event_name='Fill' and event_inputs:makerFeeAssetData like '0%'
    )

    select block_timestamp as t, s1.tx_id,contract_address as NFT_ca, NFT_seller,NFT_buyer, token_id, price_paid
    from s1 inner join s2 on s1.tx_id=s2.tx_id
    )x inner join flipside_prod_db.polygon.labels as s
    on x.NFT_ca=s.address
    where s.LABEL_TYPE ='nft'
    ),

    asales as (select month, n_unique_buyer
    from (select date_trunc('month',t) as month, count(distinct NFT_buyer) as n_unique_buyer
    from raw
    group by 1)

    ),

    sales as (select date_trunc('month',t) as month, count(tx_id) as n_txn
    from raw
    group by 1)

    select sales.month , n_txn as n_nft_purchased,n_unique_buyer
    Run a query to Download Data