PREVIEW / stock_daily / 2000-10-18
file: by_date/stock_daily/2000/2000-10-18.parquet size: 89 KB rows: 2,861 symbols: 1,779
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-18 | AAPL | Stock | 0.3471 | 0.3761 | 0.3348 | 0.3594 | 834265600.0 |
| 2000-10-18 | MSFT | Stock | 24.8125 | 26.625 | 24.2188 | 25.875 | 110536400.0 |
| 2000-10-18 | NVDA | Stock | 0.2299 | 0.256 | 0.219 | 0.2419 | 416952000.0 |
| 2000-10-18 | AMZN | Stock | 0.9938 | 1.2688 | 0.9688 | 1.2562 | 375774000.0 |
| 2000-10-18 | CL | Stock | 25.5 | 25.75 | 25.125 | 25.585 | 3454000.0 |
| 2000-10-18 | A | Stock | 29.0147 | 30.3559 | 28.0758 | 29.2382 | 5637854.0 |
| 2000-10-18 | AABA-DELISTED | Stock | 23.21875 | 27.125 | 22.53125 | 26.375 | 59887600.0 |
| 2000-10-18 | AAI-DELISTED | Stock | 4.13 | 4.13 | 4.0 | 4.13 | 142700.0 |
| 2000-10-18 | AAIC-DELISTED | Stock | 145.0 | 145.0 | 131.25 | 135.0 | 94800.0 |
| 2000-10-18 | AAME | Stock | 2.0 | 2.0 | 2.0 | 2.0 | 2400.0 |
| 2000-10-18 | AAON | Stock | 1.3397 | 1.3461 | 1.3352 | 1.3352 | 124727.0 |
| 2000-10-18 | ABAX-DELISTED | Stock | 5.5 | 5.5625 | 5.4375 | 5.5 | 100900.0 |
| 2000-10-18 | ABC-DELISTED | Stock | 11.4375 | 11.515625 | 11.3125 | 11.484375 | 1264000.0 |
| 2000-10-18 | ABCB | Stock | 7.4468 | 7.4468 | 7.1935 | 7.1935 | 1973.0 |
| 2000-10-18 | ABCW-DELISTED | Stock | 14.0 | 14.5 | 14.0 | 14.5 | 4100.0 |
| 2000-10-18 | ABE-DELISTED | Stock | 11.1875 | 11.25 | 10.625 | 11.125 | 59800.0 |
| 2000-10-18 | ABFS-DELISTED | Stock | 14.75 | 14.8125 | 14.5 | 14.8125 | 81800.0 |
| 2000-10-18 | ABK-DELISTED | Stock | 71.5 | 72.88 | 70.5 | 71.88 | 553700.0 |
| 2000-10-18 | ABM | Stock | 12.8438 | 12.875 | 12.8438 | 12.875 | 51600.0 |
| 2000-10-18 | ABMD-DELISTED | Stock | 30.5 | 32.0 | 30.0 | 31.8125 | 78600.0 |
| 2000-10-18 | ABP-DELISTED | Stock | 3.5 | 3.63 | 3.44 | 3.44 | 28000.0 |
| 2000-10-18 | ABT | Stock | 23.1184 | 23.6795 | 22.8378 | 22.8939 | 13371326.0 |
| 2000-10-18 | ABTL-DELISTED | Stock | 28.13 | 30.31 | 26.25 | 30.31 | 33300.0 |
| 2000-10-18 | ABV-DELISTED | Stock | 23.0 | 23.3125 | 22.6875 | 23.1875 | 301200.0 |
| 2000-10-18 | ABX-DELISTED | Stock | 13.626 | 13.876 | 13.0 | 13.188 | 1716456.0 |
| 2000-10-18 | ACAS-DELISTED | Stock | 21.5 | 21.75 | 21.125 | 21.5 | 81400.0 |
| 2000-10-18 | ACAT-DELISTED | Stock | 11.9375 | 12.0 | 11.9375 | 12.0 | 21600.0 |
| 2000-10-18 | ACCL-DELISTED | Stock | 13.75 | 15.4779996871948 | 13.6680002212524 | 15.3870000839233 | 283900.0 |
| 2000-10-18 | ACE-DELISTED | Stock | 34.31 | 36.31 | 33.56 | 36.06 | 1214400.0 |
| 2000-10-18 | ACF-DELISTED | Stock | 25.88 | 25.94 | 24.38 | 25.5 | 591700.0 |
| 2000-10-18 | ACG-DELISTED | Stock | 7.1875 | 7.25 | 7.125 | 7.125 | 89300.0 |
| 2000-10-18 | ACGL | Stock | 1.7569 | 1.7639 | 1.75 | 1.75 | 155700.0 |
| 2000-10-18 | ACGN-DELISTED | Stock | 1097.9688 | 1097.9688 | 920.8288 | 1097.9688 | 10400.0 |
| 2000-10-18 | ACH | Stock | 9.75 | 9.75 | 7.9167 | 8.375 | 1519200.0 |
| 2000-10-18 | ACLS | Stock | 32.3752 | 37.3752 | 32.0 | 35.25 | 205825.0 |
| 2000-10-18 | ACO-DELISTED | Stock | 5.4375 | 5.5625 | 5.25 | 5.375 | 57200.0 |
| 2000-10-18 | ACPW-DELISTED | Stock | 186.56 | 200.0 | 178.44 | 185.62 | 38960.0 |
| 2000-10-18 | ACS-DELISTED | Stock | 25.5625 | 25.5625 | 25.1875 | 25.4688 | 138800.0 |
| 2000-10-18 | ACTA-DELISTED | Stock | 197.5 | 211.25 | 180.0 | 185.0 | 440700.0 |
| 2000-10-18 | ACTT-DELISTED | Stock | 8.6094 | 8.625 | 7.8125 | 8.0 | 21000.0 |
| 2000-10-18 | ACTU-DELISTED | Stock | 27.19 | 27.25 | 25.5 | 26.5 | 494800.0 |
| 2000-10-18 | ACXM-DELISTED | Stock | 32.125 | 34.34375 | 29.625 | 33.9375 | 722100.0 |
| 2000-10-18 | AD | Stock | 35.6667 | 38.4 | 34.7667 | 38.4 | 587700.0 |
| 2000-10-18 | ADAT-DELISTED | Stock | 65.25 | 77.63 | 64.69 | 76.5 | 12000.0 |
| 2000-10-18 | ADBE | Stock | 32.0625 | 34.2812 | 30.7344 | 32.2656 | 9762000.0 |
| 2000-10-18 | ADC | Stock | 14.25 | 14.25 | 13.625 | 14.125 | 10600.0 |
| 2000-10-18 | ADEP-DELISTED | Stock | 166.25 | 184.69 | 152.5 | 179.38 | 36200.0 |
| 2000-10-18 | ADGF-DELISTED | Stock | 1.06 | 1.06 | 1.03 | 1.03 | 34000.0 |
| 2000-10-18 | ADI | Stock | 64.75 | 69.4375 | 61.5 | 65.375 | 5135600.0 |
| 2000-10-18 | ADM | Stock | 9.3452 | 9.4048 | 8.9881 | 9.1667 | 1696695.0 |
> showing 50 of 2,861 rows — these rows as CSV