PREVIEW / stock_daily / 2004-09-23
file: by_date/stock_daily/2004/2004-09-23.parquet size: 128 KB rows: 3,816 symbols: 2,379
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-09-23 | AAPL | Stock | 0.6614 | 0.6696 | 0.6595 | 0.6655 | 397404000.0 |
| 2004-09-23 | MSFT | Stock | 27.19 | 27.39 | 27.17 | 27.35 | 52155800.0 |
| 2004-09-23 | NVDA | Stock | 0.1211 | 0.1214 | 0.1176 | 0.1207 | 578664000.0 |
| 2004-09-23 | AMZN | Stock | 2.0665 | 2.11 | 2.0555 | 2.0915 | 148220000.0 |
| 2004-09-23 | CL | Stock | 22.975 | 23.175 | 22.85 | 22.9 | 14731600.0 |
| 2004-09-23 | A | Stock | 16.1445 | 16.4378 | 16.0086 | 16.1803 | 3216379.0 |
| 2004-09-23 | AABA-DELISTED | Stock | 32.7099990844727 | 33.3300018310547 | 32.3300018310547 | 33.0400009155273 | 15695100.0 |
| 2004-09-23 | AACC-DELISTED | Stock | 16.91 | 17.05 | 16.81 | 16.88 | 14618.0 |
| 2004-09-23 | AAI-DELISTED | Stock | 10.75 | 10.92 | 10.33 | 10.49 | 1378900.0 |
| 2004-09-23 | AAIC-DELISTED | Stock | 409.0 | 414.6 | 407.2 | 412.2 | 1300600.0 |
| 2004-09-23 | AAME | Stock | 3.04 | 3.09 | 3.0 | 3.0 | 9700.0 |
| 2004-09-23 | AAON | Stock | 2.3928 | 2.4151 | 2.3928 | 2.4033 | 56194.0 |
| 2004-09-23 | AAP | Stock | 23.52 | 23.92 | 23.5067 | 23.72 | 2120400.0 |
| 2004-09-23 | AAV-DELISTED | Stock | 16.29 | 16.3 | 16.02 | 16.29 | 21100.0 |
| 2004-09-23 | AAXN-DELISTED | Stock | 19.1499996185303 | 19.7000007629395 | 18.8999996185303 | 19.3899993896484 | 12094400.0 |
| 2004-09-23 | ABAX-DELISTED | Stock | 14.35 | 14.7 | 14.31 | 14.35 | 73551.0 |
| 2004-09-23 | ABB-DELISTED | Stock | 6.06 | 6.1 | 6.03 | 6.07 | 73800.0 |
| 2004-09-23 | ABC-DELISTED | Stock | 13.56 | 13.77 | 13.56 | 13.67 | 4519600.0 |
| 2004-09-23 | ABCB | Stock | 15.157 | 15.4488 | 15.1489 | 15.3029 | 18383.0 |
| 2004-09-23 | ABCO-DELISTED | Stock | 16.645 | 16.855 | 16.485 | 16.615 | 216448.0 |
| 2004-09-23 | ABCW-DELISTED | Stock | 25.59 | 25.68 | 25.37 | 25.5 | 42330.0 |
| 2004-09-23 | ABE-DELISTED | Stock | 7.87 | 8.0 | 7.87 | 7.97 | 15000.0 |
| 2004-09-23 | ABFS-DELISTED | Stock | 36.47 | 36.57 | 35.6 | 35.6 | 147601.0 |
| 2004-09-23 | ABG | Stock | 13.7 | 13.7 | 13.25 | 13.25 | 30200.0 |
| 2004-09-23 | ABK-DELISTED | Stock | 78.48 | 78.54 | 77.13 | 77.4 | 709200.0 |
| 2004-09-23 | ABM | Stock | 20.29 | 20.6 | 20.23 | 20.36 | 113300.0 |
| 2004-09-23 | ABMD-DELISTED | Stock | 9.87 | 10.15 | 9.87 | 10.07 | 129994.0 |
| 2004-09-23 | ABP-DELISTED | Stock | 1.89 | 1.99 | 1.87 | 1.99 | 203700.0 |
| 2004-09-23 | ABR | Stock | 20.98 | 21.03 | 20.85 | 20.9 | 1500.0 |
| 2004-09-23 | ABT | Stock | 20.214 | 20.3915 | 20.2092 | 20.3291 | 7969362.0 |
| 2004-09-23 | ABTL-DELISTED | Stock | 43.55 | 44.3 | 42.95 | 44.05 | 40400.0 |
| 2004-09-23 | ABV-DELISTED | Stock | 21.67 | 21.98 | 21.67 | 21.73 | 263800.0 |
| 2004-09-23 | ABVA-DELISTED | Stock | 14.9 | 14.9 | 14.8 | 14.8 | 4200.0 |
| 2004-09-23 | ABVT-DELISTED | Stock | 21.0 | 24.0 | 21.0 | 24.0 | 2400.0 |
| 2004-09-23 | ABX-DELISTED | Stock | 20.05 | 20.12 | 19.85 | 19.85 | 1233178.0 |
| 2004-09-23 | ACAD | Stock | 7.02 | 7.25 | 7.02 | 7.25 | 5400.0 |
| 2004-09-23 | ACAP-DELISTED | Stock | 30.0 | 30.27 | 30.0 | 30.18 | 13577.0 |
| 2004-09-23 | ACAS-DELISTED | Stock | 31.79 | 31.8 | 31.6 | 31.65 | 921233.0 |
| 2004-09-23 | ACAT-DELISTED | Stock | 26.55 | 26.55 | 25.97 | 26.04 | 13519.0 |
| 2004-09-23 | ACC-DELISTED | Stock | 18.68 | 19.08 | 18.6 | 18.72 | 89783.0 |
| 2004-09-23 | ACCL-DELISTED | Stock | 5.89 | 6.06 | 5.75 | 5.82 | 198832.0 |
| 2004-09-23 | ACE-DELISTED | Stock | 39.3 | 39.47 | 39.04 | 39.27 | 764900.0 |
| 2004-09-23 | ACF-DELISTED | Stock | 21.27 | 21.62 | 21.13 | 21.45 | 512100.0 |
| 2004-09-23 | ACG-DELISTED | Stock | 8.15 | 8.17 | 8.14 | 8.14 | 285400.0 |
| 2004-09-23 | ACGL | Stock | 4.3578 | 4.3578 | 4.2656 | 4.28 | 1542600.0 |
| 2004-09-23 | ACGN-DELISTED | Stock | 646.0 | 714.0 | 623.3288 | 714.0 | 311600.0 |
| 2004-09-23 | ACH | Stock | 16.9 | 17.0067 | 16.64 | 16.8 | 139050.0 |
| 2004-09-23 | ACH-DELISTED | Stock | 15.45 | 15.888 | 15.43 | 15.775 | 809600.0 |
| 2004-09-23 | ACLS | Stock | 33.0 | 34.32 | 32.6 | 33.56 | 101000.0 |
| 2004-09-23 | ACO-DELISTED | Stock | 18.0 | 18.4 | 18.0 | 18.26 | 50000.0 |
> showing 50 of 3,816 rows — these rows as CSV