pinehearstHop Supply - Vesting
Updated 2022-12-23
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
›
⌄
with dates as (
select
distinct to_date(date_day) as date
from
crosschain.core.dim_dates
where
to_date(date_day) >= '2022-06-09' and date_day <= '2026-06-09'
)
select
date,
605000000 as "Treasury",
28000000 as "Future Team",
-- airdrop
case when date < '2023-06-09' then 60000000 when date >= '2023-06-09'
and date <= '2026-06-09' then 80000000 else 0 end as "Airdrop",
-- team
0 as team_ini,
case when date < '2023-06-09' then 0
when date >= '2023-06-09'and date <= '2026-06-09' then 224500000 /(datediff('day', '2023-06-09', '2026-06-09')) else 0 end as daily_team_vesting,
-- investors
0 as investors_ini,
case when date < '2023-06-09' then 0
when date >= '2023-06-09'and date <= '2026-06-09' then 62500000 /(datediff('day', '2023-06-09', '2026-06-09')) else 0 end as daily_investors_vesting,
sum(daily_team_vesting) over (
order by
date
) as "Team",
sum(daily_investors_vesting) over (
order by
date
) as "Investors"
from
dates
order by 1 desc
Run a query to Download Data