PREVIEW / stock_daily / 2001-06-28
file: by_date/stock_daily/2001/2001-06-28.parquet size: 102 KB rows: 2,941 symbols: 1,829
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-28 | AAPL | Stock | 0.4116 | 0.427 | 0.4096 | 0.4204 | 348409600.0 |
| 2001-06-28 | MSFT | Stock | 35.775 | 38.075 | 35.265 | 36.37 | 128975600.0 |
| 2001-06-28 | NVDA | Stock | 0.3836 | 0.3885 | 0.3792 | 0.383 | 909336000.0 |
| 2001-06-28 | AMZN | Stock | 0.7115 | 0.7295 | 0.6885 | 0.718 | 110334000.0 |
| 2001-06-28 | CL | Stock | 30.375 | 30.5 | 30.165 | 30.475 | 2956400.0 |
| 2001-06-28 | A | Stock | 21.4592 | 22.8183 | 21.4592 | 22.6681 | 4211056.0 |
| 2001-06-28 | AABA-DELISTED | Stock | 9.60499954223633 | 9.84000015258789 | 9.5600004196167 | 9.6899995803833 | 16157600.0 |
| 2001-06-28 | AAI-DELISTED | Stock | 9.65 | 10.0 | 9.47 | 10.0 | 590400.0 |
| 2001-06-28 | AAIC-DELISTED | Stock | 120.0 | 130.0 | 120.0 | 130.0 | 284800.0 |
| 2001-06-28 | AAON | Stock | 1.5539 | 1.5978 | 1.4866 | 1.5159 | 444234.0 |
| 2001-06-28 | AAXN-DELISTED | Stock | 0.511666655540466 | 0.511666655540466 | 0.511666655540466 | 0.511666655540466 | 3600.0 |
| 2001-06-28 | ABAX-DELISTED | Stock | 5.32 | 5.38 | 5.27 | 5.27 | 26300.0 |
| 2001-06-28 | ABB-DELISTED | Stock | 14.55 | 15.05 | 14.55 | 15.0 | 28400.0 |
| 2001-06-28 | ABC-DELISTED | Stock | 14.3125 | 14.8400001525879 | 14.3000001907349 | 14.3874998092651 | 2370400.0 |
| 2001-06-28 | ABCB | Stock | 9.078 | 9.078 | 9.0375 | 9.0375 | 2714.0 |
| 2001-06-28 | ABCW-DELISTED | Stock | 15.0 | 15.25 | 14.95 | 15.2 | 71700.0 |
| 2001-06-28 | ABE-DELISTED | Stock | 7.95 | 8.05 | 7.9 | 8.02 | 10400.0 |
| 2001-06-28 | ABFS-DELISTED | Stock | 20.56 | 22.2 | 20.52 | 22.0 | 177000.0 |
| 2001-06-28 | ABK-DELISTED | Stock | 58.55 | 60.0 | 58.34 | 58.35 | 400500.0 |
| 2001-06-28 | ABM | Stock | 17.45 | 17.605 | 17.325 | 17.45 | 111200.0 |
| 2001-06-28 | ABMD-DELISTED | Stock | 23.4 | 24.0 | 22.57 | 23.2 | 100100.0 |
| 2001-06-28 | ABP-DELISTED | Stock | 3.3 | 3.3 | 3.05 | 3.08 | 82400.0 |
| 2001-06-28 | ABT | Stock | 22.4002 | 22.8401 | 22.4002 | 22.7189 | 7136988.0 |
| 2001-06-28 | ABTL-DELISTED | Stock | 6.75 | 7.0 | 6.65 | 7.0 | 18700.0 |
| 2001-06-28 | ABV-DELISTED | Stock | 22.4 | 23.15 | 22.25 | 22.8 | 320900.0 |
| 2001-06-28 | ABX-DELISTED | Stock | 15.38 | 15.39 | 14.94 | 15.02 | 3325700.0 |
| 2001-06-28 | ACAP-DELISTED | Stock | 19.66 | 19.98 | 19.3 | 19.42 | 89800.0 |
| 2001-06-28 | ACAS-DELISTED | Stock | 26.51 | 27.55 | 26.5 | 27.24 | 400700.0 |
| 2001-06-28 | ACAT-DELISTED | Stock | 15.04 | 15.15 | 15.01 | 15.09 | 35283.0 |
| 2001-06-28 | ACCL-DELISTED | Stock | 14.351900100708 | 14.6560001373291 | 14.351900100708 | 14.6560001373291 | 333000.0 |
| 2001-06-28 | ACE-DELISTED | Stock | 39.25 | 40.0 | 38.9 | 39.68 | 1599900.0 |
| 2001-06-28 | ACF-DELISTED | Stock | 52.95 | 54.95 | 52.9 | 53.13 | 920500.0 |
| 2001-06-28 | ACG-DELISTED | Stock | 8.78 | 8.89 | 8.77 | 8.85 | 260000.0 |
| 2001-06-28 | ACGL | Stock | 1.8611 | 1.8611 | 1.7222 | 1.7889 | 214200.0 |
| 2001-06-28 | ACGN-DELISTED | Stock | 1337.3288 | 1416.6712 | 1303.3288 | 1303.3288 | 49900.0 |
| 2001-06-28 | ACH | Stock | 12.7333 | 13.1 | 12.2667 | 12.2667 | 117000.0 |
| 2001-06-28 | ACLS | Stock | 56.72 | 61.44 | 56.72 | 60.76 | 408375.0 |
| 2001-06-28 | ACO-DELISTED | Stock | 5.98 | 6.0 | 5.15 | 5.68 | 39600.0 |
| 2001-06-28 | ACPW-DELISTED | Stock | 80.9 | 82.8 | 77.55 | 80.0 | 136659.0 |
| 2001-06-28 | ACS-DELISTED | Stock | 37.125 | 37.125 | 36.5 | 36.755 | 663000.0 |
| 2001-06-28 | ACTA-DELISTED | Stock | 36.0 | 39.0 | 35.6 | 38.0 | 69200.0 |
| 2001-06-28 | ACTT-DELISTED | Stock | 6.3 | 6.4 | 6.15 | 6.2 | 14000.0 |
| 2001-06-28 | ACTU-DELISTED | Stock | 7.34 | 7.5 | 7.01 | 7.3 | 894400.0 |
| 2001-06-28 | ACXM-DELISTED | Stock | 11.22 | 11.9 | 11.06 | 11.85 | 782800.0 |
| 2001-06-28 | AD | Stock | 38.6267 | 39.0 | 38.1733 | 38.2667 | 99150.0 |
| 2001-06-28 | ADAT-DELISTED | Stock | 71.64 | 78.84 | 71.64 | 77.4 | 5052.0 |
| 2001-06-28 | ADBE | Stock | 22.425 | 24.065 | 22.405 | 23.43 | 9316400.0 |
| 2001-06-28 | ADC | Stock | 19.4 | 19.55 | 19.4 | 19.48 | 1600.0 |
| 2001-06-28 | ADEP-DELISTED | Stock | 41.6 | 49.5 | 40.0 | 49.05 | 41600.0 |
| 2001-06-28 | ADGF-DELISTED | Stock | 0.91 | 0.98 | 0.91 | 0.95 | 20800.0 |
> showing 50 of 2,941 rows — these rows as CSV