PREVIEW / stock_daily / 2001-11-09
file: by_date/stock_daily/2001/2001-11-09.parquet size: 101 KB rows: 2,986 symbols: 1,849
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-11-09 | AAPL | Stock | 0.3321 | 0.3438 | 0.3313 | 0.3341 | 134293600.0 |
| 2001-11-09 | MSFT | Stock | 32.17 | 32.825 | 31.955 | 32.605 | 48013600.0 |
| 2001-11-09 | NVDA | Stock | 0.4329 | 0.4437 | 0.4249 | 0.4433 | 2270484000.0 |
| 2001-11-09 | AMZN | Stock | 0.3525 | 0.361 | 0.3485 | 0.356 | 88008000.0 |
| 2001-11-09 | CL | Stock | 29.0 | 29.05 | 28.6 | 28.68 | 3119200.0 |
| 2001-11-09 | A | Stock | 17.4535 | 17.8398 | 17.382 | 17.7396 | 1310206.0 |
| 2001-11-09 | AABA-DELISTED | Stock | 6.6100001335144 | 6.88500022888184 | 6.4850001335144 | 6.8600001335144 | 18362800.0 |
| 2001-11-09 | AAI-DELISTED | Stock | 5.07 | 5.23 | 4.96 | 5.21 | 549600.0 |
| 2001-11-09 | AAIC-DELISTED | Stock | 97.0 | 100.8 | 90.0 | 99.6 | 1138100.0 |
| 2001-11-09 | AAME | Stock | 2.02 | 2.11 | 2.01 | 2.11 | 36300.0 |
| 2001-11-09 | AAON | Stock | 1.5978 | 1.6022 | 1.5715 | 1.6022 | 30755.0 |
| 2001-11-09 | AAXN-DELISTED | Stock | 0.884999990463257 | 0.9375 | 0.870833337306976 | 0.933333337306976 | 730800.0 |
| 2001-11-09 | ABAX-DELISTED | Stock | 4.26 | 4.26 | 4.0 | 4.24 | 6800.0 |
| 2001-11-09 | ABB-DELISTED | Stock | 9.6 | 9.83 | 9.5 | 9.83 | 84200.0 |
| 2001-11-09 | ABC-DELISTED | Stock | 14.38 | 14.38 | 13.46 | 13.9 | 29019200.0 |
| 2001-11-09 | ABCB | Stock | 10.1317 | 10.1317 | 10.1317 | 10.1317 | 15422.0 |
| 2001-11-09 | ABCW-DELISTED | Stock | 15.69 | 15.8 | 15.68 | 15.75 | 23400.0 |
| 2001-11-09 | ABE-DELISTED | Stock | 6.85 | 6.9 | 6.82 | 6.88 | 23700.0 |
| 2001-11-09 | ABFS-DELISTED | Stock | 25.4 | 25.71 | 25.2 | 25.44 | 243500.0 |
| 2001-11-09 | ABK-DELISTED | Stock | 51.95 | 52.25 | 50.8 | 50.99 | 545500.0 |
| 2001-11-09 | ABM | Stock | 14.3 | 14.55 | 14.29 | 14.515 | 118400.0 |
| 2001-11-09 | ABMD-DELISTED | Stock | 21.72 | 22.26 | 21.4 | 21.75 | 68600.0 |
| 2001-11-09 | ABP-DELISTED | Stock | 1.55 | 1.55 | 1.45 | 1.51 | 84000.0 |
| 2001-11-09 | ABT | Stock | 24.0297 | 24.1464 | 23.7469 | 23.8815 | 5750044.0 |
| 2001-11-09 | ABTL-DELISTED | Stock | 6.75 | 7.5 | 6.0 | 7.35 | 382600.0 |
| 2001-11-09 | ABV-DELISTED | Stock | 18.15 | 18.8 | 18.15 | 18.45 | 309000.0 |
| 2001-11-09 | ABX-DELISTED | Stock | 15.6 | 15.77 | 15.43 | 15.71 | 880400.0 |
| 2001-11-09 | ACAP-DELISTED | Stock | 16.28 | 16.95 | 15.56 | 15.82 | 387200.0 |
| 2001-11-09 | ACAS-DELISTED | Stock | 27.33 | 28.27 | 26.71 | 27.5 | 256200.0 |
| 2001-11-09 | ACAT-DELISTED | Stock | 15.66 | 15.66 | 15.22 | 15.31 | 6500.0 |
| 2001-11-09 | ACCL-DELISTED | Stock | 9.76828002929688 | 9.86242008209229 | 9.76828002929688 | 9.86242008209229 | 146800.0 |
| 2001-11-09 | ACE-DELISTED | Stock | 36.73 | 37.28 | 36.43 | 36.78 | 2499866.0 |
| 2001-11-09 | ACF-DELISTED | Stock | 19.2 | 20.14 | 19.07 | 19.37 | 2792600.0 |
| 2001-11-09 | ACG-DELISTED | Stock | 8.89 | 8.89 | 8.8 | 8.87 | 452800.0 |
| 2001-11-09 | ACGL | Stock | 2.5667 | 2.5833 | 2.5556 | 2.5556 | 261900.0 |
| 2001-11-09 | ACGN-DELISTED | Stock | 1144.6712 | 1190.0 | 1133.3288 | 1190.0 | 12100.0 |
| 2001-11-09 | ACH | Stock | 12.2933 | 12.2933 | 12.0067 | 12.1667 | 169200.0 |
| 2001-11-09 | ACLS | Stock | 54.48 | 55.2 | 49.4 | 51.2 | 268575.0 |
| 2001-11-09 | ACO-DELISTED | Stock | 5.79 | 5.79 | 5.6 | 5.68 | 31800.0 |
| 2001-11-09 | ACPW-DELISTED | Stock | 30.0 | 30.25 | 27.65 | 27.65 | 59820.0 |
| 2001-11-09 | ACS-DELISTED | Stock | 44.575 | 44.605 | 43.65 | 44.05 | 560300.0 |
| 2001-11-09 | ACTA-DELISTED | Stock | 25.2 | 25.4 | 21.4 | 22.0 | 157500.0 |
| 2001-11-09 | ACTT-DELISTED | Stock | 10.44 | 10.44 | 9.83 | 10.4 | 85700.0 |
| 2001-11-09 | ACTU-DELISTED | Stock | 5.34 | 6.07 | 5.34 | 5.58 | 176900.0 |
| 2001-11-09 | ACXM-DELISTED | Stock | 12.33 | 12.64 | 12.14 | 12.21 | 259600.0 |
| 2001-11-09 | ACY-DELISTED | Stock | 5.2 | 5.2 | 5.2 | 5.2 | 300.0 |
| 2001-11-09 | AD | Stock | 29.3333 | 29.6667 | 29.3333 | 29.3667 | 172650.0 |
| 2001-11-09 | ADAT-DELISTED | Stock | 80.46 | 82.26 | 74.7 | 80.1 | 1657.0 |
| 2001-11-09 | ADBE | Stock | 14.425 | 14.785 | 14.125 | 14.395 | 6453400.0 |
| 2001-11-09 | ADC | Stock | 19.65 | 19.66 | 19.0 | 19.5 | 14200.0 |
> showing 50 of 2,986 rows — these rows as CSV