PREVIEW / stock_daily / 2005-10-12
file: by_date/stock_daily/2005/2005-10-12.parquet size: 141 KB rows: 4,217 symbols: 2,652
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-12 | AAPL | Stock | 1.7375 | 1.7964 | 1.7096 | 1.7589 | 2697486400.0 |
| 2005-10-12 | MSFT | Stock | 24.49 | 24.7 | 24.27 | 24.3 | 71294400.0 |
| 2005-10-12 | NVDA | Stock | 0.2644 | 0.2724 | 0.2641 | 0.2683 | 657660000.0 |
| 2005-10-12 | AMZN | Stock | 2.1455 | 2.184 | 2.122 | 2.1275 | 114084000.0 |
| 2005-10-12 | CL | Stock | 25.85 | 26.06 | 25.825 | 25.98 | 4120800.0 |
| 2005-10-12 | A | Stock | 22.0959 | 22.2461 | 21.5021 | 21.7668 | 5462545.0 |
| 2005-10-12 | AABA-DELISTED | Stock | 33.9900016784668 | 34.7099990844727 | 33.9099998474121 | 33.9300003051758 | 16089600.0 |
| 2005-10-12 | AACC-DELISTED | Stock | 29.35 | 29.51 | 28.91 | 28.97 | 98541.0 |
| 2005-10-12 | AACQW-DELISTED | Stock | 0.53 | 0.55 | 0.51 | 0.51 | 317500.0 |
| 2005-10-12 | AAI-DELISTED | Stock | 12.91 | 13.06 | 12.67 | 12.92 | 1641100.0 |
| 2005-10-12 | AAIC-DELISTED | Stock | 179.2 | 182.0 | 171.0 | 174.2 | 1745800.0 |
| 2005-10-12 | AAME | Stock | 2.66 | 2.75 | 2.64 | 2.7 | 15900.0 |
| 2005-10-12 | AAON | Stock | 2.2887 | 2.3111 | 2.2887 | 2.294 | 186806.0 |
| 2005-10-12 | AAP | Stock | 38.2 | 38.21 | 36.6 | 37.22 | 1436500.0 |
| 2005-10-12 | AATI-DELISTED | Stock | 11.31 | 11.4 | 10.43 | 10.46 | 107099.0 |
| 2005-10-12 | AAV-DELISTED | Stock | 17.4 | 17.79 | 17.36 | 17.4 | 40100.0 |
| 2005-10-12 | AAXN-DELISTED | Stock | 5.65999984741211 | 5.8899998664856 | 5.61999988555908 | 5.65999984741211 | 1677200.0 |
| 2005-10-12 | ABAX-DELISTED | Stock | 13.25 | 13.33 | 13.03 | 13.2 | 99314.0 |
| 2005-10-12 | ABB-DELISTED | Stock | 7.36 | 7.4 | 7.29 | 7.33 | 717000.0 |
| 2005-10-12 | ABBC-DELISTED | Stock | 12.53 | 12.53 | 12.4 | 12.48 | 33797.0 |
| 2005-10-12 | ABC-DELISTED | Stock | 18.6 | 18.76 | 18.6 | 18.69 | 5176000.0 |
| 2005-10-12 | ABCB | Stock | 17.8188 | 17.8285 | 17.527 | 17.6632 | 13674.0 |
| 2005-10-12 | ABCO-DELISTED | Stock | 23.51 | 24.36 | 23.45 | 23.67 | 259197.0 |
| 2005-10-12 | ABCW-DELISTED | Stock | 29.01 | 29.44 | 29.01 | 29.31 | 258810.0 |
| 2005-10-12 | ABD-DELISTED | Stock | 26.72 | 26.84 | 26.03 | 26.3 | 233300.0 |
| 2005-10-12 | ABE-DELISTED | Stock | 11.03 | 11.04 | 10.68 | 10.71 | 37900.0 |
| 2005-10-12 | ABFS-DELISTED | Stock | 33.76 | 34.079 | 32.86 | 33.04 | 219055.0 |
| 2005-10-12 | ABG | Stock | 16.88 | 16.9 | 16.59 | 16.65 | 69300.0 |
| 2005-10-12 | ABK-DELISTED | Stock | 69.45 | 70.28 | 68.67 | 69.01 | 804300.0 |
| 2005-10-12 | ABM | Stock | 19.65 | 19.78 | 19.18 | 19.43 | 99100.0 |
| 2005-10-12 | ABMD-DELISTED | Stock | 9.4 | 9.52 | 9.02 | 9.09 | 105384.0 |
| 2005-10-12 | ABP-DELISTED | Stock | 7.3 | 7.45 | 6.91 | 7.19 | 899500.0 |
| 2005-10-12 | ABR | Stock | 27.9 | 28.18 | 27.18 | 27.44 | 134600.0 |
| 2005-10-12 | ABT | Stock | 20.1756 | 20.4875 | 19.9501 | 20.1996 | 11613172.0 |
| 2005-10-12 | ABTL-DELISTED | Stock | 23.57 | 23.57 | 22.73 | 23.18 | 33132.0 |
| 2005-10-12 | ABV-DELISTED | Stock | 36.7 | 36.7 | 35.11 | 35.61 | 191900.0 |
| 2005-10-12 | ABVA-DELISTED | Stock | 16.45 | 16.72 | 16.45 | 16.5 | 3505.0 |
| 2005-10-12 | ABX-DELISTED | Stock | 28.34 | 28.63 | 27.38 | 27.67 | 2714700.0 |
| 2005-10-12 | ACAD | Stock | 10.04 | 10.9 | 10.0 | 10.87 | 59400.0 |
| 2005-10-12 | ACAP-DELISTED | Stock | 44.91 | 44.91 | 42.69 | 43.41 | 100041.0 |
| 2005-10-12 | ACAS-DELISTED | Stock | 36.31 | 36.41 | 35.04 | 35.14 | 1002363.0 |
| 2005-10-12 | ACAT-DELISTED | Stock | 18.59 | 19.03 | 17.93 | 18.93 | 116297.0 |
| 2005-10-12 | ACC-DELISTED | Stock | 22.94 | 23.1 | 22.6 | 22.78 | 139000.0 |
| 2005-10-12 | ACCL-DELISTED | Stock | 6.39 | 6.48 | 6.1 | 6.38 | 132519.0 |
| 2005-10-12 | ACCO | Stock | 26.72 | 26.84 | 26.03 | 26.3 | 233300.0 |
| 2005-10-12 | ACE-DELISTED | Stock | 47.6 | 48.05 | 47.34 | 47.35 | 2170245.0 |
| 2005-10-12 | ACF-DELISTED | Stock | 22.25 | 22.72 | 22.08 | 22.33 | 1858600.0 |
| 2005-10-12 | ACFC-DELISTED | Stock | 68.78 | 69.08 | 68.57 | 68.83 | 8318.0 |
| 2005-10-12 | ACG-DELISTED | Stock | 8.27 | 8.27 | 8.19 | 8.22 | 403800.0 |
| 2005-10-12 | ACGL | Stock | 5.2056 | 5.2344 | 5.0989 | 5.1711 | 1524600.0 |
> showing 50 of 4,217 rows — these rows as CSV