SELECT trunc(block_timestamp,'hour') AS date,

CASE WHEN token_in='0x600000000a36f3cd48407e35eb7c5c910dc1f7a8' THEN 'In Flow'

ELSE 'Out Flow' END AS direction,

COUNT(DISTINCT tx_hash) AS swaps,

COUNT(DISTINCT origin_from_address) AS users_count,

sum(CASE WHEN token_in='0x600000000a36f3cd48407e35eb7c5c910dc1f7a8' THEN amount_in

ELSE amount_out END) AS goo_volume

FROM ethereum.core.ez_dex_swaps

WHERE block_timestamp >= CURRENT_DATE - 90

AND (token_in='0x600000000a36f3cd48407e35eb7c5c910dc1f7a8' OR token_out = '0x600000000a36f3cd48407e35eb7c5c910dc1f7a8')

GROUP BY 1,2

SELECT * , CASE WHEN direction = 'In Flow' THEN goo_volume

WHEN direction = 'Out Flow' THEN goo_volume * -1 END AS "Net $Goo"

FROM base