count(DISTINCT swapper) AS "Traders"

, SUM(CASE WHEN swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

THEN swap_from_amount_usd

ELSE swap_to_amount_usd

END)

AS "Volume"

, COUNT(DISTINCT tx_id) AS "Transactions"

, SUM(CASE WHEN swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' THEN swap_from_amount_usd ELSE 0 END) AS "Buy Volume"

, SUM(CASE WHEN swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' THEN swap_to_amount_usd ELSE 0 END) AS "Sell Volume"

FROM solana.defi.ez_dex_swaps

WHERE swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

OR swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'