PREVIEW / stock_daily / 2015-12-02
file: by_date/stock_daily/2015/2015-12-02.parquet size: 222 KB rows: 6,646 symbols: 3,430
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-02 | AAPL | Stock | 29.335 | 29.5275 | 29.02 | 29.07 | 133546400.0 |
| 2015-12-02 | MSFT | Stock | 55.32 | 55.96 | 55.06 | 55.21 | 47274900.0 |
| 2015-12-02 | NVDA | Stock | 0.82 | 0.8285 | 0.8108 | 0.8125 | 294240000.0 |
| 2015-12-02 | AMZN | Stock | 34.05 | 34.241 | 33.7125 | 33.8005 | 85470000.0 |
| 2015-12-02 | GOOGL | Stock | 39.2625 | 39.6524 | 38.8215 | 38.8925 | 46876820.0 |
| 2015-12-02 | META | Stock | 107.0 | 107.92 | 105.79 | 106.07 | 24429100.0 |
| 2015-12-02 | TSLA | Stock | 15.8 | 15.9067 | 15.4153 | 15.466 | 44722500.0 |
| 2015-12-02 | TLT | Stock | 122.66 | 123.04 | 122.19 | 122.87 | 7345805.0 |
| 2015-12-02 | ES | Stock | 50.62 | 50.79 | 49.66 | 49.73 | 981600.0 |
| 2015-12-02 | CL | Stock | 65.82 | 66.41 | 65.58 | 65.68 | 3667300.0 |
| 2015-12-02 | A | Stock | 41.07 | 41.46 | 40.37 | 40.42 | 4713200.0 |
| 2015-12-02 | AA.B-DELISTED | Stock | 32.83 | 33.64 | 32.15 | 32.4 | 240008.0 |
| 2015-12-02 | AAAP-DELISTED | Stock | 26.2 | 27.94 | 25.995 | 26.2001 | 49570.0 |
| 2015-12-02 | AABA-DELISTED | Stock | 35.0 | 36.39 | 34.77 | 35.66 | 54763152.0 |
| 2015-12-02 | AAC-DELISTED | Stock | 24.65 | 24.68 | 23.72 | 23.88 | 65839.0 |
| 2015-12-02 | AACG | Stock | 5.56 | 5.84 | 5.56 | 5.68 | 30700.0 |
| 2015-12-02 | AAIC-DELISTED | Stock | 13.81 | 13.9 | 13.505 | 13.6 | 294026.0 |
| 2015-12-02 | AAL | Stock | 44.09 | 44.53 | 43.53 | 43.82 | 8010400.0 |
| 2015-12-02 | AAMC-DELISTED | Stock | 4.8853 | 4.9441 | 4.3529 | 4.3882 | 217100.0 |
| 2015-12-02 | AAME | Stock | 4.75 | 4.77 | 4.72 | 4.76 | 1900.0 |
| 2015-12-02 | AAMI | Stock | 16.33 | 16.37 | 16.02 | 16.16 | 180900.0 |
| 2015-12-02 | AAOI | Stock | 18.71 | 18.9 | 18.37 | 18.49 | 191900.0 |
| 2015-12-02 | AAON | Stock | 16.18 | 16.3467 | 16.0333 | 16.0667 | 183300.0 |
| 2015-12-02 | AAP | Stock | 162.21 | 163.22 | 157.09 | 157.93 | 1331800.0 |
| 2015-12-02 | AAT | Stock | 40.01 | 40.11 | 38.87 | 38.95 | 239000.0 |
| 2015-12-02 | AAU-DELISTED | Stock | 0.52 | 0.527 | 0.5195 | 0.523 | 31017.0 |
| 2015-12-02 | AAUAF-DELISTED | Stock | 0.52 | 0.527 | 0.5195 | 0.523 | 34622.0 |
| 2015-12-02 | AAV-DELISTED | Stock | 5.3 | 5.3 | 5.1 | 5.12 | 122527.0 |
| 2015-12-02 | AAVL-DELISTED | Stock | 9.95 | 10.31 | 9.77 | 10.03 | 225558.0 |
| 2015-12-02 | AAWW-DELISTED | Stock | 41.82 | 41.82 | 40.61 | 40.81 | 137986.0 |
| 2015-12-02 | AAXJ | Stock | 55.7 | 55.81 | 55.26 | 55.43 | 1395330.0 |
| 2015-12-02 | AAXN-DELISTED | Stock | 18.31 | 18.44 | 17.78 | 18.015 | 1572389.0 |
| 2015-12-02 | AB | Stock | 23.89 | 24.25 | 23.09 | 23.41 | 592000.0 |
| 2015-12-02 | ABAC-DELISTED | Stock | 0.68 | 0.829 | 0.68 | 0.79 | 12780.0 |
| 2015-12-02 | ABAX-DELISTED | Stock | 53.13 | 54.16 | 52.72 | 53.81 | 101998.0 |
| 2015-12-02 | ABB-DELISTED | Stock | 18.46 | 18.59 | 18.445 | 18.5 | 1508744.0 |
| 2015-12-02 | ABBNY-DELISTED | Stock | 18.46 | 18.59 | 18.445 | 18.51 | 1552601.0 |
| 2015-12-02 | ABBV | Stock | 59.17 | 59.39 | 57.37 | 57.72 | 7663000.0 |
| 2015-12-02 | ABC-DELISTED | Stock | 99.83 | 100.01 | 98.51 | 98.86 | 1293553.0 |
| 2015-12-02 | ABCB | Stock | 34.5 | 34.76 | 34.15 | 34.2 | 266500.0 |
| 2015-12-02 | ABCD-DELISTED | Stock | 5.2 | 5.29 | 5.04 | 5.07 | 22564.0 |
| 2015-12-02 | ABCO-DELISTED | Stock | 54.08 | 54.77 | 52.678 | 54.25 | 204808.0 |
| 2015-12-02 | ABCW-DELISTED | Stock | 42.0 | 42.0 | 41.38 | 41.98 | 66508.0 |
| 2015-12-02 | ABDC-DELISTED | Stock | 12.18 | 12.18 | 11.8 | 12.17 | 41485.0 |
| 2015-12-02 | ABE-DELISTED | Stock | 11.12 | 11.1473 | 11.12 | 11.1473 | 1164.0 |
| 2015-12-02 | ABEO | Stock | 111.75 | 112.25 | 103.75 | 104.5 | 2476.0 |
| 2015-12-02 | ABEOW-DELISTED | Stock | 1.53 | 1.6 | 1.48 | 1.55 | 3046.0 |
| 2015-12-02 | ABEV | Stock | 4.82 | 4.83 | 4.72 | 4.82 | 20185300.0 |
| 2015-12-02 | ABG | Stock | 75.65 | 75.87 | 74.38 | 74.61 | 143500.0 |
| 2015-12-02 | ABGB-DELISTED | Stock | 2.49 | 2.95 | 2.49 | 2.79 | 247761.0 |
> showing 50 of 6,646 rows — these rows as CSV