piperAddresses with more then 1000 $LAB
Updated 2024-10-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from Holders / Mints @ https://flipsidecrypto.xyz/edit/queries/2c8829c6-9f82-43de-acb1-7c87b42f03c0
-- forked from Holder Distribution by Balances @ https://flipsidecrypto.xyz/edit/queries/9db335ec-a641-40b0-90fc-7043037f8a3a
/* $LAB Holders/Balances over time */
SELECT
ADDRESS,
ROUND(BALANCE/1000000, 1) AS BALANCE
FROM
osmosis.core.fact_daily_balances
WHERE
DATE >= CURRENT_DATE
AND
CURRENCY = 'factory/osmo17fel472lgzs87ekt9dvk0zqyh5gl80sqp4sk4n/LAB'
AND
BALANCE/1000000 > 1000
ORDER BY BALANCE DESC
QueryRunArchived: QueryRun has been archived