binhachonUntitled Query
Updated 2021-11-30
9
1
2
3
4
5
6
7
8
›
⌄
-- select balance_date, count(*), count_if(balance = 0), count_if(balance = lag(balance,1,0) over (partition by address_name order by balance_date)) from ethereum.erc20_balances
-- where balance_date > getdate() - interval'3 days'
-- group by balance_date
select *, lag(balance,1,0) over (partition by address_name, contract_address order by balance_date) as balance_0 from ethereum.erc20_balances
where user_address = '0x3b7cbba9715a4cd4e11679d96ded6a930f38df6c'
and balance_date > getdate() - interval'3 days'
Run a query to Download Data