count(distinct from_address) as depositors,

sum(amount) as deposited,

sum(amount_usd) as deposited_usd

from avalanche.core.ez_token_transfers

join avalanche.core.fact_event_logs using(tx_hash)

where contract_address = '0x06d47f3fb376649c3a9dafe069b3d6e35572219e'

and topics[0] = '0x30385c845b448a36257a6a1716e6ad2e1bc2cbe333cde1e69fe849ad6511adfe'

and to_address = '0xdb8b3bd77b7a28c2835c9e8e3c15f7adbc2cd267'

group by 1),

redeem as (select date_trunc('day',block_timestamp) as date,

count(distinct to_address) as redeemers,

sum(amount) as redeemed,

sum(amount_usd) as redeemed_usd

from avalanche.core.ez_token_transfers

join avalanche.core.fact_event_logs using(tx_hash)

where contract_address = '0x06d47f3fb376649c3a9dafe069b3d6e35572219e'

and topics[0] = '0xdd8b8dbb53fec7033579b7466dc8fd28b088f5b31bca605ca8fa24a570e366ca'

and from_address = '0xdb8b3bd77b7a28c2835c9e8e3c15f7adbc2cd267'

group by 1)

select date,

depositors,

redeemers,

deposited_usd as "Deposited $",

-redeemed_usd as "Redeemed $",

deposited_usd-redeemed_usd as "NET $",

sum(deposited_usd) over (order by date) - sum(redeemed_usd) over (order by date) as "TVL"

from deposit

full outer join redeem using(date)

order by 1 desc