PREVIEW / stock_daily / 2002-01-14
file: by_date/stock_daily/2002/2002-01-14.parquet size: 106 KB rows: 3,083 symbols: 1,924
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-01-14 | AAPL | Stock | 0.3752 | 0.3821 | 0.3732 | 0.3777 | 415996000.0 |
| 2002-01-14 | MSFT | Stock | 34.15 | 34.52 | 33.87 | 34.235 | 50997800.0 |
| 2002-01-14 | NVDA | Stock | 0.5244 | 0.5281 | 0.498 | 0.498 | 1369560000.0 |
| 2002-01-14 | AMZN | Stock | 0.54 | 0.5415 | 0.5045 | 0.5055 | 119466000.0 |
| 2002-01-14 | CL | Stock | 27.45 | 28.25 | 27.45 | 27.92 | 2359200.0 |
| 2002-01-14 | A | Stock | 21.8169 | 21.9027 | 21.5093 | 21.7597 | 3117260.0 |
| 2002-01-14 | AABA-DELISTED | Stock | 9.85499954223633 | 9.96000003814697 | 9.4350004196167 | 9.50500011444092 | 21948400.0 |
| 2002-01-14 | AAI-DELISTED | Stock | 7.07 | 7.18 | 6.65 | 6.69 | 397700.0 |
| 2002-01-14 | AAIC-DELISTED | Stock | 116.4 | 116.4 | 114.0 | 114.0 | 31300.0 |
| 2002-01-14 | AAME | Stock | 2.34 | 2.34 | 2.34 | 2.34 | 6900.0 |
| 2002-01-14 | AAON | Stock | 1.8261 | 1.8261 | 1.7295 | 1.7383 | 190223.0 |
| 2002-01-14 | AAP | Stock | 14.5 | 14.5667 | 14.3 | 14.3 | 230700.0 |
| 2002-01-14 | AAXN-DELISTED | Stock | 1.43333327770233 | 1.48083329200745 | 1.33416664600372 | 1.36333334445953 | 4683600.0 |
| 2002-01-14 | ABAX-DELISTED | Stock | 5.9 | 5.9 | 5.64 | 5.7 | 40900.0 |
| 2002-01-14 | ABB-DELISTED | Stock | 10.85 | 10.88 | 10.5 | 10.5 | 13000.0 |
| 2002-01-14 | ABC-DELISTED | Stock | 14.8 | 15.08 | 14.75 | 14.98 | 3755600.0 |
| 2002-01-14 | ABCB | Stock | 10.9422 | 11.3475 | 10.9422 | 11.3475 | 2590.0 |
| 2002-01-14 | ABCO-DELISTED | Stock | 14.645 | 14.675 | 14.465 | 14.5 | 26200.0 |
| 2002-01-14 | ABCW-DELISTED | Stock | 17.85 | 17.85 | 17.07 | 17.08 | 17900.0 |
| 2002-01-14 | ABE-DELISTED | Stock | 7.04 | 7.15 | 7.02 | 7.12 | 24800.0 |
| 2002-01-14 | ABFS-DELISTED | Stock | 27.65 | 27.96 | 26.94 | 27.37 | 202700.0 |
| 2002-01-14 | ABK-DELISTED | Stock | 58.0 | 58.3 | 57.47 | 57.63 | 330300.0 |
| 2002-01-14 | ABM | Stock | 15.05 | 15.055 | 14.875 | 14.885 | 75800.0 |
| 2002-01-14 | ABMD-DELISTED | Stock | 15.78 | 16.1 | 13.5 | 13.71 | 346100.0 |
| 2002-01-14 | ABP-DELISTED | Stock | 1.35 | 1.35 | 1.25 | 1.3 | 70100.0 |
| 2002-01-14 | ABT | Stock | 25.1384 | 25.3629 | 25.0846 | 25.0891 | 7162606.0 |
| 2002-01-14 | ABTL-DELISTED | Stock | 13.8 | 14.0 | 12.75 | 13.5 | 37500.0 |
| 2002-01-14 | ABV-DELISTED | Stock | 20.2 | 20.42 | 19.9 | 19.94 | 324900.0 |
| 2002-01-14 | ABX-DELISTED | Stock | 17.05 | 17.25 | 17.01 | 17.24 | 2293551.0 |
| 2002-01-14 | ACAP-DELISTED | Stock | 20.73 | 20.73 | 19.6 | 19.98 | 168200.0 |
| 2002-01-14 | ACAS-DELISTED | Stock | 28.1 | 28.1 | 27.3 | 27.46 | 222900.0 |
| 2002-01-14 | ACAT-DELISTED | Stock | 16.48 | 16.48 | 16.02 | 16.08 | 23400.0 |
| 2002-01-14 | ACCL-DELISTED | Stock | 10.0290002822876 | 10.1302995681763 | 10.0072002410889 | 10.1302995681763 | 132600.0 |
| 2002-01-14 | ACE-DELISTED | Stock | 37.9 | 37.9 | 36.34 | 36.34 | 2277200.0 |
| 2002-01-14 | ACF-DELISTED | Stock | 24.75 | 24.8 | 22.51 | 22.79 | 5465400.0 |
| 2002-01-14 | ACG-DELISTED | Stock | 7.67 | 7.7 | 7.67 | 7.69 | 906500.0 |
| 2002-01-14 | ACGL | Stock | 3.0 | 3.0833 | 2.9833 | 3.0833 | 420300.0 |
| 2002-01-14 | ACGN-DELISTED | Stock | 1870.0 | 2040.0 | 1813.3288 | 1983.3288 | 33200.0 |
| 2002-01-14 | ACH | Stock | 12.3733 | 12.7733 | 12.3733 | 12.7733 | 158400.0 |
| 2002-01-14 | ACH-DELISTED | Stock | 4.763 | 4.763 | 4.7005 | 4.713 | 665934.0 |
| 2002-01-14 | ACLS | Stock | 57.64 | 59.52 | 56.64 | 59.16 | 178175.0 |
| 2002-01-14 | ACO-DELISTED | Stock | 7.25 | 7.35 | 7.25 | 7.28 | 49600.0 |
| 2002-01-14 | ACPW-DELISTED | Stock | 34.5 | 34.5 | 31.4 | 33.75 | 67040.0 |
| 2002-01-14 | ACS-DELISTED | Stock | 53.455 | 53.74 | 52.94 | 53.22 | 334800.0 |
| 2002-01-14 | ACTA-DELISTED | Stock | 24.8 | 27.6 | 23.4 | 27.2 | 169600.0 |
| 2002-01-14 | ACTT-DELISTED | Stock | 7.73 | 7.75 | 7.39 | 7.53 | 60700.0 |
| 2002-01-14 | ACTU-DELISTED | Stock | 5.9 | 5.92 | 5.41 | 5.73 | 907700.0 |
| 2002-01-14 | ACXM-DELISTED | Stock | 18.51 | 18.55 | 17.76 | 18.25 | 414200.0 |
| 2002-01-14 | ACY-DELISTED | Stock | 4.97 | 4.97 | 4.97 | 4.97 | 500.0 |
| 2002-01-14 | AD | Stock | 26.9733 | 26.9733 | 26.6667 | 26.7 | 303000.0 |
> showing 50 of 3,083 rows — these rows as CSV