WEEK | Depositors | Deposit Transactions | Average Deposit (USD) | Max Deposit (USD) | Median Deposit (USD) | Withdrawers | Withdraw Transactions | Average Withdraw (USD) | Max Withdraw (USD) | Median Withdraw (USD) | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-12-23 00:00:00.000 | 1421 | 2755 | 48204.096762759 | 58956790.6528806 | 41.194848579 | 378 | 549 | 50253.34402303 | 10517695.6126402 | 275.686419618 |
2 | 2025-01-27 00:00:00.000 | 485 | 1304 | 6137.971348315 | 2819858.10406857 | 13.928727243 | 514 | 736 | 20739.192981 | 5897983.84225272 | 189.212258967 |
3 | 2025-01-06 00:00:00.000 | 1470 | 2177 | 4701.418506044 | 4833000 | 8.355199828 | 751 | 993 | 10632.914601795 | 873292.213759345 | 33.404540301 |
4 | 2025-02-03 00:00:00.000 | 198 | 433 | 7611.904620442 | 1392872.72427367 | 16.832718333 | 252 | 333 | 104454.194310463 | 31771056.3122393 | 161.839238353 |
5 | 2025-01-13 00:00:00.000 | 562 | 1082 | 5494.277972713 | 315524.170608753 | 25.071709037 | 400 | 669 | 14911.840810146 | 1258332.20935743 | 349.473951137 |
6 | 2024-12-16 00:00:00.000 | 1441 | 3281 | 37370.902014069 | 33063794.255956 | 93.756036336 | 170 | 251 | 9802.594092322 | 313229.848190257 | 194.069136216 |
7 | 2025-01-20 00:00:00.000 | 445 | 1567 | 3761.604178987 | 2745849.04060565 | 9.75010907 | 680 | 862 | 22185.384488884 | 9674690.90909091 | 74.364344088 |
8 | 2024-11-25 00:00:00.000 | 1 | 4 | 89.492072535 | 334.289453826 | 10.446545432 | |||||
9 | 2024-12-09 00:00:00.000 | 49 | 97 | 330.055327742 | 13928.727242737 | 13.928727243 | 21 | 31 | 278.052048006 | 2879.701750048 | 26.859403281 |
10 | 2024-12-30 00:00:00.000 | 2618 | 3361 | 21137.236418586 | 19332000 | 2.783687804 | 591 | 812 | 14815.325164246 | 2058685.08984428 | 111.701663167 |
11 | 2024-12-02 00:00:00.000 | 7 | 221 | 566.268087316 | 10585.83270448 | 222.859635884 |
hess5. Weekly Numbers
Updated 2025-02-06
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 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: 2 months ago
11
1KB
8s