Statistics for table dow_jones_index

API
Columns
Name Type Statistics
quarter INTEGER
NULL values False
Unique values 2 [1, 2]
Minimum 1
Mean 1.52
Median 2
Maximum 2
Standard deviation 0.499933
stock TEXT
NULL values False
Unique values 30
Lexical minimum 'AA'
Lexical maximum 'XOM'
date TEXT
NULL values False
Unique values 25
Lexical minimum '2011-01-07'
Lexical maximum '2011-06-24'
open REAL
NULL values False
Unique values 722
Minimum 10.59
Mean 53.6518
Median 45.94
Maximum 172.11
Standard deviation 32.6389
high REAL
NULL values False
Unique values 713
Minimum 10.94
Mean 54.67
Median 46.88
Maximum 173.54
Standard deviation 33.216
low REAL
NULL values False
Unique values 711
Minimum 10.4
Mean 52.6402
Median 44.77
Maximum 167.82
Standard deviation 32.1193
close REAL
NULL values False
Unique values 711
Minimum 10.52
Mean 53.7293
Median 45.86
Maximum 170.58
Standard deviation 32.7888
volume INTEGER
NULL values False
Unique values 750
Minimum 9,718,851
Mean 1.17548e+08
Median 53,025,186
Maximum 1,453,438,639
Standard deviation 1.58438e+08
percent_change_price REAL
NULL values False
Unique values 745
Minimum -15.4229
Mean 0.0502624
Median 0
Maximum 9.88223
Standard deviation 2.51781
percent_change_volume_over_last_wk REAL
NULL values 30
Non-NULL values 720
Unique values 720
Minimum -61.4332
Mean 5.59363
Median 0.491083
Maximum 327.409
Standard deviation 40.5435
previous_weeks_volume INTEGER
NULL values 30
Non-NULL values 720
Unique values 720
Minimum 9,718,851
Mean 1.17388e+08
Median 52,881,329
Maximum 1,453,438,639
Standard deviation 1.59232e+08
next_weeks_open REAL
NULL values False
Unique values 720
Minimum 10.52
Mean 53.7024
Median 46
Maximum 172.11
Standard deviation 32.7781
next_weeks_close REAL
NULL values False
Unique values 715
Minimum 10.52
Mean 53.8891
Median 46
Maximum 174.54
Standard deviation 33.0167
percent_change_next_weeks_price REAL
NULL values False
Unique values 745
Minimum -15.4229
Mean 0.238468
Median 0.0919963
Maximum 9.88223
Standard deviation 2.67954
days_to_next_dividend INTEGER
NULL values False
Unique values 105
Minimum 0
Mean 52.5253
Median 47
Maximum 336
Standard deviation 46.3351
percent_return_next_dividend REAL
NULL values False
Unique values 729
Minimum 0.0655738
Mean 0.691826
Median 0.680934
Maximum 1.56421
Standard deviation 0.305482
750 rows
Schema
SciLifeLab Data Centre
DbShare 2.7.10