PREVIEW / stock_daily / 2001-09-20
file: by_date/stock_daily/2001/2001-09-20.parquet size: 101 KB rows: 3,046 symbols: 1,904
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-09-20 | AAPL | Stock | 0.2909 | 0.3027 | 0.2768 | 0.28 | 411174400.0 |
| 2001-09-20 | MSFT | Stock | 26.175 | 26.305 | 25.335 | 25.38 | 117983200.0 |
| 2001-09-20 | NVDA | Stock | 0.2488 | 0.2579 | 0.2333 | 0.2407 | 1470696000.0 |
| 2001-09-20 | AMZN | Stock | 0.3555 | 0.382 | 0.3525 | 0.374 | 172618000.0 |
| 2001-09-20 | CL | Stock | 28.15 | 28.185 | 27.245 | 27.415 | 4653800.0 |
| 2001-09-20 | A | Stock | 15.7368 | 15.7439 | 14.6924 | 14.8927 | 2919863.0 |
| 2001-09-20 | AABA-DELISTED | Stock | 4.97499990463257 | 5.17000007629395 | 4.90500020980835 | 4.9850001335144 | 16103200.0 |
| 2001-09-20 | AAI-DELISTED | Stock | 3.3 | 3.34 | 2.6 | 3.01 | 2348200.0 |
| 2001-09-20 | AAIC-DELISTED | Stock | 110.0 | 110.2 | 108.0 | 108.4 | 42000.0 |
| 2001-09-20 | AAME | Stock | 1.25 | 1.3 | 1.24 | 1.3 | 23900.0 |
| 2001-09-20 | AAON | Stock | 1.6458 | 1.668 | 1.5808 | 1.5808 | 885052.0 |
| 2001-09-20 | AAXN-DELISTED | Stock | 0.635833323001862 | 0.635833323001862 | 0.585833311080933 | 0.586666643619537 | 279600.0 |
| 2001-09-20 | ABAX-DELISTED | Stock | 3.7 | 4.0 | 3.51 | 4.0 | 44800.0 |
| 2001-09-20 | ABB-DELISTED | Stock | 6.85 | 7.1 | 6.85 | 7.08 | 11800.0 |
| 2001-09-20 | ABC-DELISTED | Stock | 16.1 | 16.5 | 16.0 | 16.43 | 5056400.0 |
| 2001-09-20 | ABCB | Stock | 10.699 | 10.699 | 10.537 | 10.537 | 21837.0 |
| 2001-09-20 | ABCW-DELISTED | Stock | 16.76 | 17.04 | 16.2 | 16.47 | 61300.0 |
| 2001-09-20 | ABE-DELISTED | Stock | 6.1 | 6.12 | 5.95 | 5.95 | 20600.0 |
| 2001-09-20 | ABFS-DELISTED | Stock | 21.5 | 21.5 | 19.29 | 19.45 | 151800.0 |
| 2001-09-20 | ABK-DELISTED | Stock | 47.1 | 47.1 | 44.7 | 45.5 | 2623900.0 |
| 2001-09-20 | ABM | Stock | 14.5 | 14.555 | 13.715 | 13.75 | 126000.0 |
| 2001-09-20 | ABMD-DELISTED | Stock | 14.06 | 15.03 | 13.5 | 14.0 | 288100.0 |
| 2001-09-20 | ABP-DELISTED | Stock | 1.98 | 1.98 | 1.49 | 1.7 | 276400.0 |
| 2001-09-20 | ABT | Stock | 21.8615 | 22.1757 | 21.6774 | 21.7672 | 11071264.0 |
| 2001-09-20 | ABTL-DELISTED | Stock | 4.95 | 5.45 | 4.45 | 4.5 | 22500.0 |
| 2001-09-20 | ABV-DELISTED | Stock | 17.08 | 17.13 | 15.75 | 16.1 | 362300.0 |
| 2001-09-20 | ABX-DELISTED | Stock | 16.81 | 17.55 | 16.79 | 17.26 | 4042600.0 |
| 2001-09-20 | ACAP-DELISTED | Stock | 19.0 | 19.0 | 18.02 | 18.34 | 73400.0 |
| 2001-09-20 | ACAS-DELISTED | Stock | 26.13 | 26.13 | 25.01 | 25.55 | 231200.0 |
| 2001-09-20 | ACAT-DELISTED | Stock | 14.82 | 14.82 | 13.5 | 13.55 | 245000.0 |
| 2001-09-20 | ACCL-DELISTED | Stock | 9.25 | 9.25399971008301 | 8.37100028991699 | 8.56599998474121 | 571900.0 |
| 2001-09-20 | ACE-DELISTED | Stock | 22.75 | 23.79 | 20.6 | 20.95 | 9363700.0 |
| 2001-09-20 | ACF-DELISTED | Stock | 30.75 | 30.9 | 28.5 | 28.96 | 2262400.0 |
| 2001-09-20 | ACG-DELISTED | Stock | 7.72 | 8.1 | 7.7 | 7.82 | 528800.0 |
| 2001-09-20 | ACGL | Stock | 1.9111 | 1.9633 | 1.8667 | 1.9111 | 157500.0 |
| 2001-09-20 | ACGN-DELISTED | Stock | 918.0 | 1099.3288 | 918.0 | 1099.3288 | 15200.0 |
| 2001-09-20 | ACH | Stock | 11.8333 | 12.1333 | 11.7333 | 11.8933 | 222600.0 |
| 2001-09-20 | ACLS | Stock | 43.2 | 44.24 | 39.6 | 39.96 | 223475.0 |
| 2001-09-20 | ACO-DELISTED | Stock | 5.6 | 5.64 | 5.55 | 5.55 | 20600.0 |
| 2001-09-20 | ACPW-DELISTED | Stock | 21.0 | 21.0 | 19.25 | 20.0 | 105460.0 |
| 2001-09-20 | ACS-DELISTED | Stock | 43.55 | 43.7 | 42.725 | 43.255 | 1163000.0 |
| 2001-09-20 | ACTA-DELISTED | Stock | 9.8 | 9.8 | 8.6 | 8.8 | 59100.0 |
| 2001-09-20 | ACTT-DELISTED | Stock | 7.275 | 7.3 | 7.0 | 7.005 | 73000.0 |
| 2001-09-20 | ACTU-DELISTED | Stock | 3.55 | 4.7 | 3.55 | 4.3 | 1653700.0 |
| 2001-09-20 | ACXM-DELISTED | Stock | 9.11 | 9.18 | 7.6 | 7.85 | 1134971.0 |
| 2001-09-20 | ACY-DELISTED | Stock | 5.73 | 5.85 | 5.56 | 5.83 | 5500.0 |
| 2001-09-20 | AD | Stock | 33.0733 | 33.1667 | 32.3733 | 32.5333 | 267150.0 |
| 2001-09-20 | ADAT-DELISTED | Stock | 62.1 | 62.1 | 54.0 | 57.6 | 2583.0 |
| 2001-09-20 | ADBE | Stock | 12.675 | 13.205 | 11.925 | 12.975 | 11141600.0 |
| 2001-09-20 | ADC | Stock | 18.6 | 18.66 | 18.42 | 18.49 | 11300.0 |
> showing 50 of 3,046 rows — these rows as CSV