SELECT

date_trunc('{{interval}}',block_timestamp) as date,

count(tx_hash) as total_deposit,

sum(total_deposit) over (ORDER BY date) as cum_deposits,

count(DISTINCT depositor_address) as unique_depositors,

sum(unique_depositors) over (ORDER BY date) as cum_unique_depositors,

total_deposit/unique_depositors as deposit_per_depositors,

sum(supplied_usd) as vol_deposit,

sum(vol_deposit) over (ORDER BY date) as cum_volume_of_supply_usd,

vol_deposit/total_deposit as volume_per_deposit,

vol_deposit/unique_depositors as volume_per_depositors

FROM ethereum.aave.ez_deposits

WHERE Aave_token = '0xffc97d72e13e01096502cb8eb52dee56f74dad7b'

AND date < current_date-1

GROUP BY 1

ORDER BY 1 DESC