PREVIEW / stock_daily / 2002-07-29
file: by_date/stock_daily/2002/2002-07-29.parquet size: 107 KB rows: 3,168 symbols: 1,968
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-07-29 | AAPL | Stock | 0.2586 | 0.2696 | 0.2566 | 0.2682 | 274960000.0 |
| 2002-07-29 | MSFT | Stock | 23.425 | 24.15 | 23.275 | 24.125 | 112148600.0 |
| 2002-07-29 | NVDA | Stock | 0.1277 | 0.1283 | 0.1219 | 0.126 | 1227720000.0 |
| 2002-07-29 | AMZN | Stock | 0.6625 | 0.723 | 0.6615 | 0.7165 | 140990000.0 |
| 2002-07-29 | CL | Stock | 25.5 | 26.25 | 25.345 | 26.235 | 5283000.0 |
| 2002-07-29 | A | Stock | 12.5536 | 13.1044 | 12.5536 | 13.1044 | 3001786.0 |
| 2002-07-29 | AABA-DELISTED | Stock | 6.47499990463257 | 6.63500022888184 | 6.42000007629395 | 6.59499979019165 | 17167200.0 |
| 2002-07-29 | AAI-DELISTED | Stock | 3.9 | 4.0 | 3.9 | 4.0 | 296200.0 |
| 2002-07-29 | AAIC-DELISTED | Stock | 186.0 | 199.0 | 186.0 | 186.0 | 101700.0 |
| 2002-07-29 | AAME | Stock | 2.2 | 2.2 | 2.2 | 2.2 | 2200.0 |
| 2002-07-29 | AAON | Stock | 2.3677 | 2.3691 | 2.2519 | 2.3374 | 205791.0 |
| 2002-07-29 | AAP | Stock | 15.75 | 16.3667 | 15.6667 | 16.3 | 1254600.0 |
| 2002-07-29 | AAXN-DELISTED | Stock | 0.4375 | 0.454166680574417 | 0.404166668653488 | 0.405000001192093 | 924000.0 |
| 2002-07-29 | ABAX-DELISTED | Stock | 3.79 | 4.0 | 3.78 | 4.0 | 8950.0 |
| 2002-07-29 | ABB-DELISTED | Stock | 5.67 | 5.94 | 5.65 | 5.85 | 38300.0 |
| 2002-07-29 | ABC-DELISTED | Stock | 16.73 | 17.25 | 16.68 | 17.24 | 4062800.0 |
| 2002-07-29 | ABCB | Stock | 11.9149 | 12.158 | 11.7527 | 12.158 | 13078.0 |
| 2002-07-29 | ABCO-DELISTED | Stock | 14.795 | 16.896 | 14.795 | 16.66 | 169327.0 |
| 2002-07-29 | ABCW-DELISTED | Stock | 21.43 | 21.89 | 21.37 | 21.75 | 38180.0 |
| 2002-07-29 | ABE-DELISTED | Stock | 6.13 | 6.58 | 6.13 | 6.53 | 55000.0 |
| 2002-07-29 | ABFS-DELISTED | Stock | 20.83 | 22.01 | 20.83 | 21.71 | 133252.0 |
| 2002-07-29 | ABG | Stock | 11.25 | 12.9 | 11.25 | 12.06 | 136600.0 |
| 2002-07-29 | ABK-DELISTED | Stock | 59.75 | 62.45 | 59.49 | 62.27 | 994700.0 |
| 2002-07-29 | ABM | Stock | 16.25 | 17.0 | 16.17 | 16.95 | 119900.0 |
| 2002-07-29 | ABMD-DELISTED | Stock | 6.04 | 6.25 | 5.8 | 6.0 | 33000.0 |
| 2002-07-29 | ABP-DELISTED | Stock | 0.5 | 0.54 | 0.5 | 0.5 | 32500.0 |
| 2002-07-29 | ABT | Stock | 17.6642 | 17.9111 | 17.5116 | 17.7989 | 15359738.0 |
| 2002-07-29 | ABTL-DELISTED | Stock | 9.6 | 10.6 | 9.25 | 10.5 | 30200.0 |
| 2002-07-29 | ABV-DELISTED | Stock | 13.3 | 13.35 | 12.39 | 12.5 | 793800.0 |
| 2002-07-29 | ABX-DELISTED | Stock | 14.03 | 14.72 | 13.95 | 14.72 | 5763151.0 |
| 2002-07-29 | ACAP-DELISTED | Stock | 16.05 | 16.2 | 15.9 | 15.99 | 73098.0 |
| 2002-07-29 | ACAS-DELISTED | Stock | 24.5 | 25.71 | 24.3 | 25.58 | 538675.0 |
| 2002-07-29 | ACAT-DELISTED | Stock | 15.05 | 15.92 | 14.29 | 15.76 | 26360.0 |
| 2002-07-29 | ACCL-DELISTED | Stock | 5.38668012619019 | 5.46705007553101 | 5.28601980209351 | 5.46705007553101 | 190400.0 |
| 2002-07-29 | ACE-DELISTED | Stock | 27.18 | 29.06 | 27.18 | 29.04 | 2724029.0 |
| 2002-07-29 | ACF-DELISTED | Stock | 17.4 | 19.59 | 17.3 | 18.96 | 3699300.0 |
| 2002-07-29 | ACG-DELISTED | Stock | 7.99 | 7.99 | 7.95 | 7.96 | 667400.0 |
| 2002-07-29 | ACGL | Stock | 2.8778 | 3.1111 | 2.8444 | 3.0556 | 416700.0 |
| 2002-07-29 | ACGN-DELISTED | Stock | 940.6712 | 1008.6712 | 940.6712 | 1008.6712 | 2100.0 |
| 2002-07-29 | ACH | Stock | 10.0 | 10.26 | 9.5667 | 9.98 | 356700.0 |
| 2002-07-29 | ACH-DELISTED | Stock | 3.6212 | 3.6663 | 3.5836 | 3.6663 | 42695.0 |
| 2002-07-29 | ACLS | Stock | 30.44 | 34.28 | 30.0 | 34.28 | 191300.0 |
| 2002-07-29 | ACO-DELISTED | Stock | 5.3 | 5.4 | 5.1 | 5.15 | 19400.0 |
| 2002-07-29 | ACPW-DELISTED | Stock | 10.0 | 11.3 | 9.47 | 11.0 | 37140.0 |
| 2002-07-29 | ACS-DELISTED | Stock | 38.5 | 40.86 | 38.5 | 40.4 | 1566900.0 |
| 2002-07-29 | ACTA-DELISTED | Stock | 4.4 | 4.8 | 4.4 | 4.4 | 28100.0 |
| 2002-07-29 | ACTT-DELISTED | Stock | 2.25 | 2.34 | 2.201 | 2.25 | 21500.0 |
| 2002-07-29 | ACTU-DELISTED | Stock | 1.9 | 2.1 | 1.88 | 2.0 | 813200.0 |
| 2002-07-29 | ACXM-DELISTED | Stock | 15.25 | 15.438 | 14.63 | 15.02 | 504069.0 |
| 2002-07-29 | ACY-DELISTED | Stock | 4.05 | 4.05 | 3.96 | 3.96 | 400.0 |
> showing 50 of 3,168 rows — these rows as CSV