kasadeghThe most profitable NFTs
    Updated 2022-07-16
    with buyers as (
    select
    events.TO_ADDRESS as buyer,
    l.LABEL as nft
    , sum(AMOUNT_USD) as AMOUNT_USD

    from flipside_prod_db.polygon.udm_events as events
    join flipside_prod_db.polygon.labels as l
    on events.contract_address = l.address
    where LABEL_TYPE like '%nft%' and AMOUNT_USD is not null
    group by buyer,nft
    )
    ,
    sellers as (
    select
    events.FROM_ADDRESS as seller
    , l.LABEL as nft
    , sum(AMOUNT_USD) as AMOUNT_USD

    from flipside_prod_db.polygon.udm_events as events
    join flipside_prod_db.polygon.labels as l
    on events.contract_address = l.address
    where LABEL_TYPE like '%nft%' and AMOUNT_USD is not null
    group by seller,nft
    )

    select sellers.nft, sum(sellers.AMOUNT_USD-buyers.AMOUNT_USD) as total_profits
    from buyers join sellers
    on sellers.seller=buyers.buyer
    where sellers.seller!='0x0000000000000000000000000000000000000000'
    group by 1
    order by 2 desc
    limit 20
    Run a query to Download Data