PREVIEW / stock_daily / 2015-01-16
file: by_date/stock_daily/2015/2015-01-16.parquet size: 221 KB rows: 6,622 symbols: 3,524
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-01-16 | AAPL | Stock | 26.7575 | 26.895 | 26.3 | 26.4975 | 314053200.0 |
| 2015-01-16 | MSFT | Stock | 45.31 | 46.28 | 45.17 | 46.24 | 35695300.0 |
| 2015-01-16 | NVDA | Stock | 0.4892 | 0.4995 | 0.4878 | 0.499 | 181512000.0 |
| 2015-01-16 | AMZN | Stock | 14.314 | 14.5395 | 14.2625 | 14.537 | 69564000.0 |
| 2015-01-16 | GOOGL | Stock | 25.1575 | 25.5425 | 25.1545 | 25.5228 | 49657160.0 |
| 2015-01-16 | META | Stock | 74.04 | 75.32 | 73.84 | 75.18 | 21791500.0 |
| 2015-01-16 | TSLA | Stock | 12.7133 | 12.966 | 12.6433 | 12.8713 | 54048000.0 |
| 2015-01-16 | TLT | Stock | 134.33 | 134.68 | 133.03 | 133.19 | 9390473.0 |
| 2015-01-16 | ES | Stock | 55.33 | 55.57 | 54.92 | 55.55 | 1464300.0 |
| 2015-01-16 | CL | Stock | 68.26 | 69.26 | 68.02 | 69.17 | 3787800.0 |
| 2015-01-16 | A | Stock | 37.83 | 38.46 | 37.76 | 38.25 | 3004000.0 |
| 2015-01-16 | AA.B-DELISTED | Stock | 49.0 | 49.5999 | 48.96 | 49.4105 | 26677.0 |
| 2015-01-16 | AABA-DELISTED | Stock | 46.06 | 46.59 | 45.85 | 46.45 | 13936993.0 |
| 2015-01-16 | AAC-DELISTED | Stock | 28.55 | 30.15 | 28.51 | 30.14 | 60476.0 |
| 2015-01-16 | AACG | Stock | 4.71 | 4.71 | 4.5 | 4.65 | 22700.0 |
| 2015-01-16 | AAIC-DELISTED | Stock | 25.86 | 26.31 | 25.75 | 26.31 | 146086.0 |
| 2015-01-16 | AAL | Stock | 49.38 | 49.97 | 48.27 | 49.81 | 12978000.0 |
| 2015-01-16 | AAMC-DELISTED | Stock | 65.2294 | 90.6265 | 63.0882 | 88.2382 | 125355.0 |
| 2015-01-16 | AAME | Stock | 3.98 | 4.0 | 3.81 | 4.0 | 1200.0 |
| 2015-01-16 | AAMI | Stock | 15.48 | 15.8 | 15.22 | 15.77 | 126900.0 |
| 2015-01-16 | AAOI | Stock | 8.35 | 8.7 | 8.17 | 8.59 | 210700.0 |
| 2015-01-16 | AAON | Stock | 14.1533 | 14.6333 | 14.1533 | 14.62 | 191850.0 |
| 2015-01-16 | AAP | Stock | 148.0 | 150.2 | 147.2 | 150.0 | 776800.0 |
| 2015-01-16 | AAT | Stock | 43.47 | 44.45 | 43.47 | 44.36 | 93000.0 |
| 2015-01-16 | AAU-DELISTED | Stock | 1.12 | 1.15 | 1.03 | 1.12 | 1308084.0 |
| 2015-01-16 | AAUAF-DELISTED | Stock | 1.12 | 1.15 | 1.03 | 1.12 | 1310861.0 |
| 2015-01-16 | AAV-DELISTED | Stock | 4.37 | 4.765 | 4.36 | 4.76 | 168120.0 |
| 2015-01-16 | AAVL-DELISTED | Stock | 51.34 | 51.34 | 46.41 | 48.38 | 644987.0 |
| 2015-01-16 | AAWW-DELISTED | Stock | 45.36 | 46.04 | 45.3 | 45.96 | 220312.0 |
| 2015-01-16 | AAXJ | Stock | 61.51 | 62.2 | 61.48 | 62.17 | 1174774.0 |
| 2015-01-16 | AAXN-DELISTED | Stock | 25.3 | 25.62 | 24.9722 | 25.35 | 1537488.0 |
| 2015-01-16 | AB | Stock | 25.4 | 25.77 | 25.21 | 25.73 | 140800.0 |
| 2015-01-16 | ABAC-DELISTED | Stock | 1.45 | 1.49 | 1.4499 | 1.49 | 12715.0 |
| 2015-01-16 | ABAX-DELISTED | Stock | 56.44 | 59.57 | 56.23 | 59.43 | 236355.0 |
| 2015-01-16 | ABB-DELISTED | Stock | 19.93 | 20.05 | 19.57 | 19.89 | 3875167.0 |
| 2015-01-16 | ABBNY-DELISTED | Stock | 19.93 | 20.05 | 19.57 | 19.9 | 4130021.0 |
| 2015-01-16 | ABBV | Stock | 62.95 | 64.62 | 62.64 | 64.54 | 8106000.0 |
| 2015-01-16 | ABC-DELISTED | Stock | 91.14 | 92.46 | 90.15 | 92.39 | 1277558.0 |
| 2015-01-16 | ABCB | Stock | 22.9 | 23.58 | 22.71 | 23.49 | 59400.0 |
| 2015-01-16 | ABCD-DELISTED | Stock | 1.84 | 1.85 | 1.8 | 1.8 | 10100.0 |
| 2015-01-16 | ABCO-DELISTED | Stock | 47.58 | 48.12 | 47.05 | 48.07 | 186803.0 |
| 2015-01-16 | ABCW-DELISTED | Stock | 34.46 | 37.96 | 34.46 | 34.85 | 11600.0 |
| 2015-01-16 | ABDC-DELISTED | Stock | 12.82 | 13.0479 | 12.5 | 12.97 | 21047.0 |
| 2015-01-16 | ABE-DELISTED | Stock | 13.1 | 13.1301 | 13.08 | 13.08 | 1876.0 |
| 2015-01-16 | ABEO | Stock | 77.0 | 86.25 | 77.0 | 81.25 | 188.0 |
| 2015-01-16 | ABEOW-DELISTED | Stock | 0.8125 | 0.8125 | 0.8 | 0.8 | 400.0 |
| 2015-01-16 | ABEV | Stock | 6.45 | 6.53 | 6.44 | 6.53 | 8161100.0 |
| 2015-01-16 | ABG | Stock | 69.94 | 71.04 | 69.12 | 70.79 | 557300.0 |
| 2015-01-16 | ABGB-DELISTED | Stock | 16.46 | 16.8 | 16.25 | 16.8 | 36666.0 |
| 2015-01-16 | ABIL-DELISTED | Stock | 9.8 | 9.81 | 9.8 | 9.81 | 400.0 |
> showing 50 of 6,622 rows — these rows as CSV