PREVIEW / stock_daily / 2015-11-12
file: by_date/stock_daily/2015/2015-11-12.parquet size: 221 KB rows: 6,614 symbols: 3,399
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-12 | AAPL | Stock | 29.065 | 29.205 | 28.9125 | 28.93 | 130102400.0 |
| 2015-11-12 | MSFT | Stock | 53.48 | 53.98 | 53.19 | 53.32 | 35361100.0 |
| 2015-11-12 | NVDA | Stock | 0.761 | 0.768 | 0.7568 | 0.76 | 291080000.0 |
| 2015-11-12 | AMZN | Stock | 33.65 | 33.782 | 33.211 | 33.28 | 85694000.0 |
| 2015-11-12 | GOOGL | Stock | 38.009 | 38.29 | 37.793 | 37.8265 | 35451100.0 |
| 2015-11-12 | META | Stock | 108.48 | 109.39 | 108.0 | 108.02 | 20924700.0 |
| 2015-11-12 | TSLA | Stock | 14.5233 | 14.6 | 14.1773 | 14.196 | 43738500.0 |
| 2015-11-12 | TLT | Stock | 118.75 | 119.44 | 118.7 | 119.0 | 6805727.0 |
| 2015-11-12 | ES | Stock | 50.66 | 51.38 | 50.16 | 50.23 | 1552700.0 |
| 2015-11-12 | CL | Stock | 66.15 | 66.32 | 65.24 | 65.27 | 2811200.0 |
| 2015-11-12 | A | Stock | 37.36 | 37.77 | 37.24 | 37.49 | 3096300.0 |
| 2015-11-12 | AA.B-DELISTED | Stock | 29.75 | 29.75 | 28.89 | 29.1 | 34277.0 |
| 2015-11-12 | AAAP-DELISTED | Stock | 24.25 | 27.12 | 22.5 | 25.0 | 83061.0 |
| 2015-11-12 | AABA-DELISTED | Stock | 33.2 | 33.845 | 31.38 | 33.23 | 12991312.0 |
| 2015-11-12 | AAC-DELISTED | Stock | 22.29 | 22.65 | 22.15 | 22.51 | 147213.0 |
| 2015-11-12 | AACG | Stock | 4.17 | 4.38 | 4.08 | 4.23 | 26400.0 |
| 2015-11-12 | AAIC-DELISTED | Stock | 13.73 | 13.79 | 13.51 | 13.57 | 190470.0 |
| 2015-11-12 | AAL | Stock | 44.29 | 44.52 | 43.82 | 43.9 | 5951100.0 |
| 2015-11-12 | AAMC-DELISTED | Stock | 6.0382 | 6.1235 | 5.6206 | 5.6382 | 49745.0 |
| 2015-11-12 | AAME | Stock | 4.9 | 4.98 | 4.76 | 4.94 | 2700.0 |
| 2015-11-12 | AAMI | Stock | 16.46 | 16.46 | 16.09 | 16.39 | 305000.0 |
| 2015-11-12 | AAOI | Stock | 16.59 | 16.713 | 15.99 | 16.11 | 379800.0 |
| 2015-11-12 | AAON | Stock | 16.3533 | 16.3733 | 15.76 | 16.02 | 339750.0 |
| 2015-11-12 | AAP | Stock | 173.75 | 177.0 | 164.23 | 164.64 | 6955600.0 |
| 2015-11-12 | AAT | Stock | 39.78 | 39.89 | 39.5 | 39.71 | 127600.0 |
| 2015-11-12 | AAU-DELISTED | Stock | 0.532 | 0.55 | 0.53 | 0.55 | 47850.0 |
| 2015-11-12 | AAUAF-DELISTED | Stock | 0.532 | 0.55 | 0.53 | 0.55 | 45986.0 |
| 2015-11-12 | AAV-DELISTED | Stock | 5.42 | 5.5 | 5.3 | 5.36 | 138887.0 |
| 2015-11-12 | AAVL-DELISTED | Stock | 7.81 | 7.95 | 7.61 | 7.785 | 225820.0 |
| 2015-11-12 | AAWW-DELISTED | Stock | 40.12 | 40.885 | 39.38 | 39.57 | 236587.0 |
| 2015-11-12 | AAXJ | Stock | 55.63 | 55.82 | 55.26 | 55.3 | 573962.0 |
| 2015-11-12 | AAXN-DELISTED | Stock | 18.38 | 18.47 | 18.07 | 18.11 | 1235047.0 |
| 2015-11-12 | AB | Stock | 24.91 | 25.23 | 24.85 | 25.0 | 101500.0 |
| 2015-11-12 | ABAC-DELISTED | Stock | 0.6399 | 0.6399 | 0.61 | 0.62 | 4500.0 |
| 2015-11-12 | ABAX-DELISTED | Stock | 53.25 | 53.75 | 51.1 | 51.51 | 230799.0 |
| 2015-11-12 | ABB-DELISTED | Stock | 18.53 | 18.72 | 18.49 | 18.5 | 1294778.0 |
| 2015-11-12 | ABBNY-DELISTED | Stock | 18.53 | 18.72 | 18.49 | 18.5 | 1366986.0 |
| 2015-11-12 | ABBV | Stock | 60.79 | 61.73 | 60.15 | 60.23 | 7765500.0 |
| 2015-11-12 | ABC-DELISTED | Stock | 96.29 | 98.38 | 96.29 | 96.91 | 1695336.0 |
| 2015-11-12 | ABCB | Stock | 33.04 | 33.35 | 32.68 | 32.9 | 135900.0 |
| 2015-11-12 | ABCD-DELISTED | Stock | 5.07 | 5.97 | 5.07 | 5.42 | 141765.0 |
| 2015-11-12 | ABCO-DELISTED | Stock | 52.97 | 53.44 | 52.48 | 53.01 | 200743.0 |
| 2015-11-12 | ABCW-DELISTED | Stock | 41.76 | 41.96 | 40.74 | 40.795 | 16066.0 |
| 2015-11-12 | ABDC-DELISTED | Stock | 12.0 | 12.39 | 11.95 | 12.07 | 38612.0 |
| 2015-11-12 | ABE-DELISTED | Stock | 11.12 | 11.3 | 11.12 | 11.24 | 16234.0 |
| 2015-11-12 | ABEO | Stock | 105.0 | 111.0 | 102.0 | 102.75 | 4636.0 |
| 2015-11-12 | ABEOW-DELISTED | Stock | 1.45 | 1.78 | 1.45 | 1.6493 | 7400.0 |
| 2015-11-12 | ABEV | Stock | 4.93 | 5.04 | 4.91 | 4.95 | 18851700.0 |
| 2015-11-12 | ABG | Stock | 75.0 | 75.47 | 72.53 | 72.57 | 618700.0 |
| 2015-11-12 | ABGB-DELISTED | Stock | 5.09 | 5.2601 | 5.0 | 5.25 | 15484.0 |
> showing 50 of 6,614 rows — these rows as CSV