Query editor
WITH params AS (SELECT100000000000 AS total_supply,0.10 AS genesis_pct,0.40 AS eco_pct,0.25 AS team_pct,0.25 AS inv_pct),months AS (SELECT monthFROM UNNEST(SEQUENCE(0, 48)) AS t(month)),calc AS (SELECTm.month,-- Genesis: fully unlocked at month 0(p.total_supply * p.genesis_pct) AS genesis_unlocked,-- Ecosystem: 8% instant + 32% linear over 36 monthsCASEWHEN m.month = 0 THEN p.total_supply * 0.08WHEN m.month <= 36 THEN (p.total_supply * 0.08)+ (p.total_supply * 0.32) * (m.month / 36.0)ELSE (p.total_supply * 0.40)END AS ecosystem_unlocked,-- Team: 12-month cliff, then 36-month linear vestCASEWHEN m.month < 12 THEN 0WHEN m.month <= 48 THEN (p.total_supply * p.team_pct) * ((m.month - 12) / 36.0)ELSE (p.total_supply * p.team_pct)END AS team_unlocked,-- Investors: same vesting model as teamCASEWHEN m.month < 12 THEN 0WHEN m.month <= 48 THEN (p.total_supply * p.inv_pct) * ((m.month - 12) / 36.0)ELSE (p.total_supply * p.inv_pct)END AS investors_unlockedFROM months mCROSS JOIN params p)SELECTmonth,genesis_unlocked as "Genesis Allocation",ecosystem_unlocked as "Ecosystem Allocation",team_unlocked as "Team Allocation",investors_unlocked as "Investor Allocation",(genesis_unlocked + ecosystem_unlocked + team_unlocked + investors_unlocked)AS total_unlockedFROM calcORDER BY month;