PREVIEW / stock_daily / 2003-07-21
file: by_date/stock_daily/2003/2003-07-21.parquet size: 114 KB rows: 3,378 symbols: 2,076
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-21 | AAPL | Stock | 0.3695 | 0.3714 | 0.3625 | 0.368 | 183808800.0 |
| 2003-07-21 | MSFT | Stock | 26.87 | 26.91 | 26.0 | 26.04 | 48480800.0 |
| 2003-07-21 | NVDA | Stock | 0.1782 | 0.1787 | 0.1703 | 0.1745 | 985140000.0 |
| 2003-07-21 | AMZN | Stock | 1.7355 | 1.8 | 1.73 | 1.7665 | 196514000.0 |
| 2003-07-21 | CL | Stock | 28.275 | 28.35 | 28.05 | 28.15 | 4603000.0 |
| 2003-07-21 | A | Stock | 15.0215 | 15.3505 | 14.6066 | 14.671 | 3716583.0 |
| 2003-07-21 | AABA-DELISTED | Stock | 15.3500003814697 | 15.7700004577637 | 15.1499996185303 | 15.5249996185303 | 32138800.0 |
| 2003-07-21 | AAI-DELISTED | Stock | 11.0 | 11.24 | 10.8 | 11.0 | 474600.0 |
| 2003-07-21 | AAIC-DELISTED | Stock | 294.6 | 298.0 | 291.0 | 294.0 | 496000.0 |
| 2003-07-21 | AAME | Stock | 2.28 | 2.49 | 2.28 | 2.28 | 2200.0 |
| 2003-07-21 | AAON | Stock | 2.4099 | 2.4151 | 2.3335 | 2.3704 | 394875.0 |
| 2003-07-21 | AAP | Stock | 21.7167 | 21.72 | 21.4567 | 21.5767 | 525600.0 |
| 2003-07-21 | AAXN-DELISTED | Stock | 1.04166662693024 | 1.07083332538605 | 1.0091667175293 | 1.03333330154419 | 325200.0 |
| 2003-07-21 | ABAX-DELISTED | Stock | 6.51 | 6.6 | 6.5 | 6.59 | 20100.0 |
| 2003-07-21 | ABB-DELISTED | Stock | 3.15 | 3.18 | 3.09 | 3.17 | 201200.0 |
| 2003-07-21 | ABC-DELISTED | Stock | 17.12 | 17.14 | 16.87 | 16.9 | 2400400.0 |
| 2003-07-21 | ABCB | Stock | 12.547 | 12.5633 | 12.1175 | 12.1742 | 19987.0 |
| 2003-07-21 | ABCO-DELISTED | Stock | 20.75 | 21.0 | 20.27 | 20.36 | 115649.0 |
| 2003-07-21 | ABCW-DELISTED | Stock | 25.4 | 25.61 | 25.02 | 25.22 | 51450.0 |
| 2003-07-21 | ABE-DELISTED | Stock | 6.1 | 6.1 | 6.05 | 6.1 | 23500.0 |
| 2003-07-21 | ABFS-DELISTED | Stock | 28.2 | 28.45 | 27.05 | 27.31 | 341503.0 |
| 2003-07-21 | ABG | Stock | 14.5 | 14.81 | 14.41 | 14.41 | 86000.0 |
| 2003-07-21 | ABK-DELISTED | Stock | 67.0 | 67.14 | 66.22 | 66.39 | 784100.0 |
| 2003-07-21 | ABM | Stock | 16.05 | 16.05 | 15.51 | 15.52 | 88500.0 |
| 2003-07-21 | ABMD-DELISTED | Stock | 5.65 | 5.81 | 5.27 | 5.76 | 40272.0 |
| 2003-07-21 | ABP-DELISTED | Stock | 1.01 | 1.03 | 1.0 | 1.01 | 32600.0 |
| 2003-07-21 | ABT | Stock | 18.58 | 18.589 | 18.2703 | 18.5396 | 8249928.0 |
| 2003-07-21 | ABTL-DELISTED | Stock | 32.5 | 34.1 | 31.3 | 32.0 | 24000.0 |
| 2003-07-21 | ABV-DELISTED | Stock | 20.35 | 20.69 | 20.31 | 20.64 | 216900.0 |
| 2003-07-21 | ABX-DELISTED | Stock | 16.98 | 17.42 | 16.97 | 17.31 | 2105200.0 |
| 2003-07-21 | ACAP-DELISTED | Stock | 25.66 | 25.66 | 24.8 | 25.12 | 21400.0 |
| 2003-07-21 | ACAS-DELISTED | Stock | 27.81 | 27.83 | 27.36 | 27.41 | 253429.0 |
| 2003-07-21 | ACAT-DELISTED | Stock | 19.865 | 20.17 | 19.094 | 19.865 | 21444.0 |
| 2003-07-21 | ACCL-DELISTED | Stock | 7.45836019515991 | 7.59594011306763 | 7.28458023071289 | 7.59594011306763 | 224800.0 |
| 2003-07-21 | ACE-DELISTED | Stock | 33.11 | 33.23 | 32.83 | 33.06 | 925700.0 |
| 2003-07-21 | ACF-DELISTED | Stock | 8.6 | 8.61 | 8.1 | 8.3 | 1421500.0 |
| 2003-07-21 | ACG-DELISTED | Stock | 8.71 | 8.71 | 8.55 | 8.6 | 755700.0 |
| 2003-07-21 | ACGL | Stock | 3.8733 | 3.9222 | 3.8422 | 3.8556 | 734400.0 |
| 2003-07-21 | ACGN-DELISTED | Stock | 1054.0 | 1054.0 | 1031.3288 | 1031.3288 | 3000.0 |
| 2003-07-21 | ACH | Stock | 16.3467 | 16.3933 | 16.1867 | 16.2867 | 366150.0 |
| 2003-07-21 | ACH-DELISTED | Stock | 6.9081 | 7.008 | 6.9081 | 6.9804 | 15639.0 |
| 2003-07-21 | ACLS | Stock | 31.72 | 31.76 | 29.6 | 30.16 | 155875.0 |
| 2003-07-21 | ACO-DELISTED | Stock | 9.6 | 9.6 | 9.25 | 9.47 | 71600.0 |
| 2003-07-21 | ACPW-DELISTED | Stock | 8.0 | 8.2 | 7.8 | 8.0 | 15490.0 |
| 2003-07-21 | ACS-DELISTED | Stock | 43.9 | 43.9 | 42.1 | 43.0 | 2417100.0 |
| 2003-07-21 | ACTA-DELISTED | Stock | 11.2 | 11.6 | 10.6 | 10.8 | 289600.0 |
| 2003-07-21 | ACTG | Stock | 1.55 | 1.58 | 1.5 | 1.54 | 28600.0 |
| 2003-07-21 | ACTI-DELISTED | Stock | 9.14 | 9.4 | 9.14 | 9.25 | 150800.0 |
| 2003-07-21 | ACTT-DELISTED | Stock | 2.08 | 2.08 | 1.851 | 2.05 | 42300.0 |
| 2003-07-21 | ACTU-DELISTED | Stock | 3.02 | 3.14 | 2.9 | 3.13 | 259734.0 |
> showing 50 of 3,378 rows — these rows as CSV