PREVIEW / stock_daily / 2000-01-27
file: by_date/stock_daily/2000/2000-01-27.parquet size: 85 KB rows: 2,701 symbols: 1,686
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-01-27 | AAPL | Stock | 0.9715 | 1.0089 | 0.9554 | 0.9821 | 340144000.0 |
| 2000-01-27 | MSFT | Stock | 49.9453 | 50.5938 | 48.625 | 49.375 | 63654800.0 |
| 2000-01-27 | NVDA | Stock | 0.0853 | 0.0853 | 0.0771 | 0.0802 | 458208000.0 |
| 2000-01-27 | AMZN | Stock | 3.2594 | 3.3875 | 3.2312 | 3.3469 | 135680000.0 |
| 2000-01-27 | CL | Stock | 29.875 | 30.6562 | 29.875 | 30.1562 | 2075200.0 |
| 2000-01-27 | A | Stock | 49.9821 | 50.4292 | 48.1044 | 48.9539 | 868577.0 |
| 2000-01-27 | AABA-DELISTED | Stock | 83.109375 | 84.890625 | 81.28125 | 84.34375 | 19222000.0 |
| 2000-01-27 | AAI-DELISTED | Stock | 4.81 | 4.88 | 4.56 | 4.81 | 358000.0 |
| 2000-01-27 | AAIC-DELISTED | Stock | 197.5 | 198.75 | 167.5 | 167.5 | 299800.0 |
| 2000-01-27 | AAME | Stock | 2.5625 | 2.875 | 2.5625 | 2.75 | 7200.0 |
| 2000-01-27 | AAON | Stock | 0.8413 | 0.8487 | 0.834 | 0.834 | 30755.0 |
| 2000-01-27 | ABAX-DELISTED | Stock | 8.875 | 8.875 | 8.5 | 8.6875 | 132900.0 |
| 2000-01-27 | ABC-DELISTED | Stock | 4.5625 | 4.875 | 4.53125 | 4.6875 | 3402800.0 |
| 2000-01-27 | ABCB | Stock | 8.1053 | 8.1053 | 8.1053 | 8.1053 | 3084.0 |
| 2000-01-27 | ABCW-DELISTED | Stock | 13.75 | 14.004 | 13.625 | 13.63 | 35600.0 |
| 2000-01-27 | ABE-DELISTED | Stock | 16.0625 | 16.1875 | 16.0 | 16.125 | 30900.0 |
| 2000-01-27 | ABFS-DELISTED | Stock | 13.25 | 13.25 | 10.625 | 11.75 | 254600.0 |
| 2000-01-27 | ABK-DELISTED | Stock | 47.81 | 50.0 | 47.75 | 49.0 | 694100.0 |
| 2000-01-27 | ABM | Stock | 10.2188 | 10.3438 | 10.2188 | 10.25 | 50400.0 |
| 2000-01-27 | ABMD-DELISTED | Stock | 29.2 | 29.438 | 28.5 | 29.0 | 112800.0 |
| 2000-01-27 | ABT | Stock | 13.3548 | 14.0001 | 13.2987 | 13.8318 | 16105783.0 |
| 2000-01-27 | ABTL-DELISTED | Stock | 63.75 | 64.06 | 59.69 | 61.88 | 109100.0 |
| 2000-01-27 | ABV-DELISTED | Stock | 14.25 | 14.62 | 14.0 | 14.13 | 111100.0 |
| 2000-01-27 | ABX-DELISTED | Stock | 16.313 | 16.938 | 16.188 | 16.938 | 2675846.0 |
| 2000-01-27 | ACAS-DELISTED | Stock | 24.13 | 24.25 | 23.75 | 23.94 | 152000.0 |
| 2000-01-27 | ACAT-DELISTED | Stock | 9.875 | 9.9375 | 9.875 | 9.875 | 43000.0 |
| 2000-01-27 | ACCL-DELISTED | Stock | 27.8700008392334 | 28.4669990539551 | 27.2450008392334 | 27.5160007476807 | 315000.0 |
| 2000-01-27 | ACE-DELISTED | Stock | 18.938 | 19.001 | 18.25 | 18.438 | 687900.0 |
| 2000-01-27 | ACF-DELISTED | Stock | 17.13 | 17.31 | 16.81 | 17.06 | 298400.0 |
| 2000-01-27 | ACG-DELISTED | Stock | 7.875 | 7.875 | 7.75 | 7.8125 | 88200.0 |
| 2000-01-27 | ACGN-DELISTED | Stock | 2266.6712 | 2479.1712 | 2195.8288 | 2266.6712 | 45300.0 |
| 2000-01-27 | ACH | Stock | 6.1667 | 6.1667 | 5.8333 | 5.8333 | 62550.0 |
| 2000-01-27 | ACO-DELISTED | Stock | 14.25 | 14.4375 | 14.25 | 14.3125 | 15700.0 |
| 2000-01-27 | ACS-DELISTED | Stock | 22.0313 | 22.0938 | 21.0625 | 21.1563 | 227800.0 |
| 2000-01-27 | ACTA-DELISTED | Stock | 2740.0 | 2757.5 | 2512.5 | 2600.0 | 123400.0 |
| 2000-01-27 | ACTT-DELISTED | Stock | 14.0625 | 14.8125 | 13.875 | 14.4375 | 37700.0 |
| 2000-01-27 | ACTU-DELISTED | Stock | 40.13 | 41.75 | 39.44 | 41.0 | 533200.0 |
| 2000-01-27 | ACXM-DELISTED | Stock | 26.19 | 26.25 | 25.19 | 25.56 | 578497.0 |
| 2000-01-27 | ACY-DELISTED | Stock | 6.0 | 6.38 | 6.0 | 6.38 | 3900.0 |
| 2000-01-27 | AD | Stock | 57.3333 | 58.0 | 49.3333 | 50.4167 | 4500600.0 |
| 2000-01-27 | ADAT-DELISTED | Stock | 277.88 | 279.0 | 261.0 | 265.5 | 11600.0 |
| 2000-01-27 | ADBE | Stock | 15.2031 | 16.0 | 15.2031 | 15.6719 | 5864400.0 |
| 2000-01-27 | ADC | Stock | 13.3125 | 13.75 | 13.25 | 13.75 | 9000.0 |
| 2000-01-27 | ADEP-DELISTED | Stock | 38.75 | 40.0 | 35.0 | 38.44 | 34000.0 |
| 2000-01-27 | ADGF-DELISTED | Stock | 1.86 | 1.94 | 1.75 | 1.94 | 41900.0 |
| 2000-01-27 | ADI | Stock | 50.9688 | 51.5469 | 47.0 | 48.0312 | 2682800.0 |
| 2000-01-27 | ADM | Stock | 10.9977 | 11.0544 | 10.771 | 10.8844 | 1256299.0 |
| 2000-01-27 | ADMP-DELISTED | Stock | 706.5625 | 743.75 | 690.625 | 722.5 | 400.0 |
| 2000-01-27 | ADPI-DELISTED | Stock | 6.5 | 6.94 | 6.25 | 6.94 | 2800.0 |
| 2000-01-27 | ADSK | Stock | 8.0781 | 8.25 | 8.0 | 8.125 | 2780400.0 |
> showing 50 of 2,701 rows — these rows as CSV