PREVIEW / stock_daily / 2000-09-19
file: by_date/stock_daily/2000/2000-09-19.parquet size: 89 KB rows: 2,840 symbols: 1,772
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-09-19 | AAPL | Stock | 1.067 | 1.0804 | 1.0458 | 1.0703 | 271510400.0 |
| 2000-09-19 | MSFT | Stock | 31.8125 | 32.875 | 31.6875 | 32.5 | 79311200.0 |
| 2000-09-19 | NVDA | Stock | 0.2654 | 0.2875 | 0.2625 | 0.2867 | 301104000.0 |
| 2000-09-19 | AMZN | Stock | 2.1031 | 2.1375 | 1.9562 | 2.0375 | 144616000.0 |
| 2000-09-19 | CL | Stock | 22.5 | 22.625 | 22.0312 | 22.25 | 13161800.0 |
| 2000-09-19 | A | Stock | 38.3137 | 38.6266 | 37.196 | 38.5372 | 3198065.0 |
| 2000-09-19 | AABA-DELISTED | Stock | 52.75 | 54.125 | 52.5625 | 54.03125 | 9642600.0 |
| 2000-09-19 | AAI-DELISTED | Stock | 4.25 | 4.31 | 4.19 | 4.31 | 163000.0 |
| 2000-09-19 | AAIC-DELISTED | Stock | 160.0 | 166.25 | 160.0 | 166.25 | 61500.0 |
| 2000-09-19 | AAME | Stock | 2.0 | 2.125 | 1.875 | 2.0625 | 46000.0 |
| 2000-09-19 | AAON | Stock | 1.39 | 1.4047 | 1.3827 | 1.3827 | 138396.0 |
| 2000-09-19 | ABAX-DELISTED | Stock | 5.75 | 5.75 | 5.5625 | 5.625 | 3800.0 |
| 2000-09-19 | ABC-DELISTED | Stock | 9.25 | 9.46875 | 9.125 | 9.453125 | 1494400.0 |
| 2000-09-19 | ABCB | Stock | 8.4093 | 8.7133 | 8.308 | 8.4093 | 34668.0 |
| 2000-09-19 | ABCW-DELISTED | Stock | 16.28 | 16.87 | 16.28 | 16.75 | 29000.0 |
| 2000-09-19 | ABE-DELISTED | Stock | 12.9375 | 12.9375 | 12.8125 | 12.8125 | 14700.0 |
| 2000-09-19 | ABFS-DELISTED | Stock | 13.0 | 14.25 | 13.0 | 14.0 | 87300.0 |
| 2000-09-19 | ABK-DELISTED | Stock | 65.0 | 69.19 | 65.0 | 68.63 | 428600.0 |
| 2000-09-19 | ABM | Stock | 13.1875 | 13.75 | 13.125 | 13.75 | 105000.0 |
| 2000-09-19 | ABMD-DELISTED | Stock | 28.0 | 29.5 | 27.7188 | 28.5938 | 63600.0 |
| 2000-09-19 | ABP-DELISTED | Stock | 4.0 | 4.0 | 3.88 | 3.88 | 79100.0 |
| 2000-09-19 | ABT | Stock | 19.6675 | 19.7236 | 19.3308 | 19.5272 | 8909094.0 |
| 2000-09-19 | ABTL-DELISTED | Stock | 23.59 | 24.37 | 20.78 | 22.66 | 296400.0 |
| 2000-09-19 | ABV-DELISTED | Stock | 21.625 | 21.625 | 21.25 | 21.5625 | 380600.0 |
| 2000-09-19 | ABX-DELISTED | Stock | 15.5625 | 15.5625 | 15.125 | 15.1875 | 977400.0 |
| 2000-09-19 | ACAS-DELISTED | Stock | 22.13 | 23.13 | 22.13 | 23.13 | 105800.0 |
| 2000-09-19 | ACAT-DELISTED | Stock | 11.9375 | 12.125 | 11.9375 | 12.0 | 7900.0 |
| 2000-09-19 | ACCL-DELISTED | Stock | 29.2299995422363 | 29.3719997406006 | 28.0590000152588 | 28.6019992828369 | 240300.0 |
| 2000-09-19 | ACE-DELISTED | Stock | 36.25 | 37.0 | 36.0625 | 37.0 | 862000.0 |
| 2000-09-19 | ACF-DELISTED | Stock | 26.75 | 26.81 | 25.88 | 26.81 | 221000.0 |
| 2000-09-19 | ACG-DELISTED | Stock | 7.5625 | 7.625 | 7.5 | 7.5 | 65800.0 |
| 2000-09-19 | ACGL | Stock | 1.6944 | 1.7361 | 1.6944 | 1.7222 | 501300.0 |
| 2000-09-19 | ACGN-DELISTED | Stock | 963.3288 | 1097.9688 | 963.3288 | 1020.0 | 40300.0 |
| 2000-09-19 | ACH | Stock | 10.25 | 10.625 | 10.1667 | 10.5417 | 125100.0 |
| 2000-09-19 | ACLS | Stock | 61.25 | 62.25 | 59.25 | 59.75 | 138825.0 |
| 2000-09-19 | ACO-DELISTED | Stock | 4.4375 | 5.75 | 4.375 | 5.25 | 219800.0 |
| 2000-09-19 | ACPW-DELISTED | Stock | 340.63 | 362.81 | 331.88 | 344.38 | 131860.0 |
| 2000-09-19 | ACS-DELISTED | Stock | 21.875 | 22.0938 | 21.8125 | 22.0 | 197300.0 |
| 2000-09-19 | ACTA-DELISTED | Stock | 551.25 | 557.5 | 510.0 | 527.5 | 298100.0 |
| 2000-09-19 | ACTT-DELISTED | Stock | 7.0 | 7.5 | 6.875 | 7.0 | 69300.0 |
| 2000-09-19 | ACTU-DELISTED | Stock | 27.06 | 29.25 | 27.0 | 28.88 | 638700.0 |
| 2000-09-19 | ACXM-DELISTED | Stock | 29.7494 | 30.6 | 29.436 | 30.31 | 819102.0 |
| 2000-09-19 | ACY-DELISTED | Stock | 6.06 | 6.06 | 6.0 | 6.0 | 5700.0 |
| 2000-09-19 | AD | Stock | 50.6667 | 50.8333 | 49.0833 | 49.125 | 553500.0 |
| 2000-09-19 | ADAT-DELISTED | Stock | 92.81 | 96.75 | 90.56 | 92.25 | 1900.0 |
| 2000-09-19 | ADBE | Stock | 35.8438 | 39.3906 | 35.5 | 38.2188 | 19066800.0 |
| 2000-09-19 | ADC | Stock | 15.8125 | 16.0 | 15.6875 | 15.875 | 6300.0 |
| 2000-09-19 | ADEP-DELISTED | Stock | 250.0 | 253.12 | 234.69 | 240.62 | 48400.0 |
| 2000-09-19 | ADGF-DELISTED | Stock | 1.33 | 1.44 | 1.25 | 1.38 | 14300.0 |
| 2000-09-19 | ADI | Stock | 84.5 | 90.5 | 83.0 | 89.0 | 3978500.0 |
> showing 50 of 2,840 rows — these rows as CSV