PREVIEW / stock_daily / 2001-10-29
file: by_date/stock_daily/2001/2001-10-29.parquet size: 102 KB rows: 3,009 symbols: 1,871
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-29 | AAPL | Stock | 0.3316 | 0.3334 | 0.3143 | 0.3148 | 239181600.0 |
| 2001-10-29 | MSFT | Stock | 31.05 | 31.1 | 29.77 | 29.82 | 55129400.0 |
| 2001-10-29 | NVDA | Stock | 0.3829 | 0.3896 | 0.3502 | 0.3506 | 1004796000.0 |
| 2001-10-29 | AMZN | Stock | 0.3805 | 0.383 | 0.352 | 0.3525 | 103236000.0 |
| 2001-10-29 | CL | Stock | 29.2 | 29.22 | 28.445 | 28.81 | 4116000.0 |
| 2001-10-29 | A | Stock | 17.0672 | 17.0744 | 16.1373 | 16.402 | 1727089.0 |
| 2001-10-29 | AABA-DELISTED | Stock | 5.97499990463257 | 6.07499980926514 | 5.64499998092651 | 5.65000009536743 | 14799000.0 |
| 2001-10-29 | AAI-DELISTED | Stock | 3.89 | 3.9 | 3.7 | 3.71 | 287500.0 |
| 2001-10-29 | AAIC-DELISTED | Stock | 104.0 | 104.0 | 100.0 | 100.0 | 45400.0 |
| 2001-10-29 | AAME | Stock | 1.51 | 1.54 | 1.5 | 1.5 | 35900.0 |
| 2001-10-29 | AAON | Stock | 1.4854 | 1.5539 | 1.4529 | 1.4705 | 190223.0 |
| 2001-10-29 | AAXN-DELISTED | Stock | 0.823333323001862 | 0.823333323001862 | 0.766666650772095 | 0.779166638851166 | 240000.0 |
| 2001-10-29 | ABAX-DELISTED | Stock | 3.65 | 3.75 | 3.5 | 3.57 | 16900.0 |
| 2001-10-29 | ABB-DELISTED | Stock | 9.1 | 9.1 | 8.61 | 8.68 | 34300.0 |
| 2001-10-29 | ABC-DELISTED | Stock | 16.66 | 17.03 | 16.46 | 16.52 | 6330000.0 |
| 2001-10-29 | ABCB | Stock | 10.3424 | 10.3424 | 10.3343 | 10.3343 | 3456.0 |
| 2001-10-29 | ABCW-DELISTED | Stock | 16.36 | 16.44 | 15.7 | 15.89 | 23800.0 |
| 2001-10-29 | ABE-DELISTED | Stock | 6.48 | 6.52 | 6.45 | 6.5 | 29500.0 |
| 2001-10-29 | ABFS-DELISTED | Stock | 23.25 | 23.7 | 23.25 | 23.36 | 86900.0 |
| 2001-10-29 | ABK-DELISTED | Stock | 49.8 | 49.8 | 48.8 | 48.83 | 429000.0 |
| 2001-10-29 | ABM | Stock | 12.8 | 13.185 | 12.7 | 13.185 | 272800.0 |
| 2001-10-29 | ABMD-DELISTED | Stock | 22.75 | 22.75 | 21.1 | 21.49 | 85800.0 |
| 2001-10-29 | ABP-DELISTED | Stock | 1.58 | 1.67 | 1.58 | 1.63 | 34600.0 |
| 2001-10-29 | ABT | Stock | 24.3978 | 24.4651 | 24.2002 | 24.2541 | 6902192.0 |
| 2001-10-29 | ABTL-DELISTED | Stock | 5.9 | 6.15 | 5.5 | 5.95 | 8700.0 |
| 2001-10-29 | ABV-DELISTED | Stock | 16.46 | 16.73 | 16.2 | 16.25 | 979100.0 |
| 2001-10-29 | ABX-DELISTED | Stock | 15.85 | 16.02 | 15.73 | 15.8 | 1391300.0 |
| 2001-10-29 | ACAP-DELISTED | Stock | 22.92 | 23.11 | 22.72 | 22.74 | 8700.0 |
| 2001-10-29 | ACAS-DELISTED | Stock | 27.0 | 27.01 | 26.75 | 26.76 | 80900.0 |
| 2001-10-29 | ACAT-DELISTED | Stock | 15.94 | 15.94 | 15.0 | 15.12 | 37900.0 |
| 2001-10-29 | ACCL-DELISTED | Stock | 11.8899002075195 | 12.3027000427246 | 11.8899002075195 | 12.3027000427246 | 351200.0 |
| 2001-10-29 | ACE-DELISTED | Stock | 37.9 | 37.9 | 36.26 | 36.6 | 1709300.0 |
| 2001-10-29 | ACF-DELISTED | Stock | 18.21 | 18.22 | 17.18 | 17.34 | 2527600.0 |
| 2001-10-29 | ACG-DELISTED | Stock | 8.63 | 8.67 | 8.62 | 8.64 | 238600.0 |
| 2001-10-29 | ACGL | Stock | 2.6656 | 2.68 | 2.6111 | 2.6111 | 315000.0 |
| 2001-10-29 | ACGN-DELISTED | Stock | 1167.3288 | 1246.6712 | 1144.6712 | 1224.0 | 49400.0 |
| 2001-10-29 | ACH | Stock | 11.9 | 12.1667 | 11.9 | 12.04 | 69600.0 |
| 2001-10-29 | ACLS | Stock | 51.44 | 53.04 | 49.68 | 50.04 | 255100.0 |
| 2001-10-29 | ACO-DELISTED | Stock | 5.65 | 5.83 | 5.65 | 5.75 | 47000.0 |
| 2001-10-29 | ACPW-DELISTED | Stock | 27.25 | 28.5 | 26.5 | 26.5 | 20340.0 |
| 2001-10-29 | ACS-DELISTED | Stock | 46.35 | 46.5 | 45.8 | 45.95 | 254800.0 |
| 2001-10-29 | ACTA-DELISTED | Stock | 14.4 | 16.0 | 14.2 | 14.4 | 87200.0 |
| 2001-10-29 | ACTT-DELISTED | Stock | 10.75 | 10.95 | 9.56 | 10.9 | 225500.0 |
| 2001-10-29 | ACTU-DELISTED | Stock | 3.96 | 4.05 | 3.62 | 3.75 | 274500.0 |
| 2001-10-29 | ACXM-DELISTED | Stock | 13.03 | 13.05 | 12.4 | 12.42 | 765200.0 |
| 2001-10-29 | ACY-DELISTED | Stock | 5.4 | 5.4 | 5.4 | 5.4 | 400.0 |
| 2001-10-29 | AD | Stock | 30.4667 | 30.4667 | 29.0 | 29.0 | 181800.0 |
| 2001-10-29 | ADAT-DELISTED | Stock | 65.7 | 73.62 | 65.16 | 73.62 | 1759.0 |
| 2001-10-29 | ADBE | Stock | 16.25 | 16.265 | 15.145 | 15.17 | 8029800.0 |
| 2001-10-29 | ADC | Stock | 18.99 | 18.99 | 18.81 | 18.81 | 1800.0 |
> showing 50 of 3,009 rows — these rows as CSV