select date_trunc('day', block_timestamp) as dt,

sum(amount) as amount_deposit_avax, count(distinct tx_id) as num_deposit_avax

from terra.transfer_events

where sender = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'

and recipient = 'terra1pw4qm09m256m3wz25n4whnuqck7rcn6wvvjzyj'

group by 1

),

w_avax as (

select date_trunc('day', block_timestamp) as dt ,

sum(amount) as amount_withdraw_avax, count(distinct tx_id) as num_withdraw_avax

from terra.transfer_events

where sender = 'terra1pw4qm09m256m3wz25n4whnuqck7rcn6wvvjzyj'

and recipient = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'

group by 1

),

final as (

select

case when amount_deposit_avax is null then '0'

else amount_deposit_avax

end as total_deposit_avax,

case when amount_withdraw_avax is null then '0'

else amount_withdraw_avax

end as total_withdraw_avax,

(total_deposit_avax - total_withdraw_avax) as net_deposit_avax,

SUM(net_deposit_avax) OVER(ORDER BY d.dt ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS current_deposit_avax,

num_deposit_avax, num_withdraw_avax,

coalesce(d.dt, w.dt) as dt_f

from d_avax d

full join w_avax w on d.dt = w.dt

),

anchor_deposit as (

select sum(deposit_amount) as amount_deposit_anchor, count(distinct tx_id) as num_deposit_anchor,