Query editor
select day 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 (select day, token_balance,row_number() over (partition by day order by token_balance desc) as rnfrom solana_utils.daily_balanceswhere token_mint_address = 'jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL' -- JTOand day > now() - interval '365' day and token_balance > 0) group by day order by day