PREVIEW / stock_daily / 2015-05-12
file: by_date/stock_daily/2015/2015-05-12.parquet size: 223 KB rows: 6,632 symbols: 3,483
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-12 | AAPL | Stock | 31.4 | 31.72 | 31.205 | 31.4675 | 192640000.0 |
| 2015-05-12 | MSFT | Stock | 46.85 | 47.68 | 46.42 | 47.35 | 29928300.0 |
| 2015-05-12 | NVDA | Stock | 0.512 | 0.525 | 0.5118 | 0.5207 | 388800000.0 |
| 2015-05-12 | AMZN | Stock | 21.554 | 21.6625 | 21.3355 | 21.551 | 38956000.0 |
| 2015-05-12 | GOOGL | Stock | 27.1405 | 27.148 | 26.75 | 26.9365 | 35282460.0 |
| 2015-05-12 | META | Stock | 77.87 | 77.89 | 76.79 | 77.46 | 21285300.0 |
| 2015-05-12 | TSLA | Stock | 16.0073 | 16.4233 | 15.8793 | 16.316 | 95451000.0 |
| 2015-05-12 | TLT | Stock | 119.14 | 120.63 | 118.82 | 119.84 | 15861707.0 |
| 2015-05-12 | ES | Stock | 48.19 | 48.8 | 47.94 | 48.71 | 1871500.0 |
| 2015-05-12 | CL | Stock | 67.52 | 68.11 | 67.33 | 67.88 | 3209000.0 |
| 2015-05-12 | A | Stock | 42.36 | 42.5 | 41.5 | 41.91 | 2617800.0 |
| 2015-05-12 | AA.B-DELISTED | Stock | 46.25 | 46.27 | 45.82 | 46.0 | 30664.0 |
| 2015-05-12 | AABA-DELISTED | Stock | 44.3 | 44.31 | 43.69 | 43.845 | 13501166.0 |
| 2015-05-12 | AAC-DELISTED | Stock | 32.56 | 33.8885 | 32.4016 | 33.6 | 181722.0 |
| 2015-05-12 | AACG | Stock | 4.8 | 4.8 | 4.74 | 4.74 | 6400.0 |
| 2015-05-12 | AAIC-DELISTED | Stock | 21.11 | 21.251 | 21.06 | 21.14 | 239694.0 |
| 2015-05-12 | AAL | Stock | 49.11 | 49.4 | 48.63 | 48.85 | 6820500.0 |
| 2015-05-12 | AAMC-DELISTED | Stock | 57.2471 | 57.2471 | 55.8824 | 56.4706 | 11091.0 |
| 2015-05-12 | AAME | Stock | 3.89 | 3.89 | 3.8 | 3.85 | 4700.0 |
| 2015-05-12 | AAMI | Stock | 19.02 | 19.45 | 18.73 | 19.36 | 72900.0 |
| 2015-05-12 | AAOI | Stock | 14.8 | 14.89 | 14.37 | 14.81 | 140900.0 |
| 2015-05-12 | AAON | Stock | 15.06 | 15.2067 | 14.88 | 15.2 | 275100.0 |
| 2015-05-12 | AAP | Stock | 144.74 | 147.17 | 144.1 | 147.13 | 806600.0 |
| 2015-05-12 | AAT | Stock | 39.71 | 40.13 | 39.3 | 40.1 | 136300.0 |
| 2015-05-12 | AAU-DELISTED | Stock | 0.8 | 0.8299 | 0.8 | 0.8053 | 105014.0 |
| 2015-05-12 | AAUAF-DELISTED | Stock | 0.8 | 0.8299 | 0.8 | 0.8053 | 106539.0 |
| 2015-05-12 | AAV-DELISTED | Stock | 6.29 | 6.54 | 6.25 | 6.44 | 141485.0 |
| 2015-05-12 | AAVL-DELISTED | Stock | 34.87 | 34.87 | 33.37 | 33.85 | 168187.0 |
| 2015-05-12 | AAWW-DELISTED | Stock | 56.13 | 56.86 | 55.56 | 56.56 | 485815.0 |
| 2015-05-12 | AAXJ | Stock | 66.64 | 66.9 | 66.45 | 66.785 | 960404.0 |
| 2015-05-12 | AAXN-DELISTED | Stock | 32.85 | 34.0 | 32.525 | 33.66 | 2477927.0 |
| 2015-05-12 | AB | Stock | 30.82 | 30.91 | 30.08 | 30.57 | 247100.0 |
| 2015-05-12 | ABAC-DELISTED | Stock | 1.61 | 1.62 | 1.61 | 1.62 | 5960.0 |
| 2015-05-12 | ABAX-DELISTED | Stock | 53.19 | 53.19 | 52.05 | 52.09 | 207772.0 |
| 2015-05-12 | ABB-DELISTED | Stock | 21.76 | 21.86 | 21.72 | 21.73 | 1505159.0 |
| 2015-05-12 | ABBNY-DELISTED | Stock | 21.76 | 21.86 | 21.72 | 21.74 | 1594794.0 |
| 2015-05-12 | ABBV | Stock | 64.75 | 65.27 | 64.59 | 64.81 | 5927000.0 |
| 2015-05-12 | ABC-DELISTED | Stock | 114.5 | 115.4497 | 114.265 | 115.04 | 1775639.0 |
| 2015-05-12 | ABCB | Stock | 25.05 | 25.16 | 24.6 | 25.02 | 74900.0 |
| 2015-05-12 | ABCD-DELISTED | Stock | 2.98 | 3.0 | 2.95 | 2.97 | 24907.0 |
| 2015-05-12 | ABCO-DELISTED | Stock | 48.08 | 48.48 | 47.24 | 48.01 | 213518.0 |
| 2015-05-12 | ABCW-DELISTED | Stock | 36.47 | 37.03 | 35.9 | 36.56 | 10817.0 |
| 2015-05-12 | ABDC-DELISTED | Stock | 13.86 | 13.975 | 13.6601 | 13.84 | 40150.0 |
| 2015-05-12 | ABE-DELISTED | Stock | 13.03 | 13.16 | 12.94 | 13.05 | 4896.0 |
| 2015-05-12 | ABEO | Stock | 226.5 | 257.25 | 220.25 | 225.0 | 657064.0 |
| 2015-05-12 | ABEOW-DELISTED | Stock | 3.99 | 5.19 | 3.77 | 4.05 | 486775.0 |
| 2015-05-12 | ABEV | Stock | 6.48 | 6.53 | 6.43 | 6.44 | 17017000.0 |
| 2015-05-12 | ABG | Stock | 85.28 | 85.97 | 84.41 | 85.17 | 259400.0 |
| 2015-05-12 | ABGB-DELISTED | Stock | 16.97 | 17.0825 | 16.88 | 16.89 | 11492.0 |
| 2015-05-12 | ABIL-DELISTED | Stock | 9.85 | 9.95 | 9.75 | 9.9 | 30357.0 |
> showing 50 of 6,632 rows — these rows as CSV