binhachonCurve Distribution Chart
Updated 2021-11-10
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
›
⌄
--SELECT USER_ADDRESS, ADDRESS_NAME, LABEL_TYPE, LABEL_SUBTYPE, BALANCE FROM ethereum.erc20_balances
SELECT
CASE
-- WHEN LABEL_SUBTYPE LIKE 'escrow%' THEN 'Escrow'
WHEN USER_ADDRESS = '0xd2d43555134dc575bf7279f4ba18809645db0f1d' THEN 'Curve Vesting Escrow'
WHEN USER_ADDRESS = '0xd2d43555134dc575bf7279f4ba18809645db0f1d' THEN 'Curve Vesting Escrow'
WHEN USER_ADDRESS = '0xe3997288987e6297ad550a69b31439504f513267' THEN 'Curve Vesting Escrow'
WHEN USER_ADDRESS = '0x575ccd8e2d300e2377b43478339e364000318e2c' THEN 'Curve Vesting Escrow'
WHEN USER_ADDRESS = '0x2a7d59e327759acd5d11a8fb652bf4072d28ac04' THEN 'Curve Vesting Escrow'
WHEN USER_ADDRESS = '0x679fcb9b33fc4ae10ff4f96caef49c1ae3f8fa67' THEN 'Curve Vesting Escrow'
WHEN USER_ADDRESS = '0x41df5d28c7e801c4df0ab33421e2ed6ce52d2567' THEN 'Curve Vesting Escrow'
WHEN USER_ADDRESS = '0xf22995a3ea2c83f6764c711115b23a88411cafdd' THEN 'Curve Vesting Escrow'
WHEN USER_ADDRESS = '0x81930d767a75269dc0e9b83938884e342c1fa5f6' THEN 'Curve Vesting Escrow'
WHEN USER_ADDRESS = '0xf7dbc322d72c1788a1e37eee738e2ea9c7fa875e' THEN 'Curve Vesting Escrow'
WHEN USER_ADDRESS = '0x629347824016530fcd9a1990a30658ed9a04c834' THEN 'Curve Vesting Escrow'
WHEN USER_ADDRESS = '0x5f3b5dfeb7b28cdbd7faba78963ee202a494e2a2' THEN 'Cureve Voting Escrow'
WHEN LABEL_SUBTYPE LIKE 'hot_wallet%' THEN 'Centralized Exchanges'
WHEN LABEL_SUBTYPE LIKE 'deposit_wallet%' THEN 'Centralized Exchanges'
ELSE 'Other' END as LABEL_SUBTYPE,
SUM(BALANCE) as TOTAL
FROM
ethereum.erc20_balances
--WHERE CONTRACT_ADDRESS = '0xd533a949740bb3306d119cc777fa900ba034cd52'
WHERE CONTRACT_LABEL = 'curve fi'
AND BALANCE_DATE >= getdate() - INTERVAL'1 day'
--AND USER_ADDRESS = '0x5f3b5dfeb7b28cdbd7faba78963ee202a494e2a2'
--AND LABEL_SUBTYPE = 'escrow'
GROUP BY 1
ORDER BY TOTAL DESC
LIMIT 90000
Run a query to Download Data