with shuttle_bridge_contract as(
(
select
'terra1g6llg3zed35nd3mh9zx6n64tfw3z67w2c48tn2' as contract_address,
'Account | Terra Bridge BSC' as contract_name
)
union
(
select
'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc' as contract_address,
'Account | Terra Bridge ETH' as contract_name
)
),
shuttle_bridge_activity_list as(
(
select
block_timestamp,
tx_id,
msg_value : execute_msg : transfer : recipient :: string as address
from
terra.msgs
where
msg_value : sender :: string in (
select
contract_address
from
shuttle_bridge_contract
)
)
union all
(
select
block_timestamp,
tx_id,
msg_value : sender :: string as address
from