msg_value:execute_msg:initiate_transfer:recipient_chain as chain, case

when chain = 1 then 'solana'

when chain = 2 then 'ethereum'

when chain = 4 then 'BSC'

when chain = 5 then 'polygon'

when chain = 6 then 'avalanche'

when chain = 7 then 'oasis'

when chain = 9 then 'aurora'

when chain = 10 then 'fantom'

else chain end as terra_to_chain,

msg_value:execute_msg:initiate_transfer:asset:amount/1e6 as amount,

msg_value:execute_msg:initiate_transfer:asset:info:native_token:denom::string as uusd

from terra.msgs

where msg_value:contract::string = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'

and msg_value:execute_msg:initiate_transfer is not null

and msg_value:execute_msg:initiate_transfer:asset:info:native_token:denom::string = 'uusd')

select dt, terra_to_chain, sum(amount) as ust_volume, sum(ust_volume) OVER(partition by terra_to_chain ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS vol_cumulative,

count(distinct tx_id) as transaction_count, sum(transaction_count) OVER(partition by terra_to_chain ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS transaction_cumulative

from raw

group by 1,2

order by 1 asc