PREVIEW / stock_daily / 2000-01-18
file: by_date/stock_daily/2000/2000-01-18.parquet size: 86 KB rows: 2,709 symbols: 1,688
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-18 | AAPL | Stock | 0.9018 | 0.9464 | 0.8968 | 0.928 | 459177600.0 |
| 2000-01-18 | MSFT | Stock | 55.9062 | 58.25 | 55.875 | 57.6562 | 81483600.0 |
| 2000-01-18 | NVDA | Stock | 0.0927 | 0.0958 | 0.0885 | 0.0954 | 261648000.0 |
| 2000-01-18 | AMZN | Stock | 3.1719 | 3.2594 | 3.15 | 3.2063 | 107698000.0 |
| 2000-01-18 | CL | Stock | 31.5312 | 31.8125 | 31.0312 | 31.5 | 2902000.0 |
| 2000-01-18 | A | Stock | 49.088 | 52.128 | 48.7303 | 51.1445 | 2101753.0 |
| 2000-01-18 | AABA-DELISTED | Stock | 85.4375 | 87.5 | 83.75 | 85.296875 | 30706000.0 |
| 2000-01-18 | AAI-DELISTED | Stock | 4.81 | 4.88 | 4.69 | 4.81 | 247900.0 |
| 2000-01-18 | AAIC-DELISTED | Stock | 172.5 | 173.75 | 160.0 | 170.0 | 136200.0 |
| 2000-01-18 | AAME | Stock | 2.4375 | 2.5 | 2.25 | 2.2812 | 8200.0 |
| 2000-01-18 | AAON | Stock | 0.8322 | 0.8487 | 0.8322 | 0.8377 | 220409.0 |
| 2000-01-18 | ABAX-DELISTED | Stock | 7.59375 | 8.5 | 7.4375 | 8.5 | 278000.0 |
| 2000-01-18 | ABC-DELISTED | Stock | 5.3125 | 5.484375 | 5.25 | 5.3125 | 3676400.0 |
| 2000-01-18 | ABCB | Stock | 8.46 | 8.5106 | 8.308 | 8.4093 | 22331.0 |
| 2000-01-18 | ABCW-DELISTED | Stock | 14.69 | 14.69 | 14.44 | 14.63 | 11900.0 |
| 2000-01-18 | ABE-DELISTED | Stock | 16.875 | 16.875 | 16.5 | 16.6875 | 25000.0 |
| 2000-01-18 | ABFS-DELISTED | Stock | 12.75 | 13.75 | 12.625 | 13.5 | 160900.0 |
| 2000-01-18 | ABK-DELISTED | Stock | 50.81 | 50.81 | 49.0 | 49.81 | 200500.0 |
| 2000-01-18 | ABM | Stock | 10.0625 | 10.0938 | 9.8438 | 9.9062 | 92800.0 |
| 2000-01-18 | ABMD-DELISTED | Stock | 22.5 | 26.0 | 22.5 | 26.0 | 198600.0 |
| 2000-01-18 | ABT | Stock | 15.1785 | 15.4871 | 14.8698 | 15.1504 | 11348831.0 |
| 2000-01-18 | ABTL-DELISTED | Stock | 63.13 | 63.44 | 58.13 | 60.31 | 151700.0 |
| 2000-01-18 | ABV-DELISTED | Stock | 14.94 | 15.12 | 14.88 | 14.94 | 279600.0 |
| 2000-01-18 | ABX-DELISTED | Stock | 17.282 | 17.72 | 17.156 | 17.532 | 2328454.0 |
| 2000-01-18 | ACAS-DELISTED | Stock | 24.71875 | 24.75 | 23.875 | 24.125 | 123900.0 |
| 2000-01-18 | ACAT-DELISTED | Stock | 9.9063 | 9.969 | 9.844 | 9.9687 | 66412.0 |
| 2000-01-18 | ACCL-DELISTED | Stock | 25.2900009155273 | 27.8780002593994 | 23.8959999084473 | 27.8780002593994 | 532900.0 |
| 2000-01-18 | ACE-DELISTED | Stock | 20.5 | 20.5 | 19.06 | 19.19 | 493600.0 |
| 2000-01-18 | ACF-DELISTED | Stock | 18.38 | 18.44 | 17.38 | 17.94 | 243100.0 |
| 2000-01-18 | ACG-DELISTED | Stock | 7.25 | 7.4375 | 7.1875 | 7.1875 | 428300.0 |
| 2000-01-18 | ACGN-DELISTED | Stock | 1416.6712 | 1770.8288 | 1416.6712 | 1770.8288 | 93300.0 |
| 2000-01-18 | ACH | Stock | 6.7917 | 6.7917 | 6.5417 | 6.5833 | 34800.0 |
| 2000-01-18 | ACO-DELISTED | Stock | 15.3125 | 15.75 | 15.3125 | 15.75 | 138800.0 |
| 2000-01-18 | ACS-DELISTED | Stock | 23.625 | 23.8125 | 23.0938 | 23.5 | 129900.0 |
| 2000-01-18 | ACTA-DELISTED | Stock | 2755.0 | 2900.0 | 2718.75 | 2775.0 | 164700.0 |
| 2000-01-18 | ACTT-DELISTED | Stock | 8.9688 | 9.625 | 8.75 | 9.125 | 22600.0 |
| 2000-01-18 | ACTU-DELISTED | Stock | 50.0 | 52.75 | 49.25 | 50.25 | 515800.0 |
| 2000-01-18 | ACXM-DELISTED | Stock | 26.0 | 27.0 | 25.75 | 26.94 | 482500.0 |
| 2000-01-18 | AD | Stock | 61.5 | 65.0 | 61.5 | 64.9583 | 981300.0 |
| 2000-01-18 | ADAT-DELISTED | Stock | 227.25 | 256.5 | 226.12 | 256.5 | 30900.0 |
| 2000-01-18 | ADBE | Stock | 16.2656 | 16.4688 | 16.0 | 16.0 | 5201600.0 |
| 2000-01-18 | ADC | Stock | 13.875 | 13.9375 | 13.5 | 13.5625 | 13800.0 |
| 2000-01-18 | ADEP-DELISTED | Stock | 31.41 | 34.38 | 31.25 | 34.38 | 13600.0 |
| 2000-01-18 | ADGF-DELISTED | Stock | 1.97 | 2.0 | 1.88 | 1.97 | 32800.0 |
| 2000-01-18 | ADI | Stock | 50.25 | 50.875 | 49.0312 | 49.25 | 1968800.0 |
| 2000-01-18 | ADM | Stock | 11.3946 | 12.0181 | 11.3946 | 11.8481 | 2991303.0 |
| 2000-01-18 | ADMP-DELISTED | Stock | 637.5 | 648.125 | 595.0 | 626.875 | 600.0 |
| 2000-01-18 | ADPI-DELISTED | Stock | 7.12 | 7.25 | 7.0 | 7.0 | 4700.0 |
| 2000-01-18 | ADSK | Stock | 7.4375 | 7.5 | 7.25 | 7.3281 | 1618000.0 |
| 2000-01-18 | ADTN | Stock | 29.8125 | 31.4375 | 29.8125 | 31.2969 | 1015800.0 |
> showing 50 of 2,709 rows — these rows as CSV