PREVIEW / stock_daily / 2001-10-22
file: by_date/stock_daily/2001/2001-10-22.parquet size: 100 KB rows: 2,982 symbols: 1,853
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-22 | AAPL | Stock | 0.3252 | 0.3405 | 0.323 | 0.3396 | 391938400.0 |
| 2001-10-22 | MSFT | Stock | 28.95 | 30.09 | 28.735 | 30.08 | 72323600.0 |
| 2001-10-22 | NVDA | Stock | 0.3669 | 0.3833 | 0.3587 | 0.3784 | 970824000.0 |
| 2001-10-22 | AMZN | Stock | 0.4035 | 0.4415 | 0.402 | 0.4385 | 84620000.0 |
| 2001-10-22 | CL | Stock | 29.05 | 29.825 | 29.005 | 29.705 | 2828200.0 |
| 2001-10-22 | A | Stock | 16.2375 | 16.9814 | 16.166 | 16.8884 | 1441618.0 |
| 2001-10-22 | AABA-DELISTED | Stock | 5.69999980926514 | 5.94000005722046 | 5.53499984741211 | 5.8899998664856 | 11827000.0 |
| 2001-10-22 | AAI-DELISTED | Stock | 3.98 | 4.19 | 3.81 | 3.98 | 341800.0 |
| 2001-10-22 | AAIC-DELISTED | Stock | 110.0 | 116.0 | 108.0 | 115.2 | 43100.0 |
| 2001-10-22 | AAME | Stock | 1.32 | 1.45 | 1.2 | 1.45 | 5700.0 |
| 2001-10-22 | AAON | Stock | 1.4933 | 1.5012 | 1.4134 | 1.4266 | 537638.0 |
| 2001-10-22 | AAXN-DELISTED | Stock | 1.03333330154419 | 1.04666662216187 | 0.858333349227905 | 0.891666650772095 | 2266800.0 |
| 2001-10-22 | ABAX-DELISTED | Stock | 3.8 | 4.04 | 3.75 | 4.04 | 9400.0 |
| 2001-10-22 | ABB-DELISTED | Stock | 7.14 | 7.35 | 7.1 | 7.3 | 15300.0 |
| 2001-10-22 | ABC-DELISTED | Stock | 17.64 | 17.94 | 17.6 | 17.81 | 2841200.0 |
| 2001-10-22 | ABCB | Stock | 10.5775 | 10.5775 | 10.5775 | 10.5775 | 4935.0 |
| 2001-10-22 | ABCW-DELISTED | Stock | 15.89 | 15.97 | 15.54 | 15.79 | 6300.0 |
| 2001-10-22 | ABE-DELISTED | Stock | 6.35 | 6.35 | 6.32 | 6.35 | 11700.0 |
| 2001-10-22 | ABFS-DELISTED | Stock | 22.8 | 23.12 | 22.8 | 23.0 | 127900.0 |
| 2001-10-22 | ABK-DELISTED | Stock | 48.0 | 51.3 | 47.6 | 50.5 | 1381800.0 |
| 2001-10-22 | ABM | Stock | 12.825 | 13.34 | 12.715 | 13.05 | 155000.0 |
| 2001-10-22 | ABMD-DELISTED | Stock | 21.3 | 23.0 | 21.25 | 22.1 | 246600.0 |
| 2001-10-22 | ABP-DELISTED | Stock | 1.6 | 1.63 | 1.58 | 1.59 | 19900.0 |
| 2001-10-22 | ABT | Stock | 23.5673 | 24.501 | 23.5583 | 24.501 | 9411877.0 |
| 2001-10-22 | ABTL-DELISTED | Stock | 4.95 | 5.15 | 4.8 | 5.0 | 34200.0 |
| 2001-10-22 | ABV-DELISTED | Stock | 15.9 | 15.9 | 15.5 | 15.8 | 1274100.0 |
| 2001-10-22 | ABX-DELISTED | Stock | 15.73 | 15.73 | 15.49 | 15.53 | 1713891.0 |
| 2001-10-22 | ACAP-DELISTED | Stock | 22.8 | 23.28 | 22.41 | 23.0 | 11600.0 |
| 2001-10-22 | ACAS-DELISTED | Stock | 26.76 | 27.11 | 26.57 | 26.8 | 99820.0 |
| 2001-10-22 | ACAT-DELISTED | Stock | 13.75 | 14.05 | 13.67 | 14.05 | 45100.0 |
| 2001-10-22 | ACCL-DELISTED | Stock | 10.3909997940063 | 11.1948003768921 | 10.3909997940063 | 11.1948003768921 | 138400.0 |
| 2001-10-22 | ACE-DELISTED | Stock | 36.7 | 37.5 | 36.4 | 37.21 | 1535800.0 |
| 2001-10-22 | ACF-DELISTED | Stock | 22.0 | 22.3 | 20.75 | 21.78 | 1404700.0 |
| 2001-10-22 | ACG-DELISTED | Stock | 8.68 | 8.69 | 8.53 | 8.54 | 226900.0 |
| 2001-10-22 | ACGL | Stock | 1.8778 | 1.8889 | 1.8778 | 1.8889 | 111600.0 |
| 2001-10-22 | ACGN-DELISTED | Stock | 1201.3288 | 1292.0 | 1201.3288 | 1269.3288 | 18100.0 |
| 2001-10-22 | ACH | Stock | 12.08 | 12.2667 | 11.9667 | 12.24 | 86250.0 |
| 2001-10-22 | ACLS | Stock | 41.4 | 46.2 | 40.84 | 45.12 | 223150.0 |
| 2001-10-22 | ACO-DELISTED | Stock | 5.75 | 5.9 | 5.75 | 5.9 | 9600.0 |
| 2001-10-22 | ACPW-DELISTED | Stock | 25.25 | 27.5 | 25.05 | 27.35 | 40680.0 |
| 2001-10-22 | ACS-DELISTED | Stock | 46.085 | 46.6 | 45.75 | 45.95 | 371400.0 |
| 2001-10-22 | ACTA-DELISTED | Stock | 17.0 | 17.0 | 14.0 | 15.0 | 181700.0 |
| 2001-10-22 | ACTT-DELISTED | Stock | 9.38 | 9.45 | 9.0 | 9.38 | 58900.0 |
| 2001-10-22 | ACTU-DELISTED | Stock | 4.5 | 4.66 | 4.19 | 4.28 | 748700.0 |
| 2001-10-22 | ACXM-DELISTED | Stock | 12.48 | 12.55 | 11.85 | 12.0 | 766300.0 |
| 2001-10-22 | ACY-DELISTED | Stock | 5.55 | 5.55 | 5.36 | 5.36 | 8700.0 |
| 2001-10-22 | AD | Stock | 28.8667 | 29.4333 | 28.8 | 29.1333 | 270000.0 |
| 2001-10-22 | ADAT-DELISTED | Stock | 73.53 | 77.31 | 70.28 | 77.31 | 1886.0 |
| 2001-10-22 | ADBE | Stock | 15.025 | 15.62 | 14.995 | 15.515 | 4704400.0 |
| 2001-10-22 | ADC | Stock | 18.5 | 18.75 | 18.45 | 18.6 | 8200.0 |
> showing 50 of 2,982 rows — these rows as CSV