ChiefSWAPS
    Updated 2023-05-26
    -- forked from Sales @ https://flipsidecrypto.xyz/edit/queries/92c1ce56-5f20-4c02-9363-a4673c42d306

    -- program_id = E1XRkj9fPF2NQUdoq41AHPqwMDHykYfn5PzBXAyDs7Be
    -- this tx went through but had an "error" for part of it tx_id = 2GNs1XJqHEtj4Yn5oWQAdk56ySskEmx6rECtZ8AF38u5eUo3kjjPr8m3AGC1tsRbFNgSxcrLQe4MnXFtTYtLLJJ4
    -- this could be the ovals royalty address ovo1kT7RqrAZwFtgSGEgNfa7nHjeZoK6ykg1GknJEXG

    -- with events as (
    -- SELECT tx_id
    -- -- ,
    -- -- instruction:programId as program_id
    -- FROM solana.core.fact_events
    -- -- FROM solana.core.fact_transactions
    -- WHERE program_id = 'E1XRkj9fPF2NQUdoq41AHPqwMDHykYfn5PzBXAyDs7Be'
    -- AND block_timestamp > current_date - 2
    -- LIMIT 50
    -- )

    with swaps as
    (SELECT *
    FROM solana.core.fact_swaps s
    -- JOIN events
    -- ON s.tx_id = events.tx_id
    WHERE s.block_timestamp > current_date - 2
    AND swap_to_mint = 'DjzG1gPn2cotdV9cvkho4KxD3Poy2VjJeghCivv8U8Wj'
    or swap_from_mint = 'DjzG1gPn2cotdV9cvkho4KxD3Poy2VjJeghCivv8U8Wj'
    ORDER BY s.tx_id
    LIMIT 20)

    SELECT *
    FROM swaps
    JOIN solana.core.fact_events e
    ON e.tx_id = swaps.tx_id
    WHERE e.block_timestamp > current_date - 2



    Run a query to Download Data