DATE_TRUNC('day', block_timestamp) AS date,

SUM(CASE WHEN MODIFICATION_TYPE = 'deposit' THEN AMOUNT_USD ELSE 0 END) AS Inflow,

SUM(CASE WHEN MODIFICATION_TYPE = 'withdraw' THEN AMOUNT_USD ELSE 0 END) AS Outflow,

inflow + outflow AS Net_Flow

FROM

arbitrum.vertex.ez_clearing_house_events

WHERE

MODIFICATION_TYPE IN ('withdraw', 'deposit')

GROUP BY

1

ORDER BY

1 DESC;