ASSET | TOTAL_DEPOSITS_USD | TOTAL_WITHDRAWALS_USD | NET_FLOW_USD | |
|---|---|---|---|---|
1 | Wrapped Ether | 13701374.951816 | 3096329.55575444 | 10605045.3960616 |
2 | tsPzethEzeth | 125121.72727288 | 0 | 125121.72727288 |
3 | tsWeethRsETH | 99232.7851346 | 0 | 99232.7851346 |
4 | tsEnaUsde | 14487.192268 | 0 | 14487.192268 |
5 | tsSwellETH | 0.08605107628 | 0 | 0.08605107628 |
6 | veNFT | 0 | 0 | 0 |
7 | EVK Vault eweETH-1 | 0 | 0 | 0 |
8 | EVK Vault eswETH-1 | 0 | 0 | 0 |
9 | EVK Vault erswETH-1 | 0 | 0 | 0 |
10 | EVK Vault ewstETH-1 | 0 | 0 | 0 |
11 | EVK Vault eezETH-1 | 0 | 0 | 0 |
12 | EVK Vault eWETH-1 | 0 | 0 | 0 |
13 | EVK Vault epzETH-1 | 0 | 0 | 0 |
14 | EVK Vault ersETH-1 | 0 | 0 | 0 |
datavortexenchanting-coffee
Updated 2025-02-08
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 Deposits AS (
SELECT
contract_name,
contract_address,
CASE
WHEN decoded_log:wad IS NOT NULL
THEN (decoded_log:wad::int)
WHEN decoded_log:assets IS NOT NULL
THEN CAST(PARSE_JSON(decoded_log:assets)[0] AS BIGINT)
END AS deposit_amount
FROM swell.core.ez_decoded_event_logs
WHERE event_name IN ('Deposit', 'Deposits')
),
Withdrawals AS (
SELECT
contract_name,
contract_address,
CASE
WHEN decoded_log:wad IS NOT NULL
THEN (decoded_log:wad::int)
WHEN decoded_log:assets IS NOT NULL
THEN CAST(PARSE_JSON(decoded_log:assets)[0] AS BIGINT)
END AS withdrawal_amount
FROM swell.core.ez_decoded_event_logs
WHERE event_name IN ('Withdraw', 'Withdrawal')
),
prices AS (
SELECT
LOWER(name) AS name,
LOWER(symbol) AS symbol,
price,
decimals,
ROW_NUMBER() OVER (PARTITION BY LOWER(symbol) ORDER BY hour DESC) AS rn
FROM ethereum.price.ez_prices_hourly
Last run: 3 months ago
14
503B
4s