PREVIEW / stock_daily / 2002-07-15
file: by_date/stock_daily/2002/2002-07-15.parquet size: 107 KB rows: 3,168 symbols: 1,967
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-15 | AAPL | Stock | 0.3113 | 0.3321 | 0.3002 | 0.3255 | 295993600.0 |
| 2002-07-15 | MSFT | Stock | 25.695 | 25.93 | 24.0 | 25.9 | 136965600.0 |
| 2002-07-15 | NVDA | Stock | 0.1663 | 0.1825 | 0.1588 | 0.1824 | 1495272000.0 |
| 2002-07-15 | AMZN | Stock | 0.7735 | 0.799 | 0.75 | 0.797 | 120522000.0 |
| 2002-07-15 | CL | Stock | 24.5 | 24.55 | 22.985 | 24.375 | 5612600.0 |
| 2002-07-15 | A | Stock | 16.824 | 17.0601 | 15.98 | 16.8598 | 2868277.0 |
| 2002-07-15 | AABA-DELISTED | Stock | 6.40500020980835 | 6.83500003814697 | 6.17999982833862 | 6.53000020980835 | 39270800.0 |
| 2002-07-15 | AAI-DELISTED | Stock | 4.0 | 4.0 | 3.51 | 3.79 | 687300.0 |
| 2002-07-15 | AAIC-DELISTED | Stock | 220.6 | 220.6 | 210.0 | 212.0 | 78200.0 |
| 2002-07-15 | AAME | Stock | 2.11 | 2.22 | 2.05 | 2.2 | 2000.0 |
| 2002-07-15 | AAON | Stock | 2.2519 | 2.3045 | 2.1755 | 2.2756 | 316659.0 |
| 2002-07-15 | AAP | Stock | 16.1033 | 16.1067 | 14.2333 | 15.4 | 2634600.0 |
| 2002-07-15 | AAXN-DELISTED | Stock | 0.875 | 0.908333361148834 | 0.816666662693024 | 0.833333313465118 | 558000.0 |
| 2002-07-15 | ABAX-DELISTED | Stock | 4.03 | 4.03 | 3.89 | 4.0187 | 13100.0 |
| 2002-07-15 | ABB-DELISTED | Stock | 8.83 | 8.83 | 8.7 | 8.8 | 15100.0 |
| 2002-07-15 | ABC-DELISTED | Stock | 15.3 | 15.3 | 14.31 | 15.02 | 8200512.0 |
| 2002-07-15 | ABCB | Stock | 11.6393 | 11.9392 | 11.4771 | 11.8825 | 36149.0 |
| 2002-07-15 | ABCO-DELISTED | Stock | 16.435 | 16.435 | 13.755 | 14.25 | 264800.0 |
| 2002-07-15 | ABCW-DELISTED | Stock | 21.65 | 21.67 | 20.45 | 20.65 | 85400.0 |
| 2002-07-15 | ABE-DELISTED | Stock | 6.63 | 6.7 | 6.5 | 6.55 | 57500.0 |
| 2002-07-15 | ABFS-DELISTED | Stock | 22.8 | 22.8 | 21.12 | 22.11 | 297700.0 |
| 2002-07-15 | ABG | Stock | 13.34 | 13.36 | 12.45 | 12.85 | 85500.0 |
| 2002-07-15 | ABK-DELISTED | Stock | 62.81 | 62.81 | 59.5 | 62.56 | 820500.0 |
| 2002-07-15 | ABM | Stock | 16.01 | 16.51 | 15.75 | 16.5 | 119800.0 |
| 2002-07-15 | ABMD-DELISTED | Stock | 6.61 | 6.61 | 6.05 | 6.38 | 52300.0 |
| 2002-07-15 | ABP-DELISTED | Stock | 0.67 | 0.67 | 0.59 | 0.59 | 52400.0 |
| 2002-07-15 | ABT | Stock | 15.2177 | 15.7834 | 14.3648 | 15.4871 | 15779653.0 |
| 2002-07-15 | ABTL-DELISTED | Stock | 10.8 | 10.8 | 9.05 | 9.5 | 13300.0 |
| 2002-07-15 | ABV-DELISTED | Stock | 16.0 | 16.0 | 15.3 | 15.53 | 274000.0 |
| 2002-07-15 | ABVA-DELISTED | Stock | 8.0 | 8.1 | 8.0 | 8.1 | 4000.0 |
| 2002-07-15 | ABX-DELISTED | Stock | 18.664 | 18.674 | 17.477 | 17.496 | 6211304.0 |
| 2002-07-15 | ACAP-DELISTED | Stock | 16.68 | 17.37 | 16.61 | 17.37 | 20700.0 |
| 2002-07-15 | ACAS-DELISTED | Stock | 26.21 | 26.58 | 25.67 | 26.54 | 520000.0 |
| 2002-07-15 | ACAT-DELISTED | Stock | 16.0 | 16.75 | 15.98 | 16.6 | 59900.0 |
| 2002-07-15 | ACCL-DELISTED | Stock | 5.4380898475647 | 5.86531019210815 | 5.4380898475647 | 5.86531019210815 | 169400.0 |
| 2002-07-15 | ACE-DELISTED | Stock | 29.15 | 29.32 | 27.43 | 29.21 | 1839700.0 |
| 2002-07-15 | ACF-DELISTED | Stock | 20.27 | 21.39 | 19.21 | 21.02 | 1737400.0 |
| 2002-07-15 | ACG-DELISTED | Stock | 7.93 | 8.0 | 7.9 | 7.96 | 512100.0 |
| 2002-07-15 | ACGL | Stock | 2.8 | 2.8 | 2.6467 | 2.73 | 782100.0 |
| 2002-07-15 | ACGN-DELISTED | Stock | 1190.0 | 1201.3288 | 1167.3288 | 1178.6712 | 22400.0 |
| 2002-07-15 | ACH | Stock | 12.0 | 12.2 | 11.8 | 11.8 | 142800.0 |
| 2002-07-15 | ACH-DELISTED | Stock | 4.4912 | 4.4962 | 4.4338 | 4.4538 | 26019.0 |
| 2002-07-15 | ACLS | Stock | 42.32 | 43.44 | 40.76 | 43.2 | 210150.0 |
| 2002-07-15 | ACO-DELISTED | Stock | 6.16 | 6.2 | 6.0 | 6.17 | 8600.0 |
| 2002-07-15 | ACPW-DELISTED | Stock | 12.772 | 12.925 | 11.137 | 11.75 | 58322.0 |
| 2002-07-15 | ACS-DELISTED | Stock | 44.7 | 44.9 | 42.42 | 44.02 | 921900.0 |
| 2002-07-15 | ACTA-DELISTED | Stock | 4.6 | 5.0 | 4.4 | 4.6 | 22100.0 |
| 2002-07-15 | ACTT-DELISTED | Stock | 3.04 | 3.051 | 2.57 | 3.0 | 87400.0 |
| 2002-07-15 | ACTU-DELISTED | Stock | 3.12 | 3.28 | 2.98 | 3.19 | 342200.0 |
| 2002-07-15 | ACXM-DELISTED | Stock | 15.68 | 15.87 | 14.06 | 15.01 | 1083700.0 |
> showing 50 of 3,168 rows — these rows as CSV