PREVIEW / stock_daily / 2015-11-24
file: by_date/stock_daily/2015/2015-11-24.parquet size: 222 KB rows: 6,638 symbols: 3,415
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-24 | AAPL | Stock | 29.3325 | 29.8375 | 29.28 | 29.72 | 171212800.0 |
| 2015-11-24 | MSFT | Stock | 53.92 | 54.44 | 53.58 | 54.25 | 24600000.0 |
| 2015-11-24 | NVDA | Stock | 0.773 | 0.786 | 0.7695 | 0.7793 | 195428000.0 |
| 2015-11-24 | AMZN | Stock | 33.707 | 33.79 | 33.0605 | 33.5575 | 90868000.0 |
| 2015-11-24 | GOOGL | Stock | 38.648 | 38.7995 | 37.9055 | 38.4815 | 47880200.0 |
| 2015-11-24 | META | Stock | 106.0 | 106.49 | 104.39 | 105.74 | 23577300.0 |
| 2015-11-24 | TSLA | Stock | 14.358 | 14.7333 | 14.3333 | 14.55 | 37204500.0 |
| 2015-11-24 | TLT | Stock | 120.9 | 121.2 | 120.58 | 120.81 | 3371479.0 |
| 2015-11-24 | ES | Stock | 50.84 | 50.91 | 50.38 | 50.65 | 1671600.0 |
| 2015-11-24 | CL | Stock | 66.43 | 67.09 | 66.42 | 66.82 | 2242000.0 |
| 2015-11-24 | A | Stock | 39.81 | 40.72 | 39.73 | 40.67 | 5669100.0 |
| 2015-11-24 | AA.B-DELISTED | Stock | 31.13 | 31.9899 | 31.13 | 31.9 | 49372.0 |
| 2015-11-24 | AAAP-DELISTED | Stock | 25.21 | 27.0 | 25.09 | 25.62 | 53812.0 |
| 2015-11-24 | AABA-DELISTED | Stock | 33.09 | 33.19 | 32.61 | 32.95 | 12675725.0 |
| 2015-11-24 | AAC-DELISTED | Stock | 23.66 | 24.89 | 23.66 | 23.94 | 114952.0 |
| 2015-11-24 | AACG | Stock | 5.27 | 5.48 | 4.6 | 5.11 | 25200.0 |
| 2015-11-24 | AAIC-DELISTED | Stock | 13.42 | 13.78 | 13.42 | 13.76 | 141140.0 |
| 2015-11-24 | AAL | Stock | 41.02 | 41.64 | 40.45 | 41.23 | 7578000.0 |
| 2015-11-24 | AAMC-DELISTED | Stock | 3.8294 | 4.5294 | 3.8235 | 4.1529 | 124566.0 |
| 2015-11-24 | AAME | Stock | 4.58 | 4.63 | 4.52 | 4.6 | 1200.0 |
| 2015-11-24 | AAMI | Stock | 15.97 | 16.17 | 15.86 | 16.13 | 125500.0 |
| 2015-11-24 | AAOI | Stock | 18.37 | 18.877 | 18.34 | 18.52 | 224500.0 |
| 2015-11-24 | AAON | Stock | 16.1867 | 16.5733 | 16.1867 | 16.5133 | 205950.0 |
| 2015-11-24 | AAP | Stock | 160.82 | 163.86 | 160.82 | 163.19 | 754500.0 |
| 2015-11-24 | AAT | Stock | 39.91 | 40.04 | 39.44 | 39.96 | 105300.0 |
| 2015-11-24 | AAU-DELISTED | Stock | 0.51 | 0.5294 | 0.5 | 0.525 | 47679.0 |
| 2015-11-24 | AAUAF-DELISTED | Stock | 0.51 | 0.5294 | 0.5 | 0.525 | 48102.0 |
| 2015-11-24 | AAV-DELISTED | Stock | 5.29 | 5.48 | 5.29 | 5.43 | 43910.0 |
| 2015-11-24 | AAVL-DELISTED | Stock | 9.07 | 9.59 | 8.98 | 9.51 | 311477.0 |
| 2015-11-24 | AAWW-DELISTED | Stock | 40.46 | 41.29 | 39.91 | 41.06 | 94651.0 |
| 2015-11-24 | AAXJ | Stock | 55.78 | 56.45 | 55.71 | 56.33 | 844689.0 |
| 2015-11-24 | AAXN-DELISTED | Stock | 19.48 | 19.84 | 18.78 | 19.32 | 3185635.0 |
| 2015-11-24 | AB | Stock | 25.67 | 26.2 | 25.59 | 25.79 | 213300.0 |
| 2015-11-24 | ABAC-DELISTED | Stock | 0.669 | 0.68 | 0.65 | 0.68 | 7288.0 |
| 2015-11-24 | ABAX-DELISTED | Stock | 54.57 | 54.8899 | 53.2 | 53.49 | 179710.0 |
| 2015-11-24 | ABB-DELISTED | Stock | 18.585 | 18.7376 | 18.54 | 18.69 | 2051485.0 |
| 2015-11-24 | ABBNY-DELISTED | Stock | 18.585 | 18.7376 | 18.54 | 18.7 | 2110445.0 |
| 2015-11-24 | ABBV | Stock | 60.56 | 61.65 | 60.53 | 61.13 | 5213500.0 |
| 2015-11-24 | ABC-DELISTED | Stock | 98.16 | 98.62 | 97.75 | 98.51 | 1445778.0 |
| 2015-11-24 | ABCB | Stock | 33.86 | 34.24 | 33.51 | 33.61 | 158100.0 |
| 2015-11-24 | ABCD-DELISTED | Stock | 5.14 | 5.14 | 4.92 | 5.05 | 58945.0 |
| 2015-11-24 | ABCO-DELISTED | Stock | 51.23 | 52.2974 | 50.96 | 52.14 | 231222.0 |
| 2015-11-24 | ABCW-DELISTED | Stock | 41.53 | 42.0 | 41.53 | 42.0 | 5548.0 |
| 2015-11-24 | ABDC-DELISTED | Stock | 11.89 | 12.23 | 11.7899 | 11.94 | 20826.0 |
| 2015-11-24 | ABE-DELISTED | Stock | 11.25 | 11.37 | 11.24 | 11.34 | 5538.0 |
| 2015-11-24 | ABEO | Stock | 111.0 | 113.75 | 109.0 | 113.0 | 2520.0 |
| 2015-11-24 | ABEV | Stock | 5.05 | 5.1 | 5.02 | 5.06 | 12119700.0 |
| 2015-11-24 | ABG | Stock | 73.77 | 76.33 | 73.57 | 75.84 | 344400.0 |
| 2015-11-24 | ABGB-DELISTED | Stock | 4.72 | 4.85 | 4.54 | 4.695 | 69196.0 |
| 2015-11-24 | ABIL-DELISTED | Stock | 10.075 | 10.1 | 10.05 | 10.08 | 50916.0 |
> showing 50 of 6,638 rows — these rows as CSV