count(DISTINCT tx_hash) as swaps,

sum(CASE WHEN symbol_out like 'GOO' THEN AMOUNT_IN_USD ELSE AMOUNT_OUT_USD END) as volume

FROM ethereum.core.ez_dex_swaps

WHERE (symbol_out like 'GOO'

OR symbol_in like 'GOO')

AND block_timestamp > CURRENT_DATE - 14