SELECT

--Moe

date_trunc('day', block_timestamp) as dYs,

case when block_timestamp >= '2022-09-15' then 'post merge' else 'pre merge' end as type,

count(DISTINCT tx_hash) as num_txs,

COUNT(DISTINCT DEPOSITOR_ADDRESS) as num_users,

sum(SUPPLIED_USD) as total_SUPPLIED_USD,

avg(SUPPLIED_USD) as avg_SUPPLIED_USD

FROM ethereum.aave.ez_deposits

WHERE 1=1

and block_timestamp between '2022-09-06' and CURRENT_date - 1

GROUP BY 1,2