PREVIEW / stock_daily / 2003-10-31
file: by_date/stock_daily/2003/2003-10-31.parquet size: 120 KB rows: 3,535 symbols: 2,195
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-10-31 | AAPL | Stock | 0.4161 | 0.417 | 0.4068 | 0.4088 | 218153600.0 |
| 2003-10-31 | MSFT | Stock | 26.37 | 26.44 | 26.11 | 26.14 | 69623700.0 |
| 2003-10-31 | NVDA | Stock | 0.1508 | 0.1521 | 0.145 | 0.1473 | 598152000.0 |
| 2003-10-31 | AMZN | Stock | 2.795 | 2.8065 | 2.719 | 2.7215 | 154534000.0 |
| 2003-10-31 | CL | Stock | 26.3 | 26.73 | 26.215 | 26.595 | 8605800.0 |
| 2003-10-31 | A | Stock | 17.8469 | 17.897 | 17.6252 | 17.8255 | 2703592.0 |
| 2003-10-31 | AABA-DELISTED | Stock | 21.7299995422363 | 22.0 | 21.5949993133545 | 21.8549995422363 | 19394000.0 |
| 2003-10-31 | AAI-DELISTED | Stock | 17.06 | 17.08 | 15.91 | 16.21 | 2411200.0 |
| 2003-10-31 | AAIC-DELISTED | Stock | 394.0 | 403.4 | 388.0 | 398.4 | 1569900.0 |
| 2003-10-31 | AAME | Stock | 2.39 | 2.47 | 2.39 | 2.47 | 1600.0 |
| 2003-10-31 | AAON | Stock | 2.4586 | 2.4955 | 2.4349 | 2.4362 | 75178.0 |
| 2003-10-31 | AAP | Stock | 26.4733 | 26.4733 | 25.7767 | 26.0733 | 3199200.0 |
| 2003-10-31 | AAXN-DELISTED | Stock | 5.55416679382324 | 5.70499992370605 | 5.19750022888184 | 5.23333311080933 | 7311600.0 |
| 2003-10-31 | ABAX-DELISTED | Stock | 17.0 | 17.75 | 16.71 | 17.37 | 190289.0 |
| 2003-10-31 | ABB-DELISTED | Stock | 5.82 | 5.92 | 5.8 | 5.8 | 159800.0 |
| 2003-10-31 | ABC-DELISTED | Stock | 14.3 | 14.31 | 13.89 | 14.2 | 6534000.0 |
| 2003-10-31 | ABCB | Stock | 13.9331 | 13.9412 | 13.6332 | 13.6413 | 4935.0 |
| 2003-10-31 | ABCO-DELISTED | Stock | 18.067 | 18.86 | 17.94 | 18.4 | 1088032.0 |
| 2003-10-31 | ABCW-DELISTED | Stock | 25.21 | 25.8 | 24.94 | 24.94 | 37780.0 |
| 2003-10-31 | ABE-DELISTED | Stock | 6.9 | 6.95 | 6.88 | 6.9 | 13700.0 |
| 2003-10-31 | ABFS-DELISTED | Stock | 33.65 | 34.0 | 32.85 | 33.1 | 196962.0 |
| 2003-10-31 | ABG | Stock | 17.0 | 17.7 | 16.92 | 17.0 | 103200.0 |
| 2003-10-31 | ABK-DELISTED | Stock | 70.21 | 71.1 | 70.21 | 70.7 | 274900.0 |
| 2003-10-31 | ABM | Stock | 15.22 | 15.56 | 15.16 | 15.56 | 136400.0 |
| 2003-10-31 | ABMD-DELISTED | Stock | 9.01 | 9.029 | 8.85 | 8.9 | 36256.0 |
| 2003-10-31 | ABP-DELISTED | Stock | 0.96 | 0.99 | 0.96 | 0.97 | 106000.0 |
| 2003-10-31 | ABT | Stock | 19.2354 | 19.2982 | 19.0334 | 19.1322 | 6279560.0 |
| 2003-10-31 | ABTL-DELISTED | Stock | 55.0 | 55.15 | 51.4 | 52.25 | 53400.0 |
| 2003-10-31 | ABV-DELISTED | Stock | 21.7 | 21.7 | 21.02 | 21.22 | 623000.0 |
| 2003-10-31 | ABVA-DELISTED | Stock | 16.349 | 16.35 | 16.349 | 16.35 | 300.0 |
| 2003-10-31 | ABX-DELISTED | Stock | 19.31 | 19.54 | 19.24 | 19.46 | 1782100.0 |
| 2003-10-31 | ACAP-DELISTED | Stock | 27.57 | 27.57 | 26.4 | 26.66 | 6700.0 |
| 2003-10-31 | ACAS-DELISTED | Stock | 26.73 | 26.99 | 26.71 | 26.99 | 341047.0 |
| 2003-10-31 | ACAT-DELISTED | Stock | 22.8 | 22.8 | 21.96 | 22.45 | 20574.0 |
| 2003-10-31 | ACCL-DELISTED | Stock | 9.26865005493164 | 9.42794990539551 | 9.00796985626221 | 9.42794990539551 | 86400.0 |
| 2003-10-31 | ACE-DELISTED | Stock | 35.75 | 36.17 | 35.5 | 36.0 | 1522400.0 |
| 2003-10-31 | ACF-DELISTED | Stock | 13.45 | 13.57 | 13.39 | 13.43 | 1632200.0 |
| 2003-10-31 | ACG-DELISTED | Stock | 8.28 | 8.3 | 8.15 | 8.27 | 474000.0 |
| 2003-10-31 | ACGL | Stock | 4.0256 | 4.0811 | 4.0222 | 4.0556 | 604800.0 |
| 2003-10-31 | ACGN-DELISTED | Stock | 1167.3288 | 1235.3288 | 1167.3288 | 1235.3288 | 21200.0 |
| 2003-10-31 | ACH | Stock | 13.44 | 13.7 | 13.3867 | 13.56 | 256650.0 |
| 2003-10-31 | ACH-DELISTED | Stock | 13.001 | 13.001 | 12.263 | 12.788 | 353595.0 |
| 2003-10-31 | ACLS | Stock | 41.92 | 43.32 | 41.68 | 42.36 | 419950.0 |
| 2003-10-31 | ACO-DELISTED | Stock | 17.96 | 18.3 | 17.86 | 18.04 | 284200.0 |
| 2003-10-31 | ACPW-DELISTED | Stock | 15.5 | 15.95 | 15.35 | 15.6 | 11708.0 |
| 2003-10-31 | ACS-DELISTED | Stock | 48.8 | 49.46 | 48.8 | 48.93 | 1308300.0 |
| 2003-10-31 | ACTA-DELISTED | Stock | 8.6 | 9.6 | 8.4 | 9.4 | 1222800.0 |
| 2003-10-31 | ACTG | Stock | 6.08 | 6.2 | 5.9 | 6.15 | 194900.0 |
| 2003-10-31 | ACTI-DELISTED | Stock | 8.4 | 8.5 | 8.29 | 8.46 | 496928.0 |
| 2003-10-31 | ACTT-DELISTED | Stock | 1.25 | 1.32 | 1.2 | 1.23 | 80500.0 |
> showing 50 of 3,535 rows — these rows as CSV