PREVIEW / stock_daily / 2000-09-18
file: by_date/stock_daily/2000/2000-09-18.parquet size: 89 KB rows: 2,839 symbols: 1,762
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-18 | AAPL | Stock | 0.9866 | 1.0848 | 0.9833 | 1.0831 | 424536000.0 |
| 2000-09-18 | MSFT | Stock | 32.125 | 32.3125 | 31.0938 | 31.5 | 69037800.0 |
| 2000-09-18 | NVDA | Stock | 0.2961 | 0.2979 | 0.275 | 0.2781 | 163488000.0 |
| 2000-09-18 | AMZN | Stock | 2.175 | 2.2312 | 2.0938 | 2.1406 | 88904000.0 |
| 2000-09-18 | CL | Stock | 22.8125 | 23.1562 | 22.125 | 22.25 | 10663200.0 |
| 2000-09-18 | A | Stock | 40.8619 | 41.2643 | 37.5536 | 38.6266 | 4730692.0 |
| 2000-09-18 | AABA-DELISTED | Stock | 52.09375 | 53.75 | 51.1875 | 52.53125 | 11642800.0 |
| 2000-09-18 | AAI-DELISTED | Stock | 4.31 | 4.31 | 4.13 | 4.25 | 139000.0 |
| 2000-09-18 | AAIC-DELISTED | Stock | 165.0 | 167.5 | 156.25 | 160.0 | 68000.0 |
| 2000-09-18 | AAME | Stock | 2.25 | 2.25 | 2.0 | 2.0 | 10500.0 |
| 2000-09-18 | AAON | Stock | 1.3132 | 1.3827 | 1.3132 | 1.3315 | 167442.0 |
| 2000-09-18 | ABAX-DELISTED | Stock | 5.875 | 5.875 | 5.625 | 5.6875 | 13500.0 |
| 2000-09-18 | ABC-DELISTED | Stock | 9.609375 | 9.6875 | 9.09375 | 9.109375 | 1010400.0 |
| 2000-09-18 | ABCB | Stock | 8.3586 | 8.4093 | 8.3586 | 8.4093 | 740.0 |
| 2000-09-18 | ABCW-DELISTED | Stock | 16.188 | 16.312 | 16.004 | 16.25 | 98220.0 |
| 2000-09-18 | ABE-DELISTED | Stock | 13.1875 | 13.1875 | 13.0 | 13.0625 | 9200.0 |
| 2000-09-18 | ABFS-DELISTED | Stock | 13.875 | 13.875 | 12.875 | 13.0625 | 86400.0 |
| 2000-09-18 | ABK-DELISTED | Stock | 67.44 | 67.63 | 64.88 | 64.94 | 414300.0 |
| 2000-09-18 | ABM | Stock | 13.375 | 13.375 | 13.125 | 13.125 | 26000.0 |
| 2000-09-18 | ABMD-DELISTED | Stock | 27.625 | 28.938 | 27.2188 | 27.8 | 92200.0 |
| 2000-09-18 | ABP-DELISTED | Stock | 4.0 | 4.06 | 3.88 | 4.0 | 182500.0 |
| 2000-09-18 | ABT | Stock | 20.1725 | 21.0142 | 19.5833 | 19.8639 | 16889252.0 |
| 2000-09-18 | ABTL-DELISTED | Stock | 25.94 | 26.56 | 23.28 | 23.44 | 76700.0 |
| 2000-09-18 | ABV-DELISTED | Stock | 21.5 | 21.8125 | 21.375 | 21.75 | 314800.0 |
| 2000-09-18 | ABX-DELISTED | Stock | 15.625 | 15.8125 | 15.25 | 15.3125 | 1340700.0 |
| 2000-09-18 | ACAS-DELISTED | Stock | 23.1875 | 23.1875 | 22.0 | 22.125 | 145200.0 |
| 2000-09-18 | ACAT-DELISTED | Stock | 11.9375 | 12.0 | 11.9375 | 12.0 | 27200.0 |
| 2000-09-18 | ACCL-DELISTED | Stock | 29.2800006866455 | 29.507999420166 | 28.3309993743896 | 28.8740005493164 | 341900.0 |
| 2000-09-18 | ACE-DELISTED | Stock | 36.0625 | 37.0 | 36.0625 | 36.25 | 1636600.0 |
| 2000-09-18 | ACF-DELISTED | Stock | 26.88 | 27.25 | 25.25 | 26.81 | 459300.0 |
| 2000-09-18 | ACG-DELISTED | Stock | 7.5625 | 7.5625 | 7.5 | 7.5625 | 84700.0 |
| 2000-09-18 | ACGL | Stock | 1.6944 | 1.6944 | 1.6944 | 1.6944 | 2700.0 |
| 2000-09-18 | ACGN-DELISTED | Stock | 963.3288 | 1097.9688 | 963.3288 | 1020.0 | 106300.0 |
| 2000-09-18 | ACH | Stock | 10.5 | 10.5417 | 10.2083 | 10.2083 | 92250.0 |
| 2000-09-18 | ACLS | Stock | 63.75 | 65.75 | 60.0 | 60.0 | 81150.0 |
| 2000-09-18 | ACO-DELISTED | Stock | 4.0 | 4.75 | 4.0 | 4.1875 | 406100.0 |
| 2000-09-18 | ACPW-DELISTED | Stock | 367.81 | 371.88 | 337.5 | 350.31 | 81940.0 |
| 2000-09-18 | ACS-DELISTED | Stock | 22.4375 | 22.4375 | 21.6875 | 21.9063 | 271900.0 |
| 2000-09-18 | ACTA-DELISTED | Stock | 602.5 | 605.0 | 542.5 | 546.25 | 211500.0 |
| 2000-09-18 | ACTT-DELISTED | Stock | 6.25 | 6.875 | 6.25 | 6.875 | 30500.0 |
| 2000-09-18 | ACTU-DELISTED | Stock | 27.41 | 27.5 | 26.75 | 27.25 | 337600.0 |
| 2000-09-18 | ACXM-DELISTED | Stock | 29.88 | 29.94 | 29.19 | 29.19 | 523200.0 |
| 2000-09-18 | ACY-DELISTED | Stock | 6.06 | 6.06 | 6.06 | 6.06 | 100.0 |
| 2000-09-18 | AD | Stock | 50.0 | 50.5833 | 49.9583 | 50.3333 | 273450.0 |
| 2000-09-18 | ADAT-DELISTED | Stock | 94.5 | 95.06 | 90.0 | 90.56 | 4300.0 |
| 2000-09-18 | ADBE | Stock | 33.5781 | 35.875 | 33.5 | 35.5 | 15124400.0 |
| 2000-09-18 | ADC | Stock | 15.9375 | 16.0 | 15.75 | 15.75 | 6400.0 |
| 2000-09-18 | ADEP-DELISTED | Stock | 269.06 | 274.37 | 240.0 | 246.88 | 31400.0 |
| 2000-09-18 | ADGF-DELISTED | Stock | 1.42 | 1.47 | 1.28 | 1.28 | 22400.0 |
| 2000-09-18 | ADI | Stock | 91.25 | 91.5 | 83.0 | 83.0 | 3824000.0 |
> showing 50 of 2,839 rows — these rows as CSV