Query editor
WITH filter_balances_not_zero AS (SELECTtoken_balance_owner,token_balance,cast(date_trunc('day', day) as date) as balance_dateFROMsolana_utils.daily_balancesWHEREtoken_mint_address = 'Bo9jh3wsmcC2AjakLWzNmKJ3SgtZmXEcSaW7L2FAvUsU'AND token_balance <> 0),ranked_balances AS (SELECTtoken_balance_owner,balance_date,ROW_NUMBER() OVER (PARTITION BY token_balance_ownerORDER BY balance_date ASC) as rnFROMfilter_balances_not_zero),first_date as (SELECTtoken_balance_owner,MIN(balance_date) as last_dateFROMranked_balancesWHERErn = 1GROUP BYtoken_balance_owner)selectlb.token_balance_owner as holder,lb.token_balance,(lb.token_balance/(select 10e8 - sum(amount)/1e8 as burned_libra fromtokens_solana.transferswhere action = 'burn'and token_mint_address = 'Bo9jh3wsmcC2AjakLWzNmKJ3SgtZmXEcSaW7L2FAvUsU'))*100 as concentracion,date_diff('day', lta.last_date, cast(date_trunc('day', now()) as date)) as dias_holderFROM solana_utils.latest_balances lbLEFT JOIN first_date lta on lta.token_balance_owner = lb.token_balance_ownerWHERE lb.token_mint_address = 'Bo9jh3wsmcC2AjakLWzNmKJ3SgtZmXEcSaW7L2FAvUsU'AND lb.token_balance != 0order by concentracion desc