PREVIEW / stock_daily / 2015-11-16
file: by_date/stock_daily/2015/2015-11-16.parquet size: 220 KB rows: 6,604 symbols: 3,387
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-16 | AAPL | Stock | 27.845 | 28.56 | 27.75 | 28.545 | 152426800.0 |
| 2015-11-16 | MSFT | Stock | 53.08 | 53.89 | 52.85 | 53.77 | 32165200.0 |
| 2015-11-16 | NVDA | Stock | 0.7548 | 0.7605 | 0.7488 | 0.76 | 344280000.0 |
| 2015-11-16 | AMZN | Stock | 32.046 | 32.4995 | 31.1145 | 32.3905 | 148718000.0 |
| 2015-11-16 | GOOGL | Stock | 37.0105 | 37.5855 | 36.7165 | 37.521 | 50703960.0 |
| 2015-11-16 | META | Stock | 103.32 | 104.17 | 100.47 | 104.04 | 49309200.0 |
| 2015-11-16 | TSLA | Stock | 13.7393 | 14.332 | 13.72 | 14.2873 | 43881000.0 |
| 2015-11-16 | TLT | Stock | 119.79 | 120.0 | 119.13 | 119.57 | 5485337.0 |
| 2015-11-16 | ES | Stock | 49.85 | 51.02 | 49.84 | 50.97 | 1383800.0 |
| 2015-11-16 | CL | Stock | 64.6 | 65.7 | 64.6 | 65.57 | 3187400.0 |
| 2015-11-16 | A | Stock | 36.75 | 37.49 | 36.6 | 37.33 | 2490200.0 |
| 2015-11-16 | AA.B-DELISTED | Stock | 29.751 | 29.9312 | 29.3 | 29.92 | 67859.0 |
| 2015-11-16 | AAAP-DELISTED | Stock | 25.01 | 26.19 | 24.1301 | 25.1 | 16179.0 |
| 2015-11-16 | AABA-DELISTED | Stock | 32.23 | 32.99 | 32.12 | 32.95 | 10356493.0 |
| 2015-11-16 | AAC-DELISTED | Stock | 22.65 | 23.19 | 22.15 | 22.57 | 162668.0 |
| 2015-11-16 | AACG | Stock | 4.4 | 4.5 | 4.21 | 4.27 | 17600.0 |
| 2015-11-16 | AAIC-DELISTED | Stock | 13.39 | 13.46 | 13.11 | 13.45 | 148072.0 |
| 2015-11-16 | AAL | Stock | 42.41 | 42.84 | 41.85 | 42.83 | 10201100.0 |
| 2015-11-16 | AAMC-DELISTED | Stock | 5.1471 | 5.1471 | 4.5618 | 4.5824 | 74412.0 |
| 2015-11-16 | AAME | Stock | 4.9 | 4.9 | 4.76 | 4.89 | 7400.0 |
| 2015-11-16 | AAMI | Stock | 15.98 | 16.05 | 15.755 | 15.99 | 147000.0 |
| 2015-11-16 | AAOI | Stock | 16.67 | 17.19 | 16.35 | 16.93 | 421200.0 |
| 2015-11-16 | AAON | Stock | 15.5933 | 15.8067 | 15.5933 | 15.6667 | 344550.0 |
| 2015-11-16 | AAP | Stock | 161.0 | 164.54 | 159.69 | 164.22 | 1494100.0 |
| 2015-11-16 | AAT | Stock | 39.45 | 39.58 | 39.0 | 39.32 | 186400.0 |
| 2015-11-16 | AAU-DELISTED | Stock | 0.53 | 0.55 | 0.53 | 0.5483 | 11750.0 |
| 2015-11-16 | AAUAF-DELISTED | Stock | 0.53 | 0.55 | 0.53 | 0.5483 | 12180.0 |
| 2015-11-16 | AAV-DELISTED | Stock | 5.49 | 5.6844 | 5.43 | 5.67 | 57629.0 |
| 2015-11-16 | AAVL-DELISTED | Stock | 8.03 | 8.21 | 7.62 | 7.86 | 195364.0 |
| 2015-11-16 | AAWW-DELISTED | Stock | 39.1 | 39.97 | 38.45 | 39.87 | 142407.0 |
| 2015-11-16 | AAXJ | Stock | 54.48 | 55.37 | 54.48 | 55.34 | 794825.0 |
| 2015-11-16 | AAXN-DELISTED | Stock | 17.25 | 17.62 | 17.19 | 17.37 | 1674167.0 |
| 2015-11-16 | AB | Stock | 24.5 | 25.05 | 24.3 | 24.88 | 164000.0 |
| 2015-11-16 | ABAC-DELISTED | Stock | 0.571 | 0.65 | 0.571 | 0.64 | 2504.0 |
| 2015-11-16 | ABAX-DELISTED | Stock | 51.12 | 51.95 | 50.9 | 51.75 | 126707.0 |
| 2015-11-16 | ABB-DELISTED | Stock | 18.29 | 18.52 | 18.25 | 18.51 | 2333132.0 |
| 2015-11-16 | ABBNY-DELISTED | Stock | 18.29 | 18.52 | 18.25 | 18.5 | 2433884.0 |
| 2015-11-16 | ABBV | Stock | 59.74 | 60.81 | 59.56 | 60.01 | 6965100.0 |
| 2015-11-16 | ABC-DELISTED | Stock | 96.86 | 98.07 | 96.54 | 97.3 | 1561878.0 |
| 2015-11-16 | ABCB | Stock | 32.1 | 32.57 | 31.33 | 32.4 | 200200.0 |
| 2015-11-16 | ABCD-DELISTED | Stock | 5.3 | 5.4 | 5.19 | 5.39 | 34333.0 |
| 2015-11-16 | ABCO-DELISTED | Stock | 52.44 | 52.63 | 51.91 | 52.23 | 139180.0 |
| 2015-11-16 | ABCW-DELISTED | Stock | 40.5 | 41.76 | 40.5 | 41.73 | 9444.0 |
| 2015-11-16 | ABDC-DELISTED | Stock | 12.14 | 12.14 | 11.68 | 11.82 | 29254.0 |
| 2015-11-16 | ABE-DELISTED | Stock | 11.1589 | 11.24 | 11.13 | 11.1586 | 3340.0 |
| 2015-11-16 | ABEO | Stock | 97.25 | 98.75 | 93.5 | 98.5 | 4812.0 |
| 2015-11-16 | ABEV | Stock | 4.92 | 5.01 | 4.89 | 4.97 | 16720700.0 |
| 2015-11-16 | ABG | Stock | 69.05 | 70.28 | 67.88 | 70.18 | 750000.0 |
| 2015-11-16 | ABGB-DELISTED | Stock | 5.18 | 5.18 | 4.95 | 4.97 | 15372.0 |
| 2015-11-16 | ABIL-DELISTED | Stock | 10.07 | 10.1 | 10.07 | 10.1 | 452882.0 |
> showing 50 of 6,604 rows — these rows as CSV