PREVIEW / stock_daily / 2015-11-20
file: by_date/stock_daily/2015/2015-11-20.parquet size: 222 KB rows: 6,635 symbols: 3,406
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-20 | AAPL | Stock | 29.8 | 29.98 | 29.7125 | 29.825 | 137148400.0 |
| 2015-11-20 | MSFT | Stock | 54.25 | 54.3 | 53.27 | 54.19 | 37147600.0 |
| 2015-11-20 | NVDA | Stock | 0.7838 | 0.7892 | 0.779 | 0.7848 | 239744000.0 |
| 2015-11-20 | AMZN | Stock | 33.397 | 33.4435 | 32.8785 | 33.4225 | 77922000.0 |
| 2015-11-20 | GOOGL | Stock | 38.465 | 38.9659 | 38.205 | 38.85 | 55478880.0 |
| 2015-11-20 | META | Stock | 106.84 | 107.87 | 106.62 | 107.32 | 22129600.0 |
| 2015-11-20 | TSLA | Stock | 14.8993 | 15.0 | 14.2387 | 14.6673 | 66010500.0 |
| 2015-11-20 | TLT | Stock | 120.93 | 121.04 | 120.28 | 120.45 | 5971025.0 |
| 2015-11-20 | ES | Stock | 51.43 | 51.9 | 51.19 | 51.44 | 2653800.0 |
| 2015-11-20 | CL | Stock | 66.75 | 67.18 | 66.04 | 66.1 | 3027900.0 |
| 2015-11-20 | A | Stock | 38.78 | 39.35 | 38.52 | 39.28 | 5447900.0 |
| 2015-11-20 | AA.B-DELISTED | Stock | 31.07 | 31.2701 | 30.5 | 30.6924 | 42501.0 |
| 2015-11-20 | AAAP-DELISTED | Stock | 26.0 | 27.01 | 25.1 | 25.14 | 55921.0 |
| 2015-11-20 | AABA-DELISTED | Stock | 32.78 | 33.3 | 32.69 | 33.1 | 11887132.0 |
| 2015-11-20 | AAC-DELISTED | Stock | 22.62 | 23.47 | 22.53 | 23.22 | 88133.0 |
| 2015-11-20 | AACG | Stock | 5.1 | 5.97 | 4.89 | 5.24 | 71600.0 |
| 2015-11-20 | AAIC-DELISTED | Stock | 13.69 | 13.7 | 13.51 | 13.51 | 146989.0 |
| 2015-11-20 | AAL | Stock | 42.4 | 42.71 | 42.05 | 42.2 | 5656000.0 |
| 2015-11-20 | AAMC-DELISTED | Stock | 3.9529 | 3.9706 | 3.5235 | 3.5294 | 176674.0 |
| 2015-11-20 | AAME | Stock | 4.88 | 4.89 | 4.51 | 4.69 | 1600.0 |
| 2015-11-20 | AAMI | Stock | 16.25 | 16.25 | 15.96 | 15.99 | 90400.0 |
| 2015-11-20 | AAOI | Stock | 17.39 | 18.25 | 17.32 | 17.96 | 425100.0 |
| 2015-11-20 | AAON | Stock | 16.04 | 16.26 | 15.8667 | 16.0867 | 250950.0 |
| 2015-11-20 | AAP | Stock | 162.86 | 165.1 | 162.55 | 162.82 | 733400.0 |
| 2015-11-20 | AAT | Stock | 40.12 | 40.54 | 39.78 | 40.25 | 133300.0 |
| 2015-11-20 | AAU-DELISTED | Stock | 0.53 | 0.53 | 0.5 | 0.5 | 76506.0 |
| 2015-11-20 | AAUAF-DELISTED | Stock | 0.53 | 0.53 | 0.5 | 0.5 | 79501.0 |
| 2015-11-20 | AAV-DELISTED | Stock | 5.46 | 5.48 | 5.21 | 5.23 | 72522.0 |
| 2015-11-20 | AAVL-DELISTED | Stock | 8.53 | 8.81 | 8.4 | 8.705 | 254530.0 |
| 2015-11-20 | AAWW-DELISTED | Stock | 41.08 | 41.3 | 40.46 | 40.63 | 104197.0 |
| 2015-11-20 | AAXJ | Stock | 56.44 | 56.69 | 56.34 | 56.45 | 740180.0 |
| 2015-11-20 | AAXN-DELISTED | Stock | 17.89 | 18.16 | 17.75 | 18.15 | 1525255.0 |
| 2015-11-20 | AB | Stock | 25.7 | 26.24 | 25.5 | 25.8 | 213500.0 |
| 2015-11-20 | ABAC-DELISTED | Stock | 0.64 | 0.6681 | 0.64 | 0.65 | 8650.0 |
| 2015-11-20 | ABAX-DELISTED | Stock | 51.54 | 52.06 | 51.28 | 51.63 | 91862.0 |
| 2015-11-20 | ABB-DELISTED | Stock | 18.97 | 18.98 | 18.77 | 18.79 | 1172620.0 |
| 2015-11-20 | ABBNY-DELISTED | Stock | 18.97 | 18.98 | 18.77 | 18.78 | 1222830.0 |
| 2015-11-20 | ABBV | Stock | 60.94 | 61.36 | 60.57 | 61.11 | 7490200.0 |
| 2015-11-20 | ABC-DELISTED | Stock | 99.6 | 99.92 | 98.64 | 99.07 | 1969459.0 |
| 2015-11-20 | ABCB | Stock | 33.63 | 33.97 | 33.2 | 33.79 | 327000.0 |
| 2015-11-20 | ABCD-DELISTED | Stock | 5.13 | 5.21 | 5.07 | 5.2 | 46079.0 |
| 2015-11-20 | ABCO-DELISTED | Stock | 51.99 | 51.99 | 50.82 | 51.03 | 244171.0 |
| 2015-11-20 | ABCW-DELISTED | Stock | 41.32 | 42.0 | 41.3 | 41.9243 | 9839.0 |
| 2015-11-20 | ABDC-DELISTED | Stock | 11.95 | 12.06 | 11.7101 | 11.87 | 31735.0 |
| 2015-11-20 | ABE-DELISTED | Stock | 11.3358 | 11.34 | 11.215 | 11.3 | 7950.0 |
| 2015-11-20 | ABEO | Stock | 102.5 | 109.75 | 101.25 | 104.75 | 5384.0 |
| 2015-11-20 | ABEOW-DELISTED | Stock | 1.5 | 1.779 | 1.5 | 1.779 | 13097.0 |
| 2015-11-20 | ABEV | Stock | 5.15 | 5.28 | 5.13 | 5.17 | 21130400.0 |
| 2015-11-20 | ABG | Stock | 71.47 | 72.87 | 70.8 | 72.38 | 386700.0 |
| 2015-11-20 | ABGB-DELISTED | Stock | 4.85 | 4.8552 | 4.76 | 4.78 | 7466.0 |
> showing 50 of 6,635 rows — these rows as CSV