PREVIEW / stock_daily / 2016-05-10
file: by_date/stock_daily/2016/2016-05-10.parquet size: 218 KB rows: 6,534 symbols: 3,265
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-05-10 | AAPL | Stock | 23.3325 | 23.3925 | 23.0275 | 23.355 | 134747200.0 |
| 2016-05-10 | MSFT | Stock | 50.33 | 51.1 | 50.19 | 51.02 | 22891000.0 |
| 2016-05-10 | NVDA | Stock | 0.8875 | 0.9005 | 0.879 | 0.899 | 269676000.0 |
| 2016-05-10 | AMZN | Stock | 34.7 | 35.2275 | 34.675 | 35.1535 | 122112000.0 |
| 2016-05-10 | GOOGL | Stock | 36.748 | 37.0 | 36.5805 | 36.969 | 32634280.0 |
| 2016-05-10 | META | Stock | 119.62 | 120.5 | 119.0 | 120.5 | 23220000.0 |
| 2016-05-10 | TSLA | Stock | 13.8367 | 13.9647 | 13.6667 | 13.9127 | 61059000.0 |
| 2016-05-10 | TLT | Stock | 130.85 | 131.12 | 130.65 | 130.87 | 4331861.0 |
| 2016-05-10 | ES | Stock | 57.8 | 57.86 | 57.32 | 57.54 | 1287000.0 |
| 2016-05-10 | CL | Stock | 71.86 | 72.25 | 71.76 | 72.2 | 2710900.0 |
| 2016-05-10 | A | Stock | 41.5 | 42.0 | 41.35 | 42.0 | 2094300.0 |
| 2016-05-10 | AA.B-DELISTED | Stock | 33.75 | 33.81 | 32.852 | 33.66 | 142668.0 |
| 2016-05-10 | AAAP-DELISTED | Stock | 33.74 | 35.96 | 31.93 | 35.84 | 33924.0 |
| 2016-05-10 | AABA-DELISTED | Stock | 37.17 | 37.58 | 37.14 | 37.43 | 6697868.0 |
| 2016-05-10 | AAC-DELISTED | Stock | 21.76 | 22.46 | 20.74 | 21.62 | 143717.0 |
| 2016-05-10 | AACG | Stock | 5.59 | 5.69 | 5.5 | 5.55 | 6700.0 |
| 2016-05-10 | AAIC-DELISTED | Stock | 12.25 | 12.63 | 11.99 | 12.54 | 545663.0 |
| 2016-05-10 | AAL | Stock | 33.24 | 33.8 | 33.09 | 33.77 | 8124400.0 |
| 2016-05-10 | AAMC-DELISTED | Stock | 5.0588 | 5.2941 | 3.9882 | 4.0176 | 156074.0 |
| 2016-05-10 | AAMI | Stock | 14.24 | 14.48 | 14.17 | 14.25 | 151400.0 |
| 2016-05-10 | AAOI | Stock | 8.9 | 9.15 | 8.08 | 8.49 | 1899100.0 |
| 2016-05-10 | AAON | Stock | 18.5 | 19.0733 | 18.4133 | 18.8333 | 238650.0 |
| 2016-05-10 | AAP | Stock | 152.39 | 153.58 | 151.37 | 152.29 | 684600.0 |
| 2016-05-10 | AAT | Stock | 42.37 | 42.37 | 41.85 | 42.08 | 66300.0 |
| 2016-05-10 | AAU-DELISTED | Stock | 1.06 | 1.1 | 1.0 | 1.1 | 314232.0 |
| 2016-05-10 | AAUAF-DELISTED | Stock | 1.06 | 1.1 | 1.0 | 1.1 | 315774.0 |
| 2016-05-10 | AAV-DELISTED | Stock | 5.24 | 5.4201 | 5.24 | 5.41 | 45479.0 |
| 2016-05-10 | AAVL-DELISTED | Stock | 4.08 | 4.4 | 3.95 | 4.32 | 197667.0 |
| 2016-05-10 | AAWW-DELISTED | Stock | 46.21 | 46.97 | 45.34 | 46.22 | 301510.0 |
| 2016-05-10 | AAXJ | Stock | 52.09 | 52.53 | 52.09 | 52.51 | 672384.0 |
| 2016-05-10 | AAXN-DELISTED | Stock | 18.66 | 19.41 | 18.48 | 19.4 | 951107.0 |
| 2016-05-10 | AB | Stock | 22.85 | 23.71 | 22.71 | 23.2 | 309300.0 |
| 2016-05-10 | ABAC-DELISTED | Stock | 0.661 | 0.6926 | 0.661 | 0.6926 | 5783.0 |
| 2016-05-10 | ABAX-DELISTED | Stock | 45.31 | 45.31 | 44.02 | 44.35 | 172386.0 |
| 2016-05-10 | ABB-DELISTED | Stock | 20.45 | 20.71 | 20.45 | 20.68 | 1635013.0 |
| 2016-05-10 | ABBNY-DELISTED | Stock | 20.45 | 20.71 | 20.45 | 20.69 | 1673623.0 |
| 2016-05-10 | ABBV | Stock | 63.51 | 63.76 | 63.32 | 63.74 | 12103400.0 |
| 2016-05-10 | ABC-DELISTED | Stock | 77.78 | 78.2887 | 76.4 | 76.68 | 3342965.0 |
| 2016-05-10 | ABCB | Stock | 30.82 | 31.5 | 30.74 | 31.25 | 131000.0 |
| 2016-05-10 | ABCD-DELISTED | Stock | 4.2999 | 4.3 | 4.14 | 4.26 | 13826.0 |
| 2016-05-10 | ABCO-DELISTED | Stock | 33.92 | 33.92 | 32.3001 | 33.75 | 515890.0 |
| 2016-05-10 | ABDC-DELISTED | Stock | 11.1 | 11.35 | 11.0 | 11.1 | 75011.0 |
| 2016-05-10 | ABE-DELISTED | Stock | 11.78 | 11.8765 | 11.78 | 11.8765 | 1150.0 |
| 2016-05-10 | ABEO | Stock | 63.0 | 63.0 | 60.5 | 62.0 | 568.0 |
| 2016-05-10 | ABEOW-DELISTED | Stock | 0.75 | 0.75 | 0.61 | 0.6374 | 979.0 |
| 2016-05-10 | ABEV | Stock | 5.39 | 5.45 | 5.36 | 5.43 | 10408300.0 |
| 2016-05-10 | ABG | Stock | 57.16 | 58.32 | 56.51 | 57.91 | 206700.0 |
| 2016-05-10 | ABIL-DELISTED | Stock | 3.2 | 3.42 | 3.17 | 3.35 | 39907.0 |
| 2016-05-10 | ABM | Stock | 32.97 | 33.35 | 32.87 | 33.33 | 246300.0 |
| 2016-05-10 | ABMD-DELISTED | Stock | 97.1 | 97.84 | 95.5 | 96.75 | 421413.0 |
> showing 50 of 6,534 rows — these rows as CSV