2844made the most profit
    Updated 2022-07-14
    WITH T1 AS (
    select DISTINCT(to_address) AS WALLET, SUM(AMOUNT_USD) AS "SELL"
    from flipside_prod_db.polygon.events_emitted e
    inner JOIN flipside_prod_db.polygon.udm_events u on u.TX_ID=e.TX_ID
    where
    TX_TO_LABEL_TYPE = 'nft'
    and u.FROM_ADDRESS is not NULL
    and u.to_address is not null
    and u.TO_LABEL_TYPE is null
    and u.EVENT_TYPE = 'erc20_transfer'
    and u.FROM_LABEL_TYPE is NULL
    AND AMOUNT_USD IS NOT NULL
    GROUP BY 1
    ),
    T2 AS (
    select DISTINCT(FROM_address) AS WALLETS, SUM(AMOUNT_USD) AS "BUY"
    from flipside_prod_db.polygon.events_emitted e
    inner JOIN flipside_prod_db.polygon.udm_events u on u.TX_ID=e.TX_ID
    where
    TX_TO_LABEL_TYPE = 'nft'
    and u.FROM_ADDRESS is not NULL
    and u.to_address is not null
    and u.TO_LABEL_TYPE is null
    and u.EVENT_TYPE = 'erc20_transfer'
    and u.FROM_LABEL_TYPE is NULL
    AND AMOUNT_USD IS NOT NULL
    GROUP BY 1
    )
    SELECT DISTINCT WALLET, "SELL" ,"BUY" ,("SELL")-("BUY") AS PROFIT
    FROM T1 INNER JOIN T2 ON WALLET=WALLETS
    ORDER BY 4 DESC
    LIMIT 5
    Run a query to Download Data