Query editor
WITH phase1_allocation AS (SELECT balanceFROM query_6236490WHERE regexp_extract(address, '>(0x[0-9a-fA-F]+)<', 1) = CAST({{user_address}} as varchar)UNION ALLSELECT balanceFROM query_6236501WHERE regexp_extract(address, '>(0x[0-9a-fA-F]+)<', 1) = CAST({{user_address}} as varchar)),tot AS (SELECT SUM(balance) AS balanceFROM phase1_allocation),points AS (SELECTMAX_BY(cumulative_points, day) AS cp,strategyFROM query_6240144GROUP BY strategy),phase1_share AS (SELECT(SUM(CASE WHEN strategy IN ('USDT Phase 1', 'frxUSD Phase 1') THEN cp END) * 1.0) /NULLIF(SUM(cp), 0) AS shareFROM points),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 phase1_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;