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