maybeyonasbalancer_aave
Updated 2022-10-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with
bal_pool as(
select
balance_date,
symbol,
balance,
amount_usd
from ethereum.erc20_balances
where user_address = '0xc697051d1c6296c24ae3bcef39aca743861d9a81'
),
total as(
select
balance_date,
'TOTAL' as symbol,
sum(balance) as amount_usd,
sum(amount_usd) as amount_usd
from bal_pool
group by balance_date
)
select * from bal_pool
union all
select * from total
Run a query to Download Data