PREVIEW / stock_daily / 2001-08-09
file: by_date/stock_daily/2001/2001-08-09.parquet size: 101 KB rows: 2,961 symbols: 1,841
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-09 | AAPL | Stock | 0.3386 | 0.342 | 0.3343 | 0.3402 | 200664800.0 |
| 2001-08-09 | MSFT | Stock | 32.49 | 32.775 | 32.15 | 32.505 | 45536200.0 |
| 2001-08-09 | NVDA | Stock | 0.3577 | 0.3648 | 0.3467 | 0.3531 | 1643616000.0 |
| 2001-08-09 | AMZN | Stock | 0.557 | 0.5585 | 0.5125 | 0.523 | 120980000.0 |
| 2001-08-09 | CL | Stock | 26.495 | 26.975 | 26.425 | 26.75 | 4463800.0 |
| 2001-08-09 | A | Stock | 20.7082 | 20.7082 | 20.0429 | 20.4864 | 1616368.0 |
| 2001-08-09 | AABA-DELISTED | Stock | 8.27999973297119 | 8.28499984741211 | 7.80000019073486 | 8.14000034332275 | 16024400.0 |
| 2001-08-09 | AAI-DELISTED | Stock | 8.7 | 8.7 | 8.5 | 8.5 | 205300.0 |
| 2001-08-09 | AAIC-DELISTED | Stock | 128.0 | 134.0 | 128.0 | 134.0 | 10600.0 |
| 2001-08-09 | AAME | Stock | 1.5 | 1.5 | 1.5 | 1.5 | 100.0 |
| 2001-08-09 | AAON | Stock | 1.7558 | 1.7839 | 1.7558 | 1.7792 | 510870.0 |
| 2001-08-09 | AAXN-DELISTED | Stock | 0.554166674613953 | 0.570833325386047 | 0.551666676998138 | 0.569166660308838 | 1784400.0 |
| 2001-08-09 | ABAX-DELISTED | Stock | 5.17 | 5.2 | 5.12 | 5.12 | 12500.0 |
| 2001-08-09 | ABB-DELISTED | Stock | 11.3 | 11.3 | 11.1 | 11.2 | 17100.0 |
| 2001-08-09 | ABC-DELISTED | Stock | 13.8649997711182 | 14.0325002670288 | 13.7150001525879 | 14.0124998092651 | 3752400.0 |
| 2001-08-09 | ABCB | Stock | 10.5775 | 10.7801 | 10.4559 | 10.537 | 3701.0 |
| 2001-08-09 | ABCW-DELISTED | Stock | 16.83 | 17.1 | 16.81 | 17.09 | 47400.0 |
| 2001-08-09 | ABE-DELISTED | Stock | 7.53 | 7.59 | 7.5 | 7.5 | 6700.0 |
| 2001-08-09 | ABFS-DELISTED | Stock | 24.5 | 25.2 | 24.5 | 25.05 | 336400.0 |
| 2001-08-09 | ABK-DELISTED | Stock | 57.55 | 58.25 | 56.6 | 57.85 | 444400.0 |
| 2001-08-09 | ABM | Stock | 18.1 | 18.24 | 17.76 | 17.825 | 92800.0 |
| 2001-08-09 | ABMD-DELISTED | Stock | 18.5 | 18.75 | 17.4 | 17.69 | 52500.0 |
| 2001-08-09 | ABP-DELISTED | Stock | 3.1 | 3.19 | 3.1 | 3.19 | 40300.0 |
| 2001-08-09 | ABT | Stock | 23.2845 | 23.3922 | 23.0017 | 23.1498 | 4841158.0 |
| 2001-08-09 | ABTL-DELISTED | Stock | 4.5 | 4.9 | 4.3 | 4.3 | 10900.0 |
| 2001-08-09 | ABV-DELISTED | Stock | 20.9 | 21.8 | 20.9 | 21.3 | 375300.0 |
| 2001-08-09 | ABX-DELISTED | Stock | 15.35 | 16.11 | 15.35 | 16.02 | 5135300.0 |
| 2001-08-09 | ACAP-DELISTED | Stock | 20.54 | 21.63 | 20.54 | 20.91 | 33000.0 |
| 2001-08-09 | ACAS-DELISTED | Stock | 26.88 | 27.15 | 26.7 | 27.15 | 258700.0 |
| 2001-08-09 | ACAT-DELISTED | Stock | 15.26 | 15.33 | 15.05 | 15.33 | 11200.0 |
| 2001-08-09 | ACCL-DELISTED | Stock | 12.0920000076294 | 12.0920000076294 | 11.8407001495361 | 12.0920000076294 | 388500.0 |
| 2001-08-09 | ACE-DELISTED | Stock | 35.5 | 35.65 | 35.1 | 35.5 | 536200.0 |
| 2001-08-09 | ACF-DELISTED | Stock | 60.0 | 60.5 | 58.81 | 60.15 | 1645800.0 |
| 2001-08-09 | ACG-DELISTED | Stock | 8.79 | 8.84 | 8.77 | 8.77 | 288100.0 |
| 2001-08-09 | ACGL | Stock | 1.9444 | 1.9789 | 1.8722 | 1.8722 | 236700.0 |
| 2001-08-09 | ACGN-DELISTED | Stock | 1076.6712 | 1076.6712 | 997.3288 | 997.3288 | 3200.0 |
| 2001-08-09 | ACH | Stock | 12.0 | 12.1667 | 11.6 | 12.1667 | 52350.0 |
| 2001-08-09 | ACLS | Stock | 51.2 | 54.4 | 50.68 | 53.04 | 88175.0 |
| 2001-08-09 | ACO-DELISTED | Stock | 6.2 | 6.24 | 6.2 | 6.2 | 28100.0 |
| 2001-08-09 | ACPW-DELISTED | Stock | 39.1 | 39.45 | 36.5 | 37.7 | 61020.0 |
| 2001-08-09 | ACS-DELISTED | Stock | 39.195 | 39.325 | 38.4 | 39.24 | 423600.0 |
| 2001-08-09 | ACTA-DELISTED | Stock | 26.2 | 27.6 | 24.4 | 26.4 | 78400.0 |
| 2001-08-09 | ACTT-DELISTED | Stock | 5.15 | 5.16 | 5.0 | 5.0 | 6600.0 |
| 2001-08-09 | ACTU-DELISTED | Stock | 9.01 | 9.25 | 8.81 | 9.11 | 280900.0 |
| 2001-08-09 | ACXM-DELISTED | Stock | 11.7 | 12.0 | 10.77 | 11.05 | 1727500.0 |
| 2001-08-09 | ACY-DELISTED | Stock | 5.7 | 6.1 | 5.7 | 6.0 | 12200.0 |
| 2001-08-09 | AD | Stock | 38.2 | 38.5333 | 37.7067 | 38.1 | 147000.0 |
| 2001-08-09 | ADAT-DELISTED | Stock | 82.08 | 85.5 | 81.0 | 83.16 | 1868.0 |
| 2001-08-09 | ADBE | Stock | 16.75 | 17.69 | 16.745 | 17.385 | 8114000.0 |
| 2001-08-09 | ADC | Stock | 19.46 | 19.6 | 19.3 | 19.6 | 2800.0 |
> showing 50 of 2,961 rows — these rows as CSV