PREVIEW / stock_daily / 2008-11-19
file: by_date/stock_daily/2008/2008-11-19.parquet size: 173 KB rows: 5,745 symbols: 3,443
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-19 | AAPL | Stock | 3.1943 | 3.2707 | 3.0789 | 3.0818 | 1171900800.0 |
| 2008-11-19 | MSFT | Stock | 19.63 | 19.95 | 18.25 | 18.29 | 103010500.0 |
| 2008-11-19 | NVDA | Stock | 0.1682 | 0.1725 | 0.155 | 0.1558 | 500220000.0 |
| 2008-11-19 | AMZN | Stock | 1.8985 | 1.95 | 1.7875 | 1.792 | 250422000.0 |
| 2008-11-19 | TLT | Stock | 97.47 | 99.37 | 97.21 | 99.3 | 2090312.0 |
| 2008-11-19 | CL | Stock | 32.0 | 32.61 | 31.495 | 31.495 | 9961400.0 |
| 2008-11-19 | A | Stock | 13.5122 | 13.8555 | 12.6109 | 12.618 | 3697570.0 |
| 2008-11-19 | AABA-DELISTED | Stock | 11.54 | 11.58 | 9.07 | 9.15 | 55675417.0 |
| 2008-11-19 | AACC-DELISTED | Stock | 5.74 | 5.81 | 5.45 | 5.47 | 81274.0 |
| 2008-11-19 | AACG | Stock | 5.3 | 5.69 | 4.8 | 5.48 | 56100.0 |
| 2008-11-19 | AAI-DELISTED | Stock | 3.75 | 3.93 | 3.24 | 3.28 | 4177023.0 |
| 2008-11-19 | AAIC-DELISTED | Stock | 7.8 | 7.8 | 4.4 | 5.0 | 1277366.0 |
| 2008-11-19 | AAME | Stock | 1.0 | 1.0 | 0.75 | 0.76 | 3900.0 |
| 2008-11-19 | AAON | Stock | 3.4311 | 3.5121 | 3.1921 | 3.202 | 546750.0 |
| 2008-11-19 | AAP | Stock | 26.49 | 27.28 | 26.49 | 26.66 | 2964600.0 |
| 2008-11-19 | AATI-DELISTED | Stock | 2.38 | 2.53 | 2.13 | 2.3 | 353330.0 |
| 2008-11-19 | AAU-DELISTED | Stock | 0.42 | 0.46 | 0.39 | 0.4 | 163750.0 |
| 2008-11-19 | AAUAF-DELISTED | Stock | 0.42 | 0.46 | 0.39 | 0.4 | 165200.0 |
| 2008-11-19 | AAV-DELISTED | Stock | 5.17 | 5.23 | 4.88 | 4.92 | 846066.0 |
| 2008-11-19 | AAWW-DELISTED | Stock | 10.81 | 11.72 | 10.65 | 11.11 | 1122465.0 |
| 2008-11-19 | AAXJ | Stock | 28.94 | 28.94 | 27.0 | 27.0 | 669703.0 |
| 2008-11-19 | AAXN-DELISTED | Stock | 3.65 | 3.65 | 2.92 | 2.93 | 828904.0 |
| 2008-11-19 | AB | Stock | 16.0 | 16.0 | 14.0 | 14.13 | 562100.0 |
| 2008-11-19 | ABAX-DELISTED | Stock | 14.29 | 14.44 | 12.83 | 12.91 | 125504.0 |
| 2008-11-19 | ABB-DELISTED | Stock | 10.3 | 10.47 | 9.69 | 9.73 | 7854297.0 |
| 2008-11-19 | ABBC-DELISTED | Stock | 9.94 | 10.2 | 9.61 | 9.63 | 70148.0 |
| 2008-11-19 | ABBNY-DELISTED | Stock | 10.3 | 10.47 | 9.69 | 9.7 | 7854397.0 |
| 2008-11-19 | ABC-DELISTED | Stock | 15.41 | 15.61 | 14.83 | 14.85 | 4524840.0 |
| 2008-11-19 | ABCB | Stock | 8.7732 | 8.9483 | 7.7811 | 7.7811 | 18712.0 |
| 2008-11-19 | ABCO-DELISTED | Stock | 10.422 | 10.777 | 9.913 | 9.923 | 198111.0 |
| 2008-11-19 | ABCW-DELISTED | Stock | 3.11 | 3.18 | 2.65 | 2.69 | 153990.0 |
| 2008-11-19 | ABD-DELISTED | Stock | 0.79 | 1.16 | 0.79 | 1.09 | 1199900.0 |
| 2008-11-19 | ABE-DELISTED | Stock | 11.39 | 11.412 | 10.72 | 10.73 | 11687.0 |
| 2008-11-19 | ABEO | Stock | 1437.5 | 1500.0 | 1375.0 | 1437.5 | 16.0 |
| 2008-11-19 | ABFS-DELISTED | Stock | 22.61 | 23.0 | 20.38 | 20.52 | 731262.0 |
| 2008-11-19 | ABG | Stock | 3.52 | 3.98 | 3.36 | 3.74 | 807500.0 |
| 2008-11-19 | ABII-DELISTED | Stock | 59.95 | 59.95 | 53.09 | 55.3 | 20210.0 |
| 2008-11-19 | ABK-DELISTED | Stock | 1.1 | 1.1 | 0.76 | 0.77 | 22536554.0 |
| 2008-11-19 | ABM | Stock | 14.32 | 14.55 | 13.73 | 13.8 | 287100.0 |
| 2008-11-19 | ABMD-DELISTED | Stock | 13.63 | 14.13 | 12.22 | 12.4 | 203856.0 |
| 2008-11-19 | ABR | Stock | 3.7 | 3.71 | 2.43 | 2.84 | 561700.0 |
| 2008-11-19 | ABT | Stock | 27.1087 | 27.4781 | 26.1107 | 26.1587 | 21407878.0 |
| 2008-11-19 | ABTL-DELISTED | Stock | 3.0 | 3.25 | 2.45 | 2.5 | 545661.0 |
| 2008-11-19 | ABV-DELISTED | Stock | 45.01 | 45.48 | 41.55 | 41.58 | 1044493.0 |
| 2008-11-19 | ABVA-DELISTED | Stock | 3.2 | 3.2 | 2.56 | 3.15 | 3566.0 |
| 2008-11-19 | ABX-DELISTED | Stock | 21.33 | 22.57 | 20.83 | 21.15 | 19114588.0 |
| 2008-11-19 | ACAD | Stock | 1.18 | 1.23 | 0.99 | 0.99 | 77900.0 |
| 2008-11-19 | ACAP-DELISTED | Stock | 37.66 | 38.4 | 34.92 | 35.16 | 81198.0 |
| 2008-11-19 | ACAS-DELISTED | Stock | 6.09 | 6.25 | 5.3 | 5.33 | 5232457.0 |
| 2008-11-19 | ACAT-DELISTED | Stock | 6.19 | 6.2 | 5.25 | 5.27 | 43966.0 |
> showing 50 of 5,745 rows — these rows as CSV