PREVIEW / stock_daily / 2004-09-17
file: by_date/stock_daily/2004/2004-09-17.parquet size: 128 KB rows: 3,799 symbols: 2,365
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-17 | AAPL | Stock | 0.6527 | 0.6675 | 0.65 | 0.6632 | 502308800.0 |
| 2004-09-17 | MSFT | Stock | 27.39 | 27.53 | 27.26 | 27.51 | 65283000.0 |
| 2004-09-17 | NVDA | Stock | 0.1185 | 0.1231 | 0.1175 | 0.1224 | 1003800000.0 |
| 2004-09-17 | AMZN | Stock | 2.1425 | 2.163 | 2.1195 | 2.148 | 157684000.0 |
| 2004-09-17 | CL | Stock | 27.275 | 27.365 | 27.14 | 27.165 | 4441400.0 |
| 2004-09-17 | A | Stock | 16.0873 | 16.4378 | 16.0873 | 16.3805 | 4573417.0 |
| 2004-09-17 | AABA-DELISTED | Stock | 33.0 | 33.5 | 32.6599998474121 | 33.4599990844727 | 15049000.0 |
| 2004-09-17 | AACC-DELISTED | Stock | 17.63 | 17.63 | 16.98 | 16.98 | 19262.0 |
| 2004-09-17 | AAI-DELISTED | Stock | 11.66 | 11.66 | 11.3 | 11.37 | 719600.0 |
| 2004-09-17 | AAIC-DELISTED | Stock | 404.0 | 407.8 | 403.4 | 405.8 | 1266500.0 |
| 2004-09-17 | AAME | Stock | 3.03 | 3.05 | 3.01 | 3.01 | 8700.0 |
| 2004-09-17 | AAON | Stock | 2.5021 | 2.5021 | 2.4257 | 2.4665 | 318937.0 |
| 2004-09-17 | AAP | Stock | 23.96 | 24.2667 | 23.9067 | 23.9667 | 1274550.0 |
| 2004-09-17 | AAV-DELISTED | Stock | 15.64 | 15.65 | 15.5 | 15.64 | 18300.0 |
| 2004-09-17 | AAXN-DELISTED | Stock | 20.3500003814697 | 20.8950004577637 | 19.9599990844727 | 20.3199996948242 | 22790400.0 |
| 2004-09-17 | ABAX-DELISTED | Stock | 15.61 | 15.66 | 14.57 | 14.61 | 84751.0 |
| 2004-09-17 | ABB-DELISTED | Stock | 6.0 | 6.09 | 5.99 | 6.046 | 104900.0 |
| 2004-09-17 | ABC-DELISTED | Stock | 13.78 | 13.88 | 13.74 | 13.76 | 3430000.0 |
| 2004-09-17 | ABCB | Stock | 15.7892 | 16.3323 | 15.465 | 15.7649 | 35409.0 |
| 2004-09-17 | ABCO-DELISTED | Stock | 17.28 | 17.68 | 16.78 | 16.855 | 104857.0 |
| 2004-09-17 | ABCW-DELISTED | Stock | 26.72 | 26.72 | 25.73 | 26.25 | 47210.0 |
| 2004-09-17 | ABE-DELISTED | Stock | 7.89 | 7.99 | 7.87 | 7.99 | 15600.0 |
| 2004-09-17 | ABFS-DELISTED | Stock | 36.03 | 36.03 | 35.34 | 35.69 | 156267.0 |
| 2004-09-17 | ABG | Stock | 14.36 | 14.46 | 14.05 | 14.35 | 41200.0 |
| 2004-09-17 | ABK-DELISTED | Stock | 78.95 | 79.29 | 78.76 | 79.19 | 390100.0 |
| 2004-09-17 | ABM | Stock | 20.54 | 20.59 | 20.23 | 20.23 | 267100.0 |
| 2004-09-17 | ABMD-DELISTED | Stock | 10.82 | 10.96 | 10.64 | 10.69 | 72401.0 |
| 2004-09-17 | ABP-DELISTED | Stock | 1.8 | 1.85 | 1.8 | 1.81 | 137000.0 |
| 2004-09-17 | ABR | Stock | 21.5 | 21.5 | 21.16 | 21.24 | 13800.0 |
| 2004-09-17 | ABT | Stock | 20.5738 | 20.7082 | 20.521 | 20.593 | 6919341.0 |
| 2004-09-17 | ABTL-DELISTED | Stock | 42.6 | 42.7 | 40.75 | 42.25 | 70700.0 |
| 2004-09-17 | ABV-DELISTED | Stock | 21.85 | 22.24 | 21.75 | 22.0 | 665100.0 |
| 2004-09-17 | ABVA-DELISTED | Stock | 14.58 | 14.58 | 14.58 | 14.58 | 500.0 |
| 2004-09-17 | ABX-DELISTED | Stock | 19.35 | 19.5 | 19.21 | 19.4 | 1587700.0 |
| 2004-09-17 | ACAD | Stock | 7.81 | 7.81 | 7.65 | 7.75 | 3100.0 |
| 2004-09-17 | ACAP-DELISTED | Stock | 31.49 | 31.5 | 30.79 | 30.79 | 43689.0 |
| 2004-09-17 | ACAS-DELISTED | Stock | 32.09 | 32.3 | 32.04 | 32.21 | 695863.0 |
| 2004-09-17 | ACAT-DELISTED | Stock | 26.46 | 27.31 | 26.08 | 26.08 | 57820.0 |
| 2004-09-17 | ACC-DELISTED | Stock | 18.41 | 18.43 | 18.33 | 18.38 | 42385.0 |
| 2004-09-17 | ACCL-DELISTED | Stock | 6.48 | 6.53 | 6.17 | 6.26 | 51574.0 |
| 2004-09-17 | ACE-DELISTED | Stock | 40.42 | 40.65 | 39.94 | 39.97 | 1159500.0 |
| 2004-09-17 | ACF-DELISTED | Stock | 21.08 | 21.2 | 20.65 | 20.87 | 525400.0 |
| 2004-09-17 | ACG-DELISTED | Stock | 8.14 | 8.15 | 8.11 | 8.13 | 424000.0 |
| 2004-09-17 | ACGL | Stock | 4.4289 | 4.4589 | 4.4278 | 4.4433 | 875700.0 |
| 2004-09-17 | ACGN-DELISTED | Stock | 623.3288 | 623.3288 | 589.3288 | 600.6712 | 26100.0 |
| 2004-09-17 | ACH | Stock | 17.2333 | 17.2333 | 16.7267 | 16.9333 | 146400.0 |
| 2004-09-17 | ACH-DELISTED | Stock | 14.182 | 14.467 | 14.14 | 14.465 | 866000.0 |
| 2004-09-17 | ACLS | Stock | 33.08 | 34.48 | 32.2 | 33.68 | 175450.0 |
| 2004-09-17 | ACO-DELISTED | Stock | 17.9 | 18.18 | 17.6 | 18.18 | 271500.0 |
| 2004-09-17 | ACPW-DELISTED | Stock | 15.85 | 16.25 | 15.4 | 16.25 | 9562.0 |
> showing 50 of 3,799 rows — these rows as CSV