PREVIEW / stock_daily / 2016-04-11
file: by_date/stock_daily/2016/2016-04-11.parquet size: 218 KB rows: 6,566 symbols: 3,314
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 |
|---|---|---|---|---|---|---|---|
| 2016-04-11 | AAPL | Stock | 27.2425 | 27.6525 | 27.2075 | 27.255 | 117630000.0 |
| 2016-04-11 | MSFT | Stock | 54.49 | 55.15 | 54.3 | 54.31 | 21414200.0 |
| 2016-04-11 | NVDA | Stock | 0.8968 | 0.9118 | 0.894 | 0.897 | 387524000.0 |
| 2016-04-11 | AMZN | Stock | 29.807 | 30.2 | 29.7455 | 29.7965 | 54086000.0 |
| 2016-04-11 | GOOGL | Stock | 38.2725 | 38.361 | 37.867 | 37.877 | 31773840.0 |
| 2016-04-11 | META | Stock | 110.7 | 110.91 | 108.77 | 108.99 | 39762300.0 |
| 2016-04-11 | TSLA | Stock | 16.7333 | 17.266 | 16.3533 | 16.6613 | 137425500.0 |
| 2016-04-11 | TLT | Stock | 131.32 | 132.18 | 131.11 | 131.84 | 4805494.0 |
| 2016-04-11 | ES | Stock | 57.06 | 57.43 | 56.61 | 56.63 | 1699900.0 |
| 2016-04-11 | CL | Stock | 71.12 | 71.4 | 70.8 | 70.94 | 2996300.0 |
| 2016-04-11 | A | Stock | 39.86 | 40.0 | 39.35 | 39.41 | 1049300.0 |
| 2016-04-11 | AA.B-DELISTED | Stock | 32.95 | 33.81 | 32.95 | 33.6 | 374959.0 |
| 2016-04-11 | AAAP-DELISTED | Stock | 35.94 | 37.4 | 35.0 | 35.0 | 9600.0 |
| 2016-04-11 | AABA-DELISTED | Stock | 36.38 | 36.845 | 36.32 | 36.48 | 12569869.0 |
| 2016-04-11 | AAC-DELISTED | Stock | 18.72 | 18.72 | 17.87 | 18.26 | 120050.0 |
| 2016-04-11 | AACG | Stock | 5.3 | 5.84 | 5.21 | 5.25 | 2000.0 |
| 2016-04-11 | AAIC-DELISTED | Stock | 12.2 | 12.45 | 12.19 | 12.19 | 283621.0 |
| 2016-04-11 | AAL | Stock | 38.79 | 39.55 | 38.67 | 38.73 | 7932300.0 |
| 2016-04-11 | AAMC-DELISTED | Stock | 5.4176 | 6.4647 | 5.4118 | 5.9176 | 175743.0 |
| 2016-04-11 | AAME | Stock | 4.61 | 4.81 | 4.56 | 4.56 | 5800.0 |
| 2016-04-11 | AAMI | Stock | 12.78 | 13.06 | 12.67 | 12.74 | 229600.0 |
| 2016-04-11 | AAOI | Stock | 15.82 | 16.44 | 15.58 | 15.91 | 274900.0 |
| 2016-04-11 | AAON | Stock | 17.96 | 18.2067 | 17.6867 | 17.7 | 280650.0 |
| 2016-04-11 | AAP | Stock | 156.25 | 157.28 | 154.75 | 154.77 | 364000.0 |
| 2016-04-11 | AAT | Stock | 38.73 | 39.07 | 38.47 | 38.53 | 145800.0 |
| 2016-04-11 | AAU-DELISTED | Stock | 1.15 | 1.27 | 1.14 | 1.2 | 2945140.0 |
| 2016-04-11 | AAUAF-DELISTED | Stock | 1.15 | 1.27 | 1.14 | 1.22 | 2980022.0 |
| 2016-04-11 | AAV-DELISTED | Stock | 5.25 | 5.36 | 5.22 | 5.34 | 45426.0 |
| 2016-04-11 | AAVL-DELISTED | Stock | 5.22 | 5.33 | 5.075 | 5.12 | 165639.0 |
| 2016-04-11 | AAWW-DELISTED | Stock | 39.22 | 40.35 | 38.77 | 38.825 | 181947.0 |
| 2016-04-11 | AAXJ | Stock | 53.97 | 54.19 | 53.815 | 53.83 | 548403.0 |
| 2016-04-11 | AAXN-DELISTED | Stock | 18.46 | 18.77 | 18.3913 | 18.46 | 540014.0 |
| 2016-04-11 | AB | Stock | 23.82 | 24.21 | 23.6 | 23.82 | 175500.0 |
| 2016-04-11 | ABAC-DELISTED | Stock | 0.6 | 0.6 | 0.58 | 0.58 | 19600.0 |
| 2016-04-11 | ABAX-DELISTED | Stock | 44.32 | 44.72 | 42.885 | 44.58 | 166862.0 |
| 2016-04-11 | ABB-DELISTED | Stock | 19.46 | 19.57 | 19.39 | 19.39 | 1255624.0 |
| 2016-04-11 | ABBNY-DELISTED | Stock | 19.46 | 19.57 | 19.39 | 19.39 | 1307878.0 |
| 2016-04-11 | ABBV | Stock | 58.59 | 59.25 | 58.25 | 58.5 | 4894000.0 |
| 2016-04-11 | ABC-DELISTED | Stock | 85.16 | 85.535 | 84.36 | 84.45 | 1611016.0 |
| 2016-04-11 | ABCB | Stock | 28.34 | 28.82 | 28.29 | 28.62 | 101400.0 |
| 2016-04-11 | ABCD-DELISTED | Stock | 4.04 | 4.19 | 4.03 | 4.09 | 20366.0 |
| 2016-04-11 | ABCO-DELISTED | Stock | 31.9 | 32.08 | 31.38 | 31.46 | 490345.0 |
| 2016-04-11 | ABCW-DELISTED | Stock | 44.28 | 44.86 | 44.23 | 44.33 | 28147.0 |
| 2016-04-11 | ABDC-DELISTED | Stock | 11.7 | 11.79 | 11.6 | 11.64 | 8620.0 |
| 2016-04-11 | ABE-DELISTED | Stock | 11.64 | 11.7932 | 11.64 | 11.72 | 32251.0 |
| 2016-04-11 | ABEO | Stock | 67.5 | 68.0 | 65.0 | 65.25 | 2420.0 |
| 2016-04-11 | ABEV | Stock | 5.19 | 5.2 | 5.1 | 5.17 | 15356400.0 |
| 2016-04-11 | ABG | Stock | 54.05 | 55.2 | 53.89 | 54.06 | 328900.0 |
| 2016-04-11 | ABGB-DELISTED | Stock | 1.48 | 1.59 | 1.48 | 1.5 | 57352.0 |
| 2016-04-11 | ABIL-DELISTED | Stock | 6.59 | 6.8203 | 6.59 | 6.7385 | 16673.0 |
> showing 50 of 6,566 rows — these rows as CSV