maybeyonaslido_eth_balance
Updated 2022-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with
st_eth_bals as(
select *
from ethereum.erc20_balances
where contract_address ='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
and balance_date >= getdate() - interval '90 days'
)--,
-- beth_bals as(
-- select *
-- from ethereum.erc20_balances
-- where contract_address ='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
-- and user_address = '0xa2f987a546d4cd1c607ee8141276876c26b72bdf'
-- and balance_date in (select * from today)
-- )
select
balance_date,
sum(balance) as total_steth,
sum(amount_usd) as total_usd_val
from st_eth_bals
group by 1
Run a query to Download Data