In [1]:
import pandas as pd
import numpy as np
In [2]:
CompustatData = pd.read_csv('./data/compustat_data.csv')
#CompustatData=pd.notnull(CompustatData)
CompustatData.head()
Out[2]:
| gvkey | datadate | fyear | indfmt | consol | popsrc | datafmt | tic | cusip | conm | ... | csho | pi | sale | exchg | cik | costat | fic | prcc_f | naics | sic | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1004 | 19940531 | 1993.0 | INDL | C | D | STD | AIR | 000361105 | AAR CORP | ... | 15.906 | 13.684 | 407.754 | 11.0 | 1750.0 | A | USA | 14.3750 | 423860.0 | 5080 |
| 1 | 1004 | 19950531 | 1994.0 | INDL | C | D | STD | AIR | 000361105 | AAR CORP | ... | 15.961 | 14.713 | 451.395 | 11.0 | 1750.0 | A | USA | 15.2500 | 423860.0 | 5080 |
| 2 | 1004 | 19960531 | 1995.0 | INDL | C | D | STD | AIR | 000361105 | AAR CORP | ... | 15.998 | 22.782 | 504.990 | 11.0 | 1750.0 | A | USA | 22.1250 | 423860.0 | 5080 |
| 3 | 1004 | 19970531 | 1996.0 | INDL | C | D | STD | AIR | 000361105 | AAR CORP | ... | 18.204 | 32.975 | 589.328 | 11.0 | 1750.0 | A | USA | 31.0000 | 423860.0 | 5080 |
| 4 | 1004 | 19980531 | 1997.0 | INDL | C | D | STD | AIR | 000361105 | AAR CORP | ... | 27.704 | 51.157 | 782.123 | 11.0 | 1750.0 | A | USA | 26.4375 | 423860.0 | 5080 |
5 rows × 22 columns
In [3]:
CompustatData=CompustatData[(CompustatData.fyear>1993) & (CompustatData.fyear<2019)]
CompustatData=CompustatData[~np.isnan(CompustatData.fyear)]
CompustatData.fyear=CompustatData.fyear.astype(int)
CompustatData = CompustatData.drop_duplicates(subset = ['gvkey', 'fyear']) #this is not ok.
#CompustatData = CompustatData.sort_values(['gvkey', 'fyear'])
#CompustatData = CompustatData.set_index(['gvkey', 'fyear'], verify_integrity = True, drop = False)
CompustatData = CompustatData[CompustatData['fic'] == 'USA']
In [4]:
CompustatData['mkvalt'] = CompustatData['csho'] * CompustatData['prcc_f']
In [5]:
naics_labels=['Agriculture, Forestry, Fishing and Hunting',\
'Mining, Quarrying, and Oil and Gas Extraction',\
'Utilities',\
'Construction',\
'NA1',\
'Manufacturing',\
'NA2',\
'Wholesale Trade',\
'Retail Trade',\
'NA3',\
'Transportation and Warehousing',\
'NA4',\
'Information',\
'Finance and Insurance',\
'Real Estate and Rental and Leasing',\
'Professional, Scientific, and Technical Services',\
'Management of Companies and Enterprises',\
'Administrative and Support and Waste Management and Remediation Services',\
'Educational Services',\
'Health Care and Social Assistance',\
'Arts, Entertainment, and Recreation',\
'Accommodation and Food Service',\
'Other Services','Public administration']
naics_code=[11,21,22,23,24,31,35,42,44,46,48,50,51,52,53,54,55,56,61,62,71,72,81,83,92]
n=24
#naics_labels=['Ag. Mining and Utilities',\
# 'Consts and Mfg',\
# 'Trade and warehousing',\
# 'Information and FIRE',\
# 'RE',\
# 'Professional services',\
# 'Nonprof services']
#naics_code=[11,23,42,51,53,54,57,92]
CompustatData['naics_label']=pd.cut(CompustatData['naics']/10**4,naics_code[:n+1],labels=naics_labels[:n],include_lowest=True,right=False)
CompustatData['naics_code_cat']=pd.cut(CompustatData['naics']/10**4,naics_code[:n+1],include_lowest=True,right=False)
CompustatData['naics_2d']=pd.cut(CompustatData['naics']/10**4,naics_code[:n+1],labels=naics_code[:n],include_lowest=True,right=False)
In [6]:
temp=pd.pivot_table(CompustatData, values=['mkvalt','sale'], columns=['fyear'], aggfunc=np.sum).T
temp['ratio']=temp.mkvalt/temp.sale
temp.ratio.plot()
Out[6]:
<matplotlib.axes._subplots.AxesSubplot at 0x20fbff214a8>
In [7]:
naics_year_count = pd.pivot_table(CompustatData, values='sale', index=['naics_label'], columns=['fyear'], aggfunc=len)
naics_year_sales = pd.pivot_table(CompustatData, values='sale', index=['naics_label'], columns=['fyear'], aggfunc=np.sum)
naics_year_mktval =pd.pivot_table(CompustatData, values='mkvalt', index=['naics_label'], columns=['fyear'], aggfunc=np.sum)
naics_year_ps_multiple=naics_year_mktval/naics_year_sales
naics_year_sales=naics_year_sales/naics_year_sales.sum()*100
naics_year_mktval = naics_year_mktval/naics_year_mktval.sum()*100
In [8]:
display(naics_year_count.T.describe().T)
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| naics_label | ||||||||
| Agriculture, Forestry, Fishing and Hunting | 25.0 | 21.72 | 6.496922 | 9.0 | 18.0 | 20.0 | 26.0 | 34.0 |
| Mining, Quarrying, and Oil and Gas Extraction | 25.0 | 265.44 | 40.846338 | 144.0 | 261.0 | 269.0 | 296.0 | 316.0 |
| Utilities | 25.0 | 97.60 | 21.215168 | 62.0 | 84.0 | 91.0 | 104.0 | 140.0 |
| Construction | 25.0 | 93.52 | 24.539288 | 56.0 | 78.0 | 83.0 | 114.0 | 135.0 |
| Manufacturing | 25.0 | 2598.60 | 573.369500 | 1667.0 | 2172.0 | 2490.0 | 3107.0 | 3523.0 |
| Wholesale Trade | 25.0 | 216.36 | 80.290556 | 112.0 | 165.0 | 177.0 | 267.0 | 362.0 |
| Retail Trade | 25.0 | 292.72 | 103.706525 | 148.0 | 220.0 | 260.0 | 374.0 | 473.0 |
| Transportation and Warehousing | 25.0 | 152.32 | 28.257329 | 94.0 | 133.0 | 157.0 | 172.0 | 199.0 |
| Information | 25.0 | 841.52 | 266.208740 | 438.0 | 654.0 | 743.0 | 1087.0 | 1315.0 |
| Finance and Insurance | 25.0 | 2218.60 | 275.865154 | 1923.0 | 2034.0 | 2099.0 | 2335.0 | 2857.0 |
| Real Estate and Rental and Leasing | 25.0 | 313.92 | 22.364257 | 283.0 | 294.0 | 311.0 | 329.0 | 351.0 |
| Professional, Scientific, and Technical Services | 25.0 | 303.32 | 130.510447 | 115.0 | 194.0 | 287.0 | 410.0 | 511.0 |
| Administrative and Support and Waste Management and Remediation Services | 25.0 | 159.48 | 57.534859 | 78.0 | 111.0 | 145.0 | 215.0 | 250.0 |
| Educational Services | 25.0 | 27.80 | 5.139715 | 14.0 | 26.0 | 28.0 | 30.0 | 39.0 |
| Health Care and Social Assistance | 25.0 | 141.72 | 49.741431 | 63.0 | 105.0 | 131.0 | 173.0 | 241.0 |
| Arts, Entertainment, and Recreation | 25.0 | 56.52 | 16.490199 | 28.0 | 44.0 | 52.0 | 75.0 | 80.0 |
| Accommodation and Food Service | 25.0 | 145.04 | 56.259429 | 75.0 | 103.0 | 111.0 | 204.0 | 243.0 |
| Other Services | 25.0 | 25.52 | 15.119303 | 8.0 | 15.0 | 20.0 | 39.0 | 52.0 |
In [9]:
display(naics_year_count)
| fyear | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | ... | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| naics_label | |||||||||||||||||||||
| Agriculture, Forestry, Fishing and Hunting | 29.0 | 32.0 | 34.0 | 32.0 | 30.0 | 27.0 | 25.0 | 26.0 | 26.0 | 21.0 | ... | 21.0 | 21.0 | 20.0 | 20.0 | 19.0 | 16.0 | 16.0 | 13.0 | 13.0 | 9.0 |
| Mining, Quarrying, and Oil and Gas Extraction | 300.0 | 303.0 | 302.0 | 277.0 | 261.0 | 265.0 | 272.0 | 261.0 | 254.0 | 256.0 | ... | 293.0 | 310.0 | 309.0 | 316.0 | 296.0 | 268.0 | 226.0 | 202.0 | 181.0 | 144.0 |
| Utilities | 140.0 | 136.0 | 135.0 | 131.0 | 124.0 | 117.0 | 104.0 | 102.0 | 102.0 | 100.0 | ... | 85.0 | 85.0 | 83.0 | 83.0 | 82.0 | 85.0 | 84.0 | 81.0 | 74.0 | 62.0 |
| Construction | 132.0 | 135.0 | 134.0 | 133.0 | 134.0 | 122.0 | 114.0 | 104.0 | 93.0 | 84.0 | ... | 75.0 | 78.0 | 79.0 | 80.0 | 82.0 | 80.0 | 75.0 | 72.0 | 65.0 | 56.0 |
| Manufacturing | 3316.0 | 3502.0 | 3523.0 | 3456.0 | 3392.0 | 3276.0 | 3107.0 | 2950.0 | 2830.0 | 2740.0 | ... | 2221.0 | 2164.0 | 2172.0 | 2189.0 | 2203.0 | 2110.0 | 2011.0 | 1963.0 | 1865.0 | 1667.0 |
| Wholesale Trade | 357.0 | 362.0 | 361.0 | 337.0 | 323.0 | 306.0 | 267.0 | 244.0 | 230.0 | 221.0 | ... | 172.0 | 166.0 | 173.0 | 167.0 | 160.0 | 153.0 | 140.0 | 135.0 | 123.0 | 112.0 |
| Retail Trade | 453.0 | 468.0 | 473.0 | 448.0 | 431.0 | 409.0 | 374.0 | 344.0 | 327.0 | 303.0 | ... | 229.0 | 230.0 | 221.0 | 217.0 | 220.0 | 200.0 | 189.0 | 178.0 | 163.0 | 148.0 |
| Transportation and Warehousing | 193.0 | 199.0 | 196.0 | 183.0 | 180.0 | 174.0 | 172.0 | 168.0 | 165.0 | 166.0 | ... | 139.0 | 133.0 | 133.0 | 135.0 | 133.0 | 130.0 | 125.0 | 115.0 | 108.0 | 94.0 |
| Information | 954.0 | 1098.0 | 1166.0 | 1227.0 | 1315.0 | 1305.0 | 1212.0 | 1087.0 | 988.0 | 908.0 | ... | 670.0 | 659.0 | 672.0 | 673.0 | 654.0 | 623.0 | 595.0 | 538.0 | 497.0 | 438.0 |
| Finance and Insurance | 2223.0 | 2173.0 | 2108.0 | 2006.0 | 2012.0 | 2067.0 | 2034.0 | 2036.0 | 2037.0 | 2091.0 | ... | 1979.0 | 2099.0 | 2282.0 | 2335.0 | 2401.0 | 2481.0 | 2646.0 | 2723.0 | 2787.0 | 2857.0 |
| Real Estate and Rental and Leasing | 304.0 | 319.0 | 335.0 | 329.0 | 328.0 | 317.0 | 308.0 | 295.0 | 294.0 | 291.0 | ... | 311.0 | 322.0 | 332.0 | 348.0 | 351.0 | 351.0 | 345.0 | 329.0 | 309.0 | 286.0 |
| Professional, Scientific, and Technical Services | 397.0 | 449.0 | 486.0 | 496.0 | 511.0 | 502.0 | 464.0 | 410.0 | 370.0 | 332.0 | ... | 242.0 | 215.0 | 194.0 | 195.0 | 181.0 | 172.0 | 159.0 | 144.0 | 131.0 | 115.0 |
| Administrative and Support and Waste Management and Remediation Services | 215.0 | 244.0 | 250.0 | 244.0 | 242.0 | 233.0 | 223.0 | 207.0 | 195.0 | 178.0 | ... | 118.0 | 111.0 | 111.0 | 108.0 | 113.0 | 111.0 | 103.0 | 98.0 | 92.0 | 78.0 |
| Educational Services | 28.0 | 30.0 | 31.0 | 33.0 | 34.0 | 39.0 | 34.0 | 32.0 | 30.0 | 29.0 | ... | 25.0 | 26.0 | 25.0 | 27.0 | 27.0 | 27.0 | 23.0 | 21.0 | 19.0 | 14.0 |
| Health Care and Social Assistance | 234.0 | 241.0 | 229.0 | 206.0 | 184.0 | 177.0 | 173.0 | 163.0 | 156.0 | 151.0 | ... | 124.0 | 118.0 | 112.0 | 105.0 | 102.0 | 95.0 | 89.0 | 83.0 | 75.0 | 63.0 |
| Arts, Entertainment, and Recreation | 80.0 | 80.0 | 80.0 | 80.0 | 76.0 | 75.0 | 76.0 | 73.0 | 64.0 | 60.0 | ... | 48.0 | 45.0 | 42.0 | 44.0 | 44.0 | 47.0 | 41.0 | 37.0 | 35.0 | 28.0 |
| Accommodation and Food Service | 225.0 | 239.0 | 243.0 | 232.0 | 218.0 | 208.0 | 204.0 | 182.0 | 167.0 | 154.0 | ... | 110.0 | 104.0 | 103.0 | 109.0 | 107.0 | 103.0 | 97.0 | 88.0 | 82.0 | 75.0 |
| Other Services | 44.0 | 52.0 | 51.0 | 50.0 | 43.0 | 42.0 | 38.0 | 39.0 | 33.0 | 28.0 | ... | 16.0 | 16.0 | 17.0 | 15.0 | 11.0 | 9.0 | 9.0 | 9.0 | 8.0 | 8.0 |
18 rows × 25 columns
In [10]:
display(naics_year_sales.T.describe().T)
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| naics_label | ||||||||
| Agriculture, Forestry, Fishing and Hunting | 25.0 | 0.110663 | 0.054757 | 0.003941 | 0.089876 | 0.124775 | 0.132679 | 0.219035 |
| Mining, Quarrying, and Oil and Gas Extraction | 25.0 | 1.367518 | 0.222877 | 0.968731 | 1.242030 | 1.327471 | 1.568725 | 1.778584 |
| Utilities | 25.0 | 1.397928 | 0.264371 | 0.990858 | 1.178511 | 1.417970 | 1.520198 | 2.042566 |
| Construction | 25.0 | 1.071543 | 0.251505 | 0.779970 | 0.878442 | 1.023130 | 1.219199 | 1.690136 |
| Manufacturing | 25.0 | 34.378515 | 2.373158 | 31.140478 | 32.572988 | 34.008520 | 36.149604 | 38.826737 |
| Wholesale Trade | 25.0 | 6.230241 | 0.967110 | 4.459984 | 5.503932 | 5.983889 | 7.026122 | 7.740305 |
| Retail Trade | 25.0 | 15.025363 | 1.461805 | 12.699186 | 14.099588 | 15.412831 | 15.922906 | 17.663545 |
| Transportation and Warehousing | 25.0 | 5.562484 | 0.316258 | 5.172716 | 5.362275 | 5.473240 | 5.694343 | 6.339252 |
| Information | 25.0 | 10.534982 | 0.791572 | 8.459532 | 10.110015 | 10.737194 | 11.180986 | 11.453092 |
| Finance and Insurance | 25.0 | 16.917391 | 2.299353 | 13.669614 | 14.795542 | 16.006926 | 18.908574 | 20.927939 |
| Real Estate and Rental and Leasing | 25.0 | 1.234424 | 0.303056 | 0.677233 | 1.021753 | 1.234066 | 1.321940 | 1.778235 |
| Professional, Scientific, and Technical Services | 25.0 | 1.621161 | 0.232228 | 1.217255 | 1.455760 | 1.617583 | 1.767937 | 2.127366 |
| Administrative and Support and Waste Management and Remediation Services | 25.0 | 1.177531 | 0.102683 | 1.026411 | 1.113860 | 1.154478 | 1.215158 | 1.435805 |
| Educational Services | 25.0 | 0.124273 | 0.038536 | 0.072800 | 0.085466 | 0.125240 | 0.151864 | 0.200730 |
| Health Care and Social Assistance | 25.0 | 1.423730 | 0.218958 | 1.123715 | 1.291023 | 1.371128 | 1.542853 | 1.949809 |
| Arts, Entertainment, and Recreation | 25.0 | 0.185782 | 0.035442 | 0.124479 | 0.160804 | 0.192556 | 0.216257 | 0.240670 |
| Accommodation and Food Service | 25.0 | 1.515737 | 0.080601 | 1.376486 | 1.473957 | 1.520122 | 1.591889 | 1.649742 |
| Other Services | 25.0 | 0.120735 | 0.034937 | 0.055134 | 0.096538 | 0.126576 | 0.144707 | 0.171247 |
In [11]:
display(naics_year_mktval)
| fyear | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | ... | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| naics_label | |||||||||||||||||||||
| Agriculture, Forestry, Fishing and Hunting | 0.217631 | 0.192928 | 0.184492 | 0.188476 | 0.165438 | 0.043017 | 0.034446 | 0.065723 | 0.096749 | 0.078890 | ... | 0.089563 | 0.080349 | 0.069247 | 0.069313 | 0.063764 | 0.054387 | 0.056946 | 0.014842 | 0.015996 | 0.006700 |
| Mining, Quarrying, and Oil and Gas Extraction | 1.964540 | 1.865740 | 2.170194 | 1.774902 | 0.860737 | 0.850277 | 1.010822 | 0.808599 | 1.254999 | 1.357313 | ... | 3.023544 | 3.336683 | 2.742283 | 2.402371 | 2.122125 | 1.624312 | 1.032139 | 1.533673 | 1.381149 | 0.836426 |
| Utilities | 1.095833 | 0.799188 | 0.775740 | 0.626868 | 0.510882 | 0.396940 | 0.507247 | 0.380657 | 0.394622 | 0.384254 | ... | 0.681667 | 0.631771 | 0.732287 | 0.616717 | 0.651092 | 0.705814 | 0.611017 | 0.643933 | 0.522055 | 0.479018 |
| Construction | 0.342389 | 0.297719 | 0.278737 | 0.266390 | 0.237240 | 0.171909 | 0.218167 | 0.240096 | 0.380933 | 0.532108 | ... | 0.493282 | 0.490821 | 0.412055 | 0.533924 | 0.523845 | 0.449001 | 0.443892 | 0.443714 | 0.498787 | 0.430708 |
| Manufacturing | 43.972228 | 44.487155 | 44.681089 | 41.851269 | 40.522766 | 37.631895 | 43.762847 | 35.056487 | 39.954270 | 39.624838 | ... | 40.268321 | 40.563040 | 41.427271 | 39.879046 | 38.519914 | 38.538829 | 37.724268 | 36.472366 | 36.562809 | 36.149489 |
| Wholesale Trade | 1.408793 | 1.379396 | 1.459720 | 1.331752 | 1.312287 | 0.990042 | 1.201411 | 1.047867 | 1.212955 | 1.185413 | ... | 1.291153 | 1.272908 | 1.328310 | 1.276149 | 1.373727 | 1.448908 | 1.312641 | 1.260232 | 1.004764 | 0.917544 |
| Retail Trade | 6.906009 | 5.477932 | 5.585286 | 5.960137 | 7.529338 | 6.190506 | 6.199213 | 20.553411 | 7.115046 | 7.273170 | ... | 7.926896 | 6.961425 | 7.366782 | 7.383122 | 6.993549 | 7.092943 | 7.685944 | 6.972144 | 7.190139 | 7.623985 |
| Transportation and Warehousing | 2.311186 | 2.372682 | 2.254198 | 1.966989 | 1.659659 | 1.810137 | 1.858853 | 1.796194 | 2.287156 | 2.257111 | ... | 3.378556 | 3.467057 | 3.809287 | 3.514899 | 3.799889 | 4.421726 | 3.377143 | 3.634707 | 3.274249 | 2.847002 |
| Information | 17.471641 | 18.624108 | 15.841483 | 16.930812 | 20.952675 | 30.325904 | 20.186058 | 17.640562 | 17.976160 | 16.855870 | ... | 14.972788 | 14.764945 | 15.117586 | 15.560291 | 16.478300 | 15.891205 | 17.282052 | 17.295817 | 17.409422 | 18.547090 |
| Finance and Insurance | 16.440629 | 16.598975 | 18.141330 | 20.796164 | 18.683766 | 14.311268 | 18.974256 | 16.613647 | 22.587112 | 23.294308 | ... | 20.034638 | 19.784951 | 18.013290 | 20.371362 | 20.572481 | 20.733629 | 20.759278 | 22.546354 | 23.003862 | 23.336421 |
| Real Estate and Rental and Leasing | 1.220292 | 1.243241 | 1.490530 | 1.711914 | 1.416661 | 1.132546 | 1.167250 | 1.256800 | 1.717741 | 2.028784 | ... | 2.706277 | 3.133416 | 3.532377 | 3.300424 | 3.377972 | 3.703946 | 4.331448 | 4.013863 | 3.956670 | 3.703837 |
| Professional, Scientific, and Technical Services | 1.707905 | 1.801152 | 2.348418 | 2.442814 | 2.677090 | 3.766563 | 2.265404 | 1.626553 | 1.457001 | 1.586170 | ... | 1.531403 | 1.665137 | 1.467185 | 1.457115 | 1.445983 | 1.416669 | 1.321447 | 1.234746 | 1.252480 | 1.323266 |
| Administrative and Support and Waste Management and Remediation Services | 1.432550 | 1.287323 | 1.277828 | 1.222710 | 1.103700 | 0.760083 | 0.710948 | 0.803964 | 0.924576 | 0.856355 | ... | 0.902458 | 0.892346 | 0.792166 | 0.862940 | 0.916954 | 0.891780 | 0.989829 | 0.985413 | 1.031409 | 0.973267 |
| Educational Services | 0.144141 | 0.137407 | 0.141675 | 0.149932 | 0.143360 | 0.095580 | 0.123947 | 0.150567 | 0.254682 | 0.284794 | ... | 0.286372 | 0.209023 | 0.189209 | 0.093846 | 0.090858 | 0.097029 | 0.059723 | 0.059434 | 0.064113 | 0.072723 |
| Health Care and Social Assistance | 1.484628 | 1.413488 | 1.308361 | 1.015436 | 0.680625 | 0.393818 | 0.743091 | 0.836639 | 0.859305 | 0.826497 | ... | 0.682832 | 0.637044 | 0.654590 | 0.554388 | 0.680457 | 0.785480 | 0.802948 | 0.726552 | 0.636160 | 0.668251 |
| Arts, Entertainment, and Recreation | 0.239707 | 0.151115 | 0.166052 | 0.181044 | 0.170040 | 0.142164 | 0.101964 | 0.128091 | 0.175565 | 0.183661 | ... | 0.145746 | 0.145551 | 0.152684 | 0.152730 | 0.163764 | 0.151523 | 0.145559 | 0.178830 | 0.217323 | 0.233712 |
| Accommodation and Food Service | 1.457061 | 1.672179 | 1.642152 | 1.355111 | 1.191665 | 0.924603 | 0.902541 | 0.922568 | 1.241386 | 1.307048 | ... | 1.526698 | 1.907477 | 2.122788 | 1.912488 | 2.181561 | 1.948840 | 2.014306 | 1.941638 | 1.935965 | 1.807181 |
| Other Services | 0.182836 | 0.198273 | 0.252715 | 0.227283 | 0.182071 | 0.062748 | 0.031538 | 0.071576 | 0.109740 | 0.083417 | ... | 0.057804 | 0.056056 | 0.070604 | 0.058875 | 0.043764 | 0.043978 | 0.049419 | 0.041743 | 0.042648 | 0.043381 |
18 rows × 25 columns
In [12]:
display(naics_year_mktval.T.describe().T)
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| naics_label | ||||||||
| Agriculture, Forestry, Fishing and Hunting | 25.0 | 0.087759 | 0.057618 | 0.006700 | 0.056946 | 0.078648 | 0.089563 | 0.217631 |
| Mining, Quarrying, and Oil and Gas Extraction | 25.0 | 1.791393 | 0.718297 | 0.808599 | 1.254999 | 1.774902 | 2.170194 | 3.336683 |
| Utilities | 25.0 | 0.592604 | 0.164987 | 0.380657 | 0.478628 | 0.611017 | 0.681667 | 1.095833 |
| Construction | 25.0 | 0.427810 | 0.141148 | 0.171909 | 0.297719 | 0.443892 | 0.523845 | 0.726490 |
| Manufacturing | 25.0 | 39.874980 | 2.726138 | 35.056487 | 37.897202 | 39.879046 | 41.427271 | 44.681089 |
| Wholesale Trade | 25.0 | 1.262869 | 0.141128 | 0.917544 | 1.212955 | 1.291153 | 1.362302 | 1.459720 |
| Retail Trade | 25.0 | 7.496531 | 2.791483 | 5.477932 | 6.906009 | 7.092943 | 7.383122 | 20.553411 |
| Transportation and Warehousing | 25.0 | 2.795937 | 0.750176 | 1.659659 | 2.257111 | 2.738405 | 3.378556 | 4.421726 |
| Information | 25.0 | 17.302152 | 3.188732 | 14.532095 | 15.199913 | 16.930812 | 17.640562 | 30.325904 |
| Finance and Insurance | 25.0 | 20.278357 | 2.667849 | 14.311268 | 18.683766 | 20.572481 | 22.546354 | 24.699160 |
| Real Estate and Rental and Leasing | 25.0 | 2.510702 | 1.036492 | 1.132546 | 1.490530 | 2.499954 | 3.377972 | 4.331448 |
| Professional, Scientific, and Technical Services | 25.0 | 1.742178 | 0.566360 | 1.234746 | 1.445983 | 1.563531 | 1.707905 | 3.766563 |
| Administrative and Support and Waste Management and Remediation Services | 25.0 | 0.975945 | 0.178107 | 0.710948 | 0.862940 | 0.916954 | 1.057408 | 1.432550 |
| Educational Services | 25.0 | 0.168044 | 0.085090 | 0.059434 | 0.095580 | 0.144141 | 0.222365 | 0.324784 |
| Health Care and Social Assistance | 25.0 | 0.796059 | 0.258184 | 0.393818 | 0.654590 | 0.726552 | 0.826497 | 1.484628 |
| Arts, Entertainment, and Recreation | 25.0 | 0.175188 | 0.038205 | 0.101964 | 0.147339 | 0.166052 | 0.205595 | 0.239707 |
| Accommodation and Food Service | 25.0 | 1.627107 | 0.377483 | 0.902541 | 1.355111 | 1.712440 | 1.930465 | 2.181561 |
| Other Services | 25.0 | 0.094386 | 0.063166 | 0.031538 | 0.049419 | 0.070604 | 0.105834 | 0.252715 |
In [13]:
display(naics_year_mktval)
| fyear | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | ... | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| naics_label | |||||||||||||||||||||
| Agriculture, Forestry, Fishing and Hunting | 0.217631 | 0.192928 | 0.184492 | 0.188476 | 0.165438 | 0.043017 | 0.034446 | 0.065723 | 0.096749 | 0.078890 | ... | 0.089563 | 0.080349 | 0.069247 | 0.069313 | 0.063764 | 0.054387 | 0.056946 | 0.014842 | 0.015996 | 0.006700 |
| Mining, Quarrying, and Oil and Gas Extraction | 1.964540 | 1.865740 | 2.170194 | 1.774902 | 0.860737 | 0.850277 | 1.010822 | 0.808599 | 1.254999 | 1.357313 | ... | 3.023544 | 3.336683 | 2.742283 | 2.402371 | 2.122125 | 1.624312 | 1.032139 | 1.533673 | 1.381149 | 0.836426 |
| Utilities | 1.095833 | 0.799188 | 0.775740 | 0.626868 | 0.510882 | 0.396940 | 0.507247 | 0.380657 | 0.394622 | 0.384254 | ... | 0.681667 | 0.631771 | 0.732287 | 0.616717 | 0.651092 | 0.705814 | 0.611017 | 0.643933 | 0.522055 | 0.479018 |
| Construction | 0.342389 | 0.297719 | 0.278737 | 0.266390 | 0.237240 | 0.171909 | 0.218167 | 0.240096 | 0.380933 | 0.532108 | ... | 0.493282 | 0.490821 | 0.412055 | 0.533924 | 0.523845 | 0.449001 | 0.443892 | 0.443714 | 0.498787 | 0.430708 |
| Manufacturing | 43.972228 | 44.487155 | 44.681089 | 41.851269 | 40.522766 | 37.631895 | 43.762847 | 35.056487 | 39.954270 | 39.624838 | ... | 40.268321 | 40.563040 | 41.427271 | 39.879046 | 38.519914 | 38.538829 | 37.724268 | 36.472366 | 36.562809 | 36.149489 |
| Wholesale Trade | 1.408793 | 1.379396 | 1.459720 | 1.331752 | 1.312287 | 0.990042 | 1.201411 | 1.047867 | 1.212955 | 1.185413 | ... | 1.291153 | 1.272908 | 1.328310 | 1.276149 | 1.373727 | 1.448908 | 1.312641 | 1.260232 | 1.004764 | 0.917544 |
| Retail Trade | 6.906009 | 5.477932 | 5.585286 | 5.960137 | 7.529338 | 6.190506 | 6.199213 | 20.553411 | 7.115046 | 7.273170 | ... | 7.926896 | 6.961425 | 7.366782 | 7.383122 | 6.993549 | 7.092943 | 7.685944 | 6.972144 | 7.190139 | 7.623985 |
| Transportation and Warehousing | 2.311186 | 2.372682 | 2.254198 | 1.966989 | 1.659659 | 1.810137 | 1.858853 | 1.796194 | 2.287156 | 2.257111 | ... | 3.378556 | 3.467057 | 3.809287 | 3.514899 | 3.799889 | 4.421726 | 3.377143 | 3.634707 | 3.274249 | 2.847002 |
| Information | 17.471641 | 18.624108 | 15.841483 | 16.930812 | 20.952675 | 30.325904 | 20.186058 | 17.640562 | 17.976160 | 16.855870 | ... | 14.972788 | 14.764945 | 15.117586 | 15.560291 | 16.478300 | 15.891205 | 17.282052 | 17.295817 | 17.409422 | 18.547090 |
| Finance and Insurance | 16.440629 | 16.598975 | 18.141330 | 20.796164 | 18.683766 | 14.311268 | 18.974256 | 16.613647 | 22.587112 | 23.294308 | ... | 20.034638 | 19.784951 | 18.013290 | 20.371362 | 20.572481 | 20.733629 | 20.759278 | 22.546354 | 23.003862 | 23.336421 |
| Real Estate and Rental and Leasing | 1.220292 | 1.243241 | 1.490530 | 1.711914 | 1.416661 | 1.132546 | 1.167250 | 1.256800 | 1.717741 | 2.028784 | ... | 2.706277 | 3.133416 | 3.532377 | 3.300424 | 3.377972 | 3.703946 | 4.331448 | 4.013863 | 3.956670 | 3.703837 |
| Professional, Scientific, and Technical Services | 1.707905 | 1.801152 | 2.348418 | 2.442814 | 2.677090 | 3.766563 | 2.265404 | 1.626553 | 1.457001 | 1.586170 | ... | 1.531403 | 1.665137 | 1.467185 | 1.457115 | 1.445983 | 1.416669 | 1.321447 | 1.234746 | 1.252480 | 1.323266 |
| Administrative and Support and Waste Management and Remediation Services | 1.432550 | 1.287323 | 1.277828 | 1.222710 | 1.103700 | 0.760083 | 0.710948 | 0.803964 | 0.924576 | 0.856355 | ... | 0.902458 | 0.892346 | 0.792166 | 0.862940 | 0.916954 | 0.891780 | 0.989829 | 0.985413 | 1.031409 | 0.973267 |
| Educational Services | 0.144141 | 0.137407 | 0.141675 | 0.149932 | 0.143360 | 0.095580 | 0.123947 | 0.150567 | 0.254682 | 0.284794 | ... | 0.286372 | 0.209023 | 0.189209 | 0.093846 | 0.090858 | 0.097029 | 0.059723 | 0.059434 | 0.064113 | 0.072723 |
| Health Care and Social Assistance | 1.484628 | 1.413488 | 1.308361 | 1.015436 | 0.680625 | 0.393818 | 0.743091 | 0.836639 | 0.859305 | 0.826497 | ... | 0.682832 | 0.637044 | 0.654590 | 0.554388 | 0.680457 | 0.785480 | 0.802948 | 0.726552 | 0.636160 | 0.668251 |
| Arts, Entertainment, and Recreation | 0.239707 | 0.151115 | 0.166052 | 0.181044 | 0.170040 | 0.142164 | 0.101964 | 0.128091 | 0.175565 | 0.183661 | ... | 0.145746 | 0.145551 | 0.152684 | 0.152730 | 0.163764 | 0.151523 | 0.145559 | 0.178830 | 0.217323 | 0.233712 |
| Accommodation and Food Service | 1.457061 | 1.672179 | 1.642152 | 1.355111 | 1.191665 | 0.924603 | 0.902541 | 0.922568 | 1.241386 | 1.307048 | ... | 1.526698 | 1.907477 | 2.122788 | 1.912488 | 2.181561 | 1.948840 | 2.014306 | 1.941638 | 1.935965 | 1.807181 |
| Other Services | 0.182836 | 0.198273 | 0.252715 | 0.227283 | 0.182071 | 0.062748 | 0.031538 | 0.071576 | 0.109740 | 0.083417 | ... | 0.057804 | 0.056056 | 0.070604 | 0.058875 | 0.043764 | 0.043978 | 0.049419 | 0.041743 | 0.042648 | 0.043381 |
18 rows × 25 columns
In [14]:
display(naics_year_ps_multiple.T.describe().T)
temp2=naics_year_ps_multiple.T.mean()
names=temp2.index.to_list()
temp2.index=names
temp2=pd.concat([temp2, pd.Series([temp['ratio'].mean()],index=['All'])] )
temp2.to_csv('price_sales_mean.csv')
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| naics_label | ||||||||
| Agriculture, Forestry, Fishing and Hunting | 25.0 | 1.193024 | 0.677125 | 0.488159 | 0.775627 | 0.915154 | 1.490932 | 3.170838 |
| Mining, Quarrying, and Oil and Gas Extraction | 25.0 | 1.702687 | 0.569655 | 0.958791 | 1.212418 | 1.470739 | 2.121611 | 2.733203 |
| Utilities | 25.0 | 0.590666 | 0.232525 | 0.287596 | 0.418810 | 0.531264 | 0.709038 | 1.092168 |
| Construction | 25.0 | 0.531940 | 0.157148 | 0.308470 | 0.374372 | 0.554288 | 0.655134 | 0.842454 |
| Manufacturing | 25.0 | 1.577052 | 0.370335 | 0.897474 | 1.333033 | 1.560647 | 1.780886 | 2.364602 |
| Wholesale Trade | 25.0 | 0.273252 | 0.043567 | 0.161063 | 0.250060 | 0.281035 | 0.302228 | 0.333397 |
| Retail Trade | 25.0 | 0.687406 | 0.348390 | 0.387750 | 0.506691 | 0.622248 | 0.747855 | 2.214593 |
| Transportation and Warehousing | 25.0 | 0.688796 | 0.264244 | 0.291680 | 0.466333 | 0.668140 | 0.767267 | 1.209608 |
| Information | 25.0 | 2.254118 | 0.735853 | 1.220714 | 1.691885 | 2.140089 | 2.666322 | 4.596095 |
| Finance and Insurance | 25.0 | 1.673212 | 0.594872 | 0.884551 | 1.271386 | 1.431917 | 1.769755 | 3.220669 |
| Real Estate and Rental and Leasing | 25.0 | 2.696638 | 0.973132 | 1.426451 | 1.870612 | 2.673809 | 3.233247 | 4.689120 |
| Professional, Scientific, and Technical Services | 25.0 | 1.437987 | 0.444949 | 0.753545 | 1.206807 | 1.296104 | 1.658825 | 2.987972 |
| Administrative and Support and Waste Management and Remediation Services | 25.0 | 1.109682 | 0.246573 | 0.644644 | 0.975262 | 1.014459 | 1.283063 | 1.670789 |
| Educational Services | 25.0 | 1.818511 | 0.771426 | 0.651472 | 1.122173 | 1.825991 | 2.428138 | 3.353606 |
| Health Care and Social Assistance | 25.0 | 0.743112 | 0.197912 | 0.372465 | 0.620587 | 0.720252 | 0.929451 | 1.053207 |
| Arts, Entertainment, and Recreation | 25.0 | 1.290378 | 0.348524 | 0.635686 | 1.097087 | 1.229272 | 1.524456 | 1.929513 |
| Accommodation and Food Service | 25.0 | 1.460847 | 0.511396 | 0.832734 | 1.002816 | 1.410243 | 1.799823 | 2.597360 |
| Other Services | 25.0 | 1.003527 | 0.426668 | 0.339314 | 0.524143 | 1.050543 | 1.278303 | 1.791542 |
In [15]:
naics_year_ps_multiple
Out[15]:
| fyear | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | ... | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| naics_label | |||||||||||||||||||||
| Agriculture, Forestry, Fishing and Hunting | 0.786572 | 1.035276 | 1.160059 | 1.452099 | 1.490932 | 0.572138 | 0.488159 | 0.924008 | 0.915154 | 0.860408 | ... | 0.749807 | 0.775627 | 0.654433 | 0.925505 | 1.633126 | 2.414251 | 2.318170 | 1.737295 | 1.973729 | 3.170838 |
| Mining, Quarrying, and Oil and Gas Extraction | 0.958791 | 1.156798 | 1.416435 | 1.466689 | 1.005526 | 1.217724 | 1.200027 | 1.212418 | 1.427275 | 1.633084 | ... | 2.428641 | 2.733203 | 1.891349 | 1.812313 | 1.907821 | 1.470739 | 1.299254 | 2.684126 | 2.172436 | 1.164774 |
| Utilities | 0.479009 | 0.527576 | 0.549562 | 0.532742 | 0.531264 | 0.452850 | 0.418810 | 0.287596 | 0.314410 | 0.349221 | ... | 0.523975 | 0.554671 | 0.655865 | 0.709038 | 0.869526 | 0.959481 | 0.893321 | 1.092168 | 1.002348 | 0.901615 |
| Construction | 0.343028 | 0.365518 | 0.379744 | 0.419405 | 0.374372 | 0.308470 | 0.360083 | 0.347082 | 0.356013 | 0.579157 | ... | 0.571376 | 0.681169 | 0.554288 | 0.729415 | 0.788956 | 0.706735 | 0.677484 | 0.655134 | 0.842454 | 0.617197 |
| Manufacturing | 0.897474 | 1.097195 | 1.233748 | 1.471529 | 1.773350 | 1.937232 | 2.041113 | 1.690970 | 1.387543 | 1.679757 | ... | 1.337883 | 1.333033 | 1.192345 | 1.323883 | 1.623613 | 1.780886 | 1.949159 | 2.108337 | 2.364602 | 2.069787 |
| Wholesale Trade | 0.250060 | 0.275296 | 0.314947 | 0.326265 | 0.333397 | 0.281035 | 0.286438 | 0.293805 | 0.258273 | 0.293223 | ... | 0.216400 | 0.228465 | 0.199825 | 0.217969 | 0.285719 | 0.302228 | 0.280929 | 0.300725 | 0.275408 | 0.229921 |
| Retail Trade | 0.387750 | 0.392713 | 0.464810 | 0.603257 | 0.853872 | 0.804848 | 0.747855 | 2.214593 | 0.501991 | 0.646679 | ... | 0.532552 | 0.506691 | 0.501717 | 0.564127 | 0.655438 | 0.715568 | 0.758513 | 0.710542 | 0.851052 | 0.870537 |
| Transportation and Warehousing | 0.291680 | 0.389870 | 0.424350 | 0.466333 | 0.456735 | 0.590563 | 0.516642 | 0.437261 | 0.483327 | 0.571273 | ... | 0.698221 | 0.763867 | 0.738857 | 0.767267 | 0.963923 | 1.161573 | 0.990929 | 1.199967 | 1.209608 | 0.996963 |
| Information | 1.220714 | 1.595054 | 1.565379 | 2.007425 | 2.809210 | 4.596095 | 2.933915 | 2.398092 | 1.729185 | 2.068137 | ... | 1.541825 | 1.691885 | 1.626002 | 1.822087 | 2.462421 | 2.508559 | 2.666322 | 2.750910 | 3.118183 | 3.080971 |
| Finance and Insurance | 0.884551 | 1.047997 | 1.245419 | 1.558337 | 1.295366 | 1.180001 | 1.422331 | 1.364144 | 1.271386 | 1.676501 | ... | 1.266940 | 1.431917 | 1.290263 | 1.652333 | 2.094019 | 2.442642 | 2.267829 | 2.684474 | 3.220669 | 2.776563 |
| Real Estate and Rental and Leasing | 1.426451 | 1.597402 | 1.950760 | 2.673809 | 2.061702 | 1.870612 | 1.750575 | 1.766565 | 1.565928 | 2.208872 | ... | 2.255032 | 2.854052 | 2.963387 | 3.216090 | 3.815154 | 4.010895 | 4.036188 | 4.063262 | 4.689120 | 4.081924 |
| Professional, Scientific, and Technical Services | 1.110742 | 1.019244 | 1.468498 | 1.658825 | 1.922792 | 2.987972 | 1.848908 | 1.365219 | 0.907947 | 1.218874 | ... | 1.051325 | 1.296104 | 1.077193 | 1.206807 | 1.648095 | 1.845652 | 1.574544 | 1.499574 | 1.676110 | 1.695268 |
| Administrative and Support and Waste Management and Remediation Services | 0.986527 | 1.014459 | 1.135323 | 1.176949 | 1.115347 | 0.958353 | 0.844945 | 0.982907 | 0.856546 | 0.999962 | ... | 0.934392 | 0.975262 | 0.790391 | 1.008946 | 1.283063 | 1.320745 | 1.421948 | 1.478638 | 1.670789 | 1.496178 |
| Educational Services | 1.567432 | 1.662725 | 2.026362 | 2.619544 | 2.467803 | 1.854562 | 2.223740 | 2.428138 | 2.453165 | 3.094573 | ... | 1.698258 | 1.206346 | 1.111484 | 0.690128 | 0.890887 | 0.896715 | 0.651472 | 0.775367 | 1.122173 | 1.586944 |
| Health Care and Social Assistance | 1.025671 | 1.053207 | 1.048842 | 1.003972 | 0.720252 | 0.514796 | 0.929451 | 0.971924 | 0.652018 | 0.755285 | ... | 0.460008 | 0.478339 | 0.480241 | 0.592018 | 0.707072 | 0.807486 | 0.708477 | 0.670773 | 0.720156 | 0.788146 |
| Arts, Entertainment, and Recreation | 1.524456 | 1.145527 | 1.422653 | 1.794200 | 1.677350 | 1.491556 | 1.021388 | 1.229272 | 1.105975 | 1.140521 | ... | 0.808867 | 0.905715 | 0.836961 | 0.883618 | 1.130067 | 1.114151 | 1.097087 | 1.416816 | 1.850759 | 1.929513 |
| Accommodation and Food Service | 0.832734 | 1.002816 | 1.087558 | 1.186391 | 1.253412 | 0.979427 | 0.884581 | 0.936581 | 0.882990 | 1.143057 | ... | 1.144516 | 1.543966 | 1.485819 | 1.410243 | 2.149490 | 1.957906 | 2.022635 | 2.195617 | 2.597360 | 2.279813 |
| Other Services | 1.192211 | 1.278303 | 1.654425 | 1.791542 | 1.614762 | 0.618374 | 0.339314 | 0.778668 | 0.832957 | 0.842758 | ... | 0.497751 | 0.490530 | 0.524143 | 0.488259 | 0.523014 | 1.032940 | 1.158756 | 1.050543 | 1.426767 | 1.467446 |
18 rows × 25 columns
In [69]:
sel=(CompustatData.naics > 484000) & (CompustatData.naics < 486000)
Naics484=pd.pivot_table(CompustatData[sel], values=['mkvalt','sale'], columns=['fyear'], aggfunc=np.sum).T
Naics484['ratio']=Naics484.mkvalt/Naics484.sale
Naics484.ratio.plot()
Out[69]:
<matplotlib.axes._subplots.AxesSubplot at 0x20fcd587198>
In [71]:
#pd.set_option('display.max_rows', None)
CompustatData[sel][['mkvalt','sale','prcc_f']].groupby([ CompustatData[sel].conm, CompustatData[sel].fyear ]).mean()
Out[71]:
| mkvalt | sale | prcc_f | ||
|---|---|---|---|---|
| conm | fyear | |||
| ALLIED HOLDINGS INC | 1994 | 92.700000 | 297.236 | 12.0000 |
| 1995 | 66.628125 | 381.464 | 8.6250 | |
| 1996 | 62.480000 | 392.547 | 8.0000 | |
| 1997 | 149.538375 | 581.530 | 19.1250 | |
| 1998 | 113.246250 | 1026.799 | 14.3750 | |
| 1999 | 48.804000 | 1081.309 | 6.1250 | |
| 2000 | 22.132000 | 1069.154 | 2.7500 | |
| 2001 | 16.432700 | 896.767 | 2.0200 | |
| 2002 | 28.126140 | 898.060 | 3.3400 | |
| 2003 | 41.804280 | 865.463 | 4.7700 | |
| 2004 | 25.419150 | 895.213 | 2.8500 | |
| 2005 | 5.388000 | 892.934 | 0.6000 | |
| 2006 | 10.776000 | 893.837 | 1.2000 | |
| AMERICAN FREIGHTWAYS CORP | 1994 | 606.108000 | 465.588 | 19.8750 |
| 1995 | 320.909125 | 572.100 | 10.3750 | |
| 1996 | 347.567250 | 729.042 | 11.1250 | |
| 1997 | 311.734000 | 870.319 | 9.8750 | |
| 1998 | 365.311584 | 986.286 | 11.5313 | |
| 1999 | 521.949750 | 1166.675 | 16.1875 | |
| AMERICAN MEDICAL RESPONSE | 1994 | 426.368250 | 311.727 | 28.8750 |
| 1995 | 645.710000 | 483.846 | 32.5000 | |
| 1996 | NaN | 719.408 | 32.5000 | |
| AMPACE CORP | 1995 | 8.400000 | 21.242 | 3.0000 |
| 1996 | 3.459375 | 30.446 | 1.1250 | |
| 1997 | 3.226356 | 34.857 | 1.0620 | |
| ARCBEST CORP | 1994 | 236.607250 | 1098.421 | 12.1250 |
| 1995 | 153.712125 | 1437.279 | 7.8750 | |
| 1996 | 85.330000 | 1659.184 | 4.3750 | |
| 1997 | 191.061000 | 1643.678 | 9.7500 | |
| 1998 | 114.596918 | 1651.453 | 5.8438 | |
| 1999 | 237.024000 | 1721.586 | 12.0000 | |
| 2000 | 369.161687 | 1839.567 | 18.3125 | |
| 2001 | 705.571240 | 1526.206 | 28.8200 | |
| 2002 | 647.238672 | 1422.297 | 25.9810 | |
| 2003 | 787.632560 | 1527.473 | 31.4600 | |
| 2004 | 1134.549860 | 1715.763 | 44.8900 | |
| 2005 | 1108.554720 | 1860.269 | 43.6800 | |
| 2006 | 894.780000 | 1860.477 | 36.0000 | |
| 2007 | 545.669740 | 1836.878 | 21.9400 | |
| 2008 | 753.472640 | 1833.052 | 30.1100 | |
| 2009 | 737.839530 | 1472.901 | 29.4300 | |
| 2010 | 692.546940 | 1657.864 | 27.4200 | |
| 2011 | 489.881940 | 1907.609 | 19.2700 | |
| 2012 | 244.651900 | 2065.999 | 9.5500 | |
| 2013 | 869.920720 | 2299.549 | 33.6800 | |
| 2014 | 1207.660280 | 2612.693 | 46.3700 | |
| 2015 | 553.102620 | 2666.905 | 21.3900 | |
| 2016 | 708.088850 | 2700.219 | 27.6500 | |
| 2017 | 916.773000 | 2826.457 | 35.7500 | |
| 2018 | 876.610620 | 3093.788 | 34.2600 | |
| ARROW TRANSPORTATION CO | 1994 | 18.459000 | 34.110 | 4.5000 |
| 1995 | 5.176250 | 31.416 | 1.2500 | |
| 1996 | 2.355342 | 27.579 | 0.5620 | |
| ASCHE TRANSPORTATION SVCS | 1994 | 18.490625 | 26.319 | 7.6250 |
| 1995 | 20.721750 | 67.748 | 5.2500 | |
| 1996 | 20.259125 | 77.365 | 5.1250 | |
| 1997 | 18.160000 | 65.170 | 4.0000 | |
| 1998 | 18.784000 | 113.431 | 4.0000 | |
| ATLANTIC EXPRESS TRANSN CORP | 2000 | NaN | 353.481 | NaN |
| 2001 | NaN | 441.578 | NaN | |
| 2002 | NaN | NaN | NaN | |
| 2003 | NaN | NaN | NaN | |
| 2004 | NaN | 363.521 | NaN | |
| 2005 | NaN | 363.676 | NaN | |
| 2006 | NaN | 414.058 | NaN | |
| 2007 | NaN | 428.817 | NaN | |
| BOYD BROS TRANSPORTATION INC | 1994 | 37.274250 | 59.132 | 9.7500 |
| 1995 | 27.716750 | 61.866 | 7.2500 | |
| 1996 | 25.907000 | 65.523 | 7.0000 | |
| 1997 | 34.295625 | 77.215 | 8.3750 | |
| 1998 | 25.437500 | 118.123 | 6.2500 | |
| 1999 | 21.645000 | 133.137 | 6.5000 | |
| 2000 | 7.008625 | 126.725 | 2.3750 | |
| 2001 | 8.145000 | 123.856 | 3.0000 | |
| 2002 | 9.403700 | 127.792 | 3.4700 | |
| 2003 | 16.678800 | 134.346 | 6.1500 | |
| BUILDERS TRANSPORT INC | 1994 | 55.342875 | 286.243 | 10.8750 |
| 1995 | 38.506250 | 289.527 | 7.6250 | |
| 1996 | 13.606968 | 289.419 | 2.6870 | |
| 1997 | 7.593108 | 288.145 | 1.4370 | |
| BULOVA TECHNOLOGIES GP INC | 1994 | 2.018665 | 1.787 | 0.1870 |
| 1995 | 2.013990 | 1.975 | 0.1870 | |
| 1996 | 1.702740 | 1.490 | 0.1560 | |
| 1997 | 11.041333 | NaN | 0.2810 | |
| 1998 | 11.876900 | 29.385 | 0.3500 | |
| 1999 | 4.798794 | 16.478 | 0.1410 | |
| 2000 | 9.762135 | 0.132 | 0.2350 | |
| 2001 | 3.541300 | 1.198 | 0.1000 | |
| 2002 | 1.063650 | 0.833 | 0.0300 | |
| 2003 | 1.240925 | 1.148 | 0.0350 | |
| 2004 | 1.444440 | 1.100 | 0.0400 | |
| 2005 | 0.782220 | 0.321 | 0.0200 | |
| 2006 | 2.356920 | 0.881 | 0.0600 | |
| 2007 | 0.942768 | 0.549 | 0.0240 | |
| 2008 | 1.429230 | 0.000 | 0.0150 | |
| 2009 | 50.647100 | 21.498 | 0.7000 | |
| 2010 | 6.224552 | 11.670 | 0.0760 | |
| 2011 | 5.476738 | 4.903 | 0.0125 | |
| 2012 | 0.994997 | 3.142 | 0.0006 | |
| 2013 | 0.420026 | 0.021 | 0.0001 | |
| 2014 | 1.363440 | 3.163 | 0.0230 | |
| 2015 | 4.145640 | 1.754 | 0.0600 | |
| 2016 | 0.790630 | 18.721 | 0.0023 | |
| 2017 | 1.581424 | 25.150 | 0.0026 | |
| C H ROBINSON WORLDWIDE INC | 1995 | NaN | 1445.975 | NaN |
| 1996 | NaN | 1605.905 | NaN | |
| 1997 | 923.304375 | 1790.785 | 22.3750 | |
| 1998 | 1068.365625 | 2038.139 | 25.9375 | |
| 1999 | 1680.789000 | 2261.027 | 39.7500 | |
| 2000 | 2660.272687 | 2882.175 | 31.4375 | |
| 2001 | 2442.074155 | 3090.072 | 28.9150 | |
| 2002 | 2636.587200 | 3294.473 | 31.2000 | |
| 2003 | 3233.874640 | 3613.645 | 37.9100 | |
| 2004 | 4732.524800 | 4341.538 | 55.5200 | |
| 2005 | 6407.300900 | 5688.948 | 37.0300 | |
| 2006 | 7059.903840 | 6556.194 | 40.8900 | |
| 2007 | 9244.886640 | 7316.223 | 54.1200 | |
| 2008 | 9379.148110 | 8578.614 | 55.0300 | |
| 2009 | 9813.665540 | 7577.189 | 58.7300 | |
| 2010 | 13315.389120 | 9274.305 | 80.1900 | |
| 2011 | 11404.912980 | 10336.346 | 69.7800 | |
| 2012 | 10199.092940 | 11359.113 | 63.2200 | |
| 2013 | 8763.994950 | 12752.076 | 58.3500 | |
| 2014 | 10968.239620 | 13470.067 | 74.8900 | |
| 2015 | 8897.079100 | 13476.084 | 62.0200 | |
| 2016 | 10348.561080 | 13144.413 | 73.2600 | |
| 2017 | 12431.796780 | 14869.380 | 89.0900 | |
| 2018 | 11544.211560 | 16631.172 | 84.0900 | |
| CANNON EXPRESS INC | 1994 | 51.216875 | 59.177 | 11.8750 |
| 1995 | 57.346000 | 79.030 | 13.2500 | |
| 1996 | 33.054000 | 89.991 | 10.5000 | |
| 1997 | 20.449000 | 106.136 | 6.5000 | |
| 1998 | 25.544000 | 109.245 | 8.0000 | |
| 1999 | 9.214375 | 95.213 | 2.8750 | |
| 2000 | 6.810625 | 91.779 | 2.1250 | |
| 2001 | 5.448500 | 85.795 | 1.7000 | |
| 2002 | 2.211450 | 79.077 | 0.6900 | |
| CARELINE INC | 1994 | 107.240000 | 148.185 | 7.0000 |
| CAREY INTERNATIONAL INC | 1994 | NaN | NaN | NaN |
| 1995 | NaN | 43.484 | NaN | |
| 1996 | NaN | 59.506 | NaN | |
| 1997 | 104.912500 | 86.378 | 13.7500 | |
| 1998 | 160.888000 | 123.218 | 17.0000 | |
| 1999 | 206.910000 | 191.058 | 21.3750 | |
| CELADON GROUP INC | 1994 | 90.076250 | 180.921 | 13.7500 |
| 1995 | 118.050250 | 250.243 | 15.2500 | |
| 1996 | 60.070250 | 166.544 | 7.7500 | |
| 1997 | 87.664500 | 191.035 | 11.5000 | |
| 1998 | 146.718000 | 229.928 | 19.0000 | |
| 1999 | 65.883500 | 281.829 | 8.5000 | |
| 2000 | 87.547500 | 351.569 | 11.2500 | |
| 2001 | 32.422000 | 351.818 | 4.3000 | |
| 2002 | 97.971280 | 336.999 | 12.7600 | |
| 2003 | 69.699946 | 367.105 | 9.0590 | |
| 2004 | 171.582400 | 397.923 | 17.6000 | |
| 2005 | 169.845000 | 436.763 | 16.9000 | |
| 2006 | 509.366440 | 480.194 | 22.0400 | |
| 2007 | 374.937900 | 502.692 | 15.9000 | |
| 2008 | 218.501280 | 565.895 | 9.9900 | |
| 2009 | 185.393830 | 490.338 | 8.3900 | |
| 2010 | 314.855380 | 523.492 | 14.1400 | |
| 2011 | 314.407120 | 568.249 | 13.9600 | |
| 2012 | 373.939020 | 598.952 | 16.3800 | |
| 2013 | 423.235750 | 613.648 | 18.2500 | |
| 2014 | 502.299200 | 759.311 | 21.3200 | |
| 2015 | 575.772560 | 900.756 | 20.6800 | |
| 2016 | 230.516550 | 1065.356 | 8.1700 | |
| CENTRAL FREIGHT LINES INC | 1998 | NaN | NaN | NaN |
| 1999 | NaN | NaN | NaN | |
| 2000 | NaN | NaN | NaN | |
| 2001 | NaN | 395.702 | NaN | |
| 2002 | NaN | 371.445 | NaN | |
| 2003 | 312.985750 | 389.696 | 17.7500 | |
| 2004 | 114.590700 | 386.601 | 6.3000 | |
| 2005 | 32.545520 | 372.140 | 1.7800 | |
| COVENANT TRANSPORTATION GRP | 1994 | 260.325000 | 131.926 | 19.5000 |
| 1995 | 160.200000 | 180.346 | 12.0000 | |
| 1996 | 191.906250 | 236.267 | 14.3750 | |
| 1997 | 203.740000 | 297.861 | 15.2500 | |
| 1998 | 266.516250 | 370.546 | 17.8750 | |
| 1999 | 259.096000 | 472.741 | 17.3750 | |
| 2000 | 149.908750 | 552.429 | 10.7500 | |
| 2001 | 224.365680 | 547.028 | 15.9600 | |
| 2002 | 272.606880 | 564.418 | 18.9600 | |
| 2003 | 278.933730 | 582.457 | 19.0100 | |
| 2004 | 305.512680 | 603.622 | 20.8200 | |
| 2005 | 195.426420 | 643.054 | 13.9800 | |
| 2006 | 159.611400 | 683.828 | 11.4000 | |
| 2007 | 94.254720 | 712.526 | 6.7200 | |
| 2008 | 28.098000 | 773.914 | 2.0000 | |
| 2009 | 59.744110 | 588.687 | 4.2100 | |
| 2010 | 140.756880 | 649.749 | 9.6800 | |
| 2011 | 43.724340 | 652.627 | 2.9700 | |
| 2012 | 81.617270 | 674.254 | 5.5300 | |
| 2013 | 122.411100 | 684.549 | 8.2100 | |
| 2014 | 490.609670 | 718.980 | 27.1100 | |
| 2015 | 342.343470 | 724.240 | 18.8900 | |
| 2016 | 352.935660 | 670.651 | 19.3400 | |
| 2017 | 526.620900 | 705.007 | 28.7300 | |
| 2018 | 352.627200 | 885.455 | 19.2000 | |
| DASEKE INC | 2013 | NaN | NaN | NaN |
| 2014 | NaN | NaN | NaN | |
| 2015 | NaN | NaN | NaN | |
| 2016 | NaN | NaN | NaN | |
| 2017 | 696.094480 | 846.304 | 14.2900 | |
| 2018 | 237.194400 | 1613.082 | 3.6800 | |
| ESCO TRANSPORTATION CO | 1994 | NaN | 6.443 | NaN |
| 1995 | 0.955500 | 8.322 | 0.8750 | |
| 1996 | 5.600087 | 17.879 | 0.5125 | |
| 1997 | 5.711013 | 22.742 | 0.4690 | |
| 1998 | 5.261760 | 27.236 | 0.4200 | |
| 1999 | 4.145700 | 34.967 | 0.3000 | |
| FORWARD AIR CORP | 1994 | 90.070500 | 135.032 | 15.5000 |
| 1995 | 77.698000 | 148.083 | 13.2500 | |
| 1996 | 59.530000 | 157.098 | 10.0000 | |
| 1997 | 146.082000 | 190.402 | 24.2500 | |
| 1998 | 118.012500 | 130.438 | 18.7500 | |
| 1999 | 599.529250 | 170.843 | 43.3750 | |
| 2000 | 795.204000 | 214.907 | 37.3125 | |
| 2001 | 733.960960 | 227.500 | 33.9200 | |
| 2002 | 411.841380 | 226.072 | 19.4100 | |
| 2003 | 591.167500 | 241.517 | 27.5000 | |
| 2004 | 965.430600 | 282.197 | 44.7000 | |
| 2005 | 1149.380650 | 320.934 | 36.6500 | |
| 2006 | 878.661960 | 352.758 | 28.9300 | |
| 2007 | 892.958160 | 392.737 | 31.1700 | |
| 2008 | 701.257380 | 474.436 | 24.2700 | |
| 2009 | 724.618500 | 417.410 | 25.0300 | |
| 2010 | 823.899780 | 483.939 | 28.3800 | |
| 2011 | 915.123650 | 536.402 | 32.0500 | |
| 2012 | 1022.116950 | 584.446 | 35.0100 | |
| 2013 | 1340.221020 | 652.481 | 43.9100 | |
| 2014 | 1523.944350 | 780.959 | 50.3700 | |
| 2015 | 1313.697440 | 959.125 | 43.0100 | |
| 2016 | 1425.664200 | 982.530 | 47.3800 | |
| 2017 | 1691.837760 | 1100.816 | 57.4400 | |
| 2018 | 1565.144750 | 1320.886 | 54.8500 | |
| FREYMILLER TRUCKING INC | 1994 | 4.046250 | 95.152 | 1.6250 |
| FROZEN FOOD EXPRESS INDS | 1994 | 197.640500 | 274.620 | 15.5000 |
| 1995 | 142.957500 | 292.345 | 8.7500 | |
| 1996 | 149.778000 | 311.428 | 9.0000 | |
| 1997 | 151.524000 | 316.568 | 9.0000 | |
| 1998 | 129.929625 | 349.932 | 7.8750 | |
| 1999 | 63.243875 | 372.149 | 3.8750 | |
| 2000 | 32.122941 | 392.393 | 1.9688 | |
| 2001 | 35.173040 | 378.409 | 2.1400 | |
| 2002 | 43.354318 | 350.934 | 2.5970 | |
| 2003 | 113.451040 | 404.187 | 6.6400 | |
| 2004 | 226.046700 | 474.430 | 12.9000 | |
| 2005 | 196.400180 | 524.127 | 11.0300 | |
| 2006 | 149.657200 | 483.721 | 8.6000 | |
| 2007 | 98.240900 | 452.214 | 5.9000 | |
| 2008 | 95.191120 | 490.536 | 5.6800 | |
| 2009 | 56.413500 | 373.051 | 3.3000 | |
| 2010 | 76.848660 | 368.822 | 4.4100 | |
| 2011 | 22.693680 | 388.461 | 1.2900 | |
| 2012 | 15.615940 | 377.715 | 0.8900 | |
| GREYHOUND LINES INC | 1994 | 124.242256 | 616.331 | 2.3120 |
| 1995 | 250.820416 | 657.364 | 4.3120 | |
| 1996 | 248.030000 | 700.858 | 4.2500 | |
| 1997 | 218.742336 | 771.122 | 3.6870 | |
| 1998 | 353.357750 | 845.996 | 5.8750 | |
| 1999 | 378.158063 | 923.531 | 6.4375 | |
| 2000 | NaN | 1014.317 | NaN | |
| 2001 | NaN | 1022.420 | NaN | |
| 2002 | NaN | 991.914 | NaN | |
| 2003 | NaN | 975.507 | NaN | |
| 2004 | NaN | 956.734 | NaN | |
| HEARTLAND EXPRESS INC | 1994 | 390.510000 | 224.248 | 30.0000 |
| 1995 | 395.000000 | 191.507 | 19.7500 | |
| 1996 | 731.250000 | 229.011 | 24.3750 | |
| 1997 | 806.250000 | 262.504 | 26.8750 | |
| 1998 | 525.000000 | 263.489 | 17.5000 | |
| 1999 | 416.745000 | 261.004 | 15.7500 | |
| 2000 | 578.684687 | 274.828 | 22.8125 | |
| 2001 | 880.531160 | 294.617 | 27.7700 | |
| 2002 | 1145.550000 | 340.745 | 22.9110 | |
| 2003 | 1209.500000 | 405.116 | 24.1900 | |
| 2004 | 1685.250000 | 457.086 | 22.4700 | |
| 2005 | 1497.848380 | 523.793 | 20.2900 | |
| 2006 | 1475.745040 | 571.919 | 15.0200 | |
| 2007 | 1374.736820 | 591.893 | 14.1800 | |
| 2008 | 1485.049040 | 625.600 | 15.7600 | |
| 2009 | 1384.821030 | 459.539 | 15.2700 | |
| 2010 | 1452.837780 | 499.516 | 16.0200 | |
| 2011 | 1235.727750 | 528.623 | 14.2900 | |
| 2012 | 1107.943900 | 545.745 | 13.0700 | |
| 2013 | 1720.772100 | 582.257 | 19.6200 | |
| 2014 | 2370.964810 | 871.355 | 27.0100 | |
| 2015 | 1431.637300 | 736.345 | 17.0200 | |
| 2016 | 1695.723320 | 612.937 | 20.3600 | |
| 2017 | 1944.292020 | 607.336 | 23.3400 | |
| 2018 | 1499.319000 | 610.803 | 18.3000 | |
| HUNT (JB) TRANSPRT SVCS INC | 1994 | 587.201250 | 1207.601 | 15.2500 |
| 1995 | 639.665750 | 1352.225 | 16.7500 | |
| 1996 | 520.744000 | 1486.748 | 14.0000 | |
| 1997 | 668.681250 | 1554.292 | 18.7500 | |
| 1998 | 818.984000 | 1841.628 | 23.0000 | |
| 1999 | 493.379188 | 2045.073 | 13.8438 | |
| 2000 | 592.035375 | 2160.447 | 16.8125 | |
| 2001 | 834.712800 | 2100.305 | 23.2000 | |
| 2002 | 1152.017400 | 2247.886 | 29.3000 | |
| 2003 | 2163.771100 | 2433.469 | 27.0100 | |
| 2004 | 3650.520900 | 2786.154 | 44.8500 | |
| 2005 | 3482.326320 | 3127.899 | 22.6400 | |
| 2006 | 3002.407350 | 3327.987 | 20.7700 | |
| 2007 | 3431.958600 | 3489.899 | 27.5500 | |
| 2008 | 3311.648740 | 3731.943 | 26.2700 | |
| 2009 | 4106.099340 | 3203.321 | 32.2700 | |
| 2010 | 4958.006900 | 3793.485 | 40.8100 | |
| 2011 | 5270.125240 | 4526.842 | 45.0700 | |
| 2012 | 7017.656590 | 5054.980 | 59.7100 | |
| 2013 | 9062.729300 | 5584.571 | 77.3000 | |
| 2014 | 9821.443750 | 6165.441 | 84.2500 | |
| 2015 | 8359.225280 | 6187.646 | 73.3600 | |
| 2016 | 10804.376350 | 6555.459 | 97.0700 | |
| 2017 | 12619.399940 | 7189.568 | 114.9800 | |
| 2018 | 10114.471440 | 8614.874 | 93.0400 | |
| INTEGRATED FREIGHT CORP | 2008 | NaN | 10.460 | NaN |
| 2009 | 7.769784 | 17.330 | 0.0040 | |
| 2010 | 13.577250 | 18.827 | 0.4300 | |
| 2011 | 2.193300 | 20.715 | 0.0500 | |
| 2012 | 2.330200 | 20.102 | 0.0200 | |
| 2013 | 1.563144 | 20.166 | 0.0060 | |
| 2014 | 1.139133 | 18.971 | 0.0025 | |
| INTRENET INC | 1994 | 40.891500 | 214.838 | 4.5000 |
| 1995 | 23.096500 | 214.973 | 1.7500 | |
| 1996 | 31.853500 | 224.613 | 2.3750 | |
| 1997 | 38.950500 | 247.888 | 2.8750 | |
| 1998 | 46.109250 | 262.722 | 3.3750 | |
| 1999 | 33.312817 | 284.800 | 2.4063 | |
| JEVIC TRANSPORTATION | 1994 | NaN | NaN | NaN |
| 1995 | NaN | 125.973 | NaN | |
| 1996 | NaN | 154.799 | NaN | |
| 1997 | 171.860250 | 190.821 | 16.1250 | |
| 1998 | 84.388500 | 226.123 | 7.8750 | |
| KENAN TRANSPORT CO | 1994 | 41.615000 | 59.100 | 17.5000 |
| 1995 | 49.571750 | 61.717 | 20.7500 | |
| 1996 | 45.391000 | 68.795 | 19.0000 | |
| 1997 | 87.716875 | 73.308 | 36.6250 | |
| 1998 | 77.504000 | 130.046 | 32.0000 | |
| 1999 | 78.109500 | 141.552 | 32.2500 | |
| 2000 | 60.525000 | 157.638 | 25.0000 | |
| KLLM TRANSPORT SERVICES INC | 1994 | 65.812447 | 217.145 | 14.6870 |
| 1995 | 45.769500 | 239.685 | 10.5000 | |
| 1996 | 42.363750 | 256.688 | 9.7500 | |
| 1997 | 53.569250 | 244.085 | 12.2500 | |
| 1998 | 31.159375 | 228.988 | 7.3750 | |
| 1999 | 19.470250 | 234.595 | 4.7500 | |
| KNIGHT-SWIFT TRPTN HLDGS INC | 1994 | 129.675000 | 37.543 | 14.2500 |
| 1995 | 125.152500 | 56.170 | 13.7500 | |
| 1996 | 188.195000 | 77.504 | 19.0000 | |
| 1997 | 276.112500 | 99.429 | 27.7500 | |
| 1998 | 399.805437 | 125.030 | 26.6875 | |
| 1999 | 250.350375 | 151.490 | 17.1250 | |
| 2000 | 288.596000 | 216.859 | 19.2500 | |
| 2001 | 691.742520 | 250.819 | 18.7800 | |
| 2002 | 780.045000 | 285.790 | 21.0000 | |
| 2003 | 961.592850 | 340.069 | 25.6500 | |
| 2004 | 1405.292000 | 442.288 | 24.8000 | |
| 2005 | 1775.856180 | 566.813 | 20.7300 | |
| 2006 | 1468.192550 | 664.407 | 17.0500 | |
| 2007 | 1283.982570 | 713.583 | 14.8100 | |
| 2008 | 1344.133960 | 766.935 | 16.1200 | |
| 2009 | 1606.895580 | 651.721 | 19.2900 | |
| 2010 | 1590.167000 | 730.709 | 19.0000 | |
| 2011 | 1241.690880 | 866.199 | 15.6400 | |
| 2012 | 1166.888800 | 936.036 | 14.6300 | |
| 2013 | 1470.849660 | 969.237 | 18.3400 | |
| 2014 | 2754.801720 | 1102.332 | 33.6600 | |
| 2015 | 1961.830410 | 1182.964 | 24.2300 | |
| 2016 | 2651.568450 | 1118.034 | 33.0500 | |
| 2017 | 7782.072560 | 2425.453 | 43.7200 | |
| 2018 | 4333.199080 | 5344.066 | 25.0700 | |
| LAIDLAW INTERNATIONAL INC | 1994 | 2252.152500 | 2128.300 | 8.1250 |
| 1995 | 2495.700000 | 2517.400 | 9.0000 | |
| 1996 | 3020.517500 | 2296.000 | 9.6250 | |
| 1997 | 4808.232000 | 3030.700 | 14.6250 | |
| 1998 | 2946.057171 | 3690.200 | 8.9609 | |
| 1999 | 2063.812500 | 2262.500 | 6.2500 | |
| 2000 | 112.054046 | 2925.900 | 0.3438 | |
| 2001 | 30.572046 | 4418.300 | 0.0938 | |
| 2002 | 11.407480 | 4432.100 | 0.0350 | |
| 2003 | 1045.000000 | 4482.800 | 10.4500 | |
| 2004 | 1570.455300 | 4631.400 | 15.7000 | |
| 2005 | 2479.950000 | 3026.500 | 24.7500 | |
| 2006 | 2203.200000 | 3131.900 | 27.0000 | |
| LANDAIR CORP | 1994 | NaN | NaN | NaN |
| 1995 | NaN | NaN | NaN | |
| 1996 | NaN | NaN | NaN | |
| 1997 | NaN | NaN | NaN | |
| 1998 | 47.197500 | 110.353 | 7.5000 | |
| 1999 | 30.210000 | 131.855 | 5.0000 | |
| 2000 | 18.322500 | 127.487 | 3.7500 | |
| 2001 | 71.471400 | 106.906 | 14.7000 | |
| LANDSTAR SYSTEM INC | 1994 | 420.772000 | 984.359 | 32.7500 |
| 1995 | 341.811500 | 1204.667 | 26.7500 | |
| 1996 | 297.344250 | 1283.801 | 23.2500 | |
| 1997 | 316.130750 | 1312.704 | 26.3750 | |
| 1998 | 424.778000 | 1283.607 | 40.7500 | |
| 1999 | 391.948437 | 1388.083 | 42.8125 | |
| 2000 | 470.775250 | 1418.492 | 55.4375 | |
| 2001 | 586.388370 | 1392.771 | 72.5100 | |
| 2002 | 921.095880 | 1506.555 | 58.3600 | |
| 2003 | 1141.466280 | 1596.571 | 38.0400 | |
| 2004 | 2233.648480 | 2021.282 | 73.6400 | |
| 2005 | 2454.604180 | 2520.523 | 41.7400 | |
| 2006 | 2136.743700 | 2518.006 | 38.1800 | |
| 2007 | 2213.254350 | 2492.624 | 42.1500 | |
| 2008 | 1986.254550 | 2646.408 | 38.4300 | |
| 2009 | 1947.533410 | 2010.064 | 38.7700 | |
| 2010 | 1959.388400 | 2401.728 | 40.9400 | |
| 2011 | 2238.822400 | 2650.787 | 47.9200 | |
| 2012 | 2436.662080 | 2794.983 | 52.4600 | |
| 2013 | 2613.343050 | 2666.255 | 57.4500 | |
| 2014 | 3248.981350 | 3186.171 | 72.5300 | |
| 2015 | 2487.933000 | 3322.487 | 58.6500 | |
| 2016 | 3568.781400 | 3169.136 | 85.3000 | |
| 2017 | 4371.263100 | 3648.862 | 104.1000 | |
| 2018 | 3837.897720 | 4618.960 | 95.6700 | |
| LYFT INC | 2016 | NaN | NaN | NaN |
| 2017 | NaN | 1059.881 | NaN | |
| 2018 | NaN | 2156.616 | NaN | |
| M S CARRIERS INC | 1994 | 280.096500 | 292.883 | 21.7500 |
| 1995 | 249.280000 | 333.070 | 20.0000 | |
| 1996 | 192.160000 | 340.236 | 16.0000 | |
| 1997 | 303.723750 | 415.933 | 24.8750 | |
| 1998 | 403.813750 | 528.841 | 32.9375 | |
| 1999 | 293.710250 | 620.414 | 23.8750 | |
| 2000 | 365.784750 | 697.522 | 32.7500 | |
| MARTEN TRANSPORT LTD | 1994 | 58.600000 | 122.730 | 20.0000 |
| 1995 | 48.543000 | 137.704 | 16.5000 | |
| 1996 | 40.700000 | 146.151 | 13.7500 | |
| 1997 | 66.043125 | 172.412 | 22.1250 | |
| 1998 | 59.333500 | 193.648 | 13.2500 | |
| 1999 | 55.362500 | 219.200 | 12.8750 | |
| 2000 | 49.898750 | 260.797 | 11.9375 | |
| 2001 | 74.375400 | 282.764 | 17.7000 | |
| 2002 | 80.343480 | 293.096 | 18.9400 | |
| 2003 | 212.592000 | 334.667 | 15.4500 | |
| 2004 | 325.198110 | 380.048 | 22.7300 | |
| 2005 | 393.060060 | 460.202 | 18.2200 | |
| 2006 | 405.264300 | 518.890 | 18.6200 | |
| 2007 | 304.277400 | 560.017 | 13.9500 | |
| 2008 | 413.896800 | 607.099 | 18.9600 | |
| 2009 | 392.835750 | 505.874 | 17.9500 | |
| 2010 | 469.291000 | 516.920 | 21.3800 | |
| 2011 | 395.510150 | 603.679 | 17.9900 | |
| 2012 | 406.602900 | 638.456 | 18.3900 | |
| 2013 | 672.347190 | 659.214 | 20.1900 | |
| 2014 | 730.539340 | 672.929 | 21.8600 | |
| 2015 | 579.852000 | 664.994 | 17.7000 | |
| 2016 | 760.395500 | 671.144 | 23.3000 | |
| 2017 | 1107.019900 | 698.120 | 20.3000 | |
| 2018 | 881.820730 | 787.594 | 16.1900 | |
| MATLACK SYSTEMS INC | 1994 | 95.221500 | 217.880 | 10.8750 |
| 1995 | 85.800000 | 236.257 | 9.7500 | |
| 1996 | 64.619750 | 224.866 | 7.3750 | |
| 1997 | 70.224000 | 231.709 | 8.0000 | |
| 1998 | 61.663000 | 238.905 | 7.0000 | |
| 1999 | 44.620875 | 205.932 | 5.0625 | |
| 2000 | 11.017500 | 186.933 | 1.2500 | |
| MORGAN GROUP INC -CL A | 1994 | 18.289875 | 101.880 | 7.1250 |
| 1995 | 20.887250 | 122.303 | 8.3750 | |
| 1996 | 19.237500 | 132.208 | 7.5000 | |
| 1997 | 24.401500 | 146.154 | 9.2500 | |
| 1998 | 18.821000 | 150.454 | 7.3750 | |
| 1999 | 14.076000 | 145.629 | 5.7500 | |
| 2000 | 10.404000 | 108.024 | 4.2500 | |
| 2001 | 8.620000 | 101.168 | 2.5000 | |
| MOTOR CARGO INDUSTRIES INC | 1994 | NaN | NaN | NaN |
| 1995 | NaN | NaN | NaN | |
| 1996 | NaN | 92.310 | NaN | |
| 1997 | 83.880000 | 105.381 | 12.0000 | |
| 1998 | 55.904000 | 114.725 | 8.0000 | |
| 1999 | 32.028125 | 125.310 | 4.6250 | |
| 2000 | 43.699500 | 131.112 | 6.7500 | |
| MTL INC | 1994 | 50.805000 | 168.290 | 11.2500 |
| 1995 | 63.238000 | 190.054 | 14.0000 | |
| 1996 | 91.611000 | 235.599 | 20.2500 | |
| 1997 | 114.887500 | 286.047 | 25.2500 | |
| NEW CENTURY TRANSPORT -REDH | 2008 | NaN | 288.649 | NaN |
| 2009 | NaN | 229.313 | NaN | |
| NOUVEAU HOLDINGS LTD | 1995 | NaN | NaN | NaN |
| 1996 | 24.772774 | 0.000 | 2.7340 | |
| 1997 | 5.622000 | 9.896 | 0.5000 | |
| OLD DOMINION FREIGHT | 1994 | 135.915000 | 243.547 | 16.2500 |
| 1995 | 66.768000 | 248.079 | 8.0000 | |
| 1996 | 88.676250 | 293.006 | 10.6250 | |
| 1997 | 126.742750 | 328.844 | 15.2500 | |
| 1998 | 94.549000 | 383.078 | 11.3750 | |
| 1999 | 89.364750 | 426.385 | 10.7500 | |
| 2000 | 78.973500 | 475.803 | 9.5000 | |
| 2001 | 105.408840 | 502.239 | 12.6800 | |
| 2002 | 302.527452 | 566.459 | 28.4010 | |
| 2003 | 547.290720 | 667.531 | 34.0800 | |
| 2004 | 864.606000 | 824.051 | 34.8000 | |
| 2005 | 1005.203600 | 1061.403 | 26.9600 | |
| 2006 | 897.449950 | 1279.431 | 24.0700 | |
| 2007 | 861.656350 | 1399.542 | 23.1100 | |
| 2008 | 1061.131100 | 1537.724 | 28.4600 | |
| 2009 | 1144.649500 | 1245.005 | 30.7000 | |
| 2010 | 1789.104730 | 1480.998 | 31.9900 | |
| 2011 | 2328.164790 | 1882.541 | 40.5300 | |
| 2012 | 2953.736200 | 2110.483 | 34.2800 | |
| 2013 | 4568.468300 | 2337.648 | 53.0200 | |
| 2014 | 6684.338160 | 2787.897 | 77.6400 | |
| 2015 | 4986.216840 | 2972.442 | 59.0700 | |
| 2016 | 7070.554430 | 2991.517 | 85.7900 | |
| 2017 | 10836.562800 | 3358.112 | 131.5500 | |
| 2018 | 10031.216190 | 4043.695 | 123.4900 | |
| OLIVER TRANSPORTATION INC | 1994 | 11.850125 | 45.158 | 3.6250 |
| OTR EXPRESS INC | 1994 | 17.337500 | 42.760 | 9.5000 |
| 1995 | 8.235000 | 49.211 | 4.5000 | |
| 1996 | 6.426000 | 55.261 | 3.5000 | |
| 1997 | 10.768875 | 63.797 | 5.8750 | |
| 1998 | 9.180000 | 72.284 | 5.0000 | |
| 1999 | 2.785937 | 80.480 | 1.5625 | |
| 2000 | 0.891000 | 78.342 | 0.5000 | |
| OVERNITE CORP | 1998 | NaN | NaN | NaN |
| 1999 | NaN | NaN | NaN | |
| 2000 | NaN | NaN | NaN | |
| 2001 | NaN | 1161.913 | NaN | |
| 2002 | NaN | 1351.788 | NaN | |
| 2003 | 635.043500 | 1475.463 | 22.7500 | |
| 2004 | 1049.460440 | 1647.461 | 37.2400 | |
| P.A.M. TRANSPORTATION SVCS | 1994 | 29.628000 | 76.147 | 6.0000 |
| 1995 | 38.056375 | 91.595 | 7.6250 | |
| 1996 | 37.061688 | 113.021 | 4.5620 | |
| 1997 | 82.750000 | 127.211 | 10.0000 | |
| 1998 | 74.925000 | 143.164 | 9.0000 | |
| 1999 | 93.895000 | 207.381 | 11.1250 | |
| 2000 | 68.025111 | 205.245 | 8.0313 | |
| 2001 | 109.200160 | 225.794 | 12.6800 | |
| 2002 | 284.419220 | 264.012 | 25.2100 | |
| 2003 | 241.533484 | 293.547 | 21.3860 | |
| 2004 | 210.348830 | 325.066 | 18.6100 | |
| 2005 | 182.987940 | 360.880 | 17.7900 | |
| 2006 | 226.894080 | 400.269 | 22.0200 | |
| 2007 | 152.882520 | 408.841 | 15.5400 | |
| 2008 | 65.870000 | 406.723 | 7.0000 | |
| 2009 | 97.236290 | 291.910 | 10.3300 | |
| 2010 | 105.636300 | 331.994 | 11.2200 | |
| 2011 | 82.612000 | 359.243 | 9.5000 | |
| 2012 | 89.021460 | 380.633 | 10.2300 | |
| 2013 | 165.428480 | 402.813 | 20.7200 | |
| 2014 | 384.808320 | 410.937 | 51.8400 | |
| 2015 | 196.358030 | 417.050 | 27.5900 | |
| 2016 | 166.194060 | 432.852 | 25.9800 | |
| 2017 | 212.123230 | 437.838 | 34.4300 | |
| 2018 | 234.765370 | 533.261 | 39.4100 | |
| PATRIOT TRANSPORTATION HLDG | 2009 | NaN | NaN | NaN |
| 2010 | NaN | NaN | NaN | |
| 2011 | NaN | NaN | NaN | |
| 2012 | NaN | NaN | NaN | |
| 2013 | NaN | 112.120 | NaN | |
| 2014 | NaN | 129.162 | NaN | |
| 2015 | 78.715650 | 122.882 | 24.0500 | |
| 2016 | 68.180970 | 120.172 | 20.7300 | |
| 2017 | 65.881760 | 112.165 | 19.9400 | |
| 2018 | 63.997773 | 114.065 | 19.2301 | |
| POLAR EXPRESS CORP | 1994 | NaN | 21.821 | NaN |
| PROFESSIONAL TRANSN GRP INC | 1995 | NaN | NaN | NaN |
| 1996 | NaN | 21.172 | NaN | |
| 1997 | 14.621127 | 43.065 | 3.7810 | |
| 1998 | 9.670000 | 55.067 | 2.5000 | |
| 1999 | 9.035250 | 41.356 | 1.7500 | |
| PROVIDENCE SERVICE CORP | 2001 | NaN | 24.670 | NaN |
| 2002 | NaN | 32.827 | NaN | |
| 2003 | 136.290180 | 59.276 | 16.3300 | |
| 2004 | 195.953200 | 96.966 | 20.9800 | |
| 2005 | 278.543250 | 145.708 | 28.7900 | |
| 2006 | 302.163120 | 191.857 | 25.1300 | |
| 2007 | 341.732160 | 285.167 | 28.1400 | |
| 2008 | 18.622350 | 691.670 | 1.4500 | |
| 2009 | 203.851600 | 801.013 | 15.8000 | |
| 2010 | 208.283270 | 879.697 | 16.0700 | |
| 2011 | 178.852480 | 942.980 | 13.7600 | |
| 2012 | 218.440430 | 1105.889 | 16.9900 | |
| 2013 | 347.760120 | 1122.682 | 25.7200 | |
| 2014 | 577.792640 | 1481.171 | 36.4400 | |
| 2015 | 717.453720 | 1695.446 | 46.9200 | |
| 2016 | 526.497850 | 1578.889 | 38.0500 | |
| 2017 | 792.070320 | 1623.882 | 59.3400 | |
| 2018 | 769.156300 | 1384.965 | 60.0200 | |
| PST VANS INC | 1994 | NaN | 136.541 | NaN |
| 1995 | 19.466625 | 164.794 | 4.6250 | |
| 1996 | 11.596750 | 147.419 | 2.7500 | |
| 1997 | 17.358560 | 143.737 | 4.0940 | |
| QUALITY DISTRIBUTION INC | 2000 | NaN | 570.785 | NaN |
| 2001 | NaN | 523.337 | NaN | |
| 2002 | NaN | 516.538 | NaN | |
| 2003 | 370.067600 | 565.440 | 19.6000 | |
| 2004 | 160.871100 | 622.015 | 8.4500 | |
| 2005 | 151.669100 | 678.076 | 7.9700 | |
| 2006 | 253.586160 | 730.159 | 13.3200 | |
| 2007 | 85.141440 | 751.558 | 4.4400 | |
| 2008 | 58.647000 | 815.290 | 3.0000 | |
| 2009 | 79.705690 | 613.609 | 3.9700 | |
| 2010 | 195.053220 | 686.598 | 9.0900 | |
| 2011 | 269.325000 | 745.951 | 11.2500 | |
| 2012 | 163.338000 | 842.118 | 6.0000 | |
| 2013 | 349.014490 | 929.810 | 12.8300 | |
| 2014 | 298.207280 | 991.758 | 10.6400 | |
| ROADWAY CORP | 1994 | NaN | 2171.117 | NaN |
| 1995 | NaN | 2288.844 | NaN | |
| 1996 | 398.059375 | 2372.718 | 19.3750 | |
| 1997 | 451.239375 | 2670.944 | 22.1250 | |
| 1998 | 279.957562 | 2654.094 | 14.4375 | |
| 1999 | 419.308750 | 2813.214 | 21.6250 | |
| 2000 | 410.846812 | 3039.560 | 21.1875 | |
| 2001 | 711.135900 | 2791.748 | 36.7000 | |
| 2002 | 712.972890 | 3010.776 | 36.8100 | |
| SAIA INC | 2000 | NaN | 789.009 | NaN |
| 2001 | NaN | 771.582 | NaN | |
| 2002 | 145.231050 | 775.436 | 9.9100 | |
| 2003 | 258.654540 | 827.359 | 17.5800 | |
| 2004 | 369.923730 | 982.270 | 23.3700 | |
| 2005 | 305.851250 | 1098.031 | 21.2500 | |
| 2006 | 334.804250 | 874.738 | 23.2100 | |
| 2007 | 178.871700 | 976.123 | 13.3000 | |
| 2008 | 146.729460 | 1030.421 | 10.8600 | |
| 2009 | 235.148940 | 849.141 | 14.8200 | |
| 2010 | 263.781000 | 902.660 | 16.5900 | |
| 2011 | 198.906240 | 1030.224 | 12.4800 | |
| 2012 | 371.284080 | 1098.679 | 23.1200 | |
| 2013 | 784.551950 | 1139.094 | 32.0500 | |
| 2014 | 1376.913920 | 1272.321 | 55.3600 | |
| 2015 | 559.409500 | 1221.311 | 22.2500 | |
| 2016 | 1118.010450 | 1218.481 | 44.1500 | |
| 2017 | 1807.804000 | 1378.510 | 70.7500 | |
| 2018 | 1434.239080 | 1653.849 | 55.8200 | |
| SIMON TRNSPT SVCS INC -CL A | 1994 | NaN | NaN | NaN |
| 1995 | NaN | 75.218 | NaN | |
| 1996 | 65.662092 | 101.090 | 13.8440 | |
| 1997 | 148.435875 | 155.296 | 23.6250 | |
| 1998 | 31.800625 | 193.507 | 5.1250 | |
| 1999 | 29.022500 | 209.143 | 4.7500 | |
| 2000 | 36.666000 | 231.397 | 6.0000 | |
| 2001 | 9.784000 | 278.818 | 1.6000 | |
| SIRVA INC -REDH | 2001 | NaN | 2249.303 | NaN |
| 2002 | NaN | 2185.646 | NaN | |
| 2003 | 1376.299900 | 2349.859 | 19.5400 | |
| 2004 | 1415.956620 | 3475.942 | 19.2200 | |
| 2005 | 591.544000 | 3681.200 | 8.0000 | |
| 2006 | 257.398200 | 3865.300 | 3.4800 | |
| 2007 | 7.585900 | 3969.900 | 0.1000 | |
| 2008 | NaN | NaN | 0.0003 | |
| 2009 | NaN | NaN | NaN | |
| 2010 | NaN | NaN | NaN | |
| 2011 | NaN | NaN | NaN | |
| 2012 | NaN | NaN | NaN | |
| 2013 | NaN | 1464.500 | NaN | |
| SMART MOVE INC | 2005 | NaN | 1.238 | NaN |
| 2006 | 48.108830 | 4.185 | 4.7300 | |
| 2007 | 6.148800 | 5.811 | 0.5600 | |
| SMITHWAY MTR XPRESS -CL A | 1995 | NaN | 77.339 | NaN |
| 1996 | NaN | 93.667 | 8.1250 | |
| 1997 | 64.857000 | 120.117 | 13.0000 | |
| 1998 | 37.515000 | 161.375 | 7.5000 | |
| 1999 | 20.773500 | 196.945 | 4.1250 | |
| 2000 | 8.295750 | 198.990 | 1.6875 | |
| 2001 | 8.961400 | 190.826 | 1.8500 | |
| 2002 | 3.732190 | 169.468 | 0.7700 | |
| 2003 | 9.451650 | 165.329 | 1.9500 | |
| 2004 | 35.282299 | 189.001 | 7.1990 | |
| 2005 | 44.350240 | 220.386 | 8.9200 | |
| 2006 | 49.910000 | 228.762 | 10.0000 | |
| SWIFT TRANSPORTATION CO INC | 1994 | 501.717000 | 365.889 | 20.5000 |
| 1995 | 376.019250 | 458.165 | 15.2500 | |
| 1996 | 655.979000 | 562.259 | 23.5000 | |
| 1997 | 916.471500 | 713.638 | 32.3750 | |
| 1998 | 1190.797655 | 873.433 | 28.0313 | |
| 1999 | 1127.224500 | 1061.234 | 17.6250 | |
| 2000 | 1252.764187 | 1258.671 | 19.8125 | |
| 2001 | 1847.536920 | 2112.221 | 21.5100 | |
| 2002 | 1680.411010 | 2101.472 | 20.0180 | |
| 2003 | 1764.460840 | 2397.655 | 21.0200 | |
| 2004 | 1544.369040 | 2826.201 | 21.4800 | |
| 2005 | 1494.892000 | 3197.455 | 20.3000 | |
| 2006 | 1972.588030 | 3172.790 | 26.2700 | |
| TRAILER BRIDGE INC | 1995 | NaN | 62.531 | NaN |
| 1996 | NaN | 63.148 | NaN | |
| 1997 | 86.779750 | 66.389 | 8.8750 | |
| 1998 | 14.973051 | 77.241 | 1.5313 | |
| 1999 | 12.222500 | 88.552 | 1.2500 | |
| 2000 | 16.500375 | 91.706 | 1.6875 | |
| 2001 | 13.004740 | 81.568 | 1.3300 | |
| 2002 | 20.924920 | 73.810 | 2.1400 | |
| 2003 | 53.992377 | 86.434 | 5.5190 | |
| 2004 | 111.974240 | 98.775 | 9.5200 | |
| 2005 | 108.928000 | 105.859 | 9.2500 | |
| 2006 | 101.376800 | 110.250 | 8.6000 | |
| 2007 | 140.081680 | 116.153 | 11.7400 | |
| 2008 | 43.567520 | 133.030 | 3.6800 | |
| 2009 | 57.566400 | 114.302 | 4.8000 | |
| 2010 | 33.166920 | 118.186 | 2.7600 | |
| TRANSPORT CORP AMERICA INC | 1994 | 60.135000 | 127.425 | 9.5000 |
| 1995 | 73.841500 | 144.254 | 11.5000 | |
| 1996 | 69.832000 | 164.666 | 10.7500 | |
| 1997 | 103.808250 | 186.392 | 15.7500 | |
| 1998 | 80.256000 | 245.913 | 12.0000 | |
| 1999 | 88.480375 | 285.585 | 12.4375 | |
| 2000 | 31.403750 | 290.611 | 4.3750 | |
| 2001 | 39.622000 | 274.589 | 5.5000 | |
| 2002 | 35.378000 | 273.227 | 4.9000 | |
| 2003 | 51.779500 | 258.859 | 7.2500 | |
| 2004 | 54.826800 | 258.408 | 8.4000 | |
| 2005 | NaN | 254.395 | 9.8800 | |
| TRISM INC | 1994 | 39.683250 | 225.191 | 6.7500 |
| 1995 | 34.398000 | 268.444 | 6.0000 | |
| 1996 | 22.230875 | 310.033 | 3.8750 | |
| 1997 | 18.645250 | 309.880 | 3.2500 | |
| 1998 | 5.702000 | 291.631 | 1.0000 | |
| 1999 | 0.855300 | 274.646 | 0.1500 | |
| 2000 | 1.250000 | 281.385 | 0.6250 | |
| U S ENVIRONMENTAL SOLUTIONS | 1994 | 3.988544 | 3.321 | 0.8120 |
| 1995 | 4.704206 | 5.832 | 0.7340 | |
| U S TRANSPORTATION SYS | 1994 | 5.037771 | 11.818 | 0.6870 |
| 1995 | 11.302848 | 17.351 | 0.8440 | |
| 1996 | 11.053250 | 21.510 | 1.6250 | |
| UBER TECHNOLOGIES INC | 2014 | NaN | NaN | NaN |
| 2015 | NaN | NaN | NaN | |
| 2016 | NaN | NaN | NaN | |
| 2017 | NaN | 7932.000 | NaN | |
| 2018 | NaN | 11270.000 | NaN | |
| US 1 INDUSTRIES INC | 1994 | 8.351000 | 20.694 | 0.8750 |
| 1995 | 6.752523 | 14.904 | 0.6870 | |
| 1996 | 3.299088 | 15.412 | 0.3120 | |
| 1997 | 2.484612 | 25.422 | 0.2340 | |
| 1998 | 0.743260 | 30.177 | 0.0700 | |
| 1999 | 0.743260 | 32.334 | 0.0700 | |
| 2000 | 1.061800 | 49.055 | 0.1000 | |
| 2001 | 7.432600 | 72.110 | 0.7000 | |
| 2002 | 6.041360 | 110.387 | 0.5200 | |
| 2003 | 12.779800 | 121.747 | 1.1000 | |
| 2004 | 11.734180 | 143.313 | 1.0100 | |
| 2005 | 15.863760 | 166.648 | 1.3200 | |
| 2006 | 18.133300 | 190.976 | 1.4900 | |
| 2007 | 24.927000 | 184.677 | 1.7500 | |
| 2008 | 13.104480 | 172.675 | 0.9200 | |
| 2009 | 13.674240 | 179.732 | 0.9600 | |
| 2010 | 16.380600 | 210.751 | 1.1500 | |
| US XPRESS ENTP INC -CL A | 1994 | 109.335750 | 254.331 | 9.1250 |
| 1995 | 89.053125 | 299.697 | 7.3750 | |
| 1996 | 169.204000 | 362.819 | 14.0000 | |
| 1997 | 332.317500 | 342.272 | 22.1250 | |
| 1998 | 223.860000 | 581.401 | 15.0000 | |
| 1999 | 107.003875 | 708.212 | 7.3750 | |
| 2000 | 76.239625 | 787.085 | 5.5625 | |
| 2001 | 124.991760 | 798.032 | 9.0600 | |
| 2002 | 121.807800 | 862.345 | 8.7600 | |
| 2003 | 172.149250 | 930.509 | 12.2500 | |
| 2004 | 474.337700 | 1105.656 | 29.3000 | |
| 2005 | 266.924790 | 1164.232 | 17.3700 | |
| 2006 | 252.254520 | 1471.764 | 16.4700 | |
| USA TRUCK INC | 1994 | 145.350000 | 92.511 | 15.0000 |
| 1995 | 102.802250 | 102.400 | 10.7500 | |
| 1996 | 74.840000 | 108.313 | 8.0000 | |
| 1997 | 110.156250 | 129.507 | 11.7500 | |
| 1998 | 109.158750 | 145.216 | 11.6250 | |
| 1999 | 72.961875 | 166.363 | 7.8750 | |
| 2000 | 50.726500 | 226.585 | 5.5000 | |
| 2001 | 101.331300 | 252.441 | 10.9500 | |
| 2002 | 65.708269 | 273.773 | 7.0510 | |
| 2003 | 92.294037 | 298.663 | 9.8890 | |
| 2004 | 158.695000 | 363.105 | 17.0000 | |
| 2005 | 332.431560 | 439.703 | 29.1300 | |
| 2006 | 180.450150 | 465.618 | 16.0500 | |
| 2007 | 161.114800 | 482.109 | 15.4000 | |
| 2008 | 143.567690 | 535.620 | 13.7900 | |
| 2009 | 131.472520 | 382.368 | 12.5200 | |
| 2010 | 138.862080 | 460.161 | 13.2300 | |
| 2011 | 80.732120 | 519.408 | 7.7300 | |
| 2012 | 35.993850 | 512.428 | 3.4500 | |
| 2013 | 140.824500 | 555.005 | 13.3800 | |
| 2014 | 299.137200 | 602.477 | 28.4000 | |
| 2015 | 168.567000 | 507.934 | 17.4500 | |
| 2016 | 72.353970 | 429.099 | 8.7100 | |
| 2017 | 150.279570 | 446.533 | 18.1300 | |
| 2018 | 125.179140 | 534.060 | 14.9700 | |
| USF CORP | 1994 | 561.776875 | 1016.464 | 25.6250 |
| 1995 | 441.140000 | 1144.458 | 20.1250 | |
| 1996 | 596.754750 | 1330.972 | 27.4370 | |
| 1997 | 832.520000 | 1565.249 | 32.5000 | |
| 1998 | 758.240250 | 1834.893 | 29.1250 | |
| 1999 | 1266.485250 | 2222.442 | 47.8750 | |
| 2000 | 778.481384 | 2538.699 | 30.0781 | |
| 2001 | 837.689200 | 2458.647 | 31.4000 | |
| 2002 | 776.106250 | 2250.526 | 28.7500 | |
| 2003 | 938.618070 | 2292.139 | 34.1900 | |
| 2004 | 1074.174750 | 2394.579 | 37.9500 | |
| WERNER ENTERPRISES INC | 1994 | 598.666250 | 516.006 | 23.7500 |
| 1995 | 509.915250 | 576.022 | 20.2500 | |
| 1996 | 688.532500 | 643.274 | 18.1250 | |
| 1997 | 783.633000 | 772.095 | 20.5000 | |
| 1998 | 836.777938 | 863.417 | 17.6875 | |
| 1999 | 663.820312 | 1052.333 | 14.0625 | |
| 2000 | 799.663000 | 1214.628 | 17.0000 | |
| 2001 | 1159.790400 | 1270.519 | 24.3000 | |
| 2002 | 1373.204930 | 1341.456 | 21.5300 | |
| 2003 | 1553.625860 | 1457.766 | 19.4900 | |
| 2004 | 1793.042720 | 1678.043 | 22.6400 | |
| 2005 | 1564.574000 | 1971.847 | 19.7000 | |
| 2006 | 1316.925720 | 2080.555 | 17.4800 | |
| 2007 | 1198.452190 | 2071.187 | 17.0300 | |
| 2008 | 1241.127840 | 2165.599 | 17.3400 | |
| 2009 | 1423.560600 | 1666.470 | 19.8000 | |
| 2010 | 1641.777000 | 1815.020 | 22.6000 | |
| 2011 | 1755.636800 | 2002.850 | 24.1000 | |
| 2012 | 1587.262490 | 2036.386 | 21.6700 | |
| 2013 | 1798.217220 | 2029.183 | 24.7300 | |
| 2014 | 2243.983700 | 2139.289 | 31.1500 | |
| 2015 | 1684.056610 | 2093.529 | 23.3900 | |
| 2016 | 1944.900650 | 2008.991 | 26.9500 | |
| 2017 | 2798.607850 | 2116.737 | 38.6500 | |
| 2018 | 2080.856680 | 2457.914 | 29.5400 | |
| WESTERN EXPRESS HLDGS -REDH | 2003 | NaN | 198.176 | NaN |
| 2004 | NaN | 225.484 | NaN | |
| WORLDWAY CORP | 1994 | 63.159250 | 935.940 | 9.6250 |
| YRC WORLDWIDE INC | 1994 | 671.030750 | 2867.492 | 23.8750 |
| 1995 | 347.811750 | 3056.640 | 12.3750 | |
| 1996 | 404.110000 | 3072.550 | 14.3750 | |
| 1997 | 706.439625 | 3348.868 | 25.1250 | |
| 1998 | 491.091750 | 2900.577 | 19.1250 | |
| 1999 | 418.698500 | 3226.847 | 16.8125 | |
| 2000 | 484.472282 | 3588.140 | 20.3594 | |
| 2001 | 624.111500 | 3276.651 | 25.1000 | |
| 2002 | 745.174971 | 2624.148 | 25.1910 | |
| 2003 | 1728.455790 | 3068.616 | 36.1700 | |
| 2004 | 2742.993270 | 6767.485 | 55.7100 | |
| 2005 | 2555.796120 | 8741.557 | 44.6100 | |
| 2006 | 2158.042810 | 9914.690 | 37.7300 | |
| 2007 | 969.208080 | 9621.316 | 17.0900 | |
| 2008 | 170.288580 | 8940.401 | 2.8700 | |
| 2009 | 80.656911 | 5282.778 | 0.8398 | |
| 2010 | 176.926920 | 4334.640 | 3.7200 | |
| 2011 | 68.254620 | 4868.844 | 9.9700 | |
| 2012 | 53.838000 | 4850.500 | 6.7500 | |
| 2013 | 176.705010 | 4865.400 | 17.3700 | |
| 2014 | 689.700830 | 5068.800 | 22.4900 | |
| 2015 | 455.759380 | 4832.400 | 14.1800 | |
| 2016 | 431.241440 | 4697.500 | 13.2800 | |
| 2017 | 470.700540 | 4891.000 | 14.3800 | |
| 2018 | 104.233500 | 5092.000 | 3.1500 |
In [ ]:
In [ ]:
In [ ]: