PREVIEW / stock_daily / 2002-06-20
file: by_date/stock_daily/2002/2002-06-20.parquet size: 107 KB rows: 3,138 symbols: 1,952
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-06-20 | AAPL | Stock | 0.3066 | 0.3143 | 0.3009 | 0.3055 | 396636800.0 |
| 2002-06-20 | MSFT | Stock | 27.185 | 27.55 | 26.95 | 27.05 | 86401200.0 |
| 2002-06-20 | NVDA | Stock | 0.1992 | 0.2046 | 0.1943 | 0.1969 | 1425048000.0 |
| 2002-06-20 | AMZN | Stock | 0.916 | 0.919 | 0.867 | 0.8775 | 173940000.0 |
| 2002-06-20 | CL | Stock | 26.075 | 26.25 | 25.8 | 25.8 | 5341600.0 |
| 2002-06-20 | A | Stock | 17.3104 | 17.7039 | 17.0172 | 17.1674 | 3845199.0 |
| 2002-06-20 | AABA-DELISTED | Stock | 8.01500034332275 | 8.10999965667725 | 7.7350001335144 | 7.82499980926514 | 14256800.0 |
| 2002-06-20 | AAI-DELISTED | Stock | 5.6 | 5.72 | 5.57 | 5.7 | 169100.0 |
| 2002-06-20 | AAIC-DELISTED | Stock | 226.0 | 229.0 | 223.8 | 227.0 | 88500.0 |
| 2002-06-20 | AAME | Stock | 2.16 | 2.39 | 2.16 | 2.39 | 800.0 |
| 2002-06-20 | AAON | Stock | 2.6337 | 2.7141 | 2.585 | 2.6772 | 116944.0 |
| 2002-06-20 | AAP | Stock | 20.0833 | 20.45 | 19.7467 | 20.3867 | 1414800.0 |
| 2002-06-20 | AAXN-DELISTED | Stock | 1.24749994277954 | 1.24749994277954 | 1.15416669845581 | 1.1783332824707 | 283200.0 |
| 2002-06-20 | ABAX-DELISTED | Stock | 4.87 | 5.0 | 4.87 | 5.0 | 4000.0 |
| 2002-06-20 | ABB-DELISTED | Stock | 8.4 | 8.41 | 8.2 | 8.3 | 22000.0 |
| 2002-06-20 | ABC-DELISTED | Stock | 20.41 | 20.62 | 20.23 | 20.25 | 3562800.0 |
| 2002-06-20 | ABCB | Stock | 12.0364 | 12.0364 | 11.8743 | 11.9554 | 7773.0 |
| 2002-06-20 | ABCO-DELISTED | Stock | 19.13 | 19.41 | 18.5 | 18.5 | 135600.0 |
| 2002-06-20 | ABCW-DELISTED | Stock | 22.64 | 23.0 | 22.27 | 22.89 | 35300.0 |
| 2002-06-20 | ABE-DELISTED | Stock | 6.98 | 7.03 | 6.9 | 6.9 | 11100.0 |
| 2002-06-20 | ABFS-DELISTED | Stock | 25.0 | 25.1 | 24.29 | 24.39 | 175200.0 |
| 2002-06-20 | ABG | Stock | 15.65 | 15.65 | 14.4 | 14.5 | 75600.0 |
| 2002-06-20 | ABK-DELISTED | Stock | 68.49 | 69.93 | 68.41 | 69.68 | 742100.0 |
| 2002-06-20 | ABM | Stock | 16.05 | 17.2 | 16.05 | 16.75 | 205400.0 |
| 2002-06-20 | ABMD-DELISTED | Stock | 6.65 | 6.65 | 6.03 | 6.391 | 43900.0 |
| 2002-06-20 | ABP-DELISTED | Stock | 0.58 | 0.6 | 0.57 | 0.58 | 30600.0 |
| 2002-06-20 | ABT | Stock | 16.7216 | 17.148 | 16.6767 | 16.9101 | 11371330.0 |
| 2002-06-20 | ABTL-DELISTED | Stock | 13.7 | 13.9 | 13.0 | 13.8 | 16400.0 |
| 2002-06-20 | ABV-DELISTED | Stock | 15.6 | 15.6 | 14.26 | 14.6 | 508400.0 |
| 2002-06-20 | ABX-DELISTED | Stock | 19.89 | 20.51 | 19.82 | 20.46 | 3451380.0 |
| 2002-06-20 | ACAP-DELISTED | Stock | 17.57 | 17.8 | 16.88 | 17.0 | 54200.0 |
| 2002-06-20 | ACAS-DELISTED | Stock | 27.25 | 27.44 | 25.95 | 26.55 | 668100.0 |
| 2002-06-20 | ACAT-DELISTED | Stock | 17.76 | 18.4 | 17.51 | 17.56 | 116000.0 |
| 2002-06-20 | ACCL-DELISTED | Stock | 6.5170202255249 | 6.5170202255249 | 6.0463399887085 | 6.5170202255249 | 144300.0 |
| 2002-06-20 | ACE-DELISTED | Stock | 33.0 | 33.4 | 32.8 | 33.11 | 1024000.0 |
| 2002-06-20 | ACF-DELISTED | Stock | 27.5 | 28.0 | 25.28 | 25.73 | 2392300.0 |
| 2002-06-20 | ACG-DELISTED | Stock | 8.18 | 8.18 | 8.13 | 8.16 | 648100.0 |
| 2002-06-20 | ACGL | Stock | 3.2689 | 3.2767 | 3.2256 | 3.24 | 180900.0 |
| 2002-06-20 | ACGN-DELISTED | Stock | 1473.3288 | 1473.3288 | 1416.6712 | 1462.0 | 19200.0 |
| 2002-06-20 | ACH | Stock | 12.9667 | 13.1467 | 12.6933 | 12.9333 | 189000.0 |
| 2002-06-20 | ACH-DELISTED | Stock | 4.5125 | 4.5125 | 4.495 | 4.495 | 56000.0 |
| 2002-06-20 | ACLS | Stock | 44.0 | 44.6 | 41.76 | 42.52 | 157225.0 |
| 2002-06-20 | ACO-DELISTED | Stock | 5.81 | 5.99 | 5.8 | 5.9 | 17500.0 |
| 2002-06-20 | ACPW-DELISTED | Stock | 18.8 | 19.15 | 17.75 | 17.8 | 13540.0 |
| 2002-06-20 | ACS-DELISTED | Stock | 53.75 | 53.9 | 53.05 | 53.25 | 840000.0 |
| 2002-06-20 | ACTA-DELISTED | Stock | 7.0 | 7.4 | 6.6 | 6.8 | 26000.0 |
| 2002-06-20 | ACTT-DELISTED | Stock | 3.1 | 3.1 | 2.9 | 3.09 | 148600.0 |
| 2002-06-20 | ACTU-DELISTED | Stock | 5.34 | 5.5 | 5.11 | 5.15 | 252700.0 |
| 2002-06-20 | ACXM-DELISTED | Stock | 17.32 | 17.92 | 17.16 | 17.27 | 578500.0 |
| 2002-06-20 | AD | Stock | 18.4333 | 19.0 | 18.0467 | 19.0 | 388950.0 |
> showing 50 of 3,138 rows — these rows as CSV