Updated 2022-09-18
    WITH


    a as
    (select
    BLOCK_TIMESTAMP,
    TX_HASH ,
    SELLER_ADDRESS as seller ,
    BUYER_ADDRESS as buyer ,
    NFT_ADDRESS as CONTRACT_ADDRESS,
    TOKENID as token_id ,
    CURRENCY_SYMBOL ,
    PRICE as volume
    from optimism.core.ez_nft_sales
    where EVENT_TYPE='sale' and PLATFORM_NAME =('quixotic') ),
    b as
    (select
    BLOCK_TIMESTAMP,
    TX_HASH ,
    SELLER_ADDRESS as seller ,
    BUYER_ADDRESS as buyer ,
    NFT_ADDRESS as CONTRACT_ADDRESS,
    TOKENID as token_id ,
    CURRENCY_SYMBOL ,
    PRICE as volume
    from optimism.core.ez_nft_sales
    where EVENT_TYPE='sale' and PLATFORM_NAME =('quixotic') ),
    c as (
    select t1.buyer,
    sum (t2.volume - t1.volume) as ETH_Profit
    from a t1 join b t2 on t1.buyer = t2.seller
    group by 1
    order by 2 DESC
    )
    Run a query to Download Data