liquidated_wallet,

min(block_timestamp) as first_tx

from ethereum.maker.ez_liquidations

where tx_status = 'SUCCESS'

group by 1)

select date_trunc('{{time}}', first_tx) as first_tx_date,

count(distinct(liquidated_wallet)) as count_new_liquidated_wallet,

sum(count_new_liquidated_wallet) over (order by first_tx_date) as cumulative_count_new_liquidated_wallet

from base

group by 1

order by 1 desc