PREVIEW / stock_daily / 2002-11-22
file: by_date/stock_daily/2002/2002-11-22.parquet size: 110 KB rows: 3,233 symbols: 1,992
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 |
|---|---|---|---|---|---|---|---|
| 2002-11-22 | AAPL | Stock | 0.2873 | 0.2911 | 0.2839 | 0.2859 | 227858400.0 |
| 2002-11-22 | MSFT | Stock | 28.725 | 29.15 | 28.525 | 29.11 | 70002000.0 |
| 2002-11-22 | NVDA | Stock | 0.1263 | 0.1337 | 0.125 | 0.131 | 1251900000.0 |
| 2002-11-22 | AMZN | Stock | 1.16 | 1.214 | 1.155 | 1.1995 | 233732000.0 |
| 2002-11-22 | CL | Stock | 25.9 | 26.325 | 25.75 | 25.785 | 6574200.0 |
| 2002-11-22 | A | Stock | 13.0544 | 13.412 | 12.8755 | 13.0544 | 4724960.0 |
| 2002-11-22 | AABA-DELISTED | Stock | 9.35000038146973 | 9.38000011444092 | 9.05500030517578 | 9.19999980926514 | 16801400.0 |
| 2002-11-22 | AAI-DELISTED | Stock | 3.71 | 3.8 | 3.6 | 3.76 | 254000.0 |
| 2002-11-22 | AAIC-DELISTED | Stock | 185.0 | 185.6 | 182.2 | 183.0 | 241900.0 |
| 2002-11-22 | AAME | Stock | 1.79 | 1.79 | 1.5 | 1.59 | 12400.0 |
| 2002-11-22 | AAON | Stock | 2.5995 | 2.7654 | 2.5758 | 2.7654 | 217181.0 |
| 2002-11-22 | AAP | Stock | 18.14 | 18.2 | 17.55 | 17.9333 | 2559000.0 |
| 2002-11-22 | AAXN-DELISTED | Stock | 0.297500014305115 | 0.316666662693024 | 0.291666656732559 | 0.308333337306976 | 469200.0 |
| 2002-11-22 | ABAX-DELISTED | Stock | 4.159 | 4.24 | 4.14 | 4.24 | 3200.0 |
| 2002-11-22 | ABB-DELISTED | Stock | 3.0 | 3.13 | 2.97 | 2.99 | 729200.0 |
| 2002-11-22 | ABC-DELISTED | Stock | 14.4 | 14.98 | 14.31 | 14.83 | 11092000.0 |
| 2002-11-22 | ABCB | Stock | 10.5775 | 10.6261 | 10.4802 | 10.5532 | 3701.0 |
| 2002-11-22 | ABCO-DELISTED | Stock | 14.995 | 14.995 | 14.7 | 14.76 | 126400.0 |
| 2002-11-22 | ABCW-DELISTED | Stock | 20.36 | 20.7 | 20.1 | 20.7 | 12670.0 |
| 2002-11-22 | ABE-DELISTED | Stock | 6.0 | 6.02 | 5.92 | 5.92 | 2700.0 |
| 2002-11-22 | ABFS-DELISTED | Stock | 29.47 | 29.47 | 28.41 | 28.96 | 311600.0 |
| 2002-11-22 | ABG | Stock | 8.26 | 8.3 | 8.17 | 8.3 | 174000.0 |
| 2002-11-22 | ABK-DELISTED | Stock | 59.5 | 61.59 | 59.35 | 61.18 | 1125200.0 |
| 2002-11-22 | ABM | Stock | 14.7 | 15.68 | 14.68 | 15.45 | 119700.0 |
| 2002-11-22 | ABMD-DELISTED | Stock | 5.325 | 5.37 | 5.0 | 5.019 | 43175.0 |
| 2002-11-22 | ABP-DELISTED | Stock | 0.62 | 0.66 | 0.62 | 0.65 | 43100.0 |
| 2002-11-22 | ABT | Stock | 20.3577 | 20.425 | 19.6394 | 19.6619 | 11021141.0 |
| 2002-11-22 | ABTL-DELISTED | Stock | 14.55 | 16.0 | 14.5 | 15.55 | 55100.0 |
| 2002-11-22 | ABV-DELISTED | Stock | 14.7 | 15.19 | 14.7 | 15.05 | 321900.0 |
| 2002-11-22 | ABX-DELISTED | Stock | 15.19 | 15.36 | 14.82 | 15.03 | 2531800.0 |
| 2002-11-22 | ACAP-DELISTED | Stock | 17.14 | 17.73 | 17.07 | 17.72 | 13300.0 |
| 2002-11-22 | ACAS-DELISTED | Stock | 19.77 | 20.45 | 19.7 | 20.2 | 831900.0 |
| 2002-11-22 | ACAT-DELISTED | Stock | 16.39 | 16.539 | 15.96 | 15.97 | 24056.0 |
| 2002-11-22 | ACCL-DELISTED | Stock | 7.8493800163269 | 8.07386016845703 | 7.8493800163269 | 8.07386016845703 | 99600.0 |
| 2002-11-22 | ACE-DELISTED | Stock | 32.75 | 34.4 | 32.6 | 34.02 | 1719700.0 |
| 2002-11-22 | ACF-DELISTED | Stock | 8.35 | 8.38 | 8.05 | 8.22 | 1446000.0 |
| 2002-11-22 | ACG-DELISTED | Stock | 8.11 | 8.18 | 8.1 | 8.18 | 335300.0 |
| 2002-11-22 | ACGL | Stock | 3.3556 | 3.3556 | 3.3056 | 3.3444 | 335700.0 |
| 2002-11-22 | ACGN-DELISTED | Stock | 1144.6712 | 1201.3288 | 1133.3288 | 1156.0 | 24200.0 |
| 2002-11-22 | ACH | Stock | 10.6 | 10.8 | 10.5867 | 10.7733 | 176550.0 |
| 2002-11-22 | ACH-DELISTED | Stock | 2.9045 | 2.932 | 2.8745 | 2.912 | 20001.0 |
| 2002-11-22 | ACLS | Stock | 28.52 | 30.44 | 27.72 | 30.4 | 158175.0 |
| 2002-11-22 | ACO-DELISTED | Stock | 5.9 | 5.99 | 5.9 | 5.96 | 5600.0 |
| 2002-11-22 | ACPW-DELISTED | Stock | 9.0 | 9.7 | 8.8 | 9.05 | 40375.0 |
| 2002-11-22 | ACS-DELISTED | Stock | 47.06 | 49.75 | 46.61 | 49.0 | 2375400.0 |
| 2002-11-22 | ACTA-DELISTED | Stock | 11.0 | 11.6 | 10.8 | 11.0 | 153600.0 |
| 2002-11-22 | ACTT-DELISTED | Stock | 1.49 | 1.5 | 1.3 | 1.36 | 52300.0 |
| 2002-11-22 | ACTU-DELISTED | Stock | 2.31 | 2.65 | 2.24 | 2.52 | 1335015.0 |
| 2002-11-22 | ACXM-DELISTED | Stock | 14.86 | 15.5 | 14.8 | 15.02 | 1062621.0 |
| 2002-11-22 | ACY-DELISTED | Stock | 4.0 | 4.0 | 4.0 | 4.0 | 2200.0 |
> showing 50 of 3,233 rows — these rows as CSV