PREVIEW / stock_daily / 2006-12-22
file: by_date/stock_daily/2006/2006-12-22.parquet size: 154 KB rows: 4,632 symbols: 2,934
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-22 | AAPL | Stock | 2.9807 | 3.0014 | 2.9143 | 2.9357 | 613303600.0 |
| 2006-12-22 | MSFT | Stock | 29.83 | 29.86 | 29.62 | 29.64 | 37971700.0 |
| 2006-12-22 | NVDA | Stock | 0.6312 | 0.6333 | 0.6142 | 0.6172 | 370170000.0 |
| 2006-12-22 | AMZN | Stock | 1.999 | 2.0255 | 1.9955 | 2.012 | 111702000.0 |
| 2006-12-22 | CL | Stock | 32.26 | 32.4 | 32.08 | 32.295 | 2563800.0 |
| 2006-12-22 | A | Stock | 24.3777 | 24.5994 | 24.0773 | 24.1202 | 2403022.0 |
| 2006-12-22 | AABA-DELISTED | Stock | 25.6700000762939 | 25.8799991607666 | 25.4500007629395 | 25.5499992370605 | 14666100.0 |
| 2006-12-22 | AACC-DELISTED | Stock | 16.04 | 16.2 | 16.0 | 16.03 | 92797.0 |
| 2006-12-22 | AACQ-DELISTED | Stock | 5.41 | 5.41 | 5.39 | 5.39 | 7500.0 |
| 2006-12-22 | AACQU-DELISTED | Stock | 6.5 | 6.5 | 6.5 | 6.5 | 500.0 |
| 2006-12-22 | AACQW-DELISTED | Stock | 0.55 | 0.55 | 0.5 | 0.5 | 24000.0 |
| 2006-12-22 | AAI-DELISTED | Stock | 11.65 | 11.869 | 11.58 | 11.69 | 1723000.0 |
| 2006-12-22 | AAIC-DELISTED | Stock | 161.8 | 164.0 | 159.6 | 160.8 | 1366700.0 |
| 2006-12-22 | AAME | Stock | 2.87 | 3.01 | 2.87 | 2.97 | 34100.0 |
| 2006-12-22 | AAON | Stock | 3.3343 | 3.3975 | 3.2961 | 3.3817 | 72900.0 |
| 2006-12-22 | AAP | Stock | 35.6 | 35.93 | 35.57 | 35.86 | 349000.0 |
| 2006-12-22 | AATI-DELISTED | Stock | 5.28 | 5.35 | 5.22 | 5.29 | 214255.0 |
| 2006-12-22 | AAU-DELISTED | Stock | 2.42 | 2.44 | 1.9063 | 2.43 | 26000.0 |
| 2006-12-22 | AAUAF-DELISTED | Stock | 2.42 | 2.44 | 1.9063 | 2.43 | 26000.0 |
| 2006-12-22 | AAV-DELISTED | Stock | 11.21 | 11.3 | 11.16 | 11.29 | 547200.0 |
| 2006-12-22 | AAWW-DELISTED | Stock | 45.04 | 46.12 | 44.74 | 45.0 | 62620.0 |
| 2006-12-22 | AAXN-DELISTED | Stock | 7.53999996185303 | 7.61999988555908 | 7.5 | 7.53000020980835 | 546000.0 |
| 2006-12-22 | AB | Stock | 79.75 | 80.0 | 79.11 | 79.9 | 225000.0 |
| 2006-12-22 | ABAX-DELISTED | Stock | 18.88 | 19.2 | 18.68 | 18.8899 | 125136.0 |
| 2006-12-22 | ABB-DELISTED | Stock | 17.69 | 17.69 | 17.43 | 17.44 | 1072300.0 |
| 2006-12-22 | ABBC-DELISTED | Stock | 19.08 | 19.09 | 18.94 | 19.09 | 8720.0 |
| 2006-12-22 | ABC-DELISTED | Stock | 22.51 | 22.6 | 22.14 | 22.33 | 3858200.0 |
| 2006-12-22 | ABCB | Stock | 27.3021 | 27.6814 | 27.2729 | 27.4188 | 21796.0 |
| 2006-12-22 | ABCO-DELISTED | Stock | 26.54 | 26.6 | 26.35 | 26.53 | 171655.0 |
| 2006-12-22 | ABCW-DELISTED | Stock | 28.77 | 28.82 | 28.47 | 28.56 | 23510.0 |
| 2006-12-22 | ABD-DELISTED | Stock | 27.32 | 27.38 | 27.1 | 27.2 | 239700.0 |
| 2006-12-22 | ABE-DELISTED | Stock | 18.61 | 18.62 | 18.12 | 18.28 | 31300.0 |
| 2006-12-22 | ABFS-DELISTED | Stock | 36.43 | 36.76 | 36.3 | 36.63 | 170110.0 |
| 2006-12-22 | ABG | Stock | 23.87 | 23.93 | 23.5 | 23.7 | 84900.0 |
| 2006-12-22 | ABK-DELISTED | Stock | 89.08 | 89.36 | 88.82 | 89.0 | 511000.0 |
| 2006-12-22 | ABM | Stock | 23.19 | 23.29 | 23.0 | 23.1 | 140900.0 |
| 2006-12-22 | ABMD-DELISTED | Stock | 14.09 | 14.13 | 13.79 | 13.92 | 125362.0 |
| 2006-12-22 | ABP-DELISTED | Stock | 3.2 | 3.32 | 3.06 | 3.26 | 350100.0 |
| 2006-12-22 | ABR | Stock | 29.0 | 29.04 | 28.66 | 28.93 | 118500.0 |
| 2006-12-22 | ABT | Stock | 23.0448 | 23.0544 | 22.8769 | 22.9009 | 6574823.0 |
| 2006-12-22 | ABTL-DELISTED | Stock | 16.628 | 17.048 | 16.604 | 16.9 | 21716.0 |
| 2006-12-22 | ABV-DELISTED | Stock | 48.87 | 48.94 | 48.61 | 48.76 | 154500.0 |
| 2006-12-22 | ABVA-DELISTED | Stock | 15.8 | 15.89 | 15.7 | 15.87 | 23073.0 |
| 2006-12-22 | ABX-DELISTED | Stock | 30.08 | 30.1 | 29.57 | 29.9 | 3130600.0 |
| 2006-12-22 | ACAD | Stock | 8.84 | 8.98 | 8.84 | 8.92 | 42600.0 |
| 2006-12-22 | ACAP-DELISTED | Stock | 39.69 | 40.53 | 39.61 | 39.89 | 68560.0 |
| 2006-12-22 | ACAS-DELISTED | Stock | 44.95 | 45.32 | 44.8 | 45.17 | 600076.0 |
| 2006-12-22 | ACAT-DELISTED | Stock | 17.94 | 17.98 | 17.33 | 17.37 | 105966.0 |
| 2006-12-22 | ACC-DELISTED | Stock | 28.46 | 28.55 | 27.53 | 28.14 | 64200.0 |
| 2006-12-22 | ACCL-DELISTED | Stock | 5.68 | 5.85 | 5.68 | 5.84 | 39446.0 |
> showing 50 of 4,632 rows — these rows as CSV