PREVIEW / stock_daily / 2001-06-22
file: by_date/stock_daily/2001/2001-06-22.parquet size: 100 KB rows: 2,939 symbols: 1,827
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-06-22 | AAPL | Stock | 0.4014 | 0.4107 | 0.3886 | 0.3975 | 286025600.0 |
| 2001-06-22 | MSFT | Stock | 35.0 | 35.305 | 34.29 | 34.415 | 51092000.0 |
| 2001-06-22 | NVDA | Stock | 0.3802 | 0.3904 | 0.3754 | 0.3804 | 761184000.0 |
| 2001-06-22 | AMZN | Stock | 0.6565 | 0.6635 | 0.619 | 0.62 | 126334000.0 |
| 2001-06-22 | CL | Stock | 30.2 | 30.205 | 29.475 | 29.675 | 3683400.0 |
| 2001-06-22 | A | Stock | 20.7439 | 21.7167 | 20.5722 | 21.03 | 3436703.0 |
| 2001-06-22 | AABA-DELISTED | Stock | 9.02000045776367 | 9.10499954223633 | 8.60000038146973 | 8.65499973297119 | 12910400.0 |
| 2001-06-22 | AAI-DELISTED | Stock | 11.13 | 11.13 | 8.86 | 9.1 | 1658000.0 |
| 2001-06-22 | AAIC-DELISTED | Stock | 120.8 | 121.0 | 119.0 | 121.0 | 39300.0 |
| 2001-06-22 | AAON | Stock | 1.4328 | 1.4328 | 1.39 | 1.4281 | 27337.0 |
| 2001-06-22 | AAXN-DELISTED | Stock | 0.445833325386047 | 0.479166656732559 | 0.445833325386047 | 0.479166656732559 | 142800.0 |
| 2001-06-22 | ABAX-DELISTED | Stock | 5.54 | 5.6 | 5.35 | 5.35 | 17100.0 |
| 2001-06-22 | ABB-DELISTED | Stock | 14.95 | 14.95 | 14.7 | 14.7 | 41400.0 |
| 2001-06-22 | ABC-DELISTED | Stock | 15.625 | 15.625 | 14.7224998474121 | 14.7600002288818 | 2342000.0 |
| 2001-06-22 | ABCB | Stock | 9.2806 | 9.2806 | 9.2806 | 9.2806 | 247.0 |
| 2001-06-22 | ABCW-DELISTED | Stock | 14.79 | 14.8 | 14.65 | 14.76 | 115200.0 |
| 2001-06-22 | ABE-DELISTED | Stock | 8.05 | 8.08 | 8.04 | 8.05 | 5500.0 |
| 2001-06-22 | ABFS-DELISTED | Stock | 21.0 | 21.01 | 20.5 | 20.68 | 37600.0 |
| 2001-06-22 | ABK-DELISTED | Stock | 59.3 | 59.5 | 58.7 | 58.74 | 705700.0 |
| 2001-06-22 | ABM | Stock | 19.05 | 19.055 | 18.625 | 18.64 | 189400.0 |
| 2001-06-22 | ABMD-DELISTED | Stock | 24.5 | 24.69 | 23.75 | 24.12 | 82500.0 |
| 2001-06-22 | ABP-DELISTED | Stock | 3.45 | 3.7 | 3.45 | 3.61 | 38400.0 |
| 2001-06-22 | ABT | Stock | 23.4551 | 23.5179 | 23.0241 | 23.3518 | 8523931.0 |
| 2001-06-22 | ABTL-DELISTED | Stock | 6.8 | 7.1 | 6.75 | 6.75 | 9900.0 |
| 2001-06-22 | ABV-DELISTED | Stock | 20.45 | 20.62 | 20.3 | 20.46 | 390500.0 |
| 2001-06-22 | ABX-DELISTED | Stock | 16.41 | 16.54 | 16.31 | 16.4 | 1406000.0 |
| 2001-06-22 | ACAP-DELISTED | Stock | 19.9 | 19.95 | 19.7 | 19.71 | 114900.0 |
| 2001-06-22 | ACAS-DELISTED | Stock | 26.17 | 26.19 | 25.65 | 25.96 | 108000.0 |
| 2001-06-22 | ACAT-DELISTED | Stock | 15.3 | 15.54 | 14.93 | 15.05 | 54400.0 |
| 2001-06-22 | ACCL-DELISTED | Stock | 15.9300003051758 | 15.9379997253418 | 14.6269998550415 | 15.0979995727539 | 197900.0 |
| 2001-06-22 | ACE-DELISTED | Stock | 37.15 | 37.56 | 36.82 | 37.48 | 462500.0 |
| 2001-06-22 | ACF-DELISTED | Stock | 50.4 | 50.5 | 49.7 | 50.02 | 769400.0 |
| 2001-06-22 | ACG-DELISTED | Stock | 8.7 | 8.75 | 8.68 | 8.7 | 248600.0 |
| 2001-06-22 | ACGL | Stock | 1.7267 | 1.7778 | 1.7222 | 1.7778 | 177300.0 |
| 2001-06-22 | ACGN-DELISTED | Stock | 1246.6712 | 1326.0 | 1246.6712 | 1326.0 | 20500.0 |
| 2001-06-22 | ACH | Stock | 12.5 | 12.5467 | 12.0933 | 12.2667 | 629400.0 |
| 2001-06-22 | ACLS | Stock | 56.0 | 59.04 | 55.8 | 57.52 | 210950.0 |
| 2001-06-22 | ACO-DELISTED | Stock | 6.07 | 6.07 | 6.0 | 6.0 | 48100.0 |
| 2001-06-22 | ACPW-DELISTED | Stock | 88.75 | 94.05 | 88.75 | 92.35 | 78920.0 |
| 2001-06-22 | ACS-DELISTED | Stock | 37.32 | 38.15 | 37.05 | 38.09 | 411000.0 |
| 2001-06-22 | ACTA-DELISTED | Stock | 35.4 | 35.4 | 34.0 | 34.2 | 54200.0 |
| 2001-06-22 | ACTT-DELISTED | Stock | 6.53 | 6.54 | 6.3 | 6.45 | 15300.0 |
| 2001-06-22 | ACTU-DELISTED | Stock | 7.2 | 7.7 | 6.55 | 6.63 | 530500.0 |
| 2001-06-22 | ACXM-DELISTED | Stock | 14.99 | 15.2 | 11.95 | 12.18 | 2814000.0 |
| 2001-06-22 | ACY-DELISTED | Stock | 4.93 | 5.0 | 4.93 | 5.0 | 3100.0 |
| 2001-06-22 | AD | Stock | 38.2667 | 38.8133 | 37.1733 | 38.1 | 150900.0 |
| 2001-06-22 | ADAT-DELISTED | Stock | 71.1 | 76.32 | 67.5 | 76.14 | 9652.0 |
| 2001-06-22 | ADBE | Stock | 22.795 | 22.875 | 21.5 | 21.79 | 5599000.0 |
| 2001-06-22 | ADC | Stock | 19.7 | 20.0 | 19.65 | 19.99 | 10900.0 |
| 2001-06-22 | ADEP-DELISTED | Stock | 37.7 | 39.25 | 37.55 | 38.5 | 38700.0 |
> showing 50 of 2,939 rows — these rows as CSV