PREVIEW / stock_daily / 2015-10-02
file: by_date/stock_daily/2015/2015-10-02.parquet size: 221 KB rows: 6,620 symbols: 3,422
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-10-02 | AAPL | Stock | 27.0025 | 27.7525 | 26.8875 | 27.595 | 232079200.0 |
| 2015-10-02 | MSFT | Stock | 44.27 | 45.57 | 43.92 | 45.57 | 41839000.0 |
| 2015-10-02 | NVDA | Stock | 0.601 | 0.62 | 0.5948 | 0.62 | 386144000.0 |
| 2015-10-02 | AMZN | Stock | 25.6495 | 26.63 | 25.405 | 26.627 | 91956000.0 |
| 2015-10-02 | GOOGL | Stock | 31.9005 | 32.9128 | 31.675 | 32.8495 | 48788700.0 |
| 2015-10-02 | META | Stock | 88.9 | 92.2 | 88.37 | 92.07 | 37881700.0 |
| 2015-10-02 | TSLA | Stock | 15.7067 | 16.5133 | 15.662 | 16.5047 | 66360000.0 |
| 2015-10-02 | TLT | Stock | 125.59 | 126.21 | 124.18 | 124.56 | 13000403.0 |
| 2015-10-02 | ES | Stock | 50.2 | 50.63 | 49.84 | 50.51 | 1228900.0 |
| 2015-10-02 | CL | Stock | 63.22 | 64.28 | 63.06 | 64.28 | 3504100.0 |
| 2015-10-02 | A | Stock | 33.18 | 34.68 | 33.12 | 34.67 | 3519400.0 |
| 2015-10-02 | AA.B-DELISTED | Stock | 32.76 | 33.3581 | 32.35 | 33.3185 | 15951.0 |
| 2015-10-02 | AABA-DELISTED | Stock | 28.62 | 30.71 | 28.43 | 30.71 | 24054912.0 |
| 2015-10-02 | AAC-DELISTED | Stock | 22.42 | 24.48 | 22.42 | 24.43 | 264751.0 |
| 2015-10-02 | AACG | Stock | 2.81 | 2.81 | 2.64 | 2.79 | 8000.0 |
| 2015-10-02 | AAIC-DELISTED | Stock | 13.86 | 14.07 | 13.69 | 14.02 | 348222.0 |
| 2015-10-02 | AAL | Stock | 38.75 | 38.77 | 37.42 | 38.63 | 12276300.0 |
| 2015-10-02 | AAMC-DELISTED | Stock | 6.8647 | 6.8735 | 6.5412 | 6.7588 | 35479.0 |
| 2015-10-02 | AAME | Stock | 4.05 | 4.05 | 3.93 | 4.04 | 2400.0 |
| 2015-10-02 | AAMI | Stock | 14.76 | 14.94 | 14.38 | 14.92 | 69100.0 |
| 2015-10-02 | AAOI | Stock | 17.94 | 18.26 | 17.64 | 18.17 | 154800.0 |
| 2015-10-02 | AAON | Stock | 12.6867 | 13.0667 | 12.5667 | 13.0467 | 164700.0 |
| 2015-10-02 | AAP | Stock | 189.81 | 192.02 | 188.03 | 191.69 | 1279700.0 |
| 2015-10-02 | AAT | Stock | 41.18 | 41.44 | 40.62 | 41.44 | 172200.0 |
| 2015-10-02 | AAU-DELISTED | Stock | 0.53 | 0.572 | 0.53 | 0.5618 | 44858.0 |
| 2015-10-02 | AAUAF-DELISTED | Stock | 0.53 | 0.572 | 0.53 | 0.5618 | 45442.0 |
| 2015-10-02 | AAV-DELISTED | Stock | 5.39 | 5.69 | 5.35 | 5.64 | 87693.0 |
| 2015-10-02 | AAVL-DELISTED | Stock | 7.86 | 8.5 | 7.77 | 8.48 | 302476.0 |
| 2015-10-02 | AAWW-DELISTED | Stock | 34.6 | 36.06 | 34.31 | 35.99 | 306923.0 |
| 2015-10-02 | AAXJ | Stock | 52.87 | 54.3 | 52.69 | 54.3 | 1792849.0 |
| 2015-10-02 | AAXN-DELISTED | Stock | 21.84 | 22.64 | 21.712 | 22.58 | 774178.0 |
| 2015-10-02 | AB | Stock | 25.23 | 26.13 | 24.75 | 25.9 | 284800.0 |
| 2015-10-02 | ABAC-DELISTED | Stock | 0.48 | 0.54 | 0.4799 | 0.5 | 54071.0 |
| 2015-10-02 | ABAX-DELISTED | Stock | 42.92 | 45.19 | 42.92 | 45.165 | 85460.0 |
| 2015-10-02 | ABB-DELISTED | Stock | 17.58 | 17.88 | 17.5 | 17.87 | 1827230.0 |
| 2015-10-02 | ABBNY-DELISTED | Stock | 17.58 | 17.88 | 17.5 | 17.87 | 1886013.0 |
| 2015-10-02 | ABBV | Stock | 53.87 | 55.85 | 53.72 | 55.82 | 6942600.0 |
| 2015-10-02 | ABC-DELISTED | Stock | 92.34 | 94.98 | 90.82 | 94.9 | 3005738.0 |
| 2015-10-02 | ABCB | Stock | 28.04 | 28.28 | 27.3 | 28.1 | 252800.0 |
| 2015-10-02 | ABCD-DELISTED | Stock | 4.75 | 4.8 | 4.66 | 4.8 | 17875.0 |
| 2015-10-02 | ABCO-DELISTED | Stock | 44.29 | 44.725 | 42.0 | 42.27 | 483035.0 |
| 2015-10-02 | ABCW-DELISTED | Stock | 40.62 | 41.5 | 39.8 | 41.49 | 24342.0 |
| 2015-10-02 | ABDC-DELISTED | Stock | 11.52 | 11.53 | 11.3493 | 11.42 | 48527.0 |
| 2015-10-02 | ABE-DELISTED | Stock | 10.63 | 10.96 | 10.63 | 10.96 | 2922.0 |
| 2015-10-02 | ABEO | Stock | 101.0 | 109.5 | 98.75 | 107.75 | 6116.0 |
| 2015-10-02 | ABEOW-DELISTED | Stock | 1.666 | 1.666 | 1.45 | 1.466 | 2366.0 |
| 2015-10-02 | ABEV | Stock | 4.87 | 5.1 | 4.85 | 5.09 | 12041600.0 |
| 2015-10-02 | ABG | Stock | 80.58 | 83.62 | 79.21 | 83.57 | 234200.0 |
| 2015-10-02 | ABGB-DELISTED | Stock | 4.57 | 4.76 | 4.55 | 4.71 | 19660.0 |
| 2015-10-02 | ABIL-DELISTED | Stock | 9.9799 | 9.9799 | 9.9799 | 9.9799 | 100.0 |
> showing 50 of 6,620 rows — these rows as CSV