POOL_NAME | CONTRACT_ADDRESS | TXS | SWAPPERS | AMOUNT | |
|---|---|---|---|---|---|
1 | WETH/weETH | 0x818ec3274c43a45ca588b485794644438a3f4653 | 687 | 109 | 2638542.3681508 |
2 | rswETH/WETH | 0xf495610d64fa6a32c5f968c947028f9c7cacfb19 | 503 | 96 | 875322.53610006 |
3 | WETH/USDe | 0x6f96c6f73147db99716a0328eda2b6bff136cdb8 | 5674 | 165 | 262621.12362012 |
4 | SWELL/USDe | 0xeab009a8f12f059fa028dee5e9e516a0c150bd41 | 1547 | 143 | 189052.405567223 |
5 | WETH/wstETH | 0x22c360c7d52925a02a07fd6814eb02bb3a9bebb0 | 535 | 89 | 97686.93449021 |
6 | WETH/XVELO | 0xfffb9b7509da106c5542c71cb314c1cf38d37f36 | 731 | 95 | 46825.64334626 |
7 | WETH/KING | 0x5cf08c03f28a0134b55c790f804faca52a86d23b | 132 | 33 | 18077.51445181 |
8 | wstETH/rsETH | 0xd91a9926c9edb79d30d9950c8375575ebecf2486 | 152 | 21 | 14066.73864044 |
9 | ezETH/wstETH | 0x27bae97405d3e23c87aa2f9041c6896af1ad8747 | 195 | 57 | 9398.89988847 |
10 | WETH/rsETH | 0xfc9e8c37745656124106806a45eb8a4565b1e5c1 | 50 | 8 | 37.43623662 |
11 | ezETH/WETH | 0xf05b706826b50122b35cafd31c95ff7a3d6d078e | 11 | 3 | 4.94874674 |
12 | USDe/rUSDC | 0xf1c0e9f805270de0bce9cfec5a8395c7c65fe254 | 1 | 1 | 0.01 |
13 | WETH/USDe | 0xa021c812c3c7bc7812d395e47f0d3c141407a6ef | 1 | 1 | 0 |
mamad-5XN3k3Velodrome Swell 3 (pools)
Updated 2025-04-02
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
date_trunc('hour', hour) as pdate,
TOKEN_ADDRESS,
case
when token_address = '0x0a6e7ba5042b38349e437ec6db6214aec7b35676' then 'SWELL'
when token_address = '0x4300000000000000000000000000000000000004' then 'WETH'
when token_address = '0xbf5495efe5db9ce00f80364c8b423567e58d2110' then 'ezETH'
when token_address = '0x4c9edd5852cd905f086c759e8383e09bff1e68b3' then 'USDe'
when token_address = '0xa1290d69c65a6fe4df752f95823fae25cb99e5a7' then 'rsETH'
--when token_address = '0xc2606aade4bdd978a4fa5a6edb3b66657acee6f8' then 'KING'
when token_address = '0x9560e827af36c94d2ac33a39bce1fe78631088db' then 'XVELO'
when token_address = '0xfae103dc9cf190ed75350761e95403b7b8afa6c0' then 'rswETH'
when token_address = '0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee' then 'weETH'
when token_address = '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0' then 'wstETH'
else symbol end as sym,
avg(price) as avg_price
from crosschain.price.ez_prices_hourly
where token_address in ('0x0a6e7ba5042b38349e437ec6db6214aec7b35676','0x4300000000000000000000000000000000000004',
'0xbf5495efe5db9ce00f80364c8b423567e58d2110','0x4c9edd5852cd905f086c759e8383e09bff1e68b3',
'0xa1290d69c65a6fe4df752f95823fae25cb99e5a7','0x9560e827af36c94d2ac33a39bce1fe78631088db',
'0xfae103dc9cf190ed75350761e95403b7b8afa6c0','0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee',
'0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0')
and hour::date >= '2025-01-01'
group by 1,2,3
),
pool_creationt as (
select
--*,
concat('0x', substr(topics[1], 24 + 3, 32 + 8)) as token_0,
concat('0x', substr(topics[2], 24 + 3, 32 + 8)) as token_1,
regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS pool_data,
concat('0x', substr(pool_data[0], 25, 40)) as pool
from swell.core.fact_event_logs
where (contract_address = lower('0x31832f2a97Fd20664D76Cc421207669b55CE4BC0')
Last run: 24 days ago
13
1KB
48s