PREVIEW / stock_daily / 2008-11-07
file: by_date/stock_daily/2008/2008-11-07.parquet size: 175 KB rows: 5,699 symbols: 3,413
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-07 | AAPL | Stock | 3.5443 | 3.5661 | 3.4186 | 3.5086 | 1095253600.0 |
| 2008-11-07 | MSFT | Stock | 21.32 | 21.54 | 21.0 | 21.5 | 71256300.0 |
| 2008-11-07 | NVDA | Stock | 0.217 | 0.2268 | 0.2025 | 0.218 | 1132068000.0 |
| 2008-11-07 | AMZN | Stock | 2.388 | 2.4895 | 2.3505 | 2.4605 | 148792000.0 |
| 2008-11-07 | TLT | Stock | 94.52 | 94.52 | 93.55 | 94.26 | 1277053.0 |
| 2008-11-07 | CL | Stock | 31.065 | 31.51 | 30.735 | 31.51 | 6377800.0 |
| 2008-11-07 | A | Stock | 15.372 | 16.0372 | 15.2074 | 15.6223 | 3836531.0 |
| 2008-11-07 | AABA-DELISTED | Stock | 12.45 | 12.5 | 11.65 | 12.21 | 46594457.0 |
| 2008-11-07 | AACC-DELISTED | Stock | 6.9 | 7.0 | 6.26 | 6.85 | 121179.0 |
| 2008-11-07 | AACG | Stock | 8.21 | 8.4 | 8.18 | 8.2 | 46200.0 |
| 2008-11-07 | AAI-DELISTED | Stock | 3.83 | 4.0 | 3.68 | 3.79 | 1568520.0 |
| 2008-11-07 | AAIC-DELISTED | Stock | 11.4 | 14.0 | 11.4 | 13.96 | 245315.0 |
| 2008-11-07 | AAME | Stock | 1.06 | 1.06 | 1.05 | 1.05 | 1100.0 |
| 2008-11-07 | AAON | Stock | 3.6721 | 3.8519 | 3.5812 | 3.7709 | 421200.0 |
| 2008-11-07 | AAP | Stock | 28.15 | 28.89 | 27.88 | 28.61 | 993500.0 |
| 2008-11-07 | AATI-DELISTED | Stock | 2.92 | 3.08 | 2.84 | 3.07 | 142087.0 |
| 2008-11-07 | AAU-DELISTED | Stock | 0.74 | 0.75 | 0.7 | 0.7 | 43800.0 |
| 2008-11-07 | AAUAF-DELISTED | Stock | 0.74 | 0.75 | 0.7 | 0.7 | 44800.0 |
| 2008-11-07 | AAV-DELISTED | Stock | 5.89 | 6.18 | 5.67 | 5.74 | 755606.0 |
| 2008-11-07 | AAWW-DELISTED | Stock | 21.18 | 22.48 | 21.18 | 22.0 | 376177.0 |
| 2008-11-07 | AAXJ | Stock | 31.0 | 32.85 | 31.0 | 31.97 | 254278.0 |
| 2008-11-07 | AAXN-DELISTED | Stock | 4.75 | 5.0 | 4.51 | 4.68 | 320086.0 |
| 2008-11-07 | AB | Stock | 21.21 | 21.91 | 19.75 | 20.33 | 382900.0 |
| 2008-11-07 | ABAX-DELISTED | Stock | 15.35 | 15.94 | 14.49 | 15.0 | 564231.0 |
| 2008-11-07 | ABB-DELISTED | Stock | 11.56 | 11.81 | 11.4 | 11.68 | 5608420.0 |
| 2008-11-07 | ABBC-DELISTED | Stock | 9.8 | 10.1 | 9.8 | 10.1 | 52529.0 |
| 2008-11-07 | ABBNY-DELISTED | Stock | 11.56 | 11.805 | 11.4 | 11.72 | 5611620.0 |
| 2008-11-07 | ABC-DELISTED | Stock | 15.08 | 15.28 | 14.98 | 15.14 | 2738738.0 |
| 2008-11-07 | ABCB | Stock | 10.2419 | 10.699 | 9.9987 | 10.6504 | 13057.0 |
| 2008-11-07 | ABCO-DELISTED | Stock | 11.403 | 11.837 | 11.313 | 11.667 | 237947.0 |
| 2008-11-07 | ABCW-DELISTED | Stock | 5.24 | 5.27 | 4.92 | 5.13 | 77930.0 |
| 2008-11-07 | ABD-DELISTED | Stock | 2.66 | 2.76 | 2.42 | 2.47 | 400710.0 |
| 2008-11-07 | ABE-DELISTED | Stock | 12.75 | 13.5 | 12.75 | 12.95 | 29025.0 |
| 2008-11-07 | ABEO | Stock | 2250.0 | 2250.0 | 2025.0 | 2125.0 | 18.0 |
| 2008-11-07 | ABFS-DELISTED | Stock | 25.52 | 25.85 | 24.38 | 25.05 | 641044.0 |
| 2008-11-07 | ABG | Stock | 3.5 | 3.71 | 3.35 | 3.51 | 456100.0 |
| 2008-11-07 | ABII-DELISTED | Stock | 64.14 | 65.35 | 63.99 | 65.25 | 8025.0 |
| 2008-11-07 | ABK-DELISTED | Stock | 1.67 | 1.85 | 1.6 | 1.67 | 28092418.0 |
| 2008-11-07 | ABM | Stock | 15.31 | 15.94 | 15.1 | 15.77 | 191700.0 |
| 2008-11-07 | ABMD-DELISTED | Stock | 14.59 | 14.8799 | 14.11 | 14.58 | 133154.0 |
| 2008-11-07 | ABR | Stock | 4.4 | 4.95 | 4.33 | 4.4 | 289900.0 |
| 2008-11-07 | ABT | Stock | 25.9092 | 26.7393 | 25.7029 | 26.5329 | 13693622.0 |
| 2008-11-07 | ABTL-DELISTED | Stock | 3.6117 | 4.6368 | 3.6117 | 4.0883 | 5431.0 |
| 2008-11-07 | ABV-DELISTED | Stock | 44.44 | 47.48 | 44.44 | 47.32 | 1306109.0 |
| 2008-11-07 | ABVA-DELISTED | Stock | 3.02 | 3.6 | 3.02 | 3.39 | 9255.0 |
| 2008-11-07 | ABX-DELISTED | Stock | 23.8 | 24.84 | 23.05 | 23.96 | 11300164.0 |
| 2008-11-07 | ACAD | Stock | 1.85 | 1.96 | 1.74 | 1.84 | 55200.0 |
| 2008-11-07 | ACAP-DELISTED | Stock | 36.73 | 38.33 | 35.51 | 38.14 | 76234.0 |
| 2008-11-07 | ACAS-DELISTED | Stock | 13.93 | 14.429 | 13.26 | 13.77 | 2324103.0 |
| 2008-11-07 | ACAT-DELISTED | Stock | 7.83 | 7.9 | 7.6 | 7.64 | 30433.0 |
> showing 50 of 5,699 rows — these rows as CSV