Query editor
WITH phase2_allocation AS (SELECT balanceFROM query_6236709WHERE regexp_extract(address, '>(0x[0-9a-fA-F]+)<', 1) = CAST({{user_address}} as varchar)),tot AS (SELECT (SUM(balance)-1000)*(500000000/1137245113.647409) AS balanceFROM phase2_allocation),points AS (SELECTMAX_BY(cumulative_points, day) AS cp,strategyFROM query_6240144GROUP BY strategy),phase2_share AS (SELECTcp * 1.0 / NULLIF((SELECT SUM(cp) FROM points), 0) AS shareFROM pointsWHERE strategy = 'USDC Phase 2'),multipliers AS (SELECTalloc,allocation_pct,alloc * 2.4 * share / 825000000 AS m_24b,alloc * 8.8 * share / 825000000 AS m_open,alloc * 16.7 * share / 825000000 AS m_peak,alloc * {{custom_valuation_in_billions}} * share / 825000000 AS m_userFROM (VALUES(0.03, '3%'),(0.05, '5%'),(0.075, '7.5%')) AS v(alloc, allocation_pct)CROSS JOIN phase2_share)SELECTalloc,allocation_pct,balance * m_24b*1000000000 AS "$2.4B FDV",balance * m_open*1000000000 AS "$XPL Open ($8.8B FDV)",balance * m_peak*1000000000 AS "$XPL Peak ($16.7B FDV)",balance * m_user*1000000000 AS "User set FDV"FROM totCROSS JOIN multipliersORDER BY alloc;