PREVIEW / stock_daily / 2001-06-19
file: by_date/stock_daily/2001/2001-06-19.parquet size: 101 KB rows: 2,958 symbols: 1,845
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-19 | AAPL | Stock | 0.3723 | 0.3821 | 0.3573 | 0.3605 | 321087200.0 |
| 2001-06-19 | MSFT | Stock | 34.105 | 34.425 | 33.425 | 33.66 | 63457400.0 |
| 2001-06-19 | NVDA | Stock | 0.3875 | 0.3966 | 0.3519 | 0.3596 | 1513128000.0 |
| 2001-06-19 | AMZN | Stock | 0.6225 | 0.6325 | 0.56 | 0.568 | 122190000.0 |
| 2001-06-19 | CL | Stock | 28.95 | 29.155 | 28.745 | 29.09 | 2714200.0 |
| 2001-06-19 | A | Stock | 21.8169 | 21.9456 | 20.7439 | 20.9728 | 3296344.0 |
| 2001-06-19 | AABA-DELISTED | Stock | 8.1899995803833 | 8.25500011444092 | 7.61999988555908 | 7.78000020980835 | 19567800.0 |
| 2001-06-19 | AAI-DELISTED | Stock | 11.94 | 11.94 | 11.0 | 11.3 | 467300.0 |
| 2001-06-19 | AAIC-DELISTED | Stock | 113.0 | 117.4 | 113.0 | 114.2 | 89000.0 |
| 2001-06-19 | AAME | Stock | 1.89 | 1.89 | 1.85 | 1.85 | 2700.0 |
| 2001-06-19 | AAON | Stock | 1.3988 | 1.3988 | 1.3169 | 1.3754 | 227243.0 |
| 2001-06-19 | AAXN-DELISTED | Stock | 0.508333325386047 | 0.508333325386047 | 0.46000000834465 | 0.46000000834465 | 237600.0 |
| 2001-06-19 | ABAX-DELISTED | Stock | 5.69 | 5.7 | 5.65 | 5.7 | 18600.0 |
| 2001-06-19 | ABB-DELISTED | Stock | 16.4 | 16.4 | 16.11 | 16.3 | 5200.0 |
| 2001-06-19 | ABC-DELISTED | Stock | 14.8000001907349 | 14.8000001907349 | 14.602499961853 | 14.6575002670288 | 1730800.0 |
| 2001-06-19 | ABCB | Stock | 9.078 | 9.078 | 9.078 | 9.078 | 1727.0 |
| 2001-06-19 | ABCW-DELISTED | Stock | 14.07 | 14.16 | 14.06 | 14.16 | 154000.0 |
| 2001-06-19 | ABE-DELISTED | Stock | 8.08 | 8.08 | 8.0 | 8.08 | 28300.0 |
| 2001-06-19 | ABFS-DELISTED | Stock | 20.05 | 20.35 | 19.75 | 20.1 | 67100.0 |
| 2001-06-19 | ABK-DELISTED | Stock | 57.0 | 57.0 | 56.26 | 56.57 | 302800.0 |
| 2001-06-19 | ABM | Stock | 18.275 | 18.375 | 17.99 | 17.99 | 143400.0 |
| 2001-06-19 | ABMD-DELISTED | Stock | 23.6 | 24.45 | 22.4 | 23.0 | 86400.0 |
| 2001-06-19 | ABP-DELISTED | Stock | 3.95 | 3.95 | 3.6 | 3.6 | 121000.0 |
| 2001-06-19 | ABT | Stock | 22.8939 | 23.1094 | 22.7683 | 23.0196 | 8607245.0 |
| 2001-06-19 | ABTL-DELISTED | Stock | 7.4 | 7.4 | 7.15 | 7.15 | 2000.0 |
| 2001-06-19 | ABV-DELISTED | Stock | 19.27 | 19.3 | 18.9 | 19.2 | 669600.0 |
| 2001-06-19 | ABX-DELISTED | Stock | 16.95 | 17.04 | 16.6 | 16.63 | 1624300.0 |
| 2001-06-19 | ACAP-DELISTED | Stock | 19.25 | 19.56 | 19.24 | 19.41 | 24700.0 |
| 2001-06-19 | ACAS-DELISTED | Stock | 25.65 | 26.06 | 25.25 | 25.56 | 107700.0 |
| 2001-06-19 | ACAT-DELISTED | Stock | 14.81 | 14.82 | 14.76 | 14.81 | 3900.0 |
| 2001-06-19 | ACCL-DELISTED | Stock | 17.0100002288818 | 17.3430004119873 | 16.2199993133545 | 16.2849998474121 | 285300.0 |
| 2001-06-19 | ACE-DELISTED | Stock | 37.2 | 37.7 | 36.0 | 36.36 | 1429300.0 |
| 2001-06-19 | ACF-DELISTED | Stock | 48.75 | 50.6 | 48.75 | 49.57 | 1098700.0 |
| 2001-06-19 | ACG-DELISTED | Stock | 8.69 | 8.72 | 8.55 | 8.71 | 330100.0 |
| 2001-06-19 | ACGL | Stock | 1.8033 | 1.8033 | 1.7333 | 1.7611 | 81000.0 |
| 2001-06-19 | ACGN-DELISTED | Stock | 1258.0 | 1303.3288 | 1190.0 | 1246.6712 | 21300.0 |
| 2001-06-19 | ACH | Stock | 13.2333 | 13.2333 | 12.9 | 13.02 | 116400.0 |
| 2001-06-19 | ACLS | Stock | 60.0 | 60.4 | 55.6 | 56.96 | 214900.0 |
| 2001-06-19 | ACO-DELISTED | Stock | 6.07 | 6.07 | 6.05 | 6.05 | 45000.0 |
| 2001-06-19 | ACPW-DELISTED | Stock | 96.75 | 97.5 | 90.75 | 91.25 | 68940.0 |
| 2001-06-19 | ACS-DELISTED | Stock | 37.5 | 37.75 | 37.25 | 37.575 | 286300.0 |
| 2001-06-19 | ACTA-DELISTED | Stock | 34.4 | 35.2 | 30.0 | 30.2 | 68500.0 |
| 2001-06-19 | ACTT-DELISTED | Stock | 6.71 | 6.76 | 6.45 | 6.47 | 10600.0 |
| 2001-06-19 | ACTU-DELISTED | Stock | 8.35 | 8.7 | 7.2 | 7.95 | 575000.0 |
| 2001-06-19 | ACXM-DELISTED | Stock | 15.65 | 16.09 | 15.08 | 15.17 | 611700.0 |
| 2001-06-19 | ACY-DELISTED | Stock | 5.05 | 5.05 | 5.05 | 5.05 | 3300.0 |
| 2001-06-19 | AD | Stock | 37.1667 | 37.6 | 36.9 | 37.2667 | 84300.0 |
| 2001-06-19 | ADAT-DELISTED | Stock | 77.4 | 80.1 | 77.4 | 77.94 | 2251.0 |
| 2001-06-19 | ADBE | Stock | 21.005 | 21.85 | 21.0 | 21.375 | 13882400.0 |
| 2001-06-19 | ADC | Stock | 19.3 | 19.74 | 19.3 | 19.7 | 8700.0 |
> showing 50 of 2,958 rows — these rows as CSV