PREVIEW / stock_daily / 2001-01-29
file: by_date/stock_daily/2001/2001-01-29.parquet size: 100 KB rows: 2,904 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-01-29 | AAPL | Stock | 0.3493 | 0.3884 | 0.3493 | 0.3873 | 855528800.0 |
| 2001-01-29 | MSFT | Stock | 31.7812 | 32.3125 | 31.75 | 32.25 | 84983800.0 |
| 2001-01-29 | NVDA | Stock | 0.2052 | 0.213 | 0.1979 | 0.2128 | 354168000.0 |
| 2001-01-29 | AMZN | Stock | 0.9562 | 1.0375 | 0.9406 | 1.0062 | 154260000.0 |
| 2001-01-29 | CL | Stock | 28.51 | 28.575 | 27.875 | 28.19 | 2488600.0 |
| 2001-01-29 | A | Stock | 39.6996 | 40.4149 | 38.6266 | 38.927 | 3051275.0 |
| 2001-01-29 | AABA-DELISTED | Stock | 18.875 | 20.1875 | 18.875 | 19.9375 | 18819000.0 |
| 2001-01-29 | AAI-DELISTED | Stock | 8.85 | 9.3 | 8.5 | 9.1 | 1606900.0 |
| 2001-01-29 | AAIC-DELISTED | Stock | 150.0 | 157.4 | 147.0 | 155.8 | 54700.0 |
| 2001-01-29 | AAME | Stock | 1.875 | 1.875 | 1.75 | 1.75 | 4600.0 |
| 2001-01-29 | AAON | Stock | 1.4184 | 1.4184 | 1.3754 | 1.39 | 29046.0 |
| 2001-01-29 | ABAX-DELISTED | Stock | 5.03125 | 5.125 | 4.90625 | 5.03125 | 104500.0 |
| 2001-01-29 | ABC-DELISTED | Stock | 11.6875 | 12.1949996948242 | 11.6575002670288 | 12.1925001144409 | 1670400.0 |
| 2001-01-29 | ABCB | Stock | 8.6626 | 8.9159 | 8.6626 | 8.7133 | 3701.0 |
| 2001-01-29 | ABCW-DELISTED | Stock | 14.69 | 15.02 | 14.69 | 14.81 | 14600.0 |
| 2001-01-29 | ABE-DELISTED | Stock | 9.4 | 9.54 | 9.36 | 9.41 | 65800.0 |
| 2001-01-29 | ABFS-DELISTED | Stock | 20.75 | 20.9375 | 19.875 | 20.625 | 243700.0 |
| 2001-01-29 | ABK-DELISTED | Stock | 54.99 | 56.74 | 54.9 | 55.0 | 1021400.0 |
| 2001-01-29 | ABM | Stock | 15.56 | 15.74 | 15.495 | 15.495 | 95800.0 |
| 2001-01-29 | ABMD-DELISTED | Stock | 18.875 | 18.875 | 18.125 | 18.375 | 96800.0 |
| 2001-01-29 | ABP-DELISTED | Stock | 5.12 | 5.23 | 4.99 | 5.05 | 365900.0 |
| 2001-01-29 | ABT | Stock | 21.0759 | 21.1881 | 20.3801 | 20.4025 | 4866330.0 |
| 2001-01-29 | ABTL-DELISTED | Stock | 10.625 | 11.25 | 10.625 | 10.625 | 17100.0 |
| 2001-01-29 | ABV-DELISTED | Stock | 26.0 | 26.6 | 25.5 | 26.6 | 97000.0 |
| 2001-01-29 | ABX-DELISTED | Stock | 15.47 | 15.52 | 14.85 | 14.91 | 1069506.0 |
| 2001-01-29 | ACAP-DELISTED | Stock | 18.5 | 19.63 | 18.47 | 19.56 | 367700.0 |
| 2001-01-29 | ACAS-DELISTED | Stock | 25.22 | 26.7178 | 25.22 | 26.7178 | 243779.0 |
| 2001-01-29 | ACAT-DELISTED | Stock | 13.063 | 13.063 | 12.938 | 13.063 | 19800.0 |
| 2001-01-29 | ACCL-DELISTED | Stock | 20.4113006591797 | 20.4561996459961 | 20.0941009521484 | 20.4561996459961 | 217800.0 |
| 2001-01-29 | ACE-DELISTED | Stock | 38.299999 | 39.049999 | 38.18 | 38.59 | 525200.0 |
| 2001-01-29 | ACF-DELISTED | Stock | 34.74 | 35.55 | 34.62 | 35.5 | 426500.0 |
| 2001-01-29 | ACG-DELISTED | Stock | 7.94 | 8.0 | 7.9 | 7.99 | 311800.0 |
| 2001-01-29 | ACGL | Stock | 1.6667 | 1.6806 | 1.5972 | 1.6181 | 459900.0 |
| 2001-01-29 | ACGN-DELISTED | Stock | 759.3288 | 759.3288 | 759.3288 | 759.3288 | 1300.0 |
| 2001-01-29 | ACH | Stock | 11.0333 | 11.0333 | 10.6667 | 10.6933 | 254100.0 |
| 2001-01-29 | ACLS | Stock | 42.25 | 43.0 | 40.5 | 43.0 | 352775.0 |
| 2001-01-29 | ACO-DELISTED | Stock | 4.38 | 4.63 | 4.12 | 4.5 | 11800.0 |
| 2001-01-29 | ACPW-DELISTED | Stock | 113.75 | 118.75 | 110.0 | 114.38 | 50560.0 |
| 2001-01-29 | ACS-DELISTED | Stock | 31.75 | 32.255 | 31.75 | 31.925 | 568100.0 |
| 2001-01-29 | ACTA-DELISTED | Stock | 118.75 | 120.0 | 111.25 | 117.5 | 66100.0 |
| 2001-01-29 | ACTT-DELISTED | Stock | 8.4375 | 8.5625 | 7.5 | 7.8125 | 46400.0 |
| 2001-01-29 | ACTU-DELISTED | Stock | 20.38 | 24.0 | 20.25 | 24.0 | 571800.0 |
| 2001-01-29 | ACXM-DELISTED | Stock | 32.375 | 34.625 | 32.25 | 34.625 | 1457100.0 |
| 2001-01-29 | ACY-DELISTED | Stock | 4.9 | 4.9 | 4.9 | 4.9 | 100.0 |
| 2001-01-29 | AD | Stock | 40.8667 | 43.12 | 40.8667 | 41.5 | 356250.0 |
| 2001-01-29 | ADAT-DELISTED | Stock | 79.03 | 81.0 | 79.03 | 79.31 | 1900.0 |
| 2001-01-29 | ADBE | Stock | 29.1562 | 29.25 | 26.6953 | 27.0 | 10978400.0 |
| 2001-01-29 | ADC | Stock | 15.61 | 15.9 | 15.56 | 15.65 | 12000.0 |
| 2001-01-29 | ADEP-DELISTED | Stock | 91.56 | 125.31 | 91.56 | 116.25 | 159600.0 |
| 2001-01-29 | ADGF-DELISTED | Stock | 1.56 | 1.75 | 1.56 | 1.75 | 175200.0 |
> showing 50 of 2,904 rows — these rows as CSV