PREVIEW / stock_daily / 2003-11-17
file: by_date/stock_daily/2003/2003-11-17.parquet size: 122 KB rows: 3,566 symbols: 2,222
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-17 | AAPL | Stock | 0.3813 | 0.3816 | 0.3741 | 0.3773 | 228256000.0 |
| 2003-11-17 | MSFT | Stock | 25.39 | 25.44 | 24.84 | 25.15 | 103900200.0 |
| 2003-11-17 | NVDA | Stock | 0.1649 | 0.1683 | 0.1633 | 0.1663 | 599880000.0 |
| 2003-11-17 | AMZN | Stock | 2.596 | 2.6095 | 2.479 | 2.518 | 259938000.0 |
| 2003-11-17 | CL | Stock | 26.055 | 26.205 | 25.375 | 26.05 | 5393400.0 |
| 2003-11-17 | A | Stock | 19.0343 | 19.3133 | 18.3119 | 19.1345 | 6865718.0 |
| 2003-11-17 | AABA-DELISTED | Stock | 20.4599990844727 | 20.5400009155273 | 19.3400001525879 | 20.1800003051758 | 42204400.0 |
| 2003-11-17 | AAI-DELISTED | Stock | 14.69 | 14.69 | 13.78 | 14.01 | 2438400.0 |
| 2003-11-17 | AAIC-DELISTED | Stock | 419.0 | 419.0 | 378.0 | 404.8 | 2053800.0 |
| 2003-11-17 | AAME | Stock | 2.63 | 2.69 | 2.62 | 2.69 | 3000.0 |
| 2003-11-17 | AAON | Stock | 2.5258 | 2.5389 | 2.3612 | 2.3612 | 225534.0 |
| 2003-11-17 | AAP | Stock | 27.0133 | 27.05 | 26.6833 | 26.8233 | 1092000.0 |
| 2003-11-17 | AAXN-DELISTED | Stock | 5.09999990463257 | 5.20833349227905 | 4.86666679382324 | 5.1875 | 3132000.0 |
| 2003-11-17 | ABAX-DELISTED | Stock | 17.09 | 17.24 | 15.81 | 17.1 | 443063.0 |
| 2003-11-17 | ABB-DELISTED | Stock | 6.08 | 6.08 | 5.94 | 6.05 | 123800.0 |
| 2003-11-17 | ABC-DELISTED | Stock | 16.02 | 16.21 | 15.92 | 16.2 | 3268000.0 |
| 2003-11-17 | ABCB | Stock | 13.382 | 13.4468 | 12.8956 | 13.2927 | 14065.0 |
| 2003-11-17 | ABCO-DELISTED | Stock | 18.03 | 18.03 | 17.55 | 17.885 | 205312.0 |
| 2003-11-17 | ABCW-DELISTED | Stock | 24.39 | 24.82 | 24.22 | 24.71 | 41730.0 |
| 2003-11-17 | ABE-DELISTED | Stock | 6.83 | 6.85 | 6.75 | 6.8 | 18500.0 |
| 2003-11-17 | ABFS-DELISTED | Stock | 33.3 | 33.3 | 32.13 | 32.45 | 162563.0 |
| 2003-11-17 | ABG | Stock | 16.32 | 16.32 | 15.71 | 15.91 | 26200.0 |
| 2003-11-17 | ABK-DELISTED | Stock | 68.9 | 69.14 | 68.1 | 68.61 | 383500.0 |
| 2003-11-17 | ABM | Stock | 15.35 | 15.52 | 15.2 | 15.47 | 186100.0 |
| 2003-11-17 | ABMD-DELISTED | Stock | 7.31 | 7.71 | 7.16 | 7.55 | 64930.0 |
| 2003-11-17 | ABP-DELISTED | Stock | 1.01 | 1.03 | 0.98 | 1.01 | 35800.0 |
| 2003-11-17 | ABT | Stock | 19.8414 | 19.8639 | 19.5811 | 19.8235 | 7054564.0 |
| 2003-11-17 | ABTL-DELISTED | Stock | 49.85 | 50.25 | 46.75 | 47.55 | 125200.0 |
| 2003-11-17 | ABV-DELISTED | Stock | 22.35 | 22.54 | 22.3 | 22.33 | 323900.0 |
| 2003-11-17 | ABVA-DELISTED | Stock | 16.0 | 16.2 | 16.0 | 16.2 | 973.0 |
| 2003-11-17 | ABX-DELISTED | Stock | 21.2 | 21.21 | 20.3 | 20.79 | 2447000.0 |
| 2003-11-17 | ACAP-DELISTED | Stock | 16.81 | 16.81 | 16.35 | 16.4 | 77531.0 |
| 2003-11-17 | ACAS-DELISTED | Stock | 27.41 | 27.9 | 27.1 | 27.53 | 865522.0 |
| 2003-11-17 | ACAT-DELISTED | Stock | 22.56 | 22.86 | 22.17 | 22.25 | 26288.0 |
| 2003-11-17 | ACCL-DELISTED | Stock | 8.15351009368896 | 8.81245040893555 | 8.15351009368896 | 8.81245040893555 | 317100.0 |
| 2003-11-17 | ACE-DELISTED | Stock | 34.26 | 34.87 | 34.0 | 34.76 | 911100.0 |
| 2003-11-17 | ACF-DELISTED | Stock | 13.48 | 13.48 | 12.92 | 13.02 | 1424300.0 |
| 2003-11-17 | ACG-DELISTED | Stock | 8.23 | 8.27 | 8.23 | 8.26 | 511400.0 |
| 2003-11-17 | ACGL | Stock | 4.2222 | 4.2222 | 4.0911 | 4.1122 | 736200.0 |
| 2003-11-17 | ACGN-DELISTED | Stock | 1156.0 | 1258.0 | 1156.0 | 1224.0 | 49400.0 |
| 2003-11-17 | ACH | Stock | 13.96 | 14.0 | 13.5333 | 13.9533 | 238950.0 |
| 2003-11-17 | ACH-DELISTED | Stock | 12.775 | 12.862 | 12.645 | 12.79 | 276800.0 |
| 2003-11-17 | ACLS | Stock | 44.2 | 44.2 | 41.8 | 43.64 | 247800.0 |
| 2003-11-17 | ACO-DELISTED | Stock | 15.95 | 16.19 | 15.7 | 15.9 | 302600.0 |
| 2003-11-17 | ACPW-DELISTED | Stock | 17.9 | 17.9 | 16.05 | 17.65 | 39526.0 |
| 2003-11-17 | ACS-DELISTED | Stock | 46.86 | 47.42 | 46.61 | 47.13 | 1159100.0 |
| 2003-11-17 | ACTA-DELISTED | Stock | 8.4 | 8.6 | 8.0 | 8.6 | 480900.0 |
| 2003-11-17 | ACTG | Stock | 6.26 | 6.35 | 5.65 | 5.9 | 137500.0 |
| 2003-11-17 | ACTI-DELISTED | Stock | 8.13 | 8.47 | 8.12 | 8.43 | 216620.0 |
| 2003-11-17 | ACTT-DELISTED | Stock | 1.45 | 1.45 | 1.25 | 1.35 | 102729.0 |
> showing 50 of 3,566 rows — these rows as CSV