what works · what's broken · what's on the way

Volume of Trading on New York Stock Exchange: 1970 to 2006 (Statistical Abstract 2008 Table 1179)

Photo of a Chacma Baboon

Size: 5.8 KB (approx) Downloaded: 0 times
Available in: csv, yaml, and xls Category: demographics/us

Tags

About

The Statistical Abstract of the United States is the standard summary of statistics on the social, political, and economic organization of the United States. It is also designed to serve as a guide to other statistical publications and sources. The latter function is served by the introductory text to each section, the source note appearing below each table, and Appendix I, which comprises the Guide to Sources of Statistics, the Guide to State Statistical Abstracts, and the Guide to Foreign Statistical Abstracts. This volume includes a selection of data from many statistical sources, both government and private. Publications cited as sources usually contain additional statistical detail and more comprehensive discussions of definitions and concepts. Data not available in publications issued by the contributing agency but obtained from the Internet or unpublished records are identified in the source notes. More information on the subjects covered in the tables so noted may generally be obtained from the source.

Although emphasis in the Statistical Abstract is primarily given to national data, many tables present data for regions and individual states and a smaller number for metropolitan areas and cities. Appendix II, Metropolitan and Micropolitan Statistical Areas: Concepts, Components, and Population, presents explanatory text, a complete current listing and population data for metropolitan and micropolitan areas defined as of December 2005. Statistics for the Commonwealth of Puerto Rico and for island areas of the United States are included in many state tables and are supplemented by information in Section 29. Additional information for states, cities, counties, metropolitan areas, and other small units, as well as more historical data are available in various supplements to the Abstract.

Fields

nametypeunitstags

Credits

US Census Bureau source http://www.census.gov/statab/www

U.S. Census Bureau, Statistical Abstract of the United States: 2008 (127th Edition) Washington, DC, 2007; http://www.census.gov/statab/www/
Philip (flip) Kromer converted http://infochimp.org/flip
New York Stock Exchange, Inc., New York, NY, http://www.nysedata.com/factbook

New York Stock Exchange, Inc., New York, NY,

“Facts & Figures”;

< http://www.nysedata.com/factbook >

(copyright).

