gigiokobaPOPCAT Swap by DEX - Total copy
    Updated 2024-07-28
    -- forked from Ario / POPCAT Swap by DEX - Total @ https://flipsidecrypto.xyz/Ario/q/-JCHHISax1Uh/popcat-swap-by-dex---total

    select
    count(DISTINCT tx_id) as N_Swap,
    count(DISTINCT SWAPPER) as N_Swapper,
    sum(SWAP_From_AMOUNT_usd) as Swap_POPCAT_Amount
    from solana.defi.ez_dex_swaps
    where (SWAP_from_MINT = 'HnKkzR1YtFbUUxM6g3iVRS2RY68KHhGV7bNdfF1GCsJB' or
    SWAP_to_MINT = 'HnKkzR1YtFbUUxM6g3iVRS2RY68KHhGV7bNdfF1GCsJB')


    QueryRunArchived: QueryRun has been archived