PREVIEW / stock_daily / 2009-05-19
file: by_date/stock_daily/2009/2009-05-19.parquet size: 180 KB rows: 5,795 symbols: 3,467
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-19 | AAPL | Stock | 4.5293 | 4.6182 | 4.4907 | 4.5518 | 372422400.0 |
| 2009-05-19 | MSFT | Stock | 20.51 | 20.74 | 20.25 | 20.31 | 51368300.0 |
| 2009-05-19 | NVDA | Stock | 0.2332 | 0.239 | 0.2295 | 0.2362 | 859768000.0 |
| 2009-05-19 | AMZN | Stock | 3.7715 | 3.948 | 3.756 | 3.8935 | 160578000.0 |
| 2009-05-19 | TLT | Stock | 96.19 | 96.47 | 95.71 | 96.01 | 1624222.0 |
| 2009-05-19 | ES | Stock | 20.62 | 20.93 | 20.57 | 20.75 | 1413100.0 |
| 2009-05-19 | CL | Stock | 32.11 | 32.25 | 31.95 | 32.105 | 6902400.0 |
| 2009-05-19 | A | Stock | 12.7897 | 13.2618 | 12.4249 | 13.1402 | 4224616.0 |
| 2009-05-19 | AABA-DELISTED | Stock | 15.06 | 15.34 | 15.02 | 15.18 | 13030506.0 |
| 2009-05-19 | AACC-DELISTED | Stock | 8.42 | 8.42 | 7.63 | 7.75 | 64213.0 |
| 2009-05-19 | AACG | Stock | 5.09 | 5.1 | 4.61 | 5.05 | 36800.0 |
| 2009-05-19 | AAI-DELISTED | Stock | 6.55 | 6.66 | 6.36 | 6.44 | 1722073.0 |
| 2009-05-19 | AAIC-DELISTED | Stock | 9.0 | 9.4 | 8.624 | 9.0 | 3310055.0 |
| 2009-05-19 | AAME | Stock | 0.79 | 0.99 | 0.79 | 0.82 | 11200.0 |
| 2009-05-19 | AAON | Stock | 4.1225 | 4.1284 | 4.0494 | 4.0988 | 354375.0 |
| 2009-05-19 | AAP | Stock | 43.03 | 44.13 | 43.03 | 43.38 | 3061600.0 |
| 2009-05-19 | AATI-DELISTED | Stock | 4.65 | 4.76 | 4.56 | 4.72 | 168265.0 |
| 2009-05-19 | AAU-DELISTED | Stock | 0.65 | 0.65 | 0.6 | 0.61 | 60813.0 |
| 2009-05-19 | AAUAF-DELISTED | Stock | 0.65 | 0.65 | 0.6 | 0.61 | 60913.0 |
| 2009-05-19 | AAV-DELISTED | Stock | 3.55 | 3.86 | 3.55 | 3.8 | 1177994.0 |
| 2009-05-19 | AAWW-DELISTED | Stock | 24.75 | 25.44 | 23.77 | 24.96 | 702541.0 |
| 2009-05-19 | AAXJ | Stock | 43.56 | 43.86 | 43.13 | 43.47 | 349103.0 |
| 2009-05-19 | AAXN-DELISTED | Stock | 4.38 | 4.45 | 4.24 | 4.27 | 399676.0 |
| 2009-05-19 | AB | Stock | 17.78 | 18.18 | 17.5 | 17.76 | 552700.0 |
| 2009-05-19 | ABAX-DELISTED | Stock | 16.99 | 17.15 | 16.71 | 16.92 | 217516.0 |
| 2009-05-19 | ABB-DELISTED | Stock | 15.67 | 16.04 | 15.49 | 15.82 | 3900706.0 |
| 2009-05-19 | ABBC-DELISTED | Stock | 8.53 | 8.57 | 8.35 | 8.41 | 20773.0 |
| 2009-05-19 | ABBNY-DELISTED | Stock | 15.67 | 16.04 | 15.49 | 15.81 | 4100942.0 |
| 2009-05-19 | ABC-DELISTED | Stock | 17.8 | 18.14 | 17.8 | 18.0 | 3940008.0 |
| 2009-05-19 | ABCB | Stock | 6.507 | 6.5945 | 6.0401 | 6.3221 | 12749.0 |
| 2009-05-19 | ABCO-DELISTED | Stock | 11.44 | 11.44 | 11.18 | 11.43 | 130666.0 |
| 2009-05-19 | ABCW-DELISTED | Stock | 1.7 | 1.72 | 1.65 | 1.67 | 37460.0 |
| 2009-05-19 | ABD-DELISTED | Stock | 3.1 | 3.13 | 2.86 | 3.05 | 259280.0 |
| 2009-05-19 | ABE-DELISTED | Stock | 14.72 | 15.1 | 14.61 | 15.04 | 12810.0 |
| 2009-05-19 | ABEO | Stock | 1875.0 | 2100.0 | 1687.5 | 2100.0 | 10.0 |
| 2009-05-19 | ABFS-DELISTED | Stock | 26.69 | 27.97 | 26.67 | 27.57 | 1288073.0 |
| 2009-05-19 | ABG | Stock | 10.7 | 10.73 | 10.08 | 10.18 | 498100.0 |
| 2009-05-19 | ABII-DELISTED | Stock | 50.0 | 50.64 | 48.69 | 49.0 | 17776.0 |
| 2009-05-19 | ABK-DELISTED | Stock | 1.43 | 1.49 | 1.38 | 1.39 | 9449487.0 |
| 2009-05-19 | ABM | Stock | 16.29 | 16.5 | 15.9 | 16.09 | 254100.0 |
| 2009-05-19 | ABMD-DELISTED | Stock | 6.46 | 6.59 | 5.85 | 5.95 | 827843.0 |
| 2009-05-19 | ABR | Stock | 1.87 | 2.1 | 1.82 | 1.93 | 249400.0 |
| 2009-05-19 | ABT | Stock | 20.7466 | 20.8953 | 20.5114 | 20.5738 | 16563568.0 |
| 2009-05-19 | ABTL-DELISTED | Stock | 2.25 | 2.35 | 2.229 | 2.3 | 14940.0 |
| 2009-05-19 | ABV-DELISTED | Stock | 60.97 | 62.97 | 60.6 | 62.21 | 526973.0 |
| 2009-05-19 | ABVA-DELISTED | Stock | 2.96 | 3.3 | 2.96 | 3.3 | 1985.0 |
| 2009-05-19 | ABVT-DELISTED | Stock | 58.5 | 58.5 | 56.5 | 57.75 | 45269.0 |
| 2009-05-19 | ABX-DELISTED | Stock | 33.79 | 34.56 | 33.01 | 33.96 | 8488453.0 |
| 2009-05-19 | ACAD | Stock | 1.82 | 1.83 | 1.76 | 1.77 | 292000.0 |
| 2009-05-19 | ACAP-DELISTED | Stock | 37.97 | 38.34 | 37.78 | 37.78 | 54390.0 |
> showing 50 of 5,795 rows — these rows as CSV