Date | LPing Txns Count | LPers Count | LPing Volume ($USD) | Pool Name | |
|---|---|---|---|---|---|
1 | 2025-02-24 00:00:00.000 | 1 | 1 | 3.97538275 | vAMM-WETH/USDe |
2 | 2025-02-24 00:00:00.000 | 1 | 1 | 0.5231013474 | vAMM-SWELL/USDe |
3 | 2025-02-24 00:00:00.000 | 1 | 1 | 0.3716232 | CL1-WETH/wstETH |
4 | 2025-02-25 00:00:00.000 | 26 | 2 | 538.584769639 | vAMM-SWELL/USDe |
5 | 2025-02-25 00:00:00.000 | 3 | 2 | 3458.24292135 | vAMM-WETH/XVELO |
6 | 2025-02-25 00:00:00.000 | 7 | 3 | 4281.398830854 | CL1-WETH/wstETH |
7 | 2025-02-25 00:00:00.000 | 31 | 4 | 10496.759657762 | vAMM-WETH/USDe |
8 | 2025-02-26 00:00:00.000 | 2 | 2 | 503.204944967 | CL1-wstETH/rsETH |
9 | 2025-02-26 00:00:00.000 | 81 | 5 | 13575.737989072 | vAMM-WETH/USDe |
10 | 2025-02-26 00:00:00.000 | 42 | 3 | 4038.964339431 | vAMM-SWELL/USDe |
11 | 2025-02-26 00:00:00.000 | 3 | 2 | 3561.651987894 | CL1-WETH/weETH |
12 | 2025-02-26 00:00:00.000 | 17 | 2 | 4385.319672609 | CL1-WETH/wstETH |
13 | 2025-02-26 00:00:00.000 | 5 | 2 | 360.444638445 | vAMM-WETH/XVELO |
14 | 2025-02-26 00:00:00.000 | 15 | 3 | 546.64656759 | CL1-ezETH/wstETH |
15 | 2025-02-26 00:00:00.000 | 10 | 3 | 5558.187792661 | CL1-rswETH/WETH |
16 | 2025-02-27 00:00:00.000 | 24 | 5 | 1072.382598364 | vAMM-SWELL/USDe |
17 | 2025-02-27 00:00:00.000 | 58 | 11 | 28145.92233572 | vAMM-WETH/XVELO |
18 | 2025-02-27 00:00:00.000 | 18 | 8 | 63391.483621406 | CL1-WETH/wstETH |
19 | 2025-02-27 00:00:00.000 | 5 | 4 | 77.665465144 | CL1-ezETH/wstETH |
20 | 2025-02-27 00:00:00.000 | 3 | 2 | 55262.379364038 | CL1-rswETH/WETH |
Eman-RazLiquidity Providing over Time
Updated 2025-04-05
99
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 final_table as (
with add_liquidity_table as (
with tab1 as (SELECT
block_timestamp, tx_hash, origin_from_address,
lower(PARSE_JSON(full_decoded_log):"address"::STRING) AS contract_address,
PARSE_JSON(full_decoded_log):"data"[0]:"value"::STRING AS from_address,
PARSE_JSON(full_decoded_log):"data"[1]:"value"::STRING AS to_address,
(PARSE_JSON(full_decoded_log):"data"[2]:"value"::NUMBER)/pow(10,18) AS amount
from swell.core.ez_decoded_event_logs
where tx_succeeded='TRUE' and event_name='Transfer')
select date_trunc('hour',block_timestamp) as date, origin_from_address as user, tx_hash, amount as input_volume, contract_address, case
when contract_address=lower('0x5d3a1Ff2b6BAb83b63cd9AD0787074081a52ef34') then 'USDe'
when contract_address=lower('0x4200000000000000000000000000000000000006') then 'WETH'
when contract_address=lower('0x7c98E0779EB5924b3ba8cE3B17648539ed5b0Ecc') then 'wstETH'
when contract_address=lower('0x18d33689AE5d02649a859A1CF16c9f0563975258') then 'rswETH'
when contract_address=lower('0x7f9AdFbd38b669F03d1d11000Bc76b9AaEA28A81') then 'XVELO'
when contract_address=lower('0xc2606AADe4bdd978a4fa5a6edb3b66657acEe6F8') then 'KING'
when contract_address=lower('0xc3eACf0612346366Db554C991D7858716db09f58') then 'rsETH'
when contract_address=lower('0x2416092f143378750bb29b79eD961ab195CcEea5') then 'ezETH'
when contract_address=lower('0xA6cB988942610f6731e664379D15fFcfBf282b44') then 'weETH'
when contract_address=lower('0x2826D136F5630adA89C1678b64A61620Aab77Aea') then 'SWELL'
end as symbol, case
when to_address=lower('0x6F96C6F73147DB99716A0328eda2b6bfF136CdB8') then 'vAMM-WETH/USDe'
when to_address=lower('0x22c360c7D52925A02a07FD6814eb02bb3a9bEBB0') then 'CL1-WETH/wstETH'
when to_address=lower('0xf495610d64FA6a32C5F968c947028f9C7Cacfb19') then 'CL1-rswETH/WETH'
when to_address=lower('0xFfFB9B7509da106c5542C71cB314C1CF38D37F36') then 'vAMM-WETH/XVELO'
when to_address=lower('0x5cf08c03f28a0134B55C790f804FaCA52a86d23B') then 'vAMM-WETH/KING'
when to_address=lower('0xd91A9926C9eDB79D30D9950c8375575ebEcF2486') then 'CL1-wstETH/rsETH'
when to_address=lower('0x27BaE97405D3E23c87aa2F9041c6896af1aD8747') then 'CL1-ezETH/wstETH'
when to_address=lower('0x818eC3274C43A45Ca588b485794644438a3F4653') then 'CL1-WETH/weETH'
when to_address=lower('0xeab009A8f12F059FA028dee5e9e516A0C150BD41') then 'vAMM-SWELL/USDe'
end as pool_name
from tab1
where (to_address=lower('0x6F96C6F73147DB99716A0328eda2b6bfF136CdB8') -- vAMM-WETH/USDe
or to_address=lower('0x22c360c7D52925A02a07FD6814eb02bb3a9bEBB0') -- CL1-WETH/wstETH
Last run: 3 months ago
...
327
21KB
6s