PREVIEW / stock_daily / 2001-08-23
file: by_date/stock_daily/2001/2001-08-23.parquet size: 102 KB rows: 2,980 symbols: 1,850
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-08-23 | AAPL | Stock | 0.325 | 0.3275 | 0.3139 | 0.318 | 217078400.0 |
| 2001-08-23 | MSFT | Stock | 30.335 | 30.765 | 29.5 | 29.56 | 51813200.0 |
| 2001-08-23 | NVDA | Stock | 0.3521 | 0.3566 | 0.3438 | 0.3455 | 1013592000.0 |
| 2001-08-23 | AMZN | Stock | 0.5065 | 0.508 | 0.4785 | 0.4815 | 80014000.0 |
| 2001-08-23 | CL | Stock | 28.1 | 28.105 | 27.7 | 27.985 | 3896000.0 |
| 2001-08-23 | A | Stock | 18.8698 | 19.1631 | 18.5193 | 18.7196 | 3637736.0 |
| 2001-08-23 | AABA-DELISTED | Stock | 6.64499998092651 | 6.92500019073486 | 6.56500005722046 | 6.63000011444092 | 15656400.0 |
| 2001-08-23 | AAI-DELISTED | Stock | 6.3 | 6.5 | 5.65 | 5.98 | 2805100.0 |
| 2001-08-23 | AAIC-DELISTED | Stock | 130.0 | 130.0 | 126.0 | 126.0 | 18100.0 |
| 2001-08-23 | AAME | Stock | 1.54 | 1.54 | 1.54 | 1.54 | 1200.0 |
| 2001-08-23 | AAON | Stock | 1.8027 | 1.8114 | 1.7792 | 1.7851 | 1119129.0 |
| 2001-08-23 | AAXN-DELISTED | Stock | 0.644999980926514 | 0.658333361148834 | 0.644999980926514 | 0.652499973773956 | 432000.0 |
| 2001-08-23 | ABAX-DELISTED | Stock | 5.15 | 5.2 | 5.07 | 5.09 | 11500.0 |
| 2001-08-23 | ABB-DELISTED | Stock | 11.2 | 11.26 | 11.2 | 11.26 | 2100.0 |
| 2001-08-23 | ABC-DELISTED | Stock | 15.3299999237061 | 15.75 | 15.2349996566772 | 15.25 | 3945600.0 |
| 2001-08-23 | ABCB | Stock | 10.4802 | 10.4802 | 10.4802 | 10.4802 | 1481.0 |
| 2001-08-23 | ABCW-DELISTED | Stock | 18.12 | 18.5 | 18.0 | 18.35 | 362900.0 |
| 2001-08-23 | ABE-DELISTED | Stock | 7.25 | 7.35 | 7.25 | 7.27 | 12600.0 |
| 2001-08-23 | ABFS-DELISTED | Stock | 26.29 | 26.85 | 26.01 | 26.55 | 149500.0 |
| 2001-08-23 | ABK-DELISTED | Stock | 60.35 | 61.07 | 60.3 | 60.35 | 331700.0 |
| 2001-08-23 | ABM | Stock | 17.635 | 18.025 | 17.635 | 17.84 | 93000.0 |
| 2001-08-23 | ABMD-DELISTED | Stock | 19.19 | 19.45 | 18.95 | 19.11 | 53300.0 |
| 2001-08-23 | ABP-DELISTED | Stock | 3.08 | 3.1 | 2.98 | 3.0 | 59600.0 |
| 2001-08-23 | ABT | Stock | 23.6571 | 24.0611 | 23.3428 | 23.473 | 9482940.0 |
| 2001-08-23 | ABTL-DELISTED | Stock | 4.25 | 4.25 | 3.9 | 3.95 | 3500.0 |
| 2001-08-23 | ABV-DELISTED | Stock | 19.7 | 19.7 | 19.5 | 19.52 | 143900.0 |
| 2001-08-23 | ABX-DELISTED | Stock | 16.63 | 16.82 | 16.59 | 16.8 | 950900.0 |
| 2001-08-23 | ACAP-DELISTED | Stock | 22.47 | 22.6 | 22.35 | 22.55 | 37000.0 |
| 2001-08-23 | ACAS-DELISTED | Stock | 29.0 | 29.08 | 28.34 | 28.55 | 129100.0 |
| 2001-08-23 | ACAT-DELISTED | Stock | 15.7 | 16.46 | 15.65 | 16.32 | 25400.0 |
| 2001-08-23 | ACCL-DELISTED | Stock | 13.1300001144409 | 13.1639995574951 | 12.4549999237061 | 12.5270004272461 | 298200.0 |
| 2001-08-23 | ACE-DELISTED | Stock | 34.54 | 34.9 | 34.44 | 34.74 | 836900.0 |
| 2001-08-23 | ACF-DELISTED | Stock | 47.3 | 50.0 | 46.9 | 50.0 | 2644800.0 |
| 2001-08-23 | ACG-DELISTED | Stock | 8.87 | 8.87 | 8.75 | 8.82 | 166200.0 |
| 2001-08-23 | ACGL | Stock | 1.9333 | 1.9333 | 1.9333 | 1.9333 | 1800.0 |
| 2001-08-23 | ACGN-DELISTED | Stock | 1190.0 | 1303.3288 | 1190.0 | 1303.3288 | 93400.0 |
| 2001-08-23 | ACH | Stock | 13.0 | 13.3 | 12.8267 | 13.1667 | 84150.0 |
| 2001-08-23 | ACLS | Stock | 52.72 | 56.48 | 52.72 | 56.36 | 245275.0 |
| 2001-08-23 | ACO-DELISTED | Stock | 6.44 | 6.45 | 6.15 | 6.15 | 20100.0 |
| 2001-08-23 | ACPW-DELISTED | Stock | 34.95 | 36.99 | 33.95 | 34.5 | 128360.0 |
| 2001-08-23 | ACS-DELISTED | Stock | 42.15 | 43.435 | 41.95 | 42.29 | 759100.0 |
| 2001-08-23 | ACTA-DELISTED | Stock | 18.0 | 18.4 | 15.6 | 17.0 | 85700.0 |
| 2001-08-23 | ACTT-DELISTED | Stock | 6.15 | 6.15 | 6.1 | 6.1 | 1500.0 |
| 2001-08-23 | ACTU-DELISTED | Stock | 6.77 | 6.86 | 6.55 | 6.55 | 261800.0 |
| 2001-08-23 | ACXM-DELISTED | Stock | 12.9 | 12.92 | 12.55 | 12.75 | 506400.0 |
| 2001-08-23 | ACY-DELISTED | Stock | 5.9 | 5.9 | 5.9 | 5.9 | 3700.0 |
| 2001-08-23 | AD | Stock | 35.9 | 36.16 | 35.7933 | 35.8667 | 71400.0 |
| 2001-08-23 | ADAT-DELISTED | Stock | 68.76 | 73.26 | 63.9 | 71.82 | 4786.0 |
| 2001-08-23 | ADBE | Stock | 17.26 | 17.81 | 17.2 | 17.25 | 5365400.0 |
| 2001-08-23 | ADC | Stock | 20.23 | 20.3 | 20.23 | 20.28 | 3700.0 |
> showing 50 of 2,980 rows — these rows as CSV