BLOCK_TIMESTAMP::date as date , action ,

sum (AMOUNT_USD) as USD_volume , sum (USD_volume) over (partition by action order by date ) as cum_USD_volume,

count (DISTINCT ORIGIN_FROM_ADDRESS ) as num_wallets,

count (DISTINCT TX_HASH ) as num_lendings, sum (num_lendings) over (partition by action order by date ) as cum_lendings

from ethereum.sushi.ez_lending

where BLOCK_TIMESTAMP::date >= CURRENT_DATE - 30 group by 1,2