jackguyxmetric 2
Updated 2023-08-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
›
⌄
SELECT
-- CASE
-- WHEN xmetric_volume < 500 THEN 'a Group 1 (0-500)'
-- WHEN xmetric_volume >= 500 AND xmetric_volume < 2000 THEN 'b Group 2 (500-2,000)'
-- WHEN xmetric_volume >= 2000 AND xmetric_volume < 5000 THEN 'c Group 2 (2,000-4999)'
-- WHEN xmetric_volume >= 5000 AND xmetric_volume < 10000 THEN 'd Group 3 (5,000-9999)'
-- WHEN xmetric_volume >= 10000 AND xmetric_volume < 20000 THEN 'e Group 4 (10,000-20,000)'
-- WHEN xmetric_volume >= 50000 AND xmetric_volume < 50000 THEN 'f Group 5 (20,000-49,999)'
-- else 'g Group 7 (50,000+)'
-- END AS UserGroup,
COUNT(*) AS UsersCount,
avg(xmetric_volume) as avg_xmetric_balance,
median(xmetric_volume) as median_xmetric_balance
FROM (
SELECT
TO_ADDRESS,
sum(AMOUNT) as xmetric_volume
FROM polygon.core.ez_token_transfers
WHERE contract_address LIKE lower('0x15848C9672e99be386807b9101f83A16EB017bb5')
GROUP BY 1
) as t
--GROUP BY UserGroup
--ORDER BY UserGroup;
Run a query to Download Data