EP1 | EPOCH_INDEX | Epoch | Bonds amount | Bonding programmes supply | Available emissions | |
|---|---|---|---|---|---|---|
1 | 1 | 2023-05 | 1 = 2023-05 | 0 | ||
2 | 2 | 2023-06 | 2 = 2023-06 | 0 | ||
3 | 3 | 2023-07 | 3 = 2023-07 | 1023397.02832047 | ||
4 | 4 | 2023-08 | 4 = 2023-08 | 3749726.93475359 | ||
5 | 5 | 2023-09 | 5 = 2023-09 | 277789.961806355 | ||
6 | 6 | 2023-10 | 6 = 2023-10 | 2049091.67167314 | ||
7 | 7 | 2023-11 | 7 = 2023-11 | 2598937.55694348 | ||
8 | 8 | 2023-12 | 8 = 2023-12 | 474124.273050126 | ||
9 | 9 | 2024-02 | 9 = 2024-02 | 115540.224636071 | ||
10 | 10 | 2024-03 | 10 = 2024-03 | 331151.468565541 | ||
11 | 11 | 2024-04 | 11 = 2024-04 | 94698.805092221 | ||
12 | 12 | 2024-05 | 12 = 2024-05 | 37655.995167302 | ||
13 | 13 | 2024-06 | 13 = 2024-06 | 0 | ||
14 | 14 | 2024-07 | 14 = 2024-07 | 0 | ||
15 | 15 | 2024-08 | 15 = 2024-08 | 0 | ||
16 | 16 | 2024-09 | 16 = 2024-09 | 4.063474009 | ||
17 | 17 | 2024-10 | 17 = 2024-10 | 1258967.01273953 | ||
18 | 18 | 2024-11 | 18 = 2024-11 | 223062.525139807 |
Flipside TeamEmission to bonders
Updated 2 hours ago
999
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 t_index as (select *
from (VALUES
('1', '2023-05'),
('2', '2023-06'),
('3', '2023-07'),
('4', '2023-08'),
('5', '2023-09'),
('6', '2023-10'),
('7', '2023-11'),
('8', '2023-12'),
('9', '2024-02'),
('10', '2024-03'),
('11', '2024-04'),
('12', '2024-05'),
('13', '2024-06'),
('14', '2024-07'),
('15', '2024-08'),
('16', '2024-09'),
('17', '2024-10'),
('18', '2024-11')
) AS t (Epoch, epoch_index)
),
epoches as (
select
DATE_DAY,
case
when DATE_DAY<'2023-05-03' then 1
when DATE_DAY>='2023-05-03' and DATE_DAY<'2023-06-28' then 2
when DATE_DAY>='2023-06-28' and DATE_DAY<'2023-07-28' then 3
when DATE_DAY>='2023-07-28' and DATE_DAY<'2023-08-27' then 4
when DATE_DAY>='2023-08-27' and DATE_DAY<'2023-09-26' then 5
when DATE_DAY>='2023-09-26' and DATE_DAY<'2023-10-27' then 6
when DATE_DAY>='2023-10-27' and DATE_DAY<'2023-11-26' then 7
when DATE_DAY>='2023-11-26' and DATE_DAY<'2023-12-26' then 8
when DATE_DAY>='2023-12-26' and DATE_DAY<'2024-02-12' then 9
Last run: about 2 hours agoAuto-refreshes every 12 hours
18
927B
15s