PREVIEW / stock_daily / 2015-11-10
file: by_date/stock_daily/2015/2015-11-10.parquet size: 221 KB rows: 6,588 symbols: 3,385
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-11-10 | AAPL | Stock | 29.225 | 29.5175 | 29.015 | 29.1925 | 236511600.0 |
| 2015-11-10 | MSFT | Stock | 54.07 | 54.13 | 53.27 | 53.51 | 55283700.0 |
| 2015-11-10 | NVDA | Stock | 0.775 | 0.7793 | 0.7538 | 0.7702 | 552260000.0 |
| 2015-11-10 | AMZN | Stock | 32.5505 | 33.0 | 32.363 | 32.984 | 69790000.0 |
| 2015-11-10 | GOOGL | Stock | 37.674 | 38.03 | 37.4205 | 37.913 | 29798580.0 |
| 2015-11-10 | META | Stock | 105.96 | 108.15 | 105.24 | 107.91 | 25031700.0 |
| 2015-11-10 | TSLA | Stock | 14.8987 | 14.9133 | 14.4053 | 14.4333 | 69255000.0 |
| 2015-11-10 | TLT | Stock | 118.5 | 119.21 | 118.38 | 118.68 | 6712535.0 |
| 2015-11-10 | ES | Stock | 49.48 | 50.45 | 49.18 | 50.37 | 1435600.0 |
| 2015-11-10 | CL | Stock | 65.67 | 66.58 | 65.58 | 66.38 | 2813700.0 |
| 2015-11-10 | A | Stock | 37.89 | 38.17 | 37.69 | 37.98 | 4338700.0 |
| 2015-11-10 | AA.B-DELISTED | Stock | 30.94 | 30.94 | 30.3088 | 30.44 | 40718.0 |
| 2015-11-10 | AABA-DELISTED | Stock | 33.45 | 34.13 | 33.26 | 34.0 | 11041993.0 |
| 2015-11-10 | AAC-DELISTED | Stock | 23.39 | 23.86 | 23.32 | 23.54 | 94904.0 |
| 2015-11-10 | AACG | Stock | 4.14 | 4.19 | 4.11 | 4.11 | 10700.0 |
| 2015-11-10 | AAIC-DELISTED | Stock | 13.69 | 13.8399 | 13.6135 | 13.76 | 225175.0 |
| 2015-11-10 | AAL | Stock | 44.66 | 45.16 | 44.02 | 44.49 | 5935300.0 |
| 2015-11-10 | AAMC-DELISTED | Stock | 7.0324 | 7.0912 | 6.1059 | 6.1824 | 106604.0 |
| 2015-11-10 | AAME | Stock | 5.0 | 5.0 | 4.84 | 4.91 | 4600.0 |
| 2015-11-10 | AAMI | Stock | 16.49 | 16.635 | 16.42 | 16.59 | 245200.0 |
| 2015-11-10 | AAOI | Stock | 16.74 | 16.97 | 16.51 | 16.91 | 470400.0 |
| 2015-11-10 | AAON | Stock | 16.1467 | 16.3733 | 15.5733 | 16.2933 | 263100.0 |
| 2015-11-10 | AAP | Stock | 193.77 | 196.12 | 193.77 | 194.11 | 1379300.0 |
| 2015-11-10 | AAT | Stock | 39.15 | 39.84 | 39.15 | 39.53 | 133900.0 |
| 2015-11-10 | AAU-DELISTED | Stock | 0.53 | 0.55 | 0.53 | 0.5498 | 64799.0 |
| 2015-11-10 | AAUAF-DELISTED | Stock | 0.53 | 0.55 | 0.53 | 0.5498 | 65292.0 |
| 2015-11-10 | AAV-DELISTED | Stock | 5.78 | 5.84 | 5.71 | 5.81 | 87080.0 |
| 2015-11-10 | AAVL-DELISTED | Stock | 9.2 | 9.2 | 7.765 | 7.99 | 888239.0 |
| 2015-11-10 | AAWW-DELISTED | Stock | 39.67 | 40.92 | 39.67 | 40.76 | 174408.0 |
| 2015-11-10 | AAXJ | Stock | 55.61 | 55.62 | 55.34 | 55.47 | 820733.0 |
| 2015-11-10 | AAXN-DELISTED | Stock | 19.05 | 19.25 | 18.55 | 18.79 | 2045374.0 |
| 2015-11-10 | AB | Stock | 25.08 | 25.29 | 24.78 | 25.17 | 127100.0 |
| 2015-11-10 | ABAC-DELISTED | Stock | 0.67 | 0.67 | 0.601 | 0.601 | 16906.0 |
| 2015-11-10 | ABAX-DELISTED | Stock | 52.08 | 52.66 | 51.78 | 52.65 | 46370.0 |
| 2015-11-10 | ABB-DELISTED | Stock | 18.73 | 18.84 | 18.65 | 18.8 | 1367867.0 |
| 2015-11-10 | ABBNY-DELISTED | Stock | 18.73 | 18.84 | 18.65 | 18.8 | 1409739.0 |
| 2015-11-10 | ABBV | Stock | 63.33 | 63.62 | 62.28 | 62.3 | 6897600.0 |
| 2015-11-10 | ABC-DELISTED | Stock | 97.628 | 99.05 | 97.308 | 99.04 | 1598324.0 |
| 2015-11-10 | ABCB | Stock | 33.46 | 33.99 | 33.4 | 33.66 | 140200.0 |
| 2015-11-10 | ABCD-DELISTED | Stock | 5.02 | 5.1 | 5.01 | 5.1 | 21300.0 |
| 2015-11-10 | ABCO-DELISTED | Stock | 51.69 | 53.025 | 51.44 | 52.9 | 332277.0 |
| 2015-11-10 | ABCW-DELISTED | Stock | 41.76 | 42.13 | 41.3268 | 42.0 | 49900.0 |
| 2015-11-10 | ABDC-DELISTED | Stock | 12.05 | 12.59 | 11.73 | 11.91 | 85856.0 |
| 2015-11-10 | ABE-DELISTED | Stock | 11.35 | 11.35 | 11.22 | 11.2559 | 2658.0 |
| 2015-11-10 | ABEO | Stock | 110.5 | 114.5 | 108.5 | 112.25 | 3456.0 |
| 2015-11-10 | ABEV | Stock | 4.83 | 4.98 | 4.76 | 4.92 | 13310800.0 |
| 2015-11-10 | ABG | Stock | 75.98 | 76.99 | 75.34 | 76.7 | 280300.0 |
| 2015-11-10 | ABGB-DELISTED | Stock | 5.64 | 5.73 | 5.53 | 5.59 | 22430.0 |
| 2015-11-10 | ABM | Stock | 28.3 | 28.74 | 28.23 | 28.73 | 257300.0 |
| 2015-11-10 | ABMD-DELISTED | Stock | 79.68 | 82.25 | 79.06 | 81.9 | 443796.0 |
> showing 50 of 6,588 rows — these rows as CSV