PREVIEW / stock_daily / 2015-12-16
file: by_date/stock_daily/2015/2015-12-16.parquet size: 222 KB rows: 6,664 symbols: 3,421
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-16 | AAPL | Stock | 27.7675 | 27.9975 | 27.2 | 27.835 | 224954000.0 |
| 2015-12-16 | MSFT | Stock | 55.54 | 56.25 | 54.76 | 56.13 | 37503300.0 |
| 2015-12-16 | NVDA | Stock | 0.826 | 0.832 | 0.8188 | 0.8292 | 236356000.0 |
| 2015-12-16 | AMZN | Stock | 33.178 | 33.8675 | 32.966 | 33.7885 | 79290000.0 |
| 2015-12-16 | GOOGL | Stock | 38.3285 | 39.075 | 37.8522 | 38.8295 | 53120200.0 |
| 2015-12-16 | META | Stock | 105.37 | 107.09 | 104.19 | 106.79 | 22680500.0 |
| 2015-12-16 | TSLA | Stock | 14.8067 | 15.6587 | 14.7153 | 15.634 | 76564500.0 |
| 2015-12-16 | TLT | Stock | 121.07 | 122.17 | 120.5 | 121.18 | 10988572.0 |
| 2015-12-16 | ES | Stock | 49.9 | 51.31 | 49.72 | 51.15 | 1773700.0 |
| 2015-12-16 | CL | Stock | 67.0 | 68.49 | 66.99 | 68.33 | 5133100.0 |
| 2015-12-16 | A | Stock | 41.01 | 41.57 | 40.67 | 41.43 | 2582600.0 |
| 2015-12-16 | AA.B-DELISTED | Stock | 31.45 | 31.47 | 30.76 | 31.19 | 51966.0 |
| 2015-12-16 | AAAP-DELISTED | Stock | 29.39 | 29.99 | 29.21 | 29.5 | 17792.0 |
| 2015-12-16 | AABA-DELISTED | Stock | 33.15 | 33.875 | 32.91 | 33.79 | 11872318.0 |
| 2015-12-16 | AAC-DELISTED | Stock | 22.58 | 22.9 | 21.72 | 22.56 | 337629.0 |
| 2015-12-16 | AACG | Stock | 5.9 | 6.16 | 5.9 | 6.01 | 72100.0 |
| 2015-12-16 | AAIC-DELISTED | Stock | 12.7 | 13.52 | 12.7 | 13.46 | 423187.0 |
| 2015-12-16 | AAL | Stock | 42.99 | 43.49 | 42.12 | 43.2 | 7850900.0 |
| 2015-12-16 | AAMC-DELISTED | Stock | 4.0853 | 4.5 | 3.8309 | 4.1971 | 281812.0 |
| 2015-12-16 | AAME | Stock | 4.69 | 4.74 | 4.69 | 4.74 | 500.0 |
| 2015-12-16 | AAMI | Stock | 14.33 | 14.37 | 14.07 | 14.36 | 235000.0 |
| 2015-12-16 | AAOI | Stock | 16.81 | 17.1 | 16.63 | 16.91 | 200800.0 |
| 2015-12-16 | AAON | Stock | 15.6667 | 15.86 | 15.44 | 15.5933 | 197400.0 |
| 2015-12-16 | AAP | Stock | 159.0 | 162.0 | 157.01 | 160.82 | 2638900.0 |
| 2015-12-16 | AAT | Stock | 39.13 | 39.78 | 38.96 | 39.68 | 156200.0 |
| 2015-12-16 | AAU-DELISTED | Stock | 0.5621 | 0.5753 | 0.55 | 0.5646 | 93425.0 |
| 2015-12-16 | AAUAF-DELISTED | Stock | 0.5621 | 0.5753 | 0.55 | 0.5646 | 94120.0 |
| 2015-12-16 | AAV-DELISTED | Stock | 4.41 | 4.74 | 4.41 | 4.6 | 103913.0 |
| 2015-12-16 | AAVL-DELISTED | Stock | 8.9 | 9.2 | 8.63 | 9.09 | 196682.0 |
| 2015-12-16 | AAWW-DELISTED | Stock | 39.31 | 40.43 | 38.96 | 40.28 | 221451.0 |
| 2015-12-16 | AAXJ | Stock | 54.24 | 55.02 | 54.07 | 54.8 | 1173626.0 |
| 2015-12-16 | AAXN-DELISTED | Stock | 17.15 | 17.16 | 16.55 | 16.78 | 1144334.0 |
| 2015-12-16 | AB | Stock | 22.13 | 23.44 | 22.07 | 23.17 | 438200.0 |
| 2015-12-16 | ABAC-DELISTED | Stock | 0.99 | 1.0601 | 0.9501 | 0.98 | 10815.0 |
| 2015-12-16 | ABAX-DELISTED | Stock | 52.41 | 53.86 | 52.41 | 53.54 | 58247.0 |
| 2015-12-16 | ABB-DELISTED | Stock | 18.0 | 18.12 | 17.82 | 18.1 | 2515181.0 |
| 2015-12-16 | ABBNY-DELISTED | Stock | 18.0 | 18.12 | 17.82 | 18.08 | 4163083.0 |
| 2015-12-16 | ABBV | Stock | 56.67 | 57.69 | 56.2 | 57.63 | 6282500.0 |
| 2015-12-16 | ABC-DELISTED | Stock | 102.1 | 102.44 | 100.44 | 101.59 | 1645605.0 |
| 2015-12-16 | ABCB | Stock | 34.74 | 34.74 | 33.77 | 34.39 | 379300.0 |
| 2015-12-16 | ABCD-DELISTED | Stock | 5.05 | 5.09 | 4.99 | 5.05 | 19708.0 |
| 2015-12-16 | ABCO-DELISTED | Stock | 51.07 | 51.32 | 49.47 | 49.89 | 306681.0 |
| 2015-12-16 | ABCW-DELISTED | Stock | 44.88 | 45.25 | 44.33 | 44.89 | 21445.0 |
| 2015-12-16 | ABDC-DELISTED | Stock | 11.295 | 11.84 | 11.25 | 11.4 | 29087.0 |
| 2015-12-16 | ABE-DELISTED | Stock | 10.8 | 10.93 | 10.74 | 10.93 | 18695.0 |
| 2015-12-16 | ABEO | Stock | 88.0 | 92.5 | 87.75 | 89.5 | 5988.0 |
| 2015-12-16 | ABEOW-DELISTED | Stock | 1.3 | 1.3944 | 1.3 | 1.3 | 700.0 |
| 2015-12-16 | ABEV | Stock | 4.52 | 4.75 | 4.46 | 4.73 | 16988100.0 |
| 2015-12-16 | ABG | Stock | 70.69 | 70.73 | 68.99 | 70.19 | 155800.0 |
| 2015-12-16 | ABGB-DELISTED | Stock | 1.73 | 1.85 | 1.71 | 1.7264 | 36049.0 |
> showing 50 of 6,664 rows — these rows as CSV