PREVIEW / stock_daily / 2009-12-29
file: by_date/stock_daily/2009/2009-12-29.parquet size: 189 KB rows: 5,932 symbols: 3,520
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2009-12-29 | AAPL | Stock | 7.5939 | 7.5971 | 7.4546 | 7.4679 | 445205600.0 |
| 2009-12-29 | MSFT | Stock | 31.35 | 31.5 | 31.23 | 31.39 | 29716200.0 |
| 2009-12-29 | NVDA | Stock | 0.4435 | 0.4518 | 0.4425 | 0.4505 | 475848000.0 |
| 2009-12-29 | AMZN | Stock | 7.0645 | 7.129 | 6.9275 | 6.9705 | 168012000.0 |
| 2009-12-29 | TLT | Stock | 89.26 | 89.89 | 89.2 | 89.73 | 2616955.0 |
| 2009-12-29 | ES | Stock | 26.39 | 26.43 | 26.25 | 26.33 | 662000.0 |
| 2009-12-29 | CL | Stock | 41.45 | 41.68 | 41.39 | 41.43 | 3511200.0 |
| 2009-12-29 | A | Stock | 21.7525 | 21.7954 | 21.6166 | 21.6953 | 4343866.0 |
| 2009-12-29 | AABA-DELISTED | Stock | 16.84 | 16.97 | 16.68 | 16.92 | 11662840.0 |
| 2009-12-29 | AACC-DELISTED | Stock | 6.53 | 6.7491 | 6.42 | 6.68 | 11438.0 |
| 2009-12-29 | AACG | Stock | 4.4 | 4.65 | 4.4 | 4.5 | 6700.0 |
| 2009-12-29 | AAI-DELISTED | Stock | 5.18 | 5.29 | 5.1 | 5.17 | 2319148.0 |
| 2009-12-29 | AAIC-DELISTED | Stock | 15.9 | 15.9 | 15.28 | 15.43 | 22697.0 |
| 2009-12-29 | AAME | Stock | 1.26 | 1.36 | 1.25 | 1.25 | 3700.0 |
| 2009-12-29 | AAON | Stock | 3.8775 | 3.9506 | 3.8519 | 3.9407 | 298687.0 |
| 2009-12-29 | AAP | Stock | 41.44 | 41.48 | 40.75 | 40.76 | 1150100.0 |
| 2009-12-29 | AATI-DELISTED | Stock | 3.63 | 3.76 | 3.5 | 3.74 | 501712.0 |
| 2009-12-29 | AAU-DELISTED | Stock | 1.06 | 1.1 | 1.06 | 1.06 | 183294.0 |
| 2009-12-29 | AAUAF-DELISTED | Stock | 1.06 | 1.1 | 1.06 | 1.06 | 185694.0 |
| 2009-12-29 | AAV-DELISTED | Stock | 6.57 | 6.73 | 6.57 | 6.64 | 753641.0 |
| 2009-12-29 | AAWW-DELISTED | Stock | 37.85 | 38.26 | 37.49 | 38.18 | 110605.0 |
| 2009-12-29 | AAXJ | Stock | 55.88 | 55.88 | 55.3101 | 55.53 | 212968.0 |
| 2009-12-29 | AAXN-DELISTED | Stock | 4.34 | 4.49 | 4.33 | 4.35 | 597807.0 |
| 2009-12-29 | AB | Stock | 26.78 | 27.66 | 26.69 | 27.63 | 372300.0 |
| 2009-12-29 | ABAX-DELISTED | Stock | 24.87 | 25.369 | 24.65 | 25.21 | 112755.0 |
| 2009-12-29 | ABB-DELISTED | Stock | 19.32 | 19.402 | 19.15 | 19.25 | 1756258.0 |
| 2009-12-29 | ABBC-DELISTED | Stock | 6.82 | 6.91 | 6.74 | 6.75 | 18619.0 |
| 2009-12-29 | ABBNY-DELISTED | Stock | 19.31 | 19.402 | 19.15 | 19.24 | 1773028.0 |
| 2009-12-29 | ABC-DELISTED | Stock | 26.41 | 26.56 | 26.36 | 26.38 | 1444835.0 |
| 2009-12-29 | ABCB | Stock | 6.8642 | 7.0914 | 6.6668 | 6.9631 | 42930.0 |
| 2009-12-29 | ABCD-DELISTED | Stock | 3.86 | 4.0 | 3.7 | 3.97 | 66156.0 |
| 2009-12-29 | ABCO-DELISTED | Stock | 14.915 | 15.0 | 14.79 | 15.0 | 89292.0 |
| 2009-12-29 | ABCW-DELISTED | Stock | 0.64 | 0.7 | 0.62 | 0.66 | 166030.0 |
| 2009-12-29 | ABD-DELISTED | Stock | 7.55 | 7.6 | 7.39 | 7.51 | 132510.0 |
| 2009-12-29 | ABE-DELISTED | Stock | 16.61 | 16.73 | 16.49 | 16.71 | 10165.0 |
| 2009-12-29 | ABEO | Stock | 3875.0 | 4125.0 | 3875.0 | 4062.5 | 11.0 |
| 2009-12-29 | ABFS-DELISTED | Stock | 30.96 | 33.54 | 30.835 | 33.43 | 826963.0 |
| 2009-12-29 | ABG | Stock | 11.92 | 11.93 | 11.75 | 11.78 | 122500.0 |
| 2009-12-29 | ABII-DELISTED | Stock | 39.53 | 39.54 | 37.27 | 37.27 | 70368.0 |
| 2009-12-29 | ABK-DELISTED | Stock | 0.86 | 0.87 | 0.83 | 0.84 | 5759960.0 |
| 2009-12-29 | ABM | Stock | 21.4 | 21.65 | 21.03 | 21.09 | 104900.0 |
| 2009-12-29 | ABMD-DELISTED | Stock | 8.8 | 8.84 | 8.7 | 8.84 | 105522.0 |
| 2009-12-29 | ABR | Stock | 1.9 | 1.96 | 1.87 | 1.95 | 152700.0 |
| 2009-12-29 | ABT | Stock | 26.2115 | 26.3554 | 26.0148 | 26.0339 | 9280325.0 |
| 2009-12-29 | ABTL-DELISTED | Stock | 5.1169 | 5.1737 | 4.5628 | 4.6 | 18258.0 |
| 2009-12-29 | ABV-DELISTED | Stock | 99.16 | 102.15 | 98.88 | 101.07 | 445506.0 |
| 2009-12-29 | ABVA-DELISTED | Stock | 3.74 | 3.74 | 3.74 | 3.74 | 1500.0 |
| 2009-12-29 | ABVT-DELISTED | Stock | 64.85 | 65.22 | 64.48 | 65.07 | 55600.0 |
| 2009-12-29 | ABX-DELISTED | Stock | 40.64 | 40.89 | 39.67 | 39.72 | 9747449.0 |
| 2009-12-29 | ACAD | Stock | 1.33 | 1.35 | 1.32 | 1.35 | 312900.0 |
> showing 50 of 5,932 rows — these rows as CSV