PREVIEW / stock_daily / 2015-06-29
file: by_date/stock_daily/2015/2015-06-29.parquet size: 225 KB rows: 6,682 symbols: 3,517
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-06-29 | AAPL | Stock | 31.365 | 31.6175 | 31.12 | 31.1325 | 196645600.0 |
| 2015-06-29 | MSFT | Stock | 45.04 | 45.23 | 44.36 | 44.37 | 34081700.0 |
| 2015-06-29 | NVDA | Stock | 0.5125 | 0.5178 | 0.5022 | 0.503 | 391724000.0 |
| 2015-06-29 | AMZN | Stock | 21.749 | 21.85 | 21.45 | 21.493 | 55064000.0 |
| 2015-06-29 | GOOGL | Stock | 27.3375 | 27.545 | 27.012 | 27.0625 | 37756320.0 |
| 2015-06-29 | META | Stock | 86.61 | 87.5 | 85.73 | 85.8 | 35957900.0 |
| 2015-06-29 | TSLA | Stock | 17.4633 | 17.73 | 17.38 | 17.468 | 52183500.0 |
| 2015-06-29 | TLT | Stock | 116.96 | 118.67 | 116.46 | 118.28 | 17132910.0 |
| 2015-06-29 | ES | Stock | 46.15 | 46.51 | 45.47 | 45.5 | 1444900.0 |
| 2015-06-29 | CL | Stock | 66.0 | 66.34 | 65.37 | 65.4 | 2270400.0 |
| 2015-06-29 | A | Stock | 39.6 | 39.8 | 38.74 | 38.74 | 2516400.0 |
| 2015-06-29 | AA.B-DELISTED | Stock | 41.4 | 41.4 | 40.76 | 40.95 | 44966.0 |
| 2015-06-29 | AABA-DELISTED | Stock | 39.49 | 39.78 | 38.85 | 38.92 | 11732235.0 |
| 2015-06-29 | AAC-DELISTED | Stock | 42.17 | 43.9 | 41.8 | 43.06 | 90658.0 |
| 2015-06-29 | AACG | Stock | 6.05 | 6.31 | 5.34 | 5.97 | 92000.0 |
| 2015-06-29 | AAIC-DELISTED | Stock | 19.7 | 19.7921 | 19.25 | 19.43 | 730560.0 |
| 2015-06-29 | AAL | Stock | 40.77 | 41.32 | 39.59 | 39.75 | 17651700.0 |
| 2015-06-29 | AAMC-DELISTED | Stock | 42.0059 | 43.5206 | 41.9882 | 42.9412 | 21182.0 |
| 2015-06-29 | AAME | Stock | 3.69 | 3.71 | 3.63 | 3.63 | 2100.0 |
| 2015-06-29 | AAMI | Stock | 17.71 | 17.93 | 17.4 | 17.47 | 382300.0 |
| 2015-06-29 | AAOI | Stock | 18.56 | 18.56 | 17.18 | 17.33 | 259400.0 |
| 2015-06-29 | AAON | Stock | 15.1067 | 15.5533 | 14.9133 | 14.9267 | 313950.0 |
| 2015-06-29 | AAP | Stock | 163.08 | 163.08 | 158.81 | 158.93 | 515500.0 |
| 2015-06-29 | AAT | Stock | 39.45 | 40.31 | 38.92 | 38.97 | 237000.0 |
| 2015-06-29 | AAU-DELISTED | Stock | 0.8099 | 0.82 | 0.7998 | 0.81 | 222583.0 |
| 2015-06-29 | AAUAF-DELISTED | Stock | 0.8 | 0.8102 | 0.79 | 0.8102 | 226062.0 |
| 2015-06-29 | AAV-DELISTED | Stock | 6.31 | 6.39 | 6.24 | 6.37 | 52400.0 |
| 2015-06-29 | AAVL-DELISTED | Stock | 15.61 | 15.81 | 15.25 | 15.3 | 572714.0 |
| 2015-06-29 | AAWW-DELISTED | Stock | 57.11 | 57.3 | 54.43 | 54.5 | 456471.0 |
| 2015-06-29 | AAXJ | Stock | 62.77 | 62.96 | 62.27 | 62.3 | 650067.0 |
| 2015-06-29 | AAXN-DELISTED | Stock | 32.23 | 33.22 | 31.11 | 31.59 | 3267159.0 |
| 2015-06-29 | AB | Stock | 29.74 | 29.87 | 29.03 | 29.11 | 163900.0 |
| 2015-06-29 | ABAC-DELISTED | Stock | 1.37 | 1.37 | 1.35 | 1.3699 | 5253.0 |
| 2015-06-29 | ABAX-DELISTED | Stock | 51.95 | 52.41 | 51.1 | 51.19 | 63911.0 |
| 2015-06-29 | ABB-DELISTED | Stock | 21.5 | 21.64 | 21.25 | 21.29 | 2791366.0 |
| 2015-06-29 | ABBNY-DELISTED | Stock | 21.5 | 21.64 | 21.25 | 21.29 | 2864655.0 |
| 2015-06-29 | ABBV | Stock | 69.27 | 70.02 | 67.08 | 67.18 | 12057200.0 |
| 2015-06-29 | ABC-DELISTED | Stock | 106.81 | 107.62 | 105.78 | 106.11 | 1473942.0 |
| 2015-06-29 | ABCB | Stock | 25.74 | 25.95 | 25.35 | 25.36 | 90900.0 |
| 2015-06-29 | ABCD-DELISTED | Stock | 4.05 | 4.25 | 3.93 | 4.21 | 104903.0 |
| 2015-06-29 | ABCO-DELISTED | Stock | 54.13 | 54.47 | 53.13 | 53.35 | 295051.0 |
| 2015-06-29 | ABCW-DELISTED | Stock | 38.05 | 38.471 | 37.99 | 38.01 | 14599.0 |
| 2015-06-29 | ABDC-DELISTED | Stock | 13.44 | 13.44 | 13.08 | 13.22 | 71386.0 |
| 2015-06-29 | ABE-DELISTED | Stock | 12.5 | 12.55 | 12.48 | 12.4928 | 13124.0 |
| 2015-06-29 | ABEO | Stock | 152.0 | 154.75 | 138.0 | 145.25 | 19176.0 |
| 2015-06-29 | ABEOW-DELISTED | Stock | 2.02 | 2.053 | 2.02 | 2.03 | 530.0 |
| 2015-06-29 | ABEV | Stock | 6.03 | 6.09 | 6.01 | 6.08 | 7091100.0 |
| 2015-06-29 | ABG | Stock | 92.06 | 92.15 | 89.99 | 90.06 | 145800.0 |
| 2015-06-29 | ABGB-DELISTED | Stock | 16.01 | 16.13 | 15.93 | 15.96 | 16503.0 |
| 2015-06-29 | ABM | Stock | 33.14 | 33.45 | 32.83 | 32.85 | 249400.0 |
> showing 50 of 6,682 rows — these rows as CSV