PREVIEW / stock_daily / 2002-08-02
file: by_date/stock_daily/2002/2002-08-02.parquet size: 106 KB rows: 3,135 symbols: 1,942
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 |
|---|---|---|---|---|---|---|---|
| 2002-08-02 | AAPL | Stock | 0.2632 | 0.2679 | 0.2545 | 0.258 | 179060000.0 |
| 2002-08-02 | MSFT | Stock | 22.755 | 22.925 | 21.9 | 22.205 | 85947600.0 |
| 2002-08-02 | NVDA | Stock | 0.0861 | 0.0867 | 0.0758 | 0.0779 | 1795260000.0 |
| 2002-08-02 | AMZN | Stock | 0.7065 | 0.707 | 0.6725 | 0.692 | 83572000.0 |
| 2002-08-02 | CL | Stock | 26.21 | 26.475 | 25.71 | 26.175 | 5616200.0 |
| 2002-08-02 | A | Stock | 12.3748 | 12.475 | 11.6237 | 12.0458 | 2628659.0 |
| 2002-08-02 | AABA-DELISTED | Stock | 6.08500003814697 | 6.09000015258789 | 5.65999984741211 | 5.78999996185303 | 17923400.0 |
| 2002-08-02 | AAI-DELISTED | Stock | 3.65 | 3.74 | 3.58 | 3.6 | 115400.0 |
| 2002-08-02 | AAIC-DELISTED | Stock | 200.0 | 200.0 | 188.0 | 194.0 | 213600.0 |
| 2002-08-02 | AAME | Stock | 1.92 | 2.19 | 1.91 | 2.19 | 3100.0 |
| 2002-08-02 | AAON | Stock | 2.2255 | 2.2519 | 2.1597 | 2.1847 | 110109.0 |
| 2002-08-02 | AAP | Stock | 16.15 | 16.1567 | 15.15 | 15.7233 | 1148700.0 |
| 2002-08-02 | AAXN-DELISTED | Stock | 0.424166679382324 | 0.457500010728836 | 0.423333346843719 | 0.452499985694885 | 988800.0 |
| 2002-08-02 | ABAX-DELISTED | Stock | 3.61 | 3.7 | 3.55 | 3.7 | 5800.0 |
| 2002-08-02 | ABB-DELISTED | Stock | 4.5 | 4.91 | 4.4 | 4.79 | 241200.0 |
| 2002-08-02 | ABC-DELISTED | Stock | 16.32 | 16.95 | 16.06 | 16.25 | 5533200.0 |
| 2002-08-02 | ABCB | Stock | 11.7365 | 11.9554 | 11.1286 | 11.7689 | 14683.0 |
| 2002-08-02 | ABCO-DELISTED | Stock | 16.627 | 16.668 | 16.218 | 16.243 | 198421.0 |
| 2002-08-02 | ABCW-DELISTED | Stock | 21.82 | 22.07 | 21.81 | 21.87 | 91700.0 |
| 2002-08-02 | ABE-DELISTED | Stock | 6.2 | 6.2 | 6.05 | 6.05 | 14400.0 |
| 2002-08-02 | ABFS-DELISTED | Stock | 20.21 | 20.28 | 18.22 | 18.67 | 258174.0 |
| 2002-08-02 | ABG | Stock | 11.2 | 11.3 | 10.27 | 10.3 | 79400.0 |
| 2002-08-02 | ABK-DELISTED | Stock | 62.26 | 62.5 | 58.91 | 59.39 | 858700.0 |
| 2002-08-02 | ABM | Stock | 16.45 | 16.45 | 15.85 | 15.88 | 127700.0 |
| 2002-08-02 | ABMD-DELISTED | Stock | 6.3 | 6.599 | 5.6 | 6.4577 | 71584.0 |
| 2002-08-02 | ABP-DELISTED | Stock | 0.53 | 0.57 | 0.48 | 0.53 | 40800.0 |
| 2002-08-02 | ABT | Stock | 17.9156 | 18.3017 | 17.7136 | 18.0099 | 10672735.0 |
| 2002-08-02 | ABTL-DELISTED | Stock | 10.25 | 11.0 | 10.25 | 11.0 | 6700.0 |
| 2002-08-02 | ABV-DELISTED | Stock | 13.7 | 14.05 | 13.65 | 13.82 | 662200.0 |
| 2002-08-02 | ABVA-DELISTED | Stock | 8.5 | 8.75 | 8.35 | 8.6 | 64000.0 |
| 2002-08-02 | ABX-DELISTED | Stock | 15.55 | 15.76 | 15.47 | 15.71 | 3167900.0 |
| 2002-08-02 | ACAP-DELISTED | Stock | 16.0 | 16.49 | 15.8 | 15.8 | 26755.0 |
| 2002-08-02 | ACAS-DELISTED | Stock | 25.36 | 25.64 | 24.38 | 24.38 | 483550.0 |
| 2002-08-02 | ACAT-DELISTED | Stock | 14.66 | 14.8 | 14.0 | 14.15 | 51643.0 |
| 2002-08-02 | ACCL-DELISTED | Stock | 4.7574200630188 | 4.7646598815918 | 4.45328998565674 | 4.7646598815918 | 223100.0 |
| 2002-08-02 | ACE-DELISTED | Stock | 31.9 | 31.93 | 30.5 | 31.09 | 1954600.0 |
| 2002-08-02 | ACF-DELISTED | Stock | 18.8 | 18.8 | 16.9 | 17.38 | 1926600.0 |
| 2002-08-02 | ACG-DELISTED | Stock | 7.84 | 7.92 | 7.83 | 7.91 | 405000.0 |
| 2002-08-02 | ACGL | Stock | 3.0089 | 3.0422 | 2.9778 | 3.0389 | 200700.0 |
| 2002-08-02 | ACGN-DELISTED | Stock | 963.3288 | 1110.6712 | 963.3288 | 1042.6712 | 9500.0 |
| 2002-08-02 | ACH | Stock | 10.0 | 10.0 | 9.6133 | 9.7067 | 173100.0 |
| 2002-08-02 | ACH-DELISTED | Stock | 3.675 | 3.71 | 3.675 | 3.685 | 22400.0 |
| 2002-08-02 | ACLS | Stock | 31.36 | 31.6 | 29.6 | 29.76 | 177425.0 |
| 2002-08-02 | ACO-DELISTED | Stock | 5.28 | 5.65 | 5.2 | 5.45 | 24000.0 |
| 2002-08-02 | ACPW-DELISTED | Stock | 11.3 | 12.0 | 11.25 | 11.25 | 32169.0 |
| 2002-08-02 | ACS-DELISTED | Stock | 44.2 | 44.32 | 42.9 | 43.0 | 1221500.0 |
| 2002-08-02 | ACTA-DELISTED | Stock | 4.4 | 4.6 | 4.2 | 4.6 | 25200.0 |
| 2002-08-02 | ACTT-DELISTED | Stock | 2.1 | 2.15 | 2.0 | 2.14 | 17600.0 |
| 2002-08-02 | ACTU-DELISTED | Stock | 1.89 | 2.04 | 1.89 | 1.97 | 294576.0 |
| 2002-08-02 | ACXM-DELISTED | Stock | 16.0 | 16.01 | 15.5 | 15.9 | 717209.0 |
> showing 50 of 3,135 rows — these rows as CSV