select

date_TRUNC('day', ethereum.aave.ez_liquidations.BLOCK_TIMESTAMP),

sum(LIQUIDATED_AMOUNT_USD),

count(distinct LIQUIDATOR)

from ethereum.aave.ez_flashloans left outer join ethereum.aave.ez_liquidations

on ethereum.aave.ez_flashloans.tx_hash = ethereum.aave.ez_liquidations.tx_hash

where LIQUIDATED_AMOUNT_USD < 1e9

group by 1