dan-smithCRV - Supply Schedule
Updated 2022-12-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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