PREVIEW / stock_daily / 2001-01-31
file: by_date/stock_daily/2001/2001-01-31.parquet size: 101 KB rows: 2,909 symbols: 1,809
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-01-31 | AAPL | Stock | 0.3839 | 0.4018 | 0.3828 | 0.3862 | 730704800.0 |
| 2001-01-31 | MSFT | Stock | 31.5 | 31.875 | 30.5 | 30.5312 | 81898800.0 |
| 2001-01-31 | NVDA | Stock | 0.2177 | 0.226 | 0.2104 | 0.2151 | 358344000.0 |
| 2001-01-31 | AMZN | Stock | 0.9469 | 0.9781 | 0.8531 | 0.8656 | 409516000.0 |
| 2001-01-31 | CL | Stock | 29.235 | 30.05 | 28.525 | 30.04 | 3374200.0 |
| 2001-01-31 | A | Stock | 39.3419 | 39.8784 | 38.1259 | 39.02 | 2555544.0 |
| 2001-01-31 | AABA-DELISTED | Stock | 19.90625 | 20.53125 | 18.5 | 18.65625 | 22458600.0 |
| 2001-01-31 | AAI-DELISTED | Stock | 10.0 | 10.4 | 9.75 | 10.38 | 1309100.0 |
| 2001-01-31 | AAIC-DELISTED | Stock | 156.8 | 157.4 | 155.4 | 155.4 | 68900.0 |
| 2001-01-31 | AAME | Stock | 2.0 | 2.0 | 2.0 | 2.0 | 2500.0 |
| 2001-01-31 | AAON | Stock | 1.4047 | 1.5656 | 1.2949 | 1.3461 | 814999.0 |
| 2001-01-31 | ABAX-DELISTED | Stock | 5.46875 | 5.71875 | 5.3125 | 5.5 | 59700.0 |
| 2001-01-31 | ABC-DELISTED | Stock | 11.8774995803833 | 12.0325002670288 | 11.75 | 11.9575004577637 | 844000.0 |
| 2001-01-31 | ABCB | Stock | 8.9159 | 8.9159 | 8.7133 | 8.7133 | 1481.0 |
| 2001-01-31 | ABCW-DELISTED | Stock | 15.38 | 15.88 | 14.88 | 15.88 | 66520.0 |
| 2001-01-31 | ABE-DELISTED | Stock | 9.48 | 9.63 | 9.43 | 9.5 | 34800.0 |
| 2001-01-31 | ABFS-DELISTED | Stock | 20.75 | 21.125 | 20.5625 | 20.625 | 1405700.0 |
| 2001-01-31 | ABK-DELISTED | Stock | 56.3 | 56.3 | 54.85 | 55.71 | 803100.0 |
| 2001-01-31 | ABM | Stock | 15.6 | 15.625 | 15.175 | 15.175 | 64000.0 |
| 2001-01-31 | ABMD-DELISTED | Stock | 24.0625 | 24.125 | 22.0625 | 22.5625 | 654100.0 |
| 2001-01-31 | ABP-DELISTED | Stock | 5.0 | 5.06 | 4.77 | 4.85 | 71500.0 |
| 2001-01-31 | ABT | Stock | 20.1781 | 20.2903 | 19.5003 | 20.1377 | 6800610.0 |
| 2001-01-31 | ABTL-DELISTED | Stock | 11.563 | 11.563 | 10.938 | 11.563 | 17700.0 |
| 2001-01-31 | ABV-DELISTED | Stock | 28.0 | 28.7 | 27.85 | 28.7 | 311700.0 |
| 2001-01-31 | ABX-DELISTED | Stock | 15.19 | 15.6 | 15.03 | 15.5 | 1738900.0 |
| 2001-01-31 | ACAP-DELISTED | Stock | 19.69 | 20.0 | 19.63 | 20.0 | 130800.0 |
| 2001-01-31 | ACAS-DELISTED | Stock | 26.125 | 26.1875 | 25.0625 | 25.125 | 263900.0 |
| 2001-01-31 | ACAT-DELISTED | Stock | 13.243 | 14.13 | 13.243 | 14.0 | 169862.0 |
| 2001-01-31 | ACCL-DELISTED | Stock | 20.4099998474121 | 20.8640003204346 | 19.9130001068115 | 20.1849994659424 | 161000.0 |
| 2001-01-31 | ACE-DELISTED | Stock | 37.790001 | 37.900002 | 36.400002 | 37.0 | 865500.0 |
| 2001-01-31 | ACF-DELISTED | Stock | 35.5 | 36.0 | 35.1 | 35.21 | 610200.0 |
| 2001-01-31 | ACG-DELISTED | Stock | 8.03 | 8.12 | 8.0 | 8.07 | 435500.0 |
| 2001-01-31 | ACGL | Stock | 1.6667 | 1.7153 | 1.6667 | 1.7153 | 90900.0 |
| 2001-01-31 | ACGN-DELISTED | Stock | 612.0 | 680.0 | 612.0 | 680.0 | 5000.0 |
| 2001-01-31 | ACH | Stock | 10.5067 | 10.5067 | 9.4667 | 9.5667 | 292500.0 |
| 2001-01-31 | ACLS | Stock | 44.0 | 46.0 | 43.5 | 44.75 | 972175.0 |
| 2001-01-31 | ACO-DELISTED | Stock | 4.79 | 4.79 | 4.5 | 4.53 | 20600.0 |
| 2001-01-31 | ACPW-DELISTED | Stock | 125.0 | 125.0 | 114.69 | 118.75 | 63840.0 |
| 2001-01-31 | ACS-DELISTED | Stock | 32.41 | 32.55 | 31.57 | 32.0 | 473300.0 |
| 2001-01-31 | ACTA-DELISTED | Stock | 128.75 | 131.88 | 121.88 | 128.75 | 233000.0 |
| 2001-01-31 | ACTT-DELISTED | Stock | 7.7031 | 8.0 | 7.7031 | 8.0 | 13500.0 |
| 2001-01-31 | ACTU-DELISTED | Stock | 23.5 | 23.88 | 22.75 | 22.97 | 353400.0 |
| 2001-01-31 | ACXM-DELISTED | Stock | 35.22 | 35.31 | 34.19 | 34.25 | 565098.0 |
| 2001-01-31 | ACY-DELISTED | Stock | 4.95 | 4.95 | 4.79 | 4.94 | 2500.0 |
| 2001-01-31 | AD | Stock | 43.3333 | 44.4333 | 43.3333 | 44.4333 | 301050.0 |
| 2001-01-31 | ADAT-DELISTED | Stock | 79.59 | 81.0 | 76.5 | 76.5 | 6400.0 |
| 2001-01-31 | ADBE | Stock | 23.6562 | 24.5 | 21.1875 | 21.8438 | 38108400.0 |
| 2001-01-31 | ADC | Stock | 15.99 | 16.24 | 15.89 | 15.89 | 7400.0 |
| 2001-01-31 | ADEP-DELISTED | Stock | 120.16 | 120.62 | 107.5 | 109.38 | 31600.0 |
| 2001-01-31 | ADGF-DELISTED | Stock | 1.72 | 1.72 | 1.59 | 1.66 | 87700.0 |
> showing 50 of 2,909 rows — these rows as CSV