PREVIEW / stock_daily / 2002-06-27
file: by_date/stock_daily/2002/2002-06-27.parquet size: 107 KB rows: 3,144 symbols: 1,951
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-27 | AAPL | Stock | 0.2998 | 0.3084 | 0.2932 | 0.3046 | 251658400.0 |
| 2002-06-27 | MSFT | Stock | 27.3 | 27.47 | 26.43 | 27.46 | 95812400.0 |
| 2002-06-27 | NVDA | Stock | 0.1734 | 0.1747 | 0.14 | 0.1423 | 3182808000.0 |
| 2002-06-27 | AMZN | Stock | 0.8055 | 0.8235 | 0.765 | 0.793 | 123840000.0 |
| 2002-06-27 | CL | Stock | 25.25 | 25.925 | 25.075 | 25.775 | 10043800.0 |
| 2002-06-27 | A | Stock | 16.6237 | 17.525 | 16.5951 | 17.3319 | 1979428.0 |
| 2002-06-27 | AABA-DELISTED | Stock | 7.21500015258789 | 7.34999990463257 | 6.61999988555908 | 7.09000015258789 | 23792600.0 |
| 2002-06-27 | AAI-DELISTED | Stock | 5.2 | 5.36 | 5.15 | 5.2 | 184800.0 |
| 2002-06-27 | AAIC-DELISTED | Stock | 235.6 | 247.0 | 235.6 | 244.0 | 155600.0 |
| 2002-06-27 | AAME | Stock | 2.05 | 2.45 | 2.05 | 2.45 | 400.0 |
| 2002-06-27 | AAON | Stock | 2.5244 | 2.5284 | 2.4388 | 2.5021 | 448791.0 |
| 2002-06-27 | AAP | Stock | 18.8333 | 18.8833 | 18.0167 | 18.2467 | 993600.0 |
| 2002-06-27 | AAXN-DELISTED | Stock | 0.988333344459534 | 1.0183333158493 | 0.966666638851166 | 1.0 | 339600.0 |
| 2002-06-27 | ABAX-DELISTED | Stock | 4.49 | 4.65 | 4.37 | 4.65 | 9400.0 |
| 2002-06-27 | ABB-DELISTED | Stock | 8.7 | 8.73 | 8.61 | 8.7 | 8900.0 |
| 2002-06-27 | ABC-DELISTED | Stock | 19.3 | 19.6 | 19.17 | 19.52 | 2627200.0 |
| 2002-06-27 | ABCB | Stock | 11.923 | 12.077 | 11.6312 | 11.9554 | 51324.0 |
| 2002-06-27 | ABCO-DELISTED | Stock | 18.733 | 19.262 | 18.439 | 19.242 | 146500.0 |
| 2002-06-27 | ABCW-DELISTED | Stock | 22.73 | 22.99 | 22.16 | 22.36 | 34200.0 |
| 2002-06-27 | ABE-DELISTED | Stock | 6.6 | 6.77 | 6.6 | 6.69 | 8500.0 |
| 2002-06-27 | ABFS-DELISTED | Stock | 24.57 | 24.94 | 23.96 | 24.7 | 151500.0 |
| 2002-06-27 | ABG | Stock | 13.75 | 14.25 | 13.7 | 14.1 | 70800.0 |
| 2002-06-27 | ABK-DELISTED | Stock | 68.5 | 69.13 | 66.96 | 66.96 | 1012700.0 |
| 2002-06-27 | ABM | Stock | 17.35 | 17.98 | 16.9 | 17.92 | 164700.0 |
| 2002-06-27 | ABMD-DELISTED | Stock | 7.14 | 7.44 | 6.92 | 7.19 | 65300.0 |
| 2002-06-27 | ABP-DELISTED | Stock | 0.55 | 0.63 | 0.54 | 0.63 | 69600.0 |
| 2002-06-27 | ABT | Stock | 16.9909 | 17.6508 | 16.9011 | 17.5745 | 10064583.0 |
| 2002-06-27 | ABTL-DELISTED | Stock | 12.45 | 15.5 | 11.65 | 14.4 | 53700.0 |
| 2002-06-27 | ABV-DELISTED | Stock | 15.5 | 15.53 | 15.0 | 15.21 | 338700.0 |
| 2002-06-27 | ABVA-DELISTED | Stock | 8.0 | 8.0 | 8.0 | 8.0 | 1000.0 |
| 2002-06-27 | ABX-DELISTED | Stock | 19.95 | 20.25 | 19.5 | 19.75 | 3039400.0 |
| 2002-06-27 | ACAP-DELISTED | Stock | 18.95 | 18.96 | 18.01 | 18.25 | 33700.0 |
| 2002-06-27 | ACAS-DELISTED | Stock | 26.05 | 27.32 | 26.04 | 26.96 | 369700.0 |
| 2002-06-27 | ACAT-DELISTED | Stock | 17.03 | 17.79 | 16.37 | 17.27 | 144800.0 |
| 2002-06-27 | ACCL-DELISTED | Stock | 6.01013994216919 | 6.50977993011475 | 6.01013994216919 | 6.50977993011475 | 231900.0 |
| 2002-06-27 | ACE-DELISTED | Stock | 31.05 | 31.29 | 28.83 | 29.98 | 3516800.0 |
| 2002-06-27 | ACF-DELISTED | Stock | 26.75 | 27.25 | 25.95 | 26.8 | 1171900.0 |
| 2002-06-27 | ACG-DELISTED | Stock | 8.1 | 8.1 | 8.0 | 8.05 | 865200.0 |
| 2002-06-27 | ACGL | Stock | 3.0222 | 3.1 | 2.9422 | 3.0111 | 571500.0 |
| 2002-06-27 | ACGN-DELISTED | Stock | 1337.3288 | 1337.3288 | 1167.3288 | 1235.3288 | 118500.0 |
| 2002-06-27 | ACH | Stock | 12.7733 | 13.2 | 12.7733 | 13.1 | 337800.0 |
| 2002-06-27 | ACH-DELISTED | Stock | 4.5495 | 4.6295 | 4.5294 | 4.6295 | 29971.0 |
| 2002-06-27 | ACLS | Stock | 43.68 | 48.2 | 43.6 | 47.52 | 306950.0 |
| 2002-06-27 | ACO-DELISTED | Stock | 5.9 | 6.0 | 5.75 | 6.0 | 65300.0 |
| 2002-06-27 | ACPW-DELISTED | Stock | 18.75 | 19.6 | 17.9 | 19.6 | 22100.0 |
| 2002-06-27 | ACS-DELISTED | Stock | 48.0 | 48.0 | 44.3 | 45.48 | 2795400.0 |
| 2002-06-27 | ACTA-DELISTED | Stock | 6.2 | 6.6 | 5.6 | 5.8 | 38200.0 |
| 2002-06-27 | ACTT-DELISTED | Stock | 2.9 | 3.2 | 2.9 | 2.95 | 46900.0 |
| 2002-06-27 | ACTU-DELISTED | Stock | 4.8 | 5.05 | 4.64 | 5.05 | 156300.0 |
| 2002-06-27 | ACXM-DELISTED | Stock | 16.89 | 17.35 | 16.85 | 17.05 | 700700.0 |
> showing 50 of 3,144 rows — these rows as CSV