PREVIEW / stock_daily / 2015-08-14
file: by_date/stock_daily/2015/2015-08-14.parquet size: 222 KB rows: 6,648 symbols: 3,460
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-08-14 | AAPL | Stock | 28.58 | 29.0775 | 28.5025 | 28.99 | 171718000.0 |
| 2015-08-14 | MSFT | Stock | 46.53 | 47.1 | 46.52 | 47.0 | 21473400.0 |
| 2015-08-14 | NVDA | Stock | 0.5875 | 0.592 | 0.584 | 0.5885 | 214652000.0 |
| 2015-08-14 | AMZN | Stock | 26.4125 | 26.7055 | 26.4125 | 26.576 | 39896000.0 |
| 2015-08-14 | GOOGL | Stock | 34.202 | 34.613 | 34.145 | 34.4685 | 27601100.0 |
| 2015-08-14 | META | Stock | 93.54 | 94.72 | 93.21 | 94.42 | 15929700.0 |
| 2015-08-14 | TSLA | Stock | 16.4827 | 16.5287 | 16.118 | 16.21 | 65472000.0 |
| 2015-08-14 | TLT | Stock | 123.47 | 124.37 | 123.2 | 123.96 | 4324742.0 |
| 2015-08-14 | ES | Stock | 50.84 | 51.22 | 50.54 | 51.18 | 885600.0 |
| 2015-08-14 | CL | Stock | 67.76 | 67.94 | 67.49 | 67.79 | 1829600.0 |
| 2015-08-14 | A | Stock | 38.62 | 38.73 | 38.32 | 38.65 | 2632700.0 |
| 2015-08-14 | AA.B-DELISTED | Stock | 34.65 | 35.02 | 34.65 | 34.88 | 29964.0 |
| 2015-08-14 | AABA-DELISTED | Stock | 35.82 | 36.345 | 35.72 | 36.24 | 11780320.0 |
| 2015-08-14 | AAC-DELISTED | Stock | 22.45 | 22.67 | 21.13 | 22.66 | 635007.0 |
| 2015-08-14 | AACG | Stock | 3.0 | 3.2 | 3.0 | 3.14 | 23800.0 |
| 2015-08-14 | AAIC-DELISTED | Stock | 18.0 | 18.08 | 17.75 | 18.04 | 311258.0 |
| 2015-08-14 | AAL | Stock | 42.35 | 43.17 | 42.35 | 42.88 | 4857400.0 |
| 2015-08-14 | AAMC-DELISTED | Stock | 28.625 | 28.625 | 26.8324 | 27.3529 | 5307.0 |
| 2015-08-14 | AAME | Stock | 3.68 | 3.68 | 3.53 | 3.6 | 5500.0 |
| 2015-08-14 | AAMI | Stock | 17.15 | 17.61 | 17.15 | 17.61 | 85000.0 |
| 2015-08-14 | AAOI | Stock | 22.38 | 22.756 | 21.75 | 22.11 | 326200.0 |
| 2015-08-14 | AAON | Stock | 15.1933 | 15.4867 | 15.1933 | 15.4867 | 108150.0 |
| 2015-08-14 | AAP | Stock | 188.49 | 190.14 | 186.76 | 187.03 | 1252700.0 |
| 2015-08-14 | AAT | Stock | 41.26 | 41.7 | 41.05 | 41.7 | 134400.0 |
| 2015-08-14 | AAU-DELISTED | Stock | 0.68 | 0.698 | 0.65 | 0.66 | 23497.0 |
| 2015-08-14 | AAUAF-DELISTED | Stock | 0.68 | 0.698 | 0.65 | 0.66 | 23997.0 |
| 2015-08-14 | AAV-DELISTED | Stock | 5.48 | 5.64 | 5.39 | 5.47 | 59319.0 |
| 2015-08-14 | AAVL-DELISTED | Stock | 11.64 | 12.25 | 9.36 | 10.01 | 6319589.0 |
| 2015-08-14 | AAWW-DELISTED | Stock | 44.69 | 45.14 | 44.27 | 45.12 | 151591.0 |
| 2015-08-14 | AAXJ | Stock | 56.92 | 57.19 | 56.92 | 57.07 | 1702643.0 |
| 2015-08-14 | AAXN-DELISTED | Stock | 23.91 | 24.2 | 23.53 | 24.0 | 859436.0 |
| 2015-08-14 | AB | Stock | 28.3 | 28.77 | 28.14 | 28.6 | 235200.0 |
| 2015-08-14 | ABAC-DELISTED | Stock | 0.99 | 1.0 | 0.91 | 0.988 | 12900.0 |
| 2015-08-14 | ABAX-DELISTED | Stock | 47.71 | 48.72 | 47.71 | 48.45 | 108628.0 |
| 2015-08-14 | ABB-DELISTED | Stock | 19.98 | 20.06 | 19.91 | 20.01 | 1140122.0 |
| 2015-08-14 | ABBNY-DELISTED | Stock | 19.98 | 20.06 | 19.91 | 20.02 | 1182146.0 |
| 2015-08-14 | ABBV | Stock | 68.56 | 69.44 | 68.41 | 68.65 | 5864800.0 |
| 2015-08-14 | ABC-DELISTED | Stock | 103.98 | 104.19 | 103.41 | 103.95 | 882886.0 |
| 2015-08-14 | ABCB | Stock | 27.72 | 28.49 | 27.72 | 28.28 | 165500.0 |
| 2015-08-14 | ABCD-DELISTED | Stock | 4.54 | 4.7188 | 4.38 | 4.45 | 82993.0 |
| 2015-08-14 | ABCO-DELISTED | Stock | 49.7 | 50.83 | 49.67 | 50.36 | 203792.0 |
| 2015-08-14 | ABCW-DELISTED | Stock | 41.0 | 41.895 | 41.0 | 41.5 | 15495.0 |
| 2015-08-14 | ABDC-DELISTED | Stock | 12.66 | 12.9846 | 12.61 | 12.97 | 46276.0 |
| 2015-08-14 | ABE-DELISTED | Stock | 12.01 | 12.01 | 11.93 | 11.9736 | 12712.0 |
| 2015-08-14 | ABEO | Stock | 139.0 | 144.0 | 130.25 | 133.75 | 9704.0 |
| 2015-08-14 | ABEOW-DELISTED | Stock | 2.1 | 2.2596 | 2.07 | 2.13 | 1800.0 |
| 2015-08-14 | ABEV | Stock | 5.32 | 5.37 | 5.29 | 5.34 | 16474100.0 |
| 2015-08-14 | ABG | Stock | 82.31 | 83.95 | 81.67 | 83.72 | 432100.0 |
| 2015-08-14 | ABGB-DELISTED | Stock | 5.31 | 5.35 | 4.94 | 5.05 | 113974.0 |
| 2015-08-14 | ABM | Stock | 33.12 | 33.74 | 32.7 | 33.67 | 201400.0 |
> showing 50 of 6,648 rows — these rows as CSV