Overview

Dataset statistics

Number of variables7
Number of observations574
Missing cells0
Missing cells (%)0.0%
Total size in memory31.5 KiB
Average record size in memory56.2 B

Variable types

Categorical7

Alerts

OpenInt has constant value "0" Constant
Date has a high cardinality: 574 distinct values High cardinality
Open has a high cardinality: 459 distinct values High cardinality
High has a high cardinality: 496 distinct values High cardinality
Low has a high cardinality: 471 distinct values High cardinality
Close has a high cardinality: 478 distinct values High cardinality
Volume has a high cardinality: 572 distinct values High cardinality
Date has unique values Unique

Reproduction

Analysis started2021-12-02 19:23:34.950520
Analysis finished2021-12-02 19:23:35.053177
Duration0.1 seconds
Software versionpandas-profiling v3.1.0
Download configurationconfig.json

Variables

Date
Categorical

HIGH CARDINALITY
UNIQUE

Distinct574
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size4.6 KiB
2015-08-05
 
1
2017-02-14
 
1
2017-02-06
 
1
2017-02-07
 
1
2017-02-08
 
1
Other values (569)
569 

Unique

Unique574 ?
Unique (%)100.0%

Sample

1st row2015-08-05
2nd row2015-08-06
3rd row2015-08-07
4th row2015-08-10
5th row2015-08-11

Common Values

ValueCountFrequency (%)
2015-08-051
 
0.2%
2017-02-141
 
0.2%
2017-02-061
 
0.2%
2017-02-071
 
0.2%
2017-02-081
 
0.2%
2017-02-091
 
0.2%
2017-02-101
 
0.2%
2017-02-131
 
0.2%
2017-02-151
 
0.2%
2017-02-021
 
0.2%
Other values (564)564
98.3%

Open
Categorical

HIGH CARDINALITY

Distinct459
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Memory size4.6 KiB
6.26
 
4
14.5
 
4
6.2
 
4
9.95
 
4
9.6
 
4
Other values (454)
554 

Unique

Unique365 ?
Unique (%)63.6%

Sample

1st row18
2nd row16.48
3rd row19.31
4th row29.7
5th row35.98

Common Values

ValueCountFrequency (%)
6.264
 
0.7%
14.54
 
0.7%
6.24
 
0.7%
9.954
 
0.7%
9.64
 
0.7%
6.313
 
0.5%
18.033
 
0.5%
8.93
 
0.5%
103
 
0.5%
9.453
 
0.5%
Other values (449)539
93.9%

High
Categorical

HIGH CARDINALITY

Distinct496
Distinct (%)86.4%
Missing0
Missing (%)0.0%
Memory size4.6 KiB
6.4
 
5
10.2
 
4
18.15
 
3
13.47
 
3
10.09
 
3
Other values (491)
556 

Unique

Unique431 ?
Unique (%)75.1%

Sample

1st row22.25
2nd row19.5
3rd row24.9
4th row42.85
5th row37.688

Common Values

ValueCountFrequency (%)
6.45
 
0.9%
10.24
 
0.7%
18.153
 
0.5%
13.473
 
0.5%
10.093
 
0.5%
193
 
0.5%
6.493
 
0.5%
18.83
 
0.5%
13.53
 
0.5%
10.53
 
0.5%
Other values (486)541
94.3%

Low
Categorical

HIGH CARDINALITY

Distinct471
Distinct (%)82.1%
Missing0
Missing (%)0.0%
Memory size4.6 KiB
12.8
 
6
6.2
 
6
9.63
 
4
17.9
 
4
9.5
 
4
Other values (466)
550 

Unique

Unique400 ?
Unique (%)69.7%

Sample

1st row15.5
2nd row16.46
3rd row19.31
4th row27.5
5th row28.16

Common Values

ValueCountFrequency (%)
12.86
 
1.0%
6.26
 
1.0%
9.634
 
0.7%
17.94
 
0.7%
9.54
 
0.7%
9.44
 
0.7%
184
 
0.7%
17.814
 
0.7%
7.053
 
0.5%
5.83
 
0.5%
Other values (461)532
92.7%

Close
Categorical

HIGH CARDINALITY

Distinct478
Distinct (%)83.3%
Missing0
Missing (%)0.0%
Memory size4.6 KiB
9.45
 
4
7.77
 
3
6.42
 
3
13.37
 
3
18.77
 
3
Other values (473)
558 

Unique

Unique399 ?
Unique (%)69.5%

Sample

1st row16.25
2nd row19.32
3rd row24.54
4th row35.14
5th row29.73

Common Values

ValueCountFrequency (%)
9.454
 
0.7%
7.773
 
0.5%
6.423
 
0.5%
13.373
 
0.5%
18.773
 
0.5%
18.273
 
0.5%
6.393
 
0.5%
13.033
 
0.5%
5.933
 
0.5%
6.233
 
0.5%
Other values (468)543
94.6%

Volume
Categorical

HIGH CARDINALITY

Distinct572
Distinct (%)99.7%
Missing0
Missing (%)0.0%
Memory size4.6 KiB
54900
 
2
140600
 
2
1535500
 
1
629254
 
1
442423
 
1
Other values (567)
567 

Unique

Unique570 ?
Unique (%)99.3%

Sample

1st row1535500
2nd row331692
3rd row269300
4th row539200
5th row243632

Common Values

ValueCountFrequency (%)
549002
 
0.3%
1406002
 
0.3%
15355001
 
0.2%
6292541
 
0.2%
4424231
 
0.2%
3960271
 
0.2%
3269751
 
0.2%
4497191
 
0.2%
5473171
 
0.2%
7468241
 
0.2%
Other values (562)562
97.9%

OpenInt
Categorical

CONSTANT
REJECTED

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.6 KiB
0
574 

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0574
100.0%