DATE | TXS | SWAPPERS | AMOUNT | |
|---|---|---|---|---|
1 | 2025-02-25 00:00:00.000 | 54 | 4 | 370.153082991 |
2 | 2025-02-26 00:00:00.000 | 129 | 9 | 4089.338368753 |
3 | 2025-02-27 00:00:00.000 | 169 | 19 | 1178.850365114 |
4 | 2025-02-28 00:00:00.000 | 248 | 12 | 1291.006377944 |
5 | 2025-03-01 00:00:00.000 | 106 | 8 | 1843.87571361 |
6 | 2025-03-02 00:00:00.000 | 309 | 15 | 3970.535563002 |
7 | 2025-03-03 00:00:00.000 | 181 | 16 | 3568.198921054 |
8 | 2025-03-04 00:00:00.000 | 317 | 17 | 8929.817760758 |
9 | 2025-03-05 00:00:00.000 | 148 | 16 | 4893.848533948 |
10 | 2025-03-06 00:00:00.000 | 408 | 30 | 71417.492899767 |
11 | 2025-03-07 00:00:00.000 | 271 | 29 | 92888.402704075 |
12 | 2025-03-08 00:00:00.000 | 167 | 25 | 14161.287316164 |
13 | 2025-03-09 00:00:00.000 | 315 | 21 | 25057.785025756 |
14 | 2025-03-10 00:00:00.000 | 628 | 22 | 54866.712832618 |
15 | 2025-03-11 00:00:00.000 | 829 | 37 | 151254.279270467 |
16 | 2025-03-12 00:00:00.000 | 1323 | 35 | 75728.969957494 |
17 | 2025-03-13 00:00:00.000 | 186 | 42 | 78283.942775598 |
18 | 2025-03-14 00:00:00.000 | 149 | 26 | 86575.292017962 |
19 | 2025-03-15 00:00:00.000 | 49 | 18 | 25742.1501708 |
20 | 2025-03-16 00:00:00.000 | 113 | 27 | 61381.720041594 |
mamad-5XN3k3Velodrome Swell 2 (daily activities)
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: 2 months ago
37
2KB
7s