PREVIEW / stock_daily / 2008-10-31
file: by_date/stock_daily/2008/2008-10-31.parquet size: 178 KB rows: 5,790 symbols: 3,484
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-10-31 | AAPL | Stock | 3.8357 | 3.9564 | 3.755 | 3.8425 | 1659756000.0 |
| 2008-10-31 | MSFT | Stock | 22.53 | 22.91 | 22.12 | 22.33 | 93055200.0 |
| 2008-10-31 | NVDA | Stock | 0.209 | 0.2232 | 0.2085 | 0.219 | 608672000.0 |
| 2008-10-31 | AMZN | Stock | 2.8005 | 2.8625 | 2.7505 | 2.862 | 170692000.0 |
| 2008-10-31 | TLT | Stock | 94.64 | 94.92 | 92.65 | 92.83 | 2282489.0 |
| 2008-10-31 | CL | Stock | 32.015 | 33.48 | 30.92 | 31.38 | 14387800.0 |
| 2008-10-31 | A | Stock | 15.8369 | 16.5808 | 15.5937 | 15.8727 | 5943038.0 |
| 2008-10-31 | AABA-DELISTED | Stock | 13.09 | 13.36 | 12.71 | 12.88 | 23792752.0 |
| 2008-10-31 | AACC-DELISTED | Stock | 7.69 | 8.17 | 7.52 | 8.17 | 99236.0 |
| 2008-10-31 | AACG | Stock | 8.4 | 8.4 | 8.26 | 8.3 | 4300.0 |
| 2008-10-31 | AAI-DELISTED | Stock | 3.96 | 4.31 | 3.87 | 4.1 | 5258359.0 |
| 2008-10-31 | AAIC-DELISTED | Stock | 10.0 | 13.6 | 10.0 | 12.6 | 716906.0 |
| 2008-10-31 | AAME | Stock | 1.08 | 1.1 | 1.08 | 1.1 | 400.0 |
| 2008-10-31 | AAON | Stock | 2.9531 | 3.2612 | 2.9175 | 3.2573 | 561431.0 |
| 2008-10-31 | AAP | Stock | 27.25 | 31.4 | 26.88 | 31.2 | 3609500.0 |
| 2008-10-31 | AATI-DELISTED | Stock | 3.0 | 3.05 | 2.63 | 3.0 | 294090.0 |
| 2008-10-31 | AAU-DELISTED | Stock | 0.83 | 0.85 | 0.79 | 0.82 | 25565.0 |
| 2008-10-31 | AAUAF-DELISTED | Stock | 0.83 | 0.85 | 0.79 | 0.821 | 26765.0 |
| 2008-10-31 | AAV-DELISTED | Stock | 6.0 | 6.24 | 5.79 | 6.15 | 631387.0 |
| 2008-10-31 | AAWW-DELISTED | Stock | 18.3 | 19.52 | 17.73 | 19.32 | 269349.0 |
| 2008-10-31 | AAXJ | Stock | 32.24 | 33.32 | 31.82 | 32.89 | 280363.0 |
| 2008-10-31 | AAXN-DELISTED | Stock | 4.75 | 5.08 | 4.56 | 5.01 | 554035.0 |
| 2008-10-31 | AB | Stock | 21.33 | 23.98 | 21.07 | 23.44 | 632400.0 |
| 2008-10-31 | ABAX-DELISTED | Stock | 14.18 | 15.78 | 13.98 | 15.37 | 422299.0 |
| 2008-10-31 | ABB-DELISTED | Stock | 12.4 | 13.42 | 12.3 | 13.21 | 5653255.0 |
| 2008-10-31 | ABBC-DELISTED | Stock | 10.06 | 10.43 | 9.6 | 10.35 | 107202.0 |
| 2008-10-31 | ABBNY-DELISTED | Stock | 12.4 | 13.42 | 12.3 | 13.15 | 5663855.0 |
| 2008-10-31 | ABC-DELISTED | Stock | 15.36 | 15.92 | 15.09 | 15.67 | 5144736.0 |
| 2008-10-31 | ABCB | Stock | 10.096 | 10.738 | 10.0765 | 10.738 | 39377.0 |
| 2008-10-31 | ABCO-DELISTED | Stock | 11.405 | 12.49 | 11.405 | 12.325 | 288460.0 |
| 2008-10-31 | ABCW-DELISTED | Stock | 5.19 | 5.7 | 4.94 | 5.7 | 169890.0 |
| 2008-10-31 | ABD-DELISTED | Stock | 2.65 | 2.9904 | 2.57 | 2.82 | 543620.0 |
| 2008-10-31 | ABE-DELISTED | Stock | 12.5001 | 13.04 | 12.15 | 12.66 | 124537.0 |
| 2008-10-31 | ABEO | Stock | 2250.0 | 2500.0 | 2250.0 | 2312.5 | 7.0 |
| 2008-10-31 | ABFS-DELISTED | Stock | 27.57 | 29.5 | 27.2 | 29.2 | 673867.0 |
| 2008-10-31 | ABG | Stock | 3.07 | 3.38 | 2.91 | 3.25 | 722800.0 |
| 2008-10-31 | ABII-DELISTED | Stock | 66.37 | 66.37 | 62.62 | 63.0 | 17118.0 |
| 2008-10-31 | ABK-DELISTED | Stock | 2.41 | 2.94 | 2.41 | 2.7 | 25724362.0 |
| 2008-10-31 | ABM | Stock | 15.05 | 16.4 | 14.7 | 16.33 | 338000.0 |
| 2008-10-31 | ABMD-DELISTED | Stock | 13.31 | 14.65 | 13.31 | 14.58 | 342455.0 |
| 2008-10-31 | ABR | Stock | 3.42 | 3.75 | 3.4 | 3.6 | 711100.0 |
| 2008-10-31 | ABT | Stock | 26.0867 | 26.8688 | 25.9188 | 26.461 | 17948520.0 |
| 2008-10-31 | ABTL-DELISTED | Stock | 3.0 | 3.9 | 2.9 | 3.9 | 6800.0 |
| 2008-10-31 | ABV-DELISTED | Stock | 42.44 | 43.27 | 41.49 | 42.94 | 1527849.0 |
| 2008-10-31 | ABVT-DELISTED | Stock | 40.0 | 43.0 | 38.0 | 40.0 | 8473.0 |
| 2008-10-31 | ABX-DELISTED | Stock | 23.82 | 24.45 | 22.61 | 22.77 | 10812462.0 |
| 2008-10-31 | ACAD | Stock | 1.87 | 1.97 | 1.85 | 1.9 | 138300.0 |
| 2008-10-31 | ACAP-DELISTED | Stock | 37.5 | 43.71 | 36.39 | 40.95 | 110592.0 |
| 2008-10-31 | ACAS-DELISTED | Stock | 14.39 | 14.61 | 13.24 | 14.05 | 3064271.0 |
| 2008-10-31 | ACAT-DELISTED | Stock | 6.81 | 7.62 | 6.6 | 7.57 | 56652.0 |
> showing 50 of 5,790 rows — these rows as CSV