select
address,
balance/pow(10,decimal) as total_amount,
rank() over (partition by date order by total_amount desc) as rank
from osmosis.core.fact_daily_balances
where currency = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
and date >= '2022-09-27'
qualify rank <= 10