PREVIEW / stock_daily / 2000-11-02
file: by_date/stock_daily/2000/2000-11-02.parquet size: 90 KB rows: 2,865 symbols: 1,786
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-11-02 | AAPL | Stock | 0.3772 | 0.4007 | 0.3761 | 0.3984 | 590693600.0 |
| 2000-11-02 | MSFT | Stock | 35.1875 | 35.4219 | 34.8125 | 35.1562 | 77985200.0 |
| 2000-11-02 | NVDA | Stock | 0.268 | 0.2854 | 0.2635 | 0.2786 | 192888000.0 |
| 2000-11-02 | AMZN | Stock | 1.9031 | 1.9938 | 1.875 | 1.9875 | 139794000.0 |
| 2000-11-02 | CL | Stock | 28.375 | 29.425 | 28.095 | 29.175 | 3126000.0 |
| 2000-11-02 | A | Stock | 33.7089 | 34.8265 | 33.53 | 34.4242 | 3432789.0 |
| 2000-11-02 | AABA-DELISTED | Stock | 33.25 | 34.625 | 32.125 | 33.71875 | 29210800.0 |
| 2000-11-02 | AAI-DELISTED | Stock | 4.75 | 4.88 | 4.69 | 4.88 | 342900.0 |
| 2000-11-02 | AAIC-DELISTED | Stock | 153.75 | 155.0 | 151.25 | 155.0 | 29200.0 |
| 2000-11-02 | AAME | Stock | 2.25 | 2.25 | 2.0 | 2.25 | 3500.0 |
| 2000-11-02 | AAON | Stock | 1.2583 | 1.4193 | 1.2583 | 1.3754 | 645848.0 |
| 2000-11-02 | ABAX-DELISTED | Stock | 6.25 | 6.25 | 6.125 | 6.25 | 17400.0 |
| 2000-11-02 | ABC-DELISTED | Stock | 10.90625 | 11.03125 | 10.109375 | 10.203125 | 3466800.0 |
| 2000-11-02 | ABCW-DELISTED | Stock | 15.31 | 15.5 | 14.81 | 14.94 | 24100.0 |
| 2000-11-02 | ABE-DELISTED | Stock | 8.75 | 8.875 | 8.625 | 8.75 | 55800.0 |
| 2000-11-02 | ABFS-DELISTED | Stock | 16.5 | 17.0 | 16.5 | 16.6875 | 42000.0 |
| 2000-11-02 | ABK-DELISTED | Stock | 77.63 | 79.19 | 75.31 | 76.13 | 878700.0 |
| 2000-11-02 | ABM | Stock | 13.8125 | 14.0 | 13.7812 | 14.0 | 50800.0 |
| 2000-11-02 | ABMD-DELISTED | Stock | 29.5 | 30.125 | 28.75 | 29.4375 | 267800.0 |
| 2000-11-02 | ABP-DELISTED | Stock | 3.0 | 3.38 | 3.0 | 3.38 | 351100.0 |
| 2000-11-02 | ABT | Stock | 23.5673 | 24.1565 | 23.2587 | 24.0162 | 6259288.0 |
| 2000-11-02 | ABTL-DELISTED | Stock | 25.47 | 27.19 | 23.28 | 26.09 | 22000.0 |
| 2000-11-02 | ABV-DELISTED | Stock | 22.625 | 23.1875 | 22.5625 | 23.0625 | 150000.0 |
| 2000-11-02 | ABX-DELISTED | Stock | 13.251 | 13.437 | 13.065 | 13.313 | 1727623.0 |
| 2000-11-02 | ACAS-DELISTED | Stock | 22.125 | 23.75 | 22.0625 | 23.375 | 183200.0 |
| 2000-11-02 | ACAT-DELISTED | Stock | 12.7188 | 12.8441 | 12.656 | 12.656 | 31623.0 |
| 2000-11-02 | ACCL-DELISTED | Stock | 17.1100006103516 | 21.1800003051758 | 16.3379993438721 | 20.636999130249 | 2726000.0 |
| 2000-11-02 | ACE-DELISTED | Stock | 39.88 | 42.5 | 39.5 | 40.44 | 1852800.0 |
| 2000-11-02 | ACF-DELISTED | Stock | 27.25 | 29.0 | 27.25 | 28.5 | 768400.0 |
| 2000-11-02 | ACG-DELISTED | Stock | 7.625 | 7.6875 | 7.5 | 7.6875 | 132500.0 |
| 2000-11-02 | ACGL | Stock | 1.7569 | 1.7569 | 1.7361 | 1.7569 | 328500.0 |
| 2000-11-02 | ACGN-DELISTED | Stock | 814.64 | 814.64 | 814.64 | 814.64 | 1200.0 |
| 2000-11-02 | ACH | Stock | 9.8333 | 9.875 | 9.625 | 9.7917 | 121350.0 |
| 2000-11-02 | ACLS | Stock | 43.0 | 43.75 | 40.0 | 42.0 | 139725.0 |
| 2000-11-02 | ACO-DELISTED | Stock | 7.125 | 7.125 | 6.25 | 6.4375 | 78600.0 |
| 2000-11-02 | ACPW-DELISTED | Stock | 183.99 | 185.57 | 159.33 | 169.13 | 32455.0 |
| 2000-11-02 | ACS-DELISTED | Stock | 27.7813 | 28.5938 | 27.7813 | 28.4688 | 218600.0 |
| 2000-11-02 | ACTA-DELISTED | Stock | 330.31 | 370.0 | 322.5 | 370.0 | 507500.0 |
| 2000-11-02 | ACTT-DELISTED | Stock | 7.6406 | 8.125 | 7.625 | 8.125 | 18200.0 |
| 2000-11-02 | ACTU-DELISTED | Stock | 28.81 | 31.44 | 28.63 | 31.44 | 484600.0 |
| 2000-11-02 | ACXM-DELISTED | Stock | 41.0 | 42.19 | 41.0 | 42.06 | 759900.0 |
| 2000-11-02 | ACY-DELISTED | Stock | 5.75 | 5.75 | 5.75 | 5.75 | 400.0 |
| 2000-11-02 | AD | Stock | 40.1667 | 40.3667 | 38.6667 | 39.4467 | 157650.0 |
| 2000-11-02 | ADAT-DELISTED | Stock | 84.94 | 94.5 | 84.94 | 93.38 | 5300.0 |
| 2000-11-02 | ADBE | Stock | 39.25 | 41.5 | 39.2188 | 40.4062 | 7077200.0 |
| 2000-11-02 | ADC | Stock | 14.0 | 14.125 | 14.0 | 14.125 | 10600.0 |
| 2000-11-02 | ADEP-DELISTED | Stock | 137.5 | 153.12 | 135.0 | 147.5 | 24700.0 |
| 2000-11-02 | ADGF-DELISTED | Stock | 1.06 | 1.19 | 1.03 | 1.06 | 61700.0 |
| 2000-11-02 | ADI | Stock | 61.0 | 62.75 | 59.5 | 60.0 | 4216100.0 |
| 2000-11-02 | ADM | Stock | 10.5357 | 10.5952 | 10.3571 | 10.4167 | 975975.0 |
> showing 50 of 2,865 rows — these rows as CSV