PREVIEW / stock_daily / 2016-01-25
file: by_date/stock_daily/2016/2016-01-25.parquet size: 218 KB rows: 6,621 symbols: 3,377
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-01-25 | AAPL | Stock | 25.38 | 25.3825 | 24.8025 | 24.86 | 207178000.0 |
| 2016-01-25 | MSFT | Stock | 51.94 | 52.65 | 51.65 | 51.79 | 34707700.0 |
| 2016-01-25 | NVDA | Stock | 0.711 | 0.7193 | 0.709 | 0.7105 | 270728000.0 |
| 2016-01-25 | AMZN | Stock | 29.8995 | 30.425 | 29.728 | 29.8265 | 87922000.0 |
| 2016-01-25 | GOOGL | Stock | 37.192 | 37.623 | 36.625 | 36.681 | 45340620.0 |
| 2016-01-25 | META | Stock | 98.72 | 99.48 | 96.93 | 97.01 | 32482000.0 |
| 2016-01-25 | TSLA | Stock | 13.3373 | 13.5713 | 13.0587 | 13.092 | 40480500.0 |
| 2016-01-25 | TLT | Stock | 125.95 | 126.27 | 125.65 | 126.02 | 5738192.0 |
| 2016-01-25 | ES | Stock | 51.62 | 51.97 | 51.22 | 51.64 | 1950700.0 |
| 2016-01-25 | CL | Stock | 64.33 | 64.61 | 63.76 | 63.93 | 3728100.0 |
| 2016-01-25 | A | Stock | 37.4 | 38.03 | 37.4 | 37.61 | 1831200.0 |
| 2016-01-25 | AA.B-DELISTED | Stock | 25.49 | 25.49 | 24.65 | 24.65 | 32883.0 |
| 2016-01-25 | AAAP-DELISTED | Stock | 27.75 | 27.75 | 24.535 | 24.535 | 43912.0 |
| 2016-01-25 | AABA-DELISTED | Stock | 30.08 | 30.39 | 29.66 | 29.78 | 22021173.0 |
| 2016-01-25 | AAC-DELISTED | Stock | 16.69 | 18.9 | 16.69 | 18.42 | 303417.0 |
| 2016-01-25 | AACG | Stock | 5.47 | 5.7 | 5.35 | 5.41 | 17300.0 |
| 2016-01-25 | AAIC-DELISTED | Stock | 10.56 | 10.77 | 10.43 | 10.44 | 282747.0 |
| 2016-01-25 | AAL | Stock | 40.02 | 40.16 | 38.82 | 38.88 | 10113200.0 |
| 2016-01-25 | AAMC-DELISTED | Stock | 5.0912 | 5.0912 | 4.4882 | 4.8971 | 575841.0 |
| 2016-01-25 | AAME | Stock | 4.5 | 4.5 | 4.33 | 4.33 | 1800.0 |
| 2016-01-25 | AAMI | Stock | 11.33 | 11.4 | 11.15 | 11.33 | 228400.0 |
| 2016-01-25 | AAOI | Stock | 13.81 | 14.25 | 13.14 | 13.31 | 190700.0 |
| 2016-01-25 | AAON | Stock | 13.6867 | 13.9467 | 13.52 | 13.5467 | 297450.0 |
| 2016-01-25 | AAP | Stock | 144.99 | 146.33 | 143.24 | 144.72 | 853700.0 |
| 2016-01-25 | AAT | Stock | 37.17 | 37.67 | 36.56 | 36.97 | 126400.0 |
| 2016-01-25 | AAU-DELISTED | Stock | 0.54 | 0.56 | 0.54 | 0.5576 | 32087.0 |
| 2016-01-25 | AAUAF-DELISTED | Stock | 0.54 | 0.56 | 0.54 | 0.5576 | 32924.0 |
| 2016-01-25 | AAV-DELISTED | Stock | 5.13 | 5.17 | 4.98 | 5.0 | 98410.0 |
| 2016-01-25 | AAVL-DELISTED | Stock | 6.36 | 6.6 | 6.29 | 6.37 | 206409.0 |
| 2016-01-25 | AAWW-DELISTED | Stock | 35.93 | 36.97 | 34.33 | 34.37 | 246554.0 |
| 2016-01-25 | AAXJ | Stock | 48.51 | 48.59 | 47.93 | 47.99 | 1546292.0 |
| 2016-01-25 | AAXN-DELISTED | Stock | 15.27 | 15.35 | 14.72 | 15.02 | 1455804.0 |
| 2016-01-25 | AB | Stock | 19.7 | 19.82 | 19.04 | 19.04 | 536100.0 |
| 2016-01-25 | ABAC-DELISTED | Stock | 0.6 | 0.6768 | 0.6 | 0.6768 | 4200.0 |
| 2016-01-25 | ABAX-DELISTED | Stock | 53.33 | 53.67 | 51.93 | 51.99 | 122886.0 |
| 2016-01-25 | ABB-DELISTED | Stock | 16.36 | 16.5 | 16.285 | 16.32 | 2609152.0 |
| 2016-01-25 | ABBNY-DELISTED | Stock | 16.36 | 16.5 | 16.285 | 16.32 | 2858220.0 |
| 2016-01-25 | ABBV | Stock | 59.03 | 59.81 | 58.18 | 58.65 | 9681900.0 |
| 2016-01-25 | ABC-DELISTED | Stock | 91.99 | 92.23 | 91.05 | 91.27 | 2190299.0 |
| 2016-01-25 | ABCB | Stock | 27.36 | 27.62 | 26.67 | 26.73 | 323200.0 |
| 2016-01-25 | ABCD-DELISTED | Stock | 4.57 | 4.68 | 4.46 | 4.48 | 38633.0 |
| 2016-01-25 | ABCO-DELISTED | Stock | 44.43 | 45.15 | 43.79 | 44.56 | 217738.0 |
| 2016-01-25 | ABCW-DELISTED | Stock | 41.56 | 41.6 | 40.86 | 40.97 | 58540.0 |
| 2016-01-25 | ABDC-DELISTED | Stock | 10.87 | 10.91 | 10.27 | 10.3 | 29270.0 |
| 2016-01-25 | ABE-DELISTED | Stock | 10.11 | 10.11 | 9.92 | 9.9415 | 2645.0 |
| 2016-01-25 | ABEO | Stock | 70.75 | 73.5 | 67.25 | 68.0 | 2708.0 |
| 2016-01-25 | ABEV | Stock | 4.09 | 4.14 | 4.04 | 4.09 | 11907700.0 |
| 2016-01-25 | ABG | Stock | 49.58 | 50.94 | 48.72 | 49.33 | 1702700.0 |
| 2016-01-25 | ABGB-DELISTED | Stock | 1.07 | 1.19 | 1.01 | 1.049 | 664585.0 |
| 2016-01-25 | ABIL-DELISTED | Stock | 9.11 | 9.11 | 8.89 | 9.02 | 14000.0 |
> showing 50 of 6,621 rows — these rows as CSV