PREVIEW / stock_daily / 2016-04-01
file: by_date/stock_daily/2016/2016-04-01.parquet size: 219 KB rows: 6,579 symbols: 3,332
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-04-01 | AAPL | Stock | 27.195 | 27.5 | 27.05 | 27.4975 | 103496000.0 |
| 2016-04-01 | MSFT | Stock | 55.05 | 55.61 | 54.57 | 55.57 | 24399200.0 |
| 2016-04-01 | NVDA | Stock | 0.8852 | 0.9043 | 0.8785 | 0.9038 | 348292000.0 |
| 2016-04-01 | AMZN | Stock | 29.5245 | 29.9515 | 29.415 | 29.925 | 58348000.0 |
| 2016-04-01 | GOOGL | Stock | 37.858 | 38.502 | 37.76 | 38.4835 | 31673960.0 |
| 2016-04-01 | META | Stock | 113.75 | 116.17 | 113.35 | 116.06 | 24760500.0 |
| 2016-04-01 | TSLA | Stock | 16.322 | 16.5267 | 15.55 | 15.8393 | 239962500.0 |
| 2016-04-01 | TLT | Stock | 130.98 | 131.13 | 129.9 | 130.68 | 9341350.0 |
| 2016-04-01 | ES | Stock | 57.9 | 58.94 | 57.9 | 58.8 | 1515600.0 |
| 2016-04-01 | CL | Stock | 70.21 | 71.27 | 70.09 | 71.2 | 3257300.0 |
| 2016-04-01 | A | Stock | 39.56 | 40.38 | 39.5 | 40.31 | 2857800.0 |
| 2016-04-01 | AA.B-DELISTED | Stock | 32.85 | 32.92 | 32.0805 | 32.76 | 28332.0 |
| 2016-04-01 | AAAP-DELISTED | Stock | 34.09 | 35.99 | 33.82 | 34.86 | 20956.0 |
| 2016-04-01 | AABA-DELISTED | Stock | 36.54 | 36.88 | 36.31 | 36.49 | 12927106.0 |
| 2016-04-01 | AAC-DELISTED | Stock | 19.66 | 20.46 | 19.281 | 20.38 | 289617.0 |
| 2016-04-01 | AACG | Stock | 5.31 | 5.46 | 5.18 | 5.32 | 1700.0 |
| 2016-04-01 | AAIC-DELISTED | Stock | 12.47 | 12.73 | 12.45 | 12.66 | 227718.0 |
| 2016-04-01 | AAL | Stock | 40.13 | 40.16 | 39.27 | 39.52 | 11244100.0 |
| 2016-04-01 | AAMC-DELISTED | Stock | 3.4706 | 3.85 | 3.4706 | 3.7529 | 55410.0 |
| 2016-04-01 | AAME | Stock | 4.45 | 4.93 | 4.45 | 4.9 | 6700.0 |
| 2016-04-01 | AAMI | Stock | 13.24 | 13.51 | 13.17 | 13.28 | 124400.0 |
| 2016-04-01 | AAOI | Stock | 14.72 | 15.38 | 14.69 | 15.04 | 190300.0 |
| 2016-04-01 | AAON | Stock | 18.5533 | 18.8533 | 18.44 | 18.8 | 198150.0 |
| 2016-04-01 | AAP | Stock | 160.41 | 160.98 | 159.33 | 160.42 | 684700.0 |
| 2016-04-01 | AAT | Stock | 39.63 | 39.8 | 39.34 | 39.56 | 202700.0 |
| 2016-04-01 | AAU-DELISTED | Stock | 0.69 | 0.71 | 0.645 | 0.71 | 60647.0 |
| 2016-04-01 | AAUAF-DELISTED | Stock | 0.67 | 0.71 | 0.645 | 0.71 | 61394.0 |
| 2016-04-01 | AAV-DELISTED | Stock | 5.37 | 5.41 | 5.17 | 5.21 | 39386.0 |
| 2016-04-01 | AAVL-DELISTED | Stock | 5.09 | 5.27 | 5.04 | 5.19 | 248298.0 |
| 2016-04-01 | AAWW-DELISTED | Stock | 41.8 | 41.8 | 40.69 | 41.22 | 149308.0 |
| 2016-04-01 | AAXJ | Stock | 53.57 | 54.42 | 53.4 | 54.31 | 889035.0 |
| 2016-04-01 | AAXN-DELISTED | Stock | 19.42 | 19.6 | 19.0 | 19.04 | 835678.0 |
| 2016-04-01 | AB | Stock | 23.24 | 24.39 | 23.0 | 24.39 | 324000.0 |
| 2016-04-01 | ABAC-DELISTED | Stock | 0.685 | 0.7 | 0.675 | 0.675 | 1470.0 |
| 2016-04-01 | ABAX-DELISTED | Stock | 44.51 | 45.32 | 42.93 | 44.57 | 237150.0 |
| 2016-04-01 | ABB-DELISTED | Stock | 19.025 | 19.29 | 19.01 | 19.28 | 1647921.0 |
| 2016-04-01 | ABBNY-DELISTED | Stock | 19.025 | 19.29 | 19.01 | 19.27 | 1691483.0 |
| 2016-04-01 | ABBV | Stock | 56.58 | 57.57 | 56.36 | 57.42 | 4525700.0 |
| 2016-04-01 | ABC-DELISTED | Stock | 86.61 | 86.85 | 85.995 | 86.51 | 1769316.0 |
| 2016-04-01 | ABCB | Stock | 29.37 | 29.61 | 29.13 | 29.46 | 140000.0 |
| 2016-04-01 | ABCD-DELISTED | Stock | 4.3 | 4.37 | 4.11 | 4.17 | 42981.0 |
| 2016-04-01 | ABCO-DELISTED | Stock | 31.97 | 33.22 | 31.84 | 32.76 | 992745.0 |
| 2016-04-01 | ABCW-DELISTED | Stock | 44.88 | 45.24 | 44.72 | 45.21 | 13684.0 |
| 2016-04-01 | ABDC-DELISTED | Stock | 11.53 | 11.72 | 11.44 | 11.57 | 10898.0 |
| 2016-04-01 | ABE-DELISTED | Stock | 11.45 | 11.71 | 11.45 | 11.71 | 11411.0 |
| 2016-04-01 | ABEO | Stock | 63.75 | 72.5 | 63.25 | 70.75 | 2812.0 |
| 2016-04-01 | ABEV | Stock | 5.13 | 5.28 | 5.09 | 5.24 | 15697200.0 |
| 2016-04-01 | ABG | Stock | 59.19 | 59.39 | 56.42 | 56.78 | 685400.0 |
| 2016-04-01 | ABGB-DELISTED | Stock | 1.45 | 1.5231 | 1.45 | 1.52 | 58672.0 |
| 2016-04-01 | ABIL-DELISTED | Stock | 6.24 | 6.24 | 6.02 | 6.1885 | 2998.0 |
> showing 50 of 6,579 rows — these rows as CSV