Tobin's Q historical data (1900-1951)

year,quarter,tobins_q
1900,Q1,0.7321465166478567
1900,Q2,0.6807121318364949
1900,Q3,0.669200233628518
1900,Q4,0.7873480970439499
1901,Q1,0.8896852131016609
1901,Q2,1.0003132216109263
1901,Q3,0.9352908434880708
1901,Q4,0.9233835909663018
1902,Q1,1.0528208625205142
1902,Q2,1.0601465331657822
1902,Q3,1.0956859698370338
1902,Q4,0.9791522092805542
1903,Q1,0.9766658979462637
1903,Q2,0.8547659113862306
1903,Q3,0.7587771994505561
1903,Q4,0.759204595724236
1904,Q1,0.8035667175022441
1904,Q2,0.8029609827494518
1904,Q3,0.8980562205105745
1904,Q4,1.0067872835593252
1905,Q1,1.0920592034822505
1905,Q2,1.0213881991573406
1905,Q3,1.0791875884757511
1905,Q4,1.098376460362535
1906,Q1,1.0441236946250219
1906,Q2,0.9923828571807262
1906,Q3,1.0462342687701391
1906,Q4,1.0038621269666514
1907,Q1,0.8409739409274077
1907,Q2,0.7765578421508208
1907,Q3,0.72592937171184
1907,Q4,0.6299392237682564
1908,Q1,0.6793547627765146
1908,Q2,0.7561799859251768
1908,Q3,0.8093682486477697
1908,Q4,0.8953740392030568
1909,Q1,0.8600495440233255
1909,Q2,0.9389452954274253
1909,Q3,0.9701999126622993
1909,Q4,0.9745724338756777
1910,Q1,0.9773617109396511
1910,Q2,0.8818296859483918
1910,Q3,0.8527779799877865
1910,Q4,0.8556334591252955
1911,Q1,0.8776901422428649
1911,Q2,0.9083612946824342
1911,Q3,0.8123830004893873
1911,Q4,0.8514760178853704
1912,Q1,0.8865853116040069
1912,Q2,0.9044856954294072
1912,Q3,0.9220446970737324
1912,Q4,0.8688729060810046
1913,Q1,0.887394360700872
1913,Q2,0.8050429188805693
1913,Q3,0.8316949544264924
1913,Q4,0.7711557369433192
1914,Q1,0.7487052449093546
1914,Q2,0.7286353536602775
1914,Q3,0.6855201515888847
1914,Q4,0.6534205156545965
1915,Q1,0.6954675007853333
1915,Q2,0.7166052318777569
1915,Q3,0.7495000830968647
1915,Q4,0.797364312483153
1916,Q1,0.7176409163653011
1916,Q2,0.6853273879571102
1916,Q3,0.6658671747355266
1916,Q4,0.6356552666028508
1917,Q1,0.5592678619404485
1917,Q2,0.5034080985559869
1917,Q3,0.4214146931322314
1917,Q4,0.3304296853399714
1918,Q1,0.346597320985109
1918,Q2,0.3378918537377643
1918,Q3,0.3265094322799977
1918,Q4,0.3272980535458692
1919,Q1,0.3360633837849028
1919,Q2,0.3665795464194339
1919,Q3,0.34539342926220257
1919,Q4,0.3297812021503357
1920,Q1,0.3465537517608424
1920,Q2,0.3141123510760593
1920,Q3,0.30971994343192544
1920,Q4,0.26595125022392396
1921,Q1,0.2806922972065499
1921,Q2,0.2788761350726941
1921,Q3,0.29425599050598605
1921,Q4,0.3409556592396656
1922,Q1,0.3402371925150397
1922,Q2,0.37379411754330394
1922,Q3,0.403325992857141
1922,Q4,0.3933619455997827
1923,Q1,0.46179199575580115
1923,Q2,0.399316173252721
1923,Q3,0.3817158251046052
1923,Q4,0.3919102736016085
1924,Q1,0.3877271643597494
1924,Q2,0.3839077685877733
1924,Q3,0.41074132840954974
1924,Q4,0.4503315524947341
1925,Q1,0.4719616029128302
1925,Q2,0.4870102436409506
1925,Q3,0.5152713005732156
1925,Q4,0.5537933017052251
1926,Q1,0.5093337605282451
1926,Q2,0.5201064804934774
1926,Q3,0.5697120020959388
1926,Q4,0.5746104506546702
1927,Q1,0.579913198692134
1927,Q2,0.6217057237597289
1927,Q3,0.706330610000145
1927,Q4,0.7270162698218633
1928,Q1,0.7585486895346678
1928,Q2,0.7888556258874143
1928,Q3,0.8761456237494397
1928,Q4,0.9560417338940763
1929,Q1,1.601709360198153
1929,Q2,1.6391781337075717
1929,Q3,1.952656465734725
1929,Q4,1.3287160303332608
1930,Q1,1.0161825985585669
1930,Q2,0.9389844730723483
1930,Q3,0.9327589595797268
1930,Q4,0.7168073031214486
1931,Q1,0.8463517029399913
1931,Q2,0.6880108873517259
1931,Q3,0.6033651798275624
1931,Q4,0.4429554456207429
1932,Q1,0.47832897301080085
1932,Q2,0.2824537053063705
1932,Q3,0.5003938826744427
1932,Q4,0.4229124412973108
1933,Q1,0.362841984913321
1933,Q2,0.6114076901240134
1933,Q3,0.6291202983051217
1933,Q4,0.5991335994526323
1934,Q1,0.6502594075952479
1934,Q2,0.6022418694320362
1934,Q3,0.5383936583466549
1934,Q4,0.5618243735951991
1935,Q1,0.5009229469495307
1935,Q2,0.6005340257765905
1935,Q3,0.6864003659639004
1935,Q4,0.7680986784922108
1936,Q1,0.8868496887496051
1936,Q2,0.8600108883625222
1936,Q3,0.9220736662110324
1936,Q4,0.9621209893115609
1937,Q1,0.9745060633107107
1937,Q2,0.8227718097622196
1937,Q3,0.7386435049511875
1937,Q4,0.5537619835705334
1938,Q1,0.5230941139890507
1938,Q2,0.518561075815221
1938,Q3,0.597400410725231
1938,Q4,0.6458671915103623
1939,Q1,0.6326867394686846
1939,Q2,0.5804240580340704
1939,Q3,0.6448893606492239
1939,Q4,0.6212585771307739
1940,Q1,0.5945159057324706
1940,Q2,0.4625517661937906
1940,Q3,0.4973159707725163
1940,Q4,0.4820608907534667
1941,Q1,0.4487357653603608
1941,Q2,0.42106330354652244
1941,Q3,0.4233955884170442
1941,Q4,0.34773734896894737
1942,Q1,0.3397072742458348
1942,Q2,0.33718517074380455
1942,Q3,0.342683458534735
1942,Q4,0.3667961684672977
1943,Q1,0.42419965619645383
1943,Q2,0.45937599199796103
1943,Q3,0.451023915764156
1943,Q4,0.4279137992560834
1944,Q1,0.4478178343044431
1944,Q2,0.46342179268815176
1944,Q3,0.45552663525241377
1944,Q4,0.4681835146322709
1945,Q1,0.46839172897407455
1945,Q2,0.4935659905134392
1945,Q3,0.5043497832788522
1945,Q4,0.5375288498048092
1946,Q1,0.4766907103581323
1946,Q2,0.5157069283641303
1946,Q3,0.42589471938436857
1946,Q4,0.4343411604919366
1947,Q1,0.32752701293837544
1947,Q2,0.3336316996706554
1947,Q3,0.34994505255734837
1947,Q4,0.36138086883254267
1948,Q1,0.2919314717159176
1948,Q2,0.35178542337856644
1948,Q3,0.33620222613421336
1948,Q4,0.33064968173247106
1949,Q1,0.3077996353873247
1949,Q2,0.2913896761101131
1949,Q3,0.32580121098733833
1949,Q4,0.3508252075628252
1950,Q1,0.32318802644141487
1950,Q2,0.35681563256818255
1950,Q3,0.3698457029846239
1950,Q4,0.38986899699500555
1951,Q1,0.35438040337205073
1951,Q2,0.3634317333677796
1951,Q3,0.405501019546944