BLOCK_TIMESTAMP::date as timestamps,

SUM(CASE WHEN TOKEN_OUT_CONTRACT = '0x5c147e74D63B1D31AA3Fd78Eb229B65161983B2b' then TOKEN_IN_AMOUNT END) as volume_BUY,

SUM(CASE WHEN TOKEN_IN_CONTRACT = '0x5c147e74D63B1D31AA3Fd78Eb229B65161983B2b' then TOKEN_IN_AMOUNT*-1 END) as volume_SELL,

volume_BUY + volume_SELL as net_Volume

FROM

flow.core.ez_swaps

WHERE

timestamps >= CURRENT_DATE - 14

GROUP BY

1

ORDER BY

1