PREVIEW / stock_daily / 2016-06-08
file: by_date/stock_daily/2016/2016-06-08.parquet size: 219 KB rows: 6,577 symbols: 3,292
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-08 | AAPL | Stock | 24.755 | 24.89 | 24.67 | 24.735 | 83392400.0 |
| 2016-06-08 | MSFT | Stock | 52.02 | 52.44 | 51.87 | 52.04 | 21149400.0 |
| 2016-06-08 | NVDA | Stock | 1.1585 | 1.1628 | 1.145 | 1.1545 | 234616000.0 |
| 2016-06-08 | AMZN | Stock | 36.32 | 36.471 | 36.08 | 36.332 | 44468000.0 |
| 2016-06-08 | GOOGL | Stock | 36.975 | 37.1905 | 36.7882 | 37.1465 | 32314540.0 |
| 2016-06-08 | META | Stock | 117.76 | 118.6 | 117.27 | 118.39 | 14505600.0 |
| 2016-06-08 | TSLA | Stock | 15.5867 | 16.0567 | 15.5073 | 15.7013 | 89580000.0 |
| 2016-06-08 | TLT | Stock | 132.87 | 133.43 | 132.71 | 133.27 | 5313151.0 |
| 2016-06-08 | ES | Stock | 55.73 | 56.34 | 55.56 | 56.33 | 1469000.0 |
| 2016-06-08 | CL | Stock | 71.46 | 72.1 | 71.35 | 72.0 | 1907000.0 |
| 2016-06-08 | A | Stock | 45.75 | 46.18 | 45.71 | 46.15 | 1552100.0 |
| 2016-06-08 | AA.B-DELISTED | Stock | 34.85 | 35.15 | 34.65 | 34.75 | 90831.0 |
| 2016-06-08 | AAAP-DELISTED | Stock | 31.73 | 32.1 | 31.49 | 32.07 | 29679.0 |
| 2016-06-08 | AABA-DELISTED | Stock | 36.84 | 37.295 | 36.84 | 36.98 | 8537434.0 |
| 2016-06-08 | AAC-DELISTED | Stock | 22.21 | 22.31 | 21.46 | 21.49 | 199541.0 |
| 2016-06-08 | AACG | Stock | 5.34 | 5.35 | 5.06 | 5.32 | 17100.0 |
| 2016-06-08 | AAIC-DELISTED | Stock | 13.92 | 13.99 | 13.85 | 13.91 | 231754.0 |
| 2016-06-08 | AAL | Stock | 32.63 | 32.97 | 32.22 | 32.51 | 8173100.0 |
| 2016-06-08 | AAMC-DELISTED | Stock | 6.55 | 7.0588 | 6.3529 | 6.5529 | 196149.0 |
| 2016-06-08 | AAME | Stock | 3.54 | 3.54 | 3.53 | 3.53 | 1000.0 |
| 2016-06-08 | AAMI | Stock | 14.81 | 15.129 | 14.81 | 15.02 | 195300.0 |
| 2016-06-08 | AAOI | Stock | 11.33 | 11.54 | 11.29 | 11.44 | 306700.0 |
| 2016-06-08 | AAON | Stock | 18.2933 | 18.54 | 18.2067 | 18.5 | 162450.0 |
| 2016-06-08 | AAP | Stock | 151.5 | 154.19 | 151.48 | 153.52 | 1850300.0 |
| 2016-06-08 | AAT | Stock | 41.04 | 41.45 | 41.01 | 41.38 | 110900.0 |
| 2016-06-08 | AAU-DELISTED | Stock | 1.25 | 1.33 | 1.24 | 1.27 | 765707.0 |
| 2016-06-08 | AAUAF-DELISTED | Stock | 1.25 | 1.33 | 1.24 | 1.28 | 779052.0 |
| 2016-06-08 | AAV-DELISTED | Stock | 6.23 | 6.31 | 5.99 | 6.0 | 255530.0 |
| 2016-06-08 | AAWW-DELISTED | Stock | 46.36 | 46.78 | 45.98 | 46.59 | 277676.0 |
| 2016-06-08 | AAXJ | Stock | 55.25 | 55.38 | 55.14 | 55.26 | 592774.0 |
| 2016-06-08 | AAXN-DELISTED | Stock | 23.18 | 23.55 | 23.0783 | 23.52 | 577825.0 |
| 2016-06-08 | AB | Stock | 23.65 | 23.84 | 23.54 | 23.73 | 188700.0 |
| 2016-06-08 | ABAC-DELISTED | Stock | 0.8399 | 0.8399 | 0.651 | 0.75 | 8764.0 |
| 2016-06-08 | ABAX-DELISTED | Stock | 45.89 | 46.7 | 45.28 | 46.62 | 106532.0 |
| 2016-06-08 | ABB-DELISTED | Stock | 21.54 | 21.57 | 21.43 | 21.47 | 1252340.0 |
| 2016-06-08 | ABBNY-DELISTED | Stock | 21.54 | 21.57 | 21.43 | 21.47 | 1293095.0 |
| 2016-06-08 | ABBV | Stock | 62.21 | 62.3 | 61.37 | 61.73 | 13173000.0 |
| 2016-06-08 | ABC-DELISTED | Stock | 76.31 | 76.64 | 75.87 | 76.25 | 1861883.0 |
| 2016-06-08 | ABCB | Stock | 31.68 | 31.97 | 31.55 | 31.87 | 67300.0 |
| 2016-06-08 | ABCD-DELISTED | Stock | 4.6 | 4.65 | 4.57 | 4.64 | 16540.0 |
| 2016-06-08 | ABCO-DELISTED | Stock | 34.08 | 35.42 | 33.83 | 35.17 | 281836.0 |
| 2016-06-08 | ABDC-DELISTED | Stock | 12.25 | 12.33 | 12.17 | 12.25 | 14384.0 |
| 2016-06-08 | ABE-DELISTED | Stock | 12.65 | 12.65 | 12.49 | 12.5 | 15452.0 |
| 2016-06-08 | ABEO | Stock | 77.0 | 79.5 | 75.25 | 79.0 | 1576.0 |
| 2016-06-08 | ABEV | Stock | 5.59 | 5.72 | 5.55 | 5.68 | 16794700.0 |
| 2016-06-08 | ABG | Stock | 57.29 | 57.7 | 56.72 | 57.44 | 277600.0 |
| 2016-06-08 | ABIL-DELISTED | Stock | 3.63 | 3.68 | 3.5 | 3.65 | 19138.0 |
| 2016-06-08 | ABM | Stock | 34.25 | 34.99 | 34.13 | 34.76 | 344500.0 |
| 2016-06-08 | ABMD-DELISTED | Stock | 104.54 | 104.91 | 104.13 | 104.36 | 357320.0 |
| 2016-06-08 | ABR | Stock | 6.97 | 7.08 | 6.95 | 7.06 | 124900.0 |
> showing 50 of 6,577 rows — these rows as CSV