9.
부록
본문에 사용된 예제의 예시
데이터 테이블은 아래와 같습니다.
1. Ticker_info
데이터 테이블
Ticker |
Sector |
Listing Date |
Year |
EPS |
Net Income |
A |
IT |
1990-06-03 |
2015Y |
-3.07 |
$30,000,000 |
A |
IT |
1990-06-03 |
2016Y |
-2.10 |
$80,000,000 |
A |
IT |
1990-06-03 |
2017Y |
-1.34 |
$100,000,000 |
A |
IT |
1990-06-03 |
2018Y |
1.21 |
$120,000,000 |
A |
IT |
1990-06-03 |
2019Y |
1.65 |
$151,000,000 |
A |
IT |
1990-06-03 |
2020Y |
1.74 |
$192,000,000 |
B |
Financials |
1998-02-04 |
2015Y |
|
|
B |
Financials |
1998-02-04 |
2016Y |
2.25 |
$367,000,000 |
B |
Financials |
1998-02-04 |
2017Y |
0.64 |
$211,000,000 |
B |
Financials |
1998-02-04 |
2018Y |
-1.07 |
$91,000,000 |
B |
Financials |
1998-02-04 |
2019Y |
-0.07 |
$128,000,000 |
B |
Financials |
1998-02-04 |
2020Y |
-2.01 |
$87,000,000 |
C |
IT |
2003-07-27 |
2015Y |
|
|
C |
IT |
2003-07-27 |
2016Y |
0.48 |
$217,000,000 |
C |
IT |
2003-07-27 |
2017Y |
0.62 |
$219,000,000 |
C |
IT |
2003-07-27 |
2018Y |
0.88 |
$222,000,000 |
C |
IT |
2003-07-27 |
2019Y |
1.12 |
$230,000,000 |
C |
IT |
2003-07-27 |
2020Y |
1.85 |
$251,000,000 |
D |
IT |
2008-05-01 |
2015Y |
-1.38 |
$135,000,000 |
D |
IT |
2008-05-01 |
2016Y |
-6.46 |
$107,000,000 |
D |
IT |
2008-05-01 |
2017Y |
0.86 |
$203,000,000 |
D |
IT |
2008-05-01 |
2018Y |
1.66 |
$201,000,000 |
D |
IT |
2008-05-01 |
2019Y |
4.94 |
$276,000,000 |
D |
IT |
2008-05-01 |
2020Y |
1.42 |
$302,000,000 |
E |
Financials |
1993-12-12 |
2015Y |
|
|
E |
Financials |
1993-12-12 |
2016Y |
|
|
E |
Financials |
1993-12-12 |
2017Y |
1.82 |
$180,000,000 |
E |
Financials |
1993-12-12 |
2018Y |
2.08 |
$200,000,000 |
E |
Financials |
1993-12-12 |
2019Y |
1.76 |
$290,000,000 |
E |
Financials |
1993-12-12 |
2020Y |
2.41 |
$240,000,000 |
F |
IT |
2011-01-26 |
2015Y |
1.59 |
$50,000,000 |
F |
IT |
2011-01-26 |
2016Y |
-3.40 |
$351,000,000 |
F |
IT |
2011-01-26 |
2017Y |
-2.08 |
$297,000,000 |
F |
IT |
2011-01-26 |
2018Y |
-0.84 |
$175,000,000 |
F |
IT |
2011-01-26 |
2019Y |
0.23 |
$106,000,000 |
F |
IT |
2011-01-26 |
2020Y |
0.31 |
$100,000,000 |
2.
Company_add_info 데이터 테이블
Ticker |
Market cap |
Rank |
A |
42.378 |
5 |
B |
55.586 |
4 |
C |
83.421 |
2 |
D |
63.7 |
3 |
E |
335.501 |
1 |
F |
388.796 |
6 |
3.
Coordinate_info 데이터 테이블
Shape |
Position |
X |
Y |
Z |
Length |
Value |
tetrahedron |
origin |
0 |
0 |
0 |
3 |
54 |
tetrahedron |
x |
1 |
0 |
0 |
3 |
6 |
tetrahedron |
y |
0 |
1 |
0 |
3 |
90 |
tetrahedron |
z |
0 |
0 |
1 |
3 |
4 |
tetrahedron |
x |
2 |
0 |
0 |
3 |
39 |
tetrahedron |
xy |
1 |
1 |
0 |
3 |
14 |
tetrahedron |
xz |
1 |
0 |
1 |
3 |
64 |
tetrahedron |
y |
0 |
2 |
0 |
3 |
70 |
tetrahedron |
yz |
0 |
1 |
1 |
3 |
56 |
tetrahedron |
z |
0 |
0 |
2 |
3 |
62 |
tetrahedron |
x |
3 |
0 |
0 |
3 |
49 |
tetrahedron |
xy |
2 |
1 |
0 |
3 |
28 |
tetrahedron |
xz |
2 |
0 |
1 |
3 |
36 |
tetrahedron |
xy |
1 |
2 |
0 |
3 |
14 |
tetrahedron |
xyz |
1 |
1 |
1 |
3 |
50 |
tetrahedron |
xz |
1 |
0 |
2 |
3 |
83 |
tetrahedron |
y |
0 |
3 |
0 |
3 |
16 |
tetrahedron |
yz |
0 |
2 |
1 |
3 |
99 |
tetrahedron |
yz |
0 |
1 |
2 |
3 |
54 |
tetrahedron |
z |
0 |
0 |
3 |
3 |
51 |
cubic |
x |
12 |
0 |
0 |
2 |
65 |
cubic |
xz |
12 |
0 |
1 |
2 |
15 |
cubic |
xz |
12 |
0 |
2 |
2 |
75 |
cubic |
xy |
12 |
1 |
0 |
2 |
8 |
cubic |
xyz |
12 |
1 |
1 |
2 |
76 |
cubic |
xyz |
12 |
1 |
2 |
2 |
53 |
cubic |
xy |
12 |
2 |
0 |
2 |
84 |
cubic |
xyz |
12 |
2 |
1 |
2 |
28 |
cubic |
xyz |
12 |
2 |
2 |
2 |
94 |
cubic |
x |
11 |
0 |
0 |
2 |
76 |
cubic |
xz |
11 |
0 |
1 |
2 |
55 |
cubic |
xz |
11 |
0 |
2 |
2 |
38 |
cubic |
xy |
11 |
1 |
0 |
2 |
94 |
cubic |
xyz |
11 |
1 |
1 |
2 |
71 |
cubic |
xyz |
11 |
1 |
2 |
2 |
79 |
cubic |
xy |
11 |
2 |
0 |
2 |
32 |
cubic |
xyz |
11 |
2 |
1 |
2 |
6 |
cubic |
xyz |
11 |
2 |
2 |
2 |
63 |
cubic |
origin |
10 |
0 |
0 |
2 |
89 |
cubic |
z |
10 |
0 |
1 |
2 |
81 |
cubic |
z |
10 |
0 |
2 |
2 |
38 |
cubic |
y |
10 |
1 |
0 |
2 |
71 |
cubic |
yz |
10 |
1 |
1 |
2 |
50 |
cubic |
yz |
10 |
1 |
2 |
2 |
50 |
cubic |
y |
10 |
2 |
0 |
2 |
95 |
cubic |
yz |
10 |
2 |
1 |
2 |
76 |
cubic |
yz |
10 |
2 |
2 |
2 |
68 |
0 댓글