SELECT

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

count(tx_hash) as total_withdraw,

sum(total_withdraw) over (ORDER BY date) as cum_total_withdraws,

count(DISTINCT depositor_address) as unique_withdrawals,

sum(unique_withdrawals) over (ORDER BY date) as cum_unique_withdrawals,

total_withdraw/unique_withdrawals as withdraw_per_withdrawls,

sum(WITHDRAWN_USD) as vol_withdraw,

sum(vol_withdraw) over (ORDER BY date) as cum_volume_of_withdraw_usd,

vol_withdraw/total_withdraw as volume_per_withdraw,

vol_withdraw/unique_withdrawals as volume_per_withdrawals

FROM ethereum.aave.ez_withdraws

WHERE Aave_token = '0xffc97d72e13e01096502cb8eb52dee56f74dad7b'

AND date < current_date-1

GROUP BY 1

ORDER BY 1 DESC