TOPIC_0 | TOTAL_AMOUNT_SWETH | AVG_AMOUNT_SWETH | TOTAL_AMOUNT_USD | AVG_AMOUNT_USD | LARGEST_TRANSACTION_AMOUNT_USD | UNIQUE_USERS_COUNT | NUMBER_OF_TRANSACTIONS | AVG_TRANSACTIONS_PER_USER | HIGHEST_DAILY_TRANSACTIONS | AVG_DAILY_TRANSACTIONS | HIGHEST_DAILY_USERS | HIGHEST_DAILY_VOLUME_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Borrow | 50.645714 | 4.220476166667 | 86513.0086548 | 7209.417387901 | 20503.422108 | 7 | 12 | 1.714285714 | 5 | 2.833333 | 2 | 50137.7745024 |
2 | Deposit | 313.929517 | 6.679351425532 | 536254.4009394 | 11409.668105094 | 291211.8058746 | 31 | 47 | 1.516129032 | 8 | 3.468085 | 8 | 291211.8058746 |
3 | Repay | 19.209587 | 3.201597833333 | 32813.8165134 | 5468.969418899 | 20506.044195 | 5 | 6 | 1.2 | 2 | 1.333333 | 1 | 20506.044195 |
4 | Withdraw | 209.956585 | 8.075253269231 | 358647.838497 | 13794.1476345 | 290394 | 19 | 26 | 1.368421053 | 3 | 1.538462 | 2 | 291211.8058746 |
Updated 2025-04-07
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
transactions AS (
SELECT
block_timestamp,
tx_hash,
CASE
WHEN TOPIC_0 = LOWER('0xfbde797d201c681b91056529119e0b02407c7bb96a4a2c75c01fc9667232c8db') THEN decoded_log:assets::int
WHEN TOPIC_0 = LOWER('0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7') THEN decoded_log:assets::int
WHEN TOPIC_0 = LOWER('0xcbc04eca7e9da35cb1393a6135a199ca52e450d5e9251cbd99f7847d33a36750') THEN decoded_log:assets::int
WHEN TOPIC_0 = LOWER('0x5c16de4f8b59bd9caf0f49a545f25819a895ed223294290b408242e72a594231') THEN decoded_log:assets::int
END AS amount,
CASE
WHEN TOPIC_0 = LOWER('0xfbde797d201c681b91056529119e0b02407c7bb96a4a2c75c01fc9667232c8db') THEN 'Withdraw'
WHEN TOPIC_0 = LOWER('0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7') THEN 'Deposit'
WHEN TOPIC_0 = LOWER('0xcbc04eca7e9da35cb1393a6135a199ca52e450d5e9251cbd99f7847d33a36750') THEN 'Borrow'
WHEN TOPIC_0 = LOWER('0x5c16de4f8b59bd9caf0f49a545f25819a895ed223294290b408242e72a594231') THEN 'Repay'
END AS TOPIC_0,
origin_from_address AS user_address
FROM swell.core.ez_decoded_event_logs
WHERE
CONTRACT_NAME = 'EVK Vault eswETH-1'
AND CONTRACT_ADDRESS = LOWER('0xf34253ec3dd0cb39c29cf5eeb62161fb350a9d14')
AND ORIGIN_FUNCTION_SIGNATURE = '0xc16ae7a4'
AND TOPIC_0 IN (
LOWER('0xfbde797d201c681b91056529119e0b02407c7bb96a4a2c75c01fc9667232c8db'),
LOWER('0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7'),
LOWER('0xcbc04eca7e9da35cb1393a6135a199ca52e450d5e9251cbd99f7847d33a36750'),
LOWER('0x5c16de4f8b59bd9caf0f49a545f25819a895ed223294290b408242e72a594231')
)
),
swETH_prices AS (
SELECT
swETH_p
FROM (
SELECT
Last run: 21 days ago
4
484B
6s