PREVIEW / stock_daily / 2015-12-10
file: by_date/stock_daily/2015/2015-12-10.parquet size: 221 KB rows: 6,624 symbols: 3,400
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-12-10 | AAPL | Stock | 29.01 | 29.235 | 28.8775 | 29.0425 | 116850800.0 |
| 2015-12-10 | MSFT | Stock | 55.39 | 55.66 | 55.01 | 55.27 | 31775800.0 |
| 2015-12-10 | NVDA | Stock | 0.8203 | 0.829 | 0.8175 | 0.8245 | 236596000.0 |
| 2015-12-10 | AMZN | Stock | 33.2795 | 33.4265 | 32.978 | 33.116 | 69110000.0 |
| 2015-12-10 | GOOGL | Stock | 38.1795 | 38.3033 | 37.75 | 38.002 | 32458800.0 |
| 2015-12-10 | META | Stock | 105.05 | 106.4 | 104.41 | 105.42 | 17454300.0 |
| 2015-12-10 | TSLA | Stock | 14.9807 | 15.2327 | 14.9093 | 15.138 | 31075500.0 |
| 2015-12-10 | TLT | Stock | 121.79 | 122.03 | 121.49 | 121.84 | 5606896.0 |
| 2015-12-10 | ES | Stock | 50.32 | 50.35 | 48.74 | 48.86 | 2467900.0 |
| 2015-12-10 | CL | Stock | 66.08 | 66.66 | 65.98 | 66.13 | 2628300.0 |
| 2015-12-10 | A | Stock | 40.96 | 41.66 | 40.65 | 41.25 | 3709200.0 |
| 2015-12-10 | AA.B-DELISTED | Stock | 30.7 | 32.61 | 30.7 | 32.2 | 152635.0 |
| 2015-12-10 | AAAP-DELISTED | Stock | 29.78 | 30.7 | 28.05 | 29.04 | 38096.0 |
| 2015-12-10 | AABA-DELISTED | Stock | 34.49 | 34.73 | 33.91 | 34.635 | 15058441.0 |
| 2015-12-10 | AAC-DELISTED | Stock | 23.11 | 24.5 | 22.86 | 23.035 | 209087.0 |
| 2015-12-10 | AACG | Stock | 5.95 | 6.2 | 5.92 | 5.92 | 45800.0 |
| 2015-12-10 | AAIC-DELISTED | Stock | 12.85 | 13.21 | 12.85 | 13.1 | 205751.0 |
| 2015-12-10 | AAL | Stock | 43.79 | 44.48 | 43.54 | 44.09 | 7955600.0 |
| 2015-12-10 | AAMC-DELISTED | Stock | 3.75 | 3.8529 | 3.5294 | 3.6765 | 555536.0 |
| 2015-12-10 | AAME | Stock | 4.88 | 4.88 | 4.56 | 4.74 | 3800.0 |
| 2015-12-10 | AAMI | Stock | 14.76 | 14.93 | 14.66 | 14.85 | 176500.0 |
| 2015-12-10 | AAOI | Stock | 17.37 | 17.45 | 16.95 | 17.17 | 157100.0 |
| 2015-12-10 | AAON | Stock | 15.6267 | 15.6867 | 15.3467 | 15.5533 | 545250.0 |
| 2015-12-10 | AAP | Stock | 153.17 | 154.23 | 150.33 | 151.76 | 1027200.0 |
| 2015-12-10 | AAT | Stock | 38.76 | 39.07 | 38.42 | 38.48 | 101800.0 |
| 2015-12-10 | AAU-DELISTED | Stock | 0.56 | 0.56 | 0.51 | 0.5199 | 82208.0 |
| 2015-12-10 | AAUAF-DELISTED | Stock | 0.56 | 0.56 | 0.51 | 0.5199 | 84144.0 |
| 2015-12-10 | AAV-DELISTED | Stock | 4.57 | 4.68 | 4.52 | 4.61 | 77047.0 |
| 2015-12-10 | AAVL-DELISTED | Stock | 9.02 | 9.22 | 8.91 | 9.04 | 142962.0 |
| 2015-12-10 | AAWW-DELISTED | Stock | 39.4 | 40.53 | 39.37 | 40.28 | 148606.0 |
| 2015-12-10 | AAXJ | Stock | 53.95 | 54.18 | 53.755 | 53.8 | 1666061.0 |
| 2015-12-10 | AAXN-DELISTED | Stock | 16.95 | 17.94 | 16.8 | 17.73 | 2262679.0 |
| 2015-12-10 | AB | Stock | 23.46 | 24.7 | 23.26 | 24.31 | 754200.0 |
| 2015-12-10 | ABAC-DELISTED | Stock | 1.2 | 1.2 | 1.06 | 1.2 | 5659.0 |
| 2015-12-10 | ABAX-DELISTED | Stock | 52.97 | 54.21 | 52.97 | 53.62 | 57235.0 |
| 2015-12-10 | ABB-DELISTED | Stock | 18.18 | 18.2001 | 18.01 | 18.03 | 1885371.0 |
| 2015-12-10 | ABBNY-DELISTED | Stock | 18.17 | 18.2001 | 18.01 | 18.04 | 2625796.0 |
| 2015-12-10 | ABBV | Stock | 56.0 | 56.65 | 55.65 | 55.78 | 6736900.0 |
| 2015-12-10 | ABC-DELISTED | Stock | 100.93 | 102.42 | 100.62 | 101.96 | 2434797.0 |
| 2015-12-10 | ABCB | Stock | 34.21 | 34.3 | 33.4 | 33.49 | 248100.0 |
| 2015-12-10 | ABCD-DELISTED | Stock | 5.03 | 5.05 | 4.9823 | 5.0 | 16810.0 |
| 2015-12-10 | ABCO-DELISTED | Stock | 51.29 | 52.136 | 50.62 | 51.6399 | 232046.0 |
| 2015-12-10 | ABCW-DELISTED | Stock | 42.62 | 43.35 | 42.59 | 43.22 | 109538.0 |
| 2015-12-10 | ABDC-DELISTED | Stock | 12.09 | 12.14 | 11.9 | 11.9 | 16945.0 |
| 2015-12-10 | ABE-DELISTED | Stock | 11.06 | 11.06 | 10.93 | 10.95 | 8858.0 |
| 2015-12-10 | ABEO | Stock | 89.0 | 91.5 | 87.75 | 89.75 | 2260.0 |
| 2015-12-10 | ABEV | Stock | 4.83 | 4.87 | 4.7 | 4.7 | 12373600.0 |
| 2015-12-10 | ABG | Stock | 73.38 | 73.82 | 72.32 | 73.02 | 263200.0 |
| 2015-12-10 | ABGB-DELISTED | Stock | 1.89 | 1.891 | 1.74 | 1.85 | 109334.0 |
| 2015-12-10 | ABIL-DELISTED | Stock | 10.09 | 10.09 | 10.01 | 10.06 | 59400.0 |
> showing 50 of 6,624 rows — these rows as CSV