PREVIEW / stock_daily / 2014-12-30
file: by_date/stock_daily/2014/2014-12-30.parquet size: 223 KB rows: 6,659 symbols: 3,529
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-30 | AAPL | Stock | 28.41 | 28.48 | 28.0275 | 28.13 | 119526000.0 |
| 2014-12-30 | MSFT | Stock | 47.44 | 47.62 | 46.84 | 47.02 | 16384700.0 |
| 2014-12-30 | NVDA | Stock | 0.5105 | 0.513 | 0.5085 | 0.5093 | 112120000.0 |
| 2014-12-30 | AMZN | Stock | 15.4955 | 15.697 | 15.467 | 15.515 | 41860000.0 |
| 2014-12-30 | GOOGL | Stock | 26.748 | 26.892 | 26.6805 | 26.764 | 20972620.0 |
| 2014-12-30 | META | Stock | 79.85 | 80.59 | 79.1 | 79.22 | 14370800.0 |
| 2014-12-30 | TSLA | Stock | 14.9327 | 15.0433 | 14.76 | 14.8153 | 43548000.0 |
| 2014-12-30 | TLT | Stock | 125.98 | 126.2101 | 125.53 | 125.68 | 4372557.0 |
| 2014-12-30 | ES | Stock | 55.94 | 55.94 | 54.55 | 54.67 | 1629100.0 |
| 2014-12-30 | CL | Stock | 70.34 | 70.69 | 69.85 | 70.04 | 2085900.0 |
| 2014-12-30 | A | Stock | 41.21 | 41.59 | 41.14 | 41.37 | 1323500.0 |
| 2014-12-30 | AA.B-DELISTED | Stock | 50.32 | 50.926 | 50.28 | 50.89 | 15040.0 |
| 2014-12-30 | AABA-DELISTED | Stock | 50.38 | 51.27 | 50.35 | 51.21 | 10087911.0 |
| 2014-12-30 | AAC-DELISTED | Stock | 29.33 | 31.26 | 29.16 | 30.92 | 66583.0 |
| 2014-12-30 | AACG | Stock | 3.98 | 4.2 | 3.9 | 4.14 | 24300.0 |
| 2014-12-30 | AAIC-DELISTED | Stock | 27.08 | 27.15 | 26.91 | 26.96 | 202790.0 |
| 2014-12-30 | AAL | Stock | 53.0 | 53.7 | 52.83 | 53.42 | 8063100.0 |
| 2014-12-30 | AAMC-DELISTED | Stock | 107.6471 | 107.6471 | 99.1176 | 100.0 | 21913.0 |
| 2014-12-30 | AAME | Stock | 3.88 | 3.95 | 3.86 | 3.93 | 4800.0 |
| 2014-12-30 | AAMI | Stock | 16.2 | 16.32 | 15.83 | 16.22 | 123000.0 |
| 2014-12-30 | AAOI | Stock | 10.87 | 11.18 | 10.87 | 11.01 | 156500.0 |
| 2014-12-30 | AAON | Stock | 14.84 | 14.9933 | 14.7333 | 14.8933 | 136350.0 |
| 2014-12-30 | AAP | Stock | 161.21 | 162.08 | 160.0 | 160.03 | 340000.0 |
| 2014-12-30 | AAT | Stock | 40.68 | 40.93 | 40.54 | 40.63 | 62300.0 |
| 2014-12-30 | AAU-DELISTED | Stock | 0.922 | 0.98 | 0.922 | 0.9621 | 172353.0 |
| 2014-12-30 | AAUAF-DELISTED | Stock | 0.922 | 0.98 | 0.922 | 0.952 | 173162.0 |
| 2014-12-30 | AAV-DELISTED | Stock | 4.64 | 4.7 | 4.5599 | 4.66 | 217797.0 |
| 2014-12-30 | AAVL-DELISTED | Stock | 51.64 | 55.98 | 51.155 | 55.89 | 189893.0 |
| 2014-12-30 | AAWW-DELISTED | Stock | 48.94 | 49.49 | 48.77 | 49.13 | 78682.0 |
| 2014-12-30 | AAXJ | Stock | 60.7 | 60.79 | 60.565 | 60.67 | 1019621.0 |
| 2014-12-30 | AAXN-DELISTED | Stock | 26.55 | 27.0 | 26.46 | 26.82 | 1356486.0 |
| 2014-12-30 | AB | Stock | 25.74 | 26.04 | 25.55 | 25.94 | 257700.0 |
| 2014-12-30 | ABAC-DELISTED | Stock | 1.7 | 1.91 | 1.6591 | 1.91 | 16500.0 |
| 2014-12-30 | ABAX-DELISTED | Stock | 57.84 | 58.46 | 57.15 | 57.9 | 119222.0 |
| 2014-12-30 | ABB-DELISTED | Stock | 21.5 | 21.51 | 21.391 | 21.41 | 596622.0 |
| 2014-12-30 | ABBNY-DELISTED | Stock | 21.5 | 21.51 | 21.391 | 21.4 | 628081.0 |
| 2014-12-30 | ABBV | Stock | 66.77 | 67.16 | 66.02 | 66.3 | 5568800.0 |
| 2014-12-30 | ABC-DELISTED | Stock | 91.47 | 91.67 | 91.08 | 91.26 | 936049.0 |
| 2014-12-30 | ABCB | Stock | 25.96 | 26.04 | 25.78 | 25.99 | 39900.0 |
| 2014-12-30 | ABCD-DELISTED | Stock | 1.65 | 1.69 | 1.65 | 1.66 | 6100.0 |
| 2014-12-30 | ABCO-DELISTED | Stock | 49.45 | 50.19 | 49.45 | 49.98 | 146351.0 |
| 2014-12-30 | ABCW-DELISTED | Stock | 35.0 | 35.0 | 34.875 | 34.995 | 18550.0 |
| 2014-12-30 | ABDC-DELISTED | Stock | 12.72 | 12.98 | 12.65 | 12.83 | 90555.0 |
| 2014-12-30 | ABE-DELISTED | Stock | 13.0 | 13.1176 | 13.0 | 13.1 | 6777.0 |
| 2014-12-30 | ABEO | Stock | 91.25 | 92.5 | 88.75 | 89.0 | 176.0 |
| 2014-12-30 | ABEOW-DELISTED | Stock | 0.8 | 0.8 | 0.8 | 0.8 | 400.0 |
| 2014-12-30 | ABEV | Stock | 6.14 | 6.25 | 6.14 | 6.19 | 13389200.0 |
| 2014-12-30 | ABG | Stock | 77.34 | 77.5 | 76.85 | 76.86 | 266600.0 |
| 2014-12-30 | ABGB-DELISTED | Stock | 11.54 | 11.67 | 11.42 | 11.64 | 108381.0 |
| 2014-12-30 | ABM | Stock | 29.23 | 29.35 | 28.83 | 28.97 | 146400.0 |
> showing 50 of 6,659 rows — these rows as CSV