0xHaM-dchristian-turquoise
    Updated 2025-02-05
    with map_data as (
    select * from (values
    ('LayerZero', '0x18d33689AE5d02649a859A1CF16c9f0563975258', '0xFAe103DC9cf190eD75350761e95403b7b8aFa6c0', '0xFAe103DC9cf190eD75350761e95403b7b8aFa6c0', 'rswETH' , 18),
    ('LayerZero', '0x09341022ea237a4DB1644DE7CCf8FA0e489D85B7', '0xf951E335afb289353dc249e82926178EaC7DEd78', '0xf951E335afb289353dc249e82926178EaC7DEd78', 'swETH' , 18),
    ('LayerZero', '0xA6cB988942610f6731e664379D15fFcfBf282b44', '0xCd5fE23C85820F7B72D0926FC9b05b43E359b7ee', '0xCd5fE23C85820F7B72D0926FC9b05b43E359b7ee', 'weETH' , 18),
    ('LayerZero', '0x1cf7b5f266A0F39d6f9408B90340E3E71dF8BF7B', '0x8DB2350D78aBc13f5673A411D4700BCF87864dDE', '0x8DB2350D78aBc13f5673A411D4700BCF87864dDE', 'swBTC' , 8),
    ('LayerZero', '0x939f1cC163fDc38a77571019eb4Ad1794873bf8c', '0x0a6E7Ba5042B38349e437ec6Db6214AEC7B35676', '0x0a6E7Ba5042B38349e437ec6Db6214AEC7B35676', 'rSWELL' , 18),
    ('LayerZero', '0x2826D136F5630adA89C1678b64A61620Aab77Aea', '0x0a6E7Ba5042B38349e437ec6Db6214AEC7B35676', '0x0a6E7Ba5042B38349e437ec6Db6214AEC7B35676', 'SWELL' , 18),
    -- ('LayerZero', 0xf6718b2701D4a6498eF77D7c152b2137Ab28b8A3, 0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599, 0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599, 'stBTC' , 18), -- using WBTC price feed, this is actual asset
    ('LayerZero', '0xc3eACf0612346366Db554C991D7858716db09f58', '0xA1290d69c65A6Fe4DF752f95823fae25cB99e5A7', '0xA1290d69c65A6Fe4DF752f95823fae25cB99e5A7', 'rsETH' , 18),
    ('LayerZero', '0x211Cc4DD073734dA055fbF44a2b4667d5E5fE5d2', '0x9D39A5DE30e57443BfF2A8307A4256c8797A3497', '0x9D39A5DE30e57443BfF2A8307A4256c8797A3497', 'sUSDe' , 18),
    ('LayerZero', '0x5d3a1Ff2b6BAb83b63cd9AD0787074081a52ef34', '0x4c9EDD5852cd905f086C759E8383e09bff1E68B3', '0x4c9EDD5852cd905f086C759E8383e09bff1E68B3', 'USDe' , 18),
    ('LayerZero', '0x58538e6A46E07434d7E7375Bc268D3cb839C0133', '0x57e114B691Db790C35207b2e685D4A43181e6061', '0x57e114B691Db790C35207b2e685D4A43181e6061', 'ENA' , 18),
    ('LayerZero', '0xbcE9988376C6b9c0c035bdbc9060568031d51130', '0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599', '0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599', 'stBTC' , 18), -- using WBTC price feed, this is the oft

    ('HyperLane', '0xa166219df110bda97b91e65d4bb4aae4159978b9', '0xbf5495Efe5DB9ce00f80364C8B423567e58d2110', '0xbf5495Efe5DB9ce00f80364C8B423567e58d2110', 'ezETH' , 18),
    ('HyperLane', '0x982abbb04f91acc47ad0cb0a11f29d50c5007934', '0x8c9532a60E0E7C6BbD2B2c1303F63aCE1c3E9811', '0x8c9532a60E0E7C6BbD2B2c1303F63aCE1c3E9811', 'pzETH' , 18),
    ('HyperLane', '0xfa3198ecf05303a6d96e57a45e6c815055d255b1', '0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599', '0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599', 'uBTC' , 18), -- using WBTC price feed
    ('HyperLane', '0x93d41e41ca545a35a81d11b08d2ee8b852c768df', '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48', '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48', 'USDC' , 6),
    ('HyperLane', '0xb89c6ed617f5f46175e41551350725a09110bbce', '0xdAC17F958D2ee523a2206206994597C13D831ec7', '0xdAC17F958D2ee523a2206206994597C13D831ec7', 'USDT' , 6),
    ('Canonical', '0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000', '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', 'ETH' , 18),
    -- ('Canonical', 0xb5668713E9BA8bC96f97D691663E70b54CE90b0A, 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2, 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2, 'ETH' , 18),
    ('Lido' , '0x7c98E0779EB5924b3ba8cE3B17648539ed5b0Ecc', '0x7f39C581F595B53c5cb19bD0b3f8dA6c935E2Ca0', '0x7f39C581F595B53c5cb19bD0b3f8dA6c935E2Ca0', 'wstETH' , 18),
    ('', '0x00', '0x00', '0x00', 'lol', 1)
    ) as b(bridge, swellchain_address, eth_address, eth_price_address, symbol, decimals)
    )
    SELECT
    -- TOPICS[0],
    ORIGIN_FUNCTION_SIGNATURE,
    TX_HASH
    -- count(*)
    FROM swell.core.fact_event_logs
    Last run: 2 months ago
    ORIGIN_FUNCTION_SIGNATURE
    TX_HASH
    1
    0x0c252b030x3a505c23f7422b70e9e3f2b3e39d347ef1bb2e2c32ecdec66f2240c2b83a4e23
    2
    0x0e7527020xbef9fec215ce039364752d0b731e32fa883cdfa118c80af563d3d982809c3388
    3
    0x1ab27b950xddc25726b39794443e7325c7f9d7d076692b54338be4901166398faf43b49306
    4
    0x1b2c4b780xfd16361918306dd672a20e8888844a37a069e90ab17a63f432274f56a48049da
    5
    0x219f5d170x0ba8f539e6585c5d4aedee1cbb889c57aaa4e1cd77a5c59fc6c841bdaf677e09
    6
    0x2f4f21e20x1656a37d333d9012222ceaf5eeb0638adad8b407d84687a1771d491c7dc5b02c
    7
    0x2fce96860xe9915cf7b656e0e25c6e9df5c9476be979178ce9fda0dc0865812783792a2dd3
    8
    0x3cdd6eeb0xca3c7705777b66ba48a3660b3a483aeebbb91987dff177359ab1bf6ccb6c4485
    9
    0xa0712d680xd61dc2034b7d25a5a95de24806b2cd47edc35ab29e53464c25c7bae166fa025f
    10
    0xa15112f90x05ca5f27bdeade8d1bd4be60615e2511c53861ee6fc43118e14618f87861780a
    11
    0x852a12e30xde22df0ab2793b41e45f2feef621fd993b94b1e25caf7245c3e06d8be46d2b5c
    12
    0x8c42f5aa0x151fa4d8b5975f0b9afdf897b99f03e21736630b913cf8912e38c7f3f0e93ba2
    13
    0x936743960x35a7b38019c80fc313fb6b937349a00e6f9fbbdf829728b0387a5a677cd5c39d
    14
    0x3d719cd90x3823e01fee40784245df05b92bd5bad8603280d76a85a2754b8eb3e9a1ca03a5
    15
    0x42c1132c0x3f56b17dc2ab0cd77c48cf9f50d5e4e22033500ade596056c07242062e9e7df3
    16
    0x45c37e140xe50d24e320b36fa587c94caa6c77321938c28fe60e9be183574cb1f84243094c
    17
    0x6138889b0x209cdc09c7524d94a43881d3f3e15d068e76bdbad3fc95415996617b78d0be71
    18
    0x6a7612020x5466eb9688f1dd0080012461299b9b3dc28f2f8771a2c72e5e31346d1b2b1e9c
    19
    0x7625391a0xb52b438934e61cf0f3cd1d61821a2e95426a9a1fba3acd340aa857c299073634
    20
    0x7715ee750x5c9755301fc330e2d01cb99af7a1c703aadc7d1697a7793f9e3e16a6ea3a55d5
    37
    3KB
    1s