PREVIEW / stock_daily / 2002-10-31
file: by_date/stock_daily/2002/2002-10-31.parquet size: 108 KB rows: 3,213 symbols: 1,986
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-31 | AAPL | Stock | 0.2855 | 0.2936 | 0.2843 | 0.287 | 295836800.0 |
| 2002-10-31 | MSFT | Stock | 26.595 | 27.035 | 26.425 | 26.735 | 105973800.0 |
| 2002-10-31 | NVDA | Stock | 0.0943 | 0.0998 | 0.0941 | 0.0992 | 1255476000.0 |
| 2002-10-31 | AMZN | Stock | 0.9515 | 0.974 | 0.9425 | 0.968 | 136452000.0 |
| 2002-10-31 | CL | Stock | 27.98 | 28.0 | 27.35 | 27.49 | 3231200.0 |
| 2002-10-31 | A | Stock | 10.0 | 10.1717 | 9.6996 | 9.8355 | 4303463.0 |
| 2002-10-31 | AABA-DELISTED | Stock | 7.51000022888184 | 7.65999984741211 | 7.35500001907349 | 7.46000003814697 | 20530800.0 |
| 2002-10-31 | AAI-DELISTED | Stock | 3.74 | 3.84 | 3.66 | 3.77 | 203900.0 |
| 2002-10-31 | AAIC-DELISTED | Stock | 199.8 | 200.0 | 198.4 | 199.6 | 84300.0 |
| 2002-10-31 | AAME | Stock | 1.72 | 1.8 | 1.62 | 1.8 | 3200.0 |
| 2002-10-31 | AAON | Stock | 2.5271 | 2.5284 | 2.4639 | 2.4639 | 92644.0 |
| 2002-10-31 | AAP | Stock | 17.7667 | 18.05 | 17.7367 | 17.85 | 840600.0 |
| 2002-10-31 | AAXN-DELISTED | Stock | 0.295833319425583 | 0.296666651964188 | 0.284999996423721 | 0.295833319425583 | 127200.0 |
| 2002-10-31 | ABAX-DELISTED | Stock | 4.03 | 4.05 | 3.95 | 4.05 | 5600.0 |
| 2002-10-31 | ABB-DELISTED | Stock | 1.4 | 1.4 | 1.32 | 1.36 | 381800.0 |
| 2002-10-31 | ABC-DELISTED | Stock | 18.4 | 18.5 | 17.75 | 17.8 | 4481200.0 |
| 2002-10-31 | ABCB | Stock | 10.4721 | 10.537 | 10.3748 | 10.3748 | 6045.0 |
| 2002-10-31 | ABCO-DELISTED | Stock | 15.725 | 16.315 | 15.725 | 16.025 | 94560.0 |
| 2002-10-31 | ABCW-DELISTED | Stock | 20.75 | 20.9 | 20.18 | 20.72 | 19100.0 |
| 2002-10-31 | ABE-DELISTED | Stock | 5.89 | 5.97 | 5.87 | 5.97 | 49700.0 |
| 2002-10-31 | ABFS-DELISTED | Stock | 30.8 | 30.93 | 29.78 | 29.95 | 236052.0 |
| 2002-10-31 | ABG | Stock | 7.9 | 8.75 | 7.5 | 8.75 | 237100.0 |
| 2002-10-31 | ABK-DELISTED | Stock | 61.77 | 63.11 | 61.16 | 61.83 | 668300.0 |
| 2002-10-31 | ABM | Stock | 15.0 | 15.28 | 14.6 | 14.69 | 100700.0 |
| 2002-10-31 | ABMD-DELISTED | Stock | 3.94 | 4.05 | 3.765 | 3.9 | 21250.0 |
| 2002-10-31 | ABP-DELISTED | Stock | 0.62 | 0.7 | 0.62 | 0.69 | 13400.0 |
| 2002-10-31 | ABT | Stock | 18.7416 | 19.0334 | 18.4678 | 18.7955 | 7914442.0 |
| 2002-10-31 | ABTL-DELISTED | Stock | 12.95 | 12.95 | 11.75 | 11.8 | 19800.0 |
| 2002-10-31 | ABV-DELISTED | Stock | 14.11 | 15.06 | 14.11 | 14.45 | 691800.0 |
| 2002-10-31 | ABX-DELISTED | Stock | 15.59 | 15.6 | 15.01 | 15.07 | 2212700.0 |
| 2002-10-31 | ACAP-DELISTED | Stock | 15.5 | 15.75 | 15.36 | 15.75 | 18300.0 |
| 2002-10-31 | ACAS-DELISTED | Stock | 19.67 | 20.33 | 19.6 | 19.69 | 531041.0 |
| 2002-10-31 | ACAT-DELISTED | Stock | 14.25 | 14.3 | 14.05 | 14.13 | 170800.0 |
| 2002-10-31 | ACCL-DELISTED | Stock | 6.80999994277954 | 7.2979998588562 | 6.80700016021729 | 7.07499980926514 | 102300.0 |
| 2002-10-31 | ACE-DELISTED | Stock | 32.35 | 32.35 | 30.55 | 30.8 | 4067900.0 |
| 2002-10-31 | ACF-DELISTED | Stock | 7.24 | 7.5 | 7.02 | 7.47 | 2441700.0 |
| 2002-10-31 | ACG-DELISTED | Stock | 7.99 | 8.02 | 7.95 | 8.01 | 266800.0 |
| 2002-10-31 | ACGL | Stock | 3.1389 | 3.1389 | 3.0278 | 3.1122 | 1916100.0 |
| 2002-10-31 | ACGN-DELISTED | Stock | 1020.0 | 1144.6712 | 1020.0 | 1076.6712 | 26300.0 |
| 2002-10-31 | ACH | Stock | 9.7333 | 9.8133 | 9.5867 | 9.8133 | 141150.0 |
| 2002-10-31 | ACH-DELISTED | Stock | 2.7455 | 2.7605 | 2.7455 | 2.753 | 10799.0 |
| 2002-10-31 | ACLS | Stock | 22.96 | 23.2 | 21.36 | 21.52 | 186350.0 |
| 2002-10-31 | ACO-DELISTED | Stock | 5.42 | 5.5 | 5.4 | 5.49 | 14000.0 |
| 2002-10-31 | ACPW-DELISTED | Stock | 10.65 | 10.75 | 10.25 | 10.3 | 14860.0 |
| 2002-10-31 | ACS-DELISTED | Stock | 47.15 | 47.5 | 45.62 | 46.05 | 1158100.0 |
| 2002-10-31 | ACTA-DELISTED | Stock | 6.6 | 7.4 | 6.4 | 7.4 | 102800.0 |
| 2002-10-31 | ACTT-DELISTED | Stock | 1.3 | 1.31 | 1.14 | 1.22 | 35100.0 |
| 2002-10-31 | ACTU-DELISTED | Stock | 1.73 | 1.85 | 1.7 | 1.82 | 763146.0 |
| 2002-10-31 | ACXM-DELISTED | Stock | 12.31 | 12.74 | 12.17 | 12.6 | 1291603.0 |
| 2002-10-31 | AD | Stock | 17.7667 | 18.5067 | 17.74 | 18.4 | 251250.0 |
> showing 50 of 3,213 rows — these rows as CSV