date_trunc('day', block_timestamp) as date,

symbol,

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

from blast.blitz.ez_clearing_house_events

group by 1 , 2