select

* -- block_number,

-- block_timestamp,

-- tx_hash,

-- contract_address,

-- event_index,

-- platform,

-- liquidator,

-- borrower,

-- protocol_market,

-- debt_token,

-- debt_token_symbol,

-- collateral_token,

-- collateral_token_symbol,

-- amount,

-- amount_usd

from

base.defi.ez_lending_liquidations

-- arbitrum.defi.ez_lending_liquidations

liquidator,

sum(amount_usd) as volume

transactions

-- block_timestamp::date as date,

-- sum(amount_usd) as volume

-- from

-- transactions

-- where

-- block_timestamp::date between current_date - 30 and current_date - 1

group by

liquidator