PREVIEW / stock_daily / 2003-10-24
file: by_date/stock_daily/2003/2003-10-24.parquet size: 119 KB rows: 3,479 symbols: 2,146
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-24 | AAPL | Stock | 0.4029 | 0.408 | 0.397 | 0.4036 | 219856000.0 |
| 2003-10-24 | MSFT | Stock | 27.27 | 27.4 | 26.42 | 26.61 | 210558300.0 |
| 2003-10-24 | NVDA | Stock | 0.1417 | 0.1438 | 0.1403 | 0.1426 | 447084000.0 |
| 2003-10-24 | AMZN | Stock | 2.7275 | 2.747 | 2.65 | 2.7255 | 208764000.0 |
| 2003-10-24 | CL | Stock | 26.595 | 26.595 | 25.65 | 25.925 | 15592000.0 |
| 2003-10-24 | A | Stock | 16.4306 | 16.5165 | 16.2017 | 16.5021 | 1727369.0 |
| 2003-10-24 | AABA-DELISTED | Stock | 19.9799995422363 | 20.3899993896484 | 19.6800003051758 | 20.2649993896484 | 28786600.0 |
| 2003-10-24 | AAI-DELISTED | Stock | 15.9 | 15.96 | 14.45 | 14.85 | 4415100.0 |
| 2003-10-24 | AAIC-DELISTED | Stock | 365.2 | 365.2 | 354.4 | 360.0 | 933600.0 |
| 2003-10-24 | AAME | Stock | 2.4 | 2.41 | 2.4 | 2.4 | 1400.0 |
| 2003-10-24 | AAON | Stock | 2.3151 | 2.3743 | 2.3151 | 2.344 | 149597.0 |
| 2003-10-24 | AAP | Stock | 24.8367 | 25.14 | 24.8333 | 25.0533 | 753300.0 |
| 2003-10-24 | AAXN-DELISTED | Stock | 4.69416666030884 | 4.87416648864746 | 4.51083326339722 | 4.53916645050049 | 7555200.0 |
| 2003-10-24 | ABAX-DELISTED | Stock | 16.05 | 16.31 | 15.15 | 15.39 | 250031.0 |
| 2003-10-24 | ABB-DELISTED | Stock | 5.25 | 5.33 | 5.2 | 5.25 | 178800.0 |
| 2003-10-24 | ABC-DELISTED | Stock | 14.4 | 14.4 | 14.0 | 14.26 | 11353200.0 |
| 2003-10-24 | ABCB | Stock | 13.1955 | 13.1955 | 12.9686 | 12.9686 | 10610.0 |
| 2003-10-24 | ABCO-DELISTED | Stock | 19.885 | 19.995 | 16.275 | 17.675 | 9040980.0 |
| 2003-10-24 | ABCW-DELISTED | Stock | 24.36 | 24.59 | 24.16 | 24.38 | 36780.0 |
| 2003-10-24 | ABE-DELISTED | Stock | 6.72 | 6.82 | 6.68 | 6.75 | 32800.0 |
| 2003-10-24 | ABFS-DELISTED | Stock | 32.72 | 32.93 | 32.07 | 32.67 | 82172.0 |
| 2003-10-24 | ABG | Stock | 16.05 | 16.23 | 14.87 | 15.2 | 98900.0 |
| 2003-10-24 | ABK-DELISTED | Stock | 69.1 | 69.9 | 68.38 | 69.26 | 421600.0 |
| 2003-10-24 | ABM | Stock | 14.6 | 14.92 | 14.51 | 14.68 | 97600.0 |
| 2003-10-24 | ABMD-DELISTED | Stock | 8.7 | 9.169 | 8.7 | 9.05 | 68357.0 |
| 2003-10-24 | ABP-DELISTED | Stock | 0.97 | 0.97 | 0.9 | 0.95 | 49600.0 |
| 2003-10-24 | ABT | Stock | 18.5845 | 18.7551 | 18.396 | 18.7461 | 6355746.0 |
| 2003-10-24 | ABTL-DELISTED | Stock | 60.5 | 60.5 | 48.1 | 48.65 | 299600.0 |
| 2003-10-24 | ABV-DELISTED | Stock | 22.01 | 22.1 | 21.79 | 22.08 | 187800.0 |
| 2003-10-24 | ABVA-DELISTED | Stock | 16.121 | 16.121 | 15.65 | 15.81 | 2600.0 |
| 2003-10-24 | ABX-DELISTED | Stock | 19.5 | 19.77 | 19.43 | 19.55 | 2253800.0 |
| 2003-10-24 | ACAP-DELISTED | Stock | 27.09 | 27.58 | 26.95 | 27.39 | 32240.0 |
| 2003-10-24 | ACAS-DELISTED | Stock | 26.23 | 26.36 | 26.03 | 26.03 | 335204.0 |
| 2003-10-24 | ACAT-DELISTED | Stock | 22.02 | 22.16 | 21.78 | 21.85 | 32592.0 |
| 2003-10-24 | ACCL-DELISTED | Stock | 8.68935966491699 | 8.87761974334717 | 8.63142967224121 | 8.87761974334717 | 190700.0 |
| 2003-10-24 | ACE-DELISTED | Stock | 33.98 | 34.14 | 33.75 | 34.08 | 638259.0 |
| 2003-10-24 | ACF-DELISTED | Stock | 11.37 | 12.1 | 11.15 | 11.73 | 4318200.0 |
| 2003-10-24 | ACG-DELISTED | Stock | 8.25 | 8.27 | 8.23 | 8.25 | 273800.0 |
| 2003-10-24 | ACGL | Stock | 3.9678 | 3.9867 | 3.9256 | 3.9489 | 565200.0 |
| 2003-10-24 | ACGN-DELISTED | Stock | 1167.3288 | 1190.0 | 1076.6712 | 1133.3288 | 87700.0 |
| 2003-10-24 | ACH | Stock | 14.26 | 14.3 | 13.8867 | 13.8867 | 366900.0 |
| 2003-10-24 | ACH-DELISTED | Stock | 10.85 | 11.2 | 10.848 | 11.07 | 361200.0 |
| 2003-10-24 | ACLS | Stock | 34.88 | 36.0 | 34.44 | 35.12 | 138500.0 |
| 2003-10-24 | ACO-DELISTED | Stock | 15.64 | 15.94 | 15.64 | 15.67 | 128300.0 |
| 2003-10-24 | ACPW-DELISTED | Stock | 15.657 | 16.626 | 15.3 | 15.3 | 109417.0 |
| 2003-10-24 | ACS-DELISTED | Stock | 47.38 | 48.05 | 47.34 | 47.96 | 958300.0 |
| 2003-10-24 | ACTA-DELISTED | Stock | 8.4 | 8.6 | 8.0 | 8.2 | 330200.0 |
| 2003-10-24 | ACTG | Stock | 6.58 | 6.6 | 5.88 | 6.2 | 422200.0 |
| 2003-10-24 | ACTI-DELISTED | Stock | 8.51 | 8.72 | 8.45 | 8.62 | 112092.0 |
| 2003-10-24 | ACTT-DELISTED | Stock | 1.4 | 1.401 | 1.35 | 1.38 | 17200.0 |
> showing 50 of 3,479 rows — these rows as CSV