PREVIEW / stock_daily / 2002-11-05
file: by_date/stock_daily/2002/2002-11-05.parquet size: 109 KB rows: 3,211 symbols: 1,982
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-05 | AAPL | Stock | 0.2991 | 0.3029 | 0.292 | 0.3018 | 210694400.0 |
| 2002-11-05 | MSFT | Stock | 27.89 | 28.4 | 27.79 | 28.34 | 76658200.0 |
| 2002-11-05 | NVDA | Stock | 0.13 | 0.1322 | 0.1196 | 0.1252 | 2034540000.0 |
| 2002-11-05 | AMZN | Stock | 0.9315 | 0.9435 | 0.91 | 0.936 | 158848000.0 |
| 2002-11-05 | CL | Stock | 26.77 | 27.25 | 26.77 | 27.25 | 3657000.0 |
| 2002-11-05 | A | Stock | 10.7296 | 10.9514 | 10.5079 | 10.7797 | 2230509.0 |
| 2002-11-05 | AABA-DELISTED | Stock | 8.14999961853027 | 8.54500007629395 | 8.13000011444092 | 8.51500034332275 | 24968000.0 |
| 2002-11-05 | AAI-DELISTED | Stock | 4.08 | 4.19 | 4.05 | 4.18 | 142600.0 |
| 2002-11-05 | AAIC-DELISTED | Stock | 196.2 | 196.2 | 191.0 | 192.4 | 21500.0 |
| 2002-11-05 | AAME | Stock | 1.74 | 1.77 | 1.72 | 1.77 | 1000.0 |
| 2002-11-05 | AAON | Stock | 2.6008 | 2.6008 | 2.5903 | 2.5995 | 34931.0 |
| 2002-11-05 | AAP | Stock | 17.5167 | 17.74 | 17.3033 | 17.5433 | 689700.0 |
| 2002-11-05 | AAXN-DELISTED | Stock | 0.300000011920929 | 0.300000011920929 | 0.289166659116745 | 0.289166659116745 | 32400.0 |
| 2002-11-05 | ABAX-DELISTED | Stock | 4.24 | 4.24 | 3.99 | 4.1 | 55000.0 |
| 2002-11-05 | ABB-DELISTED | Stock | 1.75 | 1.8 | 1.68 | 1.73 | 845300.0 |
| 2002-11-05 | ABC-DELISTED | Stock | 17.99 | 18.1 | 16.6 | 17.22 | 23152000.0 |
| 2002-11-05 | ABCB | Stock | 10.9503 | 11.1854 | 10.9503 | 11.1692 | 5182.0 |
| 2002-11-05 | ABCO-DELISTED | Stock | 16.64 | 16.935 | 16.49 | 16.81 | 180562.0 |
| 2002-11-05 | ABCW-DELISTED | Stock | 20.8 | 21.4 | 20.79 | 21.39 | 9710.0 |
| 2002-11-05 | ABE-DELISTED | Stock | 6.0 | 6.0 | 5.94 | 5.94 | 8300.0 |
| 2002-11-05 | ABFS-DELISTED | Stock | 30.22 | 30.5 | 29.86 | 30.0 | 185600.0 |
| 2002-11-05 | ABG | Stock | 8.75 | 9.2 | 8.75 | 9.0 | 176000.0 |
| 2002-11-05 | ABK-DELISTED | Stock | 61.1 | 62.0 | 59.95 | 60.29 | 930200.0 |
| 2002-11-05 | ABM | Stock | 14.8 | 14.8 | 14.36 | 14.55 | 75000.0 |
| 2002-11-05 | ABMD-DELISTED | Stock | 3.65 | 3.85 | 3.65 | 3.74 | 48715.0 |
| 2002-11-05 | ABP-DELISTED | Stock | 0.65 | 0.65 | 0.62 | 0.63 | 55300.0 |
| 2002-11-05 | ABT | Stock | 19.1456 | 19.599 | 18.9436 | 19.5047 | 8053448.0 |
| 2002-11-05 | ABTL-DELISTED | Stock | 11.6 | 11.8 | 11.6 | 11.65 | 13200.0 |
| 2002-11-05 | ABV-DELISTED | Stock | 14.1 | 14.6 | 13.99 | 14.4 | 127600.0 |
| 2002-11-05 | ABVA-DELISTED | Stock | 10.52 | 10.6 | 10.38 | 10.38 | 8000.0 |
| 2002-11-05 | ABX-DELISTED | Stock | 15.9 | 16.1 | 15.72 | 16.0 | 2435800.0 |
| 2002-11-05 | ACAP-DELISTED | Stock | 15.4 | 15.76 | 15.25 | 15.75 | 12700.0 |
| 2002-11-05 | ACAS-DELISTED | Stock | 20.11 | 20.79 | 20.07 | 20.17 | 398210.0 |
| 2002-11-05 | ACAT-DELISTED | Stock | 15.12 | 15.63 | 15.04 | 15.43 | 66200.0 |
| 2002-11-05 | ACCL-DELISTED | Stock | 7.24112987518311 | 7.46560001373291 | 7.22665023803711 | 7.46560001373291 | 56300.0 |
| 2002-11-05 | ACE-DELISTED | Stock | 31.87 | 32.1 | 30.9 | 31.26 | 857600.0 |
| 2002-11-05 | ACF-DELISTED | Stock | 8.57 | 8.95 | 8.01 | 8.15 | 1755600.0 |
| 2002-11-05 | ACG-DELISTED | Stock | 8.01 | 8.03 | 7.98 | 8.01 | 311400.0 |
| 2002-11-05 | ACGL | Stock | 3.1111 | 3.1111 | 2.9911 | 3.0744 | 1198800.0 |
| 2002-11-05 | ACGN-DELISTED | Stock | 1144.6712 | 1144.6712 | 1042.6712 | 1122.0 | 43200.0 |
| 2002-11-05 | ACH | Stock | 10.3 | 10.4267 | 9.5 | 10.0 | 445050.0 |
| 2002-11-05 | ACH-DELISTED | Stock | 3.0083 | 3.0158 | 3.0032 | 3.0032 | 46352.0 |
| 2002-11-05 | ACLS | Stock | 25.76 | 25.8 | 23.8 | 25.16 | 240650.0 |
| 2002-11-05 | ACO-DELISTED | Stock | 5.85 | 5.95 | 5.51 | 5.93 | 14600.0 |
| 2002-11-05 | ACPW-DELISTED | Stock | 9.775 | 10.074 | 9.376 | 9.725 | 8094.0 |
| 2002-11-05 | ACS-DELISTED | Stock | 48.1 | 48.76 | 47.55 | 48.7 | 1103600.0 |
| 2002-11-05 | ACTA-DELISTED | Stock | 7.4 | 7.6 | 7.0 | 7.4 | 61500.0 |
| 2002-11-05 | ACTT-DELISTED | Stock | 1.34 | 1.38 | 1.26 | 1.27 | 21400.0 |
| 2002-11-05 | ACTU-DELISTED | Stock | 2.61 | 2.61 | 2.1 | 2.24 | 560634.0 |
| 2002-11-05 | ACXM-DELISTED | Stock | 13.06 | 13.45 | 12.74 | 13.44 | 670776.0 |
> showing 50 of 3,211 rows — these rows as CSV