PREVIEW / stock_daily / 2001-08-31
file: by_date/stock_daily/2001/2001-08-31.parquet size: 101 KB rows: 2,973 symbols: 1,846
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-08-31 | AAPL | Stock | 0.3166 | 0.3321 | 0.3152 | 0.3313 | 216904800.0 |
| 2001-08-31 | MSFT | Stock | 28.425 | 29.03 | 28.15 | 28.525 | 57900800.0 |
| 2001-08-31 | NVDA | Stock | 0.3477 | 0.3562 | 0.3431 | 0.353 | 887904000.0 |
| 2001-08-31 | AMZN | Stock | 0.435 | 0.465 | 0.4345 | 0.447 | 72832000.0 |
| 2001-08-31 | CL | Stock | 26.825 | 27.405 | 26.825 | 27.075 | 1690800.0 |
| 2001-08-31 | A | Stock | 18.5265 | 19.1345 | 18.4907 | 18.9557 | 1439521.0 |
| 2001-08-31 | AABA-DELISTED | Stock | 5.65999984741211 | 5.94999980926514 | 5.58500003814697 | 5.92999982833862 | 15667000.0 |
| 2001-08-31 | AAI-DELISTED | Stock | 6.6 | 6.75 | 6.52 | 6.53 | 519800.0 |
| 2001-08-31 | AAIC-DELISTED | Stock | 134.2 | 134.2 | 128.0 | 132.0 | 25800.0 |
| 2001-08-31 | AAME | Stock | 1.45 | 1.45 | 1.45 | 1.45 | 700.0 |
| 2001-08-31 | AAON | Stock | 1.7828 | 1.7997 | 1.7792 | 1.7851 | 358805.0 |
| 2001-08-31 | AAXN-DELISTED | Stock | 0.679166674613953 | 0.716666638851166 | 0.679166674613953 | 0.708333313465118 | 852000.0 |
| 2001-08-31 | ABAX-DELISTED | Stock | 4.9114 | 5.05 | 4.86 | 5.01 | 5100.0 |
| 2001-08-31 | ABB-DELISTED | Stock | 10.34 | 10.34 | 10.26 | 10.3 | 15600.0 |
| 2001-08-31 | ABC-DELISTED | Stock | 15.58 | 16.16 | 15.58 | 16.11 | 4444800.0 |
| 2001-08-31 | ABCB | Stock | 10.8612 | 10.8612 | 10.5775 | 10.8612 | 2221.0 |
| 2001-08-31 | ABCW-DELISTED | Stock | 17.995 | 18.285 | 17.845 | 18.285 | 55200.0 |
| 2001-08-31 | ABE-DELISTED | Stock | 7.11 | 7.13 | 7.1 | 7.1 | 26500.0 |
| 2001-08-31 | ABFS-DELISTED | Stock | 26.4 | 27.19 | 26.21 | 26.57 | 123500.0 |
| 2001-08-31 | ABK-DELISTED | Stock | 59.05 | 59.45 | 59.02 | 59.31 | 269600.0 |
| 2001-08-31 | ABM | Stock | 17.475 | 17.48 | 17.18 | 17.275 | 109800.0 |
| 2001-08-31 | ABMD-DELISTED | Stock | 19.34 | 19.45 | 18.3599 | 18.75 | 32100.0 |
| 2001-08-31 | ABP-DELISTED | Stock | 2.7 | 2.7 | 2.31 | 2.37 | 115200.0 |
| 2001-08-31 | ABT | Stock | 22.5887 | 22.885 | 22.1712 | 22.3104 | 5518367.0 |
| 2001-08-31 | ABTL-DELISTED | Stock | 5.0 | 5.0 | 4.3 | 5.0 | 13300.0 |
| 2001-08-31 | ABV-DELISTED | Stock | 18.65 | 18.85 | 18.5 | 18.84 | 365200.0 |
| 2001-08-31 | ABX-DELISTED | Stock | 16.1 | 16.12 | 15.88 | 16.02 | 949600.0 |
| 2001-08-31 | ACAP-DELISTED | Stock | 22.5 | 22.55 | 22.35 | 22.43 | 65800.0 |
| 2001-08-31 | ACAS-DELISTED | Stock | 27.96 | 28.41 | 27.32 | 28.22 | 165400.0 |
| 2001-08-31 | ACAT-DELISTED | Stock | 16.09 | 16.09 | 16.0 | 16.05 | 14300.0 |
| 2001-08-31 | ACCL-DELISTED | Stock | 12.6999998092651 | 12.7080001831055 | 12.1730003356934 | 12.5629997253418 | 395000.0 |
| 2001-08-31 | ACE-DELISTED | Stock | 33.21 | 33.91 | 33.12 | 33.21 | 907872.0 |
| 2001-08-31 | ACF-DELISTED | Stock | 46.08 | 46.55 | 45.4 | 46.14 | 1259600.0 |
| 2001-08-31 | ACG-DELISTED | Stock | 8.81 | 8.87 | 8.79 | 8.87 | 139600.0 |
| 2001-08-31 | ACGL | Stock | 1.9722 | 1.9722 | 1.9667 | 1.9667 | 12600.0 |
| 2001-08-31 | ACGN-DELISTED | Stock | 1280.6712 | 1326.0 | 1201.3288 | 1246.6712 | 6400.0 |
| 2001-08-31 | ACH | Stock | 13.4 | 13.7 | 12.8333 | 13.5333 | 195600.0 |
| 2001-08-31 | ACLS | Stock | 54.8 | 57.0 | 54.6 | 55.8 | 188900.0 |
| 2001-08-31 | ACO-DELISTED | Stock | 6.15 | 6.24 | 5.95 | 6.0 | 12100.0 |
| 2001-08-31 | ACPW-DELISTED | Stock | 29.5 | 29.95 | 27.6 | 27.8 | 72400.0 |
| 2001-08-31 | ACS-DELISTED | Stock | 41.1 | 41.44 | 40.55 | 40.885 | 818600.0 |
| 2001-08-31 | ACTA-DELISTED | Stock | 13.4 | 16.4 | 12.8 | 15.2 | 94800.0 |
| 2001-08-31 | ACTT-DELISTED | Stock | 6.26 | 6.45 | 6.25 | 6.35 | 4200.0 |
| 2001-08-31 | ACTU-DELISTED | Stock | 6.56 | 7.29 | 6.55 | 6.9 | 845700.0 |
| 2001-08-31 | ACXM-DELISTED | Stock | 12.71 | 12.84 | 12.44 | 12.73 | 328200.0 |
| 2001-08-31 | ACY-DELISTED | Stock | 5.9 | 5.92 | 5.8 | 5.8 | 1000.0 |
| 2001-08-31 | AD | Stock | 33.8333 | 34.5 | 33.6733 | 34.5 | 52800.0 |
| 2001-08-31 | ADAT-DELISTED | Stock | 70.2 | 71.64 | 68.4 | 71.28 | 8680.0 |
| 2001-08-31 | ADBE | Stock | 16.05 | 17.13 | 15.975 | 16.805 | 8971600.0 |
| 2001-08-31 | ADC | Stock | 19.27 | 19.45 | 19.27 | 19.4 | 6300.0 |
> showing 50 of 2,973 rows — these rows as CSV