flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2023-03-18 04:10 PM
NakedCollector
2023-03-18 04:10 PM
Updated 2023-03-18
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
USER_ADDRESS
as
wallet
,
(
balance
/
POWER
(
10
,
18
)
)
as
balance
from
ethereum
.
core
.
fact_token_balances
where
contract_address
=
'0x23b608675a2b2fb1890d3abbd85c5775c51691d5'
and
BALANCE
>
0
and
BLOCK_TIMESTAMP
>=
'2023-03-17'
order
by
balance
desc
Results
Run a query to Download Data