ilyasStep 3: What is your historical balance?
Updated 2021-12-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- Using what we just learned in the previous query for labels:
-- Come up with a solution that would show the balance of all Binance labeled addresses for USDC
-- Use the Visual Builder by pressing 'New Visual' in the top right corner, to create a line chart to show the trend over the last 30 days!
-- Share your query in Discord!
SELECT
balance_date,
user_address,
contract_address,
symbol,
balance,
amount_usd
FROM ethereum.erc20_balances
WHERE user_address = lower('0x39C1dcc1C41D6F8842c612B60dFcA093ad0906E5')
AND balance_date >= current_date - 30
ORDER BY 1 DESC
Run a query to Download Data