PREVIEW / stock_daily / 2004-11-02
file: by_date/stock_daily/2004/2004-11-02.parquet size: 130 KB rows: 3,888 symbols: 2,431
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-11-02 | AAPL | Stock | 0.9357 | 0.9657 | 0.9357 | 0.9554 | 729988000.0 |
| 2004-11-02 | MSFT | Stock | 28.26 | 28.47 | 28.03 | 28.24 | 89417100.0 |
| 2004-11-02 | NVDA | Stock | 0.1228 | 0.1275 | 0.1218 | 0.1249 | 1095756000.0 |
| 2004-11-02 | AMZN | Stock | 1.7745 | 1.8245 | 1.757 | 1.812 | 226650000.0 |
| 2004-11-02 | CL | Stock | 22.475 | 22.75 | 22.18 | 22.51 | 6815800.0 |
| 2004-11-02 | A | Stock | 17.5036 | 18.1617 | 17.4392 | 17.8255 | 3595936.0 |
| 2004-11-02 | AABA-DELISTED | Stock | 37.0299987792969 | 38.1500015258789 | 36.8899993896484 | 37.7400016784668 | 22925400.0 |
| 2004-11-02 | AACC-DELISTED | Stock | 18.0 | 18.43 | 17.5 | 17.61 | 103288.0 |
| 2004-11-02 | AAI-DELISTED | Stock | 11.52 | 12.26 | 11.45 | 12.25 | 2276100.0 |
| 2004-11-02 | AAIC-DELISTED | Stock | 339.0 | 349.8 | 337.4 | 342.8 | 3568000.0 |
| 2004-11-02 | AAME | Stock | 3.0 | 3.0 | 2.9 | 3.0 | 16700.0 |
| 2004-11-02 | AAON | Stock | 1.9174 | 1.9714 | 1.9134 | 1.9187 | 124537.0 |
| 2004-11-02 | AAP | Stock | 26.22 | 26.3133 | 25.8867 | 25.9333 | 1171800.0 |
| 2004-11-02 | AAXN-DELISTED | Stock | 20.7700004577637 | 21.4349994659424 | 20.6849994659424 | 20.9050006866455 | 8200800.0 |
| 2004-11-02 | ABAX-DELISTED | Stock | 12.92 | 13.13 | 12.66 | 12.73 | 136472.0 |
| 2004-11-02 | ABB-DELISTED | Stock | 5.74 | 5.75 | 5.66 | 5.71 | 291300.0 |
| 2004-11-02 | ABC-DELISTED | Stock | 13.86 | 14.29 | 13.86 | 14.03 | 20920800.0 |
| 2004-11-02 | ABCB | Stock | 17.0942 | 17.2482 | 16.8672 | 16.8672 | 10735.0 |
| 2004-11-02 | ABCO-DELISTED | Stock | 17.083 | 17.487 | 16.738 | 17.277 | 330631.0 |
| 2004-11-02 | ABCW-DELISTED | Stock | 26.02 | 26.33 | 25.81 | 25.98 | 45430.0 |
| 2004-11-02 | ABE-DELISTED | Stock | 8.52 | 8.69 | 8.52 | 8.61 | 15300.0 |
| 2004-11-02 | ABFS-DELISTED | Stock | 38.67 | 39.63 | 38.57 | 39.15 | 246690.0 |
| 2004-11-02 | ABG | Stock | 13.87 | 14.0 | 13.8 | 13.96 | 23700.0 |
| 2004-11-02 | ABK-DELISTED | Stock | 77.2 | 78.42 | 76.48 | 77.69 | 801800.0 |
| 2004-11-02 | ABM | Stock | 20.85 | 21.36 | 20.55 | 20.67 | 130300.0 |
| 2004-11-02 | ABMD-DELISTED | Stock | 12.64 | 13.89 | 12.64 | 13.16 | 366183.0 |
| 2004-11-02 | ABP-DELISTED | Stock | 2.8 | 2.8 | 2.56 | 2.59 | 205600.0 |
| 2004-11-02 | ABR | Stock | 21.4 | 21.6 | 21.38 | 21.47 | 68900.0 |
| 2004-11-02 | ABT | Stock | 20.4155 | 20.6266 | 20.2092 | 20.3003 | 11304919.0 |
| 2004-11-02 | ABTL-DELISTED | Stock | 34.95 | 34.95 | 33.85 | 34.8 | 57100.0 |
| 2004-11-02 | ABV-DELISTED | Stock | 24.93 | 25.13 | 24.51 | 24.7 | 256800.0 |
| 2004-11-02 | ABVA-DELISTED | Stock | 14.98 | 14.98 | 14.78 | 14.78 | 4728.0 |
| 2004-11-02 | ABX-DELISTED | Stock | 21.77 | 21.82 | 21.06 | 21.39 | 2087200.0 |
| 2004-11-02 | ACAD | Stock | 7.37 | 7.58 | 7.36 | 7.36 | 2300.0 |
| 2004-11-02 | ACAP-DELISTED | Stock | 31.9 | 31.9 | 31.13 | 31.17 | 31011.0 |
| 2004-11-02 | ACAS-DELISTED | Stock | 31.3 | 31.36 | 30.99 | 31.275 | 507447.0 |
| 2004-11-02 | ACAT-DELISTED | Stock | 24.7 | 25.18 | 24.65 | 25.12 | 81426.0 |
| 2004-11-02 | ACC-DELISTED | Stock | 18.8 | 19.07 | 18.77 | 18.98 | 19986.0 |
| 2004-11-02 | ACCL-DELISTED | Stock | 6.0 | 6.12 | 5.839 | 5.84 | 71836.0 |
| 2004-11-02 | ACE-DELISTED | Stock | 38.25 | 38.68 | 37.75 | 38.01 | 1327400.0 |
| 2004-11-02 | ACF-DELISTED | Stock | 19.35 | 19.53 | 19.28 | 19.32 | 1016200.0 |
| 2004-11-02 | ACFC-DELISTED | Stock | 65.56 | 66.07 | 65.31 | 66.07 | 5191.0 |
| 2004-11-02 | ACG-DELISTED | Stock | 8.19 | 8.22 | 8.18 | 8.21 | 372800.0 |
| 2004-11-02 | ACGL | Stock | 4.1656 | 4.1667 | 4.1122 | 4.1333 | 1773900.0 |
| 2004-11-02 | ACGN-DELISTED | Stock | 612.0 | 612.0 | 589.3288 | 612.0 | 14100.0 |
| 2004-11-02 | ACH | Stock | 17.38 | 17.6667 | 17.3333 | 17.4933 | 256800.0 |
| 2004-11-02 | ACH-DELISTED | Stock | 14.757 | 14.893 | 14.74 | 14.768 | 567330.0 |
| 2004-11-02 | ACLS | Stock | 34.2 | 35.04 | 33.72 | 34.44 | 193975.0 |
| 2004-11-02 | ACO-DELISTED | Stock | 17.75 | 18.0 | 17.65 | 17.74 | 109700.0 |
| 2004-11-02 | ACPW-DELISTED | Stock | 16.05 | 16.95 | 16.0 | 16.75 | 11837.0 |
> showing 50 of 3,888 rows — these rows as CSV