PREVIEW / stock_daily / 2001-08-02
file: by_date/stock_daily/2001/2001-08-02.parquet size: 101 KB rows: 2,949 symbols: 1,832
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-02 | AAPL | Stock | 0.3509 | 0.3548 | 0.3439 | 0.3539 | 252089600.0 |
| 2001-08-02 | MSFT | Stock | 33.605 | 33.77 | 33.13 | 33.725 | 54198400.0 |
| 2001-08-02 | NVDA | Stock | 0.3622 | 0.3675 | 0.35 | 0.3662 | 1097928000.0 |
| 2001-08-02 | AMZN | Stock | 0.6295 | 0.63 | 0.605 | 0.6095 | 77450000.0 |
| 2001-08-02 | CL | Stock | 26.6 | 26.825 | 26.425 | 26.47 | 3569000.0 |
| 2001-08-02 | A | Stock | 22.5322 | 23.3906 | 22.2818 | 22.711 | 2576933.0 |
| 2001-08-02 | AABA-DELISTED | Stock | 9.34500026702881 | 9.35000038146973 | 9.0 | 9.22500038146973 | 7531600.0 |
| 2001-08-02 | AAI-DELISTED | Stock | 8.68 | 8.68 | 8.51 | 8.55 | 132900.0 |
| 2001-08-02 | AAIC-DELISTED | Stock | 136.0 | 138.0 | 132.0 | 134.0 | 105700.0 |
| 2001-08-02 | AAME | Stock | 1.5 | 1.6 | 1.45 | 1.54 | 25300.0 |
| 2001-08-02 | AAON | Stock | 1.7646 | 1.867 | 1.7529 | 1.829 | 768867.0 |
| 2001-08-02 | AAXN-DELISTED | Stock | 0.520833313465118 | 0.520833313465118 | 0.511666655540466 | 0.516666650772095 | 88800.0 |
| 2001-08-02 | ABAX-DELISTED | Stock | 5.38 | 5.44 | 5.31 | 5.4 | 13100.0 |
| 2001-08-02 | ABB-DELISTED | Stock | 11.45 | 11.63 | 11.4 | 11.59 | 6200.0 |
| 2001-08-02 | ABC-DELISTED | Stock | 14.3500003814697 | 14.3500003814697 | 13.8249998092651 | 14.0749998092651 | 3212000.0 |
| 2001-08-02 | ABCB | Stock | 10.0831 | 10.4478 | 10.0831 | 10.0831 | 4195.0 |
| 2001-08-02 | ABCW-DELISTED | Stock | 16.25 | 16.31 | 16.1 | 16.31 | 8800.0 |
| 2001-08-02 | ABE-DELISTED | Stock | 7.65 | 7.71 | 7.65 | 7.7 | 10100.0 |
| 2001-08-02 | ABFS-DELISTED | Stock | 27.45 | 27.55 | 27.0 | 27.0 | 124000.0 |
| 2001-08-02 | ABK-DELISTED | Stock | 58.0 | 58.55 | 57.4 | 58.2 | 386800.0 |
| 2001-08-02 | ABM | Stock | 18.575 | 18.825 | 18.475 | 18.62 | 91000.0 |
| 2001-08-02 | ABMD-DELISTED | Stock | 20.29 | 20.49 | 19.38 | 19.38 | 97700.0 |
| 2001-08-02 | ABP-DELISTED | Stock | 3.4 | 3.43 | 3.37 | 3.37 | 27300.0 |
| 2001-08-02 | ABT | Stock | 23.9399 | 23.9399 | 23.1857 | 23.3428 | 7306067.0 |
| 2001-08-02 | ABTL-DELISTED | Stock | 4.6 | 4.85 | 4.25 | 4.5 | 21300.0 |
| 2001-08-02 | ABV-DELISTED | Stock | 20.35 | 20.55 | 20.19 | 20.35 | 352100.0 |
| 2001-08-02 | ABX-DELISTED | Stock | 14.7 | 14.77 | 14.46 | 14.54 | 1494100.0 |
| 2001-08-02 | ACAP-DELISTED | Stock | 21.44 | 21.8 | 21.1 | 21.56 | 28700.0 |
| 2001-08-02 | ACAS-DELISTED | Stock | 27.83 | 27.93 | 27.45 | 27.8 | 580000.0 |
| 2001-08-02 | ACAT-DELISTED | Stock | 14.34 | 14.45 | 14.31 | 14.45 | 11900.0 |
| 2001-08-02 | ACCL-DELISTED | Stock | 11.8754997253418 | 12.6719999313354 | 11.8754997253418 | 12.6719999313354 | 492900.0 |
| 2001-08-02 | ACE-DELISTED | Stock | 34.15 | 34.3 | 33.65 | 33.89 | 789700.0 |
| 2001-08-02 | ACF-DELISTED | Stock | 63.9 | 64.9 | 62.25 | 62.48 | 747600.0 |
| 2001-08-02 | ACG-DELISTED | Stock | 8.73 | 8.8 | 8.71 | 8.79 | 277000.0 |
| 2001-08-02 | ACGN-DELISTED | Stock | 1122.0 | 1235.3288 | 1122.0 | 1190.0 | 89100.0 |
| 2001-08-02 | ACH | Stock | 11.8333 | 12.0 | 11.7667 | 12.0 | 104100.0 |
| 2001-08-02 | ACLS | Stock | 60.4 | 61.2 | 59.0 | 61.0 | 342250.0 |
| 2001-08-02 | ACO-DELISTED | Stock | 6.06 | 6.34 | 6.06 | 6.34 | 11900.0 |
| 2001-08-02 | ACPW-DELISTED | Stock | 45.5 | 46.0 | 42.3 | 42.55 | 43640.0 |
| 2001-08-02 | ACS-DELISTED | Stock | 41.425 | 41.425 | 39.59 | 39.99 | 874100.0 |
| 2001-08-02 | ACTA-DELISTED | Stock | 30.6 | 33.0 | 30.0 | 33.0 | 73500.0 |
| 2001-08-02 | ACTT-DELISTED | Stock | 5.63 | 5.8 | 5.5 | 5.8 | 10200.0 |
| 2001-08-02 | ACTU-DELISTED | Stock | 10.05 | 10.65 | 10.05 | 10.65 | 364400.0 |
| 2001-08-02 | ACXM-DELISTED | Stock | 11.82 | 11.99 | 11.13 | 11.46 | 493300.0 |
| 2001-08-02 | ACY-DELISTED | Stock | 5.2 | 5.2 | 5.16 | 5.2 | 2000.0 |
| 2001-08-02 | AD | Stock | 38.5 | 39.1667 | 38.26 | 38.5 | 154950.0 |
| 2001-08-02 | ADAT-DELISTED | Stock | 89.1 | 89.64 | 80.1 | 80.1 | 561.0 |
| 2001-08-02 | ADBE | Stock | 19.575 | 19.62 | 18.5 | 19.275 | 7271400.0 |
| 2001-08-02 | ADC | Stock | 19.26 | 19.38 | 19.26 | 19.27 | 1700.0 |
| 2001-08-02 | ADEP-DELISTED | Stock | 37.75 | 40.5 | 37.5 | 40.05 | 14200.0 |
> showing 50 of 2,949 rows — these rows as CSV