PREVIEW / stock_daily / 2002-11-18
file: by_date/stock_daily/2002/2002-11-18.parquet size: 109 KB rows: 3,245 symbols: 2,007
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-18 | AAPL | Stock | 0.2891 | 0.2893 | 0.2771 | 0.2795 | 164578400.0 |
| 2002-11-18 | MSFT | Stock | 28.475 | 28.515 | 27.87 | 27.925 | 58086400.0 |
| 2002-11-18 | NVDA | Stock | 0.1212 | 0.1217 | 0.1161 | 0.1164 | 1982472000.0 |
| 2002-11-18 | AMZN | Stock | 1.1325 | 1.187 | 1.1075 | 1.121 | 506670000.0 |
| 2002-11-18 | CL | Stock | 26.575 | 26.67 | 26.275 | 26.325 | 2381200.0 |
| 2002-11-18 | A | Stock | 9.7997 | 10.0715 | 9.671 | 9.7282 | 2996613.0 |
| 2002-11-18 | AABA-DELISTED | Stock | 8.69999980926514 | 9.0 | 8.69499969482422 | 8.88000011444092 | 19682600.0 |
| 2002-11-18 | AAI-DELISTED | Stock | 3.97 | 4.05 | 3.83 | 3.83 | 217000.0 |
| 2002-11-18 | AAIC-DELISTED | Stock | 178.0 | 178.0 | 171.6 | 172.2 | 402000.0 |
| 2002-11-18 | AAME | Stock | 1.62 | 1.83 | 1.35 | 1.45 | 18400.0 |
| 2002-11-18 | AAON | Stock | 2.4626 | 2.51 | 2.4481 | 2.4863 | 132131.0 |
| 2002-11-18 | AAP | Stock | 18.1333 | 18.1533 | 17.2333 | 17.4667 | 2168400.0 |
| 2002-11-18 | AAXN-DELISTED | Stock | 0.356666654348373 | 0.356666654348373 | 0.347499996423721 | 0.349999994039536 | 238800.0 |
| 2002-11-18 | ABAX-DELISTED | Stock | 4.0 | 4.0 | 4.0 | 4.0 | 6400.0 |
| 2002-11-18 | ABB-DELISTED | Stock | 2.52 | 2.58 | 2.51 | 2.58 | 433500.0 |
| 2002-11-18 | ABC-DELISTED | Stock | 16.31 | 16.32 | 15.8 | 15.86 | 4974800.0 |
| 2002-11-18 | ABCB | Stock | 11.0314 | 11.2583 | 10.7233 | 10.7233 | 4195.0 |
| 2002-11-18 | ABCO-DELISTED | Stock | 15.5 | 15.755 | 15.04 | 15.675 | 229702.0 |
| 2002-11-18 | ABCW-DELISTED | Stock | 21.03 | 21.03 | 20.41 | 20.41 | 27780.0 |
| 2002-11-18 | ABE-DELISTED | Stock | 5.9 | 5.95 | 5.85 | 5.87 | 8900.0 |
| 2002-11-18 | ABFS-DELISTED | Stock | 29.98 | 29.98 | 28.37 | 28.59 | 331900.0 |
| 2002-11-18 | ABG | Stock | 8.41 | 8.44 | 8.12 | 8.35 | 101400.0 |
| 2002-11-18 | ABK-DELISTED | Stock | 58.03 | 58.25 | 56.26 | 56.38 | 558200.0 |
| 2002-11-18 | ABM | Stock | 14.7 | 14.95 | 14.49 | 14.65 | 93400.0 |
| 2002-11-18 | ABMD-DELISTED | Stock | 4.75 | 4.75 | 4.32 | 4.73 | 42250.0 |
| 2002-11-18 | ABP-DELISTED | Stock | 0.57 | 0.57 | 0.55 | 0.56 | 25500.0 |
| 2002-11-18 | ABT | Stock | 20.223 | 20.3128 | 19.8549 | 19.994 | 6161048.0 |
| 2002-11-18 | ABTL-DELISTED | Stock | 14.05 | 14.25 | 13.0 | 13.55 | 15700.0 |
| 2002-11-18 | ABV-DELISTED | Stock | 15.01 | 15.06 | 14.86 | 14.97 | 136000.0 |
| 2002-11-18 | ABX-DELISTED | Stock | 15.5 | 15.91 | 15.5 | 15.82 | 1190510.0 |
| 2002-11-18 | ACAP-DELISTED | Stock | 16.8 | 16.95 | 16.67 | 16.9 | 44389.0 |
| 2002-11-18 | ACAS-DELISTED | Stock | 19.11 | 19.49 | 18.82 | 19.1 | 787359.0 |
| 2002-11-18 | ACAT-DELISTED | Stock | 15.8 | 16.25 | 15.8 | 16.05 | 28400.0 |
| 2002-11-18 | ACCL-DELISTED | Stock | 7.48732995986938 | 7.49456977844238 | 7.24112987518311 | 7.49456977844238 | 58100.0 |
| 2002-11-18 | ACE-DELISTED | Stock | 31.75 | 32.02 | 31.43 | 31.81 | 1400100.0 |
| 2002-11-18 | ACF-DELISTED | Stock | 7.65 | 7.86 | 7.4 | 7.46 | 2096300.0 |
| 2002-11-18 | ACG-DELISTED | Stock | 8.04 | 8.12 | 8.01 | 8.11 | 441100.0 |
| 2002-11-18 | ACGL | Stock | 3.34 | 3.4889 | 3.2889 | 3.4811 | 1168200.0 |
| 2002-11-18 | ACGN-DELISTED | Stock | 1190.0 | 1292.0 | 1190.0 | 1292.0 | 6300.0 |
| 2002-11-18 | ACH | Stock | 10.74 | 10.7867 | 10.06 | 10.1067 | 162150.0 |
| 2002-11-18 | ACH-DELISTED | Stock | 2.975 | 2.975 | 2.945 | 2.945 | 3600.0 |
| 2002-11-18 | ACLS | Stock | 25.44 | 26.64 | 24.88 | 25.4 | 162875.0 |
| 2002-11-18 | ACO-DELISTED | Stock | 5.85 | 5.85 | 5.55 | 5.6 | 7800.0 |
| 2002-11-18 | ACPW-DELISTED | Stock | 9.45 | 9.45 | 8.9 | 9.0 | 13025.0 |
| 2002-11-18 | ACS-DELISTED | Stock | 42.73 | 44.7 | 42.73 | 43.95 | 1995000.0 |
| 2002-11-18 | ACTA-DELISTED | Stock | 9.6 | 9.8 | 9.0 | 9.4 | 79700.0 |
| 2002-11-18 | ACTT-DELISTED | Stock | 1.3 | 1.42 | 1.21 | 1.35 | 31100.0 |
| 2002-11-18 | ACTU-DELISTED | Stock | 2.0 | 2.13 | 1.71 | 1.91 | 420055.0 |
| 2002-11-18 | ACXM-DELISTED | Stock | 13.73 | 13.79 | 13.35 | 13.46 | 518856.0 |
| 2002-11-18 | AD | Stock | 18.9333 | 18.9667 | 18.1667 | 18.2 | 178500.0 |
> showing 50 of 3,245 rows — these rows as CSV