PREVIEW / stock_daily / 2004-08-02
file: by_date/stock_daily/2004/2004-08-02.parquet size: 127 KB rows: 3,823 symbols: 2,392
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-02 | AAPL | Stock | 0.5568 | 0.575 | 0.5559 | 0.5639 | 365092000.0 |
| 2004-08-02 | MSFT | Stock | 28.27 | 28.55 | 28.16 | 28.52 | 52267000.0 |
| 2004-08-02 | NVDA | Stock | 0.1286 | 0.1307 | 0.1264 | 0.1302 | 420984000.0 |
| 2004-08-02 | AMZN | Stock | 1.9225 | 1.938 | 1.8905 | 1.915 | 118244000.0 |
| 2004-08-02 | CL | Stock | 26.605 | 26.78 | 26.58 | 26.67 | 2739600.0 |
| 2004-08-02 | A | Stock | 17.0386 | 17.2818 | 16.8097 | 17.1888 | 2675213.0 |
| 2004-08-02 | AABA-DELISTED | Stock | 30.5699996948242 | 30.6100006103516 | 30.1299991607666 | 30.4200000762939 | 12250800.0 |
| 2004-08-02 | AACC-DELISTED | Stock | 17.35 | 17.35 | 16.96 | 17.05 | 29521.0 |
| 2004-08-02 | AAI-DELISTED | Stock | 11.1 | 11.1 | 10.81 | 10.9 | 1017300.0 |
| 2004-08-02 | AAIC-DELISTED | Stock | 330.0 | 330.0 | 321.0 | 325.6 | 1823400.0 |
| 2004-08-02 | AAME | Stock | 2.98 | 3.0 | 2.91 | 2.95 | 9100.0 |
| 2004-08-02 | AAON | Stock | 2.3585 | 2.4257 | 2.3177 | 2.348 | 92644.0 |
| 2004-08-02 | AAP | Stock | 24.6133 | 24.7867 | 24.4 | 24.74 | 988650.0 |
| 2004-08-02 | AAXN-DELISTED | Stock | 14.3450002670288 | 15.375 | 14.2799997329712 | 15.1350002288818 | 10695600.0 |
| 2004-08-02 | ABAX-DELISTED | Stock | 15.14 | 15.14 | 14.69 | 14.95 | 135212.0 |
| 2004-08-02 | ABB-DELISTED | Stock | 5.51 | 5.56 | 5.45 | 5.56 | 1790000.0 |
| 2004-08-02 | ABC-DELISTED | Stock | 13.52 | 13.6 | 13.45 | 13.48 | 3722000.0 |
| 2004-08-02 | ABCB | Stock | 14.3545 | 14.5005 | 14.2087 | 14.2087 | 9130.0 |
| 2004-08-02 | ABCO-DELISTED | Stock | 16.0 | 16.12 | 15.715 | 15.75 | 159862.0 |
| 2004-08-02 | ABCW-DELISTED | Stock | 25.31 | 25.68 | 25.12 | 25.68 | 47670.0 |
| 2004-08-02 | ABE-DELISTED | Stock | 7.64 | 7.69 | 7.57 | 7.58 | 10400.0 |
| 2004-08-02 | ABFS-DELISTED | Stock | 35.0 | 36.12 | 34.65 | 36.1 | 360601.0 |
| 2004-08-02 | ABG | Stock | 13.52 | 13.97 | 13.51 | 13.78 | 29800.0 |
| 2004-08-02 | ABK-DELISTED | Stock | 70.4 | 71.3 | 70.23 | 71.15 | 436800.0 |
| 2004-08-02 | ABM | Stock | 17.89 | 18.24 | 17.75 | 18.24 | 119100.0 |
| 2004-08-02 | ABMD-DELISTED | Stock | 10.13 | 10.73 | 9.95 | 10.5 | 68362.0 |
| 2004-08-02 | ABP-DELISTED | Stock | 1.25 | 1.3 | 1.25 | 1.26 | 45000.0 |
| 2004-08-02 | ABR | Stock | 19.0 | 19.2 | 18.68 | 19.0 | 619500.0 |
| 2004-08-02 | ABT | Stock | 18.8801 | 18.9425 | 18.765 | 18.8369 | 4125886.0 |
| 2004-08-02 | ABTL-DELISTED | Stock | 33.5 | 35.45 | 33.05 | 35.0 | 66800.0 |
| 2004-08-02 | ABV-DELISTED | Stock | 20.4 | 20.89 | 20.35 | 20.58 | 130500.0 |
| 2004-08-02 | ABX-DELISTED | Stock | 19.11 | 19.3 | 18.95 | 19.16 | 707945.0 |
| 2004-08-02 | ACAD | Stock | 6.0 | 6.25 | 6.0 | 6.25 | 800.0 |
| 2004-08-02 | ACAP-DELISTED | Stock | 27.23 | 27.84 | 26.95 | 27.2 | 367087.0 |
| 2004-08-02 | ACAS-DELISTED | Stock | 29.16 | 29.23 | 28.52 | 28.52 | 1146681.0 |
| 2004-08-02 | ACAT-DELISTED | Stock | 27.04 | 27.94 | 26.94 | 27.62 | 53641.0 |
| 2004-08-02 | ACCL-DELISTED | Stock | 7.43 | 7.64 | 7.05 | 7.06 | 156352.0 |
| 2004-08-02 | ACE-DELISTED | Stock | 40.5 | 40.6 | 39.54 | 39.85 | 1196300.0 |
| 2004-08-02 | ACF-DELISTED | Stock | 18.75 | 19.06 | 18.7 | 19.03 | 792200.0 |
| 2004-08-02 | ACG-DELISTED | Stock | 8.23 | 8.25 | 8.21 | 8.25 | 356300.0 |
| 2004-08-02 | ACGL | Stock | 4.2878 | 4.2878 | 4.2333 | 4.2733 | 865800.0 |
| 2004-08-02 | ACGN-DELISTED | Stock | 544.0 | 544.0 | 510.0 | 532.6712 | 46300.0 |
| 2004-08-02 | ACH | Stock | 17.1133 | 17.2867 | 16.76 | 17.28 | 243300.0 |
| 2004-08-02 | ACH-DELISTED | Stock | 12.831 | 12.944 | 12.766 | 12.944 | 218707.0 |
| 2004-08-02 | ACLS | Stock | 37.96 | 38.0 | 36.08 | 37.2 | 188950.0 |
| 2004-08-02 | ACO-DELISTED | Stock | 20.1 | 20.9 | 19.65 | 19.69 | 691800.0 |
| 2004-08-02 | ACPW-DELISTED | Stock | 15.5 | 16.3 | 15.0 | 16.1 | 24595.0 |
| 2004-08-02 | ACS-DELISTED | Stock | 51.9 | 52.97 | 51.12 | 52.75 | 1739100.0 |
| 2004-08-02 | ACTA-DELISTED | Stock | 5.1 | 5.29 | 5.01 | 5.08 | 355700.0 |
| 2004-08-02 | ACTG | Stock | 3.23 | 3.23 | 2.97 | 2.99 | 65000.0 |
> showing 50 of 3,823 rows — these rows as CSV