0xHaM-dchristian-turquoise
Updated 2025-02-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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