PREVIEW / stock_daily / 2015-01-13
file: by_date/stock_daily/2015/2015-01-13.parquet size: 222 KB rows: 6,627 symbols: 3,521
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-01-13 | AAPL | Stock | 27.8575 | 28.2 | 27.2275 | 27.555 | 268367600.0 |
| 2015-01-13 | MSFT | Stock | 46.97 | 47.91 | 46.06 | 46.36 | 35270600.0 |
| 2015-01-13 | NVDA | Stock | 0.496 | 0.506 | 0.488 | 0.4915 | 236720000.0 |
| 2015-01-13 | AMZN | Stock | 14.874 | 15.075 | 14.6615 | 14.737 | 82728000.0 |
| 2015-01-13 | GOOGL | Stock | 25.1285 | 25.43 | 24.863 | 25.09 | 61005900.0 |
| 2015-01-13 | META | Stock | 77.23 | 78.08 | 75.85 | 76.45 | 25179600.0 |
| 2015-01-13 | TSLA | Stock | 13.5547 | 13.8407 | 13.394 | 13.6167 | 67159500.0 |
| 2015-01-13 | TLT | Stock | 131.39 | 132.61 | 131.14 | 131.82 | 8260840.0 |
| 2015-01-13 | ES | Stock | 53.65 | 54.52 | 53.36 | 53.68 | 1460900.0 |
| 2015-01-13 | CL | Stock | 68.66 | 69.33 | 68.33 | 68.73 | 4434200.0 |
| 2015-01-13 | A | Stock | 40.47 | 40.7 | 39.33 | 39.55 | 2013100.0 |
| 2015-01-13 | AA.B-DELISTED | Stock | 51.85 | 52.1099 | 50.27 | 50.41 | 62331.0 |
| 2015-01-13 | AABA-DELISTED | Stock | 49.17 | 49.48 | 47.4 | 48.285 | 20421758.0 |
| 2015-01-13 | AAC-DELISTED | Stock | 29.5 | 29.87 | 28.5 | 29.87 | 76374.0 |
| 2015-01-13 | AACG | Stock | 4.5 | 4.7 | 4.46 | 4.59 | 32400.0 |
| 2015-01-13 | AAIC-DELISTED | Stock | 26.13 | 26.31 | 25.71 | 25.92 | 222811.0 |
| 2015-01-13 | AAL | Stock | 50.12 | 51.43 | 49.46 | 50.4 | 12259300.0 |
| 2015-01-13 | AAMC-DELISTED | Stock | 90.5882 | 90.8824 | 62.7382 | 63.0235 | 380763.0 |
| 2015-01-13 | AAME | Stock | 3.91 | 4.0 | 3.91 | 4.0 | 1300.0 |
| 2015-01-13 | AAMI | Stock | 15.48 | 16.32 | 15.23 | 15.64 | 352500.0 |
| 2015-01-13 | AAOI | Stock | 9.84 | 10.21 | 9.07 | 9.25 | 484100.0 |
| 2015-01-13 | AAON | Stock | 14.3 | 14.66 | 14.2467 | 14.5267 | 214050.0 |
| 2015-01-13 | AAP | Stock | 159.62 | 160.72 | 152.33 | 153.76 | 824700.0 |
| 2015-01-13 | AAT | Stock | 42.98 | 43.13 | 42.33 | 42.93 | 220500.0 |
| 2015-01-13 | AAU-DELISTED | Stock | 1.16 | 1.18 | 1.1 | 1.1 | 429784.0 |
| 2015-01-13 | AAUAF-DELISTED | Stock | 1.16 | 1.18 | 1.1 | 1.1 | 432840.0 |
| 2015-01-13 | AAV-DELISTED | Stock | 4.43 | 4.515 | 4.33 | 4.44 | 181351.0 |
| 2015-01-13 | AAVL-DELISTED | Stock | 59.23 | 60.7 | 57.37 | 58.98 | 204695.0 |
| 2015-01-13 | AAWW-DELISTED | Stock | 47.19 | 48.165 | 45.82 | 46.67 | 143888.0 |
| 2015-01-13 | AAXJ | Stock | 61.96 | 62.24 | 61.35 | 61.74 | 774353.0 |
| 2015-01-13 | AAXN-DELISTED | Stock | 26.11 | 26.84 | 25.4 | 25.71 | 2113425.0 |
| 2015-01-13 | AB | Stock | 25.99 | 26.09 | 25.45 | 25.76 | 208600.0 |
| 2015-01-13 | ABAC-DELISTED | Stock | 1.35 | 1.54 | 1.35 | 1.374 | 9203.0 |
| 2015-01-13 | ABAX-DELISTED | Stock | 57.67 | 58.69 | 56.1 | 57.16 | 158627.0 |
| 2015-01-13 | ABB-DELISTED | Stock | 19.84 | 19.93 | 19.51 | 19.64 | 1868404.0 |
| 2015-01-13 | ABBNY-DELISTED | Stock | 19.84 | 19.93 | 19.51 | 19.65 | 2107947.0 |
| 2015-01-13 | ABBV | Stock | 65.72 | 66.07 | 62.91 | 63.39 | 13908400.0 |
| 2015-01-13 | ABC-DELISTED | Stock | 91.87 | 93.42 | 90.933 | 91.6 | 3038286.0 |
| 2015-01-13 | ABCB | Stock | 23.86 | 24.44 | 23.5 | 23.81 | 42600.0 |
| 2015-01-13 | ABCD-DELISTED | Stock | 1.79 | 1.8 | 1.75 | 1.75 | 10099.0 |
| 2015-01-13 | ABCO-DELISTED | Stock | 48.41 | 49.63 | 47.2 | 48.39 | 228654.0 |
| 2015-01-13 | ABCW-DELISTED | Stock | 35.16 | 35.16 | 34.32 | 34.9 | 14373.0 |
| 2015-01-13 | ABDC-DELISTED | Stock | 13.01 | 13.07 | 12.93 | 12.96 | 55976.0 |
| 2015-01-13 | ABE-DELISTED | Stock | 13.154 | 13.19 | 13.08 | 13.09 | 2693.0 |
| 2015-01-13 | ABEO | Stock | 83.75 | 83.75 | 76.75 | 81.75 | 492.0 |
| 2015-01-13 | ABEV | Stock | 6.37 | 6.47 | 6.29 | 6.37 | 13885900.0 |
| 2015-01-13 | ABG | Stock | 74.39 | 75.09 | 72.52 | 72.93 | 300400.0 |
| 2015-01-13 | ABGB-DELISTED | Stock | 16.16 | 16.33 | 15.95 | 16.15 | 204075.0 |
| 2015-01-13 | ABIL-DELISTED | Stock | 9.79 | 9.79 | 9.76 | 9.78 | 1101.0 |
| 2015-01-13 | ABM | Stock | 29.75 | 30.27 | 29.35 | 29.84 | 260500.0 |
> showing 50 of 6,627 rows — these rows as CSV