trader,

case when amount_quote < 0 then amount_quote*-1 else amount_quote end as vol,

from blast.blitz.ez_liquidations)

select count(DISTINCT tx_hash) as trades,

count(DISTINCT trader) as traders,

SUM(ABS(vol)) as volume,

avg(vol) as avg_volume

from liquidation