holding_pattern | num_users | total_cycles | avg_holding_period_days | total_deposited_amount | total_withdrawn_amount | total_deposited_usd | total_withdrawn_usd | |
|---|---|---|---|---|---|---|---|---|
1 | Short-Term (< 7 days) | 91 | 1890 | 1.83 | 18189.28 | 13912.93 | 40972251.94 | 33539035.69 |
Mrftidirty-green
Updated 17 hours ago
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 deposits AS (
SELECT
origin_from_address AS "user",
DATE_TRUNC('day', block_timestamp) AS "deposit_date",
CASE
WHEN contract_name = 'EVK Vault eswETH-1' THEN 'SWETH'
WHEN contract_name = 'EVK Vault epzETH-1' THEN 'PZETH'
WHEN contract_name = 'EVK Vault eweETH-1' THEN 'WEETH'
WHEN contract_name = 'EVK Vault eezETH-1' THEN 'EZETH'
WHEN contract_name = 'EVK Vault eWETH-1' THEN 'WETH'
WHEN contract_name = 'EVK Vault ersETH-1' THEN 'RSETH'
WHEN contract_name = 'EVK Vault erswETH-1' THEN 'RSWETH'
WHEN contract_name = 'EVK Vault ewstETH-1' THEN 'WSTETH'
END AS "token",
SUM(decoded_log:assets / POW(10, 18)) AS "deposit_amount",
block_timestamp AS "deposit_timestamp",
tx_hash AS "deposit_tx"
FROM
swell.core.ez_decoded_event_logs
WHERE
event_name = 'Deposit'
AND origin_to_address = '0x08739cbede6e28e387685ba20e6409bd16969cde'
AND block_timestamp > '2025-01-27 00:00:00.000'
GROUP BY 1, 2, 3, 5, 6
),
withdrawals AS (
SELECT
origin_from_address AS "user",
DATE_TRUNC('day', block_timestamp) AS "withdraw_date",
CASE
WHEN contract_name = 'EVK Vault eswETH-1' THEN 'SWETH'
WHEN contract_name = 'EVK Vault epzETH-1' THEN 'PZETH'
WHEN contract_name = 'EVK Vault eweETH-1' THEN 'WEETH'
WHEN contract_name = 'EVK Vault eezETH-1' THEN 'EZETH'
WHEN contract_name = 'EVK Vault eWETH-1' THEN 'WETH'
WHEN contract_name = 'EVK Vault ersETH-1' THEN 'RSETH'
Last run: about 17 hours agoAuto-refreshes every 12 hours
1
82B
372s