PREVIEW / stock_daily / 2002-10-23
file: by_date/stock_daily/2002/2002-10-23.parquet size: 108 KB rows: 3,203 symbols: 1,980
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-10-23 | AAPL | Stock | 0.2613 | 0.2675 | 0.2589 | 0.2657 | 209036800.0 |
| 2002-10-23 | MSFT | Stock | 25.715 | 26.63 | 25.715 | 26.6 | 110866600.0 |
| 2002-10-23 | NVDA | Stock | 0.0896 | 0.0931 | 0.0883 | 0.0918 | 925428000.0 |
| 2002-10-23 | AMZN | Stock | 0.976 | 0.991 | 0.9685 | 0.9875 | 132962000.0 |
| 2002-10-23 | CL | Stock | 28.225 | 28.495 | 27.87 | 28.3 | 3466600.0 |
| 2002-10-23 | A | Stock | 8.7268 | 8.9056 | 8.3691 | 8.5837 | 5423541.0 |
| 2002-10-23 | AABA-DELISTED | Stock | 7.28000020980835 | 7.53499984741211 | 7.17500019073486 | 7.53499984741211 | 29811600.0 |
| 2002-10-23 | AAI-DELISTED | Stock | 3.49 | 4.42 | 3.49 | 4.09 | 923700.0 |
| 2002-10-23 | AAIC-DELISTED | Stock | 205.4 | 207.8 | 202.0 | 207.8 | 42700.0 |
| 2002-10-23 | AAME | Stock | 2.0 | 2.03 | 1.7 | 1.7 | 5100.0 |
| 2002-10-23 | AAON | Stock | 2.3045 | 2.3638 | 2.3045 | 2.3638 | 167062.0 |
| 2002-10-23 | AAP | Stock | 18.0 | 18.3167 | 17.89 | 18.0667 | 976800.0 |
| 2002-10-23 | AAXN-DELISTED | Stock | 0.303333342075348 | 0.305833339691162 | 0.284166663885117 | 0.286666661500931 | 260400.0 |
| 2002-10-23 | ABAX-DELISTED | Stock | 4.0 | 4.4 | 4.0 | 4.1 | 21600.0 |
| 2002-10-23 | ABB-DELISTED | Stock | 1.29 | 1.4 | 1.12 | 1.32 | 1606300.0 |
| 2002-10-23 | ABC-DELISTED | Stock | 18.49 | 18.66 | 18.29 | 18.66 | 3837364.0 |
| 2002-10-23 | ABCB | Stock | 10.618 | 10.618 | 10.1317 | 10.4884 | 62306.0 |
| 2002-10-23 | ABCO-DELISTED | Stock | 16.34 | 17.5 | 16.3 | 17.5 | 77800.0 |
| 2002-10-23 | ABCW-DELISTED | Stock | 20.07 | 20.46 | 20.03 | 20.34 | 7600.0 |
| 2002-10-23 | ABE-DELISTED | Stock | 5.75 | 5.91 | 5.68 | 5.91 | 12500.0 |
| 2002-10-23 | ABFS-DELISTED | Stock | 31.0 | 31.0 | 29.25 | 30.76 | 368891.0 |
| 2002-10-23 | ABG | Stock | 8.56 | 8.9 | 8.56 | 8.64 | 24100.0 |
| 2002-10-23 | ABK-DELISTED | Stock | 62.94 | 63.3 | 61.69 | 63.27 | 670300.0 |
| 2002-10-23 | ABM | Stock | 14.0 | 14.48 | 13.98 | 14.46 | 88600.0 |
| 2002-10-23 | ABMD-DELISTED | Stock | 3.6 | 4.35 | 3.59 | 4.23 | 43900.0 |
| 2002-10-23 | ABP-DELISTED | Stock | 0.7 | 0.7 | 0.67 | 0.68 | 23400.0 |
| 2002-10-23 | ABT | Stock | 19.0334 | 19.4015 | 18.6518 | 19.3746 | 9785902.0 |
| 2002-10-23 | ABTL-DELISTED | Stock | 11.85 | 12.0 | 11.45 | 11.95 | 31700.0 |
| 2002-10-23 | ABV-DELISTED | Stock | 11.34 | 12.12 | 11.34 | 11.99 | 1296800.0 |
| 2002-10-23 | ABVA-DELISTED | Stock | 10.0 | 10.0 | 10.0 | 10.0 | 200.0 |
| 2002-10-23 | ABX-DELISTED | Stock | 14.83 | 14.86 | 14.51 | 14.64 | 2274800.0 |
| 2002-10-23 | ACAP-DELISTED | Stock | 15.56 | 15.97 | 15.4 | 15.77 | 42461.0 |
| 2002-10-23 | ACAS-DELISTED | Stock | 19.5 | 20.0 | 19.07 | 19.75 | 466104.0 |
| 2002-10-23 | ACAT-DELISTED | Stock | 14.75 | 14.75 | 14.36 | 14.4 | 8387.0 |
| 2002-10-23 | ACCL-DELISTED | Stock | 6.80000019073486 | 6.82800006866455 | 6.40799999237061 | 6.69799995422363 | 58200.0 |
| 2002-10-23 | ACE-DELISTED | Stock | 34.95 | 34.99 | 33.62 | 34.14 | 1855700.0 |
| 2002-10-23 | ACF-DELISTED | Stock | 7.07 | 7.07 | 6.82 | 7.03 | 1066400.0 |
| 2002-10-23 | ACG-DELISTED | Stock | 7.9 | 7.94 | 7.87 | 7.89 | 483600.0 |
| 2002-10-23 | ACGL | Stock | 3.0389 | 3.0556 | 3.0278 | 3.0333 | 216000.0 |
| 2002-10-23 | ACGN-DELISTED | Stock | 986.0 | 986.0 | 986.0 | 986.0 | 600.0 |
| 2002-10-23 | ACH | Stock | 9.6667 | 9.8533 | 9.5333 | 9.7333 | 98400.0 |
| 2002-10-23 | ACH-DELISTED | Stock | 2.9125 | 2.9125 | 2.9 | 2.9 | 8000.0 |
| 2002-10-23 | ACLS | Stock | 18.4 | 20.24 | 17.48 | 20.24 | 167825.0 |
| 2002-10-23 | ACO-DELISTED | Stock | 5.24 | 5.33 | 5.08 | 5.1 | 154200.0 |
| 2002-10-23 | ACPW-DELISTED | Stock | 10.427 | 10.427 | 9.28 | 10.423 | 18454.0 |
| 2002-10-23 | ACS-DELISTED | Stock | 43.78 | 46.1 | 43.45 | 46.1 | 1893800.0 |
| 2002-10-23 | ACTA-DELISTED | Stock | 4.6 | 4.8 | 4.4 | 4.6 | 25900.0 |
| 2002-10-23 | ACTT-DELISTED | Stock | 1.15 | 1.35 | 1.15 | 1.31 | 23900.0 |
| 2002-10-23 | ACTU-DELISTED | Stock | 1.02 | 1.17 | 1.0 | 1.15 | 128436.0 |
| 2002-10-23 | ACXM-DELISTED | Stock | 13.86 | 14.5 | 12.64 | 14.39 | 2098363.0 |
> showing 50 of 3,203 rows — these rows as CSV