symbol,

aave_token as token_address,

issued_tokens as amount

from aave.deposits

where lending_pool_contract = '0x0000006daea1723962647b7e189d311d757fb793'

and block_id <= '13532886'),

withdraws as (select block_timestamp,

symbol,

aave_token as token_address,

(-1) * withdrawn_tokens as amount

from aave.withdraws

where depositor_address = '0x0000006daea1723962647b7e189d311d757fb793' -- wintermute smart contract address

and block_id <= '13532886'),

collaterals as (select * from deposits

union all

select * from withdraws

order by block_timestamp, token_address),

final_table as (select symbol,

token_address,

sum(amount) as amount

from collaterals

group by symbol, token_address)

select * from final_table

where amount > 0

and symbol != 'USDT' -- not accepted as collateral

order by symbol