hbd1994Senders
    Updated 2025-02-10
    with base as (
    select
    BLOCK_TIMESTAMP,
    TX_HASH,
    case
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x706f82e9bb5b0813501714ab5974216704980e31' then 'Wormhole Relayer'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x8d2de8d2f73f1f4cab472ac9a881c9b123c79627' then 'Wormhole Portal'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0xc38e4e6a15593f908255214653d3d947ca1c2338' then 'Mayan Swift'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0xf18f923480dc144326e6c65d4f3d47aa459bb41c' then 'Mayan MCTP'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x3c5c5436bca59042cbc835276e51428781366d85' then 'Catalyst'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x03fabb06fa052557143dc28efcfc63fc12843f1d' then 'Wormhole CCTP'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0xd1a8ab69e00266e8b791a15bc47514153a5045a6' then 'Wormhole NTT'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0xd1a8ab69e00266e8b791a15bc47514153a5045a6' then 'AllBridge'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x8d77ac62a6571a408e5c9655ff5de90d537c3045' then 'MCTP'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0xda3adc6621b2677bef9ad26598e6939cf0d92f88' then 'Portal Nft Bridge'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x0f4aedfb8da8af176deff282da86ebbe3a0ea19e' then 'MCTP2'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x321dbb84766c4e6d51c7f2015db20f5b9a2c5601' then 'Wormhole NTT - OmniBTC'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x496a6c57dbc1c7770cb9afe118e3268f979bc53f' then 'MCTP3'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x43e5c369163395b9da8ba855f8fbc2edd25cecc2' then 'MCTP4'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0xc95b6b051c485bb661414207139a3f8b5c48f08c' then 'MCTP5'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x70287c79ee41c5d1df8259cd68ba0890cd389c47' then 'Wormhole Liquidity Layer'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x11aa521c888d84f374b63823d9b873caa3591f55' then 'MCTP6'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0x329f8856bbeededaed13ba5dea2c83cd1991179c' then 'MCTP7'
    when '0x' || substr(TOPICS[1], 27, 40 ) = '0xc986dd854b8f4acb5ccf2fa1cdacc113e6de0892' then 'Wormhole NTT'
    else 'Others'
    end as sender,
    ORIGIN_TO_ADDRESS,
    from base.core.fact_event_logs
    where TOPICS[0] = '0x6eb224fb001ed210e379b335e35efe88672a8ce935d981a6896b27ffdf52a3b2'
    --and tx_hash = '0x06547c683a9929e872fed11a72c62a79569ef5a5b45af761341bbef566cf8a69'
    and TX_STATUS = 'SUCCESS'
    and CONTRACT_ADDRESS = '0xbebdb6c8ddc678ffa9f8748f85c815c556dd8ac6'
    order by 1 desc)

    select
    sender,
    Last run: 3 months ago
    SENDER
    ORIGIN_TO_ADDRESS
    TXS
    ANY_VALUE(TX_HASH)
    1
    Wormhole NTT10xdb183be65875bd952fd4c364227d1e754d46d2226d944f19ede37349b23af933
    2
    Others0xfde26b5fe311e5985ce573933aa9c7b311eb663920xabe92a8ce857c7560884615bc07eacff8928c05d3d488f169f0c9b1ce61aa73f
    3
    Wormhole Portal0xfa7c975ab75494007865270000fe89611b1d006d590x34511182983a5a44b70eed835ab05686220c90607051d209630c5887e45b7d75
    4
    Wormhole Relayer0xfa448e89255cc27efdad1603cf9a60c2aaf4b09f100xdcc41771589f7b4b4bc456321a5acab51234eac850369dc8c38320b4d309a6e5
    5
    Wormhole Relayer0xf9ebc3b140d802240ae2ebf1a3d388e5cd67087220xd419bcbe896c3fcc9cfc410eac7f7ab6710313ce5fab99b4da394115b3dc5972
    6
    Wormhole CCTP0xf9d64d54d32ee2bdceaabfa60c4c438e224427d020980xfefd0e78791568a6f66484f9990ac77b742cf8a3193dc186c0183c0bb86030bb
    7
    MCTP0xf9d64d54d32ee2bdceaabfa60c4c438e224427d030x1e9079b15ee98676155c31d4936bce0863c2aeaa1a645a5c2641bb55eefee51a
    8
    Mayan MCTP0xf9d64d54d32ee2bdceaabfa60c4c438e224427d050x4056e631ee24f8667fcd6568b6cc47eb2320603f962f3760ea04732f773ef67c
    9
    Wormhole Portal0xf9d64d54d32ee2bdceaabfa60c4c438e224427d0140xf4d70305acca2422df3854388bea3e23ff8da1fb04e28e5b9aec1b1f5eee4fa1
    10
    Others0xf9d64d54d32ee2bdceaabfa60c4c438e224427d020x5738852996f9a147e80b3cd6b7ab8c6c29c4447e203d0ce9157930c44a02f2d0
    11
    Wormhole Relayer0xf9d64d54d32ee2bdceaabfa60c4c438e224427d010x59706caa30eac7f4b18c24d0d16be9b7de72d6c7c1e65a2f9b86f150ce6e49b1
    12
    Others0xf94e66d41562fd205efc4fe7fe0c78ed47aa15dd40x58f2637d60c2496cb3c9f611f13eeac6ca5565a762d6bd0e72fd0214c88a95ce
    13
    Wormhole Relayer0xf708e11a7c94abde8f6217b13e6fe39c8b9cc0a670xc69e764e0c35b72d74e2cdb64c222cc50b979483b5bbcd6c0069b3c7fbc3149e
    14
    Mayan MCTP0xf708e11a7c94abde8f6217b13e6fe39c8b9cc0a620x522df4c8077dab480527f3eafd00286a970e5a7e4085d6d8f3eb378fc1b7f9ac
    15
    Wormhole Relayer0xf673457b6d6df5091f000102652395f0933c513a10x0087db665375aff7196df7801ed5b73c3ce6d555655e8175c1e2c99bb569d947
    16
    Wormhole Relayer0xf4dc475961095021a0fbfb17d336a6f0f13863af27770x74cc7894521901e43a6913f6b7467757795c6f9452e90f37a96b0b3f16e21f67
    17
    Others0xf4c7e9393a5e35eaafa999400fe50609d385037b10xf06b3aedffc49fefee22f1fd864b4d685df6b41221a90d2eb2aa697df774d355
    18
    Wormhole Relayer0xf4c542518320f09943c35db6773b2f9feb2f847e131300xc65207b39d350815a1d87593ac275ac6fd21c2df3718b74c427b169b43d75119
    19
    Others0xf38c71547af666f92595219631b6329d0fd663a410xedc485221a77ee859b0ccab05ddc695f18b620aa9e1f64f9759e5c6628db8597
    20
    Others0xf3589240d848413c8861ac80277087493f329d9310x5b070d7198eb18cca2ee7deea85ae057d0b06163d6688b209073e61793c0b271
    ...
    283
    37KB
    128s