PREVIEW / stock_daily / 2004-11-01
file: by_date/stock_daily/2004/2004-11-01.parquet size: 130 KB rows: 3,877 symbols: 2,427
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-01 | AAPL | Stock | 0.9375 | 0.9511 | 0.9293 | 0.9366 | 602050400.0 |
| 2004-11-01 | MSFT | Stock | 28.16 | 28.28 | 27.96 | 28.08 | 72930900.0 |
| 2004-11-01 | NVDA | Stock | 0.1222 | 0.1232 | 0.1207 | 0.1232 | 653892000.0 |
| 2004-11-01 | AMZN | Stock | 1.711 | 1.7575 | 1.7075 | 1.755 | 123626000.0 |
| 2004-11-01 | CL | Stock | 22.31 | 22.495 | 22.27 | 22.35 | 6800200.0 |
| 2004-11-01 | A | Stock | 17.8469 | 18.0258 | 17.5966 | 17.6753 | 2830111.0 |
| 2004-11-01 | AABA-DELISTED | Stock | 35.9099998474121 | 37.0 | 35.8600006103516 | 36.9199981689453 | 16436900.0 |
| 2004-11-01 | AACC-DELISTED | Stock | 18.37 | 18.54 | 17.53 | 17.97 | 39713.0 |
| 2004-11-01 | AAI-DELISTED | Stock | 11.55 | 11.82 | 11.21 | 11.53 | 1329100.0 |
| 2004-11-01 | AAIC-DELISTED | Stock | 346.0 | 346.8 | 336.4 | 338.0 | 2474700.0 |
| 2004-11-01 | AAME | Stock | 3.0 | 3.0 | 2.96 | 3.0 | 12200.0 |
| 2004-11-01 | AAON | Stock | 1.9345 | 1.9608 | 1.916 | 1.9174 | 49359.0 |
| 2004-11-01 | AAP | Stock | 25.9667 | 26.2667 | 25.8 | 26.2667 | 1051800.0 |
| 2004-11-01 | AAV-DELISTED | Stock | 17.19 | 17.61 | 17.08 | 17.19 | 24800.0 |
| 2004-11-01 | AAXN-DELISTED | Stock | 20.9300003051758 | 21.1949996948242 | 20.5550003051758 | 20.7649993896484 | 6864600.0 |
| 2004-11-01 | ABAX-DELISTED | Stock | 12.75 | 12.97 | 12.56 | 12.89 | 57120.0 |
| 2004-11-01 | ABB-DELISTED | Stock | 5.74 | 5.8 | 5.73 | 5.75 | 410800.0 |
| 2004-11-01 | ABC-DELISTED | Stock | 13.76 | 13.85 | 13.62 | 13.65 | 4182400.0 |
| 2004-11-01 | ABCB | Stock | 16.4214 | 17.1347 | 15.9757 | 17.0942 | 13817.0 |
| 2004-11-01 | ABCO-DELISTED | Stock | 16.257 | 17.468 | 16.222 | 17.088 | 250811.0 |
| 2004-11-01 | ABCW-DELISTED | Stock | 25.72 | 26.35 | 25.71 | 26.25 | 18580.0 |
| 2004-11-01 | ABE-DELISTED | Stock | 8.59 | 8.59 | 8.41 | 8.57 | 6700.0 |
| 2004-11-01 | ABFS-DELISTED | Stock | 39.0 | 39.61 | 38.85 | 39.22 | 253741.0 |
| 2004-11-01 | ABG | Stock | 13.45 | 13.96 | 13.44 | 13.96 | 11600.0 |
| 2004-11-01 | ABK-DELISTED | Stock | 78.31 | 78.75 | 76.07 | 76.65 | 831400.0 |
| 2004-11-01 | ABM | Stock | 20.6 | 21.1 | 20.37 | 21.04 | 107000.0 |
| 2004-11-01 | ABMD-DELISTED | Stock | 11.3 | 12.93 | 11.3 | 12.83 | 290903.0 |
| 2004-11-01 | ABP-DELISTED | Stock | 2.79 | 2.89 | 2.76 | 2.8 | 343600.0 |
| 2004-11-01 | ABR | Stock | 21.2 | 21.4 | 21.12 | 21.4 | 54700.0 |
| 2004-11-01 | ABT | Stock | 20.3915 | 20.6122 | 20.2811 | 20.5067 | 9146103.0 |
| 2004-11-01 | ABTL-DELISTED | Stock | 34.8 | 34.95 | 33.6 | 34.5 | 89200.0 |
| 2004-11-01 | ABV-DELISTED | Stock | 24.69 | 25.01 | 24.61 | 24.95 | 322900.0 |
| 2004-11-01 | ABX-DELISTED | Stock | 22.48 | 22.49 | 21.84 | 21.88 | 1993779.0 |
| 2004-11-01 | ACAD | Stock | 7.6 | 7.6 | 7.32 | 7.59 | 3300.0 |
| 2004-11-01 | ACAP-DELISTED | Stock | 31.7 | 31.98 | 31.7 | 31.82 | 22849.0 |
| 2004-11-01 | ACAS-DELISTED | Stock | 31.054 | 31.31 | 30.855 | 31.12 | 586601.0 |
| 2004-11-01 | ACAT-DELISTED | Stock | 24.53 | 25.15 | 24.53 | 25.05 | 81686.0 |
| 2004-11-01 | ACC-DELISTED | Stock | 18.9 | 18.9 | 18.5 | 18.75 | 36600.0 |
| 2004-11-01 | ACCL-DELISTED | Stock | 5.86 | 6.03 | 5.77 | 6.02 | 82175.0 |
| 2004-11-01 | ACE-DELISTED | Stock | 38.2 | 38.6 | 37.72 | 38.31 | 1012300.0 |
| 2004-11-01 | ACF-DELISTED | Stock | 19.23 | 19.5 | 19.08 | 19.37 | 855500.0 |
| 2004-11-01 | ACFC-DELISTED | Stock | 65.15 | 66.07 | 65.05 | 65.92 | 7973.0 |
| 2004-11-01 | ACG-DELISTED | Stock | 8.18 | 8.19 | 8.17 | 8.19 | 492100.0 |
| 2004-11-01 | ACGL | Stock | 4.1767 | 4.1989 | 4.1278 | 4.1567 | 3024900.0 |
| 2004-11-01 | ACGN-DELISTED | Stock | 600.6712 | 612.0 | 589.3288 | 612.0 | 46300.0 |
| 2004-11-01 | ACH | Stock | 17.4667 | 17.54 | 17.1733 | 17.4 | 257850.0 |
| 2004-11-01 | ACH-DELISTED | Stock | 14.488 | 14.498 | 14.375 | 14.453 | 169198.0 |
| 2004-11-01 | ACLS | Stock | 34.52 | 34.96 | 33.76 | 34.64 | 181950.0 |
| 2004-11-01 | ACO-DELISTED | Stock | 17.34 | 17.67 | 17.21 | 17.57 | 102100.0 |
| 2004-11-01 | ACPW-DELISTED | Stock | 16.198 | 16.697 | 15.798 | 16.602 | 17174.0 |
> showing 50 of 3,877 rows — these rows as CSV