select date_trunc('day', block_timestamp) as dt, sum(amount) as ust_deposit_avax, avg(amount) as average_deposit_avax, count(distinct tx_id) as deposit_count_avax

from terra.transfer_events

where sender = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'

and recipient = 'terra1pw4qm09m256m3wz25n4whnuqck7rcn6wvvjzyj'

group by 1

),

terra as (select date_trunc('day', block_timestamp) as dt, sum(deposit_amount) as ust_deposit_terra, avg(deposit_amount) as average_deposit_terra,

count(distinct tx_id) as deposit_count_terra

from anchor.deposits

group by 1)

select a.dt, a.ust_deposit_avax as avax, a.deposit_count_avax, b.ust_deposit_terra as terra, b.deposit_count_terra,

a.average_deposit_avax as Avalanche_average, b.average_deposit_terra as Terra_average

from avax a

left join terra b on a.dt = b.dt