Updated 2022-04-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date_trunc('day',balance_date) as dt,
SYMBOL as token,
sum(balance) as token_fund,
sum(amount_usd) as fund_USD
from ethereum.erc20_balances
where contract_address in ( 'ETH', --- Ether
'0x7e9d8f07a64e363e97a648904a89fb4cd5fb94cd', --FF
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48')--USDC
and user_address = lower('0x2Fb9F0ef424b24a8D293999298F392a33Fe6A8b5') --forefront
and dt between '2022-02-22' and '2022-03-25' ---start of season 2
group by 1,2
Run a query to Download Data