date(day) as date, pool_name,

sum(CASE WHEN DIRECTION = 'IN' THEN AMOUNT_IN ELSE 0 END) AS stETH_in,

sum(CASE WHEN DIRECTION = 'OUT' THEN AMOUNT_OUT ELSE 0 END) AS stETH_out

FROM

(

SELECT

date(block_timestamp) AS day,

pool_name,

amount_in,

amount_out,

platform,

direction

FROM ethereum.dex_swaps

WHERE token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and BLOCK_TIMESTAMP > CURRENT_DATE - 360

)

GROUP BY 1,2

ORDER BY 1