PREVIEW / stock_daily / 2000-10-27
file: by_date/stock_daily/2000/2000-10-27.parquet size: 89 KB rows: 2,844 symbols: 1,769
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 |
|---|---|---|---|---|---|---|---|
| 2000-10-27 | AAPL | Stock | 0.3371 | 0.3426 | 0.3192 | 0.3315 | 744503200.0 |
| 2000-10-27 | MSFT | Stock | 32.3438 | 34.5938 | 32.3125 | 33.8438 | 124292400.0 |
| 2000-10-27 | NVDA | Stock | 0.2615 | 0.2679 | 0.2458 | 0.2552 | 210960000.0 |
| 2000-10-27 | AMZN | Stock | 1.6969 | 1.875 | 1.6938 | 1.7812 | 247414000.0 |
| 2000-10-27 | CL | Stock | 27.745 | 28.81 | 27.575 | 28.81 | 4526600.0 |
| 2000-10-27 | A | Stock | 32.8147 | 33.7983 | 32.1441 | 32.7253 | 4527143.0 |
| 2000-10-27 | AABA-DELISTED | Stock | 28.5625 | 29.21875 | 26.59375 | 27.625 | 14792400.0 |
| 2000-10-27 | AAI-DELISTED | Stock | 4.13 | 4.25 | 4.06 | 4.19 | 155700.0 |
| 2000-10-27 | AAIC-DELISTED | Stock | 152.5 | 162.5 | 145.0 | 147.5 | 63100.0 |
| 2000-10-27 | AAME | Stock | 2.5 | 2.5 | 2.5 | 2.5 | 900.0 |
| 2000-10-27 | AAON | Stock | 1.2684 | 1.273 | 1.2657 | 1.273 | 61509.0 |
| 2000-10-27 | ABAX-DELISTED | Stock | 6.3125 | 6.3125 | 5.75 | 6.125 | 19400.0 |
| 2000-10-27 | ABC-DELISTED | Stock | 10.703125 | 10.703125 | 10.34375 | 10.5 | 1117600.0 |
| 2000-10-27 | ABCW-DELISTED | Stock | 14.94 | 15.13 | 14.69 | 14.81 | 18600.0 |
| 2000-10-27 | ABE-DELISTED | Stock | 11.9375 | 12.0 | 11.875 | 12.0 | 115400.0 |
| 2000-10-27 | ABFS-DELISTED | Stock | 15.75 | 15.875 | 15.125 | 15.625 | 82400.0 |
| 2000-10-27 | ABK-DELISTED | Stock | 73.63 | 77.44 | 73.63 | 76.94 | 564200.0 |
| 2000-10-27 | ABM | Stock | 13.4375 | 13.5938 | 13.4375 | 13.5 | 18400.0 |
| 2000-10-27 | ABMD-DELISTED | Stock | 35.96875 | 36.875 | 35.125 | 35.125 | 150100.0 |
| 2000-10-27 | ABP-DELISTED | Stock | 3.44 | 3.5 | 3.31 | 3.31 | 61200.0 |
| 2000-10-27 | ABT | Stock | 22.6134 | 23.5112 | 22.4731 | 23.2026 | 8457546.0 |
| 2000-10-27 | ABTL-DELISTED | Stock | 26.56 | 26.88 | 24.06 | 24.38 | 33800.0 |
| 2000-10-27 | ABV-DELISTED | Stock | 19.875 | 20.875 | 19.875 | 20.6875 | 363400.0 |
| 2000-10-27 | ABX-DELISTED | Stock | 12.9071 | 13.6554 | 12.845 | 13.6554 | 1700795.0 |
| 2000-10-27 | ACAS-DELISTED | Stock | 22.19 | 22.31 | 22.13 | 22.31 | 33694.0 |
| 2000-10-27 | ACAT-DELISTED | Stock | 12.125 | 12.501 | 12.063 | 12.188 | 10400.0 |
| 2000-10-27 | ACCL-DELISTED | Stock | 13.75 | 14.1199998855591 | 12.4910001754761 | 12.6269998550415 | 1099700.0 |
| 2000-10-27 | ACE-DELISTED | Stock | 38.3125 | 39.25 | 38.3125 | 39.25 | 907900.0 |
| 2000-10-27 | ACF-DELISTED | Stock | 24.56 | 25.19 | 23.56 | 25.13 | 457800.0 |
| 2000-10-27 | ACG-DELISTED | Stock | 7.4375 | 7.5 | 7.4375 | 7.4375 | 116100.0 |
| 2000-10-27 | ACGL | Stock | 1.7222 | 1.7361 | 1.7083 | 1.7153 | 261900.0 |
| 2000-10-27 | ACGN-DELISTED | Stock | 850.0 | 1054.0 | 850.0 | 1054.0 | 5500.0 |
| 2000-10-27 | ACH | Stock | 9.5417 | 9.9167 | 9.5417 | 9.9167 | 76200.0 |
| 2000-10-27 | ACLS | Stock | 43.25 | 44.0 | 39.5 | 39.75 | 78450.0 |
| 2000-10-27 | ACO-DELISTED | Stock | 5.5625 | 6.375 | 5.5625 | 6.125 | 80600.0 |
| 2000-10-27 | ACPW-DELISTED | Stock | 213.12 | 218.12 | 201.56 | 202.5 | 16280.0 |
| 2000-10-27 | ACS-DELISTED | Stock | 26.6563 | 28.75 | 26.6563 | 27.5313 | 734000.0 |
| 2000-10-27 | ACTA-DELISTED | Stock | 253.75 | 257.5 | 237.5 | 240.0 | 105300.0 |
| 2000-10-27 | ACTT-DELISTED | Stock | 7.8906 | 7.9063 | 7.875 | 7.8906 | 1100.0 |
| 2000-10-27 | ACTU-DELISTED | Stock | 28.69 | 29.25 | 27.81 | 27.88 | 304200.0 |
| 2000-10-27 | ACXM-DELISTED | Stock | 40.875 | 41.5 | 39.4375 | 40.25 | 1225700.0 |
| 2000-10-27 | ACY-DELISTED | Stock | 5.5 | 5.5 | 5.5 | 5.5 | 2000.0 |
| 2000-10-27 | AD | Stock | 40.0 | 41.9 | 39.6667 | 41.6733 | 186300.0 |
| 2000-10-27 | ADAT-DELISTED | Stock | 72.0 | 73.12 | 69.75 | 72.0 | 2100.0 |
| 2000-10-27 | ADBE | Stock | 36.4531 | 37.75 | 35.2188 | 37.4062 | 8126600.0 |
| 2000-10-27 | ADC | Stock | 14.5 | 14.625 | 14.1875 | 14.25 | 6500.0 |
| 2000-10-27 | ADEP-DELISTED | Stock | 155.08 | 175.0 | 143.75 | 149.14 | 47500.0 |
| 2000-10-27 | ADGF-DELISTED | Stock | 1.06 | 1.12 | 1.06 | 1.06 | 11200.0 |
| 2000-10-27 | ADI | Stock | 62.5 | 64.75 | 59.625 | 60.0 | 4469100.0 |
| 2000-10-27 | ADM | Stock | 9.881 | 10.0 | 9.6429 | 10.0 | 1127490.0 |
> showing 50 of 2,844 rows — these rows as CSV