PREVIEW / stock_daily / 2015-05-13
file: by_date/stock_daily/2015/2015-05-13.parquet size: 222 KB rows: 6,620 symbols: 3,487
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-13 | AAPL | Stock | 31.5375 | 31.7975 | 31.4675 | 31.5025 | 138776800.0 |
| 2015-05-13 | MSFT | Stock | 48.19 | 48.32 | 47.57 | 47.63 | 34184600.0 |
| 2015-05-13 | NVDA | Stock | 0.5245 | 0.5285 | 0.5188 | 0.5238 | 308524000.0 |
| 2015-05-13 | AMZN | Stock | 21.499 | 21.6765 | 21.29 | 21.3435 | 39926000.0 |
| 2015-05-13 | GOOGL | Stock | 27.0235 | 27.192 | 26.949 | 26.9745 | 24238400.0 |
| 2015-05-13 | META | Stock | 77.72 | 78.53 | 77.65 | 78.44 | 21512300.0 |
| 2015-05-13 | TSLA | Stock | 16.5073 | 16.5533 | 16.15 | 16.212 | 81603000.0 |
| 2015-05-13 | TLT | Stock | 120.65 | 120.72 | 118.64 | 118.88 | 15759976.0 |
| 2015-05-13 | ES | Stock | 48.96 | 49.06 | 47.82 | 47.94 | 1683800.0 |
| 2015-05-13 | CL | Stock | 68.02 | 68.48 | 67.49 | 67.6 | 2315500.0 |
| 2015-05-13 | A | Stock | 42.05 | 42.39 | 41.71 | 41.81 | 1992800.0 |
| 2015-05-13 | AA.B-DELISTED | Stock | 46.23 | 46.75 | 46.11 | 46.22 | 38937.0 |
| 2015-05-13 | AABA-DELISTED | Stock | 44.03 | 44.67 | 43.98 | 44.39 | 10378223.0 |
| 2015-05-13 | AAC-DELISTED | Stock | 34.09 | 35.0 | 33.8 | 34.21 | 200398.0 |
| 2015-05-13 | AACG | Stock | 4.74 | 4.8 | 4.5 | 4.66 | 53200.0 |
| 2015-05-13 | AAIC-DELISTED | Stock | 21.15 | 21.25 | 21.11 | 21.16 | 197435.0 |
| 2015-05-13 | AAL | Stock | 49.27 | 49.85 | 48.4 | 48.49 | 8553100.0 |
| 2015-05-13 | AAMC-DELISTED | Stock | 55.6618 | 55.6618 | 53.2353 | 53.4853 | 38168.0 |
| 2015-05-13 | AAME | Stock | 3.79 | 3.82 | 3.75 | 3.79 | 2500.0 |
| 2015-05-13 | AAMI | Stock | 19.36 | 19.96 | 19.158 | 19.67 | 159800.0 |
| 2015-05-13 | AAOI | Stock | 14.85 | 15.03 | 14.42 | 14.68 | 136700.0 |
| 2015-05-13 | AAON | Stock | 15.2 | 15.4733 | 15.0 | 15.4667 | 240900.0 |
| 2015-05-13 | AAP | Stock | 147.0 | 149.49 | 146.63 | 149.38 | 1286100.0 |
| 2015-05-13 | AAT | Stock | 40.2 | 40.57 | 39.42 | 39.61 | 221700.0 |
| 2015-05-13 | AAU-DELISTED | Stock | 0.82 | 0.8375 | 0.8 | 0.81 | 253546.0 |
| 2015-05-13 | AAUAF-DELISTED | Stock | 0.82 | 0.8375 | 0.8 | 0.81 | 254901.0 |
| 2015-05-13 | AAV-DELISTED | Stock | 6.46 | 6.59 | 6.28 | 6.33 | 294736.0 |
| 2015-05-13 | AAVL-DELISTED | Stock | 33.95 | 36.35 | 33.51 | 35.61 | 203275.0 |
| 2015-05-13 | AAWW-DELISTED | Stock | 56.85 | 56.88 | 56.0875 | 56.11 | 308700.0 |
| 2015-05-13 | AAXJ | Stock | 67.08 | 67.2472 | 66.8555 | 66.895 | 1363439.0 |
| 2015-05-13 | AAXN-DELISTED | Stock | 34.0 | 34.49 | 33.47 | 33.53 | 1635226.0 |
| 2015-05-13 | AB | Stock | 30.5 | 30.61 | 30.0 | 30.3 | 271800.0 |
| 2015-05-13 | ABAC-DELISTED | Stock | 1.62 | 1.75 | 1.62 | 1.685 | 13238.0 |
| 2015-05-13 | ABAX-DELISTED | Stock | 52.06 | 52.74 | 51.36 | 52.11 | 115688.0 |
| 2015-05-13 | ABB-DELISTED | Stock | 21.99 | 22.17 | 21.97 | 21.99 | 1496270.0 |
| 2015-05-13 | ABBNY-DELISTED | Stock | 21.99 | 22.17 | 21.97 | 22.0 | 1553047.0 |
| 2015-05-13 | ABBV | Stock | 64.98 | 65.32 | 64.63 | 65.3 | 8519200.0 |
| 2015-05-13 | ABC-DELISTED | Stock | 115.47 | 115.85 | 114.17 | 114.3 | 1313849.0 |
| 2015-05-13 | ABCB | Stock | 25.05 | 25.29 | 24.86 | 25.19 | 51600.0 |
| 2015-05-13 | ABCD-DELISTED | Stock | 3.06 | 3.06 | 2.94 | 2.99 | 11736.0 |
| 2015-05-13 | ABCO-DELISTED | Stock | 48.06 | 48.7 | 47.76 | 48.13 | 131744.0 |
| 2015-05-13 | ABCW-DELISTED | Stock | 36.49 | 36.82 | 36.3301 | 36.68 | 2875.0 |
| 2015-05-13 | ABDC-DELISTED | Stock | 13.79 | 13.88 | 13.65 | 13.67 | 33254.0 |
| 2015-05-13 | ABE-DELISTED | Stock | 13.11 | 13.21 | 13.11 | 13.21 | 10628.0 |
| 2015-05-13 | ABEO | Stock | 222.5 | 232.25 | 213.75 | 215.0 | 162564.0 |
| 2015-05-13 | ABEOW-DELISTED | Stock | 3.68 | 4.18 | 3.526 | 3.7 | 78657.0 |
| 2015-05-13 | ABEV | Stock | 6.46 | 6.48 | 6.34 | 6.39 | 11250800.0 |
| 2015-05-13 | ABG | Stock | 85.11 | 85.79 | 84.28 | 84.54 | 191600.0 |
| 2015-05-13 | ABGB-DELISTED | Stock | 16.87 | 17.107 | 16.84 | 16.98 | 27271.0 |
| 2015-05-13 | ABIL-DELISTED | Stock | 9.9 | 9.9 | 9.86 | 9.9 | 184675.0 |
> showing 50 of 6,620 rows — these rows as CSV