Updated 2024-10-18
    SELECT
    count(DISTINCT tx_id) as swaps,
    count(DISTINCT swapper) as swappers,
    sum(CASE when SWAP_FROM_MINT = 'CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump' then SWAP_FROM_AMOUNT else SWAP_TO_AMOUNT end) as Goat_volume

    FROM solana.defi.fact_swaps
    WHERE SWAP_FROM_MINT = 'CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump'
    OR SWAP_TO_MINT = 'CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump'
    QueryRunArchived: QueryRun has been archived