Query editor
selectday as time_period,sum(if(rn <= 100, token_balance, 0)) / nullif(sum(token_balance), 0) as top100_share,sum(if(rn <= 10, token_balance, 0)) / nullif(sum(token_balance), 0) as top10_sharefrom (selectday,token_balance,row_number() over (partition by day order by token_balance desc) as rnfrom solana_utils.daily_balanceswhere token_mint_address = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'and day > now() - interval '365' dayand token_balance > 0)group by dayorder by day