dan-smithCRV - Supply Schedule
    Updated 2022-12-29
    WITH
    crv_schedule AS (
    SELECT
    *
    ,total_liq_incentives + total_early_users + total_core_team + total_investors + total_employees + total_reserve AS total_supply
    ,liq_incentives + early_users + core_team + investors + employees + reserve AS daily_emissions
    FROM (
    SELECT
    *
    ,SUM(liq_incentives) OVER(ORDER BY time) AS total_liq_incentives
    ,SUM(early_users) OVER(ORDER BY time) AS total_early_users
    ,SUM(core_team) OVER(ORDER BY time) AS total_core_team
    ,SUM(investors) OVER(ORDER BY time) AS total_investors
    ,SUM(employees) OVER(ORDER BY time) AS total_employees
    ,SUM(reserve) OVER(ORDER BY time) AS total_reserve
    FROM (
    SELECT
    time
    ,CASE WHEN time <= '2021-08-13' THEN 752918.583561644 -- year 1
    WHEN time <= '2022-08-13' THEN 633126.537894891 -- year 2
    WHEN time <= '2023-08-13' THEN 532393.836117809 -- year 3
    WHEN time <= '2024-08-13' THEN 446464.876851211 -- year 4
    WHEN time <= '2025-08-13' THEN 376459.291780822 -- year 5
    WHEN time <= '2026-08-13' THEN 316563.268947446 -- year 6
    WHEN time <= '2027-08-13' THEN 266196.918058904 -- year 7
    WHEN time <= '2028-08-13' THEN 223232.438425606 -- year 8
    WHEN time <= '2029-08-13' THEN 188229.645890411 -- year 9
    WHEN time <= '2030-08-13' THEN 158281.634473723 -- year 10
    ELSE 133098.459029452 --CODE WILL BREAK ON 2031-08-15
    END AS liq_incentives
    ,CASE WHEN time <= '2021-08-13' THEN 415110.00436772 -- year 1
    ELSE 0
    END AS early_users
    ,CASE WHEN time <= '2021-08-13' THEN 548603.529712329 -- year 1
    WHEN time <= '2022-08-13' THEN 548603.529712329 -- year 2
    WHEN time <= '2023-08-13' THEN 548603.529712329 -- year 3
    Run a query to Download Data