PREVIEW / stock_daily / 2001-10-30
file: by_date/stock_daily/2001/2001-10-30.parquet size: 102 KB rows: 2,998 symbols: 1,861
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-30 | AAPL | Stock | 0.3104 | 0.3214 | 0.3046 | 0.3143 | 276763200.0 |
| 2001-10-30 | MSFT | Stock | 29.46 | 29.77 | 29.095 | 29.44 | 57395600.0 |
| 2001-10-30 | NVDA | Stock | 0.3442 | 0.3662 | 0.3362 | 0.35 | 1153380000.0 |
| 2001-10-30 | AMZN | Stock | 0.3505 | 0.3515 | 0.316 | 0.321 | 201110000.0 |
| 2001-10-30 | CL | Stock | 28.375 | 29.05 | 28.375 | 28.89 | 2209800.0 |
| 2001-10-30 | A | Stock | 16.309 | 16.4521 | 15.7725 | 15.8798 | 1923368.0 |
| 2001-10-30 | AABA-DELISTED | Stock | 5.51999998092651 | 5.71000003814697 | 5.30999994277954 | 5.54500007629395 | 14171600.0 |
| 2001-10-30 | AAI-DELISTED | Stock | 3.73 | 3.73 | 3.5 | 3.55 | 268200.0 |
| 2001-10-30 | AAIC-DELISTED | Stock | 101.0 | 102.0 | 97.0 | 99.0 | 22100.0 |
| 2001-10-30 | AAME | Stock | 1.37 | 1.5 | 1.3 | 1.3 | 15700.0 |
| 2001-10-30 | AAON | Stock | 1.4925 | 1.4925 | 1.4582 | 1.4925 | 138966.0 |
| 2001-10-30 | AAXN-DELISTED | Stock | 0.769999980926514 | 0.795833349227905 | 0.75 | 0.790000021457672 | 717600.0 |
| 2001-10-30 | ABAX-DELISTED | Stock | 3.6887 | 3.82 | 3.48 | 3.75 | 10900.0 |
| 2001-10-30 | ABB-DELISTED | Stock | 8.4 | 8.46 | 8.21 | 8.33 | 20600.0 |
| 2001-10-30 | ABC-DELISTED | Stock | 16.2 | 16.24 | 15.75 | 15.75 | 6749200.0 |
| 2001-10-30 | ABCB | Stock | 10.3343 | 10.5289 | 10.3343 | 10.3829 | 9869.0 |
| 2001-10-30 | ABCW-DELISTED | Stock | 15.9 | 16.07 | 15.7 | 15.95 | 16400.0 |
| 2001-10-30 | ABE-DELISTED | Stock | 6.45 | 6.45 | 6.33 | 6.4 | 45100.0 |
| 2001-10-30 | ABFS-DELISTED | Stock | 23.35 | 23.35 | 22.88 | 23.07 | 30800.0 |
| 2001-10-30 | ABK-DELISTED | Stock | 48.75 | 49.18 | 47.02 | 48.54 | 383700.0 |
| 2001-10-30 | ABM | Stock | 13.085 | 13.515 | 12.76 | 13.5 | 168000.0 |
| 2001-10-30 | ABMD-DELISTED | Stock | 21.14 | 21.49 | 20.2326 | 20.41 | 89100.0 |
| 2001-10-30 | ABP-DELISTED | Stock | 1.69 | 1.69 | 1.56 | 1.57 | 32100.0 |
| 2001-10-30 | ABT | Stock | 24.3304 | 24.3439 | 24.1284 | 24.1419 | 7619722.0 |
| 2001-10-30 | ABTL-DELISTED | Stock | 5.6 | 6.15 | 5.6 | 6.1 | 4300.0 |
| 2001-10-30 | ABV-DELISTED | Stock | 16.4 | 16.4 | 15.5 | 15.74 | 545800.0 |
| 2001-10-30 | ABX-DELISTED | Stock | 15.88 | 16.23 | 15.8 | 15.81 | 5075191.0 |
| 2001-10-30 | ACAP-DELISTED | Stock | 22.62 | 22.62 | 21.92 | 22.25 | 11800.0 |
| 2001-10-30 | ACAS-DELISTED | Stock | 26.85 | 26.95 | 26.32 | 26.9 | 172000.0 |
| 2001-10-30 | ACAT-DELISTED | Stock | 15.0 | 15.5 | 14.93 | 15.4 | 20000.0 |
| 2001-10-30 | ACCL-DELISTED | Stock | 12.1599998474121 | 12.164999961853 | 11.4479999542236 | 11.5860004425049 | 246900.0 |
| 2001-10-30 | ACE-DELISTED | Stock | 36.45 | 37.19 | 35.7 | 36.8 | 2716000.0 |
| 2001-10-30 | ACF-DELISTED | Stock | 17.26 | 17.26 | 16.1 | 16.15 | 3549200.0 |
| 2001-10-30 | ACG-DELISTED | Stock | 8.61 | 8.65 | 8.6 | 8.64 | 221700.0 |
| 2001-10-30 | ACGL | Stock | 2.6111 | 2.6556 | 2.5833 | 2.5889 | 69300.0 |
| 2001-10-30 | ACGN-DELISTED | Stock | 1156.0 | 1224.0 | 1144.6712 | 1167.3288 | 25600.0 |
| 2001-10-30 | ACH | Stock | 12.0067 | 12.1533 | 11.7733 | 12.0733 | 56400.0 |
| 2001-10-30 | ACLS | Stock | 49.6 | 50.2 | 46.52 | 48.4 | 189225.0 |
| 2001-10-30 | ACO-DELISTED | Stock | 5.77 | 5.77 | 5.63 | 5.7 | 16500.0 |
| 2001-10-30 | ACPW-DELISTED | Stock | 25.9 | 26.1 | 24.45 | 25.3 | 37422.0 |
| 2001-10-30 | ACS-DELISTED | Stock | 45.4 | 45.535 | 44.425 | 45.3 | 472100.0 |
| 2001-10-30 | ACTA-DELISTED | Stock | 14.2 | 15.8 | 14.0 | 15.6 | 108600.0 |
| 2001-10-30 | ACTT-DELISTED | Stock | 10.9 | 10.9 | 9.85 | 10.0 | 92700.0 |
| 2001-10-30 | ACTU-DELISTED | Stock | 3.74 | 4.15 | 3.66 | 4.11 | 496300.0 |
| 2001-10-30 | ACXM-DELISTED | Stock | 12.5 | 12.5 | 11.56 | 11.8 | 903200.0 |
| 2001-10-30 | ACY-DELISTED | Stock | 5.4 | 5.45 | 5.4 | 5.45 | 400.0 |
| 2001-10-30 | AD | Stock | 29.0 | 29.3 | 28.5533 | 28.6667 | 208200.0 |
| 2001-10-30 | ADAT-DELISTED | Stock | 75.42 | 75.42 | 66.6 | 69.3 | 1448.0 |
| 2001-10-30 | ADBE | Stock | 14.99 | 15.435 | 14.285 | 14.375 | 9805200.0 |
| 2001-10-30 | ADC | Stock | 18.91 | 18.98 | 18.86 | 18.86 | 4700.0 |
> showing 50 of 2,998 rows — these rows as CSV