TIER | Total Addresses | Total tier Withdraw (USD) | |
|---|---|---|---|
1 | 1-10 USD | 3 | 12.498588701 |
2 | 10-100 USD | 9 | 392.818420966 |
3 | 100-1k USD | 19 | 7080.754943724 |
4 | 10k-100k USD | 32 | 1556027.33859411 |
5 | 1k-10k USD | 26 | 118812.846465723 |
6 | >100k USD | 25 | 30214225.7308468 |
7 | less than 1 USD | 5 | 0.6073093252 |
MrftiWithdraw analysis
Updated 2 hours ago
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
›
⌄
-- forked from Depositors analysis @ https://flipsidecrypto.xyz/studio/queries/d72d2940-0d9b-452e-95a0-f5f78ff68ac3
with alldata AS
(
WITH assettbl AS (
SELECT
origin_from_address AS user,
DATE_TRUNC('day', block_timestamp) AS 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,
contract_address,
event_name,
SUM(decoded_log:assets / POW(10, 18)) AS amount
FROM
swell.core.ez_decoded_event_logs
WHERE
event_name IN ('Deposit', 'Borrow', 'Repay', 'Withdraw')
AND origin_to_address = '0x08739cbede6e28e387685ba20e6409bd16969cde'
GROUP BY 1, 2, 3, 4, 5
),
pricetbl AS (
SELECT
DATE_TRUNC('day', hour) AS date,
symbol,
AVG(price) AS price
FROM
crosschain.price.ez_prices_hourly
WHERE
Last run: about 2 hours agoAuto-refreshes every 12 hours
7
234B
92s