PREVIEW / stock_daily / 2015-10-21
file: by_date/stock_daily/2015/2015-10-21.parquet size: 220 KB rows: 6,600 symbols: 3,403
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-21 | AAPL | Stock | 28.5 | 28.895 | 28.425 | 28.44 | 167180800.0 |
| 2015-10-21 | MSFT | Stock | 47.92 | 47.99 | 47.11 | 47.2 | 25144300.0 |
| 2015-10-21 | NVDA | Stock | 0.6985 | 0.7028 | 0.684 | 0.6852 | 386280000.0 |
| 2015-10-21 | AMZN | Stock | 28.1935 | 28.2625 | 27.626 | 27.7885 | 66872000.0 |
| 2015-10-21 | GOOGL | Stock | 34.1605 | 34.245 | 33.535 | 33.59 | 32168720.0 |
| 2015-10-21 | META | Stock | 97.37 | 98.18 | 96.47 | 97.11 | 21917800.0 |
| 2015-10-21 | TSLA | Stock | 14.1327 | 14.3207 | 13.92 | 14.006 | 62272500.0 |
| 2015-10-21 | TLT | Stock | 123.61 | 124.22 | 123.47 | 124.05 | 6603844.0 |
| 2015-10-21 | ES | Stock | 52.27 | 52.71 | 51.93 | 52.06 | 1167400.0 |
| 2015-10-21 | CL | Stock | 66.81 | 67.5 | 66.54 | 66.83 | 2755100.0 |
| 2015-10-21 | A | Stock | 36.54 | 36.6 | 35.8 | 35.9 | 2886400.0 |
| 2015-10-21 | AA.B-DELISTED | Stock | 33.85 | 33.85 | 33.0 | 33.01 | 22307.0 |
| 2015-10-21 | AABA-DELISTED | Stock | 32.06 | 32.43 | 31.01 | 31.13 | 29564875.0 |
| 2015-10-21 | AAC-DELISTED | Stock | 27.99 | 28.04 | 25.68 | 26.49 | 177113.0 |
| 2015-10-21 | AACG | Stock | 3.77 | 3.92 | 3.77 | 3.84 | 25200.0 |
| 2015-10-21 | AAIC-DELISTED | Stock | 15.4 | 15.485 | 15.18 | 15.2 | 127164.0 |
| 2015-10-21 | AAL | Stock | 44.49 | 45.18 | 44.09 | 44.31 | 6935700.0 |
| 2015-10-21 | AAMC-DELISTED | Stock | 8.2206 | 8.3318 | 7.8618 | 7.8618 | 20444.0 |
| 2015-10-21 | AAME | Stock | 4.27 | 4.36 | 4.25 | 4.3 | 10100.0 |
| 2015-10-21 | AAMI | Stock | 14.88 | 14.88 | 14.41 | 14.47 | 157700.0 |
| 2015-10-21 | AAOI | Stock | 18.38 | 18.65 | 17.875 | 17.94 | 172000.0 |
| 2015-10-21 | AAON | Stock | 14.1533 | 14.1533 | 13.6333 | 13.64 | 164400.0 |
| 2015-10-21 | AAP | Stock | 194.5 | 196.09 | 191.75 | 192.15 | 561200.0 |
| 2015-10-21 | AAT | Stock | 43.41 | 43.68 | 42.59 | 43.06 | 139300.0 |
| 2015-10-21 | AAU-DELISTED | Stock | 0.62 | 0.62 | 0.59 | 0.6001 | 135965.0 |
| 2015-10-21 | AAUAF-DELISTED | Stock | 0.62 | 0.62 | 0.59 | 0.6001 | 136672.0 |
| 2015-10-21 | AAV-DELISTED | Stock | 6.0 | 6.01 | 5.76 | 5.8 | 147301.0 |
| 2015-10-21 | AAVL-DELISTED | Stock | 8.22 | 8.27 | 7.63 | 7.84 | 547611.0 |
| 2015-10-21 | AAWW-DELISTED | Stock | 40.77 | 41.0 | 39.88 | 40.17 | 183352.0 |
| 2015-10-21 | AAXJ | Stock | 57.56 | 57.59 | 57.03 | 57.09 | 1012642.0 |
| 2015-10-21 | AAXN-DELISTED | Stock | 22.21 | 22.25 | 21.4 | 21.825 | 2584044.0 |
| 2015-10-21 | AB | Stock | 26.5 | 26.7 | 26.35 | 26.39 | 295400.0 |
| 2015-10-21 | ABAC-DELISTED | Stock | 0.6599 | 0.6599 | 0.6099 | 0.62 | 12788.0 |
| 2015-10-21 | ABAX-DELISTED | Stock | 43.81 | 45.436 | 43.0 | 43.89 | 278965.0 |
| 2015-10-21 | ABB-DELISTED | Stock | 18.31 | 18.34 | 18.01 | 18.02 | 1793015.0 |
| 2015-10-21 | ABBNY-DELISTED | Stock | 18.31 | 18.34 | 18.01 | 18.03 | 2955252.0 |
| 2015-10-21 | ABBV | Stock | 55.28 | 55.61 | 53.07 | 53.83 | 11638800.0 |
| 2015-10-21 | ABC-DELISTED | Stock | 93.45 | 93.83 | 91.69 | 92.71 | 2515385.0 |
| 2015-10-21 | ABCB | Stock | 28.92 | 29.1 | 28.44 | 28.53 | 102700.0 |
| 2015-10-21 | ABCD-DELISTED | Stock | 5.02 | 5.02 | 4.851 | 4.9 | 12085.0 |
| 2015-10-21 | ABCO-DELISTED | Stock | 48.15 | 48.15 | 46.21 | 46.23 | 190725.0 |
| 2015-10-21 | ABCW-DELISTED | Stock | 42.37 | 42.47 | 41.8953 | 42.12 | 11255.0 |
| 2015-10-21 | ABDC-DELISTED | Stock | 12.69 | 12.69 | 12.35 | 12.58 | 21397.0 |
| 2015-10-21 | ABE-DELISTED | Stock | 11.28 | 11.33 | 11.28 | 11.3285 | 400.0 |
| 2015-10-21 | ABEO | Stock | 99.25 | 100.0 | 93.25 | 95.0 | 6464.0 |
| 2015-10-21 | ABEOW-DELISTED | Stock | 1.4 | 1.4 | 1.4 | 1.4 | 210.0 |
| 2015-10-21 | ABEV | Stock | 4.98 | 4.99 | 4.87 | 4.92 | 18494200.0 |
| 2015-10-21 | ABG | Stock | 84.12 | 84.95 | 76.51 | 77.17 | 2115900.0 |
| 2015-10-21 | ABGB-DELISTED | Stock | 5.12 | 5.21 | 5.05 | 5.05 | 71671.0 |
| 2015-10-21 | ABIL-DELISTED | Stock | 10.09 | 10.09 | 10.09 | 10.09 | 1457.0 |
> showing 50 of 6,600 rows — these rows as CSV