PREVIEW / stock_daily / 2017-06-28
file: by_date/stock_daily/2017/2017-06-28.parquet size: 215 KB rows: 6,455 symbols: 2,986
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 |
|---|---|---|---|---|---|---|---|
| 2017-06-28 | AAPL | Stock | 36.1225 | 36.5275 | 35.79 | 36.4575 | 88329600.0 |
| 2017-06-28 | MSFT | Stock | 69.21 | 69.84 | 68.79 | 69.8 | 25806200.0 |
| 2017-06-28 | NVDA | Stock | 3.733 | 3.7985 | 3.6438 | 3.7938 | 994948000.0 |
| 2017-06-28 | AMZN | Stock | 48.9275 | 49.534 | 48.4605 | 49.5165 | 74752000.0 |
| 2017-06-28 | GOOGL | Stock | 47.533 | 48.162 | 46.808 | 48.0505 | 54911360.0 |
| 2017-06-28 | META | Stock | 150.92 | 153.47 | 149.86 | 153.24 | 16719100.0 |
| 2017-06-28 | TSLA | Stock | 24.4453 | 24.7827 | 24.168 | 24.7493 | 94537500.0 |
| 2017-06-28 | TLT | Stock | 126.67 | 126.71 | 125.98 | 126.47 | 7357931.0 |
| 2017-06-28 | ES | Stock | 62.26 | 62.3 | 61.19 | 61.23 | 985500.0 |
| 2017-06-28 | CL | Stock | 75.69 | 75.83 | 75.0 | 75.09 | 2078600.0 |
| 2017-06-28 | A | Stock | 59.27 | 59.7 | 59.2 | 59.4 | 1191500.0 |
| 2017-06-28 | AA | Stock | 32.1 | 33.0 | 31.93 | 32.95 | 3769000.0 |
| 2017-06-28 | AAAP-DELISTED | Stock | 37.91 | 39.08 | 37.91 | 38.95 | 23655.0 |
| 2017-06-28 | AABA-DELISTED | Stock | 54.09 | 55.1 | 53.765 | 54.95 | 13046140.0 |
| 2017-06-28 | AAC-DELISTED | Stock | 6.9 | 7.27 | 6.9 | 6.98 | 33168.0 |
| 2017-06-28 | AACG | Stock | 4.82 | 4.82 | 4.81 | 4.82 | 1600.0 |
| 2017-06-28 | AAIC-DELISTED | Stock | 14.11 | 14.1896 | 13.7 | 13.81 | 1042667.0 |
| 2017-06-28 | AAL | Stock | 48.82 | 49.8 | 48.81 | 49.25 | 4259700.0 |
| 2017-06-28 | AAM.A-DELISTED | Stock | 25.73 | 25.79 | 25.63 | 25.65 | 222216.0 |
| 2017-06-28 | AAMC-DELISTED | Stock | 26.0441 | 26.3529 | 25.5735 | 25.8824 | 37002.0 |
| 2017-06-28 | AAMI | Stock | 15.11 | 15.27 | 15.01 | 15.14 | 617200.0 |
| 2017-06-28 | AAOI | Stock | 59.62 | 61.19 | 58.0 | 61.0 | 1986100.0 |
| 2017-06-28 | AAON | Stock | 24.0 | 24.2 | 23.7867 | 24.2 | 263850.0 |
| 2017-06-28 | AAP | Stock | 119.75 | 120.6 | 116.63 | 116.71 | 2106100.0 |
| 2017-06-28 | AAT | Stock | 40.34 | 40.63 | 40.12 | 40.15 | 261100.0 |
| 2017-06-28 | AAU-DELISTED | Stock | 1.32 | 1.34 | 1.31 | 1.325 | 101090.0 |
| 2017-06-28 | AAUAF-DELISTED | Stock | 1.32 | 1.34 | 1.31 | 1.32 | 102517.0 |
| 2017-06-28 | AAV-DELISTED | Stock | 6.5 | 6.65 | 6.45 | 6.6 | 70967.0 |
| 2017-06-28 | AAWW-DELISTED | Stock | 51.3 | 52.5 | 51.15 | 51.6 | 307118.0 |
| 2017-06-28 | AAXJ | Stock | 67.84 | 68.01 | 67.65 | 67.9 | 3285215.0 |
| 2017-06-28 | AAXN-DELISTED | Stock | 25.61 | 26.02 | 25.52 | 25.855 | 293903.0 |
| 2017-06-28 | AB | Stock | 23.25 | 23.53 | 23.18 | 23.35 | 254200.0 |
| 2017-06-28 | ABAC-DELISTED | Stock | 2.099 | 2.18 | 2.0 | 2.0501 | 24138.0 |
| 2017-06-28 | ABAX-DELISTED | Stock | 53.48 | 54.05 | 53.0 | 53.71 | 68004.0 |
| 2017-06-28 | ABB-DELISTED | Stock | 25.12 | 25.21 | 25.03 | 25.18 | 2212814.0 |
| 2017-06-28 | ABBNY-DELISTED | Stock | 25.12 | 25.21 | 25.03 | 25.18 | 2255876.0 |
| 2017-06-28 | ABBV | Stock | 72.72 | 73.54 | 72.58 | 72.92 | 4196200.0 |
| 2017-06-28 | ABC-DELISTED | Stock | 96.17 | 97.11 | 96.07 | 96.37 | 738451.0 |
| 2017-06-28 | ABCB | Stock | 47.3 | 48.7 | 47.3 | 48.15 | 248100.0 |
| 2017-06-28 | ABCD-DELISTED | Stock | 4.91 | 5.08 | 4.91 | 5.01 | 21330.0 |
| 2017-06-28 | ABCO-DELISTED | Stock | 51.8 | 51.95 | 50.625 | 51.35 | 202930.0 |
| 2017-06-28 | ABDC-DELISTED | Stock | 13.42 | 13.44 | 13.05 | 13.3 | 61101.0 |
| 2017-06-28 | ABE-DELISTED | Stock | 13.9 | 13.95 | 13.9 | 13.95 | 3087.0 |
| 2017-06-28 | ABEO | Stock | 156.25 | 158.75 | 146.25 | 155.0 | 14592.0 |
| 2017-06-28 | ABEOW-DELISTED | Stock | 3.1696 | 3.2 | 3.1525 | 3.2 | 3234.0 |
| 2017-06-28 | ABEV | Stock | 5.5 | 5.57 | 5.44 | 5.52 | 25710700.0 |
| 2017-06-28 | ABG | Stock | 55.2 | 56.1 | 54.95 | 55.1 | 129800.0 |
| 2017-06-28 | ABIL-DELISTED | Stock | 1.35 | 1.38 | 1.25 | 1.37 | 441853.0 |
| 2017-06-28 | ABM | Stock | 42.01 | 42.3 | 41.83 | 42.17 | 236700.0 |
| 2017-06-28 | ABMD-DELISTED | Stock | 141.25 | 143.1 | 140.92 | 142.42 | 233902.0 |
> showing 50 of 6,455 rows — these rows as CSV