SELECT

TX_HASH,

block_timestamp,

liquidated_amount,

liquidated_amount_usd,

debt_to_cover_amount,

debt_to_cover_amount_usd,

liquidator,

borrower,

aave_version,

collateral_token_symbol,

debt_token_symbol,

LIQUIDATED_AMOUNT_USD - DEBT_TO_COVER_AMOUNT_USD as liqudation_fees_usd

FROM ethereum.aave.ez_liquidations

WHERE true --AAVE_VERSION = 'Aave V2'

and LIQUIDATED_AMOUNT_USD IS NOT NULL

and debt_token_price is not null

AND block_timestamp >= '2024-08-01'

SELECT

date_trunc(day, block_timestamp) as date,

collateral_token_symbol,

sum(liquidated_amount_usd) as liq_amt_usd,

sum(debt_to_cover_amount_usd) as debt_to_cover_usd,

sum(liqudation_fees_usd) as liq_fees_usd,

count(distinct borrower) as borrowers,

count(distinct tx_hash) as txns

FROM liqudations

GROUP BY date, collateral_token_symbol