PREVIEW / stock_daily / 2016-08-10
file: by_date/stock_daily/2016/2016-08-10.parquet size: 219 KB rows: 6,549 symbols: 3,248
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-08-10 | AAPL | Stock | 27.1775 | 27.225 | 26.94 | 27.0 | 96034000.0 |
| 2016-08-10 | MSFT | Stock | 58.16 | 58.32 | 57.82 | 58.02 | 15756900.0 |
| 2016-08-10 | NVDA | Stock | 1.4852 | 1.4875 | 1.458 | 1.4628 | 375740000.0 |
| 2016-08-10 | AMZN | Stock | 38.49 | 38.605 | 38.3095 | 38.428 | 32086000.0 |
| 2016-08-10 | GOOGL | Stock | 40.3525 | 40.544 | 40.3245 | 40.4245 | 18370280.0 |
| 2016-08-10 | META | Stock | 125.07 | 125.48 | 124.54 | 124.88 | 10670100.0 |
| 2016-08-10 | TSLA | Stock | 15.216 | 15.3247 | 14.9747 | 15.0433 | 35074500.0 |
| 2016-08-10 | TLT | Stock | 139.9 | 140.51 | 139.47 | 140.16 | 5843487.0 |
| 2016-08-10 | ES | Stock | 56.98 | 57.11 | 56.82 | 56.94 | 722400.0 |
| 2016-08-10 | CL | Stock | 74.82 | 75.07 | 74.58 | 74.84 | 1949900.0 |
| 2016-08-10 | A | Stock | 47.51 | 47.58 | 47.21 | 47.51 | 754100.0 |
| 2016-08-10 | AA.B-DELISTED | Stock | 35.67 | 35.79 | 35.26 | 35.43 | 25270.0 |
| 2016-08-10 | AAAP-DELISTED | Stock | 31.88 | 32.0 | 31.14 | 31.68 | 21708.0 |
| 2016-08-10 | AABA-DELISTED | Stock | 39.34 | 39.98 | 39.3 | 39.93 | 11884508.0 |
| 2016-08-10 | AAC-DELISTED | Stock | 18.12 | 18.36 | 17.11 | 17.17 | 196150.0 |
| 2016-08-10 | AACG | Stock | 3.72 | 3.8 | 3.54 | 3.8 | 4200.0 |
| 2016-08-10 | AAIC-DELISTED | Stock | 15.04 | 15.05 | 14.76 | 14.85 | 249818.0 |
| 2016-08-10 | AAL | Stock | 34.59 | 34.75 | 33.74 | 34.18 | 5878400.0 |
| 2016-08-10 | AAMC-DELISTED | Stock | 3.9376 | 4.1382 | 3.7765 | 3.7765 | 86258.0 |
| 2016-08-10 | AAME | Stock | 4.1 | 4.15 | 4.1 | 4.1 | 800.0 |
| 2016-08-10 | AAMI | Stock | 13.62 | 13.643 | 13.48 | 13.58 | 85800.0 |
| 2016-08-10 | AAOI | Stock | 14.09 | 14.09 | 13.46 | 13.6 | 297000.0 |
| 2016-08-10 | AAON | Stock | 18.18 | 18.2533 | 18.0733 | 18.2333 | 151200.0 |
| 2016-08-10 | AAP | Stock | 166.57 | 167.48 | 165.57 | 166.65 | 838700.0 |
| 2016-08-10 | AAT | Stock | 45.67 | 46.2 | 45.57 | 45.95 | 234500.0 |
| 2016-08-10 | AAU-DELISTED | Stock | 1.6 | 1.81 | 1.6 | 1.81 | 1229005.0 |
| 2016-08-10 | AAUAF-DELISTED | Stock | 1.6 | 1.81 | 1.6 | 1.81 | 1245983.0 |
| 2016-08-10 | AAV-DELISTED | Stock | 6.74 | 6.85 | 6.64 | 6.66 | 91367.0 |
| 2016-08-10 | AAWW-DELISTED | Stock | 35.2 | 35.49 | 34.79 | 35.185 | 213250.0 |
| 2016-08-10 | AAXJ | Stock | 59.04 | 59.08 | 58.75 | 58.92 | 508012.0 |
| 2016-08-10 | AAXN-DELISTED | Stock | 28.54 | 28.76 | 28.18 | 28.68 | 715858.0 |
| 2016-08-10 | AB | Stock | 21.71 | 21.97 | 21.54 | 21.55 | 265400.0 |
| 2016-08-10 | ABAC-DELISTED | Stock | 0.6601 | 0.71 | 0.66 | 0.69 | 13048.0 |
| 2016-08-10 | ABAX-DELISTED | Stock | 49.71 | 49.71 | 48.9943 | 49.59 | 67679.0 |
| 2016-08-10 | ABB-DELISTED | Stock | 21.89 | 21.94 | 21.84 | 21.86 | 1598947.0 |
| 2016-08-10 | ABBNY-DELISTED | Stock | 21.89 | 21.94 | 21.84 | 21.86 | 1715083.0 |
| 2016-08-10 | ABBV | Stock | 66.7 | 66.96 | 66.19 | 66.43 | 4506100.0 |
| 2016-08-10 | ABC-DELISTED | Stock | 88.79 | 88.83 | 87.66 | 87.89 | 1442730.0 |
| 2016-08-10 | ABCB | Stock | 33.75 | 33.75 | 33.19 | 33.22 | 108000.0 |
| 2016-08-10 | ABCD-DELISTED | Stock | 4.76 | 4.76 | 4.68 | 4.68 | 5775.0 |
| 2016-08-10 | ABCO-DELISTED | Stock | 41.36 | 42.35 | 40.9301 | 41.3 | 109332.0 |
| 2016-08-10 | ABDC-DELISTED | Stock | 12.4 | 12.44 | 12.31 | 12.38 | 25704.0 |
| 2016-08-10 | ABE-DELISTED | Stock | 12.74 | 12.74 | 12.68 | 12.68 | 300.0 |
| 2016-08-10 | ABEO | Stock | 96.25 | 97.5 | 93.0 | 94.0 | 2240.0 |
| 2016-08-10 | ABEOW-DELISTED | Stock | 1.71 | 1.94 | 1.52 | 1.61 | 12241.0 |
| 2016-08-10 | ABEV | Stock | 6.15 | 6.16 | 6.08 | 6.09 | 12963200.0 |
| 2016-08-10 | ABG | Stock | 55.17 | 55.74 | 54.49 | 55.05 | 229700.0 |
| 2016-08-10 | ABIL-DELISTED | Stock | 5.59 | 5.59 | 5.4 | 5.45 | 29929.0 |
| 2016-08-10 | ABM | Stock | 37.2 | 37.61 | 37.2 | 37.61 | 136600.0 |
| 2016-08-10 | ABMD-DELISTED | Stock | 123.7 | 124.26 | 121.46 | 123.46 | 299794.0 |
> showing 50 of 6,549 rows — these rows as CSV