PREVIEW / stock_daily / 2016-06-03
file: by_date/stock_daily/2016/2016-06-03.parquet size: 218 KB rows: 6,553 symbols: 3,282
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-03 | AAPL | Stock | 24.4475 | 24.5675 | 24.3625 | 24.48 | 114019600.0 |
| 2016-06-03 | MSFT | Stock | 52.38 | 52.42 | 51.6 | 51.79 | 23368300.0 |
| 2016-06-03 | NVDA | Stock | 1.167 | 1.1685 | 1.1415 | 1.162 | 461076000.0 |
| 2016-06-03 | AMZN | Stock | 36.337 | 36.35 | 35.9215 | 36.277 | 67346000.0 |
| 2016-06-03 | GOOGL | Stock | 37.0745 | 37.0745 | 36.6955 | 36.793 | 24607520.0 |
| 2016-06-03 | META | Stock | 118.98 | 118.98 | 117.86 | 118.47 | 14135100.0 |
| 2016-06-03 | TSLA | Stock | 14.6667 | 14.796 | 14.534 | 14.5993 | 33435000.0 |
| 2016-06-03 | TLT | Stock | 132.86 | 133.23 | 132.6 | 133.23 | 11077213.0 |
| 2016-06-03 | ES | Stock | 55.93 | 56.6 | 55.93 | 56.16 | 1306800.0 |
| 2016-06-03 | CL | Stock | 71.42 | 71.79 | 71.25 | 71.6 | 2290900.0 |
| 2016-06-03 | A | Stock | 45.73 | 45.85 | 45.19 | 45.72 | 2395100.0 |
| 2016-06-03 | AA.B-DELISTED | Stock | 33.196 | 33.68 | 33.0 | 33.46 | 43564.0 |
| 2016-06-03 | AAAP-DELISTED | Stock | 30.93 | 30.93 | 29.61 | 30.25 | 47320.0 |
| 2016-06-03 | AABA-DELISTED | Stock | 37.11 | 37.11 | 36.5 | 36.58 | 11420571.0 |
| 2016-06-03 | AAC-DELISTED | Stock | 22.13 | 22.5 | 21.46 | 21.48 | 94267.0 |
| 2016-06-03 | AACG | Stock | 5.02 | 5.24 | 5.02 | 5.24 | 7200.0 |
| 2016-06-03 | AAIC-DELISTED | Stock | 13.54 | 13.56 | 13.37 | 13.52 | 215206.0 |
| 2016-06-03 | AAL | Stock | 31.59 | 31.6 | 30.37 | 30.81 | 12424100.0 |
| 2016-06-03 | AAMC-DELISTED | Stock | 6.4118 | 6.6882 | 6.3235 | 6.5765 | 91871.0 |
| 2016-06-03 | AAME | Stock | 3.61 | 3.64 | 3.61 | 3.64 | 2200.0 |
| 2016-06-03 | AAMI | Stock | 14.98 | 15.52 | 14.81 | 15.22 | 251300.0 |
| 2016-06-03 | AAOI | Stock | 10.95 | 11.135 | 10.61 | 10.96 | 406800.0 |
| 2016-06-03 | AAON | Stock | 18.5933 | 18.5933 | 18.2667 | 18.4467 | 118800.0 |
| 2016-06-03 | AAP | Stock | 151.67 | 152.67 | 149.73 | 150.71 | 895200.0 |
| 2016-06-03 | AAT | Stock | 41.66 | 41.72 | 41.02 | 41.33 | 138200.0 |
| 2016-06-03 | AAU-DELISTED | Stock | 1.09 | 1.18 | 1.05 | 1.1593 | 623329.0 |
| 2016-06-03 | AAUAF-DELISTED | Stock | 1.09 | 1.18 | 1.05 | 1.14 | 627811.0 |
| 2016-06-03 | AAV-DELISTED | Stock | 5.98 | 6.05 | 5.89 | 5.94 | 53503.0 |
| 2016-06-03 | AAWW-DELISTED | Stock | 42.97 | 42.97 | 41.86 | 42.73 | 295884.0 |
| 2016-06-03 | AAXJ | Stock | 54.06 | 54.16 | 53.71 | 54.08 | 566357.0 |
| 2016-06-03 | AAXN-DELISTED | Stock | 22.87 | 22.94 | 22.57 | 22.775 | 722138.0 |
| 2016-06-03 | AB | Stock | 23.34 | 23.5 | 23.08 | 23.47 | 151200.0 |
| 2016-06-03 | ABAC-DELISTED | Stock | 0.7 | 0.7 | 0.59 | 0.6411 | 23634.0 |
| 2016-06-03 | ABAX-DELISTED | Stock | 47.29 | 47.58 | 46.01 | 46.39 | 118684.0 |
| 2016-06-03 | ABB-DELISTED | Stock | 20.94 | 20.99 | 20.84 | 20.95 | 1116119.0 |
| 2016-06-03 | ABBNY-DELISTED | Stock | 20.94 | 20.99 | 20.84 | 20.95 | 1162554.0 |
| 2016-06-03 | ABBV | Stock | 64.76 | 65.37 | 63.75 | 65.0 | 10621600.0 |
| 2016-06-03 | ABC-DELISTED | Stock | 76.7 | 77.0 | 76.27 | 76.54 | 1686338.0 |
| 2016-06-03 | ABCB | Stock | 31.64 | 31.64 | 30.53 | 31.32 | 139200.0 |
| 2016-06-03 | ABCD-DELISTED | Stock | 4.61 | 4.75 | 4.61 | 4.6611 | 17571.0 |
| 2016-06-03 | ABCO-DELISTED | Stock | 34.38 | 34.84 | 33.46 | 33.82 | 323938.0 |
| 2016-06-03 | ABDC-DELISTED | Stock | 12.29 | 12.35 | 12.23 | 12.25 | 17021.0 |
| 2016-06-03 | ABE-DELISTED | Stock | 11.94 | 12.11 | 11.84 | 12.11 | 11855.0 |
| 2016-06-03 | ABEO | Stock | 76.25 | 77.25 | 75.0 | 75.75 | 2728.0 |
| 2016-06-03 | ABEV | Stock | 5.44 | 5.52 | 5.42 | 5.52 | 20425700.0 |
| 2016-06-03 | ABG | Stock | 56.02 | 56.19 | 54.71 | 54.8 | 351500.0 |
| 2016-06-03 | ABIL-DELISTED | Stock | 3.08 | 3.1389 | 3.02 | 3.1 | 20832.0 |
| 2016-06-03 | ABM | Stock | 34.37 | 34.37 | 33.99 | 34.16 | 208600.0 |
| 2016-06-03 | ABMD-DELISTED | Stock | 101.75 | 102.13 | 100.9 | 101.84 | 423896.0 |
| 2016-06-03 | ABR | Stock | 7.01 | 7.05 | 6.96 | 6.99 | 49900.0 |
> showing 50 of 6,553 rows — these rows as CSV