flipside

    wormhole
    freemartianwormhole
    Updated 2024-02-05
    with chains_meta AS (
    -- wormhole chain id
    -- resource: https://docs.wormhole.com/wormhole/reference/constants
    SELECT 'solana' AS chain_name, '1' AS chain_id UNION
    SELECT 'ethereum' AS chain_name, '2' AS chain_id UNION
    SELECT 'terra' AS chain_name, '3' AS chain_id UNION
    SELECT 'bsc' AS chain_name, '4' AS chain_id UNION
    SELECT 'polygon' AS chain_name, '5' AS chain_id UNION
    SELECT 'avalanche' AS chain_name, '6' AS chain_id UNION
    SELECT 'oasis' AS chain_name, '7' AS chain_id UNION
    SELECT 'algorand' AS chain_name, '8' AS chain_id UNION
    SELECT 'aurora' AS chain_name, '9' AS chain_id UNION
    SELECT 'fantom' AS chain_name, '10' AS chain_id UNION
    SELECT 'karura' AS chain_name, '11' AS chain_id UNION
    SELECT 'acala' AS chain_name, '12' AS chain_id UNION
    SELECT 'klaytn' AS chain_name, '13' AS chain_id UNION
    SELECT 'celo' AS chain_name, '14' AS chain_id UNION
    SELECT 'near' AS chain_name, '15' AS chain_id UNION
    SELECT 'moonbeam' AS chain_name, '16' AS chain_id UNION
    SELECT 'neon' AS chain_name, '17' AS chain_id UNION
    SELECT 'terra2' AS chain_name, '18' AS chain_id UNION
    SELECT 'injective' AS chain_name, '19' AS chain_id UNION
    SELECT 'osmosis' AS chain_name, '20' AS chain_id UNION
    SELECT 'sui' AS chain_name, '21' AS chain_id UNION
    SELECT 'aptos' AS chain_name, '22' AS chain_id UNION
    SELECT 'arbitrum' AS chain_name, '23' AS chain_id UNION
    SELECT 'optimism' AS chain_name, '24' AS chain_id UNION
    SELECT 'gnosis' AS chain_name, '25' AS chain_id UNION
    SELECT 'pythnet' AS chain_name, '26' AS chain_id UNION
    SELECT 'xpla' AS chain_name, '28' AS chain_id UNION
    SELECT 'base' AS chain_name, '30' AS chain_id UNION
    SELECT 'sei' AS chain_name, '32' AS chain_id UNION
    SELECT 'rootstock' AS chain_name, '33' AS chain_id UNION
    SELECT 'cosmoshub' AS chain_name, '4000' AS chain_id UNION
    SELECT 'evmos' AS chain_name, '4001' AS chain_id UNION
    SELECT 'kujira' AS chain_name, '4002' AS chain_id UNION
    Last run: about 1 year ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    VERSION
    TX_HASH
    PAYLOAD
    BRIDGE_ADDRESS
    FUNCTION
    EVENT_NAME
    PLATFORM
    SENDER
    DESTINATION_CHAIN_RECEIVER
    DESTINATION_CHAIN
    DESTINATION_CHAIN_ID
    TOKEN_ADDRESS
    TOKEN_SYMBOL
    TOKEN_NAME
    AMOUNT_UNADJ
    AMOUNT
    AMOUNT_USD
    FACT_TRANSACTIONS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    41414793
    		2023-03-24 11:08:42.5221070386620xad101c1003cf2cf593078a64e4c5f10b8bc58b1c72a28569664c27ca4df25306
    {"arguments":["150000","2","0x000000000000000000000000e5136d4e0eba7f94de...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0xcba3200c0f92c594eaf2c87ee78ef4ecd50a45fd900b460e5f2c2518e4ae807d0xe5136d4e0eba7f94de669f0b4d234f608ae76774ethereum
    2
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH
    		WETHWrapped Ether
    150000
    		0.15269.838c61fb77e68ec68e0de64a2dd21a6fc132023-12-01 13:13:07.5582023-12-01 13:13:07.558
    2
    42822669
    		2023-03-30 03:03:32.5521103889210x4fab532bd1066afffbebd4572f1f6f1b9a58a9fe15a733f83d6af8d3cfcf9942
    {"arguments":["35188022","2","0x00000000000000000000000093059a1683f5d250...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0xc457c1b259c8b83fab41628b63dbfcc24f71eeb543c7be460c8d4a35fc3186420x93059a1683f5d250e739811ae783b06a6e89eeb2ethereum
    2
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    35188022
    		35.18802235.1880221040b5dc8e2fee23834c447bf7a3e29d2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    3
    60816182
    		2023-06-11 19:50:20.2061576450010x1550b9cf149d321b327ad1799e4d740969baed4a95d262b5f70d31c4ae7b6918
    {"arguments":["100000","10","0x0000000000000000000000004a1839dd849219a0d...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x3a54ff382353f6bf674b4b55d68ca38acef7dacd4d99eaf5a98b48b026f64c1f0x4a1839dd849219a0d4ee56f550ecd2a466f08376fantom
    10
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    100000
    		0.10.099704657301cb6b0e6a98a147c2a90bb9fd93a02023-12-01 13:13:07.5582023-12-01 13:13:07.558
    4
    60733459
    		2023-06-11 10:55:52.6151574011130x9dbd76066b2198c8fd14eec87888d94950ea47255e6a55c741e4a09027793c55
    {"arguments":["150000","4","0x0000000000000000000000000ab3da0d33672326c2...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x492999c8f51217950309aaa6922e1fec819b84623e1a34214b41b4134787768e0x0ab3da0d33672326c26956ec8f085b1ad2b3ffdfbsc
    4
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    150000
    		0.150.1499321256b452e4327384ad9d43128db5ca9f99a2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    5
    50566674
    		2023-04-26 14:50:43.7421300155870x73bc353b4504981550cd56a7b13ecf1c6a9252cb628f0dab4229ba751b1b25bb
    {"arguments":["10000000","5","0x000000000000000000000000ad44d11ef8019adc...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x89625d0bd67c675ffdef5b15f78f32ec435a56f9f66dd8422949abea5bd142f70xad44d11ef8019adc52f46443f0a27098ad086486polygon
    5
    0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC
    		USDCUSD Coin
    10000000
    		109.986285a92fb83804943a66f0470bfd29027c662023-12-01 13:13:07.5582023-12-01 13:13:07.558
    6
    42259734
    		2023-03-27 21:25:21.7431090364430x68323c784a8c682790103efb728406c5e69598571b7dc86ae991560859a56225
    {"arguments":["10000000","5","0x000000000000000000000000c591b10bebadeb13...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x3bcc10800ef57540c472971947f52000f0234792f146055b1cb7306248e5f3460xc591b10bebadeb13f48df94bfe75282d32a52389polygon
    5
    0x1::aptos_coin::AptosCoin
    		APTAptos Coin
    10000000
    		0.165fad36700d709b1200ab1eaadb08a632023-12-01 13:13:07.5582023-12-01 13:13:07.558
    7
    38376619
    		2023-03-10 23:45:59.5241000829820xcc142e7f39692a89177611c3b6f65d41f4e549e047e5423cd41813c5f59b1196
    {"arguments":["47968800000000","4","0x00000000000000000000000053c218ee4b...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x61df7a3d6f21824d5d327dd49d85b2b29ad9eb82bdc22c51b959e58e5b9075370x53c218ee4b05f817fab41afd2c66fd92550a8888bsc
    4
    0xccc9620d38c4f3991fa68a03ad98ef3735f18d04717cb75d7a1300dd8a7eed75::coin::T
    		BUSDBUSD Token
    47968800000000
    		479688433901.300712791f61341fabe252813e1a07143c80c72023-12-01 13:13:07.5582023-12-01 13:13:07.558
    8
    57678756
    		2023-05-27 15:04:23.4801487593160x3eb48ddb383b31409593e7292f7e67494e4ba3d847e7b1a3d9b3067a18fb3d5d
    {"arguments":["100000","5","0x0000000000000000000000002837e5f32430baa5cf...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0xaf5e6795aba4ecbd23f037d71cf5a594138995cf5187cb4b11a78d1585cf90730x2837e5f32430baa5cfd4e0d1cec7b92a58c14df6polygon
    5
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    100000
    		0.10.10005ac9426e5a5882d1c381a02648c44b75e2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    9
    38395894
    		2023-03-11 01:49:15.1141001268660xffd8c26caa3c5a4e473e3b098b39847ba70d55eaf0b52f22811b4d67f6a4db2c
    {"arguments":["400000000000","2","0x0000000000000000000000007182a1b9cf88...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x6af3833460b415dc8e1caa17e73fbc1f82b9ffe3ed23306456c0b2a82a719b2b0x7182a1b9cf88e87b83e936d3553c91f9e7bebdd7ethereum
    2
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    400000000000
    		400000394002.6995e5e321b77b0155acf36abb3c69a852023-12-01 13:13:07.5582023-12-01 13:13:07.558
    10
    38396780
    		2023-03-11 01:54:49.7091001288910x92580a373505ef5582c2644577015f89be30be88e1ce1dafd360d085c50822f9
    {"arguments":["400000000000","2","0x0000000000000000000000007182a1b9cf88...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x6af3833460b415dc8e1caa17e73fbc1f82b9ffe3ed23306456c0b2a82a719b2b0x7182a1b9cf88e87b83e936d3553c91f9e7bebdd7ethereum
    2
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    400000000000
    		400000394002.6db561ff0e4a6dc308f575767c8d070242023-12-01 13:13:07.5582023-12-01 13:13:07.558
    11
    38394319
    		2023-03-11 01:40:03.8771001230670xd3bc3a085c6ed591c54e837bdf2f80f951695bfccb02434cfec9a4a29d1baa82
    {"arguments":["400000000000","2","0x0000000000000000000000007182a1b9cf88...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x6af3833460b415dc8e1caa17e73fbc1f82b9ffe3ed23306456c0b2a82a719b2b0x7182a1b9cf88e87b83e936d3553c91f9e7bebdd7ethereum
    2
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    400000000000
    		400000394002.6efe46db6c13db02814163b5b0c60d2352023-12-01 13:13:07.5582023-12-01 13:13:07.558
    12
    38477929
    		2023-03-11 10:00:52.7341003226130x7f3a6e43a0dbb5bc79b5a57043f4172b42a03f8161afc4a41a577abd079d6c47
    {"arguments":["75956","1","0xdb175e1c8acc2f44ce06bb1caf9c662414dc4b87aa4...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0xb6e8a6eca6843ba23d087215f807e6f72dd480f091d7f101d5b3edbc711b840e0xdb175e1c8acc2f44ce06bb1caf9c662414dc4b87aa4a32382a2396f53155be54solana
    1
    0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T
    		WETHWrapped Ether
    75956
    		0.000759561.090439527704fe0bd1703162369d16dc52fa1bec42023-12-01 13:13:07.5582023-12-01 13:13:07.558
    13
    38395344
    		2023-03-11 01:45:40.7361001256320x553ddd9821fc134a8b112a4f520965610a13cb88ea74c740fc7b62dc1cd93996
    {"arguments":["400000000000","2","0x0000000000000000000000007182a1b9cf88...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x6af3833460b415dc8e1caa17e73fbc1f82b9ffe3ed23306456c0b2a82a719b2b0x7182a1b9cf88e87b83e936d3553c91f9e7bebdd7ethereum
    2
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    400000000000
    		400000394002.6064ed189c613aa1d8b2051c0ac41a04e2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    14
    38478748
    		2023-03-11 10:06:04.0381003244690x646b318423a726b2b08d10d06fa1769d02f45f7e3428fbd3faed6dd700ef880e
    {"arguments":["149826","5","0x0000000000000000000000003bfbaf197495362c31...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0xb6e8a6eca6843ba23d087215f807e6f72dd480f091d7f101d5b3edbc711b840e0x3bfbaf197495362c31126ab2bc51a8eb1a7d9f4bpolygon
    5
    0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T
    		WETHWrapped Ether
    149826
    		0.001498262.150932021c561c7e0af0b3c038ec6f89a4be18b372023-12-01 13:13:07.5582023-12-01 13:13:07.558
    15
    44740981
    		2023-04-06 08:47:19.8881151123020xa2e33d35f78b45c2811fc68598d1ffe2ae44e76bb993929d32501783cd47c5af
    {"arguments":["10000000","23","0x0000000000000000000000004432b0bb9f9e25a...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x14be77c7649bb75620fed8a750f04ba4a39fe5fea5911a63f8b434e2dc1ed7f90x4432b0bb9f9e25ab451de5b14f9a719901f45757arbitrum
    23
    0xebd44765c019ac21f3a0e28a60d9530678b284af0b3dbabff63ba1e8ac0f5496::coin::T
    		USDCUSD Coin (Arb1)
    10000000
    		109.99577be0e8038139e5b2036afbc612b948c222023-12-01 13:13:07.5582023-12-01 13:13:07.558
    16
    60695824
    		2023-06-11 06:55:11.6851572915560xa9c905606dbc73fcafdf7008bf38cac399414d274a965bcdd248c9bf0187a611
    {"arguments":["177700","5","0x000000000000000000000000c425a9b77353526296...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0xa92471e577c36986d21cdbaec98c18cf975cc34f718e91eaf8c71b8de8c42bd00xc425a9b773535262963f688e458400600d95bbd6polygon
    5
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    177700
    		0.17770.1776327405fe79dd73312b9e0b005042044265f0522023-12-01 13:13:07.5582023-12-01 13:13:07.558
    17
    60816294
    		2023-06-11 19:51:04.9211576453940xcc2e58aa0b264c1065819d97eb0c251c6864661e372920401b2d5b1610a77d57
    {"arguments":["110000","4","0x0000000000000000000000004a1839dd849219a0d4...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x3a54ff382353f6bf674b4b55d68ca38acef7dacd4d99eaf5a98b48b026f64c1f0x4a1839dd849219a0d4ee56f550ecd2a466f08376bsc
    4
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    110000
    		0.110.1096751151044446029f26a8f4c89dea68eebc2ed2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    18
    57686739
    		2023-05-27 15:57:45.0251487839790x37204d3b899293005615e0e864c930b003e760d6990805a4de31c21e16994ec5
    {"arguments":["100000","5","0x0000000000000000000000000825e49dc401af3d4a...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0xaea0fb32ea7ded3e0aeb68b6d2d474b03320268ac366b5899f0086ec22b962fe0x0825e49dc401af3d4aaaf3e5d81a7186df9ab699polygon
    5
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    100000
    		0.10.10005b6604f4994c1b3285bba1dfe394c2f5e2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    19
    57684627
    		2023-05-27 15:43:59.5361487774340x8b312559203791faf546e30929a9175ee3a536ac962db086235c2c56a8a91f1e
    {"arguments":["70000","5","0x000000000000000000000000ba0ce0602bd6c7f5dd6...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0x50ef161f51bcc6153cf12b9612d64054f1cc106ffe6bc36b771d90fb4e37b8b60xba0ce0602bd6c7f5dd674a4f14ce8c467b143611polygon
    5
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    70000
    		0.070.070035ebe9268639d787c4a98d842027f6e0912023-12-01 13:13:07.5582023-12-01 13:13:07.558
    20
    38574112
    		2023-03-11 20:38:16.6501005373410xc81415141d08f0655f85b78f72e115f61b04935c259c1bc30b2197f76e8c61e1
    {"arguments":["1114343431","5","0x0000000000000000000000000d388b8da5a6a8...
    		0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4ftransfer_tokenstransfer_tokens_entryWormhole0xdd401a8f7ca8f9f192977bfae8756062bc7e36bb38787c83ee608140ff888e780x0d388b8da5a6a8c35a1394ba5e021b273ce419acpolygon
    5
    0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T
    		USDCUSD Coin
    1114343431
    		1114.3434311060.755212575c5410d4a308c23a87ac733a01876be4f2023-12-01 13:13:07.5582023-12-01 13:13:07.558
    100
    91KB
    41s