PREVIEW / stock_daily / 2002-06-18
file: by_date/stock_daily/2002/2002-06-18.parquet size: 106 KB rows: 3,112 symbols: 1,925
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-18 | AAPL | Stock | 0.3646 | 0.3677 | 0.3568 | 0.3598 | 353360000.0 |
| 2002-06-18 | MSFT | Stock | 27.765 | 28.145 | 27.675 | 27.995 | 77518400.0 |
| 2002-06-18 | NVDA | Stock | 0.234 | 0.2425 | 0.2312 | 0.2357 | 1008300000.0 |
| 2002-06-18 | AMZN | Stock | 0.9065 | 0.958 | 0.9045 | 0.939 | 159242000.0 |
| 2002-06-18 | CL | Stock | 26.85 | 26.875 | 26.365 | 26.47 | 3797800.0 |
| 2002-06-18 | A | Stock | 18.0973 | 18.5765 | 17.7253 | 18.0758 | 3367223.0 |
| 2002-06-18 | AABA-DELISTED | Stock | 8.26000022888184 | 8.52499961853027 | 8.22500038146973 | 8.32499980926514 | 11408600.0 |
| 2002-06-18 | AAI-DELISTED | Stock | 5.76 | 5.77 | 5.7 | 5.75 | 99300.0 |
| 2002-06-18 | AAIC-DELISTED | Stock | 220.0 | 224.8 | 220.0 | 222.6 | 126600.0 |
| 2002-06-18 | AAON | Stock | 2.6298 | 2.693 | 2.5455 | 2.6416 | 419175.0 |
| 2002-06-18 | AAP | Stock | 19.5533 | 19.8833 | 19.5333 | 19.8 | 679800.0 |
| 2002-06-18 | AAXN-DELISTED | Stock | 1.19416666030884 | 1.27416670322418 | 1.19416666030884 | 1.25833332538605 | 325200.0 |
| 2002-06-18 | ABAX-DELISTED | Stock | 4.65 | 4.68 | 4.5911 | 4.5911 | 5800.0 |
| 2002-06-18 | ABB-DELISTED | Stock | 8.51 | 8.65 | 8.51 | 8.65 | 15400.0 |
| 2002-06-18 | ABC-DELISTED | Stock | 20.29 | 20.5 | 20.17 | 20.36 | 4681200.0 |
| 2002-06-18 | ABCB | Stock | 11.8338 | 11.9554 | 11.7527 | 11.7527 | 21962.0 |
| 2002-06-18 | ABCO-DELISTED | Stock | 20.69 | 20.94 | 19.655 | 19.715 | 133400.0 |
| 2002-06-18 | ABCW-DELISTED | Stock | 22.41 | 22.79 | 22.41 | 22.54 | 24300.0 |
| 2002-06-18 | ABE-DELISTED | Stock | 7.06 | 7.1 | 7.0 | 7.06 | 11400.0 |
| 2002-06-18 | ABFS-DELISTED | Stock | 23.941 | 24.34 | 23.75 | 23.84 | 54100.0 |
| 2002-06-18 | ABG | Stock | 14.7 | 15.45 | 14.7 | 15.25 | 196900.0 |
| 2002-06-18 | ABK-DELISTED | Stock | 68.7 | 68.9 | 68.13 | 68.77 | 430600.0 |
| 2002-06-18 | ABM | Stock | 16.82 | 17.45 | 16.79 | 17.22 | 112200.0 |
| 2002-06-18 | ABMD-DELISTED | Stock | 6.2 | 7.15 | 6.05 | 6.2 | 87900.0 |
| 2002-06-18 | ABP-DELISTED | Stock | 0.6 | 0.63 | 0.6 | 0.63 | 21700.0 |
| 2002-06-18 | ABT | Stock | 16.9415 | 17.6418 | 16.8921 | 17.3949 | 15029599.0 |
| 2002-06-18 | ABTL-DELISTED | Stock | 14.75 | 14.75 | 13.9 | 14.4 | 13800.0 |
| 2002-06-18 | ABV-DELISTED | Stock | 16.71 | 16.8 | 16.3 | 16.35 | 216200.0 |
| 2002-06-18 | ABX-DELISTED | Stock | 19.95 | 20.07 | 19.33 | 20.02 | 3024300.0 |
| 2002-06-18 | ACAP-DELISTED | Stock | 17.35 | 17.9 | 17.35 | 17.8 | 83000.0 |
| 2002-06-18 | ACAS-DELISTED | Stock | 27.12 | 27.76 | 27.05 | 27.2 | 852400.0 |
| 2002-06-18 | ACAT-DELISTED | Stock | 18.05 | 18.33 | 17.75 | 17.88 | 39700.0 |
| 2002-06-18 | ACCL-DELISTED | Stock | 6.92975997924805 | 7.06661987304688 | 6.59667015075684 | 7.06661987304688 | 45300.0 |
| 2002-06-18 | ACE-DELISTED | Stock | 33.57 | 34.0 | 33.35 | 33.88 | 1498100.0 |
| 2002-06-18 | ACF-DELISTED | Stock | 29.19 | 29.2 | 28.3 | 28.5 | 1296000.0 |
| 2002-06-18 | ACG-DELISTED | Stock | 8.13 | 8.15 | 8.1 | 8.12 | 563100.0 |
| 2002-06-18 | ACGL | Stock | 3.3256 | 3.3722 | 3.2833 | 3.2889 | 414000.0 |
| 2002-06-18 | ACGN-DELISTED | Stock | 1586.6712 | 1586.6712 | 1314.6712 | 1360.0 | 129100.0 |
| 2002-06-18 | ACH | Stock | 12.6 | 12.82 | 12.4667 | 12.7 | 67650.0 |
| 2002-06-18 | ACH-DELISTED | Stock | 4.42 | 4.475 | 4.42 | 4.45 | 28000.0 |
| 2002-06-18 | ACLS | Stock | 47.16 | 48.64 | 45.92 | 45.92 | 288725.0 |
| 2002-06-18 | ACO-DELISTED | Stock | 5.98 | 6.0 | 5.76 | 5.79 | 9700.0 |
| 2002-06-18 | ACPW-DELISTED | Stock | 20.45 | 20.75 | 19.4 | 19.9 | 19080.0 |
| 2002-06-18 | ACS-DELISTED | Stock | 53.46 | 54.2 | 53.2 | 53.82 | 1058100.0 |
| 2002-06-18 | ACTA-DELISTED | Stock | 7.0 | 7.6 | 6.6 | 6.8 | 37400.0 |
| 2002-06-18 | ACTT-DELISTED | Stock | 2.9 | 3.03 | 2.9 | 3.03 | 21100.0 |
| 2002-06-18 | ACTU-DELISTED | Stock | 5.93 | 6.04 | 5.55 | 5.73 | 128800.0 |
| 2002-06-18 | ACXM-DELISTED | Stock | 17.49 | 17.86 | 17.22 | 17.3 | 868600.0 |
| 2002-06-18 | ACY-DELISTED | Stock | 4.2 | 4.3 | 4.1 | 4.11 | 2500.0 |
| 2002-06-18 | AD | Stock | 18.3867 | 18.6733 | 18.2867 | 18.54 | 175500.0 |
> showing 50 of 3,112 rows — these rows as CSV