PREVIEW / stock_daily / 2001-06-14
file: by_date/stock_daily/2001/2001-06-14.parquet size: 100 KB rows: 2,920 symbols: 1,815
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-14 | AAPL | Stock | 0.3579 | 0.3652 | 0.353 | 0.355 | 297348800.0 |
| 2001-06-14 | MSFT | Stock | 35.11 | 35.275 | 34.2 | 34.45 | 71972400.0 |
| 2001-06-14 | NVDA | Stock | 0.3858 | 0.3966 | 0.3802 | 0.39 | 946152000.0 |
| 2001-06-14 | AMZN | Stock | 0.706 | 0.706 | 0.658 | 0.6645 | 101766000.0 |
| 2001-06-14 | CL | Stock | 28.925 | 29.075 | 28.55 | 28.855 | 1917000.0 |
| 2001-06-14 | A | Stock | 22.9971 | 23.0043 | 21.7096 | 22.2461 | 3332133.0 |
| 2001-06-14 | AABA-DELISTED | Stock | 8.52999973297119 | 8.73999977111816 | 8.02499961853027 | 8.23499965667725 | 16570400.0 |
| 2001-06-14 | AAI-DELISTED | Stock | 11.75 | 12.25 | 11.7 | 12.01 | 1282600.0 |
| 2001-06-14 | AAIC-DELISTED | Stock | 113.6 | 114.0 | 111.0 | 111.0 | 32700.0 |
| 2001-06-14 | AAME | Stock | 1.85 | 1.89 | 1.85 | 1.89 | 5500.0 |
| 2001-06-14 | AAON | Stock | 1.4573 | 1.4603 | 1.3959 | 1.4339 | 148648.0 |
| 2001-06-14 | ABAX-DELISTED | Stock | 5.67 | 5.75 | 5.66 | 5.75 | 23100.0 |
| 2001-06-14 | ABB-DELISTED | Stock | 16.28 | 16.5 | 16.27 | 16.27 | 38400.0 |
| 2001-06-14 | ABC-DELISTED | Stock | 14.1499996185303 | 14.25 | 14.0249996185303 | 14.1350002288818 | 1965600.0 |
| 2001-06-14 | ABCW-DELISTED | Stock | 14.9 | 14.99 | 14.85 | 14.86 | 7400.0 |
| 2001-06-14 | ABE-DELISTED | Stock | 8.28 | 8.3 | 8.2 | 8.2 | 26000.0 |
| 2001-06-14 | ABFS-DELISTED | Stock | 22.9 | 22.9 | 22.53 | 22.69 | 96800.0 |
| 2001-06-14 | ABK-DELISTED | Stock | 55.9 | 55.9 | 54.42 | 55.36 | 516000.0 |
| 2001-06-14 | ABM | Stock | 17.525 | 17.925 | 17.0 | 17.73 | 213600.0 |
| 2001-06-14 | ABMD-DELISTED | Stock | 23.28 | 23.79 | 21.05 | 22.49 | 70600.0 |
| 2001-06-14 | ABP-DELISTED | Stock | 4.1 | 4.14 | 4.0 | 4.06 | 144300.0 |
| 2001-06-14 | ABT | Stock | 22.5707 | 23.2172 | 22.5348 | 22.6695 | 6912662.0 |
| 2001-06-14 | ABTL-DELISTED | Stock | 7.7 | 8.0 | 7.4 | 8.0 | 23000.0 |
| 2001-06-14 | ABV-DELISTED | Stock | 21.34 | 21.34 | 20.0 | 20.63 | 193600.0 |
| 2001-06-14 | ABX-DELISTED | Stock | 16.95 | 17.59 | 16.81 | 17.35 | 2264900.0 |
| 2001-06-14 | ACAP-DELISTED | Stock | 19.37 | 19.51 | 18.0 | 18.78 | 164500.0 |
| 2001-06-14 | ACAS-DELISTED | Stock | 26.54 | 26.54 | 26.2 | 26.23 | 122488.0 |
| 2001-06-14 | ACAT-DELISTED | Stock | 14.79 | 14.79 | 14.7 | 14.75 | 3800.0 |
| 2001-06-14 | ACCL-DELISTED | Stock | 17.0536003112793 | 17.0536003112793 | 16.6690998077393 | 17.0536003112793 | 341100.0 |
| 2001-06-14 | ACE-DELISTED | Stock | 39.19 | 39.26 | 38.76 | 39.08 | 788896.0 |
| 2001-06-14 | ACF-DELISTED | Stock | 47.75 | 47.75 | 45.0 | 46.49 | 1475400.0 |
| 2001-06-14 | ACG-DELISTED | Stock | 8.47 | 8.6 | 8.46 | 8.55 | 352600.0 |
| 2001-06-14 | ACGL | Stock | 1.8056 | 1.8456 | 1.8056 | 1.8111 | 56700.0 |
| 2001-06-14 | ACGN-DELISTED | Stock | 1360.0 | 1450.6712 | 1360.0 | 1416.6712 | 35000.0 |
| 2001-06-14 | ACH | Stock | 13.1667 | 13.2 | 12.4867 | 13.1667 | 151350.0 |
| 2001-06-14 | ACLS | Stock | 60.8 | 61.4 | 57.4 | 57.8 | 127975.0 |
| 2001-06-14 | ACO-DELISTED | Stock | 6.2 | 6.2 | 6.1 | 6.11 | 16700.0 |
| 2001-06-14 | ACPW-DELISTED | Stock | 98.5 | 98.5 | 89.9 | 95.4 | 178500.0 |
| 2001-06-14 | ACS-DELISTED | Stock | 37.3 | 37.475 | 36.455 | 36.75 | 582000.0 |
| 2001-06-14 | ACTA-DELISTED | Stock | 38.4 | 38.6 | 35.8 | 37.0 | 58900.0 |
| 2001-06-14 | ACTT-DELISTED | Stock | 7.16 | 7.16 | 7.15 | 7.15 | 1000.0 |
| 2001-06-14 | ACTU-DELISTED | Stock | 9.65 | 9.78 | 8.3 | 8.6 | 801800.0 |
| 2001-06-14 | ACXM-DELISTED | Stock | 17.3 | 17.3 | 16.71 | 16.74 | 282500.0 |
| 2001-06-14 | ACY-DELISTED | Stock | 5.05 | 5.15 | 5.05 | 5.1 | 1000.0 |
| 2001-06-14 | AD | Stock | 38.2 | 38.2 | 37.1667 | 37.2333 | 60600.0 |
| 2001-06-14 | ADAT-DELISTED | Stock | 81.9 | 83.7 | 81.0 | 82.44 | 2136.0 |
| 2001-06-14 | ADBE | Stock | 19.855 | 20.1 | 18.9 | 19.505 | 11826000.0 |
| 2001-06-14 | ADC | Stock | 18.7 | 19.5 | 18.7 | 19.35 | 20100.0 |
| 2001-06-14 | ADEP-DELISTED | Stock | 43.25 | 43.5 | 42.2 | 43.0 | 83600.0 |
| 2001-06-14 | ADGF-DELISTED | Stock | 1.05 | 1.05 | 0.88 | 0.95 | 55200.0 |
> showing 50 of 2,920 rows — these rows as CSV