select
block_timestamp::date as day,
sum(amount_usd) as total_usd_amount,
count(distinct depositor) as number_of_depositors,
count(distinct tx_hash) as number_of_transactions,
action
from ethereum.sushi.ez_lending
where day >= '2022-09-15'
group by day, action