piperHolders / Mints
Updated 2024-10-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from Holder Distribution by Balances @ https://flipsidecrypto.xyz/edit/queries/9db335ec-a641-40b0-90fc-7043037f8a3a
/* $LAB Holders/Balances over time */
SELECT
DATE,
SUM(BALANCE)/1000000/10 AS total_balance,
COUNT(DISTINCT ADDRESS) AS holders
FROM
osmosis.core.fact_daily_balances
WHERE
DATE >= '2024-04-04'
AND
CURRENCY = 'factory/osmo17fel472lgzs87ekt9dvk0zqyh5gl80sqp4sk4n/LAB'
AND
BALANCE/1000000 >= 10
AND
BALANCE/1000000 <= 1000
GROUP BY DATE
ORDER BY DATE DESC
QueryRunArchived: QueryRun has been archived