PREVIEW / stock_daily / 2001-08-28
file: by_date/stock_daily/2001/2001-08-28.parquet size: 102 KB rows: 2,979 symbols: 1,856
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-28 | AAPL | Stock | 0.3375 | 0.3418 | 0.3286 | 0.3286 | 171735200.0 |
| 2001-08-28 | MSFT | Stock | 31.17 | 31.475 | 30.29 | 30.37 | 47422800.0 |
| 2001-08-28 | NVDA | Stock | 0.3666 | 0.3748 | 0.36 | 0.3628 | 1178760000.0 |
| 2001-08-28 | AMZN | Stock | 0.506 | 0.5075 | 0.478 | 0.4985 | 64582000.0 |
| 2001-08-28 | CL | Stock | 27.805 | 27.805 | 27.35 | 27.355 | 2655400.0 |
| 2001-08-28 | A | Stock | 19.4564 | 19.8856 | 19.1416 | 19.671 | 1880450.0 |
| 2001-08-28 | AABA-DELISTED | Stock | 6.76000022888184 | 6.8600001335144 | 6.5 | 6.5 | 14270400.0 |
| 2001-08-28 | AAI-DELISTED | Stock | 6.1 | 6.25 | 6.0 | 6.22 | 1066800.0 |
| 2001-08-28 | AAIC-DELISTED | Stock | 125.8 | 130.0 | 125.8 | 129.0 | 26800.0 |
| 2001-08-28 | AAME | Stock | 1.26 | 1.35 | 1.25 | 1.26 | 4700.0 |
| 2001-08-28 | AAON | Stock | 1.8144 | 1.8144 | 1.788 | 1.7939 | 208448.0 |
| 2001-08-28 | AAXN-DELISTED | Stock | 0.740000009536743 | 0.754166662693024 | 0.704166650772095 | 0.708333313465118 | 1693200.0 |
| 2001-08-28 | ABAX-DELISTED | Stock | 5.06 | 5.0995 | 5.01 | 5.0995 | 9200.0 |
| 2001-08-28 | ABB-DELISTED | Stock | 11.17 | 11.18 | 11.01 | 11.15 | 9800.0 |
| 2001-08-28 | ABC-DELISTED | Stock | 16.5249996185303 | 16.625 | 16.1275005340576 | 16.1499996185303 | 10018800.0 |
| 2001-08-28 | ABCB | Stock | 10.7396 | 10.8612 | 10.7396 | 10.7396 | 1851.0 |
| 2001-08-28 | ABCW-DELISTED | Stock | 17.6 | 17.97 | 17.599 | 17.85 | 35500.0 |
| 2001-08-28 | ABE-DELISTED | Stock | 7.33 | 7.33 | 7.23 | 7.27 | 16900.0 |
| 2001-08-28 | ABFS-DELISTED | Stock | 26.89 | 27.0 | 26.75 | 26.8 | 189000.0 |
| 2001-08-28 | ABK-DELISTED | Stock | 59.8 | 60.0 | 58.65 | 59.27 | 511200.0 |
| 2001-08-28 | ABM | Stock | 17.45 | 17.725 | 17.425 | 17.625 | 96400.0 |
| 2001-08-28 | ABMD-DELISTED | Stock | 19.35 | 19.35 | 18.5 | 18.5 | 48400.0 |
| 2001-08-28 | ABP-DELISTED | Stock | 2.95 | 2.95 | 2.75 | 2.8 | 84200.0 |
| 2001-08-28 | ABT | Stock | 23.1633 | 23.3608 | 22.9613 | 23.0735 | 4443743.0 |
| 2001-08-28 | ABTL-DELISTED | Stock | 4.7 | 4.95 | 4.65 | 4.95 | 4700.0 |
| 2001-08-28 | ABV-DELISTED | Stock | 19.3 | 19.3 | 19.2 | 19.24 | 363800.0 |
| 2001-08-28 | ABX-DELISTED | Stock | 16.22 | 16.23 | 15.9 | 16.14 | 1810100.0 |
| 2001-08-28 | ACAP-DELISTED | Stock | 22.8 | 22.8 | 22.5 | 22.5 | 31700.0 |
| 2001-08-28 | ACAS-DELISTED | Stock | 28.65 | 28.65 | 27.9 | 28.42 | 202800.0 |
| 2001-08-28 | ACAT-DELISTED | Stock | 15.9 | 16.1 | 15.78 | 16.01 | 14300.0 |
| 2001-08-28 | ACCL-DELISTED | Stock | 12.6792001724243 | 12.7509002685547 | 12.6719999313354 | 12.7509002685547 | 558200.0 |
| 2001-08-28 | ACE-DELISTED | Stock | 33.75 | 33.75 | 32.95 | 33.49 | 1150900.0 |
| 2001-08-28 | ACF-DELISTED | Stock | 46.0 | 48.3 | 45.31 | 47.8 | 1768000.0 |
| 2001-08-28 | ACG-DELISTED | Stock | 8.82 | 8.84 | 8.75 | 8.81 | 202500.0 |
| 2001-08-28 | ACGL | Stock | 1.9722 | 1.9722 | 1.8889 | 1.8944 | 107100.0 |
| 2001-08-28 | ACGN-DELISTED | Stock | 1303.3288 | 1303.3288 | 1144.6712 | 1292.0 | 28700.0 |
| 2001-08-28 | ACH | Stock | 13.6667 | 14.0 | 12.8667 | 13.4333 | 271200.0 |
| 2001-08-28 | ACLS | Stock | 58.32 | 58.36 | 55.24 | 56.4 | 209075.0 |
| 2001-08-28 | ACO-DELISTED | Stock | 5.85 | 6.1 | 5.85 | 5.95 | 33900.0 |
| 2001-08-28 | ACPW-DELISTED | Stock | 33.55 | 33.8 | 30.54 | 31.65 | 71618.0 |
| 2001-08-28 | ACS-DELISTED | Stock | 42.9 | 43.25 | 42.5 | 42.55 | 469500.0 |
| 2001-08-28 | ACTA-DELISTED | Stock | 15.4 | 15.6 | 13.0 | 14.0 | 70100.0 |
| 2001-08-28 | ACTT-DELISTED | Stock | 6.55 | 6.65 | 6.52 | 6.57 | 11200.0 |
| 2001-08-28 | ACTU-DELISTED | Stock | 6.7 | 7.25 | 6.62 | 7.25 | 926600.0 |
| 2001-08-28 | ACXM-DELISTED | Stock | 12.84 | 13.13 | 12.55 | 12.55 | 290600.0 |
| 2001-08-28 | AD | Stock | 35.2 | 35.2 | 34.0333 | 34.46 | 390450.0 |
| 2001-08-28 | ADAT-DELISTED | Stock | 74.34 | 74.34 | 67.5 | 68.4 | 3366.0 |
| 2001-08-28 | ADBE | Stock | 18.03 | 18.09 | 16.85 | 17.03 | 5867000.0 |
| 2001-08-28 | ADC | Stock | 20.11 | 20.12 | 19.93 | 19.95 | 5000.0 |
| 2001-08-28 | ADEP-DELISTED | Stock | 32.5 | 32.8 | 30.9 | 31.1 | 73600.0 |
> showing 50 of 2,979 rows — these rows as CSV