PREVIEW / stock_daily / 2001-10-23
file: by_date/stock_daily/2001/2001-10-23.parquet size: 101 KB rows: 2,982 symbols: 1,858
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-23 | AAPL | Stock | 0.3414 | 0.3468 | 0.3191 | 0.3239 | 684980800.0 |
| 2001-10-23 | MSFT | Stock | 30.235 | 30.72 | 29.7 | 30.215 | 80325000.0 |
| 2001-10-23 | NVDA | Stock | 0.3832 | 0.3901 | 0.3633 | 0.3717 | 953028000.0 |
| 2001-10-23 | AMZN | Stock | 0.4625 | 0.48 | 0.4425 | 0.4775 | 244528000.0 |
| 2001-10-23 | CL | Stock | 29.625 | 29.63 | 29.2 | 29.36 | 2969400.0 |
| 2001-10-23 | A | Stock | 16.8884 | 17.6323 | 16.8813 | 17.0601 | 1902259.0 |
| 2001-10-23 | AABA-DELISTED | Stock | 5.96500015258789 | 6.14499998092651 | 5.69999980926514 | 5.78999996185303 | 20593400.0 |
| 2001-10-23 | AAI-DELISTED | Stock | 4.07 | 4.07 | 3.85 | 3.95 | 332000.0 |
| 2001-10-23 | AAIC-DELISTED | Stock | 115.2 | 118.0 | 107.0 | 110.0 | 38500.0 |
| 2001-10-23 | AAON | Stock | 1.4486 | 1.4705 | 1.3221 | 1.4047 | 780258.0 |
| 2001-10-23 | AAXN-DELISTED | Stock | 0.876666665077209 | 0.922500014305115 | 0.8125 | 0.814999997615814 | 1377600.0 |
| 2001-10-23 | ABAX-DELISTED | Stock | 4.0 | 4.11 | 3.75 | 4.0 | 14100.0 |
| 2001-10-23 | ABB-DELISTED | Stock | 7.55 | 8.15 | 7.55 | 7.99 | 88500.0 |
| 2001-10-23 | ABC-DELISTED | Stock | 18.0 | 18.0 | 17.27 | 17.42 | 8092800.0 |
| 2001-10-23 | ABCB | Stock | 10.4559 | 10.537 | 9.929 | 9.929 | 5058.0 |
| 2001-10-23 | ABCW-DELISTED | Stock | 15.97 | 15.99 | 15.69 | 15.7 | 12200.0 |
| 2001-10-23 | ABE-DELISTED | Stock | 6.39 | 6.43 | 6.39 | 6.39 | 59000.0 |
| 2001-10-23 | ABFS-DELISTED | Stock | 23.09 | 23.71 | 22.85 | 22.96 | 277500.0 |
| 2001-10-23 | ABK-DELISTED | Stock | 50.35 | 50.45 | 47.6 | 48.25 | 1085900.0 |
| 2001-10-23 | ABM | Stock | 13.0 | 13.305 | 12.99 | 13.175 | 206000.0 |
| 2001-10-23 | ABMD-DELISTED | Stock | 22.4 | 23.11 | 21.25 | 21.52 | 91700.0 |
| 2001-10-23 | ABP-DELISTED | Stock | 1.6 | 1.68 | 1.5 | 1.5 | 123900.0 |
| 2001-10-23 | ABT | Stock | 24.501 | 24.501 | 23.9713 | 24.1778 | 8594770.0 |
| 2001-10-23 | ABTL-DELISTED | Stock | 5.05 | 5.6 | 5.05 | 5.5 | 64200.0 |
| 2001-10-23 | ABV-DELISTED | Stock | 16.0 | 16.05 | 15.8 | 15.88 | 648500.0 |
| 2001-10-23 | ABX-DELISTED | Stock | 15.6 | 15.76 | 15.38 | 15.51 | 1879800.0 |
| 2001-10-23 | ACAP-DELISTED | Stock | 23.0 | 23.36 | 22.27 | 23.0 | 42100.0 |
| 2001-10-23 | ACAS-DELISTED | Stock | 26.7 | 26.9 | 26.15 | 26.19 | 102900.0 |
| 2001-10-23 | ACAT-DELISTED | Stock | 14.08 | 14.5 | 13.96 | 14.5 | 14600.0 |
| 2001-10-23 | ACCL-DELISTED | Stock | 11.210000038147 | 11.5500001907349 | 10.9919996261597 | 11.4700002670288 | 108500.0 |
| 2001-10-23 | ACE-DELISTED | Stock | 36.87 | 37.46 | 36.2 | 36.67 | 1753599.0 |
| 2001-10-23 | ACF-DELISTED | Stock | 21.85 | 21.86 | 20.85 | 21.16 | 2371200.0 |
| 2001-10-23 | ACG-DELISTED | Stock | 8.59 | 8.6 | 8.54 | 8.58 | 269700.0 |
| 2001-10-23 | ACGL | Stock | 1.91 | 1.9511 | 1.8778 | 1.9378 | 178200.0 |
| 2001-10-23 | ACGN-DELISTED | Stock | 1269.3288 | 1269.3288 | 1201.3288 | 1269.3288 | 25000.0 |
| 2001-10-23 | ACH | Stock | 12.24 | 12.3 | 11.9333 | 12.14 | 303750.0 |
| 2001-10-23 | ACLS | Stock | 45.0 | 46.84 | 45.0 | 45.88 | 70225.0 |
| 2001-10-23 | ACO-DELISTED | Stock | 5.95 | 5.95 | 5.66 | 5.88 | 11600.0 |
| 2001-10-23 | ACPW-DELISTED | Stock | 27.35 | 29.05 | 27.0 | 27.95 | 20800.0 |
| 2001-10-23 | ACS-DELISTED | Stock | 45.95 | 46.5 | 44.81 | 45.91 | 814900.0 |
| 2001-10-23 | ACTA-DELISTED | Stock | 15.8 | 16.0 | 14.4 | 14.4 | 113200.0 |
| 2001-10-23 | ACTT-DELISTED | Stock | 9.21 | 9.35 | 9.0 | 9.15 | 166400.0 |
| 2001-10-23 | ACTU-DELISTED | Stock | 4.35 | 4.55 | 4.28 | 4.35 | 174100.0 |
| 2001-10-23 | ACXM-DELISTED | Stock | 12.02 | 12.8 | 12.01 | 12.8 | 1179300.0 |
| 2001-10-23 | ACY-DELISTED | Stock | 5.4 | 5.4 | 5.4 | 5.4 | 200.0 |
| 2001-10-23 | AD | Stock | 29.3 | 29.9667 | 29.1733 | 29.2067 | 428250.0 |
| 2001-10-23 | ADAT-DELISTED | Stock | 72.18 | 74.7 | 64.98 | 72.72 | 1717.0 |
| 2001-10-23 | ADBE | Stock | 15.675 | 16.05 | 15.05 | 15.635 | 6145200.0 |
| 2001-10-23 | ADC | Stock | 18.7 | 19.0 | 18.6 | 19.0 | 9300.0 |
| 2001-10-23 | ADEP-DELISTED | Stock | 20.2 | 27.0 | 20.0 | 22.0 | 62800.0 |
> showing 50 of 2,982 rows — these rows as CSV