PREVIEW / stock_daily / 2006-11-20
file: by_date/stock_daily/2006/2006-11-20.parquet size: 156 KB rows: 4,613 symbols: 2,919
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-11-20 | AAPL | Stock | 3.05 | 3.1071 | 3.0429 | 3.0882 | 570794000.0 |
| 2006-11-20 | MSFT | Stock | 29.52 | 30.0 | 29.5 | 29.89 | 85703800.0 |
| 2006-11-20 | NVDA | Stock | 0.5978 | 0.6143 | 0.5933 | 0.611 | 608634000.0 |
| 2006-11-20 | AMZN | Stock | 2.1175 | 2.1275 | 2.097 | 2.122 | 115928000.0 |
| 2006-11-20 | CL | Stock | 33.41 | 33.46 | 32.705 | 32.99 | 5786600.0 |
| 2006-11-20 | A | Stock | 23.9986 | 24.3062 | 23.9342 | 24.1345 | 3130262.0 |
| 2006-11-20 | AABA-DELISTED | Stock | 26.9599990844727 | 27.0400009155273 | 26.6299991607666 | 26.7199993133545 | 20272000.0 |
| 2006-11-20 | AACC-DELISTED | Stock | 16.86 | 17.27 | 16.83 | 17.09 | 65440.0 |
| 2006-11-20 | AACQ-DELISTED | Stock | 5.5 | 5.5 | 5.5 | 5.5 | 25800.0 |
| 2006-11-20 | AAI-DELISTED | Stock | 13.05 | 13.12 | 12.61 | 12.72 | 1868900.0 |
| 2006-11-20 | AAIC-DELISTED | Stock | 143.4 | 145.0 | 142.2 | 144.4 | 1185500.0 |
| 2006-11-20 | AAON | Stock | 3.6872 | 3.7531 | 3.6596 | 3.6938 | 78216.0 |
| 2006-11-20 | AAP | Stock | 37.97 | 38.55 | 37.69 | 37.95 | 692200.0 |
| 2006-11-20 | AATI-DELISTED | Stock | 5.81 | 5.85 | 5.74 | 5.82 | 204614.0 |
| 2006-11-20 | AAU-DELISTED | Stock | 2.57 | 2.63 | 2.5 | 2.5 | 31000.0 |
| 2006-11-20 | AAUAF-DELISTED | Stock | 2.57 | 2.63 | 2.5 | 2.5 | 31000.0 |
| 2006-11-20 | AAV-DELISTED | Stock | 12.0 | 12.49 | 11.93 | 12.375 | 1572600.0 |
| 2006-11-20 | AAWW-DELISTED | Stock | 37.61 | 37.67 | 37.07 | 37.65 | 334505.0 |
| 2006-11-20 | AAXN-DELISTED | Stock | 9.05000019073486 | 9.07999992370605 | 8.9399995803833 | 8.97999954223633 | 592500.0 |
| 2006-11-20 | AB | Stock | 76.57 | 77.42 | 76.4 | 77.13 | 215900.0 |
| 2006-11-20 | ABAX-DELISTED | Stock | 20.13 | 20.44 | 19.92 | 19.96 | 141502.0 |
| 2006-11-20 | ABB-DELISTED | Stock | 15.63 | 15.8852 | 15.6101 | 15.88 | 3285200.0 |
| 2006-11-20 | ABBC-DELISTED | Stock | 16.2 | 16.3 | 16.2 | 16.24 | 3844.0 |
| 2006-11-20 | ABC-DELISTED | Stock | 23.46 | 23.46 | 23.01 | 23.15 | 2500392.0 |
| 2006-11-20 | ABCB | Stock | 27.341 | 27.7689 | 27.341 | 27.7689 | 15319.0 |
| 2006-11-20 | ABCO-DELISTED | Stock | 28.95 | 29.39 | 28.9 | 28.97 | 156080.0 |
| 2006-11-20 | ABCW-DELISTED | Stock | 29.27 | 29.55 | 29.22 | 29.38 | 16770.0 |
| 2006-11-20 | ABD-DELISTED | Stock | 25.28 | 25.34 | 25.05 | 25.28 | 131900.0 |
| 2006-11-20 | ABE-DELISTED | Stock | 16.84 | 16.84 | 16.3 | 16.61 | 24900.0 |
| 2006-11-20 | ABFS-DELISTED | Stock | 40.07 | 40.12 | 39.31 | 39.69 | 336855.0 |
| 2006-11-20 | ABG | Stock | 24.0 | 24.04 | 23.83 | 24.03 | 337400.0 |
| 2006-11-20 | ABK-DELISTED | Stock | 85.6 | 85.69 | 84.93 | 85.07 | 347700.0 |
| 2006-11-20 | ABM | Stock | 20.75 | 20.89 | 20.65 | 20.87 | 110100.0 |
| 2006-11-20 | ABMD-DELISTED | Stock | 12.67 | 13.0 | 12.66 | 12.99 | 109002.0 |
| 2006-11-20 | ABP-DELISTED | Stock | 3.5 | 3.52 | 3.4 | 3.5 | 131500.0 |
| 2006-11-20 | ABR | Stock | 28.69 | 28.77 | 28.3 | 28.46 | 138000.0 |
| 2006-11-20 | ABT | Stock | 22.7665 | 22.992 | 22.7521 | 22.9152 | 8359316.0 |
| 2006-11-20 | ABTL-DELISTED | Stock | 15.525 | 15.525 | 15.324 | 15.425 | 14578.0 |
| 2006-11-20 | ABV-DELISTED | Stock | 46.64 | 47.17 | 46.3 | 46.62 | 318200.0 |
| 2006-11-20 | ABVA-DELISTED | Stock | 15.62 | 16.6 | 15.62 | 16.6 | 8048.0 |
| 2006-11-20 | ABX-DELISTED | Stock | 28.52 | 28.95 | 28.32 | 28.35 | 4321500.0 |
| 2006-11-20 | ACAD | Stock | 9.7 | 9.8 | 9.52 | 9.8 | 75600.0 |
| 2006-11-20 | ACAP-DELISTED | Stock | 38.7 | 39.21 | 38.43 | 39.11 | 15367.0 |
| 2006-11-20 | ACAS-DELISTED | Stock | 44.06 | 44.18 | 43.76 | 43.96 | 527128.0 |
| 2006-11-20 | ACAT-DELISTED | Stock | 17.5 | 17.75 | 17.5 | 17.64 | 38372.0 |
| 2006-11-20 | ACC-DELISTED | Stock | 28.32 | 28.92 | 28.29 | 28.44 | 342650.0 |
| 2006-11-20 | ACCL-DELISTED | Stock | 6.34 | 6.4 | 6.28 | 6.39 | 35360.0 |
| 2006-11-20 | ACCO | Stock | 25.27 | 25.35 | 25.05 | 25.28 | 168900.0 |
| 2006-11-20 | ACCP-DELISTED | Stock | 1.25 | 1.4 | 1.25 | 1.4 | 2100.0 |
| 2006-11-20 | ACE-DELISTED | Stock | 57.92 | 58.44 | 57.92 | 58.28 | 784753.0 |
> showing 50 of 4,613 rows — these rows as CSV