PREVIEW / stock_daily / 2015-01-29
file: by_date/stock_daily/2015/2015-01-29.parquet size: 221 KB rows: 6,615 symbols: 3,511
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-29 | AAPL | Stock | 29.08 | 29.7975 | 28.89 | 29.725 | 337745600.0 |
| 2015-01-29 | MSFT | Stock | 40.93 | 42.12 | 40.79 | 42.01 | 63585300.0 |
| 2015-01-29 | NVDA | Stock | 0.483 | 0.4972 | 0.4808 | 0.4945 | 235340000.0 |
| 2015-01-29 | AMZN | Stock | 15.2365 | 15.64 | 14.9665 | 15.589 | 173132000.0 |
| 2015-01-29 | GOOGL | Stock | 25.645 | 25.7595 | 25.174 | 25.6615 | 79017140.0 |
| 2015-01-29 | META | Stock | 76.85 | 78.02 | 74.21 | 78.0 | 61293500.0 |
| 2015-01-29 | TSLA | Stock | 13.4047 | 13.732 | 13.1 | 13.68 | 53221500.0 |
| 2015-01-29 | TLT | Stock | 136.12 | 136.67 | 135.4601 | 135.87 | 8881399.0 |
| 2015-01-29 | ES | Stock | 55.58 | 56.52 | 55.28 | 56.4 | 1060000.0 |
| 2015-01-29 | CL | Stock | 68.6 | 69.46 | 68.22 | 69.03 | 6902200.0 |
| 2015-01-29 | A | Stock | 38.0 | 38.47 | 37.69 | 38.46 | 2330000.0 |
| 2015-01-29 | AA.B-DELISTED | Stock | 50.7 | 51.2699 | 50.23 | 51.26 | 153761.0 |
| 2015-01-29 | AABA-DELISTED | Stock | 43.56 | 43.8 | 41.8 | 43.72 | 62237909.0 |
| 2015-01-29 | AAC-DELISTED | Stock | 26.6 | 26.6 | 25.82 | 26.27 | 62077.0 |
| 2015-01-29 | AACG | Stock | 4.88 | 4.92 | 4.85 | 4.91 | 8000.0 |
| 2015-01-29 | AAIC-DELISTED | Stock | 26.74 | 26.85 | 26.45 | 26.85 | 168711.0 |
| 2015-01-29 | AAL | Stock | 51.05 | 52.42 | 50.57 | 52.24 | 16618900.0 |
| 2015-01-29 | AAMC-DELISTED | Stock | 58.8235 | 58.8235 | 50.5912 | 50.5912 | 156536.0 |
| 2015-01-29 | AAME | Stock | 3.9 | 3.9 | 3.9 | 3.9 | 400.0 |
| 2015-01-29 | AAMI | Stock | 15.26 | 15.47 | 15.17 | 15.45 | 179300.0 |
| 2015-01-29 | AAOI | Stock | 9.16 | 9.3 | 8.9 | 9.2 | 246000.0 |
| 2015-01-29 | AAON | Stock | 14.86 | 15.0467 | 14.6733 | 15.0333 | 170100.0 |
| 2015-01-29 | AAP | Stock | 159.69 | 160.98 | 157.58 | 160.26 | 561300.0 |
| 2015-01-29 | AAT | Stock | 44.65 | 45.09 | 44.44 | 45.05 | 88000.0 |
| 2015-01-29 | AAU-DELISTED | Stock | 1.19 | 1.21 | 1.119 | 1.2 | 310215.0 |
| 2015-01-29 | AAUAF-DELISTED | Stock | 1.17 | 1.2 | 1.11 | 1.2 | 314111.0 |
| 2015-01-29 | AAV-DELISTED | Stock | 4.03 | 4.07 | 3.96 | 4.01 | 117001.0 |
| 2015-01-29 | AAVL-DELISTED | Stock | 41.17 | 41.89 | 37.775 | 39.5 | 237835.0 |
| 2015-01-29 | AAWW-DELISTED | Stock | 45.45 | 46.2 | 45.05 | 46.18 | 236105.0 |
| 2015-01-29 | AAXJ | Stock | 63.21 | 63.256 | 62.69 | 63.23 | 961262.0 |
| 2015-01-29 | AAXN-DELISTED | Stock | 27.23 | 27.82 | 26.56 | 27.81 | 1453565.0 |
| 2015-01-29 | AB | Stock | 25.2 | 25.34 | 24.68 | 24.82 | 462100.0 |
| 2015-01-29 | ABAC-DELISTED | Stock | 1.53 | 1.53 | 1.39 | 1.429 | 11060.0 |
| 2015-01-29 | ABAX-DELISTED | Stock | 59.82 | 60.45 | 58.84 | 59.72 | 285319.0 |
| 2015-01-29 | ABB-DELISTED | Stock | 19.38 | 19.44 | 19.25 | 19.39 | 2171711.0 |
| 2015-01-29 | ABBNY-DELISTED | Stock | 19.38 | 19.44 | 19.25 | 19.39 | 2257683.0 |
| 2015-01-29 | ABBV | Stock | 62.12 | 63.38 | 61.59 | 63.12 | 8485600.0 |
| 2015-01-29 | ABC-DELISTED | Stock | 96.87 | 97.13 | 94.89 | 96.33 | 2733347.0 |
| 2015-01-29 | ABCB | Stock | 22.75 | 24.91 | 22.75 | 24.69 | 260800.0 |
| 2015-01-29 | ABCD-DELISTED | Stock | 2.52 | 2.59 | 2.331 | 2.52 | 69100.0 |
| 2015-01-29 | ABCO-DELISTED | Stock | 46.48 | 47.44 | 46.1 | 47.33 | 448133.0 |
| 2015-01-29 | ABCW-DELISTED | Stock | 33.01 | 33.7 | 33.01 | 33.46 | 3359.0 |
| 2015-01-29 | ABDC-DELISTED | Stock | 13.0 | 13.01 | 12.89 | 12.95 | 32151.0 |
| 2015-01-29 | ABE-DELISTED | Stock | 13.21 | 13.21 | 13.107 | 13.14 | 5533.0 |
| 2015-01-29 | ABEO | Stock | 80.25 | 81.25 | 77.25 | 81.25 | 48.0 |
| 2015-01-29 | ABEV | Stock | 6.63 | 6.83 | 6.63 | 6.81 | 24676400.0 |
| 2015-01-29 | ABG | Stock | 76.25 | 77.41 | 75.77 | 77.31 | 474700.0 |
| 2015-01-29 | ABGB-DELISTED | Stock | 15.12 | 15.42 | 15.0 | 15.35 | 33299.0 |
| 2015-01-29 | ABM | Stock | 29.01 | 29.5 | 28.99 | 29.48 | 160900.0 |
| 2015-01-29 | ABMD-DELISTED | Stock | 49.65 | 53.6 | 49.63 | 52.25 | 1122866.0 |
> showing 50 of 6,615 rows — these rows as CSV