PREVIEW / stock_daily / 2000-11-20
file: by_date/stock_daily/2000/2000-11-20.parquet size: 89 KB rows: 2,864 symbols: 1,782
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-20 | AAPL | Stock | 0.332 | 0.3482 | 0.3259 | 0.3382 | 408066400.0 |
| 2000-11-20 | MSFT | Stock | 34.0625 | 34.25 | 32.7812 | 33.5938 | 80157200.0 |
| 2000-11-20 | NVDA | Stock | 0.2543 | 0.2544 | 0.2409 | 0.2438 | 298752000.0 |
| 2000-11-20 | AMZN | Stock | 1.3 | 1.3969 | 1.25 | 1.2906 | 128766000.0 |
| 2000-11-20 | CL | Stock | 30.0 | 30.4 | 29.525 | 29.94 | 2931000.0 |
| 2000-11-20 | A | Stock | 33.53 | 33.5747 | 31.3394 | 31.9206 | 4141016.0 |
| 2000-11-20 | AABA-DELISTED | Stock | 25.1875 | 25.6875 | 23.9375 | 24.4375 | 18448400.0 |
| 2000-11-20 | AAI-DELISTED | Stock | 5.06 | 5.13 | 5.0 | 5.13 | 96200.0 |
| 2000-11-20 | AAIC-DELISTED | Stock | 135.0 | 140.0 | 135.0 | 136.25 | 40400.0 |
| 2000-11-20 | AAME | Stock | 2.0 | 2.0 | 2.0 | 2.0 | 3000.0 |
| 2000-11-20 | AAON | Stock | 1.3461 | 1.3608 | 1.3461 | 1.3608 | 133270.0 |
| 2000-11-20 | ABAX-DELISTED | Stock | 6.96875 | 7.0 | 6.5625 | 6.625 | 27700.0 |
| 2000-11-20 | ABC-DELISTED | Stock | 11.828125 | 12.0625 | 11.78125 | 12.0625 | 1350800.0 |
| 2000-11-20 | ABCB | Stock | 7.1429 | 7.1429 | 7.0921 | 7.0921 | 4565.0 |
| 2000-11-20 | ABCW-DELISTED | Stock | 15.06 | 15.13 | 14.94 | 15.13 | 15000.0 |
| 2000-11-20 | ABE-DELISTED | Stock | 8.375 | 8.5 | 8.0625 | 8.0625 | 39800.0 |
| 2000-11-20 | ABFS-DELISTED | Stock | 18.21875 | 18.375 | 17.75 | 17.875 | 39400.0 |
| 2000-11-20 | ABK-DELISTED | Stock | 74.69 | 75.31 | 73.5 | 75.06 | 302000.0 |
| 2000-11-20 | ABM | Stock | 14.8438 | 14.9688 | 14.7188 | 14.9375 | 19200.0 |
| 2000-11-20 | ABMD-DELISTED | Stock | 28.875 | 28.875 | 25.625 | 27.75 | 220600.0 |
| 2000-11-20 | ABP-DELISTED | Stock | 3.44 | 3.44 | 3.31 | 3.44 | 45400.0 |
| 2000-11-20 | ABT | Stock | 23.6234 | 23.8479 | 23.399 | 23.6515 | 3495872.0 |
| 2000-11-20 | ABTL-DELISTED | Stock | 17.5 | 19.063 | 17.5 | 18.438 | 27600.0 |
| 2000-11-20 | ABV-DELISTED | Stock | 21.9375 | 22.9375 | 21.9375 | 22.3125 | 264800.0 |
| 2000-11-20 | ABX-DELISTED | Stock | 13.313 | 13.501 | 13.313 | 13.313 | 570395.0 |
| 2000-11-20 | ACAS-DELISTED | Stock | 22.25 | 22.5 | 21.75 | 22.0 | 117700.0 |
| 2000-11-20 | ACAT-DELISTED | Stock | 12.001 | 12.063 | 11.938 | 11.938 | 20500.0 |
| 2000-11-20 | ACCL-DELISTED | Stock | 17.1100006103516 | 17.378999710083 | 15.4779996871948 | 15.8400001525879 | 383600.0 |
| 2000-11-20 | ACE-DELISTED | Stock | 39.9375 | 39.9375 | 38.75 | 39.125 | 946900.0 |
| 2000-11-20 | ACF-DELISTED | Stock | 23.19 | 23.38 | 20.38 | 22.94 | 1220700.0 |
| 2000-11-20 | ACG-DELISTED | Stock | 7.5625 | 7.5625 | 7.5 | 7.5 | 109100.0 |
| 2000-11-20 | ACGL | Stock | 1.7014 | 1.7014 | 1.6806 | 1.6944 | 196200.0 |
| 2000-11-20 | ACGN-DELISTED | Stock | 779.1712 | 1027.14 | 779.1712 | 1027.14 | 14900.0 |
| 2000-11-20 | ACH | Stock | 10.375 | 10.375 | 10.0 | 10.0 | 211650.0 |
| 2000-11-20 | ACLS | Stock | 31.25 | 33.1248 | 30.75 | 33.0 | 72200.0 |
| 2000-11-20 | ACO-DELISTED | Stock | 6.4375 | 6.875 | 6.3125 | 6.625 | 31100.0 |
| 2000-11-20 | ACPW-DELISTED | Stock | 90.0 | 92.5 | 82.5 | 90.0 | 114440.0 |
| 2000-11-20 | ACS-DELISTED | Stock | 28.9375 | 28.9375 | 28.3125 | 28.5938 | 469500.0 |
| 2000-11-20 | ACTA-DELISTED | Stock | 137.5 | 157.5 | 130.0 | 148.12 | 176600.0 |
| 2000-11-20 | ACTT-DELISTED | Stock | 9.4375 | 9.4375 | 9.3438 | 9.375 | 18400.0 |
| 2000-11-20 | ACTU-DELISTED | Stock | 31.56 | 31.59 | 29.0 | 29.13 | 286500.0 |
| 2000-11-20 | ACXM-DELISTED | Stock | 38.63 | 38.69 | 34.63 | 37.94 | 1514795.0 |
| 2000-11-20 | AD | Stock | 37.1667 | 37.6733 | 36.18 | 37.1733 | 244200.0 |
| 2000-11-20 | ADAT-DELISTED | Stock | 99.0 | 99.0 | 93.38 | 93.38 | 2900.0 |
| 2000-11-20 | ADBE | Stock | 39.4062 | 40.0625 | 37.2812 | 38.0 | 6724600.0 |
| 2000-11-20 | ADC | Stock | 14.375 | 14.375 | 14.3125 | 14.3125 | 3000.0 |
| 2000-11-20 | ADEP-DELISTED | Stock | 150.0 | 154.69 | 135.31 | 140.0 | 21800.0 |
| 2000-11-20 | ADGF-DELISTED | Stock | 1.08 | 1.08 | 1.0 | 1.06 | 22500.0 |
| 2000-11-20 | ADI | Stock | 59.0 | 62.0 | 57.125 | 61.5 | 4763400.0 |
| 2000-11-20 | ADLR-DELISTED | Stock | 18.71875 | 21.125 | 18.4375 | 20.5 | 157200.0 |
> showing 50 of 2,864 rows — these rows as CSV