PREVIEW / stock_daily / 2008-11-18
file: by_date/stock_daily/2008/2008-11-18.parquet size: 175 KB rows: 5,763 symbols: 3,451
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-18 | AAPL | Stock | 3.2014 | 3.2496 | 3.1021 | 3.2111 | 1209695200.0 |
| 2008-11-18 | MSFT | Stock | 19.5 | 19.66 | 18.75 | 19.62 | 108966500.0 |
| 2008-11-18 | NVDA | Stock | 0.179 | 0.18 | 0.164 | 0.1698 | 564488000.0 |
| 2008-11-18 | AMZN | Stock | 1.9865 | 2.033 | 1.804 | 1.922 | 300984000.0 |
| 2008-11-18 | TLT | Stock | 96.38 | 97.0 | 95.96 | 96.82 | 924768.0 |
| 2008-11-18 | CL | Stock | 31.04 | 32.095 | 30.5 | 32.025 | 9638800.0 |
| 2008-11-18 | A | Stock | 13.7554 | 13.927 | 13.0186 | 13.5908 | 4217207.0 |
| 2008-11-18 | AABA-DELISTED | Stock | 11.93 | 12.4 | 11.0 | 11.53 | 50120156.0 |
| 2008-11-18 | AACC-DELISTED | Stock | 5.81 | 6.31 | 5.57 | 5.87 | 101534.0 |
| 2008-11-18 | AACG | Stock | 5.5 | 5.69 | 5.48 | 5.5 | 22200.0 |
| 2008-11-18 | AAI-DELISTED | Stock | 3.6 | 3.87 | 3.52 | 3.86 | 2772447.0 |
| 2008-11-18 | AAIC-DELISTED | Stock | 9.2 | 10.0 | 6.8 | 7.8 | 769052.0 |
| 2008-11-18 | AAME | Stock | 0.95 | 1.0 | 0.94 | 0.99 | 3200.0 |
| 2008-11-18 | AAON | Stock | 3.277 | 3.4963 | 3.1763 | 3.4291 | 595350.0 |
| 2008-11-18 | AAP | Stock | 25.87 | 26.89 | 25.29 | 26.55 | 1136600.0 |
| 2008-11-18 | AATI-DELISTED | Stock | 2.73 | 2.75 | 2.35 | 2.48 | 532676.0 |
| 2008-11-18 | AAU-DELISTED | Stock | 0.47 | 0.51 | 0.42 | 0.45 | 128178.0 |
| 2008-11-18 | AAUAF-DELISTED | Stock | 0.47 | 0.5099 | 0.42 | 0.4499 | 129723.0 |
| 2008-11-18 | AAV-DELISTED | Stock | 5.1 | 5.2 | 4.98 | 5.06 | 992150.0 |
| 2008-11-18 | AAWW-DELISTED | Stock | 15.24 | 15.26 | 10.38 | 10.99 | 1108998.0 |
| 2008-11-18 | AAXJ | Stock | 29.5 | 29.71 | 28.3 | 29.29 | 1420179.0 |
| 2008-11-18 | AAXN-DELISTED | Stock | 3.53 | 3.7 | 3.42 | 3.57 | 562275.0 |
| 2008-11-18 | AB | Stock | 15.64 | 16.7 | 15.53 | 15.95 | 472000.0 |
| 2008-11-18 | ABAX-DELISTED | Stock | 14.22 | 14.59 | 13.9 | 14.38 | 141089.0 |
| 2008-11-18 | ABB-DELISTED | Stock | 10.6 | 10.81 | 10.2 | 10.56 | 5258477.0 |
| 2008-11-18 | ABBC-DELISTED | Stock | 9.81 | 10.2 | 9.3 | 10.05 | 95109.0 |
| 2008-11-18 | ABBNY-DELISTED | Stock | 10.6 | 10.81 | 10.2 | 10.55 | 5260197.0 |
| 2008-11-18 | ABC-DELISTED | Stock | 15.16 | 15.54 | 14.96 | 15.36 | 4896004.0 |
| 2008-11-18 | ABCB | Stock | 8.7538 | 8.9386 | 8.2675 | 8.9094 | 23236.0 |
| 2008-11-18 | ABCO-DELISTED | Stock | 11.08 | 11.08 | 10.191 | 10.465 | 285533.0 |
| 2008-11-18 | ABCW-DELISTED | Stock | 3.71 | 3.89 | 2.9 | 3.2 | 191820.0 |
| 2008-11-18 | ABD-DELISTED | Stock | 0.91 | 1.03 | 0.7295 | 0.79 | 5871980.0 |
| 2008-11-18 | ABE-DELISTED | Stock | 11.57 | 11.59 | 11.4125 | 11.52 | 19031.0 |
| 2008-11-18 | ABEO | Stock | 1687.5 | 1687.5 | 1500.0 | 1562.5 | 6.0 |
| 2008-11-18 | ABFS-DELISTED | Stock | 23.88 | 24.06 | 22.02 | 22.6 | 456783.0 |
| 2008-11-18 | ABG | Stock | 3.11 | 3.58 | 3.1 | 3.54 | 537000.0 |
| 2008-11-18 | ABII-DELISTED | Stock | 57.94 | 59.93 | 56.82 | 57.77 | 10322.0 |
| 2008-11-18 | ABK-DELISTED | Stock | 1.25 | 1.26 | 1.06 | 1.14 | 14934947.0 |
| 2008-11-18 | ABM | Stock | 14.6 | 15.35 | 13.74 | 14.33 | 206200.0 |
| 2008-11-18 | ABMD-DELISTED | Stock | 13.8 | 14.4 | 13.26 | 13.66 | 292026.0 |
| 2008-11-18 | ABR | Stock | 3.62 | 3.97 | 3.25 | 3.97 | 376500.0 |
| 2008-11-18 | ABT | Stock | 26.768 | 27.291 | 26.1491 | 27.1423 | 23398499.0 |
| 2008-11-18 | ABTL-DELISTED | Stock | 2.6 | 3.4 | 2.6 | 3.35 | 5708.0 |
| 2008-11-18 | ABV-DELISTED | Stock | 45.56 | 46.9 | 44.33 | 46.82 | 1040594.0 |
| 2008-11-18 | ABVA-DELISTED | Stock | 3.26 | 3.45 | 2.73 | 2.91 | 3200.0 |
| 2008-11-18 | ABX-DELISTED | Stock | 21.27 | 22.08 | 20.5 | 20.98 | 11753351.0 |
| 2008-11-18 | ACAD | Stock | 1.41 | 1.58 | 1.19 | 1.19 | 109900.0 |
| 2008-11-18 | ACAP-DELISTED | Stock | 38.07 | 39.09 | 36.78 | 37.96 | 78028.0 |
| 2008-11-18 | ACAS-DELISTED | Stock | 6.01 | 6.48 | 5.931 | 6.28 | 3709085.0 |
| 2008-11-18 | ACAT-DELISTED | Stock | 6.5 | 6.5 | 6.09 | 6.24 | 16514.0 |
> showing 50 of 5,763 rows — these rows as CSV