PREVIEW / stock_daily / 2015-10-09
file: by_date/stock_daily/2015/2015-10-09.parquet size: 221 KB rows: 6,583 symbols: 3,398
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-09 | AAPL | Stock | 27.5 | 28.07 | 27.3725 | 28.03 | 211064400.0 |
| 2015-10-09 | MSFT | Stock | 47.45 | 47.54 | 46.92 | 47.11 | 28600600.0 |
| 2015-10-09 | NVDA | Stock | 0.6508 | 0.657 | 0.6395 | 0.6518 | 423248000.0 |
| 2015-10-09 | AMZN | Stock | 26.724 | 27.0895 | 26.5135 | 26.99 | 70748000.0 |
| 2015-10-09 | GOOGL | Stock | 33.3745 | 33.7042 | 33.118 | 33.562 | 32123560.0 |
| 2015-10-09 | META | Stock | 92.9 | 93.74 | 92.24 | 93.24 | 20012900.0 |
| 2015-10-09 | TSLA | Stock | 14.7287 | 14.958 | 14.5573 | 14.7127 | 92376000.0 |
| 2015-10-09 | TLT | Stock | 121.97 | 122.64 | 121.9 | 122.28 | 9038104.0 |
| 2015-10-09 | ES | Stock | 51.0 | 51.02 | 50.48 | 50.63 | 1007900.0 |
| 2015-10-09 | CL | Stock | 66.0 | 66.42 | 65.78 | 66.34 | 3478400.0 |
| 2015-10-09 | A | Stock | 35.94 | 36.34 | 35.88 | 36.23 | 3232900.0 |
| 2015-10-09 | AA.B-DELISTED | Stock | 37.03 | 37.03 | 35.9837 | 36.12 | 121460.0 |
| 2015-10-09 | AABA-DELISTED | Stock | 32.36 | 32.69 | 31.99 | 32.515 | 11350264.0 |
| 2015-10-09 | AAC-DELISTED | Stock | 26.74 | 27.11 | 25.72 | 26.24 | 161939.0 |
| 2015-10-09 | AACG | Stock | 3.1 | 3.21 | 3.1 | 3.1 | 7600.0 |
| 2015-10-09 | AAIC-DELISTED | Stock | 15.25 | 15.41 | 15.19 | 15.34 | 144250.0 |
| 2015-10-09 | AAL | Stock | 40.27 | 42.49 | 40.25 | 42.42 | 16835500.0 |
| 2015-10-09 | AAMC-DELISTED | Stock | 8.75 | 10.0294 | 8.5206 | 9.5118 | 87706.0 |
| 2015-10-09 | AAME | Stock | 4.27 | 4.3 | 4.11 | 4.13 | 9200.0 |
| 2015-10-09 | AAMI | Stock | 15.27 | 15.32 | 14.85 | 14.93 | 67900.0 |
| 2015-10-09 | AAOI | Stock | 20.29 | 20.61 | 20.04 | 20.1 | 206400.0 |
| 2015-10-09 | AAON | Stock | 14.24 | 14.2667 | 13.9267 | 13.9333 | 169650.0 |
| 2015-10-09 | AAP | Stock | 186.88 | 189.91 | 186.13 | 189.52 | 785600.0 |
| 2015-10-09 | AAT | Stock | 42.22 | 42.32 | 41.91 | 42.09 | 117800.0 |
| 2015-10-09 | AAU-DELISTED | Stock | 0.55 | 0.57 | 0.55 | 0.5508 | 62587.0 |
| 2015-10-09 | AAUAF-DELISTED | Stock | 0.55 | 0.57 | 0.55 | 0.5508 | 62947.0 |
| 2015-10-09 | AAV-DELISTED | Stock | 6.34 | 6.45 | 6.21 | 6.27 | 208274.0 |
| 2015-10-09 | AAVL-DELISTED | Stock | 8.48 | 8.63 | 8.375 | 8.47 | 254982.0 |
| 2015-10-09 | AAWW-DELISTED | Stock | 41.14 | 42.19 | 40.46 | 40.89 | 162046.0 |
| 2015-10-09 | AAXJ | Stock | 57.37 | 57.6599 | 56.92 | 57.13 | 506678.0 |
| 2015-10-09 | AAXN-DELISTED | Stock | 26.48 | 26.48 | 24.55 | 24.7 | 1705652.0 |
| 2015-10-09 | AB | Stock | 26.79 | 27.08 | 26.62 | 26.72 | 147100.0 |
| 2015-10-09 | ABAC-DELISTED | Stock | 0.51 | 0.5399 | 0.489 | 0.51 | 34456.0 |
| 2015-10-09 | ABAX-DELISTED | Stock | 44.86 | 46.3 | 44.86 | 46.21 | 120952.0 |
| 2015-10-09 | ABB-DELISTED | Stock | 19.0 | 19.12 | 18.87 | 18.96 | 1797859.0 |
| 2015-10-09 | ABBNY-DELISTED | Stock | 19.0 | 19.12 | 18.87 | 18.96 | 1874881.0 |
| 2015-10-09 | ABBV | Stock | 56.18 | 56.5 | 55.47 | 55.64 | 7178500.0 |
| 2015-10-09 | ABC-DELISTED | Stock | 93.23 | 93.69 | 92.33 | 92.83 | 2528431.0 |
| 2015-10-09 | ABCB | Stock | 28.53 | 28.54 | 28.16 | 28.17 | 76000.0 |
| 2015-10-09 | ABCD-DELISTED | Stock | 4.79 | 4.84 | 4.78 | 4.8399 | 6417.0 |
| 2015-10-09 | ABCO-DELISTED | Stock | 44.23 | 45.55 | 44.17 | 45.29 | 194915.0 |
| 2015-10-09 | ABCW-DELISTED | Stock | 42.35 | 42.35 | 40.8 | 40.8 | 19104.0 |
| 2015-10-09 | ABDC-DELISTED | Stock | 12.39 | 12.5 | 12.25 | 12.44 | 18504.0 |
| 2015-10-09 | ABE-DELISTED | Stock | 11.36 | 11.5 | 11.3345 | 11.44 | 3248.0 |
| 2015-10-09 | ABEO | Stock | 105.0 | 115.0 | 102.5 | 111.0 | 8180.0 |
| 2015-10-09 | ABEOW-DELISTED | Stock | 1.61 | 1.7 | 1.61 | 1.69 | 2700.0 |
| 2015-10-09 | ABEV | Stock | 5.21 | 5.3 | 5.15 | 5.22 | 12198100.0 |
| 2015-10-09 | ABG | Stock | 84.49 | 85.02 | 83.57 | 84.26 | 299900.0 |
| 2015-10-09 | ABGB-DELISTED | Stock | 4.91 | 4.95 | 4.73 | 4.84 | 32389.0 |
| 2015-10-09 | ABIL-DELISTED | Stock | 9.9501 | 9.9684 | 9.95 | 9.95 | 916.0 |
> showing 50 of 6,583 rows — these rows as CSV