PREVIEW / stock_daily / 2016-02-08
file: by_date/stock_daily/2016/2016-02-08.parquet size: 218 KB rows: 6,585 symbols: 3,355
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-02-08 | AAPL | Stock | 23.2825 | 23.925 | 23.26 | 23.7525 | 216085600.0 |
| 2016-02-08 | MSFT | Stock | 49.55 | 49.57 | 48.19 | 49.41 | 59290500.0 |
| 2016-02-08 | NVDA | Stock | 0.6508 | 0.654 | 0.6213 | 0.6305 | 608852000.0 |
| 2016-02-08 | AMZN | Stock | 24.3235 | 24.675 | 23.7605 | 24.405 | 196510000.0 |
| 2016-02-08 | GOOGL | Stock | 34.384 | 35.226 | 34.1005 | 35.208 | 89410280.0 |
| 2016-02-08 | META | Stock | 100.41 | 102.68 | 97.46 | 99.75 | 71229700.0 |
| 2016-02-08 | TSLA | Stock | 10.4733 | 10.4767 | 9.7333 | 9.866 | 139695000.0 |
| 2016-02-08 | TLT | Stock | 129.72 | 131.629 | 129.68 | 131.49 | 14452163.0 |
| 2016-02-08 | ES | Stock | 54.14 | 54.78 | 53.43 | 54.09 | 3262400.0 |
| 2016-02-08 | CL | Stock | 65.65 | 66.29 | 65.24 | 66.07 | 4029200.0 |
| 2016-02-08 | A | Stock | 35.61 | 35.78 | 34.39 | 34.8 | 3888600.0 |
| 2016-02-08 | AA.B-DELISTED | Stock | 28.2 | 28.92 | 27.48 | 27.64 | 44741.0 |
| 2016-02-08 | AAAP-DELISTED | Stock | 25.25 | 25.95 | 24.0501 | 24.5 | 11744.0 |
| 2016-02-08 | AABA-DELISTED | Stock | 27.64 | 27.97 | 26.48 | 27.05 | 23344629.0 |
| 2016-02-08 | AAC-DELISTED | Stock | 19.19 | 19.86 | 18.26 | 19.31 | 427436.0 |
| 2016-02-08 | AACG | Stock | 5.26 | 5.54 | 5.25 | 5.35 | 18600.0 |
| 2016-02-08 | AAIC-DELISTED | Stock | 11.69 | 11.69 | 11.23 | 11.35 | 263107.0 |
| 2016-02-08 | AAL | Stock | 36.08 | 36.16 | 34.76 | 35.55 | 12821900.0 |
| 2016-02-08 | AAMC-DELISTED | Stock | 4.6088 | 4.6088 | 4.2765 | 4.4118 | 96747.0 |
| 2016-02-08 | AAME | Stock | 4.5 | 4.5 | 4.49 | 4.5 | 1200.0 |
| 2016-02-08 | AAMI | Stock | 11.26 | 11.57 | 10.77 | 10.87 | 319200.0 |
| 2016-02-08 | AAOI | Stock | 15.22 | 15.22 | 13.96 | 14.68 | 360300.0 |
| 2016-02-08 | AAON | Stock | 13.36 | 13.7133 | 13.1667 | 13.6467 | 177000.0 |
| 2016-02-08 | AAP | Stock | 142.77 | 143.1 | 136.06 | 141.45 | 2109900.0 |
| 2016-02-08 | AAT | Stock | 36.47 | 36.47 | 35.17 | 35.68 | 198100.0 |
| 2016-02-08 | AAU-DELISTED | Stock | 0.64 | 0.71 | 0.6003 | 0.6003 | 293624.0 |
| 2016-02-08 | AAUAF-DELISTED | Stock | 0.64 | 0.71 | 0.6003 | 0.6003 | 294404.0 |
| 2016-02-08 | AAV-DELISTED | Stock | 5.47 | 5.85 | 5.45 | 5.68 | 199769.0 |
| 2016-02-08 | AAVL-DELISTED | Stock | 4.36 | 4.38 | 4.1 | 4.18 | 665053.0 |
| 2016-02-08 | AAWW-DELISTED | Stock | 35.0 | 35.37 | 33.89 | 35.18 | 187203.0 |
| 2016-02-08 | AAXJ | Stock | 48.09 | 48.23 | 47.48 | 48.02 | 1332264.0 |
| 2016-02-08 | AAXN-DELISTED | Stock | 15.24 | 15.38 | 14.72 | 15.38 | 1093870.0 |
| 2016-02-08 | AB | Stock | 17.72 | 17.77 | 16.56 | 16.8 | 305100.0 |
| 2016-02-08 | ABAC-DELISTED | Stock | 0.79 | 0.79 | 0.6 | 0.64 | 2952.0 |
| 2016-02-08 | ABAX-DELISTED | Stock | 41.29 | 41.2999 | 39.2 | 40.0 | 330713.0 |
| 2016-02-08 | ABB-DELISTED | Stock | 17.22 | 17.27 | 16.98 | 17.14 | 4315550.0 |
| 2016-02-08 | ABBNY-DELISTED | Stock | 17.22 | 17.27 | 16.98 | 17.15 | 6445401.0 |
| 2016-02-08 | ABBV | Stock | 52.58 | 54.1 | 51.94 | 52.89 | 9369400.0 |
| 2016-02-08 | ABC-DELISTED | Stock | 83.89 | 84.24 | 82.72 | 83.6 | 4167785.0 |
| 2016-02-08 | ABCB | Stock | 26.4 | 26.53 | 25.75 | 25.82 | 322800.0 |
| 2016-02-08 | ABCD-DELISTED | Stock | 4.13 | 4.22 | 3.81 | 3.91 | 62479.0 |
| 2016-02-08 | ABCO-DELISTED | Stock | 42.59 | 42.6899 | 41.52 | 41.83 | 181740.0 |
| 2016-02-08 | ABCW-DELISTED | Stock | 40.77 | 41.38 | 40.61 | 41.18 | 135127.0 |
| 2016-02-08 | ABDC-DELISTED | Stock | 10.0 | 10.03 | 9.56 | 9.72 | 16484.0 |
| 2016-02-08 | ABE-DELISTED | Stock | 10.24 | 10.26 | 10.24 | 10.26 | 1687.0 |
| 2016-02-08 | ABEO | Stock | 58.0 | 62.25 | 58.0 | 61.25 | 2652.0 |
| 2016-02-08 | ABEV | Stock | 4.55 | 4.59 | 4.5 | 4.56 | 10763800.0 |
| 2016-02-08 | ABG | Stock | 45.96 | 48.2 | 45.48 | 46.07 | 896700.0 |
| 2016-02-08 | ABGB-DELISTED | Stock | 1.0 | 1.0 | 0.9011 | 0.916 | 35654.0 |
| 2016-02-08 | ABIL-DELISTED | Stock | 6.91 | 7.28 | 6.9 | 7.09 | 11732.0 |
> showing 50 of 6,585 rows — these rows as CSV