PREVIEW / stock_daily / 2015-12-28
file: by_date/stock_daily/2015/2015-12-28.parquet size: 221 KB rows: 6,662 symbols: 3,415
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-28 | AAPL | Stock | 26.8975 | 26.9225 | 26.545 | 26.705 | 106816800.0 |
| 2015-12-28 | MSFT | Stock | 55.35 | 55.95 | 54.98 | 55.95 | 22458300.0 |
| 2015-12-28 | NVDA | Stock | 0.8205 | 0.8285 | 0.809 | 0.8285 | 142024000.0 |
| 2015-12-28 | AMZN | Stock | 33.278 | 33.775 | 33.275 | 33.76 | 75672000.0 |
| 2015-12-28 | GOOGL | Stock | 38.5 | 39.1408 | 38.3865 | 39.112 | 31155100.0 |
| 2015-12-28 | META | Stock | 105.02 | 105.98 | 104.53 | 105.93 | 13069700.0 |
| 2015-12-28 | TSLA | Stock | 15.4327 | 15.4653 | 15.036 | 15.2633 | 28519500.0 |
| 2015-12-28 | TLT | Stock | 121.99 | 122.67 | 121.85 | 122.19 | 7586564.0 |
| 2015-12-28 | ES | Stock | 51.71 | 51.86 | 51.39 | 51.84 | 718600.0 |
| 2015-12-28 | CL | Stock | 66.76 | 66.95 | 66.65 | 66.89 | 1525700.0 |
| 2015-12-28 | A | Stock | 42.02 | 42.08 | 41.52 | 41.78 | 1458200.0 |
| 2015-12-28 | AA.B-DELISTED | Stock | 33.8 | 33.8 | 33.14 | 33.38 | 40846.0 |
| 2015-12-28 | AAAP-DELISTED | Stock | 30.0 | 30.04 | 29.31 | 29.5401 | 25316.0 |
| 2015-12-28 | AABA-DELISTED | Stock | 33.9 | 33.91 | 33.35 | 33.59 | 9553120.0 |
| 2015-12-28 | AAC-DELISTED | Stock | 19.04 | 19.3599 | 18.33 | 18.75 | 214559.0 |
| 2015-12-28 | AACG | Stock | 6.72 | 6.72 | 6.21 | 6.33 | 63800.0 |
| 2015-12-28 | AAIC-DELISTED | Stock | 14.67 | 14.75 | 14.29 | 14.5 | 486926.0 |
| 2015-12-28 | AAL | Stock | 43.62 | 44.04 | 42.91 | 43.23 | 4148000.0 |
| 2015-12-28 | AAMC-DELISTED | Stock | 5.8853 | 5.9618 | 5.0676 | 5.2971 | 223938.0 |
| 2015-12-28 | AAME | Stock | 4.72 | 4.75 | 4.7 | 4.72 | 3300.0 |
| 2015-12-28 | AAMI | Stock | 15.26 | 15.33 | 15.05 | 15.24 | 68100.0 |
| 2015-12-28 | AAOI | Stock | 17.52 | 17.6 | 16.95 | 17.56 | 230200.0 |
| 2015-12-28 | AAON | Stock | 15.76 | 15.8467 | 15.5867 | 15.68 | 208050.0 |
| 2015-12-28 | AAP | Stock | 148.44 | 150.92 | 148.14 | 150.55 | 710600.0 |
| 2015-12-28 | AAT | Stock | 38.79 | 38.94 | 38.64 | 38.93 | 68000.0 |
| 2015-12-28 | AAU-DELISTED | Stock | 0.68 | 0.72 | 0.65 | 0.72 | 91660.0 |
| 2015-12-28 | AAUAF-DELISTED | Stock | 0.68 | 0.72 | 0.65 | 0.72 | 92503.0 |
| 2015-12-28 | AAV-DELISTED | Stock | 4.93 | 4.98 | 4.854 | 4.95 | 30274.0 |
| 2015-12-28 | AAVL-DELISTED | Stock | 9.43 | 9.5 | 9.11 | 9.28 | 156609.0 |
| 2015-12-28 | AAWW-DELISTED | Stock | 43.48 | 43.52 | 42.32 | 42.41 | 228388.0 |
| 2015-12-28 | AAXJ | Stock | 54.01 | 54.11 | 53.75 | 54.01 | 1706288.0 |
| 2015-12-28 | AAXN-DELISTED | Stock | 17.7 | 17.82 | 17.14 | 17.25 | 985692.0 |
| 2015-12-28 | AB | Stock | 24.84 | 25.24 | 24.21 | 24.55 | 243600.0 |
| 2015-12-28 | ABAC-DELISTED | Stock | 1.13 | 1.13 | 0.93 | 0.9458 | 6385.0 |
| 2015-12-28 | ABAX-DELISTED | Stock | 54.88 | 56.53 | 54.77 | 55.98 | 169265.0 |
| 2015-12-28 | ABB-DELISTED | Stock | 18.27 | 18.27 | 18.09 | 18.16 | 1810054.0 |
| 2015-12-28 | ABBNY-DELISTED | Stock | 18.27 | 18.27 | 18.09 | 18.16 | 1849859.0 |
| 2015-12-28 | ABBV | Stock | 58.27 | 58.97 | 57.76 | 58.75 | 5585800.0 |
| 2015-12-28 | ABC-DELISTED | Stock | 103.85 | 104.57 | 103.48 | 104.22 | 693013.0 |
| 2015-12-28 | ABCB | Stock | 34.15 | 34.47 | 33.72 | 34.41 | 161600.0 |
| 2015-12-28 | ABCD-DELISTED | Stock | 5.05 | 5.14 | 4.86 | 5.07 | 24655.0 |
| 2015-12-28 | ABCO-DELISTED | Stock | 49.8 | 50.36 | 49.26 | 50.3 | 117351.0 |
| 2015-12-28 | ABCW-DELISTED | Stock | 44.0 | 44.1 | 43.78 | 44.09 | 35198.0 |
| 2015-12-28 | ABDC-DELISTED | Stock | 12.13 | 12.17 | 11.69 | 12.01 | 59562.0 |
| 2015-12-28 | ABE-DELISTED | Stock | 10.92 | 10.97 | 10.85 | 10.9089 | 4870.0 |
| 2015-12-28 | ABEO | Stock | 90.5 | 91.75 | 87.5 | 88.25 | 2116.0 |
| 2015-12-28 | ABEV | Stock | 4.59 | 4.69 | 4.58 | 4.67 | 12924600.0 |
| 2015-12-28 | ABG | Stock | 68.61 | 68.98 | 67.79 | 68.56 | 230100.0 |
| 2015-12-28 | ABGB-DELISTED | Stock | 1.52 | 1.55 | 1.48 | 1.51 | 40943.0 |
| 2015-12-28 | ABIL-DELISTED | Stock | 11.03 | 11.03 | 9.02 | 9.1711 | 46589.0 |
> showing 50 of 6,662 rows — these rows as CSV