PREVIEW / stock_daily / 2008-11-17
file: by_date/stock_daily/2008/2008-11-17.parquet size: 174 KB rows: 5,727 symbols: 3,426
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-17 | AAPL | Stock | 3.16 | 3.2339 | 3.1164 | 3.1479 | 1162526400.0 |
| 2008-11-17 | MSFT | Stock | 19.74 | 20.24 | 19.15 | 19.32 | 97289000.0 |
| 2008-11-17 | NVDA | Stock | 0.1775 | 0.1823 | 0.1738 | 0.1755 | 388224000.0 |
| 2008-11-17 | AMZN | Stock | 1.9955 | 2.063 | 1.9535 | 1.9845 | 214236000.0 |
| 2008-11-17 | TLT | Stock | 95.68 | 96.03 | 95.29 | 95.6 | 490511.0 |
| 2008-11-17 | CL | Stock | 30.705 | 32.215 | 30.705 | 31.04 | 6938200.0 |
| 2008-11-17 | A | Stock | 14.1631 | 14.3562 | 13.3763 | 13.6767 | 6550189.0 |
| 2008-11-17 | AABA-DELISTED | Stock | 10.5 | 10.94 | 10.3175 | 10.63 | 14470970.0 |
| 2008-11-17 | AACC-DELISTED | Stock | 6.01 | 6.25 | 5.76 | 5.76 | 91559.0 |
| 2008-11-17 | AACG | Stock | 5.39 | 5.76 | 5.31 | 5.5 | 62600.0 |
| 2008-11-17 | AAI-DELISTED | Stock | 3.43 | 3.72 | 3.41 | 3.59 | 2240118.0 |
| 2008-11-17 | AAIC-DELISTED | Stock | 10.0 | 10.2 | 7.6 | 9.4 | 446246.0 |
| 2008-11-17 | AAME | Stock | 0.95 | 0.95 | 0.89 | 0.9 | 2100.0 |
| 2008-11-17 | AAON | Stock | 3.2553 | 3.4193 | 3.2119 | 3.2711 | 1038319.0 |
| 2008-11-17 | AAP | Stock | 26.0 | 26.92 | 25.45 | 25.81 | 1040400.0 |
| 2008-11-17 | AATI-DELISTED | Stock | 2.75 | 2.8 | 2.66 | 2.73 | 265069.0 |
| 2008-11-17 | AAU-DELISTED | Stock | 0.55 | 0.55 | 0.46 | 0.48 | 60715.0 |
| 2008-11-17 | AAUAF-DELISTED | Stock | 0.55 | 0.55 | 0.46 | 0.48 | 62565.0 |
| 2008-11-17 | AAV-DELISTED | Stock | 5.29 | 5.29 | 5.01 | 5.01 | 974749.0 |
| 2008-11-17 | AAWW-DELISTED | Stock | 15.74 | 16.42 | 14.97 | 15.16 | 300881.0 |
| 2008-11-17 | AAXJ | Stock | 30.3 | 30.8 | 29.82 | 29.94 | 177061.0 |
| 2008-11-17 | AAXN-DELISTED | Stock | 3.75 | 3.85 | 3.52 | 3.55 | 350020.0 |
| 2008-11-17 | AB | Stock | 17.12 | 17.68 | 15.75 | 15.84 | 458000.0 |
| 2008-11-17 | ABAX-DELISTED | Stock | 14.39 | 14.76 | 14.1 | 14.18 | 163835.0 |
| 2008-11-17 | ABB-DELISTED | Stock | 10.98 | 11.25 | 10.6 | 10.83 | 4243414.0 |
| 2008-11-17 | ABBC-DELISTED | Stock | 9.71 | 10.1 | 9.67 | 9.81 | 41779.0 |
| 2008-11-17 | ABBNY-DELISTED | Stock | 10.98 | 11.25 | 10.6 | 10.83 | 4245314.0 |
| 2008-11-17 | ABC-DELISTED | Stock | 14.86 | 15.62 | 14.79 | 15.26 | 5635010.0 |
| 2008-11-17 | ABCB | Stock | 8.4522 | 9.2596 | 8.4522 | 8.7927 | 11104.0 |
| 2008-11-17 | ABCO-DELISTED | Stock | 10.712 | 11.117 | 10.398 | 10.653 | 178758.0 |
| 2008-11-17 | ABCW-DELISTED | Stock | 3.7499 | 3.9577 | 3.6015 | 3.74 | 116830.0 |
| 2008-11-17 | ABD-DELISTED | Stock | 1.18 | 1.18 | 0.89 | 0.91 | 344200.0 |
| 2008-11-17 | ABE-DELISTED | Stock | 11.79 | 12.2 | 11.51 | 11.8 | 5952.0 |
| 2008-11-17 | ABEO | Stock | 1812.5 | 1812.5 | 1562.5 | 1562.5 | 6.0 |
| 2008-11-17 | ABFS-DELISTED | Stock | 23.75 | 24.69 | 23.06 | 23.85 | 251075.0 |
| 2008-11-17 | ABG | Stock | 3.79 | 3.79 | 3.09 | 3.11 | 334700.0 |
| 2008-11-17 | ABII-DELISTED | Stock | 61.5 | 61.56 | 60.19 | 60.54 | 12281.0 |
| 2008-11-17 | ABK-DELISTED | Stock | 1.35 | 1.38 | 1.23 | 1.24 | 7468174.0 |
| 2008-11-17 | ABM | Stock | 14.41 | 15.24 | 14.06 | 14.59 | 127300.0 |
| 2008-11-17 | ABMD-DELISTED | Stock | 13.78 | 14.12 | 13.53 | 13.81 | 159508.0 |
| 2008-11-17 | ABR | Stock | 3.8 | 4.14 | 3.5 | 3.6 | 156900.0 |
| 2008-11-17 | ABT | Stock | 26.0627 | 27.2095 | 25.9524 | 26.5425 | 16899541.0 |
| 2008-11-17 | ABTL-DELISTED | Stock | 3.2 | 3.26 | 2.75 | 3.05 | 5749.0 |
| 2008-11-17 | ABV-DELISTED | Stock | 46.21 | 47.88 | 45.11 | 45.28 | 1033488.0 |
| 2008-11-17 | ABVA-DELISTED | Stock | 3.14 | 3.45 | 2.65 | 3.45 | 8369.0 |
| 2008-11-17 | ABX-DELISTED | Stock | 21.81 | 22.48 | 20.65 | 21.19 | 11668932.0 |
| 2008-11-17 | ACAD | Stock | 1.41 | 1.74 | 1.4 | 1.4 | 56900.0 |
| 2008-11-17 | ACAP-DELISTED | Stock | 37.94 | 39.91 | 36.8 | 37.95 | 113952.0 |
| 2008-11-17 | ACAS-DELISTED | Stock | 6.03 | 6.44 | 5.87 | 6.01 | 3668173.0 |
| 2008-11-17 | ACAT-DELISTED | Stock | 6.2 | 6.5 | 6.07 | 6.44 | 44179.0 |
> showing 50 of 5,727 rows — these rows as CSV