hess0. TVL Weekly
    Updated 10 days ago
    with bonk as (select * from (values
    ('LayerZero', '0x18d33689ae5d02649a859a1cf16c9f0563975258', '0xfae103dc9cf190ed75350761e95403b7b8afa6c0', '0xfae103dc9cf190ed75350761e95403b7b8afa6c0', 'rswETH' , 18),
    ('Canonical', '0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000', '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', 'ETH' , 18),
    ('HyperLane', '0x2416092f143378750bb29b79ed961ab195cceea5', '0xbf5495efe5db9ce00f80364c8b423567e58d2110', '0xbf5495efe5db9ce00f80364c8b423567e58d2110', 'ezETH' , 18),
    ('Lido' , '0x7c98e0779eb5924b3ba8ce3b17648539ed5b0ecc', '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0', '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0', 'wstETH' , 18),
    ('HyperLane', '0x9cb41cd74d01ae4b4f640ec40f7a60ca1bcf83e7', '0x8c9532a60e0e7c6bbd2b2c1303f63ace1c3e9811', '0x8c9532a60e0e7c6bbd2b2c1303f63ace1c3e9811', 'pzETH' , 18),
    ('LayerZero', '0xc3eacf0612346366db554c991d7858716db09f58', '0xa1290d69c65a6fe4df752f95823fae25cb99e5a7', '0xa1290d69c65a6fe4df752f95823fae25cb99e5a7', 'rsETH' , 18),
    ('LayerZero', '0x09341022ea237a4db1644de7ccf8fa0e489d85b7', '0xf951e335afb289353dc249e82926178eac7ded78', '0xf951e335afb289353dc249e82926178eac7ded78', 'swETH' , 18),
    ('LayerZero', '0xa6cb988942610f6731e664379d15ffcfbf282b44', '0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee', '0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee', 'weETH' , 18),
    ('LayerZero', '0x1cf7b5f266a0f39d6f9408b90340e3e71df8bf7b', '0x8db2350d78abc13f5673a411d4700bcf87864dde', '0x8db2350d78abc13f5673a411d4700bcf87864dde', 'swBTC' , 8),
    ('LayerZero', '0x939f1cc163fdc38a77571019eb4ad1794873bf8c', '0x358d94b5b2f147d741088803d932acb566acb7b6', '0x0a6e7ba5042b38349e437ec6db6214aec7b35676', 'rSWELL' , 18),
    ('LayerZero', '0x2826d136f5630ada89c1678b64a61620aab77aea', '0x0a6e7ba5042b38349e437ec6db6214aec7b35676', '0x0a6e7ba5042b38349e437ec6db6214aec7b35676', 'SWELL' , 18),
    ('LayerZero', '0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2', '0x9d39a5de30e57443bff2a8307a4256c8797a3497', '0x9d39a5de30e57443bff2a8307a4256c8797a3497', 'sUSDe' , 18),
    ('LayerZero', '0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34', '0x4c9edd5852cd905f086c759e8383e09bff1e68b3', '0x4c9edd5852cd905f086c759e8383e09bff1e68b3', 'USDe' , 18),
    ('LayerZero', '0x58538e6a46e07434d7e7375bc268d3cb839c0133', '0x57e114b691db790c35207b2e685d4a43181e6061', '0x57e114b691db790c35207b2e685d4a43181e6061', 'ENA' , 18),
    ('LayerZero', '0xf6718b2701d4a6498ef77d7c152b2137ab28b8a3', '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599', '0xf6718b2701d4a6498ef77d7c152b2137ab28b8a3', 'stBTC' , 18),
    ('LayerZero', '0x3a8909dccf2ecefa2688df93d5c3680a5b20b93b', '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599', '0xf6718b2701d4a6498ef77d7c152b2137ab28b8a3', 'stBTC' , 18),
    ('LayerZero', '0x75a931fbee73591e15dcd5e9cabfa5a7f14b4c7c', '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599', '0xf6718b2701d4a6498ef77d7c152b2137ab28b8a3', 'stBTC' , 18),
    ('HyperLane', '0xfa3198ecf05303a6d96e57a45e6c815055d255b1', '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599', '0xf6718b2701d4a6498ef77d7c152b2137ab28b8a3', 'uBTC' , 18),
    ('HyperLane', '0x93d41e41ca545a35a81d11b08d2ee8b852c768df', '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', 'USDC' , 6),
    ('HyperLane', '0xb89c6ed617f5f46175e41551350725a09110bbce', '0xdac17f958d2ee523a2206206994597c13d831ec7', '0xdac17f958d2ee523a2206206994597c13d831ec7', 'USDT' , 6))
    as b (bridge, swellchain_address, eth_address, eth_price_address, symbol, decimals))
    ,
    price as ( select hour::date as date, -- UBTC SWELL
    case when a.symbol = 'WETH' then 'ETH'
    when a.symbol = 'STBTC' then 'stBTC'
    when a.symbol = 'SUSDE' then 'sUSDe'
    when a.symbol = 'PZETH' then 'pzETH'
    when a.symbol = 'RSETH' then 'rsETH'
    when a.symbol = 'USDE' then 'USDe'
    when a.symbol = 'SWBTC' then 'swBTC'
    when a.symbol = 'RSWETH' then 'rswETH'
    when a.symbol = 'WETHW' then 'ETH'
    when a.symbol = 'SWETH' then 'swETH'
    when a.symbol = 'WSTETH' then 'wstETH'
    when a.symbol = 'EZETH' then 'ezETH'
    Last run: 10 days ago
    DAILY
    Deposit
    Withdraw
    CUM_DEP
    CUM_WI
    TVL
    1
    2024-12-23 00:00:00.0002269363.33901962-648641.72287625984314129.0746014-2506693.8227495981807435.2518518
    2
    2025-02-18 00:00:00.000759765.280519593-88505.864880254264676121.611639-93294776.2131831171381345.398456
    3
    2025-01-14 00:00:00.0001425466.96520008-2174034.24286608237861613.401959-40385604.66179197476008.740169
    4
    2024-12-07 00:00:00.0001807.019115078017.030548902078017.030548902
    5
    2025-01-08 00:00:00.000590632.037042033-947882.85284469229630999.622769-31574157.3209488198056842.30182
    6
    2025-01-15 00:00:00.000823224.940153804-622731.989318881238684838.342113-41008336.6511088197676501.691004
    7
    2025-01-24 00:00:00.000197304.083157772-431502.30829168244894028.57749-50185105.6840615194708922.893429
    8
    2025-02-28 00:00:00.000288702.272157302-95951.962164964268935475.42933-101658037.16993167277438.2594
    9
    2025-03-11 00:00:00.00059148.173219869-387344.05608249272512068.436678-104806196.15307167705872.283609
    10
    2025-02-01 00:00:00.0001985084.29573374-442231.745124438250496981.702963-58724878.3847176191772103.318245
    11
    2024-12-08 00:00:00.000486.64161078503.672158902078503.672158902
    12
    2025-03-25 00:00:00.000279712.49435329-4441813.90337708279011499.791348-203122619.13992275888880.6514261
    13
    2025-03-04 00:00:00.000365167.433366598-76713.60402913270055645.753017-101994665.653925168060980.099092
    14
    2025-02-13 00:00:00.00056432.177620629-296466.766472344262946490.79059-91756611.4086734171189879.381916
    15
    2024-11-29 00:00:00.0004.4564250229.0602450229.060245
    16
    2025-02-23 00:00:00.000250918.197320139-283158.321078981267273614.536728-100078548.640609167195065.896119
    17
    2025-02-06 00:00:00.0001354083.27851184-526829.257563675252727657.224047-84369475.7899793168358181.434068
    18
    2024-12-26 00:00:00.00028482843.1550066-7758750.99092301162411427.336383-14654888.4338802147756538.902503
    19
    2025-01-26 00:00:00.000177283.625428118-214586.366198943245113856.032037-50502135.1001001194611720.931937
    20
    2025-03-07 00:00:00.000572280.337657402-63544.014638547271586509.669351-103765784.740541167820724.92881
    ...
    126
    14KB
    46s