PREVIEW / stock_daily / 2015-10-22
file: by_date/stock_daily/2015/2015-10-22.parquet size: 221 KB rows: 6,599 symbols: 3,407
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-10-22 | AAPL | Stock | 28.5825 | 28.875 | 28.525 | 28.875 | 166616400.0 |
| 2015-10-22 | MSFT | Stock | 47.53 | 48.95 | 47.09 | 48.03 | 56637100.0 |
| 2015-10-22 | NVDA | Stock | 0.6932 | 0.7123 | 0.6922 | 0.71 | 306884000.0 |
| 2015-10-22 | AMZN | Stock | 28.135 | 28.4575 | 27.8335 | 28.1955 | 155588000.0 |
| 2015-10-22 | GOOGL | Stock | 33.772 | 34.4025 | 33.585 | 34.057 | 88631900.0 |
| 2015-10-22 | META | Stock | 97.79 | 99.73 | 97.55 | 99.67 | 26392100.0 |
| 2015-10-22 | TSLA | Stock | 14.104 | 14.3833 | 13.96 | 14.1147 | 42378000.0 |
| 2015-10-22 | TLT | Stock | 124.1 | 124.78 | 123.51 | 124.26 | 6934112.0 |
| 2015-10-22 | ES | Stock | 52.16 | 52.85 | 52.03 | 52.7 | 1080000.0 |
| 2015-10-22 | CL | Stock | 67.15 | 68.86 | 66.67 | 68.64 | 3660400.0 |
| 2015-10-22 | A | Stock | 36.03 | 36.95 | 36.0 | 36.09 | 3696200.0 |
| 2015-10-22 | AA.B-DELISTED | Stock | 33.43 | 34.04 | 33.12 | 33.37 | 42681.0 |
| 2015-10-22 | AABA-DELISTED | Stock | 31.27 | 31.9 | 31.21 | 31.67 | 17611968.0 |
| 2015-10-22 | AAC-DELISTED | Stock | 26.71 | 26.71 | 24.83 | 25.65 | 359973.0 |
| 2015-10-22 | AACG | Stock | 3.91 | 4.18 | 3.7 | 3.85 | 36300.0 |
| 2015-10-22 | AAIC-DELISTED | Stock | 15.24 | 15.45 | 15.2 | 15.27 | 120080.0 |
| 2015-10-22 | AAL | Stock | 44.89 | 46.01 | 44.36 | 45.99 | 14444600.0 |
| 2015-10-22 | AAMC-DELISTED | Stock | 8.1618 | 8.4529 | 7.8353 | 8.1029 | 26394.0 |
| 2015-10-22 | AAME | Stock | 4.38 | 4.38 | 4.23 | 4.23 | 3200.0 |
| 2015-10-22 | AAMI | Stock | 14.54 | 15.0 | 14.54 | 14.85 | 303000.0 |
| 2015-10-22 | AAOI | Stock | 18.19 | 19.66 | 17.865 | 19.38 | 484000.0 |
| 2015-10-22 | AAON | Stock | 13.76 | 14.18 | 13.62 | 14.0733 | 191700.0 |
| 2015-10-22 | AAP | Stock | 192.89 | 193.9 | 191.28 | 191.87 | 705200.0 |
| 2015-10-22 | AAT | Stock | 43.16 | 43.55 | 43.1 | 43.24 | 295400.0 |
| 2015-10-22 | AAU-DELISTED | Stock | 0.6 | 0.605 | 0.58 | 0.59 | 145195.0 |
| 2015-10-22 | AAUAF-DELISTED | Stock | 0.6 | 0.605 | 0.58 | 0.59 | 145720.0 |
| 2015-10-22 | AAV-DELISTED | Stock | 5.85 | 6.0 | 5.85 | 5.91 | 48934.0 |
| 2015-10-22 | AAVL-DELISTED | Stock | 7.87 | 8.01 | 7.5 | 7.63 | 395757.0 |
| 2015-10-22 | AAWW-DELISTED | Stock | 40.48 | 41.54 | 40.01 | 41.52 | 201065.0 |
| 2015-10-22 | AAXJ | Stock | 57.5 | 58.33 | 57.5 | 58.25 | 644332.0 |
| 2015-10-22 | AAXN-DELISTED | Stock | 21.86 | 22.26 | 21.63 | 22.03 | 933270.0 |
| 2015-10-22 | AB | Stock | 26.2 | 27.68 | 26.2 | 27.32 | 297700.0 |
| 2015-10-22 | ABAC-DELISTED | Stock | 0.6199 | 0.62 | 0.55 | 0.6014 | 27639.0 |
| 2015-10-22 | ABAX-DELISTED | Stock | 43.96 | 44.198 | 41.53 | 42.11 | 322171.0 |
| 2015-10-22 | ABB-DELISTED | Stock | 17.9 | 18.27 | 17.87 | 18.15 | 2860505.0 |
| 2015-10-22 | ABBNY-DELISTED | Stock | 17.9 | 18.27 | 17.87 | 18.16 | 4407249.0 |
| 2015-10-22 | ABBV | Stock | 53.88 | 54.44 | 45.45 | 48.27 | 46517700.0 |
| 2015-10-22 | ABC-DELISTED | Stock | 92.88 | 93.69 | 91.79 | 92.8 | 2961549.0 |
| 2015-10-22 | ABCB | Stock | 28.6 | 29.17 | 28.43 | 28.67 | 120800.0 |
| 2015-10-22 | ABCD-DELISTED | Stock | 4.9 | 4.96 | 4.84 | 4.95 | 66635.0 |
| 2015-10-22 | ABCO-DELISTED | Stock | 46.38 | 46.99 | 44.15 | 44.51 | 314459.0 |
| 2015-10-22 | ABCW-DELISTED | Stock | 42.16 | 42.41 | 41.72 | 41.89 | 15921.0 |
| 2015-10-22 | ABDC-DELISTED | Stock | 12.73 | 12.73 | 12.0 | 12.36 | 31146.0 |
| 2015-10-22 | ABE-DELISTED | Stock | 11.37 | 11.49 | 11.33 | 11.49 | 3373.0 |
| 2015-10-22 | ABEO | Stock | 95.25 | 98.0 | 93.5 | 96.0 | 5048.0 |
| 2015-10-22 | ABEOW-DELISTED | Stock | 1.39 | 1.4 | 1.3501 | 1.36 | 1200.0 |
| 2015-10-22 | ABEV | Stock | 4.95 | 5.05 | 4.93 | 5.0 | 44199100.0 |
| 2015-10-22 | ABG | Stock | 78.31 | 81.52 | 78.02 | 78.99 | 1108900.0 |
| 2015-10-22 | ABGB-DELISTED | Stock | 4.86 | 4.89 | 4.75 | 4.83 | 71018.0 |
| 2015-10-22 | ABIL-DELISTED | Stock | 10.09 | 10.1 | 10.09 | 10.09 | 900.0 |
> showing 50 of 6,599 rows — these rows as CSV