PREVIEW / stock_daily / 2015-08-12
file: by_date/stock_daily/2015/2015-08-12.parquet size: 223 KB rows: 6,650 symbols: 3,455
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-12 | AAPL | Stock | 28.1325 | 28.855 | 27.4075 | 28.81 | 404870000.0 |
| 2015-08-12 | MSFT | Stock | 46.19 | 46.9 | 45.71 | 46.74 | 30181400.0 |
| 2015-08-12 | NVDA | Stock | 0.582 | 0.5973 | 0.582 | 0.593 | 384048000.0 |
| 2015-08-12 | AMZN | Stock | 26.1875 | 26.375 | 25.653 | 26.2955 | 79246000.0 |
| 2015-08-12 | GOOGL | Stock | 34.7245 | 34.8 | 34.0255 | 34.5735 | 58646560.0 |
| 2015-08-12 | META | Stock | 92.7 | 94.44 | 91.19 | 94.19 | 27050500.0 |
| 2015-08-12 | TSLA | Stock | 15.6667 | 15.9847 | 15.516 | 15.878 | 55920000.0 |
| 2015-08-12 | TLT | Stock | 124.93 | 125.71 | 124.0 | 124.07 | 8455249.0 |
| 2015-08-12 | ES | Stock | 50.42 | 51.15 | 50.1 | 50.91 | 1289200.0 |
| 2015-08-12 | CL | Stock | 67.99 | 68.13 | 66.97 | 68.0 | 3310600.0 |
| 2015-08-12 | A | Stock | 39.05 | 39.11 | 38.27 | 38.89 | 3431000.0 |
| 2015-08-12 | AA.B-DELISTED | Stock | 34.85 | 35.42 | 34.63 | 35.28 | 44694.0 |
| 2015-08-12 | AABA-DELISTED | Stock | 34.26 | 34.77 | 33.85 | 34.505 | 29874710.0 |
| 2015-08-12 | AAC-DELISTED | Stock | 17.82 | 20.29 | 17.7 | 19.52 | 569627.0 |
| 2015-08-12 | AACG | Stock | 3.2 | 3.26 | 2.72 | 3.08 | 30200.0 |
| 2015-08-12 | AAIC-DELISTED | Stock | 18.12 | 18.2 | 17.95 | 18.13 | 209734.0 |
| 2015-08-12 | AAL | Stock | 42.37 | 42.68 | 40.68 | 42.52 | 10391900.0 |
| 2015-08-12 | AAMC-DELISTED | Stock | 29.4118 | 30.4559 | 29.4118 | 29.4147 | 284090.0 |
| 2015-08-12 | AAME | Stock | 3.67 | 3.76 | 3.62 | 3.64 | 14100.0 |
| 2015-08-12 | AAMI | Stock | 17.73 | 17.73 | 17.11 | 17.38 | 210200.0 |
| 2015-08-12 | AAOI | Stock | 21.8 | 22.49 | 21.55 | 22.38 | 489200.0 |
| 2015-08-12 | AAON | Stock | 15.14 | 15.3933 | 15.0733 | 15.28 | 137100.0 |
| 2015-08-12 | AAP | Stock | 170.69 | 172.58 | 169.4 | 172.0 | 2965500.0 |
| 2015-08-12 | AAT | Stock | 40.63 | 41.26 | 40.51 | 41.21 | 264200.0 |
| 2015-08-12 | AAU-DELISTED | Stock | 0.711 | 0.75 | 0.66 | 0.6754 | 203870.0 |
| 2015-08-12 | AAUAF-DELISTED | Stock | 0.711 | 0.75 | 0.66 | 0.6754 | 204571.0 |
| 2015-08-12 | AAV-DELISTED | Stock | 5.63 | 5.72 | 5.43 | 5.54 | 127559.0 |
| 2015-08-12 | AAVL-DELISTED | Stock | 13.8 | 14.53 | 13.75 | 14.32 | 325173.0 |
| 2015-08-12 | AAWW-DELISTED | Stock | 45.1 | 45.17 | 44.22 | 45.17 | 625237.0 |
| 2015-08-12 | AAXJ | Stock | 56.49 | 56.75 | 56.3025 | 56.7 | 4130129.0 |
| 2015-08-12 | AAXN-DELISTED | Stock | 23.6 | 23.85 | 22.73 | 23.25 | 1781098.0 |
| 2015-08-12 | AB | Stock | 28.08 | 28.09 | 27.27 | 27.9 | 362500.0 |
| 2015-08-12 | ABAC-DELISTED | Stock | 0.99 | 0.99 | 0.92 | 0.95 | 5913.0 |
| 2015-08-12 | ABAX-DELISTED | Stock | 48.26 | 48.76 | 47.638 | 48.27 | 144340.0 |
| 2015-08-12 | ABB-DELISTED | Stock | 20.11 | 20.33 | 20.05 | 20.31 | 2248215.0 |
| 2015-08-12 | ABBNY-DELISTED | Stock | 20.11 | 20.33 | 20.05 | 20.32 | 2668635.0 |
| 2015-08-12 | ABBV | Stock | 67.83 | 68.92 | 67.24 | 68.75 | 8337600.0 |
| 2015-08-12 | ABC-DELISTED | Stock | 104.19 | 105.84 | 102.45 | 104.38 | 1488034.0 |
| 2015-08-12 | ABCB | Stock | 28.02 | 28.1 | 27.21 | 27.77 | 115900.0 |
| 2015-08-12 | ABCD-DELISTED | Stock | 4.24 | 4.31 | 4.15 | 4.29 | 75210.0 |
| 2015-08-12 | ABCO-DELISTED | Stock | 49.67 | 50.92 | 49.34 | 49.85 | 655137.0 |
| 2015-08-12 | ABCW-DELISTED | Stock | 39.84 | 39.84 | 39.3 | 39.82 | 13943.0 |
| 2015-08-12 | ABDC-DELISTED | Stock | 12.59 | 12.75 | 12.4 | 12.67 | 32779.0 |
| 2015-08-12 | ABE-DELISTED | Stock | 11.82 | 11.9578 | 11.82 | 11.9578 | 731.0 |
| 2015-08-12 | ABEO | Stock | 145.25 | 148.75 | 137.75 | 144.25 | 10392.0 |
| 2015-08-12 | ABEOW-DELISTED | Stock | 2.26 | 2.5153 | 2.07 | 2.35 | 10156.0 |
| 2015-08-12 | ABEV | Stock | 5.48 | 5.48 | 5.38 | 5.43 | 18559100.0 |
| 2015-08-12 | ABG | Stock | 81.6 | 82.37 | 80.23 | 82.08 | 465800.0 |
| 2015-08-12 | ABGB-DELISTED | Stock | 5.49 | 5.55 | 5.04 | 5.155 | 343263.0 |
| 2015-08-12 | ABM | Stock | 33.08 | 33.21 | 32.54 | 33.06 | 179300.0 |
> showing 50 of 6,650 rows — these rows as CSV