PREVIEW / stock_daily / 2005-10-05
file: by_date/stock_daily/2005/2005-10-05.parquet size: 140 KB rows: 4,185 symbols: 2,630
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-05 | AAPL | Stock | 1.9404 | 1.9414 | 1.8839 | 1.885 | 610769600.0 |
| 2005-10-05 | MSFT | Stock | 25.04 | 25.05 | 24.67 | 24.67 | 73684700.0 |
| 2005-10-05 | NVDA | Stock | 0.29 | 0.29 | 0.2783 | 0.2801 | 599184000.0 |
| 2005-10-05 | AMZN | Stock | 2.2455 | 2.2645 | 2.1945 | 2.2245 | 129054000.0 |
| 2005-10-05 | CL | Stock | 26.33 | 26.49 | 26.205 | 26.205 | 4054000.0 |
| 2005-10-05 | A | Stock | 22.9757 | 22.99 | 22.2675 | 22.3605 | 5472331.0 |
| 2005-10-05 | AABA-DELISTED | Stock | 33.7900009155273 | 33.9300003051758 | 33.3600006103516 | 33.4900016784668 | 14642000.0 |
| 2005-10-05 | AACC-DELISTED | Stock | 30.67 | 30.67 | 29.6 | 29.63 | 106423.0 |
| 2005-10-05 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 5000.0 |
| 2005-10-05 | AACQU-DELISTED | Stock | 6.24 | 6.24 | 6.2 | 6.2 | 3000.0 |
| 2005-10-05 | AACQW-DELISTED | Stock | 0.56 | 0.56 | 0.55 | 0.55 | 23600.0 |
| 2005-10-05 | AAI-DELISTED | Stock | 13.36 | 13.36 | 12.72 | 12.99 | 2328000.0 |
| 2005-10-05 | AAIC-DELISTED | Stock | 197.6 | 198.6 | 187.4 | 190.8 | 3376100.0 |
| 2005-10-05 | AAON | Stock | 2.3322 | 2.3506 | 2.2624 | 2.2756 | 233887.0 |
| 2005-10-05 | AAP | Stock | 38.7 | 38.97 | 37.66 | 37.75 | 874300.0 |
| 2005-10-05 | AATI-DELISTED | Stock | 11.31 | 11.64 | 11.21 | 11.38 | 59219.0 |
| 2005-10-05 | AAV-DELISTED | Stock | 16.94 | 17.46 | 16.93 | 16.94 | 63400.0 |
| 2005-10-05 | AAXN-DELISTED | Stock | 5.98999977111816 | 6.0 | 5.69000005722046 | 5.71999979019165 | 1797100.0 |
| 2005-10-05 | ABAX-DELISTED | Stock | 13.98 | 13.99 | 13.42 | 13.57 | 196220.0 |
| 2005-10-05 | ABB-DELISTED | Stock | 7.38 | 7.41 | 7.31 | 7.32 | 737700.0 |
| 2005-10-05 | ABBC-DELISTED | Stock | 12.48 | 12.5 | 12.48 | 12.5 | 750.0 |
| 2005-10-05 | ABC-DELISTED | Stock | 19.55 | 19.65 | 18.95 | 18.98 | 2963600.0 |
| 2005-10-05 | ABCB | Stock | 18.7233 | 18.7233 | 17.6632 | 17.6632 | 18403.0 |
| 2005-10-05 | ABCO-DELISTED | Stock | 25.56 | 25.76 | 24.88 | 24.88 | 300562.0 |
| 2005-10-05 | ABCW-DELISTED | Stock | 29.4 | 29.68 | 29.19 | 29.19 | 124030.0 |
| 2005-10-05 | ABD-DELISTED | Stock | 27.6 | 27.96 | 27.57 | 27.6 | 171700.0 |
| 2005-10-05 | ABE-DELISTED | Stock | 11.49 | 11.49 | 11.001 | 11.1 | 39300.0 |
| 2005-10-05 | ABFS-DELISTED | Stock | 33.69 | 33.85 | 32.72 | 32.75 | 300728.0 |
| 2005-10-05 | ABG | Stock | 16.9 | 16.97 | 16.6 | 16.71 | 105000.0 |
| 2005-10-05 | ABK-DELISTED | Stock | 70.85 | 70.96 | 69.59 | 69.74 | 756000.0 |
| 2005-10-05 | ABM | Stock | 21.0 | 21.01 | 20.02 | 20.07 | 213700.0 |
| 2005-10-05 | ABMD-DELISTED | Stock | 9.8 | 10.04 | 9.6 | 9.71 | 86278.0 |
| 2005-10-05 | ABP-DELISTED | Stock | 9.0 | 9.2 | 7.9 | 8.28 | 2802000.0 |
| 2005-10-05 | ABR | Stock | 28.75 | 28.88 | 28.25 | 28.85 | 102100.0 |
| 2005-10-05 | ABT | Stock | 21.1256 | 21.2839 | 20.7514 | 20.7657 | 10641934.0 |
| 2005-10-05 | ABTL-DELISTED | Stock | 24.3 | 24.5 | 23.85 | 24.1 | 37508.0 |
| 2005-10-05 | ABV-DELISTED | Stock | 37.9 | 37.9 | 36.28 | 36.55 | 356100.0 |
| 2005-10-05 | ABVA-DELISTED | Stock | 16.4265 | 16.55 | 16.42 | 16.55 | 1100.0 |
| 2005-10-05 | ABVT-DELISTED | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 500.0 |
| 2005-10-05 | ABX-DELISTED | Stock | 28.3 | 28.3 | 27.56 | 27.69 | 3527500.0 |
| 2005-10-05 | ACAD | Stock | 11.15 | 11.46 | 10.84 | 11.02 | 84800.0 |
| 2005-10-05 | ACAP-DELISTED | Stock | 47.39 | 47.56 | 45.36 | 45.46 | 93974.0 |
| 2005-10-05 | ACAS-DELISTED | Stock | 36.83 | 37.0 | 36.51 | 36.761 | 467738.0 |
| 2005-10-05 | ACAT-DELISTED | Stock | 20.12 | 20.45 | 19.29 | 19.32 | 417057.0 |
| 2005-10-05 | ACC-DELISTED | Stock | 24.01 | 24.01 | 23.5 | 23.63 | 78900.0 |
| 2005-10-05 | ACCL-DELISTED | Stock | 7.02 | 7.02 | 6.59 | 6.65 | 101749.0 |
| 2005-10-05 | ACCO | Stock | 27.6 | 27.96 | 27.57 | 27.6 | 171800.0 |
| 2005-10-05 | ACE-DELISTED | Stock | 47.0 | 48.45 | 46.81 | 47.81 | 4206900.0 |
| 2005-10-05 | ACF-DELISTED | Stock | 23.09 | 23.09 | 22.25 | 22.38 | 2872500.0 |
| 2005-10-05 | ACFC-DELISTED | Stock | 71.22 | 71.43 | 71.17 | 71.38 | 2494.0 |
> showing 50 of 4,185 rows — these rows as CSV