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'

else null 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'),

worm as (select dt,sum(amount) as ust_volume

from raw

where terra_to_chain = 'ethereum'

group by 1

order by 1 asc),

terra_bridge as (select date_trunc('day',block_timestamp) as dt, sum(msg_value:amount[0]:amount/1e6) as amount

from terra.msgs

where msg_value:to_address::string = 'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc' and tx_status = 'SUCCEEDED'

and msg_value:amount[0]:denom::string = 'uusd'

group by 1)

select a.dt, a.amount as Terra_Bridge, b.ust_volume as wormhole,

sum(Wormhole) OVER(ORDER BY a.dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS Wormhole_cumulative_volume,

sum(terra_bridge) OVER(ORDER BY a.dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS terrabridge_cumulative_volume

from terra_bridge a

left outer join worm b on a.dt = b.dt