flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
masoud-moj
Untitled Query
Updated 2021-11-19
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
balance_date
,
user_address
,
contract_address
,
symbol
,
balance
,
amount_usd
FROM
ethereum
.
erc20_balances
WHERE
user_address
=
lower
(
'0x2c99f7Ad7762A9504316935700290624239268E6'
)
AND
balance_date
>=
current_date
-
30
ORDER
BY
1
DESC
Results
Run a query to Download Data