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

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

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

    select sellers.seller as user , (sellers.AMOUNT_USD-buyers.AMOUNT_USD) as total_profits
    from buyers join sellers
    on sellers.seller=buyers.buyer
    where user!='0x0000000000000000000000000000000000000000'
    order by 2 desc
    limit 20



    Run a query to Download Data