mattkstewTrader Strats 3
    Updated 2023-04-23


    with tab1 as (
    select
    block_timestamp,
    purchaser,
    mint,
    sales_amount as bought_amount
    from solana.core.fact_nft_sales
    )
    ,
    tab2 as (
    select
    block_timestamp,
    Seller,
    mint,
    sales_amount as sold_amount
    from solana.core.fact_nft_sales
    )
    ,
    tab3 as (
    select
    tab1.block_timestamp as date,
    purchaser,
    tab1.mint,
    sold_amount - bought_amount as net_profit
    from tab1 left outer join tab2 on
    purchaser = seller and tab1.mint = tab2.mint
    where bought_amount is not null
    and sold_amount is not null
    )
    ,
    Users as (
    Run a query to Download Data