PREVIEW / stock_daily / 2002-07-18
file: by_date/stock_daily/2002/2002-07-18.parquet size: 105 KB rows: 3,106 symbols: 1,914
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-18 | AAPL | Stock | 0.2768 | 0.2779 | 0.2634 | 0.2677 | 559462400.0 |
| 2002-07-18 | MSFT | Stock | 26.03 | 26.37 | 25.33 | 25.555 | 91053600.0 |
| 2002-07-18 | NVDA | Stock | 0.1597 | 0.1692 | 0.1578 | 0.1582 | 1243188000.0 |
| 2002-07-18 | AMZN | Stock | 0.796 | 0.8295 | 0.7765 | 0.7775 | 137134000.0 |
| 2002-07-18 | CL | Stock | 23.625 | 24.025 | 23.01 | 23.09 | 4285000.0 |
| 2002-07-18 | A | Stock | 16.2375 | 16.5594 | 15.4793 | 15.5436 | 3083149.0 |
| 2002-07-18 | AABA-DELISTED | Stock | 7.03499984741211 | 7.125 | 6.7649998664856 | 6.78999996185303 | 21366600.0 |
| 2002-07-18 | AAI-DELISTED | Stock | 4.0 | 4.1 | 3.75 | 3.75 | 285700.0 |
| 2002-07-18 | AAIC-DELISTED | Stock | 216.4 | 216.4 | 195.0 | 195.0 | 60200.0 |
| 2002-07-18 | AAME | Stock | 2.19 | 2.28 | 2.12 | 2.2 | 2100.0 |
| 2002-07-18 | AAON | Stock | 2.157 | 2.186 | 2.0675 | 2.0675 | 207309.0 |
| 2002-07-18 | AAP | Stock | 15.6033 | 16.1667 | 15.4033 | 15.9333 | 2736000.0 |
| 2002-07-18 | AAXN-DELISTED | Stock | 0.758333325386047 | 0.758333325386047 | 0.658333361148834 | 0.691666662693024 | 735600.0 |
| 2002-07-18 | ABAX-DELISTED | Stock | 3.7 | 3.75 | 3.45 | 3.46 | 2600.0 |
| 2002-07-18 | ABB-DELISTED | Stock | 8.78 | 8.88 | 8.78 | 8.78 | 3600.0 |
| 2002-07-18 | ABC-DELISTED | Stock | 16.06 | 16.4 | 15.69 | 15.8 | 4054000.0 |
| 2002-07-18 | ABCB | Stock | 11.8338 | 11.9149 | 11.6636 | 11.6636 | 16286.0 |
| 2002-07-18 | ABCO-DELISTED | Stock | 14.77 | 15.06 | 14.335 | 14.36 | 62800.0 |
| 2002-07-18 | ABCW-DELISTED | Stock | 20.3 | 20.62 | 19.91 | 20.15 | 36700.0 |
| 2002-07-18 | ABE-DELISTED | Stock | 6.68 | 6.68 | 6.58 | 6.58 | 9800.0 |
| 2002-07-18 | ABFS-DELISTED | Stock | 21.76 | 22.76 | 20.89 | 21.51 | 102400.0 |
| 2002-07-18 | ABG | Stock | 12.4 | 12.6 | 12.0 | 12.0 | 36300.0 |
| 2002-07-18 | ABK-DELISTED | Stock | 57.05 | 57.5 | 54.25 | 54.97 | 1281000.0 |
| 2002-07-18 | ABM | Stock | 16.0 | 16.09 | 15.65 | 15.72 | 88000.0 |
| 2002-07-18 | ABMD-DELISTED | Stock | 6.29 | 6.4389 | 5.63 | 6.28 | 80200.0 |
| 2002-07-18 | ABP-DELISTED | Stock | 0.59 | 0.65 | 0.59 | 0.62 | 53400.0 |
| 2002-07-18 | ABT | Stock | 15.4197 | 15.4871 | 14.8317 | 14.8452 | 7999539.0 |
| 2002-07-18 | ABTL-DELISTED | Stock | 11.5 | 12.65 | 11.3 | 11.75 | 4500.0 |
| 2002-07-18 | ABV-DELISTED | Stock | 15.52 | 15.89 | 15.45 | 15.8 | 282700.0 |
| 2002-07-18 | ABX-DELISTED | Stock | 16.95 | 17.38 | 16.9 | 17.13 | 6020700.0 |
| 2002-07-18 | ACAP-DELISTED | Stock | 16.85 | 16.85 | 16.38 | 16.38 | 20700.0 |
| 2002-07-18 | ACAS-DELISTED | Stock | 26.22 | 26.68 | 26.12 | 26.25 | 505600.0 |
| 2002-07-18 | ACAT-DELISTED | Stock | 16.33 | 16.53 | 16.14 | 16.41 | 28200.0 |
| 2002-07-18 | ACCL-DELISTED | Stock | 5.64807987213135 | 5.86531019210815 | 5.4236102104187 | 5.86531019210815 | 129000.0 |
| 2002-07-18 | ACE-DELISTED | Stock | 27.77 | 27.78 | 25.25 | 25.41 | 5132800.0 |
| 2002-07-18 | ACF-DELISTED | Stock | 17.91 | 18.24 | 17.0 | 17.1 | 2273600.0 |
| 2002-07-18 | ACG-DELISTED | Stock | 8.05 | 8.05 | 7.99 | 8.01 | 387200.0 |
| 2002-07-18 | ACGL | Stock | 2.6667 | 2.7811 | 2.5833 | 2.6667 | 1131300.0 |
| 2002-07-18 | ACGN-DELISTED | Stock | 1156.0 | 1190.0 | 1076.6712 | 1178.6712 | 47600.0 |
| 2002-07-18 | ACH | Stock | 10.4667 | 10.9 | 9.3333 | 9.9333 | 473100.0 |
| 2002-07-18 | ACH-DELISTED | Stock | 4.3418 | 4.3642 | 4.3418 | 4.3642 | 5200.0 |
| 2002-07-18 | ACLS | Stock | 39.24 | 42.0 | 39.0 | 39.2 | 156275.0 |
| 2002-07-18 | ACO-DELISTED | Stock | 5.85 | 5.85 | 5.55 | 5.55 | 42300.0 |
| 2002-07-18 | ACPW-DELISTED | Stock | 11.55 | 11.55 | 10.5 | 10.85 | 18740.0 |
| 2002-07-18 | ACS-DELISTED | Stock | 45.3 | 45.45 | 41.4 | 41.95 | 2203900.0 |
| 2002-07-18 | ACTA-DELISTED | Stock | 5.8 | 6.2 | 5.0 | 5.2 | 28600.0 |
| 2002-07-18 | ACTT-DELISTED | Stock | 2.8 | 2.95 | 2.58 | 2.79 | 28600.0 |
| 2002-07-18 | ACTU-DELISTED | Stock | 3.41 | 3.41 | 2.08 | 2.11 | 1767900.0 |
| 2002-07-18 | ACXM-DELISTED | Stock | 15.94 | 15.94 | 13.68 | 13.77 | 1083100.0 |
| 2002-07-18 | ACY-DELISTED | Stock | 4.1 | 4.1 | 4.1 | 4.1 | 200.0 |
> showing 50 of 3,106 rows — these rows as CSV