-- 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')