PREVIEW / stock_daily / 2001-11-02
file: by_date/stock_daily/2001/2001-11-02.parquet size: 101 KB rows: 2,981 symbols: 1,849
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-11-02 | AAPL | Stock | 0.3307 | 0.3368 | 0.3243 | 0.3316 | 197204000.0 |
| 2001-11-02 | MSFT | Stock | 30.965 | 31.51 | 30.255 | 30.7 | 83360000.0 |
| 2001-11-02 | NVDA | Stock | 0.3859 | 0.3978 | 0.3717 | 0.3931 | 1087248000.0 |
| 2001-11-02 | AMZN | Stock | 0.3475 | 0.3475 | 0.3335 | 0.3355 | 73942000.0 |
| 2001-11-02 | CL | Stock | 28.88 | 29.25 | 28.675 | 29.25 | 3057800.0 |
| 2001-11-02 | A | Stock | 16.5594 | 16.774 | 16.3162 | 16.6667 | 1321669.0 |
| 2001-11-02 | AABA-DELISTED | Stock | 5.56500005722046 | 5.625 | 5.41499996185303 | 5.48000001907349 | 10678000.0 |
| 2001-11-02 | AAI-DELISTED | Stock | 3.9 | 4.04 | 3.85 | 3.93 | 379500.0 |
| 2001-11-02 | AAIC-DELISTED | Stock | 101.0 | 101.0 | 98.2 | 99.0 | 84500.0 |
| 2001-11-02 | AAME | Stock | 1.41 | 1.41 | 1.41 | 1.41 | 200.0 |
| 2001-11-02 | AAON | Stock | 1.5188 | 1.5232 | 1.4925 | 1.4925 | 33033.0 |
| 2001-11-02 | AAXN-DELISTED | Stock | 0.808333337306976 | 0.833333313465118 | 0.804166674613953 | 0.822499990463257 | 470400.0 |
| 2001-11-02 | ABAX-DELISTED | Stock | 3.87 | 4.0005 | 3.8689 | 4.0005 | 14300.0 |
| 2001-11-02 | ABB-DELISTED | Stock | 9.05 | 9.05 | 8.97 | 9.0 | 9500.0 |
| 2001-11-02 | ABC-DELISTED | Stock | 15.75 | 15.86 | 15.54 | 15.59 | 4826400.0 |
| 2001-11-02 | ABCB | Stock | 10.4884 | 10.4884 | 10.4154 | 10.4154 | 1604.0 |
| 2001-11-02 | ABCW-DELISTED | Stock | 15.8 | 15.8 | 15.67 | 15.67 | 17800.0 |
| 2001-11-02 | ABE-DELISTED | Stock | 6.6 | 6.6 | 6.51 | 6.58 | 3900.0 |
| 2001-11-02 | ABFS-DELISTED | Stock | 23.6 | 24.75 | 23.56 | 24.4 | 175000.0 |
| 2001-11-02 | ABK-DELISTED | Stock | 49.3 | 50.74 | 49.3 | 50.35 | 371300.0 |
| 2001-11-02 | ABM | Stock | 13.6 | 13.635 | 13.355 | 13.625 | 170400.0 |
| 2001-11-02 | ABMD-DELISTED | Stock | 22.99 | 24.1 | 22.32 | 22.8793 | 141500.0 |
| 2001-11-02 | ABP-DELISTED | Stock | 1.55 | 1.58 | 1.42 | 1.53 | 32800.0 |
| 2001-11-02 | ABT | Stock | 24.2047 | 24.5549 | 23.9489 | 24.4427 | 6073501.0 |
| 2001-11-02 | ABTL-DELISTED | Stock | 6.75 | 7.1 | 6.4 | 7.0 | 31600.0 |
| 2001-11-02 | ABV-DELISTED | Stock | 16.8 | 17.45 | 16.8 | 17.25 | 405300.0 |
| 2001-11-02 | ABX-DELISTED | Stock | 15.6 | 16.1 | 15.43 | 16.03 | 1462500.0 |
| 2001-11-02 | ACAP-DELISTED | Stock | 23.09 | 23.09 | 22.7 | 22.72 | 18600.0 |
| 2001-11-02 | ACAS-DELISTED | Stock | 26.35 | 26.54 | 26.02 | 26.23 | 209100.0 |
| 2001-11-02 | ACAT-DELISTED | Stock | 16.47 | 16.47 | 15.92 | 15.95 | 19400.0 |
| 2001-11-02 | ACCL-DELISTED | Stock | 11.0299997329712 | 11.2379999160767 | 9.88399982452393 | 9.97799968719482 | 292900.0 |
| 2001-11-02 | ACE-DELISTED | Stock | 37.05 | 38.7 | 36.85 | 38.34 | 2559500.0 |
| 2001-11-02 | ACF-DELISTED | Stock | 16.0 | 16.05 | 14.0 | 14.96 | 3640700.0 |
| 2001-11-02 | ACG-DELISTED | Stock | 8.68 | 8.75 | 8.68 | 8.74 | 298600.0 |
| 2001-11-02 | ACGL | Stock | 2.6444 | 2.6444 | 2.6389 | 2.6444 | 78300.0 |
| 2001-11-02 | ACGN-DELISTED | Stock | 1246.6712 | 1246.6712 | 1133.3288 | 1224.0 | 11500.0 |
| 2001-11-02 | ACH | Stock | 11.9867 | 12.6667 | 11.9667 | 12.4 | 207450.0 |
| 2001-11-02 | ACLS | Stock | 53.68 | 56.6 | 53.68 | 55.6 | 159200.0 |
| 2001-11-02 | ACO-DELISTED | Stock | 5.8 | 5.95 | 5.75 | 5.8 | 46300.0 |
| 2001-11-02 | ACPW-DELISTED | Stock | 26.25 | 27.5 | 24.5 | 26.2 | 30440.0 |
| 2001-11-02 | ACS-DELISTED | Stock | 45.0 | 45.995 | 44.82 | 45.9 | 335800.0 |
| 2001-11-02 | ACTA-DELISTED | Stock | 18.0 | 19.2 | 17.4 | 18.8 | 129300.0 |
| 2001-11-02 | ACTT-DELISTED | Stock | 9.7 | 10.65 | 9.69 | 10.44 | 56300.0 |
| 2001-11-02 | ACTU-DELISTED | Stock | 4.34 | 5.0 | 4.1 | 4.75 | 2977100.0 |
| 2001-11-02 | ACXM-DELISTED | Stock | 11.2 | 11.7 | 11.1 | 11.45 | 1224600.0 |
| 2001-11-02 | ACY-DELISTED | Stock | 5.4 | 5.5 | 5.35 | 5.35 | 1400.0 |
| 2001-11-02 | AD | Stock | 29.2 | 29.4267 | 28.6667 | 29.2 | 264000.0 |
| 2001-11-02 | ADAT-DELISTED | Stock | 82.08 | 82.08 | 79.2 | 80.82 | 2412.0 |
| 2001-11-02 | ADBE | Stock | 13.57 | 13.75 | 13.15 | 13.475 | 10423400.0 |
| 2001-11-02 | ADC | Stock | 19.0 | 19.19 | 19.0 | 19.19 | 1700.0 |
> showing 50 of 2,981 rows — these rows as CSV