mboveiriUntitled Query
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
--balance_date,
user_address,
balance as balance_jan,
rank () over (order by balance_jan desc ) as rank_jan
from flipside_prod_db.ethereum.erc20_balances
where contract_address=lower('0x2e9d63788249371f1dfc918a52f8d799f4a38c94')
and balance_date = last_day(to_date({{timeline}}))
order by rank_jan
limit 20
Run a query to Download Data