referenced on dataset section Data (#1)
New York Stock Exchange, Inc., New York, NY, http://www.nyse.com/

New York Stock Exchange, Inc., New York, NY,

“Facts & Figures”;

< http://www.nysedata.com/factbook >

(copyright).

For more information:

http://www.nyse.com/

referenced on dataset section Notes (#2)

Usage Notes

[none]

Rights Info

All US Census Bureau materials, regardless of the media, are entirely in the public domain. There are no user fees, site licenses, or any special agreements etc for the public or private use, and or reuse of any census title. As tax funded product, it’s all in the public record. Some of our products, however, are special cases. [...] The Statistical Abstract has some data covered by copyright law. Check the table’s footnotes to determine if the data are covered by copyright law.

File structure

The Statistical Abstract files are distributed by the census department as excel files. These files have data mixed with notes and references, multiple tables per sheet, and worst of all the table headers aren’t easily matched to their rows and columns. The excel files in this collection are unmolested copies of the census originals, with the following exceptions:

  1. A few files had extraneous characters in the title. These were corrected to be consistent. A few files have a sheet of crufty gibberish in the first slot. The sheet order was shuffled but no data were changed.

    The tables that were changed:

    0166 0257 0362 0429 0445 0446 0459 0461 0462 0464 0465 0466 0467 0469 0479 0480 0481 0482 0483 0484 0485 0486 0487 0559 0628 0629 1144 1227 1231

  1. The first four files have been restructured to allow full comprehension of the table. If you’d like to help clean up the data follow along with what’s there.

The CSV files, and the payload portions of the yaml files, have not been processed beyond extracting an array (excel sheets) of 2-D arrays (each sheet’s cells).

Some metadata (title, footnotes, symbols, and sources) has been copied (without molesting the imported stream) into the appropriate slot in this schema. This metadata identification was purposefully done to be strict and simple, and the original files are somewhat irregular, so it’s possible that some metadata fields were missed

These files have been tagged by hand and received cursory inspection, but you’re advised to check against the originals before you go lauching any Mars rovers.

Footnotes

Notes (pg 2)

  1. Beginning 2005 reflects trades of NYSE Group.
  2. Excludes odd lot statistics for February which were not available.
  3. Par value.

Headnotes

[3,124 represents 3,124,000,000. Round lot: A unit of trading or a multiple thereof. On the NYSE the unit of trading is generally 100 shares in stocks. For some inactive stocks, the unit of trading is 10 shares. Odd lot: An amount of stock less than the established 100-share unit or 10-share unit of trading]

Shape

table: [20, 33]

Snippet

Shares traded Million 3124 4839 11561.5 12049.4 16669.3 21845.7 23308.6 27774 36009.2 48142.8 41117.7 42022.2 39946.3 45598.8 51825.7 67461 74003.2 87873.4 105477.1 134403.5 171188 206299 265499 311290 369069 356767.304 372717.813 410832.268905 523811.068905 597724.2
Round lots 1 Million 2937 4693 11352.3 11853.7 16458 21589.6 23071 27510.7 35680 47801.3 40849.5 41698.5 39664.5 45266 51375.7 66923.3 73420.4 87217.5 104636.2 133312.1 169745 203914 262478 307509.3 363135.9 352397.8 367098.5 403764 516742.8 588126.8
Average daily shares Million 11.6 18.6 44.871 46.853 65.052 85.334 91.19 109.169 141.028 188.938 161.461 165.47 156.777 178.917 202.266 264.519 291.351 346.101 411.953 526.925 674 809 1041.6 1240 1441 1398.4 1456.7 1602.2 2050.56666667 2343.13466135
High day Million 21.3 35.2 84.297 92.881 149.385 129.411 236.565 181.027 244.293 608.149 343.949 416.396 292.364 317.362 389.036 379.483 482.754 652.829 680.913 1201.347 1216 1350 1560.8 2368 2813 1886.1 2690.2 3115.805723 3628.16397 3853
Low day Million 6.7 8.7 16.132 23.945 36.76 53.033 46.364 62.055 48.865 86.366 72.088 68.869 56.853 69.644 95.14 89.851 113.811 117.723 130.303 154.797 247 312 403.3 413.8 462 359.76902 508.8 545.22402 693.777799 797.462964
Odd lots Million 186 146 209.2 195.7 211.3 256.2 237.5 263.3 329.2 341.5 268.2 323.7 281.7 332.8 450.1 537.8 582.8 655.9 840.9 1091.4 1443 2384 3020.989 3781.036 5933.184 4369.504 5619.313 7068.268905 7068.268905 9597.4
Value of shares traded Billion dollars 102.5 131.7 382.447 396.07 495.13 775.337 773.426 980.772 1388.819 1888.707 1365.892 1556.008 1336.229 1533.578 1764.59 2305.166 2476.592 3110.162 4102.061 5833.4694 7395 9073 11205 10644.5 10491 9846.509 11841.142 14441.415983 18174.115983 22247.3
Round lots 1 Billion dollars 95.3 126.7 374.9091 389.2184 488.3967 765.2753 764.7374 970.4785 1374.3496 1873.597 1356.0495 1542.8455 1325.3326 1520.1641 1745.466 2283.39 2454.242 3082.916 4063.655 5777.6015 7318 8945 11060 10489.3 10278 9692.3 11618.2 14125 17857.7 21789.6
Odd lots Billion dollars 7.2 5 7.5379 6.8516 6.7333 10.0617 8.6886 10.2935 14.4694 15.11 9.8425 13.1625 10.8964 2 13.4139 19.124 21.776 22.35 27.246 38.406 55.8679 77 128 144.802 155.195 213.349 154.209 222.942 316.415983 316.415983 457.7
33=. ... snip ...
(copyright).

Symbols

Notes (pg 2)

  • (NA) Not available.

Tablenum

1179

Year

2008

History

Uploaded by (admin) Modified by (admin)