with balances as
(SELECT
balance_date,
user_address,
balance,
rank() over (partition by user_address order by balance_date desc) as pick
FROM
ethereum.erc20_balances
WHERE erc20_balances.contract_address = lower('0x8798249c2e607446efb7ad49ec89dd1865ff4272')
order by erc20_balances.user_address, erc20_balances.balance_date desc
limit 10000)
select
balance_date,
user_address,
balance as tokens
from
balances
where pick = 1
order by balances.balance desc;
-- select
-- *
-- from
-- ethereum.erc20_balances
-- limit 10