PREVIEW / stock_daily / 2001-10-25
file: by_date/stock_daily/2001/2001-10-25.parquet size: 100 KB rows: 2,967 symbols: 1,833
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-25 | AAPL | Stock | 0.3293 | 0.3438 | 0.3243 | 0.3427 | 254951200.0 |
| 2001-10-25 | MSFT | Stock | 30.305 | 31.3 | 29.785 | 31.28 | 75318200.0 |
| 2001-10-25 | NVDA | Stock | 0.3792 | 0.4178 | 0.3733 | 0.4109 | 1152396000.0 |
| 2001-10-25 | AMZN | Stock | 0.3695 | 0.389 | 0.3575 | 0.3885 | 185356000.0 |
| 2001-10-25 | CL | Stock | 29.12 | 29.49 | 28.575 | 29.45 | 2259200.0 |
| 2001-10-25 | A | Stock | 16.8097 | 17.2604 | 15.9514 | 17.2604 | 2410571.0 |
| 2001-10-25 | AABA-DELISTED | Stock | 5.7350001335144 | 6.15999984741211 | 5.58500003814697 | 6.125 | 20753600.0 |
| 2001-10-25 | AAI-DELISTED | Stock | 3.75 | 3.95 | 3.75 | 3.95 | 715000.0 |
| 2001-10-25 | AAIC-DELISTED | Stock | 107.0 | 107.0 | 99.0 | 102.0 | 32200.0 |
| 2001-10-25 | AAME | Stock | 1.44 | 1.44 | 1.44 | 1.44 | 800.0 |
| 2001-10-25 | AAON | Stock | 1.4486 | 1.5144 | 1.4055 | 1.4538 | 511439.0 |
| 2001-10-25 | AAXN-DELISTED | Stock | 0.847500026226044 | 0.866666674613953 | 0.829999983310699 | 0.833333313465118 | 646800.0 |
| 2001-10-25 | ABAX-DELISTED | Stock | 3.8985 | 3.95 | 3.77 | 3.9 | 11300.0 |
| 2001-10-25 | ABB-DELISTED | Stock | 8.0 | 8.06 | 7.8 | 7.93 | 43800.0 |
| 2001-10-25 | ABC-DELISTED | Stock | 16.71 | 17.2 | 16.67 | 17.19 | 4948800.0 |
| 2001-10-25 | ABCB | Stock | 9.9777 | 9.9777 | 9.9777 | 9.9777 | 1234.0 |
| 2001-10-25 | ABCW-DELISTED | Stock | 16.02 | 16.57 | 15.86 | 16.56 | 31900.0 |
| 2001-10-25 | ABE-DELISTED | Stock | 6.45 | 6.46 | 6.41 | 6.45 | 23100.0 |
| 2001-10-25 | ABFS-DELISTED | Stock | 23.15 | 23.18 | 22.7 | 22.97 | 220800.0 |
| 2001-10-25 | ABK-DELISTED | Stock | 49.5 | 49.95 | 49.05 | 49.71 | 472700.0 |
| 2001-10-25 | ABM | Stock | 12.95 | 12.975 | 12.705 | 12.91 | 201000.0 |
| 2001-10-25 | ABMD-DELISTED | Stock | 22.69 | 23.3 | 21.45 | 23.15 | 368800.0 |
| 2001-10-25 | ABP-DELISTED | Stock | 1.55 | 1.68 | 1.51 | 1.65 | 43900.0 |
| 2001-10-25 | ABT | Stock | 24.1464 | 24.6447 | 23.9085 | 24.4875 | 7132309.0 |
| 2001-10-25 | ABTL-DELISTED | Stock | 6.7 | 6.7 | 6.0 | 6.25 | 61400.0 |
| 2001-10-25 | ABV-DELISTED | Stock | 15.7 | 15.98 | 15.53 | 15.88 | 549900.0 |
| 2001-10-25 | ABX-DELISTED | Stock | 15.7 | 16.33 | 15.7 | 16.04 | 1997800.0 |
| 2001-10-25 | ACAP-DELISTED | Stock | 22.9 | 23.48 | 22.89 | 23.19 | 67600.0 |
| 2001-10-25 | ACAS-DELISTED | Stock | 26.11 | 26.85 | 25.65 | 26.73 | 138500.0 |
| 2001-10-25 | ACAT-DELISTED | Stock | 14.5 | 15.1 | 14.5 | 15.0 | 23100.0 |
| 2001-10-25 | ACCL-DELISTED | Stock | 11.7306003570557 | 11.7306003570557 | 11.7089004516602 | 11.7306003570557 | 135100.0 |
| 2001-10-25 | ACE-DELISTED | Stock | 34.9 | 36.15 | 34.61 | 35.41 | 3584400.0 |
| 2001-10-25 | ACF-DELISTED | Stock | 20.0 | 20.01 | 18.22 | 19.1 | 4636300.0 |
| 2001-10-25 | ACG-DELISTED | Stock | 8.59 | 8.62 | 8.56 | 8.59 | 242200.0 |
| 2001-10-25 | ACGL | Stock | 2.6644 | 2.86 | 2.5333 | 2.6667 | 1359000.0 |
| 2001-10-25 | ACGN-DELISTED | Stock | 1235.3288 | 1269.3288 | 1201.3288 | 1269.3288 | 25000.0 |
| 2001-10-25 | ACH | Stock | 11.9 | 12.1867 | 11.74 | 12.0133 | 146250.0 |
| 2001-10-25 | ACLS | Stock | 44.6 | 53.52 | 43.64 | 51.48 | 570000.0 |
| 2001-10-25 | ACO-DELISTED | Stock | 5.65 | 5.95 | 5.65 | 5.8 | 4200.0 |
| 2001-10-25 | ACPW-DELISTED | Stock | 27.2 | 27.35 | 24.15 | 26.5 | 50120.0 |
| 2001-10-25 | ACS-DELISTED | Stock | 45.8 | 46.375 | 45.3 | 46.145 | 398600.0 |
| 2001-10-25 | ACTA-DELISTED | Stock | 14.0 | 14.6 | 12.8 | 14.6 | 76800.0 |
| 2001-10-25 | ACTT-DELISTED | Stock | 10.49 | 11.24 | 9.75 | 11.01 | 370600.0 |
| 2001-10-25 | ACTU-DELISTED | Stock | 4.28 | 4.35 | 3.88 | 4.03 | 908800.0 |
| 2001-10-25 | ACXM-DELISTED | Stock | 13.02 | 13.1 | 12.5 | 12.95 | 569800.0 |
| 2001-10-25 | AD | Stock | 29.5333 | 30.1 | 29.2667 | 30.0 | 179850.0 |
| 2001-10-25 | ADAT-DELISTED | Stock | 64.98 | 68.4 | 64.98 | 68.4 | 378.0 |
| 2001-10-25 | ADBE | Stock | 16.31 | 16.86 | 15.775 | 16.515 | 13962800.0 |
| 2001-10-25 | ADC | Stock | 18.85 | 18.98 | 18.75 | 18.85 | 3800.0 |
| 2001-10-25 | ADEP-DELISTED | Stock | 20.15 | 20.45 | 17.5 | 19.25 | 48500.0 |
> showing 50 of 2,967 rows — these rows as CSV