PREVIEW / stock_daily / 2015-11-17
file: by_date/stock_daily/2015/2015-11-17.parquet size: 221 KB rows: 6,622 symbols: 3,400
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-17 | AAPL | Stock | 28.73 | 28.7625 | 28.33 | 28.4225 | 110467600.0 |
| 2015-11-17 | MSFT | Stock | 53.17 | 53.53 | 52.85 | 52.97 | 31551300.0 |
| 2015-11-17 | NVDA | Stock | 0.762 | 0.7665 | 0.7568 | 0.76 | 257048000.0 |
| 2015-11-17 | AMZN | Stock | 32.5325 | 32.6625 | 32.05 | 32.165 | 86404000.0 |
| 2015-11-17 | GOOGL | Stock | 37.6235 | 37.7475 | 37.2025 | 37.299 | 38863120.0 |
| 2015-11-17 | META | Stock | 104.62 | 106.2 | 104.14 | 105.13 | 26807200.0 |
| 2015-11-17 | TSLA | Stock | 14.3467 | 14.4 | 14.0933 | 14.2667 | 32230500.0 |
| 2015-11-17 | TLT | Stock | 119.0 | 120.13 | 118.66 | 119.77 | 5122919.0 |
| 2015-11-17 | ES | Stock | 50.83 | 51.22 | 49.48 | 49.65 | 1805800.0 |
| 2015-11-17 | CL | Stock | 65.92 | 65.96 | 65.14 | 65.32 | 2296600.0 |
| 2015-11-17 | A | Stock | 36.5 | 38.5 | 36.5 | 38.38 | 7679500.0 |
| 2015-11-17 | AA.B-DELISTED | Stock | 30.3135 | 30.4 | 29.78 | 29.8521 | 118749.0 |
| 2015-11-17 | AAAP-DELISTED | Stock | 24.46 | 25.51 | 24.38 | 25.07 | 23404.0 |
| 2015-11-17 | AABA-DELISTED | Stock | 33.01 | 33.12 | 32.62 | 32.87 | 9822914.0 |
| 2015-11-17 | AAC-DELISTED | Stock | 22.6 | 23.9 | 22.42 | 22.5 | 88760.0 |
| 2015-11-17 | AACG | Stock | 4.34 | 4.58 | 4.33 | 4.58 | 21600.0 |
| 2015-11-17 | AAIC-DELISTED | Stock | 13.43 | 13.58 | 13.3 | 13.31 | 216701.0 |
| 2015-11-17 | AAL | Stock | 43.0 | 43.46 | 42.05 | 42.3 | 9596500.0 |
| 2015-11-17 | AAMC-DELISTED | Stock | 4.5176 | 4.6147 | 3.6838 | 3.7029 | 115624.0 |
| 2015-11-17 | AAME | Stock | 4.83 | 5.0 | 4.8 | 4.96 | 4000.0 |
| 2015-11-17 | AAMI | Stock | 16.06 | 16.215 | 15.876 | 16.13 | 150500.0 |
| 2015-11-17 | AAOI | Stock | 17.03 | 17.15 | 16.19 | 16.68 | 477800.0 |
| 2015-11-17 | AAON | Stock | 15.7333 | 16.0333 | 15.5867 | 15.76 | 239850.0 |
| 2015-11-17 | AAP | Stock | 165.09 | 167.22 | 162.53 | 164.09 | 1171000.0 |
| 2015-11-17 | AAT | Stock | 39.25 | 39.94 | 39.25 | 39.3 | 156300.0 |
| 2015-11-17 | AAU-DELISTED | Stock | 0.54 | 0.5478 | 0.535 | 0.535 | 68800.0 |
| 2015-11-17 | AAUAF-DELISTED | Stock | 0.54 | 0.5478 | 0.535 | 0.535 | 69410.0 |
| 2015-11-17 | AAV-DELISTED | Stock | 5.55 | 5.7 | 5.5 | 5.58 | 157385.0 |
| 2015-11-17 | AAVL-DELISTED | Stock | 7.87 | 8.2 | 7.65 | 7.73 | 196565.0 |
| 2015-11-17 | AAWW-DELISTED | Stock | 40.09 | 41.0 | 39.75 | 40.27 | 179856.0 |
| 2015-11-17 | AAXJ | Stock | 55.17 | 55.38 | 55.0 | 55.16 | 683537.0 |
| 2015-11-17 | AAXN-DELISTED | Stock | 17.4 | 17.5 | 16.74 | 16.76 | 1737533.0 |
| 2015-11-17 | AB | Stock | 24.91 | 25.12 | 24.29 | 24.37 | 161800.0 |
| 2015-11-17 | ABAC-DELISTED | Stock | 0.62 | 0.636 | 0.62 | 0.636 | 3988.0 |
| 2015-11-17 | ABAX-DELISTED | Stock | 51.94 | 53.24 | 51.45 | 52.36 | 116923.0 |
| 2015-11-17 | ABB-DELISTED | Stock | 18.64 | 18.71 | 18.48 | 18.52 | 1975609.0 |
| 2015-11-17 | ABBNY-DELISTED | Stock | 18.64 | 18.71 | 18.48 | 18.52 | 2021420.0 |
| 2015-11-17 | ABBV | Stock | 60.1 | 61.73 | 59.73 | 60.38 | 8405400.0 |
| 2015-11-17 | ABC-DELISTED | Stock | 97.73 | 99.53 | 97.33 | 99.2 | 2064392.0 |
| 2015-11-17 | ABCB | Stock | 32.5 | 33.26 | 32.45 | 32.9 | 230800.0 |
| 2015-11-17 | ABCD-DELISTED | Stock | 5.35 | 5.35 | 5.23 | 5.3 | 32186.0 |
| 2015-11-17 | ABCO-DELISTED | Stock | 53.28 | 53.62 | 51.97 | 52.32 | 276514.0 |
| 2015-11-17 | ABCW-DELISTED | Stock | 41.7001 | 42.09 | 41.43 | 41.47 | 15336.0 |
| 2015-11-17 | ABDC-DELISTED | Stock | 11.8 | 12.15 | 11.8 | 11.8 | 54900.0 |
| 2015-11-17 | ABE-DELISTED | Stock | 11.2089 | 11.24 | 11.1516 | 11.17 | 5845.0 |
| 2015-11-17 | ABEO | Stock | 98.0 | 101.25 | 95.25 | 100.25 | 3280.0 |
| 2015-11-17 | ABEOW-DELISTED | Stock | 1.54 | 1.54 | 1.5 | 1.5 | 2000.0 |
| 2015-11-17 | ABEV | Stock | 4.99 | 5.03 | 4.94 | 5.01 | 13170100.0 |
| 2015-11-17 | ABG | Stock | 70.7 | 71.98 | 70.18 | 70.5 | 604600.0 |
| 2015-11-17 | ABGB-DELISTED | Stock | 5.01 | 5.13 | 4.95 | 5.034 | 34300.0 |
> showing 50 of 6,622 rows — these rows as CSV