N_BRIDGES | N_USERS | DEPOSIT_VOLUME_USD | WITHDRAW_VOLUME_USD | NET_VOLUME_USD | |
|---|---|---|---|---|---|
1 | 8416 | 1320 | 274264287.016875 | -128742618.908433 | 145521668.108442 |
0xHaM-dLayer Zero in Total
Updated 2025-02-09
999
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', 'rswETH' , 18),
('LayerZero', '0x09341022ea237a4DB1644DE7CCf8FA0e489D85B7', '0xf951E335afb289353dc249e82926178EaC7DEd78', 'swETH' , 18),
('LayerZero', '0xA6cB988942610f6731e664379D15fFcfBf282b44', '0xCd5fE23C85820F7B72D0926FC9b05b43E359b7ee', 'weETH' , 18),
('LayerZero', '0x1cf7b5f266A0F39d6f9408B90340E3E71dF8BF7B', '0x8DB2350D78aBc13f5673A411D4700BCF87864dDE', 'swBTC' , 8),
('LayerZero', '0x939f1cC163fDc38a77571019eb4Ad1794873bf8c', '0x0a6E7Ba5042B38349e437ec6Db6214AEC7B35676', 'rSWELL' , 18),
('LayerZero', '0x2826D136F5630adA89C1678b64A61620Aab77Aea', '0x0a6E7Ba5042B38349e437ec6Db6214AEC7B35676', 'SWELL' , 18),
-- ('LayerZero', 0xf6718b2701D4a6498eF77D7c152b2137Ab28b8A3, 0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599, 'stBTC' , 18), -- using WBTC price feed, this is actual asset
('LayerZero', '0xc3eACf0612346366Db554C991D7858716db09f58', '0xA1290d69c65A6Fe4DF752f95823fae25cB99e5A7', 'rsETH' , 18),
('LayerZero', '0x211Cc4DD073734dA055fbF44a2b4667d5E5fE5d2', '0x9D39A5DE30e57443BfF2A8307A4256c8797A3497', 'sUSDe' , 18),
('LayerZero', '0x5d3a1Ff2b6BAb83b63cd9AD0787074081a52ef34', '0x4c9EDD5852cd905f086C759E8383e09bff1E68B3', 'USDe' , 18),
('LayerZero', '0x58538e6A46E07434d7E7375Bc268D3cb839C0133', '0x57e114B691Db790C35207b2e685D4A43181e6061', 'ENA' , 18),
('LayerZero', '0xbcE9988376C6b9c0c035bdbc9060568031d51130', '0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599', 'stBTC' , 18) -- using WBTC price feed, this is the oft
) as b(bridge, swellchain_address, token_address, symbol, decimals)
)
, evenTb as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
ORIGIN_FROM_ADDRESS,
ORIGIN_TO_ADDRESS,
ORIGIN_FUNCTION_SIGNATURE,
CONTRACT_ADDRESS,
DATA,
symbol,
token_address,
ethereum.public.udf_hex_to_int(DATA)/pow(10, decimals) as amount,
FROM swell.core.fact_event_logs
JOIN map_data on CONTRACT_ADDRESS ilike swellchain_address
WHERE bridge = 'LayerZero'
AND TOPICS[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND ORIGIN_FUNCTION_SIGNATURE in ('0x8c42f5aa','0xc7c7f5b3','0xcfc32570')
AND TX_SUCCEEDED = TRUE
)
,
Last run: 2 months ago
1
65B
28s