PREVIEW / stock_daily / 2005-10-14
file: by_date/stock_daily/2005/2005-10-14.parquet size: 140 KB rows: 4,179 symbols: 2,634
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-14 | AAPL | Stock | 1.9296 | 1.9411 | 1.8854 | 1.9286 | 1035552000.0 |
| 2005-10-14 | MSFT | Stock | 24.71 | 24.73 | 24.5 | 24.67 | 53846700.0 |
| 2005-10-14 | NVDA | Stock | 0.2688 | 0.2722 | 0.2625 | 0.2669 | 311256000.0 |
| 2005-10-14 | AMZN | Stock | 2.15 | 2.1935 | 2.117 | 2.1895 | 91552000.0 |
| 2005-10-14 | CL | Stock | 25.89 | 26.41 | 25.68 | 26.2 | 3785000.0 |
| 2005-10-14 | A | Stock | 23.6767 | 23.6767 | 21.8026 | 22.1245 | 3457114.0 |
| 2005-10-14 | AABA-DELISTED | Stock | 33.6199989318848 | 33.6199989318848 | 32.7700004577637 | 33.5200004577637 | 17425200.0 |
| 2005-10-14 | AACC-DELISTED | Stock | 27.74 | 28.32 | 27.32 | 27.52 | 140685.0 |
| 2005-10-14 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 2500.0 |
| 2005-10-14 | AACQU-DELISTED | Stock | 6.13 | 6.13 | 6.05 | 6.05 | 2500.0 |
| 2005-10-14 | AACQW-DELISTED | Stock | 0.5 | 0.5 | 0.5 | 0.5 | 15000.0 |
| 2005-10-14 | AAI-DELISTED | Stock | 13.63 | 13.93 | 13.39 | 13.73 | 1471300.0 |
| 2005-10-14 | AAIC-DELISTED | Stock | 180.6 | 188.0 | 180.0 | 185.2 | 1863200.0 |
| 2005-10-14 | AAME | Stock | 2.5 | 2.83 | 2.5 | 2.68 | 5600.0 |
| 2005-10-14 | AAON | Stock | 2.24 | 2.2848 | 2.2387 | 2.2782 | 236925.0 |
| 2005-10-14 | AAP | Stock | 37.0 | 38.37 | 36.98 | 37.47 | 1482000.0 |
| 2005-10-14 | AATI-DELISTED | Stock | 10.86 | 10.86 | 10.41 | 10.64 | 210736.0 |
| 2005-10-14 | AAV-DELISTED | Stock | 17.1 | 17.21 | 16.8 | 17.1 | 52100.0 |
| 2005-10-14 | AAXN-DELISTED | Stock | 5.55000019073486 | 5.6100001335144 | 5.51999998092651 | 5.6100001335144 | 956100.0 |
| 2005-10-14 | ABAX-DELISTED | Stock | 13.51 | 13.6 | 13.28 | 13.59 | 45518.0 |
| 2005-10-14 | ABB-DELISTED | Stock | 7.26 | 7.32 | 7.24 | 7.31 | 227300.0 |
| 2005-10-14 | ABBC-DELISTED | Stock | 12.1 | 12.1 | 11.9 | 12.01 | 18111.0 |
| 2005-10-14 | ABC-DELISTED | Stock | 18.68 | 18.8 | 18.5 | 18.68 | 3058400.0 |
| 2005-10-14 | ABCB | Stock | 17.9939 | 17.9939 | 17.5854 | 17.9064 | 8122.0 |
| 2005-10-14 | ABCO-DELISTED | Stock | 24.02 | 24.29 | 23.87 | 24.04 | 91122.0 |
| 2005-10-14 | ABCW-DELISTED | Stock | 29.6 | 30.07 | 29.39 | 30.03 | 48740.0 |
| 2005-10-14 | ABD-DELISTED | Stock | 25.76 | 25.8 | 24.81 | 24.81 | 479910.0 |
| 2005-10-14 | ABE-DELISTED | Stock | 10.76 | 10.76 | 10.57 | 10.63 | 12100.0 |
| 2005-10-14 | ABFS-DELISTED | Stock | 33.46 | 33.88 | 33.18 | 33.5 | 201014.0 |
| 2005-10-14 | ABG | Stock | 16.75 | 17.03 | 16.65 | 16.9 | 62400.0 |
| 2005-10-14 | ABK-DELISTED | Stock | 69.27 | 69.93 | 69.0 | 69.82 | 551300.0 |
| 2005-10-14 | ABM | Stock | 19.69 | 19.85 | 19.41 | 19.7 | 92100.0 |
| 2005-10-14 | ABMD-DELISTED | Stock | 9.06 | 9.2 | 8.96 | 9.1 | 32367.0 |
| 2005-10-14 | ABP-DELISTED | Stock | 6.75 | 7.2 | 6.65 | 7.11 | 810900.0 |
| 2005-10-14 | ABR | Stock | 27.35 | 27.96 | 27.16 | 27.89 | 125900.0 |
| 2005-10-14 | ABT | Stock | 20.3051 | 20.4827 | 20.1516 | 20.4587 | 10143185.0 |
| 2005-10-14 | ABTL-DELISTED | Stock | 23.22 | 23.53 | 23.02 | 23.22 | 16594.0 |
| 2005-10-14 | ABV-DELISTED | Stock | 36.0 | 36.1 | 34.66 | 35.11 | 463200.0 |
| 2005-10-14 | ABVA-DELISTED | Stock | 16.55 | 16.7 | 16.5 | 16.6999 | 1140.0 |
| 2005-10-14 | ABX-DELISTED | Stock | 26.93 | 27.13 | 26.62 | 26.85 | 2400429.0 |
| 2005-10-14 | ACAD | Stock | 11.05 | 11.05 | 10.92 | 11.02 | 41600.0 |
| 2005-10-14 | ACAP-DELISTED | Stock | 43.91 | 43.91 | 42.74 | 43.84 | 34379.0 |
| 2005-10-14 | ACAS-DELISTED | Stock | 35.3 | 36.55 | 35.25 | 35.79 | 909546.0 |
| 2005-10-14 | ACAT-DELISTED | Stock | 18.73 | 18.73 | 18.191 | 18.73 | 218633.0 |
| 2005-10-14 | ACC-DELISTED | Stock | 23.05 | 23.62 | 22.74 | 23.55 | 130900.0 |
| 2005-10-14 | ACCL-DELISTED | Stock | 6.48 | 6.75 | 6.48 | 6.61 | 56556.0 |
| 2005-10-14 | ACCO | Stock | 25.75 | 25.79 | 24.8 | 24.82 | 483100.0 |
| 2005-10-14 | ACE-DELISTED | Stock | 48.46 | 49.52 | 48.38 | 49.07 | 2617600.0 |
| 2005-10-14 | ACF-DELISTED | Stock | 22.64 | 22.97 | 22.55 | 22.88 | 1173400.0 |
| 2005-10-14 | ACFC-DELISTED | Stock | 68.83 | 70.05 | 68.42 | 68.88 | 2483.0 |
> showing 50 of 4,179 rows — these rows as CSV