flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Daily number of whales
nits
Daily number of whales
Updated 2022-02-05
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
balance_date
,
count
(
DISTINCT
user_address
)
as
number_of_whales
from
(
select
*
from
ethereum
.
erc20_balances
where
contract_address
=
'0x6b3595068778dd592e39a122f4f5a5cf09c90fe2'
and
balance
>=
pow
(
10
,
6
)
)
GROUP
by
1
limit
1000
Results
Run a query to Download Data