date_trunc('day',block_timestamp) as day,

-- block_timestamp,

-- tx_id,

pool_name,

SUM(CASE WHEN direction = 'OUT' THEN amount_usd ELSE 0 END) as swapto_volume,

SUM(CASE WHEN direction = 'IN' THEN amount_usd ELSE 0 END) as swapout_volume,

swapto_volume - swapout_volume as volume_in

FROM ethereum.dex_swaps

WHERE block_timestamp >= getdate() - interval '60 days'

AND token_address = '0xc4de189abf94c57f396bd4c52ab13b954febefd8'

GROUP BY 1,2

ORDER BY 1 DESC