PREVIEW / stock_daily / 2015-05-26
file: by_date/stock_daily/2015/2015-05-26.parquet size: 223 KB rows: 6,657 symbols: 3,516
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-05-26 | AAPL | Stock | 33.15 | 33.2275 | 32.28 | 32.405 | 282790400.0 |
| 2015-05-26 | MSFT | Stock | 46.83 | 46.88 | 46.19 | 46.59 | 29581900.0 |
| 2015-05-26 | NVDA | Stock | 0.519 | 0.5225 | 0.5142 | 0.5182 | 259732000.0 |
| 2015-05-26 | AMZN | Stock | 21.31 | 21.35 | 21.1 | 21.2735 | 44884000.0 |
| 2015-05-26 | GOOGL | Stock | 27.629 | 27.6665 | 27.1485 | 27.3595 | 37474180.0 |
| 2015-05-26 | META | Stock | 80.43 | 80.6 | 79.08 | 79.33 | 16321300.0 |
| 2015-05-26 | TSLA | Stock | 16.512 | 16.8 | 16.4333 | 16.4973 | 52480500.0 |
| 2015-05-26 | TLT | Stock | 120.84 | 122.5501 | 120.74 | 122.46 | 10469658.0 |
| 2015-05-26 | ES | Stock | 49.2 | 49.3 | 48.75 | 49.0 | 1384000.0 |
| 2015-05-26 | CL | Stock | 68.42 | 68.5 | 67.11 | 67.15 | 4847100.0 |
| 2015-05-26 | A | Stock | 42.48 | 42.63 | 41.99 | 42.06 | 1919600.0 |
| 2015-05-26 | AA.B-DELISTED | Stock | 44.6 | 44.61 | 44.03 | 44.3159 | 35318.0 |
| 2015-05-26 | AABA-DELISTED | Stock | 43.46 | 43.5 | 42.58 | 42.85 | 12234267.0 |
| 2015-05-26 | AAC-DELISTED | Stock | 39.4 | 39.75 | 37.74 | 38.31 | 93991.0 |
| 2015-05-26 | AACG | Stock | 5.24 | 5.6 | 5.05 | 5.1 | 44800.0 |
| 2015-05-26 | AAIC-DELISTED | Stock | 20.9 | 21.02 | 20.53 | 20.71 | 542509.0 |
| 2015-05-26 | AAL | Stock | 43.05 | 43.09 | 41.36 | 41.56 | 17481100.0 |
| 2015-05-26 | AAMC-DELISTED | Stock | 51.4088 | 52.2706 | 49.7088 | 49.7088 | 17792.0 |
| 2015-05-26 | AAME | Stock | 3.4 | 3.4 | 3.16 | 3.27 | 12600.0 |
| 2015-05-26 | AAMI | Stock | 19.43 | 19.54 | 19.25 | 19.42 | 67200.0 |
| 2015-05-26 | AAOI | Stock | 17.31 | 19.35 | 16.39 | 19.18 | 1411700.0 |
| 2015-05-26 | AAON | Stock | 16.0533 | 16.1933 | 15.98 | 16.16 | 441750.0 |
| 2015-05-26 | AAP | Stock | 160.07 | 160.82 | 157.44 | 158.0 | 1120900.0 |
| 2015-05-26 | AAT | Stock | 40.21 | 40.21 | 39.54 | 39.78 | 128300.0 |
| 2015-05-26 | AAU-DELISTED | Stock | 0.93 | 0.93 | 0.87 | 0.9135 | 103723.0 |
| 2015-05-26 | AAUAF-DELISTED | Stock | 0.93 | 0.93 | 0.87 | 0.91 | 104466.0 |
| 2015-05-26 | AAV-DELISTED | Stock | 6.05 | 6.14 | 5.95 | 6.03 | 74588.0 |
| 2015-05-26 | AAVL-DELISTED | Stock | 37.94 | 38.8 | 36.02 | 37.01 | 253470.0 |
| 2015-05-26 | AAWW-DELISTED | Stock | 57.15 | 57.475 | 56.13 | 56.59 | 339166.0 |
| 2015-05-26 | AAXJ | Stock | 68.42 | 68.42 | 67.72 | 67.89 | 602431.0 |
| 2015-05-26 | AAXN-DELISTED | Stock | 31.76 | 31.83 | 30.48 | 31.29 | 2570995.0 |
| 2015-05-26 | AB | Stock | 32.3 | 32.49 | 31.51 | 31.64 | 408200.0 |
| 2015-05-26 | ABAC-DELISTED | Stock | 1.62 | 1.668 | 1.58 | 1.58 | 41135.0 |
| 2015-05-26 | ABAX-DELISTED | Stock | 52.5 | 53.6 | 52.48 | 53.35 | 118457.0 |
| 2015-05-26 | ABB-DELISTED | Stock | 21.76 | 21.77 | 21.52 | 21.57 | 1022895.0 |
| 2015-05-26 | ABBNY-DELISTED | Stock | 21.76 | 21.77 | 21.52 | 21.57 | 1075537.0 |
| 2015-05-26 | ABBV | Stock | 65.72 | 67.0 | 65.66 | 66.1 | 21034300.0 |
| 2015-05-26 | ABC-DELISTED | Stock | 113.88 | 114.45 | 112.805 | 113.0 | 1413681.0 |
| 2015-05-26 | ABCB | Stock | 25.41 | 25.79 | 25.16 | 25.23 | 119300.0 |
| 2015-05-26 | ABCD-DELISTED | Stock | 3.88 | 3.886 | 3.69 | 3.84 | 25111.0 |
| 2015-05-26 | ABCO-DELISTED | Stock | 46.95 | 48.0 | 46.69 | 47.96 | 354249.0 |
| 2015-05-26 | ABCW-DELISTED | Stock | 37.09 | 37.25 | 36.95 | 36.95 | 4497.0 |
| 2015-05-26 | ABDC-DELISTED | Stock | 13.75 | 13.9 | 13.6501 | 13.87 | 37790.0 |
| 2015-05-26 | ABE-DELISTED | Stock | 13.24 | 13.24 | 13.07 | 13.07 | 6888.0 |
| 2015-05-26 | ABEO | Stock | 215.5 | 228.25 | 213.75 | 224.75 | 46908.0 |
| 2015-05-26 | ABEOW-DELISTED | Stock | 4.7 | 4.7 | 3.9 | 4.2 | 31937.0 |
| 2015-05-26 | ABEV | Stock | 6.02 | 6.03 | 5.86 | 5.86 | 11644500.0 |
| 2015-05-26 | ABG | Stock | 85.83 | 86.36 | 84.82 | 85.64 | 252100.0 |
| 2015-05-26 | ABGB-DELISTED | Stock | 16.01 | 16.02 | 15.83 | 15.98 | 16908.0 |
| 2015-05-26 | ABIL-DELISTED | Stock | 9.92 | 9.92 | 9.92 | 9.92 | 236.0 |
> showing 50 of 6,657 rows — these rows as CSV