CONTRACT_NAME | TOTAL_DEPOSIT_TRANSACTIONS | TOTAL_DEPOSITORS | TOTAL_DEPOSITS_USD | |
|---|---|---|---|---|
1 | EVK Vault eWETH-1 | 541 | 156 | 23931521.277711 |
2 | Wrapped Ether | 12828 | 1284 | 21227596.9912767 |
3 | EVK Vault eweETH-1 | 218 | 65 | 14529055.2447669 |
4 | EVK Vault eezETH-1 | 137 | 55 | 4804654.28778654 |
5 | EVK Vault epzETH-1 | 44 | 24 | 3331037.32958512 |
6 | tsRSwellSwell | 155 | 105 | 2767002.21051915 |
7 | EVK Vault eswETH-1 | 47 | 32 | 1306788.08371253 |
8 | EVK Vault ewstETH-1 | 185 | 30 | 914024.23162129 |
9 | EVK Vault erswETH-1 | 77 | 46 | 796602.170698268 |
10 | EVK Vault ersETH-1 | 64 | 29 | 573181.022509994 |
11 | tsWeethRsETH | 24 | 21 | 161135.291772331 |
12 | tsSwellETH | 89 | 21 | 144538.1271423 |
13 | tsPzethEzeth | 17 | 10 | 142881.807928816 |
14 | tsEnaUsde | 43 | 20 | 21850.81323435 |
15 | tsRswethWeeth | 18 | 16 | 18592.985436948 |
16 | EVK Vault eWETH-2 | 1 | 1 | 81.276025 |
17 | 9 | 8 | 0.0001 | |
18 | veNFT | 102 | 44 | 0 |
datavortexBy Asset
Updated 2025-02-09
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 D1 AS (
SELECT DISTINCT
contract_name,
contract_address,
origin_from_address AS depositor,
CASE
WHEN decoded_log:wad IS NOT NULL
THEN (decoded_log:wad::int)
ELSE (decoded_log:assets::int)
END AS deposit_amount,
tx_hash,
DATE_TRUNC('day', block_timestamp) AS deposit_date
FROM swell.core.ez_decoded_event_logs
WHERE event_name = 'Deposit'
),
D2 AS (
SELECT DISTINCT
contract_name,
contract_address,
origin_from_address AS depositor,
(decoded_log:assets[1]::int) AS deposit_amount,
tx_hash,
DATE_TRUNC('day', block_timestamp) AS deposit_date
FROM swell.core.ez_decoded_event_logs
WHERE event_name = 'Deposits'
AND tx_hash NOT IN (SELECT tx_hash FROM D1)
),
prices AS (
SELECT
LOWER(name) AS name,
LOWER(symbol) AS symbol,
DATE_TRUNC('day', hour) AS price_date,
AVG(price) AS price,
Last run: 19 days ago
18
726B
2s