PREVIEW / stock_daily / 2002-10-28
file: by_date/stock_daily/2002/2002-10-28.parquet size: 108 KB rows: 3,207 symbols: 1,984
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-28 | AAPL | Stock | 0.2777 | 0.2848 | 0.2723 | 0.2788 | 349300000.0 |
| 2002-10-28 | MSFT | Stock | 26.7 | 26.75 | 25.755 | 25.975 | 79906600.0 |
| 2002-10-28 | NVDA | Stock | 0.0967 | 0.0975 | 0.0924 | 0.093 | 1070544000.0 |
| 2002-10-28 | AMZN | Stock | 0.964 | 0.9865 | 0.92 | 0.9295 | 175996000.0 |
| 2002-10-28 | CL | Stock | 27.85 | 27.85 | 27.155 | 27.385 | 4234000.0 |
| 2002-10-28 | A | Stock | 9.4063 | 9.9714 | 9.4063 | 9.671 | 2695064.0 |
| 2002-10-28 | AABA-DELISTED | Stock | 7.67500019073486 | 7.67500019073486 | 7.2649998664856 | 7.32999992370605 | 20800000.0 |
| 2002-10-28 | AAI-DELISTED | Stock | 3.96 | 4.03 | 3.8 | 3.8 | 180600.0 |
| 2002-10-28 | AAIC-DELISTED | Stock | 198.0 | 198.0 | 189.0 | 194.0 | 112900.0 |
| 2002-10-28 | AAME | Stock | 1.71 | 1.89 | 1.7 | 1.89 | 2500.0 |
| 2002-10-28 | AAON | Stock | 2.4362 | 2.5666 | 2.4362 | 2.456 | 82772.0 |
| 2002-10-28 | AAP | Stock | 18.1 | 18.1333 | 17.6333 | 17.8967 | 1545000.0 |
| 2002-10-28 | AAXN-DELISTED | Stock | 0.297500014305115 | 0.298333346843719 | 0.283333331346512 | 0.284999996423721 | 398400.0 |
| 2002-10-28 | ABAX-DELISTED | Stock | 4.039 | 4.14 | 4.039 | 4.14 | 12500.0 |
| 2002-10-28 | ABB-DELISTED | Stock | 1.22 | 1.22 | 1.1 | 1.14 | 480000.0 |
| 2002-10-28 | ABC-DELISTED | Stock | 18.69 | 18.8 | 17.89 | 17.89 | 3512800.0 |
| 2002-10-28 | ABCB | Stock | 10.4154 | 10.6585 | 10.3262 | 10.6585 | 39850.0 |
| 2002-10-28 | ABCO-DELISTED | Stock | 15.945 | 16.266 | 15.609 | 15.745 | 80925.0 |
| 2002-10-28 | ABCW-DELISTED | Stock | 20.98 | 21.59 | 20.65 | 20.84 | 18000.0 |
| 2002-10-28 | ABE-DELISTED | Stock | 5.84 | 5.95 | 5.76 | 5.94 | 22700.0 |
| 2002-10-28 | ABFS-DELISTED | Stock | 30.94 | 30.98 | 30.15 | 30.48 | 95600.0 |
| 2002-10-28 | ABG | Stock | 8.2 | 8.2 | 7.11 | 7.3 | 142700.0 |
| 2002-10-28 | ABK-DELISTED | Stock | 65.1 | 65.45 | 62.54 | 62.81 | 671200.0 |
| 2002-10-28 | ABM | Stock | 14.25 | 14.48 | 14.05 | 14.38 | 114700.0 |
| 2002-10-28 | ABMD-DELISTED | Stock | 4.03 | 4.199 | 3.76 | 3.76 | 18400.0 |
| 2002-10-28 | ABP-DELISTED | Stock | 0.68 | 0.7 | 0.68 | 0.7 | 7300.0 |
| 2002-10-28 | ABT | Stock | 19.6394 | 19.6394 | 18.984 | 19.1142 | 6694796.0 |
| 2002-10-28 | ABTL-DELISTED | Stock | 11.8 | 12.5 | 11.7 | 11.9 | 43500.0 |
| 2002-10-28 | ABV-DELISTED | Stock | 13.69 | 13.69 | 13.04 | 13.24 | 272800.0 |
| 2002-10-28 | ABX-DELISTED | Stock | 15.35 | 15.68 | 15.25 | 15.51 | 2408600.0 |
| 2002-10-28 | ACAP-DELISTED | Stock | 15.49 | 15.49 | 15.05 | 15.18 | 23900.0 |
| 2002-10-28 | ACAS-DELISTED | Stock | 20.19 | 20.44 | 19.99 | 20.14 | 412922.0 |
| 2002-10-28 | ACAT-DELISTED | Stock | 14.7 | 14.7 | 14.08 | 14.08 | 18400.0 |
| 2002-10-28 | ACCL-DELISTED | Stock | 6.8600001335144 | 6.89400005340576 | 6.67600011825562 | 6.76300001144409 | 54300.0 |
| 2002-10-28 | ACE-DELISTED | Stock | 34.5 | 35.5 | 33.74 | 33.95 | 1236200.0 |
| 2002-10-28 | ACF-DELISTED | Stock | 8.0 | 8.19 | 7.55 | 7.56 | 3316200.0 |
| 2002-10-28 | ACG-DELISTED | Stock | 8.02 | 8.06 | 7.99 | 8.02 | 437800.0 |
| 2002-10-28 | ACGL | Stock | 3.0889 | 3.1544 | 3.0678 | 3.1122 | 875700.0 |
| 2002-10-28 | ACGN-DELISTED | Stock | 1054.0 | 1178.6712 | 1054.0 | 1156.0 | 88800.0 |
| 2002-10-28 | ACH | Stock | 10.1 | 10.1 | 9.7 | 9.8667 | 308850.0 |
| 2002-10-28 | ACH-DELISTED | Stock | 2.9625 | 2.9625 | 2.9 | 2.9 | 18800.0 |
| 2002-10-28 | ACLS | Stock | 20.32 | 21.28 | 20.0 | 20.0 | 161075.0 |
| 2002-10-28 | ACO-DELISTED | Stock | 5.14 | 5.2 | 5.12 | 5.15 | 42200.0 |
| 2002-10-28 | ACPW-DELISTED | Stock | 11.45 | 11.5 | 9.95 | 9.95 | 20860.0 |
| 2002-10-28 | ACS-DELISTED | Stock | 49.5 | 49.8 | 46.11 | 46.35 | 1739800.0 |
| 2002-10-28 | ACTA-DELISTED | Stock | 5.2 | 5.6 | 5.2 | 5.2 | 30900.0 |
| 2002-10-28 | ACTT-DELISTED | Stock | 1.24 | 1.48 | 1.239 | 1.29 | 118000.0 |
| 2002-10-28 | ACTU-DELISTED | Stock | 1.73 | 1.93 | 1.63 | 1.82 | 816516.0 |
| 2002-10-28 | ACXM-DELISTED | Stock | 14.2 | 14.28 | 13.09 | 13.54 | 1183479.0 |
| 2002-10-28 | AD | Stock | 19.0333 | 19.3 | 18.8333 | 18.9667 | 291300.0 |
> showing 50 of 3,207 rows — these rows as CSV