select origin_from_address,

count (distinct tx_hash) as Transactions,

count (distinct origin_from_address) as Users,

sum (decoded_log:value/1e18) as savusd_Volume,

avg (decoded_log:value/1e18) as avg_savusd_Volume,

savusd_Volume / Users as volume_per_user

from avalanche.core.ez_decoded_event_logs

where origin_to_address = '0xdb8b3bd77b7a28c2835c9e8e3c15f7adbc2cd267'

and tx_succeeded

and event_name = 'Transfer'

and origin_function_signature = '0x0587bcf3'

and contract_address = '0x06d47f3fb376649c3a9dafe069b3d6e35572219e'

and decoded_log:from = origin_from_address

group by 1),

redeemt as (

select origin_from_address,

count (distinct tx_hash) as Transactions,

count (distinct origin_from_address) as Users,

sum (decoded_log:value/1e18) as savusd_Volume,

avg (decoded_log:value/1e18) as avg_savusd_Volume,

savusd_Volume / Users as volume_per_user

from avalanche.core.ez_decoded_event_logs

where origin_to_address = '0xdb8b3bd77b7a28c2835c9e8e3c15f7adbc2cd267'

and tx_succeeded

and event_name = 'Transfer'

and origin_function_signature = '0xfa7f0c4e'

and contract_address = '0x06d47f3fb376649c3a9dafe069b3d6e35572219e'

and decoded_log:to = origin_from_address

group by 1)

select coalesce (t1.origin_from_address,t2.origin_from_address) as User,

sum (coalesce (t1.savusd_volume,0) - coalesce (t2.savusd_volume,0)) as Net_Balance