PREVIEW / stock_daily / 2001-10-19
file: by_date/stock_daily/2001/2001-10-19.parquet size: 99 KB rows: 2,948 symbols: 1,824
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-19 | AAPL | Stock | 0.3204 | 0.3286 | 0.3193 | 0.3268 | 166790400.0 |
| 2001-10-19 | MSFT | Stock | 28.7 | 29.005 | 27.815 | 28.95 | 91219600.0 |
| 2001-10-19 | NVDA | Stock | 0.357 | 0.375 | 0.3525 | 0.3697 | 1059264000.0 |
| 2001-10-19 | AMZN | Stock | 0.4245 | 0.426 | 0.375 | 0.4005 | 140146000.0 |
| 2001-10-19 | CL | Stock | 28.805 | 29.165 | 28.75 | 29.08 | 3638400.0 |
| 2001-10-19 | A | Stock | 16.1731 | 16.8097 | 16.0658 | 16.7096 | 1585891.0 |
| 2001-10-19 | AABA-DELISTED | Stock | 5.55999994277954 | 5.73000001907349 | 5.40500020980835 | 5.68499994277954 | 13111600.0 |
| 2001-10-19 | AAI-DELISTED | Stock | 3.9 | 3.98 | 3.75 | 3.88 | 245000.0 |
| 2001-10-19 | AAIC-DELISTED | Stock | 103.6 | 109.8 | 103.6 | 109.8 | 27100.0 |
| 2001-10-19 | AAME | Stock | 1.46 | 1.46 | 1.32 | 1.35 | 17200.0 |
| 2001-10-19 | AAON | Stock | 1.4942 | 1.517 | 1.4933 | 1.4933 | 191362.0 |
| 2001-10-19 | AAXN-DELISTED | Stock | 0.89083331823349 | 1.04166662693024 | 0.89083331823349 | 1.02499997615814 | 4971600.0 |
| 2001-10-19 | ABAX-DELISTED | Stock | 3.75 | 3.75 | 3.24 | 3.7 | 47200.0 |
| 2001-10-19 | ABB-DELISTED | Stock | 7.25 | 7.25 | 7.0 | 7.15 | 123100.0 |
| 2001-10-19 | ABC-DELISTED | Stock | 17.6 | 17.7 | 17.55 | 17.7 | 2733847.0 |
| 2001-10-19 | ABCB | Stock | 10.5532 | 10.5532 | 10.4559 | 10.4559 | 9869.0 |
| 2001-10-19 | ABCW-DELISTED | Stock | 15.44 | 15.89 | 15.3 | 15.89 | 47200.0 |
| 2001-10-19 | ABE-DELISTED | Stock | 6.37 | 6.39 | 6.34 | 6.39 | 25200.0 |
| 2001-10-19 | ABFS-DELISTED | Stock | 22.2 | 22.94 | 21.81 | 22.65 | 119000.0 |
| 2001-10-19 | ABK-DELISTED | Stock | 49.75 | 49.9 | 47.91 | 48.85 | 600600.0 |
| 2001-10-19 | ABM | Stock | 13.025 | 13.025 | 12.75 | 12.89 | 184000.0 |
| 2001-10-19 | ABMD-DELISTED | Stock | 20.24 | 21.29 | 19.75 | 21.15 | 91300.0 |
| 2001-10-19 | ABP-DELISTED | Stock | 1.64 | 1.65 | 1.6 | 1.6 | 52800.0 |
| 2001-10-19 | ABT | Stock | 23.5942 | 23.8142 | 23.482 | 23.8142 | 5133427.0 |
| 2001-10-19 | ABTL-DELISTED | Stock | 4.9 | 5.25 | 4.8 | 4.9 | 56600.0 |
| 2001-10-19 | ABV-DELISTED | Stock | 15.6 | 15.9 | 15.4 | 15.8 | 475500.0 |
| 2001-10-19 | ABX-DELISTED | Stock | 15.85 | 16.09 | 15.79 | 15.83 | 2128438.0 |
| 2001-10-19 | ACAP-DELISTED | Stock | 22.27 | 23.13 | 22.27 | 22.96 | 10000.0 |
| 2001-10-19 | ACAS-DELISTED | Stock | 27.08 | 27.1 | 26.61 | 26.65 | 232347.0 |
| 2001-10-19 | ACAT-DELISTED | Stock | 13.33 | 13.97 | 13.33 | 13.75 | 15500.0 |
| 2001-10-19 | ACCL-DELISTED | Stock | 10.4996004104614 | 10.7819995880127 | 10.4996004104614 | 10.7819995880127 | 43600.0 |
| 2001-10-19 | ACE-DELISTED | Stock | 36.85 | 37.5 | 36.11 | 36.51 | 1866200.0 |
| 2001-10-19 | ACF-DELISTED | Stock | 21.13 | 22.48 | 19.5 | 21.99 | 3712600.0 |
| 2001-10-19 | ACG-DELISTED | Stock | 8.67 | 8.69 | 8.56 | 8.61 | 296000.0 |
| 2001-10-19 | ACGL | Stock | 1.8611 | 1.8889 | 1.8333 | 1.8889 | 192600.0 |
| 2001-10-19 | ACGN-DELISTED | Stock | 1235.3288 | 1314.6712 | 1235.3288 | 1303.3288 | 2300.0 |
| 2001-10-19 | ACH | Stock | 12.0667 | 12.0933 | 11.8333 | 12.08 | 189750.0 |
| 2001-10-19 | ACLS | Stock | 41.12 | 42.52 | 40.04 | 41.4 | 110000.0 |
| 2001-10-19 | ACO-DELISTED | Stock | 5.7 | 5.75 | 5.57 | 5.75 | 21300.0 |
| 2001-10-19 | ACPW-DELISTED | Stock | 25.75 | 28.75 | 25.55 | 26.8 | 43680.0 |
| 2001-10-19 | ACS-DELISTED | Stock | 44.875 | 46.1 | 44.875 | 46.085 | 638200.0 |
| 2001-10-19 | ACTA-DELISTED | Stock | 18.6 | 18.8 | 16.0 | 16.4 | 88700.0 |
| 2001-10-19 | ACTT-DELISTED | Stock | 8.6 | 9.42 | 8.4 | 9.42 | 76400.0 |
| 2001-10-19 | ACTU-DELISTED | Stock | 4.26 | 4.6 | 4.25 | 4.51 | 1038900.0 |
| 2001-10-19 | ACXM-DELISTED | Stock | 11.68 | 12.54 | 11.38 | 12.48 | 1053500.0 |
| 2001-10-19 | ACY-DELISTED | Stock | 5.57 | 5.59 | 5.4 | 5.59 | 4000.0 |
| 2001-10-19 | AD | Stock | 27.7 | 28.8333 | 27.7 | 28.7 | 240300.0 |
| 2001-10-19 | ADAT-DELISTED | Stock | 72.9 | 72.9 | 70.38 | 72.0 | 358.0 |
| 2001-10-19 | ADBE | Stock | 14.59 | 15.27 | 14.53 | 15.055 | 5384000.0 |
| 2001-10-19 | ADC | Stock | 18.71 | 18.81 | 18.64 | 18.64 | 3900.0 |
> showing 50 of 2,948 rows — these rows as CSV