PREVIEW / stock_daily / 2002-09-23
file: by_date/stock_daily/2002/2002-09-23.parquet size: 107 KB rows: 3,196 symbols: 1,983
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-09-23 | AAPL | Stock | 0.2636 | 0.2671 | 0.258 | 0.2652 | 263709600.0 |
| 2002-09-23 | MSFT | Stock | 23.3 | 23.355 | 22.405 | 22.615 | 89783800.0 |
| 2002-09-23 | NVDA | Stock | 0.0755 | 0.0762 | 0.0729 | 0.0734 | 521676000.0 |
| 2002-09-23 | AMZN | Stock | 0.78 | 0.822 | 0.7795 | 0.8025 | 148090000.0 |
| 2002-09-23 | CL | Stock | 26.65 | 26.975 | 26.35 | 26.745 | 2394400.0 |
| 2002-09-23 | A | Stock | 9.9428 | 9.9785 | 9.4707 | 9.5494 | 3924745.0 |
| 2002-09-23 | AABA-DELISTED | Stock | 4.78999996185303 | 4.82499980926514 | 4.5 | 4.53999996185303 | 16616400.0 |
| 2002-09-23 | AAI-DELISTED | Stock | 3.05 | 3.14 | 2.71 | 2.79 | 287200.0 |
| 2002-09-23 | AAIC-DELISTED | Stock | 179.8 | 181.4 | 177.4 | 180.4 | 74400.0 |
| 2002-09-23 | AAME | Stock | 1.75 | 1.8 | 1.75 | 1.8 | 500.0 |
| 2002-09-23 | AAON | Stock | 2.1136 | 2.1939 | 2.1096 | 2.1939 | 115425.0 |
| 2002-09-23 | AAP | Stock | 17.1833 | 17.2 | 16.52 | 16.83 | 914400.0 |
| 2002-09-23 | AAXN-DELISTED | Stock | 0.467500001192093 | 0.495000004768372 | 0.467500001192093 | 0.487500011920929 | 176400.0 |
| 2002-09-23 | ABAX-DELISTED | Stock | 3.1505 | 3.1505 | 3.09 | 3.1 | 4400.0 |
| 2002-09-23 | ABB-DELISTED | Stock | 3.8 | 3.85 | 3.58 | 3.78 | 53400.0 |
| 2002-09-23 | ABC-DELISTED | Stock | 17.06 | 17.2 | 16.89 | 17.1 | 3531200.0 |
| 2002-09-23 | ABCB | Stock | 10.3424 | 10.5856 | 10.3343 | 10.3424 | 9500.0 |
| 2002-09-23 | ABCO-DELISTED | Stock | 13.85 | 13.87 | 13.725 | 13.755 | 60709.0 |
| 2002-09-23 | ABCW-DELISTED | Stock | 20.31 | 20.36 | 19.94 | 19.94 | 69800.0 |
| 2002-09-23 | ABE-DELISTED | Stock | 5.64 | 5.67 | 5.57 | 5.57 | 8500.0 |
| 2002-09-23 | ABFS-DELISTED | Stock | 27.54 | 27.65 | 27.1 | 27.61 | 160162.0 |
| 2002-09-23 | ABG | Stock | 10.01 | 10.08 | 8.85 | 8.9 | 418400.0 |
| 2002-09-23 | ABK-DELISTED | Stock | 51.08 | 53.69 | 50.5 | 53.43 | 1470800.0 |
| 2002-09-23 | ABM | Stock | 13.85 | 14.11 | 13.5 | 14.04 | 165700.0 |
| 2002-09-23 | ABMD-DELISTED | Stock | 3.91 | 4.19 | 3.84 | 3.98 | 84519.0 |
| 2002-09-23 | ABP-DELISTED | Stock | 0.8 | 0.85 | 0.8 | 0.82 | 24600.0 |
| 2002-09-23 | ABT | Stock | 18.7685 | 19.0783 | 18.6429 | 18.7192 | 12137201.0 |
| 2002-09-23 | ABTL-DELISTED | Stock | 10.4 | 11.85 | 10.4 | 11.5 | 34100.0 |
| 2002-09-23 | ABV-DELISTED | Stock | 11.85 | 11.9 | 11.61 | 11.8 | 588400.0 |
| 2002-09-23 | ABX-DELISTED | Stock | 17.86 | 17.92 | 17.31 | 17.41 | 3278610.0 |
| 2002-09-23 | ACAP-DELISTED | Stock | 17.3 | 17.3 | 17.07 | 17.18 | 30100.0 |
| 2002-09-23 | ACAS-DELISTED | Stock | 18.17 | 18.29 | 17.4 | 17.85 | 768329.0 |
| 2002-09-23 | ACAT-DELISTED | Stock | 14.0 | 14.05 | 13.85 | 13.96 | 105400.0 |
| 2002-09-23 | ACCL-DELISTED | Stock | 6.0391001701355 | 6.15496015548706 | 5.93049001693726 | 6.15496015548706 | 665700.0 |
| 2002-09-23 | ACE-DELISTED | Stock | 31.9 | 32.09 | 30.7 | 30.9 | 2113800.0 |
| 2002-09-23 | ACF-DELISTED | Stock | 6.6 | 6.63 | 6.05 | 6.53 | 1906300.0 |
| 2002-09-23 | ACG-DELISTED | Stock | 8.19 | 8.21 | 8.18 | 8.19 | 566400.0 |
| 2002-09-23 | ACGL | Stock | 3.1056 | 3.1189 | 3.0444 | 3.0667 | 346500.0 |
| 2002-09-23 | ACH | Stock | 9.6 | 9.6667 | 9.3333 | 9.3467 | 323400.0 |
| 2002-09-23 | ACH-DELISTED | Stock | 2.7568 | 2.7568 | 2.6641 | 2.7067 | 84590.0 |
| 2002-09-23 | ACLS | Stock | 19.88 | 19.88 | 18.24 | 18.68 | 151075.0 |
| 2002-09-23 | ACO-DELISTED | Stock | 6.05 | 6.05 | 6.0 | 6.01 | 7800.0 |
| 2002-09-23 | ACPW-DELISTED | Stock | 6.35 | 6.9 | 6.35 | 6.6 | 7240.0 |
| 2002-09-23 | ACS-DELISTED | Stock | 41.1 | 41.1 | 40.1 | 40.85 | 946600.0 |
| 2002-09-23 | ACTA-DELISTED | Stock | 4.0 | 4.2 | 3.8 | 3.8 | 55300.0 |
| 2002-09-23 | ACTT-DELISTED | Stock | 1.69 | 1.69 | 1.52 | 1.56 | 19200.0 |
| 2002-09-23 | ACTU-DELISTED | Stock | 1.0 | 1.02 | 0.75 | 0.76 | 2424725.0 |
| 2002-09-23 | ACXM-DELISTED | Stock | 16.56 | 16.6 | 15.62 | 15.92 | 678412.0 |
| 2002-09-23 | ACY-DELISTED | Stock | 4.0 | 4.08 | 4.0 | 4.08 | 700.0 |
| 2002-09-23 | AD | Stock | 20.9733 | 20.9733 | 20.4333 | 20.48 | 125100.0 |
> showing 50 of 3,196 rows — these rows as CSV