PREVIEW / stock_daily / 2003-08-18
file: by_date/stock_daily/2003/2003-08-18.parquet size: 117 KB rows: 3,449 symbols: 2,128
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-08-18 | AAPL | Stock | 0.3546 | 0.3645 | 0.3521 | 0.3632 | 192774400.0 |
| 2003-08-18 | MSFT | Stock | 25.56 | 25.83 | 25.46 | 25.7 | 45817400.0 |
| 2003-08-18 | NVDA | Stock | 0.1367 | 0.1386 | 0.1343 | 0.1386 | 717684000.0 |
| 2003-08-18 | AMZN | Stock | 2.024 | 2.162 | 2.019 | 2.151 | 223484000.0 |
| 2003-08-18 | CL | Stock | 27.425 | 27.475 | 27.27 | 27.29 | 2956400.0 |
| 2003-08-18 | A | Stock | 15.5794 | 16.1087 | 15.5651 | 16.0658 | 2675073.0 |
| 2003-08-18 | AABA-DELISTED | Stock | 14.9849996566772 | 15.6850004196167 | 14.9700002670288 | 15.6450004577637 | 20156800.0 |
| 2003-08-18 | AAI-DELISTED | Stock | 13.54 | 13.74 | 13.54 | 13.74 | 598600.0 |
| 2003-08-18 | AAIC-DELISTED | Stock | 313.4 | 316.0 | 309.0 | 315.0 | 468100.0 |
| 2003-08-18 | AAME | Stock | 2.4 | 2.5 | 2.4 | 2.45 | 24400.0 |
| 2003-08-18 | AAON | Stock | 2.4691 | 2.4691 | 2.4283 | 2.4599 | 75178.0 |
| 2003-08-18 | AAP | Stock | 23.94 | 24.38 | 23.94 | 24.3367 | 1291800.0 |
| 2003-08-18 | AAXN-DELISTED | Stock | 1.97833335399628 | 2.10249996185303 | 1.97749996185303 | 2.06166672706604 | 2649600.0 |
| 2003-08-18 | ABAX-DELISTED | Stock | 8.47 | 8.55 | 7.85 | 8.489 | 252680.0 |
| 2003-08-18 | ABB-DELISTED | Stock | 5.0 | 5.27 | 5.0 | 5.24 | 597800.0 |
| 2003-08-18 | ABC-DELISTED | Stock | 15.44 | 15.46 | 15.3 | 15.32 | 2654800.0 |
| 2003-08-18 | ABCB | Stock | 13.0091 | 13.3252 | 12.9442 | 13.1307 | 10117.0 |
| 2003-08-18 | ABCO-DELISTED | Stock | 20.09 | 20.76 | 19.98 | 20.58 | 111076.0 |
| 2003-08-18 | ABCW-DELISTED | Stock | 24.6 | 24.99 | 24.2 | 24.97 | 14790.0 |
| 2003-08-18 | ABE-DELISTED | Stock | 6.35 | 6.35 | 6.3 | 6.35 | 8800.0 |
| 2003-08-18 | ABFS-DELISTED | Stock | 27.4 | 28.129 | 27.4 | 28.12 | 135244.0 |
| 2003-08-18 | ABG | Stock | 16.75 | 17.3 | 16.63 | 17.24 | 62500.0 |
| 2003-08-18 | ABK-DELISTED | Stock | 66.17 | 66.9 | 66.09 | 66.17 | 412100.0 |
| 2003-08-18 | ABM | Stock | 15.67 | 15.88 | 15.5 | 15.88 | 85300.0 |
| 2003-08-18 | ABMD-DELISTED | Stock | 5.349 | 5.5 | 5.23 | 5.42 | 45900.0 |
| 2003-08-18 | ABP-DELISTED | Stock | 1.0 | 1.0 | 0.98 | 0.98 | 99500.0 |
| 2003-08-18 | ABT | Stock | 17.956 | 17.983 | 17.6867 | 17.8618 | 6337256.0 |
| 2003-08-18 | ABTL-DELISTED | Stock | 30.7 | 31.75 | 29.2 | 31.65 | 31300.0 |
| 2003-08-18 | ABV-DELISTED | Stock | 19.65 | 19.74 | 19.47 | 19.7 | 393600.0 |
| 2003-08-18 | ABVA-DELISTED | Stock | 19.41 | 19.41 | 19.41 | 19.41 | 100.0 |
| 2003-08-18 | ABX-DELISTED | Stock | 18.25 | 18.46 | 18.11 | 18.21 | 1565800.0 |
| 2003-08-18 | ACAP-DELISTED | Stock | 27.5 | 28.72 | 27.35 | 28.7 | 30735.0 |
| 2003-08-18 | ACAS-DELISTED | Stock | 22.65 | 23.34 | 22.61 | 23.07 | 1230783.0 |
| 2003-08-18 | ACAT-DELISTED | Stock | 21.49 | 22.01 | 21.24 | 21.64 | 25325.0 |
| 2003-08-18 | ACCL-DELISTED | Stock | 7.1325101852417 | 7.57422018051147 | 7.1325101852417 | 7.57422018051147 | 68400.0 |
| 2003-08-18 | ACE-DELISTED | Stock | 33.11 | 33.38 | 32.88 | 33.04 | 922700.0 |
| 2003-08-18 | ACF-DELISTED | Stock | 7.38 | 7.65 | 7.2 | 7.56 | 1943900.0 |
| 2003-08-18 | ACG-DELISTED | Stock | 8.06 | 8.12 | 8.03 | 8.1 | 581000.0 |
| 2003-08-18 | ACGL | Stock | 3.8111 | 3.9056 | 3.8111 | 3.8944 | 564300.0 |
| 2003-08-18 | ACGN-DELISTED | Stock | 1008.6712 | 1042.6712 | 1008.6712 | 1020.0 | 16000.0 |
| 2003-08-18 | ACH | Stock | 15.8333 | 16.0333 | 15.8267 | 15.9333 | 138000.0 |
| 2003-08-18 | ACH-DELISTED | Stock | 7.7 | 7.937 | 7.7 | 7.925 | 31600.0 |
| 2003-08-18 | ACLS | Stock | 29.8 | 32.4 | 29.68 | 32.04 | 439425.0 |
| 2003-08-18 | ACO-DELISTED | Stock | 10.08 | 10.46 | 10.07 | 10.42 | 86800.0 |
| 2003-08-18 | ACPW-DELISTED | Stock | 12.3 | 12.5 | 10.35 | 11.25 | 244018.0 |
| 2003-08-18 | ACS-DELISTED | Stock | 45.3 | 46.25 | 45.3 | 46.01 | 1037500.0 |
| 2003-08-18 | ACTA-DELISTED | Stock | 9.4 | 9.6 | 9.0 | 9.0 | 217100.0 |
| 2003-08-18 | ACTG | Stock | 1.69 | 1.81 | 1.66 | 1.72 | 80800.0 |
| 2003-08-18 | ACTI-DELISTED | Stock | 7.97 | 8.25 | 7.97 | 8.25 | 146899.0 |
| 2003-08-18 | ACTT-DELISTED | Stock | 2.09 | 2.53 | 2.0 | 2.42 | 258650.0 |
> showing 50 of 3,449 rows — these rows as CSV