PREVIEW / stock_daily / 2003-07-14
file: by_date/stock_daily/2003/2003-07-14.parquet size: 116 KB rows: 3,409 symbols: 2,100
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-07-14 | AAPL | Stock | 0.3573 | 0.3643 | 0.3548 | 0.3554 | 188406400.0 |
| 2003-07-14 | MSFT | Stock | 27.63 | 27.81 | 27.05 | 27.4 | 60464400.0 |
| 2003-07-14 | NVDA | Stock | 0.2087 | 0.21 | 0.201 | 0.202 | 694344000.0 |
| 2003-07-14 | AMZN | Stock | 1.925 | 1.9805 | 1.912 | 1.9635 | 173806000.0 |
| 2003-07-14 | CL | Stock | 28.65 | 28.82 | 28.475 | 28.49 | 3566400.0 |
| 2003-07-14 | A | Stock | 15.701 | 16.0229 | 15.6795 | 15.8441 | 4971008.0 |
| 2003-07-14 | AABA-DELISTED | Stock | 16.4500007629395 | 16.5249996185303 | 15.7550001144409 | 16.1000003814697 | 59770600.0 |
| 2003-07-14 | AAI-DELISTED | Stock | 11.15 | 11.36 | 10.9 | 11.33 | 1235800.0 |
| 2003-07-14 | AAIC-DELISTED | Stock | 305.8 | 310.0 | 304.0 | 307.6 | 586600.0 |
| 2003-07-14 | AAME | Stock | 2.5 | 2.5 | 2.5 | 2.5 | 1000.0 |
| 2003-07-14 | AAON | Stock | 2.5811 | 2.6206 | 2.5811 | 2.5877 | 194400.0 |
| 2003-07-14 | AAP | Stock | 21.2833 | 22.13 | 21.2833 | 21.8467 | 2355300.0 |
| 2003-07-14 | AAXN-DELISTED | Stock | 1.03333330154419 | 1.0625 | 1.03333330154419 | 1.04999995231628 | 163200.0 |
| 2003-07-14 | ABAX-DELISTED | Stock | 6.74 | 6.74 | 6.42 | 6.46 | 39600.0 |
| 2003-07-14 | ABB-DELISTED | Stock | 3.38 | 3.38 | 3.32 | 3.34 | 215000.0 |
| 2003-07-14 | ABC-DELISTED | Stock | 17.47 | 17.6 | 17.27 | 17.39 | 3582800.0 |
| 2003-07-14 | ABCB | Stock | 12.7578 | 12.7578 | 12.5389 | 12.6849 | 19000.0 |
| 2003-07-14 | ABCO-DELISTED | Stock | 21.52 | 21.87 | 20.53 | 21.34 | 142915.0 |
| 2003-07-14 | ABCW-DELISTED | Stock | 26.08 | 26.23 | 25.98 | 26.0 | 31730.0 |
| 2003-07-14 | ABE-DELISTED | Stock | 6.2 | 6.24 | 6.18 | 6.21 | 3500.0 |
| 2003-07-14 | ABFS-DELISTED | Stock | 27.55 | 27.78 | 27.14 | 27.21 | 251990.0 |
| 2003-07-14 | ABG | Stock | 14.6 | 15.0 | 14.54 | 14.84 | 43600.0 |
| 2003-07-14 | ABK-DELISTED | Stock | 66.29 | 67.67 | 66.29 | 67.26 | 686900.0 |
| 2003-07-14 | ABM | Stock | 15.7 | 16.12 | 15.7 | 15.98 | 89100.0 |
| 2003-07-14 | ABMD-DELISTED | Stock | 5.55 | 5.67 | 5.4 | 5.64 | 47557.0 |
| 2003-07-14 | ABP-DELISTED | Stock | 1.08 | 1.08 | 1.03 | 1.05 | 36900.0 |
| 2003-07-14 | ABT | Stock | 19.8684 | 20.1108 | 19.7292 | 19.7696 | 7423688.0 |
| 2003-07-14 | ABTL-DELISTED | Stock | 33.8 | 35.0 | 33.8 | 34.55 | 98600.0 |
| 2003-07-14 | ABV-DELISTED | Stock | 20.7 | 21.15 | 20.7 | 21.15 | 522500.0 |
| 2003-07-14 | ABVA-DELISTED | Stock | 17.5 | 17.5 | 17.28 | 17.28 | 1900.0 |
| 2003-07-14 | ABX-DELISTED | Stock | 17.41 | 17.57 | 17.36 | 17.42 | 1420221.0 |
| 2003-07-14 | ACAP-DELISTED | Stock | 26.9 | 27.03 | 26.72 | 27.03 | 12000.0 |
| 2003-07-14 | ACAS-DELISTED | Stock | 27.62 | 27.96 | 27.4 | 27.87 | 325517.0 |
| 2003-07-14 | ACAT-DELISTED | Stock | 20.46 | 20.66 | 19.476 | 19.656 | 38561.0 |
| 2003-07-14 | ACCL-DELISTED | Stock | 6.81400012969971 | 7.44399976730347 | 6.81400012969971 | 7.18300008773804 | 92500.0 |
| 2003-07-14 | ACE-DELISTED | Stock | 34.35 | 34.84 | 34.08 | 34.5 | 1265700.0 |
| 2003-07-14 | ACF-DELISTED | Stock | 9.1 | 9.37 | 9.07 | 9.2 | 1710700.0 |
| 2003-07-14 | ACG-DELISTED | Stock | 8.74 | 8.78 | 8.51 | 8.59 | 2847000.0 |
| 2003-07-14 | ACGL | Stock | 3.9067 | 3.9478 | 3.8844 | 3.9422 | 416700.0 |
| 2003-07-14 | ACGN-DELISTED | Stock | 1008.6712 | 1144.6712 | 1008.6712 | 1099.3288 | 62300.0 |
| 2003-07-14 | ACH | Stock | 15.2067 | 15.3 | 15.1733 | 15.2667 | 261750.0 |
| 2003-07-14 | ACH-DELISTED | Stock | 7.1 | 7.163 | 7.075 | 7.075 | 127600.0 |
| 2003-07-14 | ACLS | Stock | 30.12 | 31.72 | 29.92 | 31.48 | 446600.0 |
| 2003-07-14 | ACO-DELISTED | Stock | 9.35 | 9.85 | 9.35 | 9.5 | 103300.0 |
| 2003-07-14 | ACPW-DELISTED | Stock | 8.6 | 8.7 | 8.35 | 8.45 | 16363.0 |
| 2003-07-14 | ACS-DELISTED | Stock | 44.5 | 45.65 | 44.5 | 44.9 | 1375900.0 |
| 2003-07-14 | ACTA-DELISTED | Stock | 10.4 | 15.2 | 9.8 | 14.4 | 5035300.0 |
| 2003-07-14 | ACTG | Stock | 1.38 | 1.58 | 1.35 | 1.58 | 348500.0 |
| 2003-07-14 | ACTI-DELISTED | Stock | 9.54 | 9.95 | 9.25 | 9.95 | 137536.0 |
| 2003-07-14 | ACTT-DELISTED | Stock | 1.86 | 1.92 | 1.81 | 1.9 | 23400.0 |
> showing 50 of 3,409 rows — these rows as CSV