sunslinger7423 Daily Balance
Updated 2022-06-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- 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('0x5970C498244CE30248711497b7886fecA0077423')
AND balance_date >= '2021-03-18' and balance_date <= '2021-09-01'
and symbol in ('ETH','USDC')
ORDER BY 1 DESC
Run a query to Download Data