Query editor
WITH token_launches AS (SELECTtoken_mint_address,MIN(block_time) as launch_timeFROM tokens_solana.transfersWHERE token_mint_address = '4rWuWZei2iFNHYpnz5wjMeSvimsJcj5EgpSNvNS1pump'AND block_time > NOW() - INTERVAL '5' dayGROUP BY token_mint_address),holder_balances AS (SELECTto_owner as holder,SUM(CAST(amount AS DOUBLE)) / 1e6 as balance,MIN(block_time) as first_tx_timeFROM tokens_solana.transfersWHERE token_mint_address = '4rWuWZei2iFNHYpnz5wjMeSvimsJcj5EgpSNvNS1pump'AND block_time > NOW() - INTERVAL '5' dayAND to_owner != '6EF8rrecthR5DkZJv9RKad96u3KdeC1LyD7L26Y6S51'GROUP BY to_ownerUNION ALLSELECTfrom_owner as holder,-1 * SUM(CAST(amount AS DOUBLE)) / 1e6 as balance,MIN(block_time) as first_tx_timeFROM tokens_solana.transfersWHERE token_mint_address = '4rWuWZei2iFNHYpnz5wjMeSvimsJcj5EgpSNvNS1pump'AND block_time > NOW() - INTERVAL '5' dayAND from_owner != '6EF8rrecthR5DkZJv9RKad96u3KdeC1LyD7L26Y6S51'GROUP BY from_owner),aggregated_balances AS (SELECTholder,SUM(balance) as total_balance,MIN(first_tx_time) as first_tx_timeFROM holder_balancesGROUP BY holderHAVING SUM(balance) > 0.01),total_supply_calc AS (SELECT SUM(total_balance) as total_supplyFROM aggregated_balances),holders_with_pct AS (SELECTab.holder,ab.total_balance,(ab.total_balance / ts.total_supply) * 100 as pct_of_supply,ab.first_tx_timeFROM aggregated_balances abCROSS JOIN total_supply_calc ts),categorized_holders AS (SELECThwp.holder,hwp.total_balance,hwp.pct_of_supply,CASE