PREVIEW / stock_daily / 2015-10-06
file: by_date/stock_daily/2015/2015-10-06.parquet size: 222 KB rows: 6,613 symbols: 3,417
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-06 | AAPL | Stock | 27.6575 | 27.935 | 27.4425 | 27.8275 | 192787200.0 |
| 2015-10-06 | MSFT | Stock | 46.33 | 47.18 | 46.22 | 46.75 | 27017200.0 |
| 2015-10-06 | NVDA | Stock | 0.6288 | 0.6465 | 0.6263 | 0.6438 | 453216000.0 |
| 2015-10-06 | AMZN | Stock | 27.275 | 27.575 | 26.6665 | 26.874 | 90056000.0 |
| 2015-10-06 | GOOGL | Stock | 33.4675 | 33.94 | 33.1541 | 33.582 | 43148180.0 |
| 2015-10-06 | META | Stock | 94.08 | 94.17 | 92.34 | 92.8 | 22172800.0 |
| 2015-10-06 | TSLA | Stock | 16.0 | 16.202 | 15.7053 | 16.0973 | 78378000.0 |
| 2015-10-06 | TLT | Stock | 122.55 | 123.6 | 122.4101 | 123.4 | 5687786.0 |
| 2015-10-06 | ES | Stock | 50.99 | 51.11 | 50.36 | 50.64 | 1545300.0 |
| 2015-10-06 | CL | Stock | 65.3 | 65.3 | 64.73 | 64.79 | 2941500.0 |
| 2015-10-06 | A | Stock | 35.13 | 35.21 | 34.53 | 34.9 | 1833700.0 |
| 2015-10-06 | AA.B-DELISTED | Stock | 35.79 | 37.38 | 35.79 | 37.2 | 34206.0 |
| 2015-10-06 | AABA-DELISTED | Stock | 30.79 | 31.185 | 30.66 | 30.95 | 9661609.0 |
| 2015-10-06 | AAC-DELISTED | Stock | 27.86 | 28.46 | 26.4 | 26.98 | 305426.0 |
| 2015-10-06 | AACG | Stock | 2.91 | 3.15 | 2.9 | 3.09 | 11600.0 |
| 2015-10-06 | AAIC-DELISTED | Stock | 14.52 | 14.76 | 14.4801 | 14.64 | 167370.0 |
| 2015-10-06 | AAL | Stock | 39.95 | 40.37 | 38.08 | 38.13 | 12985800.0 |
| 2015-10-06 | AAMC-DELISTED | Stock | 7.2941 | 7.8235 | 7.2941 | 7.5 | 38838.0 |
| 2015-10-06 | AAME | Stock | 4.2 | 4.2 | 4.05 | 4.09 | 3300.0 |
| 2015-10-06 | AAMI | Stock | 15.25 | 15.35 | 14.85 | 14.85 | 173900.0 |
| 2015-10-06 | AAOI | Stock | 19.47 | 19.92 | 18.7 | 19.08 | 120400.0 |
| 2015-10-06 | AAON | Stock | 13.52 | 13.68 | 13.3267 | 13.3533 | 159000.0 |
| 2015-10-06 | AAP | Stock | 191.34 | 192.44 | 189.4 | 191.1 | 543400.0 |
| 2015-10-06 | AAT | Stock | 41.61 | 41.9 | 41.29 | 41.35 | 344700.0 |
| 2015-10-06 | AAU-DELISTED | Stock | 0.524 | 0.575 | 0.5239 | 0.5678 | 65113.0 |
| 2015-10-06 | AAUAF-DELISTED | Stock | 0.524 | 0.575 | 0.5239 | 0.5678 | 65539.0 |
| 2015-10-06 | AAV-DELISTED | Stock | 5.92 | 6.1767 | 5.91 | 6.12 | 171206.0 |
| 2015-10-06 | AAVL-DELISTED | Stock | 8.63 | 8.76 | 8.14 | 8.47 | 365868.0 |
| 2015-10-06 | AAWW-DELISTED | Stock | 39.07 | 39.865 | 36.78 | 39.24 | 277614.0 |
| 2015-10-06 | AAXJ | Stock | 55.0 | 55.17 | 54.77 | 54.92 | 1290495.0 |
| 2015-10-06 | AAXN-DELISTED | Stock | 23.35 | 24.22 | 23.23 | 23.97 | 1136252.0 |
| 2015-10-06 | AB | Stock | 26.56 | 26.94 | 26.46 | 26.61 | 218300.0 |
| 2015-10-06 | ABAC-DELISTED | Stock | 0.5496 | 0.5496 | 0.5 | 0.5 | 2000.0 |
| 2015-10-06 | ABAX-DELISTED | Stock | 45.75 | 46.11 | 44.16 | 44.26 | 90235.0 |
| 2015-10-06 | ABB-DELISTED | Stock | 18.17 | 18.36 | 18.16 | 18.28 | 1949003.0 |
| 2015-10-06 | ABBNY-DELISTED | Stock | 18.17 | 18.36 | 18.16 | 18.29 | 2199962.0 |
| 2015-10-06 | ABBV | Stock | 56.26 | 56.67 | 53.96 | 55.08 | 9008300.0 |
| 2015-10-06 | ABC-DELISTED | Stock | 95.5 | 95.9 | 92.27 | 93.05 | 3186684.0 |
| 2015-10-06 | ABCB | Stock | 28.24 | 28.38 | 27.72 | 27.95 | 252200.0 |
| 2015-10-06 | ABCD-DELISTED | Stock | 4.85 | 4.9 | 4.76 | 4.79 | 24044.0 |
| 2015-10-06 | ABCO-DELISTED | Stock | 42.3 | 42.32 | 40.87 | 40.96 | 330168.0 |
| 2015-10-06 | ABCW-DELISTED | Stock | 42.0 | 42.4 | 40.56 | 40.6101 | 21585.0 |
| 2015-10-06 | ABDC-DELISTED | Stock | 11.82 | 11.9199 | 11.72 | 11.8 | 19015.0 |
| 2015-10-06 | ABE-DELISTED | Stock | 11.14 | 11.2096 | 11.1 | 11.2096 | 4848.0 |
| 2015-10-06 | ABEO | Stock | 106.25 | 106.25 | 97.5 | 100.5 | 6100.0 |
| 2015-10-06 | ABEOW-DELISTED | Stock | 1.29 | 1.6 | 1.29 | 1.6 | 1270.0 |
| 2015-10-06 | ABEV | Stock | 5.22 | 5.27 | 5.1 | 5.12 | 14900600.0 |
| 2015-10-06 | ABG | Stock | 85.27 | 85.72 | 83.18 | 83.9 | 244400.0 |
| 2015-10-06 | ABGB-DELISTED | Stock | 5.02 | 5.31 | 4.97 | 5.0 | 43286.0 |
| 2015-10-06 | ABM | Stock | 28.17 | 28.34 | 27.94 | 28.04 | 341600.0 |
> showing 50 of 6,613 rows — these rows as CSV