PREVIEW / stock_daily / 2015-11-05
file: by_date/stock_daily/2015/2015-11-05.parquet size: 221 KB rows: 6,591 symbols: 3,393
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-05 | AAPL | Stock | 30.4625 | 30.6725 | 30.045 | 30.23 | 158210800.0 |
| 2015-11-05 | MSFT | Stock | 54.49 | 54.7 | 54.0 | 54.38 | 31468500.0 |
| 2015-11-05 | NVDA | Stock | 0.7042 | 0.7062 | 0.6908 | 0.6928 | 478800000.0 |
| 2015-11-05 | AMZN | Stock | 32.355 | 32.85 | 32.1545 | 32.7825 | 94476000.0 |
| 2015-11-05 | GOOGL | Stock | 37.9405 | 38.3175 | 37.8735 | 38.0335 | 45486280.0 |
| 2015-11-05 | META | Stock | 108.8 | 110.65 | 107.95 | 108.76 | 63232900.0 |
| 2015-11-05 | TSLA | Stock | 15.372 | 15.6387 | 15.2793 | 15.4513 | 67452000.0 |
| 2015-11-05 | TLT | Stock | 121.05 | 121.06 | 120.3 | 120.77 | 7268407.0 |
| 2015-11-05 | ES | Stock | 51.51 | 51.82 | 51.36 | 51.5 | 1086500.0 |
| 2015-11-05 | CL | Stock | 67.51 | 67.89 | 67.2 | 67.6 | 2802700.0 |
| 2015-11-05 | A | Stock | 38.27 | 38.5 | 37.93 | 38.3 | 1419800.0 |
| 2015-11-05 | AA.B-DELISTED | Stock | 33.27 | 33.27 | 32.49 | 32.71 | 36376.0 |
| 2015-11-05 | AABA-DELISTED | Stock | 35.02 | 35.3 | 34.16 | 35.12 | 13829297.0 |
| 2015-11-05 | AAC-DELISTED | Stock | 24.1 | 24.41 | 23.4601 | 24.24 | 83359.0 |
| 2015-11-05 | AACG | Stock | 4.44 | 4.48 | 3.91 | 4.12 | 69400.0 |
| 2015-11-05 | AAIC-DELISTED | Stock | 13.94 | 13.97 | 13.74 | 13.89 | 160769.0 |
| 2015-11-05 | AAL | Stock | 45.7 | 45.83 | 45.03 | 45.6 | 5864700.0 |
| 2015-11-05 | AAMC-DELISTED | Stock | 8.2294 | 8.8529 | 7.8265 | 7.8265 | 66456.0 |
| 2015-11-05 | AAME | Stock | 4.8 | 4.82 | 4.75 | 4.75 | 9700.0 |
| 2015-11-05 | AAMI | Stock | 16.26 | 16.54 | 16.24 | 16.54 | 164500.0 |
| 2015-11-05 | AAOI | Stock | 18.22 | 18.73 | 17.32 | 17.73 | 732200.0 |
| 2015-11-05 | AAON | Stock | 16.28 | 16.28 | 15.8867 | 16.2667 | 317550.0 |
| 2015-11-05 | AAP | Stock | 199.96 | 201.21 | 198.16 | 200.34 | 711300.0 |
| 2015-11-05 | AAT | Stock | 40.87 | 41.36 | 40.85 | 41.31 | 197900.0 |
| 2015-11-05 | AAU-DELISTED | Stock | 0.5726 | 0.5726 | 0.5515 | 0.5515 | 66257.0 |
| 2015-11-05 | AAUAF-DELISTED | Stock | 0.5726 | 0.5726 | 0.5515 | 0.5515 | 67027.0 |
| 2015-11-05 | AAV-DELISTED | Stock | 5.87 | 5.94 | 5.77 | 5.88 | 94423.0 |
| 2015-11-05 | AAVL-DELISTED | Stock | 9.4 | 9.4 | 8.9 | 9.1 | 206946.0 |
| 2015-11-05 | AAWW-DELISTED | Stock | 42.68 | 43.87 | 38.69 | 39.44 | 844042.0 |
| 2015-11-05 | AAXJ | Stock | 57.76 | 58.0 | 57.48 | 57.78 | 1784708.0 |
| 2015-11-05 | AAXN-DELISTED | Stock | 20.44 | 20.91 | 18.8 | 20.16 | 3653791.0 |
| 2015-11-05 | AB | Stock | 25.33 | 25.5 | 25.14 | 25.3 | 167000.0 |
| 2015-11-05 | ABAC-DELISTED | Stock | 0.6 | 0.6665 | 0.6 | 0.6401 | 22984.0 |
| 2015-11-05 | ABAX-DELISTED | Stock | 52.0 | 53.05 | 51.64 | 52.9 | 125161.0 |
| 2015-11-05 | ABB-DELISTED | Stock | 19.18 | 19.2 | 19.02 | 19.07 | 1621869.0 |
| 2015-11-05 | ABBNY-DELISTED | Stock | 19.18 | 19.2 | 19.02 | 19.09 | 1716018.0 |
| 2015-11-05 | ABBV | Stock | 63.7 | 64.18 | 61.69 | 62.77 | 10237200.0 |
| 2015-11-05 | ABC-DELISTED | Stock | 97.8 | 98.41 | 97.38 | 97.86 | 1816796.0 |
| 2015-11-05 | ABCB | Stock | 31.54 | 32.24 | 31.4 | 32.19 | 189100.0 |
| 2015-11-05 | ABCD-DELISTED | Stock | 5.35 | 5.5 | 5.31 | 5.34 | 56351.0 |
| 2015-11-05 | ABCO-DELISTED | Stock | 44.11 | 45.353 | 43.67 | 44.2 | 169390.0 |
| 2015-11-05 | ABCW-DELISTED | Stock | 41.85 | 42.19 | 41.76 | 42.03 | 17231.0 |
| 2015-11-05 | ABDC-DELISTED | Stock | 11.81 | 11.81 | 11.53 | 11.73 | 29280.0 |
| 2015-11-05 | ABE-DELISTED | Stock | 11.57 | 11.5988 | 11.54 | 11.54 | 3834.0 |
| 2015-11-05 | ABEO | Stock | 111.25 | 113.5 | 108.25 | 109.5 | 1540.0 |
| 2015-11-05 | ABEOW-DELISTED | Stock | 1.726 | 1.726 | 1.6999 | 1.6999 | 1100.0 |
| 2015-11-05 | ABEV | Stock | 5.11 | 5.12 | 5.03 | 5.06 | 16365200.0 |
| 2015-11-05 | ABG | Stock | 81.4 | 81.43 | 79.81 | 80.35 | 233000.0 |
| 2015-11-05 | ABGB-DELISTED | Stock | 5.33 | 5.43 | 5.33 | 5.37 | 33447.0 |
| 2015-11-05 | ABIL-DELISTED | Stock | 10.09 | 10.09 | 10.0 | 10.0 | 25301.0 |
> showing 50 of 6,591 rows — these rows as CSV