SELECT

distinct ORIGIN_FROM_ADDRESS as unique_Users,

SUM(CASE WHEN SYMBOL_OUT = 'WETH' then AMOUNT_IN_USD END) as volume_BUY,

SUM(CASE WHEN SYMBOL_IN = 'WETH' then AMOUNT_IN_USD END) as volume_SELL

FROM

ethereum.core.ez_dex_swaps

WHERE

BLOCK_TIMESTAMP::date >= CURRENT_DATE - 14

AND

EVENT_NAME = 'Swap'

GROUP BY

1

ORDER BY

1