date_trunc(week,block_timestamp) as date,

MODIFICATION_TYPE,

COUNT(DISTINCT tx_hash) AS numTransaction,

COUNT(DISTINCT trader) AS numUser,

SUM(CASE WHEN MODIFICATION_TYPE = 'deposit'

then amount_usd else 0 end) as inNetwork,

SUM(CASE WHEN MODIFICATION_TYPE = 'withdraw'

then amount_usd else 0 end) as outNetwork,

FROM blast.blitz.ez_clearing_house_events

WHERE MODIFICATION_TYPE IN ('deposit', 'withdraw')

GROUP BY date, MODIFICATION_TYPE;