PREVIEW / stock_daily / 2008-11-05
file: by_date/stock_daily/2008/2008-11-05.parquet size: 177 KB rows: 5,701 symbols: 3,409
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-05 | AAPL | Stock | 3.8896 | 3.9186 | 3.6782 | 3.6893 | 1256455200.0 |
| 2008-11-05 | MSFT | Stock | 23.33 | 23.34 | 22.05 | 22.08 | 81179700.0 |
| 2008-11-05 | NVDA | Stock | 0.2163 | 0.2225 | 0.2128 | 0.2128 | 787620000.0 |
| 2008-11-05 | AMZN | Stock | 2.8735 | 2.9 | 2.581 | 2.599 | 229968000.0 |
| 2008-11-05 | TLT | Stock | 94.89 | 95.67 | 94.4001 | 95.57 | 1931636.0 |
| 2008-11-05 | CL | Stock | 32.725 | 32.93 | 31.59 | 31.855 | 7904200.0 |
| 2008-11-05 | A | Stock | 17.3247 | 17.6037 | 16.6237 | 16.6381 | 3003044.0 |
| 2008-11-05 | AABA-DELISTED | Stock | 13.23 | 14.84 | 13.15 | 13.92 | 70794295.0 |
| 2008-11-05 | AACC-DELISTED | Stock | 7.42 | 7.57 | 7.03 | 7.27 | 93442.0 |
| 2008-11-05 | AACG | Stock | 8.39 | 8.4 | 8.32 | 8.32 | 5800.0 |
| 2008-11-05 | AAI-DELISTED | Stock | 3.98 | 4.06 | 3.77 | 3.89 | 2504806.0 |
| 2008-11-05 | AAIC-DELISTED | Stock | 14.6 | 14.6 | 12.6 | 12.6 | 431167.0 |
| 2008-11-05 | AAME | Stock | 1.2 | 1.3 | 1.2 | 1.3 | 57900.0 |
| 2008-11-05 | AAON | Stock | 3.5259 | 3.8894 | 3.4746 | 3.5141 | 1366875.0 |
| 2008-11-05 | AAP | Stock | 31.15 | 31.21 | 29.1 | 29.32 | 1110600.0 |
| 2008-11-05 | AATI-DELISTED | Stock | 3.02 | 3.05 | 2.86 | 2.89 | 216242.0 |
| 2008-11-05 | AAU-DELISTED | Stock | 0.81 | 0.83 | 0.75 | 0.79 | 34474.0 |
| 2008-11-05 | AAUAF-DELISTED | Stock | 0.81 | 0.8299 | 0.75 | 0.79 | 41774.0 |
| 2008-11-05 | AAV-DELISTED | Stock | 6.44 | 6.44 | 6.06 | 6.1 | 577021.0 |
| 2008-11-05 | AAWW-DELISTED | Stock | 23.15 | 23.33 | 22.4675 | 22.81 | 402197.0 |
| 2008-11-05 | AAXJ | Stock | 34.15 | 34.15 | 32.53 | 32.9 | 104927.0 |
| 2008-11-05 | AAXN-DELISTED | Stock | 5.25 | 5.39 | 4.98 | 5.0 | 365096.0 |
| 2008-11-05 | AB | Stock | 23.12 | 24.73 | 22.61 | 23.21 | 439500.0 |
| 2008-11-05 | ABAX-DELISTED | Stock | 16.97 | 17.43 | 16.81 | 16.88 | 338448.0 |
| 2008-11-05 | ABB-DELISTED | Stock | 13.52 | 13.81 | 12.91 | 12.97 | 7131484.0 |
| 2008-11-05 | ABBC-DELISTED | Stock | 9.82 | 9.89 | 9.75 | 9.75 | 64877.0 |
| 2008-11-05 | ABBNY-DELISTED | Stock | 13.52 | 13.81 | 12.91 | 12.97 | 7179261.0 |
| 2008-11-05 | ABC-DELISTED | Stock | 15.66 | 15.79 | 15.32 | 15.44 | 4218730.0 |
| 2008-11-05 | ABCB | Stock | 10.7087 | 11.127 | 9.9793 | 10.1836 | 22722.0 |
| 2008-11-05 | ABCO-DELISTED | Stock | 12.629 | 13.028 | 11.836 | 11.936 | 354778.0 |
| 2008-11-05 | ABCW-DELISTED | Stock | 6.0945 | 6.0945 | 5.6057 | 5.6655 | 128900.0 |
| 2008-11-05 | ABD-DELISTED | Stock | 2.825 | 3.2143 | 2.7052 | 2.835 | 455620.0 |
| 2008-11-05 | ABE-DELISTED | Stock | 14.7 | 14.7 | 13.51 | 13.6 | 82343.0 |
| 2008-11-05 | ABEO | Stock | 2500.0 | 2500.0 | 2312.5 | 2500.0 | 43.0 |
| 2008-11-05 | ABFS-DELISTED | Stock | 29.07 | 30.0 | 26.12 | 26.36 | 739095.0 |
| 2008-11-05 | ABG | Stock | 3.76 | 3.89 | 3.5 | 3.54 | 989500.0 |
| 2008-11-05 | ABII-DELISTED | Stock | 64.97 | 64.97 | 63.0 | 63.5 | 4804.0 |
| 2008-11-05 | ABK-DELISTED | Stock | 2.23 | 2.69 | 2.02 | 2.05 | 61792506.0 |
| 2008-11-05 | ABM | Stock | 16.29 | 16.58 | 15.56 | 15.58 | 171200.0 |
| 2008-11-05 | ABMD-DELISTED | Stock | 15.08 | 15.33 | 14.41 | 14.53 | 216318.0 |
| 2008-11-05 | ABR | Stock | 5.05 | 5.35 | 4.53 | 4.76 | 362800.0 |
| 2008-11-05 | ABT | Stock | 26.8016 | 27.5405 | 26.3074 | 26.4754 | 19175907.0 |
| 2008-11-05 | ABTL-DELISTED | Stock | 3.6497 | 3.7503 | 3.6497 | 3.7503 | 124.0 |
| 2008-11-05 | ABV-DELISTED | Stock | 43.68 | 44.1 | 41.48 | 41.77 | 878746.0 |
| 2008-11-05 | ABVA-DELISTED | Stock | 3.74 | 3.89 | 3.058 | 3.44 | 3691.0 |
| 2008-11-05 | ABVT-DELISTED | Stock | 38.0 | 40.0 | 36.0 | 40.0 | 18400.0 |
| 2008-11-05 | ABX-DELISTED | Stock | 24.83 | 26.16 | 24.15 | 25.0 | 11626357.0 |
| 2008-11-05 | ACAD | Stock | 1.98 | 2.04 | 1.79 | 1.82 | 59400.0 |
| 2008-11-05 | ACAP-DELISTED | Stock | 39.0 | 41.88 | 37.07 | 37.19 | 95266.0 |
| 2008-11-05 | ACAS-DELISTED | Stock | 15.69 | 15.74 | 14.13 | 14.39 | 1989794.0 |
> showing 50 of 5,701 rows — these rows as CSV