PREVIEW / stock_daily / 2001-10-17
file: by_date/stock_daily/2001/2001-10-17.parquet size: 101 KB rows: 2,979 symbols: 1,851
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-17 | AAPL | Stock | 0.3275 | 0.3288 | 0.3029 | 0.3034 | 285538400.0 |
| 2001-10-17 | MSFT | Stock | 29.56 | 29.65 | 27.99 | 28.015 | 73710600.0 |
| 2001-10-17 | NVDA | Stock | 0.3773 | 0.3775 | 0.3458 | 0.3475 | 1695540000.0 |
| 2001-10-17 | AMZN | Stock | 0.499 | 0.4995 | 0.4425 | 0.446 | 178890000.0 |
| 2001-10-17 | CL | Stock | 28.65 | 28.655 | 28.125 | 28.385 | 3006800.0 |
| 2001-10-17 | A | Stock | 17.525 | 17.7325 | 16.5236 | 16.8956 | 2791806.0 |
| 2001-10-17 | AABA-DELISTED | Stock | 6.5149998664856 | 6.59000015258789 | 5.65500020980835 | 5.67999982833862 | 23678200.0 |
| 2001-10-17 | AAI-DELISTED | Stock | 4.2 | 4.28 | 4.03 | 4.04 | 258600.0 |
| 2001-10-17 | AAIC-DELISTED | Stock | 114.8 | 114.8 | 110.0 | 110.0 | 50500.0 |
| 2001-10-17 | AAME | Stock | 1.32 | 1.47 | 1.32 | 1.47 | 15200.0 |
| 2001-10-17 | AAON | Stock | 1.5934 | 1.6022 | 1.4933 | 1.5056 | 701662.0 |
| 2001-10-17 | AAXN-DELISTED | Stock | 0.881666660308838 | 0.885833323001862 | 0.834166646003723 | 0.834999978542328 | 306000.0 |
| 2001-10-17 | ABAX-DELISTED | Stock | 3.95 | 3.95 | 3.87 | 3.95 | 9500.0 |
| 2001-10-17 | ABB-DELISTED | Stock | 7.21 | 7.25 | 7.1 | 7.1 | 15300.0 |
| 2001-10-17 | ABC-DELISTED | Stock | 17.5 | 17.65 | 17.22 | 17.41 | 3532800.0 |
| 2001-10-17 | ABCB | Stock | 10.537 | 10.5856 | 10.4559 | 10.4559 | 37013.0 |
| 2001-10-17 | ABCW-DELISTED | Stock | 16.0 | 16.0 | 15.47 | 15.52 | 31900.0 |
| 2001-10-17 | ABE-DELISTED | Stock | 6.5 | 6.55 | 6.5 | 6.52 | 26800.0 |
| 2001-10-17 | ABFS-DELISTED | Stock | 22.85 | 23.35 | 21.83 | 22.35 | 160900.0 |
| 2001-10-17 | ABK-DELISTED | Stock | 53.85 | 53.85 | 50.55 | 51.11 | 958400.0 |
| 2001-10-17 | ABM | Stock | 13.5 | 13.5 | 13.13 | 13.15 | 69000.0 |
| 2001-10-17 | ABMD-DELISTED | Stock | 19.5 | 19.6 | 18.3 | 18.67 | 105700.0 |
| 2001-10-17 | ABP-DELISTED | Stock | 1.73 | 1.75 | 1.65 | 1.66 | 26100.0 |
| 2001-10-17 | ABT | Stock | 23.8142 | 23.9713 | 23.6526 | 23.8905 | 6114490.0 |
| 2001-10-17 | ABTL-DELISTED | Stock | 5.25 | 6.3 | 5.1 | 5.1 | 192000.0 |
| 2001-10-17 | ABV-DELISTED | Stock | 15.95 | 16.15 | 15.85 | 15.85 | 249600.0 |
| 2001-10-17 | ABX-DELISTED | Stock | 16.59 | 17.0 | 16.34 | 16.92 | 1945500.0 |
| 2001-10-17 | ACAP-DELISTED | Stock | 22.05 | 22.35 | 22.0 | 22.18 | 12600.0 |
| 2001-10-17 | ACAS-DELISTED | Stock | 26.54 | 27.02 | 26.42 | 26.95 | 133813.0 |
| 2001-10-17 | ACAT-DELISTED | Stock | 14.085 | 14.085 | 13.94 | 14.01 | 28000.0 |
| 2001-10-17 | ACCL-DELISTED | Stock | 11.3199996948242 | 11.6219997406006 | 10.5 | 10.5290002822876 | 123200.0 |
| 2001-10-17 | ACE-DELISTED | Stock | 39.02 | 39.2 | 37.41 | 38.14 | 2661800.0 |
| 2001-10-17 | ACF-DELISTED | Stock | 26.95 | 26.95 | 23.8 | 24.01 | 2889200.0 |
| 2001-10-17 | ACG-DELISTED | Stock | 8.6 | 8.6 | 8.49 | 8.51 | 302300.0 |
| 2001-10-17 | ACGL | Stock | 1.8611 | 1.8622 | 1.8611 | 1.8622 | 34200.0 |
| 2001-10-17 | ACGN-DELISTED | Stock | 1008.6712 | 1076.6712 | 986.0 | 1076.6712 | 23000.0 |
| 2001-10-17 | ACH | Stock | 12.7333 | 12.8333 | 11.34 | 12.2667 | 867150.0 |
| 2001-10-17 | ACLS | Stock | 44.12 | 45.8 | 41.4 | 42.0 | 166600.0 |
| 2001-10-17 | ACO-DELISTED | Stock | 5.54 | 5.7 | 5.54 | 5.63 | 106200.0 |
| 2001-10-17 | ACPW-DELISTED | Stock | 27.25 | 27.9 | 26.7 | 26.7 | 56740.0 |
| 2001-10-17 | ACS-DELISTED | Stock | 45.75 | 46.245 | 45.045 | 45.685 | 824600.0 |
| 2001-10-17 | ACTA-DELISTED | Stock | 17.0 | 19.0 | 16.4 | 17.6 | 279400.0 |
| 2001-10-17 | ACTT-DELISTED | Stock | 9.2 | 10.12 | 8.55 | 9.3 | 351000.0 |
| 2001-10-17 | ACTU-DELISTED | Stock | 6.6 | 6.6 | 3.99 | 4.55 | 3754100.0 |
| 2001-10-17 | ACXM-DELISTED | Stock | 13.56 | 13.56 | 12.15 | 12.17 | 867400.0 |
| 2001-10-17 | ACY-DELISTED | Stock | 5.55 | 5.55 | 5.55 | 5.55 | 2600.0 |
| 2001-10-17 | AD | Stock | 28.0533 | 29.5 | 27.96 | 29.0067 | 391200.0 |
| 2001-10-17 | ADAT-DELISTED | Stock | 78.3 | 78.3 | 72.54 | 78.3 | 979.0 |
| 2001-10-17 | ADBE | Stock | 16.04 | 16.05 | 14.335 | 14.39 | 7573600.0 |
| 2001-10-17 | ADC | Stock | 18.75 | 18.9 | 18.51 | 18.9 | 8000.0 |
> showing 50 of 2,979 rows — these rows as CSV