Statistics Security and Federal Reserve Excel

You select the data from the Excel files provided and construct a presentation that meets the submission requirements

Excel files: 1) Market Data – Security data and 2) Governmental DataSecurity data: 5 firms across industries and 7 index fundsFederal Reserve data: Mix of economic, financial, and social data

Construct a presentation using a mixture of data provided in Excel files.

Dashboard interactivity means that you apply a filter to one sheet, so when you choose one element, it will change all visualizations (sheets) within the same dashboard. Hover over the side of any sheet, you should see a “use as filter” icon. Clicking on that icon makes the sheet an interactive filter and changes all the other sheets when you choose one data point on the sheet.  For instruction on how to do it, please watch these videos:

Federal Reserve data avaiable in this file per worksheet
Median Income: Family, Real (regions)
Median Income: Personal, Real (regions)
Gini Index: USA (A measure of income inequality)
Ownership: Percent Financial Assets USA
Ownership: Percent Corp Equities USA
Net Worth: Percent
Population: US with age groups
Price: Commodities
GDP and Unemployment rates
NBER: Economic Cycles
Important: Remove all lines above data before importing into Tableau.
FRED Graph Observations
Federal Reserve Economic Data
Link: https://fred.stlouisfed.org
Help: https://fredhelp.stlouisfed.org
Economic Research Division
Federal Reserve Bank of St. Louis
MEFAINUSA672N
Real Median Family Income in the United States, 2020 CPI-U-RS Adjusted Dollars, Annual, Not Seasonally Ad
Remove all lines above data before importing into Tableau.
Date
USA
N East
Md Wst
South
West
1970-01-01 58,862
63,808
61,606
51,018
61,284
1971-01-01 58,780
62,981
61,638
51,322
61,169
1972-01-01 61,680
66,263
65,054
53,645
63,911
1973-01-01 62,929
67,102
67,002
55,493
65,117
1974-01-01 61,248
66,223
65,189
53,748
62,829
1975-01-01 60,180
63,523
63,786
53,675
62,799
1976-01-01 62,046
63,900
66,127
55,662
64,227
1977-01-01 62,463
65,565
65,725
56,837
64,426
1978-01-01 64,410
66,418
67,911
58,217
67,221
1979-01-01 65,324
68,776
68,606
58,531
69,000
1980-01-01 63,052
65,551
65,191
57,411
66,825
1981-01-01 61,354
64,966
63,354
56,404
65,423
1982-01-01 60,560
64,398
62,592
55,565
63,638
1983-01-01 60,923
66,123
61,294
55,755
63,431
1984-01-01 62,898
67,786
63,659
57,332
66,810
1985-01-01 63,806
70,268
64,254
57,691
68,506
1986-01-01 66,604
72,713
66,889
60,386
70,011
1987-01-01 67,694
74,907
67,954
62,054
69,991
1988-01-01 67,909
76,902
69,378
61,074
69,789
1989-01-01 69,152
79,805
69,960
61,645
72,153
1990-01-01 68,098
76,070
69,706
61,113
70,667
1991-01-01 66,796
74,837
68,320
59,364
69,086
1992-01-01 66,326
73,795
67,214
59,458
69,866
1993-01-01 65,377
72,502
67,116
59,020
68,777
1994-01-01 67,199
74,409
68,893
61,318
69,825
1995-01-01 68,712
74,293
73,550
61,973
71,007
1996-01-01 69,714
76,723
74,093
63,797
70,157
1997-01-01 71,897
77,963
75,391
66,143
73,546
1998-01-01 74,389
80,485
78,869
67,981
74,519
1999-01-01 76,101
81,498
80,576
69,945
75,914
2000-01-01 76,469
83,914
81,701
69,157
77,149
2001-01-01 75,342
83,539
79,283
68,425
76,161
2002-01-01 74,566
81,893
78,398
68,146
75,393
2003-01-01 74,321
84,471
78,459
66,762
77,728
2004-01-01 74,263
82,835
77,419
68,689
75,534
2005-01-01 74,664
82,555
76,337
68,231
77,044
2006-01-01 75,168
84,280
77,071
67,483
78,719
2007-01-01 76,784
83,457
78,685
70,756
79,372
2008-01-01 74,144
83,540
74,693
67,342
79,147
2009-01-01 72,670
81,001
73,396
66,411
75,259
2010-01-01 71,667
79,670
72,410
65,702
73,327
2011-01-01
2012-01-01
2013-01-01
2014-01-01
2015-01-01
2016-01-01
2017-01-01
2018-01-01
2019-01-01
2020-01-01
70,328
70,300
72,869
72,926
77,242
78,426
80,395
81,070
87,085
84,008
78,528
79,165
82,415
83,229
87,933
87,913
88,291
91,214
99,158
96,393
71,308
71,816
76,380
76,294
80,343
81,196
83,815
85,482
89,320
85,833
65,593
64,867
66,879
66,668
68,334
71,737
74,002
73,329
78,621
76,481
72,039
73,307
76,099
75,098
79,101
81,466
83,158
84,195
91,459
89,544
FRED Graph Observations
Federal Reserve Economic Data
Link: https://fred.stlouisfed.org
Help: https://fredhelp.stlouisfed.org
Economic Research Division
Federal Reserve Bank of St. Louis
MEPAINUSA672N
Real Median Personal Income in the United States, 2020 CPI-U-RS Adjusted Dollars, Annual, Not Seasonally A
Remove all lines above data before importing into Tableau.
Date
USA
N East
Md Wst
South
West
1980-01-01 23,826
24,252
23,961
22,500
25,763
1981-01-01 23,382
23,954
23,226
22,190
25,760
1982-01-01 23,629
23,921
23,324
22,407
25,922
1983-01-01 24,091
24,714
23,137
22,964
26,476
1984-01-01 24,788
25,456
23,964
23,724
27,043
1985-01-01 25,324
26,608
24,498
23,818
27,871
1986-01-01 26,105
28,099
25,572
24,235
28,002
1987-01-01 26,454
28,942
25,808
24,975
28,103
1988-01-01 27,287
30,872
26,543
25,180
29,416
1989-01-01 28,006
31,775
27,315
25,451
29,671
1990-01-01 27,705
30,273
27,832
25,347
29,148
1991-01-01 27,299
29,474
26,952
25,201
29,202
1992-01-01 27,025
29,003
26,809
24,972
28,679
1993-01-01 27,289
28,824
27,567
25,462
28,483
1994-01-01 27,625
29,366
28,013
25,987
28,524
1995-01-01 28,383
29,971
29,466
26,721
28,834
1996-01-01 28,985
30,709
30,109
27,564
29,028
1997-01-01 30,257
31,801
31,009
28,815
30,648
1998-01-01 31,758
32,501
32,618
30,297
32,223
1999-01-01 32,079
32,720
33,261
30,770
32,358
2000-01-01 32,431
33,532
33,405
31,135
32,864
2001-01-01 32,146
33,464
32,839
30,889
32,455
2002-01-01 31,913
33,354
32,304
30,790
32,380
2003-01-01 31,986
33,724
32,505
30,811
32,725
2004-01-01 31,889
33,669
32,355
30,431
32,801
2005-01-01 32,320
33,811
32,811
30,637
33,233
2006-01-01 33,197
34,358
33,322
32,186
34,065
2007-01-01 33,321
34,267
33,303
32,249
34,565
2008-01-01 31,953
33,285
31,940
30,718
33,075
2009-01-01 31,606
33,370
31,442
30,321
32,450
2010-01-01 31,142
32,648
30,974
30,348
31,495
2011-01-01 30,667
31,934
30,636
30,128
30,687
2012-01-01 30,484
32,557
30,921
29,633
30,391
2013-01-01 30,804
33,595
32,200
29,066
31,899
2014-01-01 31,473
33,269
32,516
29,877
31,705
2015-01-01 33,040
34,598
33,592
31,167
33,225
2016-01-01 33,545
35,721
33,900
32,475
33,663
2017-01-01 33,750
36,540
33,992
32,647
34,318
2018-01-01 34,745
37,155
35,853
32,773
36,268
2019-01-01 36,426
39,438
37,206
33,909
37,135
2020-01-01 35,805
39,261
36,176
32,893
36,562
Annual, Not Seasonally Adjusted
FRED Graph Observations
Federal Reserve Economic Data
Link: https://fred.stlouisfed.org
Help: https://fredhelp.stlouisfed.org
Economic Research Division
Federal Reserve Bank of St. Louis
Gini Ratio: a statistical measure of the degree of variation or inequality represented in a set of values, used especia
“an increase in the Gini coefficient suggests that income is becoming more unevenly distributed”
All: Income Gini Ratio for Households by Race of Householder, All Races, Ratio, Annual, Not Seasonally Adjusted
Remove all lines above data before importing into Tableau.
Date
All
1970-01-01
0.394
1971-01-01
0.396
1972-01-01
0.401
1973-01-01
0.400
1974-01-01
0.395
1975-01-01
0.397
1976-01-01
0.398
1977-01-01
0.402
1978-01-01
0.402
1979-01-01
0.404
1980-01-01
0.403
1981-01-01
0.406
1982-01-01
0.412
1983-01-01
0.414
1984-01-01
0.415
1985-01-01
0.419
1986-01-01
0.425
1987-01-01
0.426
1988-01-01
0.426
1989-01-01
0.431
1990-01-01
0.428
1991-01-01
0.428
1992-01-01
0.433
1993-01-01
0.454
1994-01-01
0.456
1995-01-01
0.450
1996-01-01
0.455
1997-01-01
0.459
1998-01-01
0.456
1999-01-01
0.458
2000-01-01
0.462
2001-01-01
0.466
2002-01-01
0.462
2003-01-01
0.464
2004-01-01
0.466
2005-01-01
0.469
2006-01-01
0.470
2007-01-01
0.463
2008-01-01
0.466
2009-01-01
0.468
2010-01-01
2011-01-01
2012-01-01
2013-01-01
2014-01-01
2015-01-01
2016-01-01
2017-01-01
2018-01-01
2019-01-01
2020-01-01
0.470
0.477
0.477
0.482
0.480
0.479
0.481
0.489
0.486
0.484
0.489
a set of values, used especially in analyzing income inequality.
FRED Graph Observations
Federal Reserve Economic Data
Link: https://fred.stlouisfed.org
Help: https://fredhelp.stlouisfed.org
Economic Research Division
Federal Reserve Bank of St. Louis
Top 1: Share of Financial Assets Held by the Top 1% (99th to 100th Wealth Perce
Pct: 90-99 Share of Financial Assets Held by the 90th to 99th Wealth Percentiles, Perc
Pct: 50-90 Share of Financial Assets Held by the 50th to 90th Wealth Percentiles, Perc
Pct: 1-50 Share of Financial Assets Held by the Bottom 50% (1st to 50th Wealth Perc
Remove all lines above data before importing into Tableau.
Date
Pct:Top 1 Pct: 90-99 Pct: 50-90
1990-01-01
26.5
37.9
31.9
1990-04-01
26.6
37.9
31.8
1990-07-01
26.0
38.0
32.2
1990-10-01
26.3
37.8
32.2
1991-01-01
26.5
37.5
32.3
1991-04-01
26.4
37.4
32.4
1991-07-01
26.7
37.1
32.5
1991-10-01
27.2
36.8
32.4
1992-01-01
26.9
36.9
32.6
1992-04-01
26.6
36.9
32.8
1992-07-01
26.6
36.9
32.8
1992-10-01
27.2
36.6
32.6
1993-01-01
27.9
36.2
32.3
1993-04-01
28.2
36.0
32.3
1993-07-01
28.6
35.7
32.1
1993-10-01
29.0
35.5
31.9
1994-01-01
29.4
35.4
31.6
1994-04-01
29.9
35.1
31.4
1994-07-01
30.2
34.9
31.2
1994-10-01
30.7
34.7
30.9
1995-01-01
31.3
34.5
30.5
1995-04-01
31.6
34.2
30.4
1995-07-01
32.0
34.0
30.3
1995-10-01
32.2
33.9
30.3
1996-01-01
32.0
33.9
30.5
1996-04-01
31.8
33.9
30.6
1996-07-01
31.6
33.9
30.9
1996-10-01
31.7
33.8
30.9
1997-01-01
31.1
34.4
30.8
1997-04-01
31.5
34.3
30.6
1997-07-01
31.5
34.4
30.5
1997-10-01
31.3
34.6
30.5
1998-01-01
31.5
34.9
30.0
1998-04-01
31.5
34.8
30.1
1998-07-01
30.9
35.0
30.6
1998-10-01
30.8
35.2
30.4
1999-01-01
30.6
35.3
30.6
1999-04-01
30.7
35.3
30.5
1999-07-01
30.5
35.3
30.8
1999-10-01
30.8
35.3
30.4
2000-01-01
31.1
35.6
29.9
2000-04-01
30.6
35.7
30.3
2000-07-01
30.2
36.0
30.3
2000-10-01
29.6
36.1
30.9
2001-01-01
29.0
36.1
31.5
Pct: 1-50
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.6
3.6
3.6
3.6
3.6
3.6
3.6
3.7
3.7
3.7
3.7
3.7
3.7
3.7
3.6
3.6
3.6
3.7
3.6
3.6
3.6
3.6
3.5
3.6
3.5
3.5
3.5
3.5
3.5
3.4
3.4
3.4
3.4
3.4
2001-04-01
2001-07-01
2001-10-01
2002-01-01
2002-04-01
2002-07-01
2002-10-01
2003-01-01
2003-04-01
2003-07-01
2003-10-01
2004-01-01
2004-04-01
2004-07-01
2004-10-01
2005-01-01
2005-04-01
2005-07-01
2005-10-01
2006-01-01
2006-04-01
2006-07-01
2006-10-01
2007-01-01
2007-04-01
2007-07-01
2007-10-01
2008-01-01
2008-04-01
2008-07-01
2008-10-01
2009-01-01
2009-04-01
2009-07-01
2009-10-01
2010-01-01
2010-04-01
2010-07-01
2010-10-01
2011-01-01
2011-04-01
2011-07-01
2011-10-01
2012-01-01
2012-04-01
2012-07-01
2012-10-01
2013-01-01
2013-04-01
2013-07-01
2013-10-01
2014-01-01
2014-04-01
2014-07-01
2014-10-01
28.9
28.1
28.2
28.2
28.2
27.6
27.1
26.9
27.7
28.1
28.7
29.6
29.6
29.9
30.2
30.4
30.8
31.0
31.1
31.8
31.7
31.7
31.8
32.1
32.0
31.9
31.3
31.1
30.8
30.1
28.5
28.3
28.5
29.4
28.6
29.3
29.1
29.5
29.3
29.9
29.9
29.7
29.4
29.9
30.0
30.2
30.3
30.6
30.6
30.5
30.5
31.1
31.3
31.5
31.7
36.4
36.5
36.3
36.3
36.5
36.3
36.3
36.6
36.5
36.4
36.1
36.2
36.5
36.6
36.5
36.6
36.5
36.5
36.4
36.7
37.1
37.1
36.9
37.4
37.8
38.0
38.1
38.5
38.7
39.3
39.1
39.8
39.3
39.2
38.6
39.1
39.5
39.3
38.8
39.1
39.0
38.9
38.4
38.8
38.8
38.4
38.3
38.3
38.7
38.5
38.4
38.5
38.5
38.7
38.4
31.4
32.1
32.3
32.3
32.2
33.0
33.5
33.4
32.7
32.6
32.3
31.4
31.3
30.9
30.7
30.3
30.0
29.8
29.7
28.7
28.5
28.5
28.4
27.7
27.4
27.3
27.7
27.6
27.7
27.8
29.5
29.0
29.4
28.6
30.0
28.9
28.7
28.5
29.3
28.4
28.6
28.9
29.6
28.8
28.7
28.8
28.9
28.6
28.3
28.5
28.6
28.0
27.8
27.4
27.5
3.3
3.3
3.2
3.2
3.1
3.1
3.1
3.1
3.0
2.9
2.9
2.8
2.7
2.6
2.7
2.7
2.7
2.7
2.7
2.7
2.8
2.8
2.8
2.8
2.8
2.8
2.8
2.8
2.8
2.8
2.9
2.8
2.8
2.8
2.8
2.7
2.7
2.6
2.6
2.6
2.5
2.5
2.6
2.6
2.5
2.5
2.5
2.5
2.5
2.4
2.4
2.4
2.4
2.4
2.3
2015-01-01
2015-04-01
2015-07-01
2015-10-01
2016-01-01
2016-04-01
2016-07-01
2016-10-01
2017-01-01
2017-04-01
2017-07-01
2017-10-01
2018-01-01
2018-04-01
2018-07-01
2018-10-01
2019-01-01
2019-04-01
2019-07-01
2019-10-01
2020-01-01
2020-04-01
2020-07-01
2020-10-01
2021-01-01
2021-04-01
2021-07-01
32.0
32.2
32.1
32.1
32.4
32.7
32.7
32.4
32.6
32.7
32.7
32.8
32.9
32.8
32.9
32.3
32.8
32.8
32.6
32.9
31.8
32.6
33.1
33.9
34.4
35.0
35.2
38.6
38.7
38.8
38.4
38.4
38.5
38.6
38.4
38.5
38.6
38.7
38.6
38.8
38.9
38.9
39.0
39.0
39.1
39.3
39.1
39.2
39.0
38.9
38.8
38.6
38.4
38.3
27.0
26.8
26.8
27.2
26.9
26.5
26.4
26.9
26.6
26.4
26.4
26.3
26.1
26.0
25.9
26.4
26.0
25.9
25.9
25.8
26.7
26.1
25.8
25.1
24.8
24.4
24.4
2.3
2.3
2.3
2.3
2.3
2.3
2.3
2.3
2.3
2.3
2.3
2.3
2.3
2.3
2.3
2.3
2.3
2.2
2.2
2.2
2.3
2.3
2.2
2.2
2.2
2.2
2.2
9th to 100th Wealth Percentiles), Percent of Aggregate, Quarterly, Not Seasonally Adjusted
% (1st to 50th Wealth Percentiles), Percent of Aggregate, Quarterly, Not Seasonally Adjusted
FRED Graph Observations
Federal Reserve Economic Data
Link: https://fred.stlouisfed.org
Help: https://fredhelp.stlouisfed.org
Economic Research Division
Federal Reserve Bank of St. Louis
Total: Population, Thousands, Monthly, Not Seasonally Adjusted
Yrs: 16-19: Population Level – 16-19 Yrs., Thousands of Persons, Monthly, Not Sea
Yrs: 20-24: Population Level – 20-24 Yrs., Thousands of Persons, Monthly, Not Sea
Yrs: 25-54: Population Level – 25-54 Yrs., Thousands of Persons, Monthly, Not Sea
Yrs: 55+: Population Level – 55 Yrs. & over, Thousands of Persons, Monthly, Not
Remove all lines above data before importing into Tableau.
Date
1990-01-01
1990-02-01
1990-03-01
1990-04-01
1990-05-01
1990-06-01
1990-07-01
1990-08-01
1990-09-01
1990-10-01
1990-11-01
1990-12-01
1991-01-01
1991-02-01
1991-03-01
1991-04-01
1991-05-01
1991-06-01
1991-07-01
1991-08-01
1991-09-01
1991-10-01
1991-11-01
1991-12-01
1992-01-01
1992-02-01
1992-03-01
1992-04-01
1992-05-01
1992-06-01
1992-07-01
1992-08-01
1992-09-01
1992-10-01
1992-11-01
1992-12-01
1993-01-01
1993-02-01
1993-03-01
1993-04-01
1993-05-01
1993-06-01
1993-07-01
1993-08-01
1993-09-01
Total
248,743
248,920
249,146
249,436
249,707
249,990
250,285
250,595
250,904
251,201
251,486
251,758
252,012
252,253
252,507
252,778
253,060
253,350
253,650
253,966
254,280
254,576
254,841
255,089
255,331
255,576
255,848
256,139
256,437
256,742
257,063
257,390
257,704
258,004
258,280
258,546
258,799
259,036
259,283
259,547
259,822
260,109
260,411
260,717
261,015
Yrs: 16-19
18,860
18,818
18,919
18,915
18,892
18,927
18,909
18,933
18,926
18,920
18,896
18,909
18,989
18,962
18,936
18,970
18,945
18,941
18,918
18,941
18,970
19,027
18,982
18,980
18,969
18,861
18,845
18,832
18,846
18,840
18,833
18,854
18,830
18,803
18,847
18,794
18,758
18,744
18,714
18,667
18,700
18,653
18,596
18,602
18,583
Yrs: 20-24
18,860
18,818
18,919
18,915
18,892
18,927
18,909
18,933
18,926
18,920
18,896
18,909
18,989
18,962
18,936
18,970
18,945
18,941
18,918
18,941
18,970
19,027
18,982
18,980
18,969
18,861
18,845
18,832
18,846
18,840
18,833
18,854
18,830
18,803
18,847
18,794
18,758
18,744
18,714
18,667
18,700
18,653
18,596
18,602
18,583
Yrs: 25-54
104,971
105,137
105,254
105,374
105,575
105,618
105,756
105,980
106,142
106,332
106,533
106,647
106,760
106,888
106,971
107,091
107,268
107,428
107,575
107,694
107,855
108,005
108,236
108,383
108,520
108,768
108,835
108,977
109,112
109,239
109,381
109,516
109,693
109,828
109,955
110,205
110,320
110,505
110,622
110,751
110,831
110,944
111,149
111,176
111,362
Yrs: 55+
49,816
49,810
49,797
49,858
49,860
49,952
49,997
50,015
50,064
50,112
50,126
50,180
50,203
50,226
50,280
50,265
50,311
50,334
50,410
50,447
50,461
50,506
50,503
50,557
50,618
50,644
50,679
50,682
50,715
50,752
50,781
50,816
50,859
50,940
50,950
50,958
51,051
51,082
51,125
51,131
51,127
51,161
51,189
51,271
51,305
1993-10-01
1993-11-01
1993-12-01
1994-01-01
1994-02-01
1994-03-01
1994-04-01
1994-05-01
1994-06-01
1994-07-01
1994-08-01
1994-09-01
1994-10-01
1994-11-01
1994-12-01
1995-01-01
1995-02-01
1995-03-01
1995-04-01
1995-05-01
1995-06-01
1995-07-01
1995-08-01
1995-09-01
1995-10-01
1995-11-01
1995-12-01
1996-01-01
1996-02-01
1996-03-01
1996-04-01
1996-05-01
1996-06-01
1996-07-01
1996-08-01
1996-09-01
1996-10-01
1996-11-01
1996-12-01
1997-01-01
1997-02-01
1997-03-01
1997-04-01
1997-05-01
1997-06-01
1997-07-01
1997-08-01
1997-09-01
1997-10-01
1997-11-01
1997-12-01
1998-01-01
1998-02-01
1998-03-01
1998-04-01
261,294
261,550
261,796
262,021
262,237
262,491
262,754
263,014
263,294
263,580
263,871
264,159
264,430
264,681
264,924
265,157
265,383
265,625
265,877
266,134
266,414
266,700
266,998
267,304
267,585
267,829
268,047
268,258
268,480
268,724
268,980
269,247
269,527
269,822
270,130
270,433
270,730
271,002
271,243
271,472
271,703
271,952
272,213
272,482
272,767
273,074
273,395
273,703
273,989
274,249
274,499
274,732
274,943
275,175
275,434
18,582
18,574
18,530
18,469
18,383
18,367
18,361
18,380
18,379
18,312
18,339
18,349
18,314
18,269
18,313
18,141
18,036
17,980
17,950
17,905
17,936
17,905
17,849
17,763
17,709
17,583
17,613
17,618
17,522
17,494
17,495
17,401
17,394
17,348
17,314
17,288
17,298
17,351
17,381
17,475
17,435
17,356
17,413
17,385
17,395
17,444
17,427
17,473
17,470
17,492
17,535
17,532
17,535
17,502
17,539
18,582
18,574
18,530
18,469
18,383
18,367
18,361
18,380
18,379
18,312
18,339
18,349
18,314
18,269
18,313
18,141
18,036
17,980
17,950
17,905
17,936
17,905
17,849
17,763
17,709
17,583
17,613
17,618
17,522
17,494
17,495
17,401
17,394
17,348
17,314
17,288
17,298
17,351
17,381
17,475
17,435
17,356
17,413
17,385
17,395
17,444
17,427
17,473
17,470
17,492
17,535
17,532
17,535
17,502
17,539
111,503
111,629
111,847
111,955
112,144
112,261
112,359
112,427
112,506
112,592
112,719
112,872
113,046
113,223
113,308
113,389
113,598
113,688
113,758
113,826
113,873
114,002
114,137
114,282
114,459
114,598
114,700
114,724
114,957
115,069
115,238
115,403
115,488
115,581
115,667
115,818
115,938
116,059
116,131
116,348
116,462
116,559
116,662
116,873
116,902
116,881
116,940
117,018
117,039
117,124
117,181
117,202
117,246
117,218
117,329
51,332
51,353
51,370
51,463
51,451
51,497
51,508
51,522
51,617
51,689
51,734
51,758
51,808
51,858
51,870
51,960
51,957
51,991
52,055
52,102
52,145
52,177
52,247
52,303
52,345
52,421
52,491
52,597
52,575
52,602
52,564
52,651
52,687
52,750
52,815
52,854
52,894
52,927
52,985
53,144
53,231
53,327
53,290
53,274
53,366
53,481
53,614
53,659
53,775
53,847
53,923
54,077
54,166
54,316
54,294
1998-05-01
1998-06-01
1998-07-01
1998-08-01
1998-09-01
1998-10-01
1998-11-01
1998-12-01
1999-01-01
1999-02-01
1999-03-01
1999-04-01
1999-05-01
1999-06-01
1999-07-01
1999-08-01
1999-09-01
1999-10-01
1999-11-01
1999-12-01
2000-01-01
2000-02-01
2000-03-01
2000-04-01
2000-05-01
2000-06-01
2000-07-01
2000-08-01
2000-09-01
2000-10-01
2000-11-01
2000-12-01
2001-01-01
2001-02-01
2001-03-01
2001-04-01
2001-05-01
2001-06-01
2001-07-01
2001-08-01
2001-09-01
2001-10-01
2001-11-01
2001-12-01
2002-01-01
2002-02-01
2002-03-01
2002-04-01
2002-05-01
2002-06-01
2002-07-01
2002-08-01
2002-09-01
2002-10-01
2002-11-01
275,700
275,976
276,266
276,566
276,859
277,140
277,402
277,658
277,891
278,095
278,324
278,584
278,859
279,148
279,448
279,752
280,053
280,337
280,594
280,846
281,083
281,299
281,531
281,763
281,996
282,247
282,504
282,769
283,033
283,285
283,523
283,748
283,960
284,166
284,380
284,602
284,834
285,076
285,324
285,584
285,842
286,086
286,315
286,533
286,739
286,935
287,131
287,343
287,571
287,808
288,051
288,303
288,554
288,794
289,012
17,540
17,581
17,576
17,585
17,679
17,665
17,699
17,687
17,762
17,900
17,913
17,942
17,963
17,896
17,935
17,999
18,042
18,060
18,107
18,093
18,005
18,063
18,121
18,144
18,202
18,322
18,364
18,357
18,466
18,492
18,610
18,589
18,554
18,603
18,651
18,824
18,837
18,877
18,928
18,930
19,042
19,029
19,090
19,157
19,126
19,256
19,187
19,256
19,252
19,248
19,349
19,362
19,482
19,522
19,560
17,540
17,581
17,576
17,585
17,679
17,665
17,699
17,687
17,762
17,900
17,913
17,942
17,963
17,896
17,935
17,999
18,042
18,060
18,107
18,093
18,005
18,063
18,121
18,144
18,202
18,322
18,364
18,357
18,466
18,492
18,610
18,589
18,554
18,603
18,651
18,824
18,837
18,877
18,928
18,930
19,042
19,029
19,090
19,157
19,126
19,256
19,187
19,256
19,252
19,248
19,349
19,362
19,482
19,522
19,560
117,483
117,427
117,375
117,487
117,511
117,596
117,731
117,789
117,912
117,808
117,854
117,862
117,995
118,240
118,266
118,369
118,328
118,433
118,577
118,734
120,252
120,264
120,237
120,319
120,534
120,546
120,716
120,847
120,843
121,056
121,072
121,191
121,330
121,340
121,477
121,555
121,556
121,579
121,616
121,740
121,735
121,771
121,769
121,779
121,880
121,814
121,912
121,913
121,988
122,114
122,103
122,201
122,234
122,213
122,264
54,267
54,427
54,629
54,718
54,806
54,876
54,897
54,926
55,136
55,226
55,281
55,421
55,419
55,482
55,562
55,609
55,808
55,862
55,875
55,891
57,151
57,243
57,345
57,572
57,588
57,728
57,747
57,865
58,010
58,030
58,006
58,077
58,071
58,198
58,239
58,281
58,506
58,634
58,718
58,824
58,965
59,156
59,253
59,348
59,422
59,528
59,651
59,818
59,942
60,102
60,205
60,323
60,437
60,634
60,792
2002-12-01
2003-01-01
2003-02-01
2003-03-01
2003-04-01
2003-05-01
2003-06-01
2003-07-01
2003-08-01
2003-09-01
2003-10-01
2003-11-01
2003-12-01
2004-01-01
2004-02-01
2004-03-01
2004-04-01
2004-05-01
2004-06-01
2004-07-01
2004-08-01
2004-09-01
2004-10-01
2004-11-01
2004-12-01
2005-01-01
2005-02-01
2005-03-01
2005-04-01
2005-05-01
2005-06-01
2005-07-01
2005-08-01
2005-09-01
2005-10-01
2005-11-01
2005-12-01
2006-01-01
2006-02-01
2006-03-01
2006-04-01
2006-05-01
2006-06-01
2006-07-01
2006-08-01
2006-09-01
2006-10-01
2006-11-01
2006-12-01
2007-01-01
2007-02-01
2007-03-01
2007-04-01
2007-05-01
2007-06-01
289,214
289,412
289,606
289,809
290,024
290,250
290,484
290,726
290,974
291,222
291,463
291,677
291,868
292,046
292,230
292,434
292,651
292,872
293,103
293,350
293,603
293,857
294,104
294,337
294,561
294,768
294,955
295,149
295,359
295,582
295,824
296,077
296,338
296,606
296,857
297,089
297,311
297,526
297,734
297,950
298,170
298,401
298,653
298,910
299,178
299,452
299,710
299,950
300,178
300,398
300,608
300,823
301,045
301,278
301,528
19,573
19,667
19,711
19,738
19,764
19,775
19,785
19,796
19,822
19,848
19,872
19,904
19,936
20,120
20,138
20,154
20,173
20,178
20,186
20,193
20,211
20,229
20,247
20,261
20,274
20,263
20,260
20,257
20,254
20,263
20,272
20,282
20,287
20,291
20,295
20,295
20,293
20,246
20,246
20,246
20,248
20,261
20,275
20,289
20,283
20,276
20,270
20,272
20,271
20,391
20,393
20,397
20,402
20,417
20,433
19,573
19,667
19,711
19,738
19,764
19,775
19,785
19,796
19,822
19,848
19,872
19,904
19,936
20,120
20,138
20,154
20,173
20,178
20,186
20,193
20,211
20,229
20,247
20,261
20,274
20,263
20,260
20,257
20,254
20,263
20,272
20,282
20,287
20,291
20,295
20,295
20,293
20,246
20,246
20,246
20,248
20,261
20,275
20,289
20,283
20,276
20,270
20,272
20,271
20,391
20,393
20,397
20,402
20,417
20,433
122,284
122,930
123,006
123,046
123,125
123,172
123,231
123,317
123,379
123,469
123,523
123,595
123,676
123,095
123,150
123,208
123,262
123,301
123,373
123,426
123,496
123,564
123,607
123,686
123,751
123,764
123,813
123,877
123,941
124,017
124,121
124,194
124,270
124,382
124,472
124,582
124,671
124,579
124,637
124,661
124,711
124,756
124,805
124,881
124,974
125,045
125,113
125,201
125,244
125,387
125,456
125,488
125,550
125,581
125,620
60,960
61,273
61,367
61,496
61,601
61,750
61,903
62,029
62,190
62,331
62,499
62,618
62,719
62,782
62,894
63,002
63,124
63,283
63,423
63,580
63,737
63,902
64,081
64,200
64,321
64,508
64,650
64,771
64,898
65,026
65,136
65,278
65,444
65,576
65,726
65,837
65,949
66,213
66,335
66,492
66,634
66,775
66,923
67,043
67,186
67,347
67,515
67,628
67,764
67,981
68,077
68,222
68,353
68,520
68,682
2007-07-01
2007-08-01
2007-09-01
2007-10-01
2007-11-01
2007-12-01
2008-01-01
2008-02-01
2008-03-01
2008-04-01
2008-05-01
2008-06-01
2008-07-01
2008-08-01
2008-09-01
2008-10-01
2008-11-01
2008-12-01
2009-01-01
2009-02-01
2009-03-01
2009-04-01
2009-05-01
2009-06-01
2009-07-01
2009-08-01
2009-09-01
2009-10-01
2009-11-01
2009-12-01
2010-01-01
2010-02-01
2010-03-01
2010-04-01
2010-05-01
2010-06-01
2010-07-01
2010-08-01
2010-09-01
2010-10-01
2010-11-01
2010-12-01
2011-01-01
2011-02-01
2011-03-01
2011-04-01
2011-05-01
2011-06-01
2011-07-01
2011-08-01
2011-09-01
2011-10-01
2011-11-01
2011-12-01
2012-01-01
301,790
302,064
302,334
302,590
302,834
303,062
303,280
303,494
303,707
303,926
304,157
304,396
304,646
304,903
305,158
305,403
305,620
305,827
306,035
306,237
306,438
306,645
306,863
307,090
307,322
307,570
307,826
308,071
308,289
308,495
308,706
308,904
309,095
309,279
309,457
309,643
309,847
310,060
310,280
310,488
310,677
310,858
311,023
311,173
311,333
311,502
311,678
311,872
312,077
312,292
312,509
312,708
312,889
313,064
313,227
20,450
20,447
20,443
20,440
20,452
20,463
20,330
20,343
20,355
20,368
20,385
20,403
20,422
20,434
20,446
20,459
20,474
20,488
20,394
20,415
20,437
20,460
20,485
20,513
20,542
20,563
20,586
20,608
20,632
20,655
20,913
20,938
20,963
20,989
21,014
21,040
21,068
21,088
21,110
21,130
21,148
21,166
21,334
21,350
21,366
21,382
21,399
21,418
21,436
21,450
21,464
21,477
21,494
21,509
21,632
20,450
20,447
20,443
20,440
20,452
20,463
20,330
20,343
20,355
20,368
20,385
20,403
20,422
20,434
20,446
20,459
20,474
20,488
20,394
20,415
20,437
20,460
20,485
20,513
20,542
20,563
20,586
20,608
20,632
20,655
20,913
20,938
20,963
20,989
21,014
21,040
21,068
21,088
21,110
21,130
21,148
21,166
21,334
21,350
21,366
21,382
21,399
21,418
21,436
21,450
21,464
21,477
21,494
21,509
21,632
125,715
125,791
125,867
125,916
125,978
126,009
125,396
125,440
125,474
125,506
125,563
125,627
125,699
125,742
125,801
125,812
125,857
125,904
125,461
125,498
125,493
125,491
125,513
125,533
125,604
125,617
125,637
125,644
125,647
125,640
125,156
125,178
125,191
125,192
125,249
125,268
125,326
125,337
125,354
125,407
125,415
125,410
124,628
124,647
124,644
124,658
124,727
124,738
124,771
124,756
124,728
124,743
124,722
124,690
124,356
68,800
68,964
69,126
69,320
69,462
69,628
69,878
69,999
70,125
70,267
70,393
70,524
70,659
70,839
71,012
71,232
71,379
71,517
71,786
71,910
72,073
72,244
72,389
72,555
72,681
72,875
73,080
73,290
73,476
73,662
73,726
73,869
74,019
74,186
74,304
74,478
74,620
74,817
75,019
75,174
75,351
75,534
75,879
76,009
76,163
76,296
76,395
76,558
76,703
76,916
77,141
77,321
77,513
77,693
79,181
2012-02-01
2012-03-01
2012-04-01
2012-05-01
2012-06-01
2012-07-01
2012-08-01
2012-09-01
2012-10-01
2012-11-01
2012-12-01
2013-01-01
2013-02-01
2013-03-01
2013-04-01
2013-05-01
2013-06-01
2013-07-01
2013-08-01
2013-09-01
2013-10-01
2013-11-01
2013-12-01
2014-01-01
2014-02-01
2014-03-01
2014-04-01
2014-05-01
2014-06-01
2014-07-01
2014-08-01
2014-09-01
2014-10-01
2014-11-01
2014-12-01
2015-01-01
2015-02-01
2015-03-01
2015-04-01
2015-05-01
2015-06-01
2015-07-01
2015-08-01
2015-09-01
2015-10-01
2015-11-01
2015-12-01
2016-01-01
2016-02-01
2016-03-01
2016-04-01
2016-05-01
2016-06-01
2016-07-01
2016-08-01
313,383
313,546
313,710
313,883
314,072
314,272
314,489
314,703
314,905
315,092
315,258
315,400
315,535
315,682
315,841
316,016
316,202
316,405
316,627
316,846
317,055
317,248
317,429
317,598
317,758
317,924
318,098
318,284
318,479
318,692
318,921
319,149
319,367
319,561
319,742
319,904
320,053
320,215
320,390
320,574
320,769
320,982
321,205
321,428
321,641
321,834
322,020
322,196
322,353
322,513
322,685
322,867
323,061
323,265
323,473
21,669
21,706
21,744
21,768
21,794
21,820
21,845
21,869
21,893
21,914
21,934
21,994
22,006
22,017
22,030
22,042
22,053
22,066
22,072
22,077
22,083
22,087
22,091
22,099
22,101
22,103
22,107
22,105
22,105
22,106
22,084
22,064
22,043
22,027
22,010
22,095
22,075
22,055
22,035
22,014
21,996
21,978
21,945
21,913
21,879
21,849
21,817
21,844
21,822
21,801
21,781
21,760
21,741
21,722
21,690
21,669
21,706
21,744
21,768
21,794
21,820
21,845
21,869
21,893
21,914
21,934
21,994
22,006
22,017
22,030
22,042
22,053
22,066
22,072
22,077
22,083
22,087
22,091
22,099
22,101
22,103
22,107
22,105
22,105
22,106
22,084
22,064
22,043
22,027
22,010
22,095
22,075
22,055
22,035
22,014
21,996
21,978
21,945
21,913
21,879
21,849
21,817
21,844
21,822
21,801
21,781
21,760
21,741
21,722
21,690
124,341
124,323
124,357
124,363
124,355
124,372
124,308
124,259
124,270
124,248
124,219
124,357
124,354
124,343
124,380
124,388
124,406
124,401
124,409
124,465
124,461
124,474
124,438
124,453
124,439
124,410
124,453
124,442
124,478
124,500
124,549
124,587
124,607
124,612
124,597
124,974
124,959
124,949
124,970
125,015
125,085
125,147
125,210
125,238
125,241
125,258
125,258
125,536
125,570
125,614
125,635
125,674
125,716
125,771
125,852
79,348
79,520
79,648
79,819
80,010
80,183
80,457
80,713
80,913
81,123
81,326
81,445
81,614
81,795
81,937
82,117
82,287
82,493
82,709
82,880
83,116
83,295
83,517
83,691
83,880
84,087
84,228
84,431
84,595
84,788
84,974
85,181
85,399
85,604
85,824
86,018
86,235
86,453
86,642
86,810
86,970
87,141
87,330
87,562
87,809
88,021
88,237
88,366
88,519
88,671
88,854
89,032
89,223
89,399
89,580
2016-09-01
2016-10-01
2016-11-01
2016-12-01
2017-01-01
2017-02-01
2017-03-01
2017-04-01
2017-05-01
2017-06-01
2017-07-01
2017-08-01
2017-09-01
2017-10-01
2017-11-01
2017-12-01
2018-01-01
2018-02-01
2018-03-01
2018-04-01
2018-05-01
2018-06-01
2018-07-01
2018-08-01
2018-09-01
2018-10-01
2018-11-01
2018-12-01
2019-01-01
2019-02-01
2019-03-01
2019-04-01
2019-05-01
2019-06-01
2019-07-01
2019-08-01
2019-09-01
2019-10-01
2019-11-01
2019-12-01
2020-01-01
2020-02-01
2020-03-01
2020-04-01
2020-05-01
2020-06-01
2020-07-01
2020-08-01
2020-09-01
2020-10-01
2020-11-01
2020-12-01
2021-01-01
2021-02-01
2021-03-01
323,680
323,876
324,052
324,216
324,362
324,494
324,632
324,783
324,944
325,117
325,296
325,476
325,653
325,820
325,968
326,100
326,216
326,323
326,437
326,563
326,699
326,847
327,005
327,167
327,328
327,477
327,607
327,722
327,824
327,921
328,025
328,140
328,267
328,404
328,561
328,730
328,897
329,054
329,191
329,314
329,423
329,527
329,638
329,760
329,894
330,038
330,199
330,368
330,535
330,692
330,829
330,924
330,968
331,004
331,061
21,659
21,626
21,610
21,592
21,516
21,491
21,467
21,443
21,426
21,410
21,395
21,368
21,342
21,315
21,298
21,278
21,283
21,277
21,272
21,267
21,260
21,254
21,249
21,230
21,212
21,194
21,189
21,183
21,095
21,085
21,075
21,066
21,059
21,053
21,047
21,044
21,040
21,037
21,034
21,030
20,898
20,906
20,914
20,923
20,922
20,922
20,922
20,921
20,919
20,917
20,924
20,931
20,865
20,855
20,846
21,659
21,626
21,610
21,592
21,516
21,491
21,467
21,443
21,426
21,410
21,395
21,368
21,342
21,315
21,298
21,278
21,283
21,277
21,272
21,267
21,260
21,254
21,249
21,230
21,212
21,194
21,189
21,183
21,095
21,085
21,075
21,066
21,059
21,053
21,047
21,044
21,040
21,037
21,034
21,030
20,898
20,906
20,914
20,923
20,922
20,922
20,922
20,921
20,919
20,917
20,924
20,931
20,865
20,855
20,846
125,896
125,928
125,965
125,970
125,547
125,567
125,572
125,562
125,602
125,667
125,732
125,772
125,804
125,822
125,849
125,867
126,238
126,241
126,282
126,295
126,321
126,337
126,388
126,423
126,482
126,541
126,568
126,564
126,164
126,205
126,238
126,265
126,292
126,296
126,288
126,257
126,277
126,322
126,376
126,395
125,936
125,950
125,960
125,980
126,037
126,061
126,074
126,083
126,069
126,086
126,129
126,181
126,060
126,048
126,062
89,799
90,026
90,216
90,424
90,286
90,447
90,628
90,829
90,984
91,124
91,267
91,457
91,655
91,865
92,040
92,204
92,477
92,637
92,769
92,938
93,109
93,296
93,458
93,658
93,834
94,011
94,188
94,385
94,276
94,400
94,526
94,665
94,820
95,003
95,208
95,444
95,628
95,789
95,918
96,070
96,046
96,167
96,295
96,419
96,522
96,664
96,827
97,004
97,205
97,371
97,487
97,580
97,445
97,545
97,635
2021-04-01
2021-05-01
2021-06-01
2021-07-01
2021-08-01
2021-09-01
2021-10-01
2021-11-01
331,126
331,204
331,297
331,395
331,507
331,618
331,716
331,799
20,838
20,828
20,819
20,810
20,797
20,785
20,771
20,757
20,838
20,828
20,819
20,810
20,797
20,785
20,771
20,757
126,077
126,088
126,101
126,125
126,091
126,115
126,157
126,165
97,736
97,847
97,975
98,094
98,280
98,419
98,529
98,656
of Persons, Monthly, Not Seasonally Adjusted
of Persons, Monthly, Not Seasonally Adjusted
of Persons, Monthly, Not Seasonally Adjusted
nds of Persons, Monthly, Not Seasonally Adjusted
FRED Graph Observations
Federal Reserve Economic Data
Link: https://fred.stlouisfed.org
Help: https://fredhelp.stlouisfed.org
Economic Research Division
Federal Reserve Bank of St. Louis
Pct:Top 1 Share of Total Net Worth Held by the Top 1% (99th to 100th Wealth Percentile
Pct: 90-99 Share of Total Net Worth Held by the 90th to 99th Wealth Percentiles, Percent
Pct: 50-90 Share of Total Net Worth Held by the 50th to 90th Wealth Percentiles, Percent
Pct: 1-50 Share of Total Net Worth Held by the Bottom 50% (1st to 50th Wealth Percenti
Remove all lines above data before importing into Tableau.
Date
Pct:Top 1 Pct: 90-99 Pct: 50-90 Pct: 1-50
1990-01-01
23.5
37.1
35.8
3.7
1990-04-01
23.7
37.0
35.8
3.5
1990-07-01
23.2
37.0
36.1
3.7
1990-10-01
23.5
36.8
36.0
3.6
1991-01-01
23.8
36.6
35.9
3.7
1991-04-01
23.8
36.5
36.0
3.8
1991-07-01
23.9
36.0
36.1
4.0
1991-10-01
24.4
35.8
35.8
4.0
1992-01-01
24.2
35.7
36.0
4.0
1992-04-01
24.2
35.5
36.3
4.0
1992-07-01
24.1
35.4
36.2
4.3
1992-10-01
24.6
35.2
36.1
4.1
1993-01-01
25.2
34.9
36.0
3.8
1993-04-01
25.4
34.7
36.0
3.9
1993-07-01
25.7
34.5
35.9
3.9
1993-10-01
26.1
34.4
35.8
3.8
1994-01-01
26.4
34.3
35.7
3.6
1994-04-01
26.7
34.1
35.7
3.6
1994-07-01
26.9
33.9
35.5
3.6
1994-10-01
27.4
33.7
35.4
3.4
1995-01-01
27.9
33.5
35.2
3.5
1995-04-01
28.0
33.4
34.9
3.7
1995-07-01
28.3
33.3
34.6
3.8
1995-10-01
28.5
33.3
34.5
3.7
1996-01-01
28.4
33.4
34.5
3.7
1996-04-01
28.3
33.4
34.7
3.6
1996-07-01
28.2
33.3
34.9
3.6
1996-10-01
28.4
33.3
34.8
3.4
1997-01-01
28.0
33.8
34.7
3.5
1997-04-01
28.3
33.8
34.4
3.5
1997-07-01
28.4
33.9
34.2
3.5
1997-10-01
28.3
34.1
34.1
3.4
1998-01-01
28.6
34.3
33.6
3.5
1998-04-01
28.6
34.3
33.8
3.4
1998-07-01
27.9
34.3
34.2
3.6
1998-10-01
28.1
34.6
33.9
3.4
1999-01-01
27.9
34.7
34.0
3.5
1999-04-01
28.1
34.7
33.8
3.3
1999-07-01
27.8
34.7
34.1
3.4
1999-10-01
28.3
34.7
33.6
3.3
2000-01-01
28.6
34.8
33.3
3.3
2000-04-01
28.1
34.8
33.7
3.3
2000-07-01
27.8
35.1
33.8
3.4
2000-10-01
27.2
35.1
34.4
3.3
2001-01-01
26.6
35.0
35.2
3.2
2001-04-01
2001-07-01
2001-10-01
2002-01-01
2002-04-01
2002-07-01
2002-10-01
2003-01-01
2003-04-01
2003-07-01
2003-10-01
2004-01-01
2004-04-01
2004-07-01
2004-10-01
2005-01-01
2005-04-01
2005-07-01
2005-10-01
2006-01-01
2006-04-01
2006-07-01
2006-10-01
2007-01-01
2007-04-01
2007-07-01
2007-10-01
2008-01-01
2008-04-01
2008-07-01
2008-10-01
2009-01-01
2009-04-01
2009-07-01
2009-10-01
2010-01-01
2010-04-01
2010-07-01
2010-10-01
2011-01-01
2011-04-01
2011-07-01
2011-10-01
2012-01-01
2012-04-01
2012-07-01
2012-10-01
2013-01-01
2013-04-01
2013-07-01
2013-10-01
2014-01-01
2014-04-01
2014-07-01
2014-10-01
26.6
25.9
26.0
26.1
26.1
25.4
25.1
25.0
25.8
26.1
26.5
27.2
27.1
27.4
27.6
27.7
28.0
28.1
28.1
28.8
28.7
28.8
29.0
29.3
29.4
29.5
29.2
29.1
28.9
28.6
27.2
26.9
27.2
28.1
27.5
28.2
28.1
28.4
28.4
29.1
29.3
29.0
28.8
29.4
29.5
29.6
29.7
30.0
30.0
29.9
29.9
30.4
30.6
30.6
30.7
35.3
35.3
35.3
35.3
35.5
35.4
35.5
35.7
35.7
35.6
35.5
35.5
35.7
35.9
35.7
35.9
35.9
35.9
35.8
36.2
36.5
36.5
36.5
37.0
37.4
37.7
37.9
38.3
38.5
39.1
39.3
40.2
39.7
39.7
39.2
39.6
39.8
39.8
39.4
39.5
39.3
39.3
39.0
39.2
39.1
38.8
38.6
38.6
38.8
38.6
38.4
38.4
38.4
38.6
38.4
35.0
35.7
35.7
35.7
35.7
36.3
36.6
36.6
36.1
35.9
35.4
34.8
34.7
34.3
34.3
34.1
33.9
33.7
33.7
32.7
32.6
32.5
32.4
31.5
31.2
31.0
31.2
31.0
31.0
31.3
32.4
31.8
32.0
31.4
32.6
31.7
31.7
31.2
31.7
31.0
31.1
31.2
31.6
30.9
30.8
30.9
30.9
30.7
30.5
30.7
30.8
30.3
30.1
29.8
29.9
3.1
3.1
2.9
2.9
2.8
2.8
2.9
2.7
2.5
2.5
2.6
2.4
2.5
2.5
2.4
2.3
2.3
2.3
2.3
2.3
2.2
2.2
2.2
2.2
2.1
1.9
1.7
1.6
1.5
1.1
1.1
1.2
1.0
0.7
0.7
0.6
0.4
0.5
0.5
0.4
0.3
0.4
0.6
0.6
0.6
0.7
0.8
0.7
0.8
0.9
0.8
0.8
0.9
1.0
1.0
2015-01-01
2015-04-01
2015-07-01
2015-10-01
2016-01-01
2016-04-01
2016-07-01
2016-10-01
2017-01-01
2017-04-01
2017-07-01
2017-10-01
2018-01-01
2018-04-01
2018-07-01
2018-10-01
2019-01-01
2019-04-01
2019-07-01
2019-10-01
2020-01-01
2020-04-01
2020-07-01
2020-10-01
2021-01-01
2021-04-01
2021-07-01
31.0
31.1
30.9
30.8
31.0
31.2
31.1
30.8
31.0
31.0
30.9
31.0
31.0
30.9
31.0
30.3
30.7
30.7
30.5
30.8
29.7
30.4
30.8
31.5
31.9
32.2
32.1
38.5
38.6
38.7
38.3
38.3
38.4
38.4
38.2
38.3
38.4
38.4
38.3
38.4
38.5
38.5
38.6
38.5
38.7
38.8
38.7
38.6
38.4
38.2
38.0
37.7
37.6
37.5
29.5
29.3
29.4
29.8
29.5
29.3
29.2
29.7
29.5
29.3
29.3
29.3
29.2
29.0
29.0
29.6
29.2
29.0
29.0
28.8
29.9
29.4
29.2
28.6
28.5
28.0
27.9
1.0
1.0
1.0
1.1
1.2
1.1
1.2
1.3
1.3
1.4
1.4
1.4
1.5
1.6
1.6
1.6
1.6
1.6
1.7
1.8
1.8
1.8
1.8
1.8
1.9
2.2
2.5
% (99th to 100th Wealth Percentiles), Percent of Aggregate, Quarterly, Not Seasonally Adjusted
m 50% (1st to 50th Wealth Percentiles), Percent of Aggregate, Quarterly, Not Seasonally Adjusted
FRED Graph Observations
Federal Reserve Economic Data
Link: https://fred.stlouisfed.org
Help: https://fredhelp.stlouisfed.org
Economic Research Division
Federal Reserve Bank of St. Louis
Pct:Top 1 Share of Corporate Equities and Mutual Fund Shares Held by the Top 1% (99th
Pct: 90-99 Share of Corporate Equities and Mutual Fund Shares Held by the 90th to 99th
Pct: 50-90 Share of Corporate Equities and Mutual Fund Shares Held by the 50th to 90th
Pct: 1-50 Share of Corporate Equities and Mutual Fund Shares Held by the Bottom 50%
Remove all lines above data before importing into Tableau.
Date
Pct:Top 1 Pct: 90-99 Pct: 50-90 Pct: 1-50
1990-01-01
42.10
39.00
17.60
1.30
1990-04-01
42.60
38.60
17.40
1.30
1990-07-01
40.90
39.00
18.60
1.50
1990-10-01
41.30
38.40
18.80
1.50
1991-01-01
41.80
37.80
19.00
1.40
1991-04-01
41.70
37.60
19.20
1.50
1991-07-01
42.10
37.20
19.20
1.50
1991-10-01
43.10
36.60
18.80
1.50
1992-01-01
42.70
36.50
19.30
1.50
1992-04-01
42.70
36.30
19.40
1.60
1992-07-01
43.00
36.00
19.50
1.60
1992-10-01
44.30
35.50
18.70
1.50
1993-01-01
45.00
35.20
18.30
1.50
1993-04-01
45.50
34.90
18.10
1.50
1993-07-01
46.20
34.60
17.70
1.50
1993-10-01
46.70
34.40
17.40
1.50
1994-01-01
46.90
34.20
17.40
1.50
1994-04-01
47.70
33.90
16.90
1.60
1994-07-01
48.40
33.60
16.50
1.60
1994-10-01
49.10
33.30
16.00
1.60
1995-01-01
50.00
33.00
15.40
1.60
1995-04-01
50.50
32.80
15.10
1.60
1995-07-01
50.90
32.70
14.80
1.50
1995-10-01
50.40
32.90
15.10
1.60
1996-01-01
49.70
33.20
15.50
1.60
1996-04-01
49.30
33.40
15.80
1.60
1996-07-01
48.70
33.50
16.10
1.70
1996-10-01
48.40
33.70
16.30
1.70
1997-01-01
47.90
33.80
16.60
1.70
1997-04-01
48.30
33.90
16.10
1.70
1997-07-01
48.30
34.00
16.10
1.70
1997-10-01
48.00
34.10
16.30
1.70
1998-01-01
48.30
34.10
15.90
1.70
1998-04-01
48.10
34.20
16.10
1.70
1998-07-01
46.90
34.40
16.90
1.80
1998-10-01
47.10
34.60
16.70
1.70
1999-01-01
46.50
34.90
17.00
1.70
1999-04-01
46.40
35.00
16.90
1.60
1999-07-01
45.60
35.40
17.40
1.70
1999-10-01
46.40
35.30
16.70
1.60
2000-01-01
46.40
35.50
16.60
1.50
2000-04-01
45.60
35.70
17.10
1.60
2000-07-01
45.10
36.00
17.40
1.60
2000-10-01
43.70
36.40
18.30
1.60
2001-01-01
42.10
36.80
19.40
1.70
2001-04-01
2001-07-01
2001-10-01
2002-01-01
2002-04-01
2002-07-01
2002-10-01
2003-01-01
2003-04-01
2003-07-01
2003-10-01
2004-01-01
2004-04-01
2004-07-01
2004-10-01
2005-01-01
2005-04-01
2005-07-01
2005-10-01
2006-01-01
2006-04-01
2006-07-01
2006-10-01
2007-01-01
2007-04-01
2007-07-01
2007-10-01
2008-01-01
2008-04-01
2008-07-01
2008-10-01
2009-01-01
2009-04-01
2009-07-01
2009-10-01
2010-01-01
2010-04-01
2010-07-01
2010-10-01
2011-01-01
2011-04-01
2011-07-01
2011-10-01
2012-01-01
2012-04-01
2012-07-01
2012-10-01
2013-01-01
2013-04-01
2013-07-01
2013-10-01
2014-01-01
2014-04-01
2014-07-01
2014-10-01
42.10
40.20
41.30
41.70
41.30
40.20
40.90
40.90
42.60
43.40
44.70
45.50
46.00
46.60
47.20
47.20
47.50
47.90
48.10
48.80
48.60
48.90
49.30
49.50
49.70
49.60
49.20
48.40
48.00
47.10
45.10
44.30
45.70
46.80
47.00
47.50
46.90
47.70
48.10
48.50
48.40
47.40
47.70
48.40
48.20
48.50
48.50
49.20
49.20
49.50
50.00
50.40
50.70
50.70
51.00
36.90
37.50
37.10
37.00
37.00
37.20
36.90
36.90
36.40
36.20
35.80
35.50
35.40
35.10
35.20
35.30
35.40
35.40
35.50
35.40
35.60
35.70
35.70
35.70
35.80
35.90
36.10
36.50
36.70
37.20
38.10
38.60
38.20
37.80
37.90
37.90
38.30
38.10
37.70
37.40
37.30
37.60
37.30
36.90
36.90
36.60
36.50
36.10
35.90
35.70
35.60
35.50
35.40
35.40
35.40
19.40
20.70
20.00
19.80
20.20
21.10
20.70
20.80
19.70
19.20
18.40
17.80
17.70
17.30
16.70
16.50
16.20
15.70
15.40
14.80
14.70
14.40
14.00
13.70
13.50
13.40
13.60
14.10
14.30
14.70
15.90
16.20
15.20
14.40
14.20
13.80
14.00
13.50
13.40
13.30
13.40
14.20
14.10
13.80
14.10
14.00
14.10
13.80
13.90
13.80
13.50
13.30
13.00
13.00
12.80
1.60
1.70
1.60
1.50
1.50
1.50
1.50
1.40
1.30
1.20
1.10
1.10
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
0.90
0.90
0.90
0.80
0.80
0.80
0.80
0.80
0.80
0.80
0.90
0.90
0.90
0.90
0.90
0.90
0.90
0.90
0.90
0.90
0.80
0.80
0.80
2015-01-01
2015-04-01
2015-07-01
2015-10-01
2016-01-01
2016-04-01
2016-07-01
2016-10-01
2017-01-01
2017-04-01
2017-07-01
2017-10-01
2018-01-01
2018-04-01
2018-07-01
2018-10-01
2019-01-01
2019-04-01
2019-07-01
2019-10-01
2020-01-01
2020-04-01
2020-07-01
2020-10-01
2021-01-01
2021-04-01
2021-07-01
51.20
51.30
51.10
51.30
51.50
51.70
51.90
51.90
52.10
52.20
52.20
52.40
52.40
52.40
52.50
51.90
52.50
52.60
52.50
52.70
51.60
52.40
52.80
53.30
53.50
53.80
53.80
35.30
35.30
35.40
35.30
35.30
35.20
35.20
35.30
35.20
35.30
35.30
35.30
35.40
35.40
35.40
35.80
35.50
35.60
35.70
35.50
36.00
35.60
35.40
35.20
35.10
34.90
35.00
12.60
12.60
12.70
12.60
12.40
12.30
12.20
12.10
12.00
11.90
11.80
11.60
11.60
11.50
11.40
11.70
11.30
11.20
11.30
11.20
11.80
11.40
11.20
10.90
10.80
10.60
10.60
0.80
0.80
0.80
0.80
0.80
0.80
0.80
0.80
0.70
0.70
0.70
0.70
0.70
0.70
0.70
0.60
0.60
0.60
0.60
0.60
0.60
0.60
0.60
0.60
0.60
0.60
0.60
nd Shares Held by the Top 1% (99th to 100th Wealth Percentiles), Percent of Aggregate, Quarterly, Not Seasonally Adjusted
nd Shares Held by the Bottom 50% (1st to 50th Wealth Percentiles), Percent of Aggregate, Quarterly, Not Seasonally Adjusted
FRED Graph Observations
Federal Reserve EconomicNatl
Data
Gas: Global price of Natural gas, EU, U.S. Dollars per Million Metric British Thermal Unit, Month
Link: https://fred.stlouisfed.org Oil: Crude Oil Prices: West Texas Intermediate (WTI) – Cushing, Oklahoma, Dollars per Barre
Help: https://fredhelp.stlouisfed.org
Elect: Average Price: Electricity per Kilowatt-Hour in U.S. City Average, U.S. Dollars, Monthly, No
Economic Research Division Beef: Average Price: Ground Beef, 100% Beef (Cost per Pound/453.6 Grams) in U.S. City Aver
Federal Reserve Bank of St. Louis
Corn: Global price of Corn, U.S. Dollars per Metric Ton, Monthly, Not Seasonally Adjusted
Soybeans: Global price of Soybeans, U.S. Dollars per Metric Ton, Monthly, Not Seasonally Adjusted
Remove all lines above data before importing into Tableau.
Date
Natl Gas
1990-01-01
1.730
1990-02-01
1.730
1990-03-01
1.730
1990-04-01
2.110
1990-05-01
2.110
1990-06-01
2.110
1990-07-01
1.920
1990-08-01
1.920
1990-09-01
1.920
1990-10-01
2.380
1990-11-01
2.380
1990-12-01
2.380
1991-01-01
2.960
1991-02-01
2.960
1991-03-01
2.960
1991-04-01
3.410
1991-05-01
3.410
1991-06-01
3.410
1991-07-01
3.120
1991-08-01
3.120
1991-09-01
3.120
1991-10-01
2.540
1991-11-01
2.540
1991-12-01
2.540
1992-01-01
2.380
1992-02-01
2.380
1992-03-01
2.380
1992-04-01
2.340
1992-05-01
2.340
1992-06-01
2.340
1992-07-01
2.390
1992-08-01
2.390
1992-09-01
2.390
1992-10-01
2.350
1992-11-01
2.350
1992-12-01
2.350
1993-01-01
2.700
1993-02-01
2.700
1993-03-01
2.700
1993-04-01
2.610
1993-05-01
2.600
1993-06-01
2.600
1993-07-01
2.550
1993-08-01
2.550
Oil
22.860
22.110
20.390
18.430
18.200
16.700
18.450
27.310
33.510
36.040
32.330
27.280
25.230
20.480
19.900
20.830
21.230
20.190
21.400
21.690
21.890
23.230
22.460
19.500
18.790
19.010
18.920
20.230
20.980
22.390
21.780
21.340
21.880
21.690
20.340
19.410
19.030
20.090
20.320
20.250
19.950
19.090
17.890
18.010
Elect
0.081
0.081
0.081
0.082
0.082
0.088
0.087
0.087
0.088
0.083
0.082
0.082
0.084
0.084
0.085
0.084
0.085
0.090
0.091
0.090
0.091
0.087
0.084
0.085
0.085
0.084
0.086
0.086
0.087
0.092
0.092
0.091
0.092
0.088
0.086
0.088
0.089
0.087
0.088
0.088
0.090
0.094
0.095
0.097
Beef
1.557
1.572
1.571
1.593
1.577
1.593
1.581
1.576
1.594
1.582
1.622
1.630
1.647
1.632
1.610
1.611
1.624
1.604
1.586
1.578
1.553
1.552
1.567
1.577
1.601
1.587
1.545
1.563
1.545
1.535
1.487
1.533
1.521
1.546
1.535
1.500
1.565
1.562
1.562
1.588
1.560
1.562
1.577
1.573
Corn
Soybeans
105.901 209.827
106.294 208.449
109.837 218.279
118.498 220.668
121.254 228.316
120.073 221.058
114.955 222.459
109.837 222.712
102.357 226.915
99.995 224.802
99.995 211.849
102.357 213.870
105.507 207.508
106.294 210.126
109.050 213.318
110.231 215.891
105.735 210.654
105.113 208.863
105.730 199.102
110.119 208.082
108.853 216.235
109.523 205.739
106.798 205.670
106.721 204.155
109.586 208.610
113.921 211.160
116.685 216.143
109.055 211.297
109.178 220.369
110.202 224.389
102.394 208.105
97.540 202.868
98.217 202.891
94.560 197.678
95.173 205.211
94.043 208.909
94.095 212.331
94.254 210.034
97.535 214.122
100.487 217.682
99.223 221.495
92.726 221.908
101.889 258.839
100.313 246.644
1993-09-01
1993-10-01
1993-11-01
1993-12-01
1994-01-01
1994-02-01
1994-03-01
1994-04-01
1994-05-01
1994-06-01
1994-07-01
1994-08-01
1994-09-01
1994-10-01
1994-11-01
1994-12-01
1995-01-01
1995-02-01
1995-03-01
1995-04-01
1995-05-01
1995-06-01
1995-07-01
1995-08-01
1995-09-01
1995-10-01
1995-11-01
1995-12-01
1996-01-01
1996-02-01
1996-03-01
1996-04-01
1996-05-01
1996-06-01
1996-07-01
1996-08-01
1996-09-01
1996-10-01
1996-11-01
1996-12-01
1997-01-01
1997-02-01
1997-03-01
1997-04-01
1997-05-01
1997-06-01
1997-07-01
1997-08-01
1997-09-01
1997-10-01
1997-11-01
1997-12-01
1998-01-01
1998-02-01
1998-03-01
2.550
2.540
2.540
2.540
2.220
2.220
2.220
2.240
2.240
2.240
2.350
2.350
2.350
2.440
2.440
2.440
2.590
2.590
2.590
2.690
2.690
2.690
2.769
2.769
2.769
2.825
2.690
2.690
2.680
2.680
2.680
2.690
2.690
2.690
2.690
2.690
2.690
2.940
2.940
2.940
3.000
2.944
2.760
2.730
2.730
2.730
2.600
2.600
2.600
2.450
2.450
2.450
2.490
2.490
2.490
17.500
18.150
16.610
14.520
15.030
14.780
14.680
16.420
17.890
19.060
19.660
18.380
17.450
17.720
18.070
17.160
18.040
18.570
18.540
19.900
19.740
18.450
17.330
18.020
18.230
17.430
17.990
19.030
18.860
19.090
21.330
23.500
21.170
20.420
21.300
21.900
23.970
24.880
23.710
25.230
25.130
22.180
20.970
19.700
20.820
19.260
19.660
19.950
19.800
21.330
20.190
18.330
16.720
16.060
15.120
0.097
0.093
0.091
0.090
0.090
0.090
0.089
0.088
0.090
0.095
0.095
0.096
0.096
0.093
0.091
0.091
0.091
0.091
0.091
0.090
0.092
0.098
0.098
0.098
0.097
0.094
0.092
0.091
0.091
0.091
0.092
0.092
0.092
0.096
0.099
0.099
0.099
0.095
0.092
0.092
0.092
0.092
0.093
0.092
0.093
0.099
0.099
0.098
0.099
0.093
0.092
0.090
0.086
0.085
0.085
1.551
1.556
1.600
1.574
1.561
1.555
1.576
1.482
1.489
1.511
1.456
1.460
1.463
1.416
1.376
1.380
1.381
1.426
1.392
1.365
1.322
1.333
1.365
1.328
1.376
1.371
1.368
1.403
1.350
1.403
1.375
1.354
1.319
1.324
1.352
1.391
1.360
1.371
1.403
1.424
1.409
1.398
1.356
1.381
1.382
1.408
1.402
1.394
1.420
1.406
1.409
1.392
1.457
1.398
1.413
101.032
105.768
115.928
121.229
126.716
123.649
120.107
113.417
110.601
112.083
98.732
96.157
97.605
96.110
95.606
102.555
106.899
106.978
109.627
109.640
111.928
120.007
127.310
126.297
130.513
140.816
143.212
148.189
156.671
164.712
170.961
189.033
203.999
196.639
197.620
186.820
145.239
128.609
117.137
116.835
118.695
121.746
127.861
124.713
118.611
112.581
106.421
111.951
112.237
120.244
117.405
113.604
114.367
113.619
113.840
236.056
226.088
243.934
252.523
255.601
249.675
250.548
242.762
250.227
249.607
223.240
214.099
207.875
198.711
205.395
206.382
202.501
203.649
209.345
211.274
211.642
216.649
226.915
218.922
232.588
240.994
249.744
263.961
270.116
268.256
265.775
290.419
295.518
284.608
288.765
296.299
297.493
259.804
255.279
257.163
268.095
280.543
305.876
313.363
319.840
304.773
281.163
267.590
255.210
250.755
265.431
254.590
246.001
247.425
240.121
1998-04-01
1998-05-01
1998-06-01
1998-07-01
1998-08-01
1998-09-01
1998-10-01
1998-11-01
1998-12-01
1999-01-01
1999-02-01
1999-03-01
1999-04-01
1999-05-01
1999-06-01
1999-07-01
1999-08-01
1999-09-01
1999-10-01
1999-11-01
1999-12-01
2000-01-01
2000-02-01
2000-03-01
2000-04-01
2000-05-01
2000-06-01
2000-07-01
2000-08-01
2000-09-01
2000-10-01
2000-11-01
2000-12-01
2001-01-01
2001-02-01
2001-03-01
2001-04-01
2001-05-01
2001-06-01
2001-07-01
2001-08-01
2001-09-01
2001-10-01
2001-11-01
2001-12-01
2002-01-01
2002-02-01
2002-03-01
2002-04-01
2002-05-01
2002-06-01
2002-07-01
2002-08-01
2002-09-01
2002-10-01
2.370
2.370
2.370
2.210
2.210
2.210
1.910
1.910
1.910
1.789
1.789
1.789
1.670
1.670
1.670
1.730
1.730
1.730
2.039
2.039
2.039
3.056
3.056
3.056
3.240
3.240
3.240
3.590
3.590
3.590
3.930
3.930
3.930
4.220
4.220
4.220
4.260
4.260
4.260
3.780
3.780
3.780
3.240
3.240
3.219
2.790
2.790
2.790
2.560
2.560
2.560
2.520
2.520
2.532
2.780
15.350
14.910
13.720
14.170
13.470
15.030
14.460
13.000
11.350
12.520
12.010
14.680
17.310
17.720
17.920
20.100
21.280
23.800
22.690
25.000
26.100
27.260
29.370
29.840
25.720
28.790
31.820
29.700
31.260
33.880
33.110
34.420
28.440
29.590
29.610
27.250
27.490
28.630
27.600
26.430
27.370
26.200
22.170
19.640
19.390
19.720
20.720
24.530
26.180
27.040
25.520
26.970
28.390
29.660
28.840
0.085
0.086
0.091
0.091
0.090
0.089
0.086
0.084
0.084
0.084
0.084
0.084
0.084
0.085
0.089
0.090
0.089
0.090
0.087
0.085
0.085
0.084
0.085
0.085
0.085
0.085
0.090
0.091
0.091
0.091
0.088
0.086
0.086
0.088
0.088
0.089
0.089
0.090
0.097
0.099
0.098
0.097
0.093
0.090
0.090
0.089
0.089
0.089
0.088
0.089
0.095
0.095
0.095
0.095
0.091
1.419
1.411
1.388
1.447
1.426
1.361
1.393
1.442
1.388
1.382
1.431
1.404
1.429
1.444
1.448
1.435
1.442
1.484
1.496
1.518
1.528
1.483
1.516
1.532
1.584
1.570
1.556
1.574
1.611
1.579
1.582
1.621
1.625
1.693
1.732
1.740
1.763
1.735
1.703
1.680
1.634
1.717
1.713
1.747
1.713
1.734
1.700
1.740
1.784
1.737
1.719
1.659
1.669
1.676
1.721
106.688
105.967
101.752
100.904
88.358
85.714
95.495
97.385
95.325
97.452
94.564
96.426
94.038
92.717
92.947
83.598
86.382
87.121
85.650
85.409
87.223
92.953
95.082
95.169
95.539
95.531
84.040
75.057
75.241
80.151
84.707
88.937
96.224
94.297
92.378
91.012
87.545
85.078
83.161
90.755
92.879
89.744
86.268
89.883
92.312
91.967
90.728
89.858
87.107
90.331
93.170
99.700
109.891
113.941
109.647
235.091
236.148
231.118
232.427
202.248
193.337
200.755
209.896
204.913
195.037
179.672
175.055
177.536
171.449
170.003
158.312
172.001
180.636
178.179
171.197
169.957
180.384
185.758
190.971
197.104
200.870
186.952
169.497
167.867
180.453
173.608
177.191
185.965
175.423
167.453
164.376
158.611
163.870
170.232
186.654
182.749
172.345
160.632
162.561
160.150
160.058
160.196
168.693
171.358
176.640
185.368
209.093
208.220
208.220
200.089
2002-11-01
2002-12-01
2003-01-01
2003-02-01
2003-03-01
2003-04-01
2003-05-01
2003-06-01
2003-07-01
2003-08-01
2003-09-01
2003-10-01
2003-11-01
2003-12-01
2004-01-01
2004-02-01
2004-03-01
2004-04-01
2004-05-01
2004-06-01
2004-07-01
2004-08-01
2004-09-01
2004-10-01
2004-11-01
2004-12-01
2005-01-01
2005-02-01
2005-03-01
2005-04-01
2005-05-01
2005-06-01
2005-07-01
2005-08-01
2005-09-01
2005-10-01
2005-11-01
2005-12-01
2006-01-01
2006-02-01
2006-03-01
2006-04-01
2006-05-01
2006-06-01
2006-07-01
2006-08-01
2006-09-01
2006-10-01
2006-11-01
2006-12-01
2007-01-01
2007-02-01
2007-03-01
2007-04-01
2007-05-01
2.780
2.814
3.150
3.150
3.170
3.578
3.578
3.580
3.610
3.610
3.610
3.600
3.600
3.600
3.390
3.390
3.390
3.480
3.480
3.480
3.810
3.810
3.810
4.340
4.340
4.340
5.060
5.060
5.060
5.510
5.510
5.510
6.130
6.130
6.130
6.960
6.960
6.960
7.660
7.660
7.660
8.140
8.140
8.140
8.400
8.400
8.400
8.650
8.650
8.650
8.390
8.390
8.390
7.830
7.830
26.350
29.460
32.950
35.830
33.510
28.170
28.110
30.660
30.760
31.570
28.310
30.340
31.110
32.130
34.310
34.690
36.740
36.750
40.280
38.030
40.780
44.900
45.940
53.280
48.470
43.150
46.840
48.150
54.190
52.980
49.830
56.350
59.000
64.990
65.590
62.260
58.320
59.410
65.490
61.630
62.690
69.440
70.840
70.950
74.410
73.040
63.800
58.890
59.080
61.960
54.510
59.280
60.440
63.980
63.460
0.089
0.089
0.089
0.089
0.089
0.091
0.092
0.097
0.098
0.098
0.098
0.093
0.090
0.090
0.091
0.091
0.091
0.091
0.093
0.099
0.099
0.100
0.099
0.094
0.092
0.092
0.094
0.094
0.094
0.095
0.097
0.104
0.105
0.105
0.106
0.102
0.102
0.102
0.108
0.108
0.109
0.109
0.110
0.118
0.118
0.118
0.118
0.112
0.110
0.110
0.113
0.113
0.113
0.113
0.115
1.721
1.693
1.722
1.778
1.858
1.855
1.856
1.932
1.878
2.006
2.022
2.010
2.256
2.232
2.260
2.250
2.196
2.089
2.125
2.078
2.095
2.130
2.121
2.210
2.216
2.140
2.191
2.229
2.218
2.309
2.363
2.338
2.299
2.422
2.377
2.206
2.302
2.303
2.277
2.188
2.251
2.228
2.240
2.237
2.147
2.213
2.202
2.206
2.206
2.259
2.185
2.304
2.292
2.254
2.307
108.646
107.013
105.844
106.141
105.132
105.338
107.906
107.025
97.671
100.350
103.238
104.206
108.100
111.992
116.246
122.932
128.460
133.439
129.285
123.279
104.494
104.093
97.727
93.415
93.759
95.609
96.039
94.359
100.014
96.471
95.365
97.615
105.664
99.287
97.071
101.551
95.980
102.676
102.790
106.937
104.952
107.910
110.625
109.612
114.306
115.277
120.270
142.262
164.106
160.721
165.160
177.385
169.583
152.631
160.139
210.218
208.243
208.674
209.613
210.222
221.709
232.413
229.775
214.032
208.219
231.700
268.988
279.721
283.185
300.899
316.552
360.675
363.505
347.871
320.230
289.785
225.790
206.447
193.434
195.818
198.591
195.665
197.589
233.181
228.765
233.462
254.742
253.348
230.427
212.016
211.167
210.900
216.543
214.009
214.366
212.714
208.902
217.356
216.504
217.252
203.844
199.307
217.886
244.000
243.308
255.867
278.039
276.960
270.392
283.206
2007-06-01
2007-07-01
2007-08-01
2007-09-01
2007-10-01
2007-11-01
2007-12-01
2008-01-01
2008-02-01
2008-03-01
2008-04-01
2008-05-01
2008-06-01
2008-07-01
2008-08-01
2008-09-01
2008-10-01
2008-11-01
2008-12-01
2009-01-01
2009-02-01
2009-03-01
2009-04-01
2009-05-01
2009-06-01
2009-07-01
2009-08-01
2009-09-01
2009-10-01
2009-11-01
2009-12-01
2010-01-01
2010-02-01
2010-03-01
2010-04-01
2010-05-01
2010-06-01
2010-07-01
2010-08-01
2010-09-01
2010-10-01
2010-11-01
2010-12-01
2011-01-01
2011-02-01
2011-03-01
2011-04-01
2011-05-01
2011-06-01
2011-07-01
2011-08-01
2011-09-01
2011-10-01
2011-11-01
2011-12-01
7.830
7.790
7.790
7.790
8.560
8.560
8.560
10.270
10.270
10.270
11.900
11.900
11.900
14.360
14.360
14.360
16.020
16.020
16.020
16.020
14.470
11.470
8.600
8.600
8.600
6.790
6.180
6.180
6.450
6.450
6.450
7.590
7.590
7.590
8.350
7.870
8.060
8.480
8.570
8.490
8.640
8.710
8.730
9.190
9.140
9.120
10.030
10.020
10.000
11.200
11.110
11.110
12.110
12.020
12.110
67.490
74.120
72.360
79.920
85.800
94.770
91.690
92.970
95.390
105.450
112.580
125.400
133.880
133.370
116.670
104.110
76.610
57.310
41.120
41.710
39.090
47.940
49.650
59.030
69.640
64.150
71.050
69.410
75.720
77.990
74.470
78.330
76.390
81.200
84.290
73.740
75.340
76.320
76.600
75.240
81.890
84.250
89.150
89.170
88.580
102.860
109.530
100.900
96.260
97.300
86.330
85.520
86.320
97.160
98.560
0.122
0.122
0.121
0.121
0.117
0.115
0.115
0.116
0.116
0.116
0.118
0.120
0.128
0.131
0.132
0.130
0.126
0.123
0.124
0.126
0.126
0.126
0.125
0.126
0.132
0.131
0.130
0.130
0.126
0.124
0.124
0.124
0.123
0.125
0.126
0.127
0.132
0.133
0.133
0.132
0.127
0.125
0.125
0.125
0.125
0.127
0.127
0.129
0.134
0.135
0.135
0.135
0.130
0.128
0.127
2.333
2.366
2.395
2.372
2.260
2.289
2.234
2.328
2.381
2.293
2.323
2.313
2.269
2.258
2.371
2.419
2.402
2.357
2.406
2.357
2.436
2.269
2.251
2.257
2.234
2.147
2.134
2.138
2.177
2.062
2.186
2.279
2.277
2.240
2.364
2.309
2.400
2.453
2.502
2.398
2.397
2.394
2.378
2.533
2.659
2.715
2.722
2.694
2.774
2.818
2.819
2.868
2.876
2.899
2.921
164.537
147.216
151.031
160.125
164.114
171.114
180.283
206.559
220.048
233.926
246.642
243.532
287.132
267.141
235.159
233.946
183.025
164.304
158.910
173.295
163.400
164.577
168.796
180.070
179.394
151.800
152.036
150.593
167.279
171.687
164.613
167.336
161.907
158.928
157.267
163.240
152.874
163.922
175.600
205.840
235.703
238.237
250.626
265.286
293.397
290.435
318.939
308.575
310.536
300.832
310.307
296.299
274.846
274.278
258.518
302.829
313.476
309.007
347.562
358.403
389.015
423.081
461.715
508.216
495.691
482.791
489.089
552.472
554.149
471.067
433.383
338.785
329.137
318.814
364.718
341.272
333.658
374.466
422.355
445.108
398.089
408.957
349.052
354.865
370.707
379.299
358.967
344.661
348.949
357.639
349.051
348.514
370.976
379.462
390.231
427.176
459.961
483.756
511.105
512.052
498.740
501.469
498.765
499.773
501.827
501.424
490.909
446.016
428.825
420.046
2012-01-01
2012-02-01
2012-03-01
2012-04-01
2012-05-01
2012-06-01
2012-07-01
2012-08-01
2012-09-01
2012-10-01
2012-11-01
2012-12-01
2013-01-01
2013-02-01
2013-03-01
2013-04-01
2013-05-01
2013-06-01
2013-07-01
2013-08-01
2013-09-01
2013-10-01
2013-11-01
2013-12-01
2014-01-01
2014-02-01
2014-03-01
2014-04-01
2014-05-01
2014-06-01
2014-07-01
2014-08-01
2014-09-01
2014-10-01
2014-11-01
2014-12-01
2015-01-01
2015-02-01
2015-03-01
2015-04-01
2015-05-01
2015-06-01
2015-07-01
2015-08-01
2015-09-01
2015-10-01
2015-11-01
2015-12-01
2016-01-01
2016-02-01
2016-03-01
2016-04-01
2016-05-01
2016-06-01
2016-07-01
12.330
12.220
12.510
12.570
12.570
12.560
11.380
11.400
11.380
11.570
11.640
11.640
11.390
11.360
11.360
11.640
11.410
11.320
10.980
10.970
10.960
10.930
10.960
10.990
10.900
10.830
10.690
10.790
10.640
10.520
9.400
10.380
10.400
10.400
10.160
10.450
9.500
9.290
9.290
7.390
7.370
7.300
6.680
6.660
6.490
6.010
5.870
5.810
5.090
4.790
4.090
4.020
3.990
4.040
4.300
100.270
102.200
106.160
103.320
94.660
82.300
87.900
94.130
94.510
89.490
86.530
87.860
94.760
95.310
92.940
92.020
94.510
95.770
104.670
106.570
106.290
100.540
93.860
97.630
94.620
100.820
100.800
102.070
102.180
105.790
103.590
96.540
93.210
84.400
75.790
59.290
47.220
50.580
47.820
54.450
59.270
59.820
50.900
42.870
45.480
46.220
42.440
37.190
31.680
30.320
37.550
40.750
46.710
48.760
44.650
0.128
0.128
0.127
0.127
0.129
0.135
0.133
0.133
0.133
0.128
0.127
0.127
0.129
0.129
0.128
0.128
0.131
0.137
0.137
0.137
0.137
0.132
0.130
0.131
0.134
0.134
0.135
0.131
0.136
0.143
0.143
0.143
0.141
0.136
0.134
0.135
0.138
0.138
0.136
0.137
0.137
0.143
0.142
0.142
0.141
0.136
0.134
0.133
0.134
0.134
0.134
0.134
0.133
0.138
0.139
3.005
2.947
3.016
2.998
2.995
3.007
3.085
2.991
3.024
0.000
3.175
3.080
3.407
3.379
3.332
3.268
3.311
3.382
3.459
3.454
3.502
3.389
3.477
3.460
3.467
3.555
3.698
3.808
3.856
3.880
3.884
4.013
4.096
4.154
4.201
4.156
4.235
4.238
4.200
4.231
4.136
4.221
4.200
4.159
4.126
4.083
4.113
4.060
3.978
3.964
3.955
3.815
3.717
3.725
3.690
272.920
279.514
280.715
274.219
268.885
267.329
332.999
332.233
320.706
321.382
321.597
308.750
303.360
302.610
309.579
279.765
295.369
297.112
279.013
234.939
207.490
201.780
199.182
197.553
198.772
209.356
222.393
222.430
216.975
202.634
182.295
176.482
163.134
163.378
178.709
178.713
174.795
173.759
174.294
172.152
166.350
166.814
179.609
162.741
166.078
171.449
166.092
164.004
161.099
159.717
159.227
164.465
169.002
179.913
161.823
441.733
461.556
496.290
529.422
520.925
522.329
609.447
622.914
615.181
565.525
533.029
534.791
526.047
536.376
536.081
517.790
542.199
560.158
548.350
498.048
503.237
472.828
476.662
488.669
476.102
496.799
522.001
547.188
546.033
528.003
463.234
432.985
368.850
354.441
379.345
378.782
367.492
364.739
359.596
356.926
351.950
354.823
372.347
347.022
323.555
327.420
319.082
323.315
323.204
320.129
326.935
353.802
388.512
421.229
390.402
2016-08-01
2016-09-01
2016-10-01
2016-11-01
2016-12-01
2017-01-01
2017-02-01
2017-03-01
2017-04-01
2017-05-01
2017-06-01
2017-07-01
2017-08-01
2017-09-01
2017-10-01
2017-11-01
2017-12-01
2018-01-01
2018-02-01
2018-03-01
2018-04-01
2018-05-01
2018-06-01
2018-07-01
2018-08-01
2018-09-01
2018-10-01
2018-11-01
2018-12-01
2019-01-01
2019-02-01
2019-03-01
2019-04-01
2019-05-01
2019-06-01
2019-07-01
2019-08-01
2019-09-01
2019-10-01
2019-11-01
2019-12-01
2020-01-01
2020-02-01
2020-03-01
2020-04-01
2020-05-01
2020-06-01
2020-07-01
2020-08-01
2020-09-01
2020-10-01
2020-11-01
2020-12-01
2021-01-01
2021-02-01
4.250
3.960
4.010
4.540
5.160
6.278
6.100
4.945
5.035
5.068
4.984
5.098
5.537
6.033
5.891
6.739
7.214
6.648
7.835
8.512
7.060
7.464
7.510
7.622
8.101
9.525
8.607
8.211
7.884
7.165
5.983
5.196
4.960
4.359
3.483
3.594
3.274
3.094
3.316
4.736
4.232
3.624
2.995
2.786
2.079
1.447
1.648
1.630
2.625
3.866
4.828
4.788
5.833
7.280
6.177
44.720
45.180
49.780
45.660
51.970
52.500
53.470
49.330
51.060
48.480
45.180
46.630
48.040
49.820
51.580
56.640
57.880
63.700
62.230
62.730
66.250
69.980
67.870
70.980
68.060
70.230
70.750
56.960
49.520
51.380
54.950
58.150
63.860
60.830
54.660
57.350
54.810
56.950
53.960
57.030
59.880
57.520
50.540
29.210
16.550
28.560
38.310
40.710
42.340
39.630
39.400
40.940
47.020
52.000
59.040
0.139
0.139
0.134
0.131
0.133
0.134
0.135
0.134
0.135
0.137
0.142
0.143
0.142
0.142
0.137
0.136
0.136
0.135
0.135
0.135
0.134
0.136
0.139
0.139
0.139
0.138
0.136
0.134
0.135
0.135
0.136
0.135
0.135
0.136
0.139
0.140
0.139
0.139
0.136
0.133
0.133
0.134
0.134
0.134
0.133
0.134
0.137
0.137
0.137
0.137
0.135
0.136
0.136
0.136
0.137
3.657
3.665
3.679
3.597
3.559
3.553
3.557
3.594
3.547
3.559
3.679
3.754
3.732
3.707
3.688
3.638
3.708
3.641
3.642
3.657
3.730
3.685
3.729
3.745
3.792
3.743
3.714
3.781
3.725
3.801
3.758
3.725
3.775
3.822
3.812
3.800
3.819
3.851
3.841
3.812
3.862
3.886
3.865
3.881
4.052
4.461
4.737
4.264
4.177
4.076
4.008
4.027
3.951
3.965
3.987
150.215
148.512
152.617
151.331
152.730
160.012
162.963
158.979
156.540
158.600
157.974
157.611
148.543
147.316
148.722
148.792
149.087
155.917
163.461
172.077
175.601
179.179
165.140
156.554
162.522
154.945
160.366
160.878
167.490
166.846
169.656
166.321
161.653
171.180
195.168
189.486
163.629
157.374
167.298
166.362
167.059
171.814
168.745
162.179
147.012
143.989
148.042
152.588
149.393
166.603
186.766
190.625
199.184
231.754
245.554
370.317
355.902
358.387
368.373
375.289
379.590
380.873
366.095
347.861
350.180
339.729
365.453
345.411
353.860
358.276
361.409
357.153
356.869
371.232
381.894
381.268
374.848
339.958
312.562
316.659
306.433
315.852
322.282
330.482
333.777
334.503
329.237
324.254
305.311
326.615
325.470
314.626
322.454
339.871
332.958
334.949
337.080
325.428
319.336
309.994
309.331
318.643
328.935
332.141
366.825
387.575
419.585
443.655
504.312
507.817
2021-03-01
2021-04-01
2021-05-01
2021-06-01
2021-07-01
2021-08-01
2021-09-01
2021-10-01
2021-11-01
6.199
7.286
8.985
10.311
12.545
15.323
22.092
29.788
27.201
62.330
61.720
65.170
71.380
72.490
67.730
71.650
81.480
79.150
0.138
0.139
0.140
0.142
0.143
0.144
0.144
0.142
0.142
4.042
4.096
4.101
4.357
4.388
4.468
4.504
4.719
4.716
245.760
268.622
304.298
292.524
278.446
257.021
235.816
239.602
248.768
519.879
537.418
576.968
537.356
523.571
504.040
469.440
452.022
454.576
und/453.6 Grams) in U.S. City Average, U.S. Dollars, Monthly, Not Seasonally Adjusted
Help: https://fredhelp.stlouisfed.org
Economic Research Division
Federal Reserve Bank of St. Louis
Source: U.S. Bureau of Economic Analysis
GDP Chg: Gross Domestic Product, Percent Change from Preceding Per
UNRATE: Unemployment Rate, Percent, Monthly, Seasonally Adjusted
Remove all lines above data before importing into Tableau.
Date
GDP Chg
1990-01-01
9.00
1990-04-01
6.10
1990-07-01
3.70
1990-10-01
(0.70)
1991-01-01
2.00
1991-04-01
6.20
1991-07-01
5.30
1991-10-01
3.80
1992-01-01
6.40
1992-04-01
6.90
1992-07-01
6.10
1992-10-01
7.10
1993-01-01
2.90
1993-04-01
4.80
1993-07-01
4.40
1993-10-01
7.90
1994-01-01
5.90
1994-04-01
7.60
1994-07-01
4.70
1994-10-01
7.00
1995-01-01
3.60
1995-04-01
3.20
1995-07-01
5.50
1995-10-01
4.70
1996-01-01
5.00
1996-04-01
8.60
1996-07-01
5.00
1996-10-01
6.50
1997-01-01
5.10
1997-04-01
7.70
1997-07-01
6.90
1997-10-01
4.80
1998-01-01
4.70
1998-04-01
4.70
1998-07-01
6.90
1998-10-01
7.80
1999-01-01
5.20
1999-04-01
5.00
1999-07-01
6.90
1999-10-01
9.10
2000-01-01
4.20
2000-04-01
10.20
2000-07-01
2.80
2000-10-01
4.60
2001-01-01
1.30
2001-04-01
5.00
2001-07-01
0.00
Unrate
5.40
5.30
5.20
5.40
5.40
5.20
5.50
5.70
5.90
5.90
6.20
6.30
6.40
6.60
6.80
6.70
6.90
6.90
6.80
6.90
6.90
7.00
7.00
7.30
7.30
7.40
7.40
7.40
7.60
7.80
7.70
7.60
7.60
7.30
7.40
7.40
7.30
7.10
7.00
7.10
7.10
7.00
6.90
6.80
6.70
6.80
6.60
2001-10-01
2002-01-01
2002-04-01
2002-07-01
2002-10-01
2003-01-01
2003-04-01
2003-07-01
2003-10-01
2004-01-01
2004-04-01
2004-07-01
2004-10-01
2005-01-01
2005-04-01
2005-07-01
2005-10-01
2006-01-01
2006-04-01
2006-07-01
2006-10-01
2007-01-01
2007-04-01
2007-07-01
2007-10-01
2008-01-01
2008-04-01
2008-07-01
2008-10-01
2009-01-01
2009-04-01
2009-07-01
2009-10-01
2010-01-01
2010-04-01
2010-07-01
2010-10-01
2011-01-01
2011-04-01
2011-07-01
2011-10-01
2012-01-01
2012-04-01
2012-07-01
2012-10-01
2013-01-01
2013-04-01
2013-07-01
2013-10-01
2014-01-01
2014-04-01
2014-07-01
2014-10-01
2015-01-01
2015-04-01
2.40
4.70
3.90
3.60
2.80
4.10
5.10
9.30
7.30
5.20
6.50
6.50
7.40
7.90
5.00
7.00
5.60
8.50
4.60
3.40
5.00
5.10
5.30
4.60
4.20
(0.20)
4.40
0.90
(7.60)
(4.80)
(1.40)
1.90
5.70
3.10
6.00
4.40
4.50
1.10
5.50
2.30
5.10
5.80
3.50
2.80
2.50
5.20
1.70
5.20
5.40
0.30
7.60
6.60
2.50
3.10
4.60
6.50
6.60
6.60
6.50
6.40
6.10
6.10
6.10
6.00
5.90
5.80
5.60
5.50
5.60
5.40
5.40
5.80
5.60
5.60
5.70
5.70
5.60
5.50
5.60
5.60
5.60
5.50
5.50
5.60
5.60
5.30
5.50
5.10
5.20
5.20
5.40
5.40
5.30
5.20
5.20
5.10
4.90
5.00
4.90
4.80
4.90
4.70
4.60
4.70
4.60
4.60
4.70
4.30
4.40
4.50
2015-07-01
2015-10-01
2016-01-01
2016-04-01
2016-07-01
2016-10-01
2017-01-01
2017-04-01
2017-07-01
2017-10-01
2018-01-01
2018-04-01
2018-07-01
2018-10-01
2019-01-01
2019-04-01
2019-07-01
2019-10-01
2020-01-01
2020-04-01
2020-07-01
2020-10-01
2021-01-01
2021-04-01
2021-07-01
2.50
0.50
2.00
4.10
3.60
4.20
4.00
3.60
5.00
6.80
5.30
7.10
3.30
3.00
3.70
5.60
4.10
3.60
(3.90)
(32.40)
38.70
6.60
10.90
13.40
8.40
4.50
4.50
4.60
4.50
4.40
4.40
4.30
4.40
4.20
4.30
4.20
4.30
4.30
4.20
4.20
4.10
4.10
4.00
4.00
4.10
4.00
3.80
4.00
4.00
4.00
4.10
3.90
3.90
3.90
3.90
4.20
4.20
4.30
4.40
4.30
4.50
4.60
4.90
5.00
5.30
5.50
5.70
5.70
5.70
5.70
5.90
5.80
5.80
5.80
5.70
5.70
5.70
5.90
6.00
5.80
5.90
5.90
6.00
6.10
6.30
6.20
6.10
6.10
6.00
5.80
5.70
5.70
5.60
5.80
5.60
5.60
5.60
5.50
5.40
5.40
5.50
5.40
5.40
5.30
5.40
5.20
5.20
5.10
5.00
5.00
4.90
5.00
5.00
5.00
4.90
4.70
4.80
4.70
4.70
4.60
4.60
4.70
4.70
4.50
4.40
4.50
4.40
4.60
4.50
4.40
4.50
4.40
4.60
4.70
4.60
4.70
4.70
4.70
5.00
5.00
4.90
5.10
5.00
5.40
5.60
5.80
6.10
6.10
6.50
6.80
7.30
7.80
8.30
8.70
9.00
9.40
9.50
9.50
9.60
9.80
10.00
9.90
9.90
9.80
9.80
9.90
9.90
9.60
9.40
9.40
9.50
9.50
9.40
9.80
9.30
9.10
9.00
9.00
9.10
9.00
9.10
9.00
9.00
9.00
8.80
8.60
8.50
8.30
8.30
8.20
8.20
8.20
8.20
8.20
8.10
7.80
7.80
7.70
7.90
8.00
7.70
7.50
7.60
7.50
7.50
7.30
7.20
7.20
7.20
6.90
6.70
6.60
6.70
6.70
6.20
6.30
6.10
6.20
6.10
5.90
5.70
5.80
5.60
5.70
5.50
5.40
5.40
5.60
5.30
5.20
5.10
5.00
5.00
5.10
5.00
4.80
4.90
5.00
5.10
4.80
4.90
4.80
4.90
5.00
4.90
4.70
4.70
4.70
4.60
4.40
4.50
4.40
4.30
4.30
4.40
4.20
4.10
4.20
4.10
4.00
4.10
4.00
4.00
3.80
4.00
3.80
3.80
3.70
3.80
3.80
3.90
4.00
3.80
3.80
3.70
3.70
3.60
3.60
3.70
3.50
3.60
3.60
3.60
3.50
3.50
4.40
14.80
13.30
11.10
10.20
8.40
7.80
6.90
6.70
6.70
6.30
6.20
6.00
6.10
5.80
5.90
5.40
5.20
4.80
4.60
4.20
ent Change from Preceding Period, Quarterly, Seasonally Adjusted Annual Rate
NBER
https://www.nber.org/research/business-cycle-dating
Contraction
Peak
Trough
Duration,
Trough month (Trough
Peak month (Peak Quarter)
month
month
peak to
Quarter)
number number
trough
Remove all lines above data before importing into Tableau.
June 1857 (1857Q2)
October 1860 (1860Q3)
April 1865 (1865Q1)
June 1869 (1869Q2)
October 1873 (1873Q3)
March 1882 (1882Q1)
March 1887 (1887Q2)
July 1890 (1890Q3)
January 1893 (1893Q1)
December 1895 (1895Q4)
June 1899 (1899Q3)
September 1902 (1902Q4)
May 1907 (1907Q2)
January 1910 (1910Q1)
January 1913 (1913Q1)
August 1918 (1918Q3)
January 1920 (1920Q1)
May 1923 (1923Q2)
October 1926 (1926Q3)
August 1929 (1929Q3)
May 1937 (1937Q2)
February 1945 (1945Q1)
November 1948 (1948Q4)
July 1953 (1953Q2)
August 1957 (1957Q3)
April 1960 (1960Q2)
December 1969 (1969Q4)
November 1973 (1973Q4)
January 1980 (1980Q1)
July 1981 (1981Q3)
July 1990 (1990Q3)
March 2001 (2001Q1)
December 2007 (2007Q4)
February 2020 (2019Q4)
1854-2020
1854-1919
1919-1945
1945-2020
December 1854 (1854Q4)
December 1858 (1858Q4)
June 1861 (1861Q3)
December 1867 (1868Q1)
December 1870 (1870Q4)
March 1879 (1879Q1)
May 1885 (1885Q2)
April 1888 (1888Q1)
May 1891 (1891Q2)
June 1894 (1894Q2)
June 1897 (1897Q2)
December 1900 (1900Q4)
August 1904 (1904Q3)
June 1908 (1908Q2)
January 1912 (1911Q4)
December 1914 (1914Q4)
March 1919 (1919Q1)
July 1921 (1921Q3)
July 1924 (1924Q3)
November 1927 (1927Q4)
March 1933 (1933Q1)
June 1938 (1938Q2)
October 1945 (1945Q4)
October 1949 (1949Q4)
May 1954 (1954Q2)
April 1958 (1958Q2)
February 1961 (1961Q1)
November 1970 (1970Q4)
March 1975 (1975Q1)
July 1980 (1980Q3)
November 1982 (1982Q4)
March 1991 (1991Q1)
November 2001 (2001Q4)
June 2009 (2009Q2)
April 2020 (2020Q2)
690
730
784
834
886
987
1,047
1,087
1,117
1,152
1,194
1,233
1,289
1,321
1,357
1,424
1,441
1,481
1,522
1,556
1,649
1,742
1,787
1,843
1,892
1,924
2,040
2,087
2,161
2,179
2,287
2,415
2,496
2,642
660
708
738
816
852
951
1,025
1,060
1,097
1,134
1,170
1,212
1,256
1,302
1,345
1,380
1,431
1,459
1,495
1,535
1,599
1,662
1,750
1,798
1,853
1,900
1,934
2,051
2,103
2,167
2,195
2,295
2,423
2,514
2,644
18
8
32
18
65
38
13
10
17
18
18
23
13
24
23
7
18
14
13
43
13
8
11
10
8
10
11
16
6
16
8
8
18
2
17.0
21.6
18.2
10.3
Expansion
Duration,
trough to
peak
Cycle
Duration, Duration,
trough to
peak to
trough
peak
30
22
46
18
34
36
22
27
20
18
24
21
33
19
12
44
10
22
27
21
50
80
37
45
39
24
106
36
58
12
92
120
73
128
48
30
78
36
99
74
35
37
37
36
42
44
46
43
35
51
28
36
40
64
63
88
48
55
47
34
117
52
64
28
100
128
91
130
40
54
50
52
101
60
40
30
35
42
39
56
32
36
67
17
40
41
34
93
93
45
56
49
32
116
47
74
18
108
128
81
146
41.4
26.6
35.0
64.2
58.4
48.2
53.2
74.5
59.2
48.9
53.0
75.0
Corporate and Index fund data avaiable for Tableau Assignment
Monthly data, 01/01/2010 AAPL
Apple Inc.
LRCX
Lam Research Corporation
AMD
Advanced Micro Devices, Inc.
TSLA
Tesla, Inc. (07/01/2010 – )
JPM
JPMorgan Chase & Co.
VFINX
Vanguard 500 Index Fund Investor Shares
VFSNX
Vanguard FTSE All-World ex-US Small-Cap Index Fund Institutional Shares
VFTNX
Vanguard FTSE Social Index Fund Institutional Shares
VMCIX Vanguard Mid-Cap Index Fund Institutional Shares
VITAX
Vanguard Information Technology Index Fund Admiral Shares
VBIMX Vanguard Intermediate-Term Bond Index Fund Institutional Shares
VFAIX
Vanguard Financials Index Fund Admiral Shares
Important: Remove all lines above data before importing into Tableau.
AAPL
Apple, Inc.
Important: Remove all lines above data before importing into Tableau.
Date
Open
High
Low
Close
Adj Close
Volume
1/1/2010
7.62
7.70
6.79
6.86
5.88
15,168,994,400
2/1/2010
6.87
7.33
6.82
7.31
6.27
10,776,080,000
3/1/2010
7.35
8.48
7.34
8.39
7.20
12,154,172,800
4/1/2010
8.48
9.73
8.31
9.32
7.99
12,367,129,600
5/1/2010
9.42
9.57
7.12
9.17
7.87
18,082,654,800
6/1/2010
9.27
9.96
8.65
8.98
7.70
16,651,252,800
7/1/2010
9.08
9.50
8.56
9.19
7.88
15,669,704,400
8/1/2010
9.30
9.44
8.41
8.68
7.44
9,589,120,800
9/1/2010
8.84
10.53
8.80
10.13
8.69
11,849,919,200
10/1/2010
10.22
11.39
9.92
10.75
9.22
12,234,577,600
11/1/2010
10.79
11.48
10.63
11.11
9.53
9,508,086,000
12/1/2010
11.26
11.67
11.25
11.52
9.88
6,973,234,800
1/1/2011
11.63
12.45
11.60
12.12
10.39
10,841,535,600
2/1/2011
12.19
13.03
12.06
12.61
10.82
9,295,949,600
3/1/2011
12.70
12.92
11.65
12.45
10.67
11,306,458,800
4/1/2011
12.54
12.68
11.43
12.50
10.72
9,253,829,200
5/1/2011
12.49
12.57
11.77
12.42
10.65
6,912,060,400
6/1/2011
12.46
12.58
11.09
11.99
10.28
9,263,850,400
7/1/2011
12.00
14.45
11.94
13.95
11.96
10,653,946,800
8/1/2011
14.21
14.27
12.61
13.74
11.78
16,142,599,200
9/1/2011
13.78
15.10
13.09
13.62
11.68
11,977,448,000
10/1/2011
13.58
15.24
12.65
14.46
12.39
13,141,427,600
11/1/2011
14.19
14.57
12.98
13.65
11.70
8,963,701,600
12/1/2011
13.66
14.61
13.49
14.46
12.40
6,306,532,400
1/1/2012
14.62
16.37
14.61
16.30
13.98
6,859,854,400
2/1/2012
16.37
19.56
16.21
19.37
16.61
11,368,554,400
3/1/2012
19.58
22.19
18.44
21.41
18.36
15,584,338,000
4/1/2012
21.49
23.00
19.82
20.86
17.88
15,598,990,400
5/1/2012
20.89
21.31
18.65
20.63
17.69
11,106,345,600
6/1/2012
20.33
21.07
19.59
20.86
17.88
7,855,825,600
7/1/2012
20.88
22.14
20.36
21.81
18.70
8,909,650,400
8/1/2012
22.00
24.32
21.44
23.76
20.37
8,276,206,400
9/1/2012
23.78
25.18
23.43
23.83
20.51
9,199,005,200
10/1/2012
23.97
24.17
20.99
21.26
18.31
12,142,830,000
11/1/2012
21.37
21.54
18.06
20.90
18.00
12,929,851,200
12/1/2012
21.20
21.24
17.90
19.01
16.44
12,132,752,800
1/1/2013
19.78
19.82
15.54
16.27
14.07
13,123,423,600
2/1/2013
16.40
17.32
15.63
15.76
13.64
9,344,034,000
3/1/2013
15.64
16.78
14.96
15.81
13.75
9,176,876,800
4/1/2013
15.78
15.90
13.75
15.81
13.76
10,963,489,600
5/1/2013
15.87
16.63
14.96
16.06
13.97
9,447,530,400
6/1/2013
16.10
16.23
13.89
14.16
12.40
7,018,536,000
7/1/2013
14.38
16.33
14.33
16.16
14.15
6,538,114,800
8/1/2013
16.28
18.35
16.19
17.40
15.24
8,058,338,400
9/1/2013
17.61
18.14
15.97
17.03
15.01
8,630,941,200
10/1/2013
17.09
19.26
17.08
18.67
16.46
7,837,732,000
11/1/2013
18.72
19.94
18.30
19.86
17.51
5,225,155,600
12/1/2013
19.93
20.54
19.24
20.04
17.77
7,057,397,200
1/1/2014
19.85
20.01
17.63
17.88
15.85
8,765,954,400
2/1/2014
17.95
19.69
17.83
18.79
16.67
5,880,366,800
3/1/2014
4/1/2014
5/1/2014
6/1/2014
7/1/2014
8/1/2014
9/1/2014
10/1/2014
11/1/2014
12/1/2014
1/1/2015
2/1/2015
3/1/2015
4/1/2015
5/1/2015
6/1/2015
7/1/2015
8/1/2015
9/1/2015
10/1/2015
11/1/2015
12/1/2015
1/1/2016
2/1/2016
3/1/2016
4/1/2016
5/1/2016
6/1/2016
7/1/2016
8/1/2016
9/1/2016
10/1/2016
11/1/2016
12/1/2016
1/1/2017
2/1/2017
3/1/2017
4/1/2017
5/1/2017
6/1/2017
7/1/2017
8/1/2017
9/1/2017
10/1/2017
11/1/2017
12/1/2017
1/1/2018
2/1/2018
3/1/2018
4/1/2018
5/1/2018
6/1/2018
7/1/2018
8/1/2018
9/1/2018
18.69
19.21
21.14
22.64
23.38
23.73
25.76
25.15
27.06
29.70
27.85
29.51
32.31
31.21
31.53
32.57
31.73
30.38
27.54
27.27
30.20
29.69
25.65
24.12
24.41
27.20
23.49
24.75
23.87
26.10
26.54
28.18
28.37
27.59
28.95
31.76
34.47
35.93
36.28
38.29
36.22
37.28
41.20
38.56
42.47
42.49
42.54
41.79
44.63
41.66
41.60
47.00
45.96
49.78
57.10
19.61
21.41
23.01
23.76
24.86
25.73
25.93
27.01
29.94
29.81
30.00
33.40
32.57
33.63
33.24
32.85
33.24
30.64
29.22
30.31
30.96
29.97
26.46
24.72
27.61
28.10
25.18
25.47
26.14
27.56
29.05
29.67
28.44
29.50
30.61
34.37
36.13
36.37
39.16
38.99
38.50
41.13
41.24
42.41
44.06
44.30
45.03
45.15
45.88
44.74
47.59
48.55
48.99
57.22
57.42
18.67
18.26
20.73
22.23
23.14
23.32
24.04
23.80
26.93
26.57
26.16
29.02
30.41
30.78
30.84
31.12
29.81
23.00
26.84
26.83
27.75
26.21
23.10
23.15
24.36
23.13
22.37
22.88
23.59
26.00
25.63
28.07
26.02
27.06
28.69
31.75
34.26
35.01
36.07
35.55
35.60
37.10
37.29
38.12
41.32
41.62
41.17
37.56
41.24
40.16
41.32
45.18
45.86
49.33
53.83
19.17
21.07
22.61
23.23
23.90
25.63
25.19
27.00
29.73
27.59
29.29
32.12
31.11
31.29
32.57
31.36
30.33
28.19
27.58
29.88
29.58
26.32
24.33
24.17
27.25
23.43
24.97
23.90
26.05
26.53
28.26
28.39
27.63
28.96
30.34
34.25
35.92
35.91
38.19
36.01
37.18
41.00
38.53
42.26
42.96
42.31
41.86
44.53
41.95
41.31
46.72
46.28
47.57
56.91
56.44
17.10
18.80
20.17
20.84
21.44
22.99
22.71
24.34
26.80
24.98
26.52
29.08
28.27
28.44
29.60
28.62
27.68
25.73
25.28
27.39
27.12
24.23
22.41
22.26
25.23
21.70
23.11
22.26
24.27
24.71
26.47
26.58
25.87
27.25
28.56
32.24
33.95
33.95
36.10
34.18
35.30
38.92
36.72
40.27
40.94
40.46
40.03
42.59
40.28
39.68
44.86
44.61
45.86
54.86
54.60
5,001,698,800
6,435,060,800
5,735,668,400
4,827,739,200
4,140,344,000
3,748,308,000
6,105,680,000
5,441,120,800
3,281,632,800
4,294,378,400
5,221,053,600
4,546,140,800
4,554,568,400
3,984,542,000
3,816,608,400
3,514,426,800
4,233,122,400
6,427,276,400
4,826,189,200
4,450,048,400
3,002,562,400
3,687,660,800
5,087,392,000
3,243,450,400
2,984,198,400
3,489,534,800
3,602,686,000
3,117,990,800
2,743,118,400
2,520,514,000
3,872,062,400
2,747,657,200
2,886,220,000
2,435,086,800
2,252,488,000
2,299,874,400
2,246,513,600
1,493,216,400
2,615,927,200
2,736,712,400
1,688,047,600
2,644,276,000
2,721,496,400
2,017,165,200
2,402,653,600
2,124,735,200
2,638,717,600
3,711,577,200
2,854,910,800
2,664,617,200
2,483,905,200
2,110,498,000
1,574,765,600
2,801,275,600
2,715,888,000
10/1/2018
11/1/2018
12/1/2018
1/1/2019
2/1/2019
3/1/2019
4/1/2019
5/1/2019
6/1/2019
7/1/2019
8/1/2019
9/1/2019
10/1/2019
11/1/2019
12/1/2019
1/1/2020
2/1/2020
3/1/2020
4/1/2020
5/1/2020
6/1/2020
7/1/2020
8/1/2020
9/1/2020
10/1/2020
11/1/2020
12/1/2020
1/1/2021
2/1/2021
3/1/2021
4/1/2021
5/1/2021
6/1/2021
7/1/2021
8/1/2021
9/1/2021
10/1/2021
11/1/2021
12/1/2021
56.99
54.76
46.12
38.72
41.74
43.57
47.91
52.47
43.90
50.79
53.47
51.61
56.27
62.38
66.82
74.06
76.07
70.57
61.63
71.56
79.44
91.28
108.20
132.76
117.64
109.11
121.01
133.52
133.75
123.75
123.66
132.04
125.08
136.60
146.36
152.83
141.90
148.99
167.48
58.37
55.59
46.24
42.25
43.97
49.42
52.12
53.83
50.39
55.34
54.51
56.61
62.44
67.00
73.49
81.96
81.81
76.00
73.63
81.06
93.10
106.42
131.00
137.98
125.39
121.99
138.79
145.09
137.88
128.72
137.07
134.07
137.41
150.00
153.49
157.26
153.17
165.70
182.13
51.52
42.56
36.65
35.50
41.48
42.38
47.10
43.75
42.57
49.60
48.15
51.06
53.78
62.29
64.07
73.19
64.09
53.15
59.22
71.46
79.30
89.14
107.89
103.10
107.72
107.32
120.01
126.38
118.39
116.21
122.49
122.25
123.13
135.76
144.50
141.27
138.27
147.48
157.80
54.72
44.65
39.44
41.61
43.29
47.49
50.17
43.77
49.48
53.26
52.19
55.99
62.19
66.81
73.41
77.38
68.34
63.57
73.45
79.49
91.20
106.26
129.04
115.81
108.86
119.05
132.69
131.96
121.26
122.15
131.46
124.61
136.96
145.86
151.83
141.50
149.80
165.30
177.57
52.93
43.19
38.28
40.39
42.02
46.30
48.91
42.67
48.43
52.13
51.07
55.01
61.10
65.64
72.34
76.24
67.34
62.79
72.55
78.51
90.32
105.24
127.80
114.90
108.01
118.12
131.88
131.15
120.52
121.58
130.85
124.03
136.56
145.43
151.38
141.29
149.58
165.06
177.57
3,158,994,000
3,845,305,600
3,595,690,000
3,312,349,600
1,890,162,400
2,603,925,600
2,024,470,800
2,957,826,400
2,060,874,800
1,895,406,800
2,724,326,400
2,170,268,400
2,433,210,800
1,793,326,000
2,388,794,800
2,934,370,400
3,019,279,200
6,280,072,400
3,265,299,200
2,805,936,000
3,243,375,600
3,020,283,200
4,070,061,100
3,885,245,100
2,894,666,500
2,123,077,300
2,322,189,600
2,240,262,000
1,833,855,600
2,650,418,200
1,889,857,500
1,711,934,900
1,606,590,000
1,918,976,500
1,460,744,100
1,797,465,800
1,564,866,800
1,690,808,300
2,444,341,400
LRCX
Lam Research Corporation
Important: Remove all lines above data before importing into Tableau.
Date
Open
High
Low
Close
Adj Close
Volume
1/1/2010
39.70
41.56
32.60
33.01
29.37
53,865,300
2/1/2010
33.15
35.98
32.07
33.91
30.17
59,210,400
3/1/2010
34.09
37.79
32.56
37.32
33.20
69,333,800
4/1/2010
37.53
43.42
37.06
40.54
36.06
48,202,300
5/1/2010
40.60
41.81
35.33
37.86
33.68
45,403,200
6/1/2010
37.64
43.42
36.36
38.06
33.86
53,841,000
7/1/2010
37.97
43.76
36.94
42.19
37.53
54,958,900
8/1/2010
42.51
42.93
35.43
36.11
32.12
46,580,200
9/1/2010
36.95
43.00
35.39
41.85
37.23
49,191,700
10/1/2010
42.30
46.53
36.77
45.79
40.73
61,320,100
11/1/2010
45.97
48.78
43.99
45.40
40.39
42,605,100
12/1/2010
46.33
52.91
46.14
51.78
46.06
38,525,300
1/1/2011
51.69
54.29
46.27
49.89
44.38
57,590,800
2/1/2011
50.45
56.38
50.32
54.90
48.84
27,417,600
3/1/2011
55.31
59.10
49.60
56.66
50.40
45,458,900
4/1/2011
57.15
57.41
47.92
48.31
42.98
49,314,800
5/1/2011
48.54
49.88
44.90
46.99
41.80
60,228,200
6/1/2011
46.97
48.88
41.77
44.28
39.39
47,954,900
7/1/2011
44.32
46.27
40.69
40.88
36.37
53,391,200
8/1/2011
41.55
41.77
35.03
37.16
33.06
66,849,300
9/1/2011
37.48
40.77
34.92
37.98
33.79
65,270,900
10/1/2011
37.74
44.38
36.06
42.99
38.24
64,102,300
11/1/2011
41.83
45.48
36.59
40.77
36.27
49,354,400
12/1/2011
40.85
43.67
34.81
37.02
32.93
84,928,300
1/1/2012
37.72
44.47
36.15
42.59
37.89
92,861,300
2/1/2012
43.14
45.04
39.90
41.70
37.10
61,099,400
3/1/2012
41.76
45.29
38.62
44.62
39.69
74,629,100
4/1/2012
44.38
44.55
39.49
41.67
37.07
52,190,800
5/1/2012
41.75
42.36
36.89
37.30
33.18
74,348,400
6/1/2012
36.52
38.99
35.56
37.74
33.57
108,019,000
7/1/2012
37.98
37.99
33.24
34.41
30.61
80,101,000
8/1/2012
34.65
35.99
33.39
34.13
30.36
53,828,900
9/1/2012
34.09
35.08
31.17
31.78
28.27
73,306,100
10/1/2012
31.79
36.72
31.33
35.40
31.49
86,492,200
11/1/2012
35.49
38.14
33.88
35.12
31.24
59,398,900
12/1/2012
35.28
37.18
34.70
36.13
32.14
50,785,300
1/1/2013
37.02
42.24
36.84
41.14
36.60
53,851,000
2/1/2013
41.38
43.38
40.74
42.30
37.63
40,629,400
3/1/2013
42.09
43.92
40.44
41.46
36.88
45,279,000
4/1/2013
41.34
46.72
39.94
46.22
41.12
55,897,600
5/1/2013
45.95
48.37
45.44
46.78
41.61
38,053,900
6/1/2013
47.50
49.13
43.35
44.34
39.44
41,619,400
7/1/2013
44.59
50.96
44.11
49.22
43.79
42,147,600
8/1/2013
49.84
51.00
46.20
46.67
41.52
31,275,900
9/1/2013
47.30
52.31
46.44
51.20
45.55
37,377,400
10/1/2013
51.33
55.48
49.93
54.27
48.28
49,690,500
11/1/2013
54.42
54.50
49.54
52.11
46.36
35,008,100
12/1/2013
51.98
54.74
50.71
54.45
48.44
30,065,100
1/1/2014
54.04
56.52
50.17
50.61
45.02
47,719,400
2/1/2014
49.85
53.47
48.45
51.73
46.02
44,194,600
3/1/2014
4/1/2014
5/1/2014
6/1/2014
7/1/2014
8/1/2014
9/1/2014
10/1/2014
11/1/2014
12/1/2014
1/1/2015
2/1/2015
3/1/2015
4/1/2015
5/1/2015
6/1/2015
7/1/2015
8/1/2015
9/1/2015
10/1/2015
11/1/2015
12/1/2015
1/1/2016
2/1/2016
3/1/2016
4/1/2016
5/1/2016
6/1/2016
7/1/2016
8/1/2016
9/1/2016
10/1/2016
11/1/2016
12/1/2016
1/1/2017
2/1/2017
3/1/2017
4/1/2017
5/1/2017
6/1/2017
7/1/2017
8/1/2017
9/1/2017
10/1/2017
11/1/2017
12/1/2017
1/1/2018
2/1/2018
3/1/2018
4/1/2018
5/1/2018
6/1/2018
7/1/2018
8/1/2018
9/1/2018
51.33
55.13
57.73
62.25
68.00
69.56
72.10
74.69
77.74
82.00
79.87
76.76
83.05
70.59
76.09
82.77
82.92
76.71
70.83
65.28
76.82
78.30
77.77
71.20
73.50
82.28
76.40
82.54
83.95
90.17
93.60
94.15
97.16
105.65
106.68
115.91
118.97
128.62
145.93
155.26
142.71
160.44
166.02
185.04
210.45
190.00
185.15
190.00
192.49
201.49
184.14
200.00
169.99
189.87
171.75
57.16
58.94
62.22
67.99
72.92
72.44
77.35
78.37
83.40
85.70
82.16
84.49
84.48
81.65
83.35
84.39
84.13
76.88
74.92
77.36
79.04
81.29
78.55
74.62
83.51
83.83
83.39
87.19
93.80
95.77
95.41
102.44
108.20
110.35
119.14
119.42
129.35
148.00
157.77
167.05
170.00
167.32
185.23
210.09
219.70
193.00
218.48
199.79
234.88
212.85
209.92
205.95
196.70
190.80
172.92
50.50
50.54
55.40
61.77
66.70
67.50
71.14
65.78
77.07
76.33
75.49
75.00
69.07
69.56
74.53
79.53
73.81
62.85
61.20
63.22
75.01
76.15
66.14
63.10
73.06
75.68
72.00
79.15
80.68
88.13
89.80
94.08
93.69
97.79
105.79
113.20
116.40
124.91
145.13
140.01
139.24
148.26
162.52
180.79
189.26
175.80
183.87
156.83
182.16
181.67
183.74
166.37
166.89
166.32
147.54
55.00
57.61
62.04
67.58
70.00
71.91
74.70
77.86
82.64
79.34
76.44
82.46
70.24
75.58
82.25
81.35
76.87
72.77
65.33
76.59
78.20
79.42
71.79
73.30
82.60
76.40
82.81
84.06
89.77
93.32
94.71
96.86
106.02
105.73
114.86
118.54
128.36
144.85
155.17
141.43
159.46
165.98
185.04
208.57
192.33
184.07
191.52
191.86
203.16
185.06
198.18
172.85
190.64
173.09
151.70
48.93
51.25
55.19
60.12
62.44
64.15
66.64
69.63
73.90
70.95
68.51
73.90
62.95
67.89
73.88
73.07
69.30
65.60
58.89
69.33
70.79
71.89
65.24
66.61
75.06
69.71
75.56
76.70
82.21
85.46
86.73
88.99
97.41
97.14
105.99
109.38
118.44
134.17
143.73
131.00
148.12
154.18
171.88
194.26
179.13
171.44
178.87
179.19
189.74
173.27
185.56
161.84
179.46
162.94
142.81
41,670,100
58,555,300
37,559,800
34,166,400
49,425,200
29,418,700
32,136,100
59,308,600
27,264,800
39,432,500
38,450,500
31,143,500
50,492,300
54,933,600
32,084,800
36,878,800
48,270,000
51,146,500
48,643,800
79,539,500
40,311,000
41,938,000
65,150,100
58,320,300
50,851,000
57,918,200
60,463,800
49,705,500
42,804,600
51,750,600
44,018,100
76,658,500
44,636,300
40,471,100
39,569,100
33,668,900
33,938,100
36,441,500
43,933,500
62,170,400
47,785,100
51,966,300
40,482,100
49,126,700
49,977,800
61,508,600
77,262,900
75,327,300
84,095,400
81,839,600
57,160,500
86,690,000
58,106,400
57,240,800
56,285,600
10/1/2018
11/1/2018
12/1/2018
1/1/2019
2/1/2019
3/1/2019
4/1/2019
5/1/2019
6/1/2019
7/1/2019
8/1/2019
9/1/2019
10/1/2019
11/1/2019
12/1/2019
1/1/2020
2/1/2020
3/1/2020
4/1/2020
5/1/2020
6/1/2020
7/1/2020
8/1/2020
9/1/2020
10/1/2020
11/1/2020
12/1/2020
1/1/2021
2/1/2021
3/1/2021
4/1/2021
5/1/2021
6/1/2021
7/1/2021
8/1/2021
9/1/2021
10/1/2021
11/1/2021
12/1/2021
150.63
142.64
161.00
133.46
170.20
177.67
182.00
208.04
175.48
194.57
207.89
211.00
233.00
273.82
266.48
295.78
300.00
296.64
228.95
246.73
270.60
322.15
380.80
339.55
339.14
348.12
460.06
478.15
491.05
576.56
611.23
629.27
656.00
647.67
646.20
607.94
571.12
565.00
692.70
154.85
157.18
162.87
172.90
185.24
187.96
209.50
209.04
195.29
218.49
217.70
244.98
282.88
285.87
299.39
319.00
344.32
309.65
281.95
279.81
325.80
381.48
387.70
365.14
381.96
460.62
516.65
585.42
603.60
603.49
669.00
655.32
673.80
649.38
659.49
621.99
579.94
693.00
728.38
133.42
139.87
122.64
131.35
169.43
163.60
181.45
174.53
171.04
178.92
190.71
209.02
225.00
260.12
255.50
287.54
273.66
181.38
213.29
229.69
267.10
316.12
336.24
292.28
328.56
345.18
457.59
473.32
486.92
501.67
608.20
555.80
608.58
575.33
559.83
566.85
535.01
561.36
642.43
141.73
156.96
136.17
169.58
176.09
179.01
207.43
174.61
187.84
208.61
210.51
231.11
271.04
266.83
292.40
298.21
293.43
240.00
255.28
273.67
323.46
377.16
336.34
331.75
342.08
452.66
472.27
483.95
567.19
595.24
620.45
649.85
650.70
637.41
604.82
569.15
563.57
679.85
719.15
134.35
148.78
129.08
161.85
168.07
170.85
199.19
167.68
180.38
201.49
203.32
223.22
263.10
259.01
283.83
290.72
286.06
233.97
250.36
268.40
317.23
371.36
331.17
326.65
338.12
447.43
466.81
479.58
562.07
589.87
616.34
645.55
646.39
634.46
602.02
566.51
562.34
678.36
717.58
82,983,000
57,935,600
57,699,700
72,624,000
39,479,400
48,400,300
40,686,500
41,882,700
38,330,200
38,196,400
36,860,600
36,887,200
40,248,500
28,055,900
28,722,300
35,559,500
39,451,900
63,092,500
47,163,300
50,276,800
44,793,400
35,754,300
30,809,100
44,505,200
31,470,900
26,336,100
29,893,900
32,412,000
30,706,700
40,323,000
32,191,400
31,716,800
21,318,200
27,274,600
26,684,000
28,463,600
30,362,800
28,409,000
27,024,200
AMD
Advanced Micro Devices, Inc.
Important: Remove all lines above data before importing into Tableau.
Date
Open
High
Low
Close
Adj Close
Volume
1/1/2010
9.79
9.90
7.30
7.46
7.46
539,405,700
2/1/2010
7.61
8.20
6.98
7.91
7.91
349,645,100
3/1/2010
7.94
9.74
7.94
9.27
9.27
362,325,900
4/1/2010
9.34
10.24
9.06
9.07
9.07
545,403,600
5/1/2010
9.18
9.78
7.68
8.57
8.57
714,882,100
6/1/2010
8.43
9.19
7.30
7.32
7.32
600,646,700
7/1/2010
7.35
8.25
6.96
7.49
7.49
708,138,000
8/1/2010
7.63
7.77
5.53
5.61
5.61
670,320,000
9/1/2010
5.75
7.44
5.67
7.11
7.11
643,928,600
10/1/2010
7.20
7.68
6.77
7.34
7.34
602,273,500
11/1/2010
7.48
8.24
7.24
7.29
7.29
430,132,400
12/1/2010
7.41
8.43
7.37
8.18
8.18
345,150,800
1/1/2011
8.44
9.25
7.34
7.83
7.83
661,252,800
2/1/2011
8.10
9.58
8.03
9.21
9.21
559,169,900
3/1/2011
9.27
9.39
7.93
8.60
8.60
431,229,300
4/1/2011
8.61
9.14
8.01
9.10
9.10
349,835,500
5/1/2011
9.16
9.17
8.31
8.68
8.68
307,639,900
6/1/2011
8.65
8.68
6.72
6.99
6.99
468,109,800
7/1/2011
6.99
7.87
6.09
7.34
7.34
511,986,100
8/1/2011
7.54
7.58
5.60
6.83
6.83
582,782,600
9/1/2011
6.83
7.44
5.07
5.08
5.08
546,673,900
10/1/2011
5.03
6.05
4.31
5.83
5.83
489,208,600
11/1/2011
5.56
6.00
4.96
5.69
5.69
374,278,500
12/1/2011
5.61
5.84
4.82
5.40
5.40
246,292,700
1/1/2012
5.53
6.95
5.35
6.71
6.71
348,780,400
2/1/2012
6.83
7.68
6.80
7.35
7.35
315,144,700
3/1/2012
7.47
8.35
6.76
8.02
8.02
340,485,500
4/1/2012
8.03
8.24
7.21
7.36
7.36
346,033,400
5/1/2012
7.34
7.72
5.89
6.08
6.08
356,499,800
6/1/2012
5.90
6.14
5.32
5.73
5.73
305,370,800
7/1/2012
5.75
6.08
3.98
4.06
4.06
422,901,800
8/1/2012
4.09
4.47
3.60
3.72
3.72
378,898,100
9/1/2012
3.69
4.02
3.22
3.37
3.37
596,182,800
10/1/2012
3.39
3.41
2.03
2.05
2.05
673,971,900
11/1/2012
2.07
2.35
1.81
2.20
2.20
589,473,800
12/1/2012
2.28
2.59
2.21
2.40
2.40
505,946,700
1/1/2013
2.55
2.93
2.43
2.60
2.60
578,923,500
2/1/2013
2.63
2.84
2.44
2.49
2.49
288,580,100
3/1/2013
2.50
2.75
2.36
2.55
2.55
256,612,600
4/1/2013
2.54
2.82
2.26
2.82
2.82
405,342,300
5/1/2013
2.81
4.42
2.79
4.00
4.00
956,205,200
6/1/2013
4.02
4.21
3.81
4.08
4.08
432,452,200
7/1/2013
4.11
4.65
3.58
3.77
3.77
887,955,000
8/1/2013
3.81
3.87
3.25
3.27
3.27
436,575,700
9/1/2013
3.32
4.00
3.25
3.81
3.81
549,781,400
10/1/2013
3.82
4.13
3.04
3.34
3.34
909,573,300
11/1/2013
3.37
3.68
3.20
3.64
3.64
312,102,400
12/1/2013
3.65
3.88
3.48
3.87
3.87
313,148,800
1/1/2014
3.85
4.60
3.35
3.43
3.43
770,422,000
2/1/2014
3.43
3.77
3.29
3.71
3.71
317,509,100
3/1/2014
4/1/2014
5/1/2014
6/1/2014
7/1/2014
8/1/2014
9/1/2014
10/1/2014
11/1/2014
12/1/2014
1/1/2015
2/1/2015
3/1/2015
4/1/2015
5/1/2015
6/1/2015
7/1/2015
8/1/2015
9/1/2015
10/1/2015
11/1/2015
12/1/2015
1/1/2016
2/1/2016
3/1/2016
4/1/2016
5/1/2016
6/1/2016
7/1/2016
8/1/2016
9/1/2016
10/1/2016
11/1/2016
12/1/2016
1/1/2017
2/1/2017
3/1/2017
4/1/2017
5/1/2017
6/1/2017
7/1/2017
8/1/2017
9/1/2017
10/1/2017
11/1/2017
12/1/2017
1/1/2018
2/1/2018
3/1/2018
4/1/2018
5/1/2018
6/1/2018
7/1/2018
8/1/2018
9/1/2018
3.66
4.04
4.13
4.03
4.21
3.91
4.16
3.39
2.81
2.77
2.67
2.69
3.13
2.66
2.26
2.29
2.47
1.93
1.77
1.77
2.13
2.36
2.77
2.17
2.16
2.79
3.58
4.60
5.09
6.89
7.18
6.95
7.32
8.92
11.42
10.90
15.08
14.60
13.43
11.25
12.57
13.72
13.12
12.80
11.25
10.81
10.42
13.62
12.26
9.99
10.83
13.98
14.80
18.34
25.62
4.14
4.35
4.24
4.50
4.80
4.32
4.25
3.46
2.91
2.82
2.84
3.37
3.23
2.94
2.39
2.67
2.63
2.21
2.14
2.21
2.40
3.06
2.82
2.19
2.98
3.99
4.71
5.52
7.16
8.00
7.64
7.53
9.23
12.42
11.69
15.55
15.09
14.74
13.63
14.67
15.65
13.93
14.24
14.41
12.27
11.19
13.85
13.84
12.82
11.36
13.95
17.34
20.18
27.30
34.14
3.60
3.65
3.85
3.90
3.67
3.87
3.40
2.54
2.59
2.35
2.14
2.65
2.53
2.25
2.20
2.25
1.61
1.65
1.65
1.72
1.94
2.20
1.75
1.81
2.12
2.60
3.45
4.07
4.82
6.15
5.66
6.24
6.22
8.26
9.42
10.81
12.38
12.22
9.85
10.57
12.13
11.86
12.04
10.65
10.66
9.70
10.34
10.63
9.79
9.04
10.77
13.92
14.74
18.00
25.57
4.01
4.09
4.00
4.19
3.91
4.17
3.41
2.80
2.79
2.67
2.57
3.11
2.68
2.26
2.28
2.40
1.93
1.81
1.72
2.12
2.36
2.87
2.20
2.14
2.85
3.55
4.57
5.14
6.86
7.40
6.91
7.23
8.91
11.34
10.37
14.46
14.55
13.30
11.19
12.48
13.61
13.00
12.75
10.99
10.89
10.28
13.74
12.11
10.05
10.88
13.73
14.99
18.33
25.17
30.89
4.01
4.09
4.00
4.19
3.91
4.17
3.41
2.80
2.79
2.67
2.57
3.11
2.68
2.26
2.28
2.40
1.93
1.81
1.72
2.12
2.36
2.87
2.20
2.14
2.85
3.55
4.57
5.14
6.86
7.40
6.91
7.23
8.91
11.34
10.37
14.46
14.55
13.30
11.19
12.48
13.61
13.00
12.75
10.99
10.89
10.28
13.74
12.11
10.05
10.88
13.73
14.99
18.33
25.17
30.89
451,073,000
592,512,300
310,712,200
431,502,500
1,077,778,500
462,568,300
372,572,500
673,408,400
213,816,500
303,879,500
435,408,400
339,665,200
269,815,500
335,187,000
210,397,100
389,269,100
406,747,300
252,729,100
188,468,000
205,349,000
136,451,200
266,450,600
355,489,300
192,749,800
333,321,700
472,576,300
394,438,600
625,642,500
700,562,400
606,398,900
1,041,904,000
869,559,700
990,277,900
1,155,647,500
878,890,400
1,571,999,700
1,733,593,200
943,383,500
1,716,437,000
2,208,152,100
1,710,461,400
1,190,382,100
1,209,201,600
1,358,068,500
1,039,199,400
795,755,000
1,335,288,900
1,103,985,800
1,483,511,900
1,163,360,900
1,020,602,700
1,632,781,900
1,456,419,400
2,201,119,100
3,063,055,900
10/1/2018
11/1/2018
12/1/2018
1/1/2019
2/1/2019
3/1/2019
4/1/2019
5/1/2019
6/1/2019
7/1/2019
8/1/2019
9/1/2019
10/1/2019
11/1/2019
12/1/2019
1/1/2020
2/1/2020
3/1/2020
4/1/2020
5/1/2020
6/1/2020
7/1/2020
8/1/2020
9/1/2020
10/1/2020
11/1/2020
12/1/2020
1/1/2021
2/1/2021
3/1/2021
4/1/2021
5/1/2021
6/1/2021
7/1/2021
8/1/2021
9/1/2021
10/1/2021
11/1/2021
12/1/2021
30.69
18.41
22.48
18.01
24.61
23.97
26.42
28.95
28.75
31.79
30.50
30.83
29.05
34.37
39.32
46.86
46.40
47.42
44.18
51.07
53.31
52.63
78.19
91.92
83.06
75.85
92.25
92.11
86.83
85.37
80.16
81.97
81.01
94.04
105.93
111.30
102.60
119.45
160.37
31.91
22.22
23.75
25.14
25.52
28.11
29.95
29.67
34.30
34.86
35.55
32.05
34.34
41.79
47.31
52.81
59.27
50.20
58.63
56.98
59.00
78.96
92.64
94.28
88.72
92.74
97.98
99.23
94.22
86.95
89.20
82.00
94.34
106.97
122.49
111.85
128.08
164.46
160.88
16.17
17.18
16.03
16.94
22.27
21.04
25.83
26.03
27.29
30.10
27.65
28.35
27.43
34.10
37.15
46.10
41.04
36.75
41.70
49.09
48.42
51.60
76.10
73.85
74.23
73.76
89.03
85.02
79.36
73.86
77.94
72.50
78.96
84.24
101.98
99.51
99.82
118.13
130.60
18.21
21.30
18.46
24.41
23.53
25.52
27.63
27.41
30.37
30.45
31.45
28.99
33.93
39.15
45.86
47.00
45.48
45.48
52.39
53.80
52.61
77.43
90.82
81.99
75.29
92.66
91.71
85.64
84.51
78.50
81.62
80.08
93.93
106.19
110.72
102.90
120.23
158.37
143.90
18.21
21.30
18.46
24.41
23.53
25.52
27.63
27.41
30.37
30.45
31.45
28.99
33.93
39.15
45.86
47.00
45.48
45.48
52.39
53.80
52.61
77.43
90.82
81.99
75.29
92.66
91.71
85.64
84.51
78.50
81.62
80.08
93.93
106.19
110.72
102.90
120.23
158.37
143.90
2,655,213,100
2,140,346,900
1,981,674,300
2,311,913,200
1,301,360,800
1,499,160,400
1,275,793,800
1,675,142,900
1,578,411,200
1,155,469,400
1,645,871,800
1,012,749,700
1,067,281,800
1,202,279,900
982,440,800
1,227,882,000
1,283,146,900
2,095,887,300
1,714,615,700
1,192,698,100
1,174,606,200
1,563,684,800
1,220,335,300
1,168,263,000
1,181,118,000
907,041,400
848,701,400
997,848,700
734,954,400
1,008,228,800
986,273,800
892,921,300
812,057,600
1,138,122,300
1,998,033,700
867,013,100
930,142,400
1,373,528,900
1,175,315,000
TSLA
Tesla, Inc.
Important: Remove all lines above data before importing into Tableau.
Date
Open
High
Low
Close
Adj Close
Volume
7/1/2010
5.00
5.18
3.00
3.99
3.99
322,879,000
8/1/2010
4.10
4.44
3.48
3.90
3.90
75,191,000
9/1/2010
3.92
4.63
3.90
4.08
4.08
90,229,500
10/1/2010
4.14
4.37
4.00
4.37
4.37
32,739,000
11/1/2010
4.39
7.20
4.21
7.07
7.07
141,575,500
12/1/2010
7.17
7.28
5.00
5.33
5.33
184,464,500
1/1/2011
5.37
5.74
4.47
4.82
4.82
142,100,500
2/1/2011
4.86
5.10
4.22
4.78
4.78
146,517,500
3/1/2011
4.81
5.74
4.35
5.55
5.55
162,816,500
4/1/2011
5.49
5.64
4.84
5.52
5.52
149,474,500
5/1/2011
5.52
6.06
5.10
6.03
6.03
151,744,000
6/1/2011
6.00
6.30
5.10
5.83
5.83
198,636,500
7/1/2011
5.81
6.09
5.33
5.63
5.63
105,510,500
8/1/2011
5.73
5.84
4.30
4.95
4.95
136,078,500
9/1/2011
4.93
5.40
4.46
4.88
4.88
90,107,500
10/1/2011
4.99
6.00
4.59
5.87
5.87
108,313,000
11/1/2011
5.68
7.00
5.60
6.55
6.55
129,234,000
12/1/2011
6.51
7.00
5.21
5.71
5.71
105,642,500
1/1/2012
5.79
6.00
4.53
5.81
5.81
128,049,500
2/1/2012
5.81
6.99
5.80
6.68
6.68
115,968,000
3/1/2012
6.70
7.99
6.52
7.45
7.45
110,817,500
4/1/2012
7.47
7.69
6.20
6.63
6.63
113,764,500
5/1/2012
6.63
6.94
5.37
5.90
5.90
170,926,500
6/1/2012
5.71
6.90
5.42
6.26
6.26
130,635,500
7/1/2012
6.27
7.20
5.44
5.48
5.48
162,717,000
8/1/2012
5.60
6.26
5.10
5.70
5.70
122,410,500
9/1/2012
5.70
6.56
5.46
5.86
5.86
166,475,500
10/1/2012
5.90
6.02
5.37
5.63
5.63
88,104,500
11/1/2012
5.65
6.86
5.64
6.76
6.76
118,804,500
12/1/2012
6.78
7.16
6.55
6.77
6.77
108,571,500
1/1/2013
7.00
7.74
6.42
7.50
7.50
142,323,000
2/1/2013
7.63
8.00
6.76
6.97
6.97
221,280,000
3/1/2013
7.00
7.90
6.85
7.58
7.58
148,275,000
4/1/2013
8.47
11.64
8.04
10.80
10.80
407,740,500
5/1/2013
11.20
22.98
10.60
19.55
19.55
1,656,104,500
6/1/2013
19.52
22.05
17.65
21.47
21.47
895,573,500
7/1/2013
21.87
27.50
20.90
26.86
26.86
1,147,641,000
8/1/2013
27.00
34.60
26.47
33.80
33.80
1,296,333,000
9/1/2013
34.68
38.90
31.70
38.67
38.67
856,053,000
10/1/2013
38.79
38.85
30.60
31.99
31.99
1,292,274,000
11/1/2013
32.60
36.29
23.22
25.46
25.46
1,541,942,500
12/1/2013
25.27
31.60
24.79
30.09
30.09
988,189,500
1/1/2014
29.96
37.20
27.33
36.28
36.28
919,661,500
2/1/2014
36.58
53.00
33.87
48.96
48.96
1,129,770,500
3/1/2014
47.45
52.00
40.60
41.69
41.69
833,428,000
4/1/2014
41.80
47.15
36.86
41.58
41.58
826,039,000
5/1/2014
41.42
43.73
35.44
41.55
41.55
674,050,500
6/1/2014
41.47
48.90
39.85
48.01
48.01
616,813,500
7/1/2014
48.49
48.69
42.72
44.66
44.66
539,763,500
8/1/2014
45.22
54.40
45.20
53.94
53.94
574,236,000
9/1/2014
10/1/2014
11/1/2014
12/1/2014
1/1/2015
2/1/2015
3/1/2015
4/1/2015
5/1/2015
6/1/2015
7/1/2015
8/1/2015
9/1/2015
10/1/2015
11/1/2015
12/1/2015
1/1/2016
2/1/2016
3/1/2016
4/1/2016
5/1/2016
6/1/2016
7/1/2016
8/1/2016
9/1/2016
10/1/2016
11/1/2016
12/1/2016
1/1/2017
2/1/2017
3/1/2017
4/1/2017
5/1/2017
6/1/2017
7/1/2017
8/1/2017
9/1/2017
10/1/2017
11/1/2017
12/1/2017
1/1/2018
2/1/2018
3/1/2018
4/1/2018
5/1/2018
6/1/2018
7/1/2018
8/1/2018
9/1/2018
10/1/2018
11/1/2018
12/1/2018
1/1/2019
2/1/2019
3/1/2019
55.10
48.44
48.60
48.23
44.57
40.79
40.54
37.74
45.99
50.28
54.22
53.26
48.07
49.50
41.78
46.21
46.14
37.75
38.85
48.97
48.30
44.30
41.23
47.10
41.80
42.46
39.61
37.65
42.97
50.61
50.84
57.38
62.98
68.80
74.05
64.60
71.22
68.50
66.45
61.09
62.40
70.20
69.00
51.25
58.70
57.17
72.01
59.60
59.39
61.15
67.65
72.00
61.22
61.08
61.39
58.28
53.11
52.00
48.49
44.65
45.10
41.24
47.75
50.57
54.28
57.33
54.20
54.31
49.97
46.92
48.73
46.28
39.90
47.98
53.87
48.64
48.17
47.06
47.33
42.22
43.13
39.87
44.76
51.69
57.48
56.40
62.96
68.58
77.40
74.27
74.00
77.92
72.60
66.52
69.49
72.10
72.00
69.73
61.90
62.60
74.75
72.96
77.49
62.99
69.43
73.35
75.90
70.40
64.85
61.43
48.02
43.46
45.70
38.53
37.00
38.66
36.28
37.21
44.05
49.14
50.16
39.00
47.39
40.40
41.16
42.97
36.48
28.21
36.30
46.65
40.73
37.57
41.20
41.73
38.69
38.40
35.64
36.00
42.19
48.40
48.56
56.92
58.15
66.84
60.63
62.24
67.08
63.33
58.53
60.00
61.14
58.95
49.64
48.92
54.68
56.77
57.23
57.64
50.45
49.55
65.00
58.82
55.86
57.75
50.89
48.54
48.34
48.90
44.48
40.72
40.67
37.75
45.21
50.16
53.65
53.23
49.81
49.68
41.39
46.05
48.00
38.24
38.39
45.95
48.15
44.65
42.46
46.96
42.40
40.81
39.55
37.88
42.74
50.39
50.00
55.66
62.81
68.20
72.32
64.69
71.18
68.22
66.31
61.77
62.27
70.86
68.61
53.23
58.78
56.95
68.59
59.63
60.33
52.95
67.46
70.10
66.56
61.40
63.98
55.97
48.54
48.34
48.90
44.48
40.72
40.67
37.75
45.21
50.16
53.65
53.23
49.81
49.68
41.39
46.05
48.00
38.24
38.39
45.95
48.15
44.65
42.46
46.96
42.40
40.81
39.55
37.88
42.74
50.39
50.00
55.66
62.81
68.20
72.32
64.69
71.18
68.22
66.31
61.77
62.27
70.86
68.61
53.23
58.78
56.95
68.59
59.63
60.33
52.95
67.46
70.10
66.56
61.40
63.98
55.97
664,241,500
760,262,500
538,609,000
634,731,000
451,025,500
533,587,500
614,950,500
494,725,500
445,639,000
327,365,500
400,305,000
576,320,500
401,440,500
504,060,000
392,442,000
299,227,500
396,236,000
668,529,000
514,610,000
677,536,500
516,537,500
608,364,000
370,319,500
311,455,500
353,159,500
460,664,000
494,430,000
439,967,000
503,398,000
597,700,000
535,176,500
584,753,000
740,231,500
929,755,500
908,200,000
684,708,000
557,563,500
615,183,500
744,064,000
549,423,500
621,357,500
545,950,000
786,342,500
951,554,000
777,890,500
1,067,125,500
861,641,000
1,386,801,000
980,377,000
1,431,803,500
665,095,500
732,256,000
878,260,500
642,750,500
1,068,967,500
4/1/2019
56.52
5/1/2019
47.77
6/1/2019
37.10
7/1/2019
46.04
8/1/2019
48.53
9/1/2019
44.82
10/1/2019
48.30
11/1/2019
63.26
12/1/2019
65.88
1/1/2020
84.90
2/1/2020
134.74
3/1/2020
142.25
4/1/2020
100.80
5/1/2020
151.00
6/1/2020
171.60
7/1/2020
216.60
8/1/2020
289.84
9/1/2020
502.14
10/1/2020
440.76
11/1/2020
394.00
12/1/2020
597.59
1/1/2021
719.46
2/1/2021
814.29
3/1/2021
690.11
4/1/2021
688.37
5/1/2021
703.80
6/1/2021
627.80
7/1/2021
683.92
8/1/2021
700.00
9/1/2021
734.08
10/1/2021
778.40
11/1/2021 1,145.00
12/1/2021 1,160.70
59.23
51.67
46.95
53.21
48.90
50.70
68.17
72.24
87.06
130.60
193.80
161.40
173.96
168.66
217.54
359.00
500.14
502.49
465.90
607.80
718.72
900.40
880.50
721.11
780.79
706.00
697.62
700.00
740.39
799.00
1,115.21
1,243.49
1,172.84
46.23
36.82
35.40
44.44
42.20
43.67
44.86
61.85
65.45
84.34
122.30
70.10
89.28
136.61
170.82
216.10
273.00
329.88
379.11
392.30
541.21
717.19
619.00
539.49
659.42
546.98
571.22
620.46
648.84
708.85
763.59
978.60
886.12
47.74
37.03
44.69
48.32
45.12
48.17
62.98
65.99
83.67
130.11
133.60
104.80
156.38
167.00
215.96
286.15
498.32
429.01
388.04
567.60
705.67
793.53
675.50
667.93
709.44
625.22
679.70
687.20
735.72
775.48
1,114.00
1,144.76
1,056.78
47.74
37.03
44.69
48.32
45.12
48.17
62.98
65.99
83.67
130.11
133.60
104.80
156.38
167.00
215.96
286.15
498.32
429.01
388.04
567.60
705.67
793.53
675.50
667.93
709.44
625.22
679.70
687.20
735.72
775.48
1,114.00
1,144.76
1,056.78
1,153,736,500
1,412,994,000
1,074,853,000
996,683,500
668,953,000
678,876,500
1,139,913,000
788,854,000
1,035,400,000
2,036,092,500
2,362,934,000
2,104,675,000
1,907,387,500
1,363,518,000
1,278,863,500
1,893,167,500
1,557,378,400
1,736,284,800
833,666,400
782,598,800
1,196,346,000
705,694,800
522,857,900
942,452,400
678,539,700
625,175,800
519,921,900
448,393,900
381,113,700
390,101,400
528,800,500
648,671,800
509,833,400
JPM
JPMorgan Chase & Co.
Important: Remove all lines above data before importing into Tableau.
Date
Open
High
Low
Close
Adj Close
Volume
1/1/2010
41.79
45.19
38.07
38.94
28.78
1,029,066,400
2/1/2010
39.10
42.31
37.03
41.97
31.0…