PREVIEW / stock_daily / 2001-07-26
file: by_date/stock_daily/2001/2001-07-26.parquet size: 100 KB rows: 2,923 symbols: 1,807
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-07-26 | AAPL | Stock | 0.33 | 0.3357 | 0.3188 | 0.332 | 369140800.0 |
| 2001-07-26 | MSFT | Stock | 33.56 | 33.66 | 32.75 | 33.295 | 77974000.0 |
| 2001-07-26 | NVDA | Stock | 0.2959 | 0.3313 | 0.2944 | 0.3292 | 1714152000.0 |
| 2001-07-26 | AMZN | Stock | 0.5835 | 0.6375 | 0.5615 | 0.6165 | 210050000.0 |
| 2001-07-26 | CL | Stock | 27.195 | 27.25 | 26.775 | 27.05 | 4049400.0 |
| 2001-07-26 | A | Stock | 20.0286 | 21.1373 | 19.7783 | 20.8941 | 2545339.0 |
| 2001-07-26 | AABA-DELISTED | Stock | 8.4399995803833 | 8.85000038146973 | 8.30000019073486 | 8.73999977111816 | 11784000.0 |
| 2001-07-26 | AAI-DELISTED | Stock | 8.8 | 9.17 | 8.24 | 9.12 | 621900.0 |
| 2001-07-26 | AAIC-DELISTED | Stock | 139.0 | 140.0 | 138.0 | 139.0 | 70100.0 |
| 2001-07-26 | AAON | Stock | 1.764 | 1.7705 | 1.7471 | 1.7617 | 452777.0 |
| 2001-07-26 | AAXN-DELISTED | Stock | 0.473333328962326 | 0.47749999165535 | 0.473333328962326 | 0.47749999165535 | 31200.0 |
| 2001-07-26 | ABAX-DELISTED | Stock | 5.45 | 5.45 | 5.39 | 5.39 | 3200.0 |
| 2001-07-26 | ABB-DELISTED | Stock | 10.35 | 10.55 | 10.22 | 10.48 | 47200.0 |
| 2001-07-26 | ABC-DELISTED | Stock | 13.8325004577637 | 14.5 | 13.8299999237061 | 14.375 | 2962400.0 |
| 2001-07-26 | ABCB | Stock | 10.1074 | 10.1074 | 10.1074 | 10.1074 | 1851.0 |
| 2001-07-26 | ABCW-DELISTED | Stock | 15.68 | 16.15 | 15.68 | 16.1 | 395000.0 |
| 2001-07-26 | ABE-DELISTED | Stock | 7.52 | 7.6 | 7.51 | 7.52 | 21500.0 |
| 2001-07-26 | ABFS-DELISTED | Stock | 26.04 | 27.35 | 26.04 | 26.87 | 292000.0 |
| 2001-07-26 | ABK-DELISTED | Stock | 56.45 | 57.5 | 56.42 | 57.05 | 411600.0 |
| 2001-07-26 | ABM | Stock | 18.215 | 18.235 | 17.9 | 17.95 | 119200.0 |
| 2001-07-26 | ABMD-DELISTED | Stock | 17.8 | 18.75 | 17.58 | 18.31 | 83300.0 |
| 2001-07-26 | ABP-DELISTED | Stock | 3.4 | 3.55 | 3.4 | 3.55 | 41500.0 |
| 2001-07-26 | ABT | Stock | 23.0511 | 23.2755 | 22.8984 | 23.2755 | 4599456.0 |
| 2001-07-26 | ABTL-DELISTED | Stock | 5.2 | 5.2 | 4.85 | 5.1 | 41300.0 |
| 2001-07-26 | ABV-DELISTED | Stock | 20.74 | 20.74 | 20.25 | 20.64 | 118700.0 |
| 2001-07-26 | ABX-DELISTED | Stock | 15.54 | 15.54 | 15.16 | 15.21 | 1207373.0 |
| 2001-07-26 | ACAP-DELISTED | Stock | 20.21 | 20.3 | 20.01 | 20.3 | 60100.0 |
| 2001-07-26 | ACAS-DELISTED | Stock | 26.98 | 27.71 | 26.61 | 27.71 | 162544.0 |
| 2001-07-26 | ACAT-DELISTED | Stock | 14.2 | 14.65 | 14.1 | 14.65 | 22700.0 |
| 2001-07-26 | ACCL-DELISTED | Stock | 12.207799911499 | 12.3678998947144 | 12.1658000946045 | 12.3678998947144 | 333200.0 |
| 2001-07-26 | ACE-DELISTED | Stock | 33.65 | 33.82 | 33.0 | 33.43 | 1141000.0 |
| 2001-07-26 | ACF-DELISTED | Stock | 58.36 | 60.52 | 58.05 | 59.95 | 791000.0 |
| 2001-07-26 | ACG-DELISTED | Stock | 8.65 | 8.7 | 8.57 | 8.7 | 199000.0 |
| 2001-07-26 | ACGL | Stock | 1.9978 | 1.9978 | 1.8956 | 1.8956 | 27000.0 |
| 2001-07-26 | ACGN-DELISTED | Stock | 906.6712 | 906.6712 | 827.3288 | 827.3288 | 116600.0 |
| 2001-07-26 | ACH | Stock | 11.9 | 12.2267 | 11.7867 | 12.2267 | 148650.0 |
| 2001-07-26 | ACLS | Stock | 50.64 | 55.12 | 48.68 | 54.08 | 514175.0 |
| 2001-07-26 | ACO-DELISTED | Stock | 5.98 | 6.1 | 5.98 | 6.05 | 98000.0 |
| 2001-07-26 | ACPW-DELISTED | Stock | 40.25 | 45.5 | 39.55 | 45.25 | 169140.0 |
| 2001-07-26 | ACS-DELISTED | Stock | 40.15 | 40.975 | 39.725 | 40.905 | 422800.0 |
| 2001-07-26 | ACTA-DELISTED | Stock | 28.4 | 28.8 | 27.2 | 28.0 | 32100.0 |
| 2001-07-26 | ACTT-DELISTED | Stock | 4.01 | 4.09 | 3.89 | 3.95 | 130100.0 |
| 2001-07-26 | ACTU-DELISTED | Stock | 9.54 | 10.1 | 9.35 | 9.96 | 210100.0 |
| 2001-07-26 | ACXM-DELISTED | Stock | 12.04 | 12.1 | 10.87 | 11.06 | 3204100.0 |
| 2001-07-26 | ACY-DELISTED | Stock | 5.3 | 5.3 | 5.2 | 5.2 | 4900.0 |
| 2001-07-26 | AD | Stock | 37.0 | 37.6133 | 35.7867 | 37.0067 | 307650.0 |
| 2001-07-26 | ADAT-DELISTED | Stock | 86.4 | 92.88 | 86.4 | 88.92 | 4596.0 |
| 2001-07-26 | ADBE | Stock | 20.75 | 21.73 | 20.135 | 21.5 | 6531200.0 |
| 2001-07-26 | ADC | Stock | 19.85 | 19.95 | 19.6 | 19.7 | 5700.0 |
| 2001-07-26 | ADEP-DELISTED | Stock | 46.5 | 46.5 | 40.4 | 42.7 | 42200.0 |
> showing 50 of 2,923 rows — these rows as CSV