PREVIEW / stock_daily / 2002-07-17
file: by_date/stock_daily/2002/2002-07-17.parquet size: 106 KB rows: 3,142 symbols: 1,944
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-17 | AAPL | Stock | 0.288 | 0.2893 | 0.2713 | 0.2791 | 1215485600.0 |
| 2002-07-17 | MSFT | Stock | 26.26 | 26.65 | 25.585 | 26.0 | 98034800.0 |
| 2002-07-17 | NVDA | Stock | 0.1737 | 0.1771 | 0.1555 | 0.1624 | 1922364000.0 |
| 2002-07-17 | AMZN | Stock | 0.842 | 0.858 | 0.766 | 0.808 | 146442000.0 |
| 2002-07-17 | CL | Stock | 24.25 | 24.3 | 23.43 | 23.575 | 5371400.0 |
| 2002-07-17 | A | Stock | 16.8383 | 17.2389 | 15.7582 | 16.2518 | 3594398.0 |
| 2002-07-17 | AABA-DELISTED | Stock | 7.11999988555908 | 7.40000009536743 | 6.96000003814697 | 7.13000011444092 | 31584000.0 |
| 2002-07-17 | AAI-DELISTED | Stock | 3.81 | 4.15 | 3.8 | 4.0 | 247500.0 |
| 2002-07-17 | AAIC-DELISTED | Stock | 215.4 | 215.8 | 208.0 | 215.8 | 59500.0 |
| 2002-07-17 | AAME | Stock | 2.0 | 2.2 | 1.95 | 2.15 | 15700.0 |
| 2002-07-17 | AAON | Stock | 2.1452 | 2.1584 | 2.0425 | 2.1426 | 217941.0 |
| 2002-07-17 | AAP | Stock | 15.4 | 15.91 | 14.75 | 15.6033 | 1981200.0 |
| 2002-07-17 | AAXN-DELISTED | Stock | 0.768333315849304 | 0.804166674613953 | 0.741666674613953 | 0.745833337306976 | 264000.0 |
| 2002-07-17 | ABAX-DELISTED | Stock | 3.9 | 3.9 | 3.71 | 3.75 | 17700.0 |
| 2002-07-17 | ABB-DELISTED | Stock | 8.68 | 8.8 | 8.65 | 8.8 | 8700.0 |
| 2002-07-17 | ABC-DELISTED | Stock | 16.0 | 16.25 | 15.8 | 16.15 | 4946800.0 |
| 2002-07-17 | ABCB | Stock | 11.5096 | 11.85 | 11.5096 | 11.85 | 11721.0 |
| 2002-07-17 | ABCO-DELISTED | Stock | 14.16 | 15.165 | 14.06 | 14.73 | 163600.0 |
| 2002-07-17 | ABCW-DELISTED | Stock | 20.55 | 21.0 | 20.15 | 20.7 | 85500.0 |
| 2002-07-17 | ABE-DELISTED | Stock | 6.63 | 6.71 | 6.59 | 6.63 | 7900.0 |
| 2002-07-17 | ABFS-DELISTED | Stock | 22.2 | 22.87 | 21.44 | 21.97 | 186100.0 |
| 2002-07-17 | ABG | Stock | 12.6 | 13.05 | 12.4 | 12.4 | 94900.0 |
| 2002-07-17 | ABK-DELISTED | Stock | 60.2 | 61.05 | 56.23 | 56.98 | 1752300.0 |
| 2002-07-17 | ABM | Stock | 15.54 | 16.25 | 15.23 | 16.1 | 187500.0 |
| 2002-07-17 | ABMD-DELISTED | Stock | 6.34 | 6.79 | 5.64 | 6.18 | 229300.0 |
| 2002-07-17 | ABP-DELISTED | Stock | 0.6 | 0.61 | 0.59 | 0.59 | 23200.0 |
| 2002-07-17 | ABT | Stock | 15.3749 | 15.7026 | 15.1863 | 15.532 | 11292916.0 |
| 2002-07-17 | ABTL-DELISTED | Stock | 12.2 | 12.5 | 11.3 | 12.35 | 5000.0 |
| 2002-07-17 | ABV-DELISTED | Stock | 15.45 | 15.66 | 15.32 | 15.42 | 311900.0 |
| 2002-07-17 | ABX-DELISTED | Stock | 17.6 | 17.6 | 16.75 | 16.81 | 5172900.0 |
| 2002-07-17 | ACAP-DELISTED | Stock | 17.0 | 17.0 | 16.55 | 16.68 | 59400.0 |
| 2002-07-17 | ACAS-DELISTED | Stock | 26.38 | 26.58 | 25.5 | 26.01 | 401600.0 |
| 2002-07-17 | ACAT-DELISTED | Stock | 16.0 | 16.81 | 16.0 | 16.81 | 29400.0 |
| 2002-07-17 | ACCL-DELISTED | Stock | 5.64807987213135 | 5.86531019210815 | 5.64807987213135 | 5.86531019210815 | 159100.0 |
| 2002-07-17 | ACE-DELISTED | Stock | 29.01 | 29.5 | 27.71 | 28.05 | 2542600.0 |
| 2002-07-17 | ACF-DELISTED | Stock | 19.0 | 20.0 | 16.5 | 17.92 | 5316600.0 |
| 2002-07-17 | ACG-DELISTED | Stock | 8.0 | 8.04 | 7.99 | 8.03 | 397500.0 |
| 2002-07-17 | ACGL | Stock | 2.7667 | 2.8611 | 2.64 | 2.6667 | 1857600.0 |
| 2002-07-17 | ACGN-DELISTED | Stock | 1201.3288 | 1224.0 | 1110.6712 | 1144.6712 | 62000.0 |
| 2002-07-17 | ACH | Stock | 11.7333 | 11.7333 | 10.5 | 10.6333 | 901200.0 |
| 2002-07-17 | ACH-DELISTED | Stock | 4.3725 | 4.375 | 4.355 | 4.355 | 6400.0 |
| 2002-07-17 | ACLS | Stock | 42.4 | 44.6 | 40.0 | 40.08 | 184325.0 |
| 2002-07-17 | ACO-DELISTED | Stock | 6.0 | 6.06 | 5.77 | 5.85 | 41000.0 |
| 2002-07-17 | ACPW-DELISTED | Stock | 11.323 | 11.677 | 10.929 | 11.577 | 46622.0 |
| 2002-07-17 | ACS-DELISTED | Stock | 45.75 | 46.89 | 45.2 | 46.35 | 1829000.0 |
| 2002-07-17 | ACTA-DELISTED | Stock | 5.4 | 6.2 | 5.2 | 6.0 | 76800.0 |
| 2002-07-17 | ACTT-DELISTED | Stock | 3.15 | 3.16 | 2.7 | 2.76 | 44400.0 |
| 2002-07-17 | ACTU-DELISTED | Stock | 3.6 | 3.95 | 3.4 | 3.5 | 679500.0 |
| 2002-07-17 | ACXM-DELISTED | Stock | 15.69 | 16.649 | 15.44 | 15.89 | 743800.0 |
| 2002-07-17 | ACY-DELISTED | Stock | 4.26 | 4.35 | 4.2 | 4.2 | 8900.0 |
> showing 50 of 3,142 rows — these rows as CSV