Crazzy_SidETH: Percent of Addresses in Profit and Loss
Updated 2024-10-15
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
›
⌄
WITH AddressProfitLoss AS (
SELECT
USER_ADDRESS AS Address,
SUM(CASE
WHEN USD_VALUE_NOW > USD_VALUE_LAST_ACTIVITY THEN 1
ELSE 0
END) AS In_Profit,
SUM(CASE
WHEN USD_VALUE_NOW < USD_VALUE_LAST_ACTIVITY THEN 1
ELSE 0
END) AS In_Loss
FROM
ethereum.core.ez_current_balances
WHERE
MODIFIED_TIMESTAMP >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY
USER_ADDRESS
)
SELECT
(SUM(In_Profit) * 100.0) / COUNT(*) AS Percent_In_Profit,
(SUM(In_Loss) * 100.0) / COUNT(*) AS Percent_In_Loss
FROM
AddressProfitLoss;
QueryRunArchived: QueryRun has been archived