Query editor
WITH total_supply AS (SELECTSUM(token_balance) AS total_balance_supplyFROMsolana_utils.daily_balancesWHEREtoken_mint_address = '7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr'),holder_balances AS (SELECTtoken_balance_owner AS holder_address,SUM(token_balance) AS holder_balance,MAX(block_time) AS last_active_dateFROMsolana_utils.daily_balancesWHEREtoken_mint_address = '7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr'GROUP BYtoken_balance_owner)SELECThb.holder_address,hb.holder_balance,ROUND((hb.holder_balance / ts.total_balance_supply), 4) AS balance_percentage,hb.last_active_dateFROMholder_balances hbCROSS JOINtotal_supply tsORDER BYhb.holder_balance DESCLIMIT 100;