PREVIEW / stock_daily / 2016-02-10
file: by_date/stock_daily/2016/2016-02-10.parquet size: 217 KB rows: 6,565 symbols: 3,337
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-10 | AAPL | Stock | 23.98 | 24.0875 | 23.525 | 23.5675 | 169374400.0 |
| 2016-02-10 | MSFT | Stock | 49.89 | 50.39 | 49.52 | 49.71 | 38237000.0 |
| 2016-02-10 | NVDA | Stock | 0.6412 | 0.6598 | 0.6322 | 0.6358 | 335800000.0 |
| 2016-02-10 | AMZN | Stock | 24.588 | 25.233 | 24.3 | 24.524 | 135724000.0 |
| 2016-02-10 | GOOGL | Stock | 35.5895 | 36.161 | 35.2695 | 35.3425 | 60314660.0 |
| 2016-02-10 | META | Stock | 101.55 | 103.25 | 100.24 | 101.0 | 45179400.0 |
| 2016-02-10 | TSLA | Stock | 10.0333 | 10.3313 | 9.4493 | 9.578 | 156097500.0 |
| 2016-02-10 | TLT | Stock | 131.7 | 132.84 | 131.11 | 132.79 | 12797068.0 |
| 2016-02-10 | ES | Stock | 54.48 | 55.28 | 53.81 | 54.94 | 2036700.0 |
| 2016-02-10 | CL | Stock | 66.39 | 66.83 | 65.71 | 65.81 | 3117500.0 |
| 2016-02-10 | A | Stock | 35.63 | 36.73 | 35.53 | 35.85 | 3170000.0 |
| 2016-02-10 | AA.B-DELISTED | Stock | 27.08 | 27.12 | 26.18 | 26.51 | 27834.0 |
| 2016-02-10 | AAAP-DELISTED | Stock | 24.22 | 26.59 | 24.01 | 25.0 | 22291.0 |
| 2016-02-10 | AABA-DELISTED | Stock | 27.11 | 27.81 | 26.84 | 27.1 | 8488979.0 |
| 2016-02-10 | AAC-DELISTED | Stock | 19.55 | 20.08 | 19.18 | 19.56 | 73945.0 |
| 2016-02-10 | AACG | Stock | 5.24 | 5.45 | 5.17 | 5.22 | 6600.0 |
| 2016-02-10 | AAIC-DELISTED | Stock | 11.09 | 11.28 | 10.8 | 11.09 | 231628.0 |
| 2016-02-10 | AAL | Stock | 36.57 | 37.64 | 36.53 | 37.12 | 8114100.0 |
| 2016-02-10 | AAMC-DELISTED | Stock | 4.2735 | 4.5147 | 4.2676 | 4.4676 | 115328.0 |
| 2016-02-10 | AAME | Stock | 4.5 | 4.5 | 4.48 | 4.5 | 1200.0 |
| 2016-02-10 | AAMI | Stock | 11.01 | 11.45 | 10.86 | 10.87 | 232100.0 |
| 2016-02-10 | AAOI | Stock | 14.61 | 15.26 | 14.16 | 14.54 | 366600.0 |
| 2016-02-10 | AAON | Stock | 13.52 | 14.0 | 13.52 | 13.5933 | 164550.0 |
| 2016-02-10 | AAP | Stock | 141.13 | 143.5 | 138.41 | 138.57 | 2203700.0 |
| 2016-02-10 | AAT | Stock | 34.77 | 35.62 | 34.77 | 34.83 | 236400.0 |
| 2016-02-10 | AAU-DELISTED | Stock | 0.62 | 0.6402 | 0.6 | 0.615 | 52148.0 |
| 2016-02-10 | AAUAF-DELISTED | Stock | 0.62 | 0.6402 | 0.6 | 0.615 | 60389.0 |
| 2016-02-10 | AAV-DELISTED | Stock | 5.38 | 5.61 | 5.26 | 5.39 | 75494.0 |
| 2016-02-10 | AAVL-DELISTED | Stock | 4.18 | 4.69 | 4.11 | 4.58 | 1183807.0 |
| 2016-02-10 | AAWW-DELISTED | Stock | 35.62 | 36.32 | 35.28 | 35.39 | 235475.0 |
| 2016-02-10 | AAXJ | Stock | 48.13 | 48.58 | 47.7 | 47.76 | 723800.0 |
| 2016-02-10 | AAXN-DELISTED | Stock | 15.45 | 16.19 | 15.394 | 15.48 | 1013705.0 |
| 2016-02-10 | AB | Stock | 17.41 | 17.58 | 17.15 | 17.28 | 200300.0 |
| 2016-02-10 | ABAC-DELISTED | Stock | 0.789 | 0.789 | 0.6764 | 0.71 | 9312.0 |
| 2016-02-10 | ABAX-DELISTED | Stock | 40.19 | 40.82 | 39.09 | 39.13 | 183365.0 |
| 2016-02-10 | ABB-DELISTED | Stock | 17.08 | 17.1375 | 16.89 | 16.91 | 2000426.0 |
| 2016-02-10 | ABBNY-DELISTED | Stock | 17.08 | 17.1375 | 16.89 | 16.91 | 2087419.0 |
| 2016-02-10 | ABBV | Stock | 54.11 | 54.69 | 52.55 | 52.72 | 9302800.0 |
| 2016-02-10 | ABC-DELISTED | Stock | 85.44 | 86.35 | 85.22 | 85.59 | 2377602.0 |
| 2016-02-10 | ABCB | Stock | 26.36 | 26.86 | 25.89 | 25.98 | 288000.0 |
| 2016-02-10 | ABCD-DELISTED | Stock | 3.84 | 3.8892 | 3.67 | 3.67 | 55955.0 |
| 2016-02-10 | ABCO-DELISTED | Stock | 40.71 | 42.249 | 39.87 | 39.99 | 162960.0 |
| 2016-02-10 | ABCW-DELISTED | Stock | 41.49 | 41.9 | 40.96 | 41.3299 | 65474.0 |
| 2016-02-10 | ABDC-DELISTED | Stock | 9.16 | 9.24 | 8.92 | 8.99 | 29559.0 |
| 2016-02-10 | ABE-DELISTED | Stock | 10.3385 | 10.3385 | 10.3385 | 10.3385 | 324.0 |
| 2016-02-10 | ABEO | Stock | 62.5 | 63.5 | 59.25 | 59.25 | 1076.0 |
| 2016-02-10 | ABEOW-DELISTED | Stock | 0.51 | 0.51 | 0.51 | 0.51 | 500.0 |
| 2016-02-10 | ABEV | Stock | 4.54 | 4.55 | 4.4 | 4.49 | 14366500.0 |
| 2016-02-10 | ABG | Stock | 47.18 | 49.67 | 47.08 | 48.96 | 825400.0 |
| 2016-02-10 | ABGB-DELISTED | Stock | 0.85 | 0.8667 | 0.7576 | 0.76 | 40178.0 |
> showing 50 of 6,565 rows — these rows as CSV