PREVIEW / stock_daily / 2002-06-28
file: by_date/stock_daily/2002/2002-06-28.parquet size: 109 KB rows: 3,161 symbols: 1,961
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-28 | AAPL | Stock | 0.3054 | 0.3182 | 0.3036 | 0.3164 | 269858400.0 |
| 2002-06-28 | MSFT | Stock | 27.275 | 27.895 | 27.0 | 27.35 | 89555600.0 |
| 2002-06-28 | NVDA | Stock | 0.14 | 0.1491 | 0.1369 | 0.1432 | 1991184000.0 |
| 2002-06-28 | AMZN | Stock | 0.7845 | 0.818 | 0.77 | 0.8125 | 124758000.0 |
| 2002-06-28 | CL | Stock | 25.65 | 25.875 | 25.01 | 25.025 | 6462200.0 |
| 2002-06-28 | A | Stock | 17.1531 | 17.4893 | 16.8455 | 16.917 | 3194290.0 |
| 2002-06-28 | AABA-DELISTED | Stock | 7.05000019073486 | 7.43499994277954 | 6.96000003814697 | 7.38000011444092 | 13724200.0 |
| 2002-06-28 | AAI-DELISTED | Stock | 5.2 | 5.69 | 5.2 | 5.45 | 528000.0 |
| 2002-06-28 | AAIC-DELISTED | Stock | 244.0 | 257.6 | 244.0 | 254.6 | 438500.0 |
| 2002-06-28 | AAME | Stock | 2.14 | 2.35 | 2.0 | 2.35 | 11000.0 |
| 2002-06-28 | AAON | Stock | 2.5534 | 2.5745 | 2.3374 | 2.4718 | 4178841.0 |
| 2002-06-28 | AAP | Stock | 18.2833 | 18.5667 | 17.7 | 18.17 | 2560500.0 |
| 2002-06-28 | AAXN-DELISTED | Stock | 0.995833337306976 | 1.05583333969116 | 0.991666674613953 | 1.0 | 294000.0 |
| 2002-06-28 | ABAX-DELISTED | Stock | 4.51 | 4.55 | 4.36 | 4.36 | 17700.0 |
| 2002-06-28 | ABB-DELISTED | Stock | 8.71 | 9.0 | 8.71 | 9.0 | 9700.0 |
| 2002-06-28 | ABC-DELISTED | Stock | 19.51 | 19.57 | 18.92 | 19.03 | 3562400.0 |
| 2002-06-28 | ABCB | Stock | 11.9554 | 12.158 | 10.618 | 12.0689 | 638467.0 |
| 2002-06-28 | ABCO-DELISTED | Stock | 19.22 | 19.3 | 17.85 | 18.12 | 953600.0 |
| 2002-06-28 | ABCW-DELISTED | Stock | 22.38 | 24.11 | 22.37 | 24.11 | 365500.0 |
| 2002-06-28 | ABE-DELISTED | Stock | 6.72 | 6.82 | 6.72 | 6.77 | 5800.0 |
| 2002-06-28 | ABFS-DELISTED | Stock | 24.8 | 25.93 | 24.55 | 25.48 | 325500.0 |
| 2002-06-28 | ABG | Stock | 14.07 | 14.2 | 13.27 | 13.6 | 241600.0 |
| 2002-06-28 | ABK-DELISTED | Stock | 66.95 | 68.38 | 66.7 | 67.3 | 926600.0 |
| 2002-06-28 | ABM | Stock | 17.8 | 18.29 | 17.36 | 17.36 | 144100.0 |
| 2002-06-28 | ABMD-DELISTED | Stock | 7.05 | 8.75 | 7.05 | 8.3 | 320700.0 |
| 2002-06-28 | ABP-DELISTED | Stock | 0.63 | 0.63 | 0.55 | 0.63 | 75800.0 |
| 2002-06-28 | ABT | Stock | 17.6418 | 17.8887 | 16.8787 | 16.9011 | 13723965.0 |
| 2002-06-28 | ABTL-DELISTED | Stock | 14.25 | 15.25 | 14.0 | 15.25 | 12000.0 |
| 2002-06-28 | ABV-DELISTED | Stock | 15.19 | 15.7 | 15.19 | 15.5 | 270000.0 |
| 2002-06-28 | ABVA-DELISTED | Stock | 8.3 | 8.3 | 8.3 | 8.3 | 100.0 |
| 2002-06-28 | ABX-DELISTED | Stock | 19.72 | 19.87 | 18.95 | 18.99 | 3952700.0 |
| 2002-06-28 | ACAP-DELISTED | Stock | 18.25 | 18.5 | 18.11 | 18.46 | 200200.0 |
| 2002-06-28 | ACAS-DELISTED | Stock | 26.86 | 27.57 | 26.46 | 27.57 | 793840.0 |
| 2002-06-28 | ACAT-DELISTED | Stock | 16.9 | 18.0 | 16.9 | 17.41 | 141600.0 |
| 2002-06-28 | ACCL-DELISTED | Stock | 6.48081016540527 | 6.85734987258911 | 6.16871976852417 | 6.85734987258911 | 392500.0 |
| 2002-06-28 | ACE-DELISTED | Stock | 30.8 | 31.9 | 30.63 | 31.6 | 1741364.0 |
| 2002-06-28 | ACF-DELISTED | Stock | 26.94 | 29.25 | 26.6 | 28.05 | 1288000.0 |
| 2002-06-28 | ACG-DELISTED | Stock | 7.95 | 8.01 | 7.91 | 7.99 | 955300.0 |
| 2002-06-28 | ACGL | Stock | 2.9711 | 3.1811 | 2.9711 | 3.1278 | 430200.0 |
| 2002-06-28 | ACGN-DELISTED | Stock | 1235.3288 | 1314.6712 | 1201.3288 | 1314.6712 | 7400.0 |
| 2002-06-28 | ACH | Stock | 12.9333 | 13.3 | 12.82 | 13.1733 | 500400.0 |
| 2002-06-28 | ACH-DELISTED | Stock | 4.625 | 4.775 | 4.625 | 4.775 | 1022800.0 |
| 2002-06-28 | ACLS | Stock | 47.6 | 49.52 | 45.04 | 45.2 | 713100.0 |
| 2002-06-28 | ACO-DELISTED | Stock | 6.0 | 6.76 | 5.98 | 6.45 | 267700.0 |
| 2002-06-28 | ACPW-DELISTED | Stock | 19.65 | 20.25 | 17.75 | 18.05 | 68980.0 |
| 2002-06-28 | ACS-DELISTED | Stock | 45.61 | 48.05 | 45.55 | 47.48 | 2071000.0 |
| 2002-06-28 | ACTA-DELISTED | Stock | 5.8 | 6.4 | 4.8 | 5.4 | 199200.0 |
| 2002-06-28 | ACTT-DELISTED | Stock | 3.0 | 3.1 | 2.85 | 3.1 | 52400.0 |
| 2002-06-28 | ACTU-DELISTED | Stock | 5.0 | 5.19 | 4.49 | 4.5 | 605300.0 |
| 2002-06-28 | ACXM-DELISTED | Stock | 17.15 | 17.56 | 17.14 | 17.49 | 1040600.0 |
> showing 50 of 3,161 rows — these rows as CSV