with token_bonk as ( select * from

( values ( '8', 'USDT', 'binance', '/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/871jbn9unTavWsAe83f2Ma9GJWSv6BKsyWYLiQ6z3Pva'),

('6', 'USDC', 'solana', '/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/9fELvUhFo6yWL34ZaLgPbCPzdk9MD1tAzMycgH45qShH'),

('6','USDC','optimism','/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/3VKKYtbQ9iq8f9CaZfgR6Cr3TUj6ypXPAn6kco6wjcAu'),

('6','USDC','polygon','/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/DUVFMY2neJdL8aE4d3stcpttDDm5aoyfGyVvm29iA9Yp'

),

('6','USDC','arbitrum','/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7edDfnf4mku8So3t4Do215GNHwASEwCWrdhM5GqD51xZ'

),

( '8','WBTC','ethereum','/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7omXa4gryZ5NiBmLep7JsTtTtANCVKXwT9vbN91aS1br'

),

('6','USDC','ethereum','/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/Hq4tuDzhRBnxw3tFA5n6M52NVMVcC19XggbyDiJKCD6H'

),

('8','ETH','ethereum','/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/4tLQqCLaoKKfNFuPjA9o39YbKUwhR1F8N29Tz3hEbfP2'

)) as a (decimal, token_name, chain, token_address))

,

bridge_in as (select DISTINCT tx_id

from sei.core.fact_msg_attributes

where ATTRIBUTE_KEY = 'minter')

,

bridge_out as ( select DISTINCT tx_id

from sei.core.fact_msg_attributes

where ATTRIBUTE_KEY = 'burner')

,

-- Contract addresses are similar to User addresses.

-- To separate the contract addresses from the user addresses.

contract_addess as ( select DISTINCT attribute_value

from sei.core.fact_msg_attributes

where ATTRIBUTE_KEY = '_contract_address'),

bridge_tx_worm as ( select DISTINCT tx_id

from sei.core.fact_msg_attributes a join sei.core.dim_labels b on a.attribute_value = b.address

and block_timestamp::date >= '2023-08-15'

and tx_id in (select tx_id from bridge_out)

and label = 'wormhole'