PREVIEW / stock_daily / 2003-01-27
file: by_date/stock_daily/2003/2003-01-27.parquet size: 111 KB rows: 3,307 symbols: 2,037
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-01-27 | AAPL | Stock | 0.2443 | 0.2589 | 0.2438 | 0.2523 | 391406400.0 |
| 2003-01-27 | MSFT | Stock | 24.66 | 25.3 | 24.205 | 24.585 | 114838600.0 |
| 2003-01-27 | NVDA | Stock | 0.0829 | 0.0872 | 0.0814 | 0.0835 | 889116000.0 |
| 2003-01-27 | AMZN | Stock | 1.084 | 1.1185 | 1.082 | 1.089 | 164140000.0 |
| 2003-01-27 | CL | Stock | 25.775 | 25.78 | 25.205 | 25.425 | 4140200.0 |
| 2003-01-27 | A | Stock | 11.7024 | 11.9599 | 11.5308 | 11.6094 | 2669761.0 |
| 2003-01-27 | AABA-DELISTED | Stock | 9.09000015258789 | 9.38500022888184 | 9.02000045776367 | 9.05500030517578 | 18864600.0 |
| 2003-01-27 | AAI-DELISTED | Stock | 5.13 | 5.2 | 4.94 | 5.05 | 321200.0 |
| 2003-01-27 | AAIC-DELISTED | Stock | 182.6 | 182.6 | 172.0 | 174.8 | 332400.0 |
| 2003-01-27 | AAME | Stock | 1.48 | 1.53 | 1.39 | 1.53 | 1900.0 |
| 2003-01-27 | AAON | Stock | 2.3585 | 2.3954 | 2.2874 | 2.294 | 88087.0 |
| 2003-01-27 | AAP | Stock | 14.1667 | 14.2833 | 14.0133 | 14.1667 | 1426500.0 |
| 2003-01-27 | AAXN-DELISTED | Stock | 0.338333338499069 | 0.355833321809769 | 0.334166675806046 | 0.349166661500931 | 208800.0 |
| 2003-01-27 | ABAX-DELISTED | Stock | 3.99 | 4.0 | 3.679 | 3.68 | 7700.0 |
| 2003-01-27 | ABB-DELISTED | Stock | 2.98 | 3.04 | 2.9 | 2.91 | 136600.0 |
| 2003-01-27 | ABC-DELISTED | Stock | 13.9 | 14.0 | 13.71 | 13.81 | 6158800.0 |
| 2003-01-27 | ABCB | Stock | 10.9827 | 11.1449 | 10.9341 | 11.0557 | 7032.0 |
| 2003-01-27 | ABCO-DELISTED | Stock | 15.35 | 15.65 | 15.195 | 15.3 | 74852.0 |
| 2003-01-27 | ABCW-DELISTED | Stock | 21.02 | 21.41 | 21.02 | 21.36 | 48950.0 |
| 2003-01-27 | ABE-DELISTED | Stock | 5.43 | 5.48 | 5.41 | 5.46 | 7300.0 |
| 2003-01-27 | ABFS-DELISTED | Stock | 23.45 | 25.69 | 23.45 | 24.551 | 572076.0 |
| 2003-01-27 | ABG | Stock | 8.3 | 8.31 | 8.21 | 8.24 | 18100.0 |
| 2003-01-27 | ABK-DELISTED | Stock | 53.0 | 53.96 | 51.8 | 52.5 | 1133700.0 |
| 2003-01-27 | ABM | Stock | 14.4 | 14.75 | 14.35 | 14.5 | 70100.0 |
| 2003-01-27 | ABMD-DELISTED | Stock | 5.25 | 5.42 | 4.82 | 5.17 | 135489.0 |
| 2003-01-27 | ABP-DELISTED | Stock | 0.77 | 0.8 | 0.72 | 0.75 | 65900.0 |
| 2003-01-27 | ABT | Stock | 16.7216 | 16.8158 | 16.3759 | 16.5914 | 8832239.0 |
| 2003-01-27 | ABTL-DELISTED | Stock | 13.0 | 13.75 | 13.0 | 13.75 | 7700.0 |
| 2003-01-27 | ABV-DELISTED | Stock | 12.9 | 13.35 | 12.8 | 13.19 | 386400.0 |
| 2003-01-27 | ABVA-DELISTED | Stock | 10.985 | 10.985 | 10.985 | 10.985 | 200.0 |
| 2003-01-27 | ABX-DELISTED | Stock | 17.19 | 17.2 | 16.19 | 16.37 | 4875800.0 |
| 2003-01-27 | ACAP-DELISTED | Stock | 18.72 | 18.96 | 18.7 | 18.7 | 6900.0 |
| 2003-01-27 | ACAS-DELISTED | Stock | 22.06 | 22.52 | 22.0 | 22.15 | 370590.0 |
| 2003-01-27 | ACAT-DELISTED | Stock | 16.13 | 16.21 | 15.94 | 16.2 | 23323.0 |
| 2003-01-27 | ACCL-DELISTED | Stock | 4.80086994171143 | 4.86604022979736 | 4.74293994903564 | 4.86604022979736 | 311300.0 |
| 2003-01-27 | ACE-DELISTED | Stock | 28.0 | 29.8 | 28.0 | 29.27 | 4534200.0 |
| 2003-01-27 | ACF-DELISTED | Stock | 3.12 | 3.24 | 3.01 | 3.14 | 3554700.0 |
| 2003-01-27 | ACG-DELISTED | Stock | 8.57 | 8.65 | 8.56 | 8.6 | 533600.0 |
| 2003-01-27 | ACGL | Stock | 3.4833 | 3.53 | 3.4733 | 3.4989 | 1532700.0 |
| 2003-01-27 | ACGN-DELISTED | Stock | 872.6712 | 895.3288 | 804.6712 | 804.6712 | 7400.0 |
| 2003-01-27 | ACH | Stock | 10.9333 | 11.08 | 10.8067 | 10.8333 | 111000.0 |
| 2003-01-27 | ACH-DELISTED | Stock | 3.94 | 3.9425 | 3.9124 | 3.9425 | 9979.0 |
| 2003-01-27 | ACLS | Stock | 27.0 | 27.44 | 26.28 | 26.6 | 348325.0 |
| 2003-01-27 | ACO-DELISTED | Stock | 5.5 | 5.6 | 5.5 | 5.5 | 14700.0 |
| 2003-01-27 | ACPW-DELISTED | Stock | 8.45 | 8.65 | 7.4 | 7.4 | 33353.0 |
| 2003-01-27 | ACS-DELISTED | Stock | 50.6 | 52.03 | 50.06 | 50.45 | 810600.0 |
| 2003-01-27 | ACTA-DELISTED | Stock | 7.8 | 8.0 | 7.0 | 7.2 | 128500.0 |
| 2003-01-27 | ACTG | Stock | 1.35 | 1.44 | 1.3 | 1.35 | 60200.0 |
| 2003-01-27 | ACTT-DELISTED | Stock | 1.22 | 1.28 | 1.22 | 1.229 | 5700.0 |
| 2003-01-27 | ACTU-DELISTED | Stock | 2.6 | 2.75 | 2.56 | 2.68 | 258658.0 |
> showing 50 of 3,307 rows — these rows as CSV