apostleoffinance$LAB: Holders Classification by Wallet Balance
Updated 2024-08-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
--$LAB Token Address is factory/osmo17fel472lgzs87ekt9dvk0zqyh5gl80sqp4sk4n/LAB
SELECT
Date,
COUNT(DISTINCT address) AS token_holders,
CASE
WHEN BALANCE/1000000 < 10 THEN '1. Under 10 $LAB'
WHEN BALANCE/1000000 BETWEEN 10 AND 20 THEN '2. Between 10 - 20 $LAB'
WHEN BALANCE/1000000 BETWEEN 20 AND 100 THEN '3. Between 20 - 100 $LAB'
WHEN BALANCE/1000000 BETWEEN 100 AND 1000 THEN '4. Between 100 - 1000 $LAB'
WHEN BALANCE/1000000 > 1000 THEN '5. More then 1000 $LAB'
END AS wallet_balances
FROM osmosis.core.fact_daily_balances
WHERE --balance_type = 'staked'
--AND
currency = 'factory/osmo17fel472lgzs87ekt9dvk0zqyh5gl80sqp4sk4n/LAB'
AND date >= '2024-04-04'
GROUP BY 1,3
ORDER BY 1 DESC, 3
--LIMIT 10
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived