PREVIEW / stock_daily / 2002-11-01
file: by_date/stock_daily/2002/2002-11-01.parquet size: 108 KB rows: 3,189 symbols: 1,961
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-01 | AAPL | Stock | 0.2846 | 0.2946 | 0.2838 | 0.2921 | 189828800.0 |
| 2002-11-01 | MSFT | Stock | 26.215 | 26.62 | 25.95 | 26.5 | 105097800.0 |
| 2002-11-01 | NVDA | Stock | 0.0977 | 0.1189 | 0.0975 | 0.1175 | 2128836000.0 |
| 2002-11-01 | AMZN | Stock | 0.961 | 0.995 | 0.9545 | 0.99 | 110988000.0 |
| 2002-11-01 | CL | Stock | 27.615 | 27.615 | 27.05 | 27.5 | 4177800.0 |
| 2002-11-01 | A | Stock | 9.7711 | 10.4721 | 9.4421 | 10.4292 | 2990042.0 |
| 2002-11-01 | AABA-DELISTED | Stock | 7.34999990463257 | 7.61499977111816 | 7.25 | 7.57499980926514 | 19034000.0 |
| 2002-11-01 | AAI-DELISTED | Stock | 3.79 | 4.02 | 3.78 | 4.02 | 377400.0 |
| 2002-11-01 | AAIC-DELISTED | Stock | 198.6 | 200.0 | 193.0 | 193.0 | 70900.0 |
| 2002-11-01 | AAME | Stock | 1.63 | 1.87 | 1.63 | 1.74 | 5300.0 |
| 2002-11-01 | AAON | Stock | 2.5258 | 2.6074 | 2.4902 | 2.5811 | 277172.0 |
| 2002-11-01 | AAP | Stock | 17.3333 | 17.7667 | 17.3167 | 17.5167 | 2199300.0 |
| 2002-11-01 | AAXN-DELISTED | Stock | 0.297500014305115 | 0.299166679382324 | 0.28833332657814 | 0.296666651964188 | 94800.0 |
| 2002-11-01 | ABAX-DELISTED | Stock | 4.05 | 4.05 | 3.85 | 3.93 | 32900.0 |
| 2002-11-01 | ABB-DELISTED | Stock | 1.3 | 1.43 | 1.15 | 1.4 | 3772900.0 |
| 2002-11-01 | ABC-DELISTED | Stock | 17.79 | 18.2 | 17.7 | 18.11 | 3268400.0 |
| 2002-11-01 | ABCB | Stock | 10.3748 | 10.9422 | 10.3748 | 10.9422 | 39604.0 |
| 2002-11-01 | ABCO-DELISTED | Stock | 16.345 | 16.375 | 15.97 | 16.2 | 50040.0 |
| 2002-11-01 | ABCW-DELISTED | Stock | 20.32 | 21.4 | 20.32 | 21.35 | 42240.0 |
| 2002-11-01 | ABE-DELISTED | Stock | 5.89 | 5.93 | 5.89 | 5.92 | 22200.0 |
| 2002-11-01 | ABFS-DELISTED | Stock | 29.89 | 30.1 | 29.71 | 30.0 | 168971.0 |
| 2002-11-01 | ABG | Stock | 8.7 | 9.47 | 8.39 | 9.29 | 85200.0 |
| 2002-11-01 | ABK-DELISTED | Stock | 61.76 | 61.77 | 59.9 | 60.93 | 1126000.0 |
| 2002-11-01 | ABM | Stock | 14.6 | 15.15 | 14.59 | 15.15 | 68500.0 |
| 2002-11-01 | ABMD-DELISTED | Stock | 3.66 | 4.0 | 3.66 | 4.0 | 28600.0 |
| 2002-11-01 | ABP-DELISTED | Stock | 0.67 | 0.68 | 0.67 | 0.67 | 4800.0 |
| 2002-11-01 | ABT | Stock | 18.5396 | 18.8404 | 18.4139 | 18.7326 | 6919568.0 |
| 2002-11-01 | ABTL-DELISTED | Stock | 11.9 | 11.95 | 11.6 | 11.6 | 14700.0 |
| 2002-11-01 | ABV-DELISTED | Stock | 14.48 | 14.99 | 14.48 | 14.82 | 353000.0 |
| 2002-11-01 | ABVA-DELISTED | Stock | 10.88 | 10.88 | 10.88 | 10.88 | 500.0 |
| 2002-11-01 | ABX-DELISTED | Stock | 15.4 | 15.6 | 15.2 | 15.55 | 2012400.0 |
| 2002-11-01 | ACAP-DELISTED | Stock | 15.69 | 15.9 | 15.64 | 15.9 | 18500.0 |
| 2002-11-01 | ACAS-DELISTED | Stock | 19.65 | 19.94 | 19.43 | 19.59 | 466630.0 |
| 2002-11-01 | ACAT-DELISTED | Stock | 13.995 | 14.7 | 13.995 | 14.7 | 51258.0 |
| 2002-11-01 | ACCL-DELISTED | Stock | 7.09631013870239 | 7.4293999671936 | 7.09631013870239 | 7.4293999671936 | 165100.0 |
| 2002-11-01 | ACE-DELISTED | Stock | 30.89 | 30.99 | 30.39 | 30.79 | 2277738.0 |
| 2002-11-01 | ACF-DELISTED | Stock | 7.5 | 8.05 | 7.28 | 8.0 | 2463000.0 |
| 2002-11-01 | ACG-DELISTED | Stock | 8.0 | 8.03 | 7.99 | 8.0 | 242900.0 |
| 2002-11-01 | ACGL | Stock | 3.1111 | 3.1211 | 3.0833 | 3.1111 | 343800.0 |
| 2002-11-01 | ACGN-DELISTED | Stock | 997.3288 | 1054.0 | 929.3288 | 1020.0 | 28700.0 |
| 2002-11-01 | ACH | Stock | 9.88 | 10.2867 | 9.8667 | 10.2333 | 368250.0 |
| 2002-11-01 | ACH-DELISTED | Stock | 2.823 | 2.8255 | 2.803 | 2.803 | 7193.0 |
| 2002-11-01 | ACLS | Stock | 21.52 | 24.0 | 21.0 | 23.84 | 193225.0 |
| 2002-11-01 | ACO-DELISTED | Stock | 5.59 | 5.68 | 5.4 | 5.58 | 23200.0 |
| 2002-11-01 | ACPW-DELISTED | Stock | 10.3 | 11.0 | 10.2 | 11.0 | 33380.0 |
| 2002-11-01 | ACS-DELISTED | Stock | 45.7 | 47.09 | 44.6 | 47.0 | 1183000.0 |
| 2002-11-01 | ACTA-DELISTED | Stock | 7.0 | 7.6 | 6.4 | 7.0 | 52300.0 |
| 2002-11-01 | ACTT-DELISTED | Stock | 1.18 | 1.29 | 1.18 | 1.27 | 47390.0 |
| 2002-11-01 | ACTU-DELISTED | Stock | 1.85 | 2.28 | 1.77 | 2.28 | 415148.0 |
| 2002-11-01 | ACXM-DELISTED | Stock | 12.56 | 13.52 | 12.25 | 13.52 | 1434263.0 |
> showing 50 of 3,189 rows — these rows as CSV