ChiefBottom Collections
    Updated 2023-02-04
    with tab1 as (
    select
    -- block_timestamp,
    tx_id,
    purchaser,
    mint,
    sales_amount as bought_amount

    from solana.core.fact_nft_sales
    WHERE block_timestamp > CURRENT_DATE - 30
    AND succeeded = True
    -- GROUP BY purchaser, mint
    )
    ,
    tab2 as (
    select
    -- block_timestamp,
    Seller,
    tx_id,
    md.mint,
    contract_name,
    sales_amount as sold_amount

    from solana.core.fact_nft_sales as sales
    JOIN (select mint, contract_name, contract_address from solana.core.dim_nft_metadata) as md
    ON sales.mint = md.mint
    WHERE block_timestamp > CURRENT_DATE - 30
    AND succeeded = True
    -- GROUP BY seller, mint
    )

    , tab3 as (
    select purchaser as traders,
    sold_amount - bought_amount as net_profit

    from tab1 left outer join tab2 on
    Run a query to Download Data