USER | WETH | weETH | pzETH | ezETH | wstETH | rswETH | swETH | rsETH | Supplied | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 0x43e9fa7a60f80711c9d3afe4ce1bb3e8c3f7a9b8 | 4356816 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4356816 |
2 | 0x29dfdd80d6acc0f9028d8a6fa7d7d448342e25c1 | 0 | 0 | 0 | 528706 | 0 | 0 | 0 | 0 | 528706 |
3 | 0xa6086e3190c145f1b6b089de98b1866296137a50 | 441153 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 441153 |
4 | 0x1d607e4eb747f1294ae632d3490f121b00db9312 | 0 | 0 | 0 | 0 | 0 | 0 | 432637 | 0 | 432637 |
5 | 0x5b9effdcbd65946f2b143725dc244563248aa4ee | 0 | 365222 | 0 | 0 | 0 | 0 | 0 | 0 | 365222 |
6 | 0xacae46375cef811bab8f3d572b2dab327085c609 | 0 | 361068 | 0 | 0 | 0 | 0 | 0 | 0 | 361068 |
7 | 0x5c0642fe68fc72cf03f676b28faf5cf97cc0b265 | 0 | 0 | 0 | 0 | 344141 | 0 | 0 | 0 | 344141 |
8 | 0x19391f0a0d3b6409e57faef5f62bc509433b3d2e | 301240 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 301240 |
9 | 0x1d607e4eb747f1294ae632d3490f121b00db9312 | 0 | 0 | 0 | 0 | 0 | 187123 | 0 | 0 | 187123 |
10 | 0xc81b6381bf13ac1dd80ad44775958c91bf962502 | 0 | 0 | 0 | 182372 | 0 | 0 | 0 | 0 | 182372 |
11 | 0xe18b7e20c0b9a8fa16c20911b706be8dc69d3485 | 0 | 0 | 0 | 0 | 0 | 0 | 121986 | 0 | 121986 |
12 | 0xfbf73c3622668cfe655faff8fcb9876015001a5e | 0 | 0 | 0 | 0 | 0 | 93562 | 0 | 0 | 93562 |
13 | 0xf84651a665bb9ad7bbc6b931c7cbb16eafc2a318 | 0 | 36070 | 0 | 0 | 0 | 0 | 0 | 0 | 36070 |
14 | 0x9342174252e8ae1de46abefc1b930e21a3cbcf55 | 0 | 28854 | 0 | 0 | 0 | 0 | 0 | 0 | 28854 |
15 | 0x052d0e4db4ed2f34d0c51a44fe92eee0eb805238 | 0 | 25474 | 0 | 0 | 0 | 0 | 0 | 0 | 25474 |
16 | 0x5275817b74021e97c980e95ede6bbac0d0d6f3a2 | 0 | 0 | 0 | 0 | 0 | 24303 | 0 | 0 | 24303 |
17 | 0x6f5a30e72b5f611ddaf39a87e6c13f37c7aa8ceb | 0 | 0 | 18081 | 0 | 0 | 0 | 0 | 0 | 18081 |
18 | 0x5275817b74021e97c980e95ede6bbac0d0d6f3a2 | 0 | 16206 | 0 | 0 | 0 | 0 | 0 | 0 | 16206 |
19 | 0x327b9dee1830f8201efa751fd96f7b1ad0b300a1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14523 | 14523 |
20 | 0x1d565c9104d576b5b5882e472a2a9042bcb68a02 | 0 | 0 | 0 | 0 | 0 | 0 | 13766 | 0 | 13766 |
mamad-5XN3k3Euler Swell Users
Updated 2025-04-05
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 pricet as (
select
distinct TOKEN_ADDRESS,
SYMBOL as sym,
PRICE
from crosschain.price.ez_prices_hourly
join (
select
TOKEN_ADDRESS as max_token,
max(HOUR) as max_hour
from crosschain.price.ez_prices_hourly
group by 1
) on TOKEN_ADDRESS = max_token and max_hour = hour
where token_address in ('0xa1290d69c65a6fe4df752f95823fae25cb99e5a7','0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee',
'0xfae103dc9cf190ed75350761e95403b7b8afa6c0','0x4c9edd5852cd905f086c759e8383e09bff1e68b3',
'0xbf5495efe5db9ce00f80364c8b423567e58d2110','0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0',
'0x8c9532a60e0e7c6bbd2b2c1303f63ace1c3e9811','0xf951e335afb289353dc249e82926178eac7ded78',
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2','0x9d39a5de30e57443bff2a8307a4256c8797a3497',
'0x0a6e7ba5042b38349e437ec6db6214aec7b35676'
)
),
pools as (
select
CONTRACT_ADDRESS as pool,
concat('0x', substr(topics[2], 24 + 3, 32 + 8)) as asset
from swell.core.fact_event_logs
where topics[0] = '0x0cd345140b9008a43f99a999a328ece572a0193e8c8bf5f5755585e6f293b85e'
)
select *
from(
select
distinct user,
case when symbol = 'WETH' then round(net_supplied,0) else 0 end as "WETH",
case when symbol = 'WEETH' then round(net_supplied,0) else 0 end as "weETH",
Last run: 11 days ago
...
204
14KB
26s