'Deposit' as action,

date_trunc('{{Interval}}',BLOCK_TIMESTAMP::date) as date,

count(distinct tx_hash) as txs_count,

sum(txs_count) over (order by date) as cumultxs_count,

count(distinct DEPOSITOR_ADDRESS) as user_count,

sum(ISSUED_TOKENS) as aave_volume,

sum(aave_volume) over (order by date) as cumulaave_volume,

sum(SUPPLIED_USD) as usd_volume,

sum(usd_volume) over (order by date) as cumulusd_volume

from ethereum.aave.ez_deposits

where symbol = 'AAVE'

group by 2

order by 2)

union all

(select

'Withdraw' as action,

date_trunc('{{Interval}}',BLOCK_TIMESTAMP::date) as date,

count(distinct tx_hash) as txs_count,

sum(txs_count) over (order by date) as cumul1,

count(distinct DEPOSITOR_ADDRESS) as user_count,

sum(WITHDRAWN_TOKENS) as aave_volume,

sum(aave_volume) over (order by date) as cumul2,

sum(WITHDRAWN_USD) as usd_volume,

sum(usd_volume) over (order by date) as cumul3

from ethereum.aave.ez_withdraws

where symbol = 'AAVE'

group by 2

order by 2)