PREVIEW / stock_daily / 2001-10-02
file: by_date/stock_daily/2001/2001-10-02.parquet size: 100 KB rows: 2,975 symbols: 1,850
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-10-02 | AAPL | Stock | 0.2755 | 0.2827 | 0.2657 | 0.2688 | 235883200.0 |
| 2001-10-02 | MSFT | Stock | 25.815 | 26.775 | 25.78 | 26.525 | 80860800.0 |
| 2001-10-02 | NVDA | Stock | 0.2092 | 0.2175 | 0.1888 | 0.199 | 1123032000.0 |
| 2001-10-02 | AMZN | Stock | 0.3085 | 0.3085 | 0.2975 | 0.304 | 113554000.0 |
| 2001-10-02 | CL | Stock | 28.5 | 28.75 | 28.37 | 28.75 | 2368400.0 |
| 2001-10-02 | A | Stock | 13.5908 | 14.3777 | 13.5908 | 14.3562 | 3390150.0 |
| 2001-10-02 | AABA-DELISTED | Stock | 4.51000022888184 | 4.625 | 4.44500017166138 | 4.61999988555908 | 10246400.0 |
| 2001-10-02 | AAI-DELISTED | Stock | 4.07 | 4.24 | 4.0 | 4.21 | 187000.0 |
| 2001-10-02 | AAIC-DELISTED | Stock | 102.0 | 102.2 | 99.0 | 99.2 | 21900.0 |
| 2001-10-02 | AAME | Stock | 1.29 | 1.29 | 1.29 | 1.29 | 100.0 |
| 2001-10-02 | AAON | Stock | 1.7778 | 1.7997 | 1.668 | 1.7558 | 322355.0 |
| 2001-10-02 | AAXN-DELISTED | Stock | 0.691666662693024 | 0.715833306312561 | 0.691666662693024 | 0.715833306312561 | 164400.0 |
| 2001-10-02 | ABAX-DELISTED | Stock | 4.2 | 4.25 | 4.1 | 4.2 | 10100.0 |
| 2001-10-02 | ABB-DELISTED | Stock | 6.55 | 6.8 | 6.52 | 6.8 | 28500.0 |
| 2001-10-02 | ABC-DELISTED | Stock | 17.8 | 17.81 | 17.46 | 17.5 | 4752000.0 |
| 2001-10-02 | ABCB | Stock | 10.9422 | 10.9422 | 10.537 | 10.5856 | 11967.0 |
| 2001-10-02 | ABCW-DELISTED | Stock | 16.21 | 16.43 | 16.2 | 16.43 | 8500.0 |
| 2001-10-02 | ABE-DELISTED | Stock | 6.1 | 6.24 | 6.05 | 6.17 | 14900.0 |
| 2001-10-02 | ABFS-DELISTED | Stock | 19.02 | 20.2 | 19.02 | 19.85 | 133300.0 |
| 2001-10-02 | ABK-DELISTED | Stock | 54.28 | 54.34 | 53.0 | 54.21 | 703000.0 |
| 2001-10-02 | ABM | Stock | 12.625 | 12.655 | 12.5 | 12.5 | 98200.0 |
| 2001-10-02 | ABMD-DELISTED | Stock | 16.97 | 17.8 | 16.81 | 17.2 | 201300.0 |
| 2001-10-02 | ABP-DELISTED | Stock | 1.86 | 1.97 | 1.8 | 1.8 | 71000.0 |
| 2001-10-02 | ABT | Stock | 23.5538 | 23.9758 | 23.4147 | 23.9713 | 11318312.0 |
| 2001-10-02 | ABTL-DELISTED | Stock | 4.25 | 4.95 | 4.25 | 4.6 | 5500.0 |
| 2001-10-02 | ABV-DELISTED | Stock | 16.25 | 16.25 | 15.5 | 15.59 | 417800.0 |
| 2001-10-02 | ABX-DELISTED | Stock | 17.805 | 17.955 | 17.585 | 17.945 | 3214514.0 |
| 2001-10-02 | ACAP-DELISTED | Stock | 20.61 | 21.2 | 19.93 | 20.82 | 11600.0 |
| 2001-10-02 | ACAS-DELISTED | Stock | 27.04 | 27.59 | 25.65 | 26.8 | 329700.0 |
| 2001-10-02 | ACAT-DELISTED | Stock | 13.28 | 13.9 | 13.28 | 13.8 | 10300.0 |
| 2001-10-02 | ACCL-DELISTED | Stock | 9.34105968475342 | 9.40622997283936 | 9.31136989593506 | 9.40622997283936 | 797700.0 |
| 2001-10-02 | ACE-DELISTED | Stock | 29.01 | 29.25 | 28.6 | 28.93 | 4832300.0 |
| 2001-10-02 | ACF-DELISTED | Stock | 30.85 | 31.45 | 30.36 | 31.0 | 1365000.0 |
| 2001-10-02 | ACG-DELISTED | Stock | 8.65 | 8.84 | 8.62 | 8.84 | 335400.0 |
| 2001-10-02 | ACGL | Stock | 1.8389 | 1.8389 | 1.8389 | 1.8389 | 284400.0 |
| 2001-10-02 | ACGN-DELISTED | Stock | 1144.6712 | 1144.6712 | 963.3288 | 963.3288 | 10800.0 |
| 2001-10-02 | ACH | Stock | 12.9333 | 13.0 | 12.5733 | 12.8667 | 242700.0 |
| 2001-10-02 | ACLS | Stock | 36.8 | 38.12 | 35.84 | 36.2 | 176450.0 |
| 2001-10-02 | ACO-DELISTED | Stock | 5.7 | 5.85 | 5.6 | 5.74 | 21600.0 |
| 2001-10-02 | ACPW-DELISTED | Stock | 23.5 | 25.25 | 23.5 | 25.25 | 27120.0 |
| 2001-10-02 | ACS-DELISTED | Stock | 39.8 | 40.8 | 39.25 | 40.8 | 809700.0 |
| 2001-10-02 | ACTA-DELISTED | Stock | 9.4 | 10.4 | 9.2 | 10.2 | 99100.0 |
| 2001-10-02 | ACTT-DELISTED | Stock | 9.2 | 9.29 | 8.35 | 9.02 | 103700.0 |
| 2001-10-02 | ACTU-DELISTED | Stock | 4.44 | 5.0 | 4.34 | 4.9 | 210500.0 |
| 2001-10-02 | ACXM-DELISTED | Stock | 10.1 | 11.63 | 10.1 | 11.14 | 2050300.0 |
| 2001-10-02 | ACY-DELISTED | Stock | 5.65 | 5.65 | 5.65 | 5.65 | 400.0 |
| 2001-10-02 | AD | Stock | 32.0 | 32.2467 | 30.88 | 31.3 | 171900.0 |
| 2001-10-02 | ADAT-DELISTED | Stock | 79.02 | 87.66 | 75.78 | 83.52 | 3049.0 |
| 2001-10-02 | ADBE | Stock | 11.945 | 12.475 | 11.63 | 12.19 | 9519600.0 |
| 2001-10-02 | ADC | Stock | 18.23 | 18.3 | 18.0 | 18.15 | 6400.0 |
> showing 50 of 2,975 rows — these rows as CSV