PREVIEW / stock_daily / 2016-05-13
file: by_date/stock_daily/2016/2016-05-13.parquet size: 218 KB rows: 6,520 symbols: 3,261
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-13 | AAPL | Stock | 22.5 | 22.9175 | 22.5 | 22.63 | 177571200.0 |
| 2016-05-13 | MSFT | Stock | 51.44 | 51.9 | 51.04 | 51.08 | 22592300.0 |
| 2016-05-13 | NVDA | Stock | 0.9798 | 1.025 | 0.975 | 1.0245 | 2110256000.0 |
| 2016-05-13 | AMZN | Stock | 35.732 | 35.9625 | 35.3255 | 35.496 | 95268000.0 |
| 2016-05-13 | GOOGL | Stock | 36.331 | 36.5645 | 36.1755 | 36.2415 | 25243220.0 |
| 2016-05-13 | META | Stock | 120.38 | 120.64 | 119.68 | 119.81 | 18124300.0 |
| 2016-05-13 | TSLA | Stock | 13.852 | 14.08 | 13.78 | 13.8407 | 42342000.0 |
| 2016-05-13 | TLT | Stock | 131.48 | 132.32 | 131.23 | 132.28 | 8707286.0 |
| 2016-05-13 | ES | Stock | 57.66 | 57.74 | 57.08 | 57.39 | 1351400.0 |
| 2016-05-13 | CL | Stock | 72.58 | 72.58 | 71.53 | 71.67 | 2630000.0 |
| 2016-05-13 | A | Stock | 42.55 | 42.93 | 42.39 | 42.62 | 2430600.0 |
| 2016-05-13 | AA.B-DELISTED | Stock | 33.4399 | 33.4399 | 32.4988 | 32.64 | 263695.0 |
| 2016-05-13 | AAAP-DELISTED | Stock | 30.89 | 30.9299 | 27.12 | 28.16 | 104948.0 |
| 2016-05-13 | AABA-DELISTED | Stock | 36.91 | 37.07 | 36.38 | 36.48 | 10212749.0 |
| 2016-05-13 | AAC-DELISTED | Stock | 20.35 | 20.72 | 20.2701 | 20.41 | 63068.0 |
| 2016-05-13 | AACG | Stock | 5.26 | 5.57 | 5.26 | 5.45 | 2400.0 |
| 2016-05-13 | AAIC-DELISTED | Stock | 12.48 | 12.6 | 12.31 | 12.38 | 194708.0 |
| 2016-05-13 | AAL | Stock | 31.09 | 32.01 | 31.08 | 31.51 | 10132500.0 |
| 2016-05-13 | AAMC-DELISTED | Stock | 3.5912 | 4.0878 | 3.5912 | 3.6794 | 102789.0 |
| 2016-05-13 | AAME | Stock | 3.87 | 3.87 | 3.87 | 3.87 | 100.0 |
| 2016-05-13 | AAMI | Stock | 13.87 | 14.06 | 13.63 | 13.69 | 230700.0 |
| 2016-05-13 | AAOI | Stock | 8.84 | 9.48 | 8.815 | 9.15 | 534700.0 |
| 2016-05-13 | AAON | Stock | 18.16 | 18.9667 | 18.16 | 18.5667 | 234750.0 |
| 2016-05-13 | AAP | Stock | 149.57 | 150.01 | 145.19 | 145.56 | 989300.0 |
| 2016-05-13 | AAT | Stock | 41.26 | 41.34 | 40.79 | 40.93 | 101200.0 |
| 2016-05-13 | AAU-DELISTED | Stock | 1.16 | 1.23 | 1.14 | 1.16 | 153045.0 |
| 2016-05-13 | AAUAF-DELISTED | Stock | 1.16 | 1.23 | 1.12 | 1.12 | 153646.0 |
| 2016-05-13 | AAV-DELISTED | Stock | 5.7 | 5.77 | 5.66 | 5.71 | 34667.0 |
| 2016-05-13 | AAWW-DELISTED | Stock | 44.73 | 45.02 | 43.62 | 44.26 | 327094.0 |
| 2016-05-13 | AAXJ | Stock | 51.55 | 51.75 | 51.115 | 51.21 | 893316.0 |
| 2016-05-13 | AAXN-DELISTED | Stock | 19.64 | 19.72 | 19.31 | 19.37 | 495469.0 |
| 2016-05-13 | AB | Stock | 22.92 | 23.21 | 22.28 | 22.41 | 231700.0 |
| 2016-05-13 | ABAC-DELISTED | Stock | 0.63 | 0.64 | 0.6 | 0.6 | 8995.0 |
| 2016-05-13 | ABAX-DELISTED | Stock | 43.03 | 43.48 | 41.89 | 43.38 | 279098.0 |
| 2016-05-13 | ABB-DELISTED | Stock | 20.32 | 20.47 | 20.125 | 20.195 | 1898656.0 |
| 2016-05-13 | ABBNY-DELISTED | Stock | 20.32 | 20.47 | 20.125 | 20.2 | 1943422.0 |
| 2016-05-13 | ABBV | Stock | 62.15 | 62.86 | 61.82 | 62.0 | 7339600.0 |
| 2016-05-13 | ABC-DELISTED | Stock | 74.71 | 75.07 | 73.54 | 73.64 | 2166011.0 |
| 2016-05-13 | ABCB | Stock | 30.85 | 31.3 | 30.56 | 30.81 | 174900.0 |
| 2016-05-13 | ABCD-DELISTED | Stock | 4.24 | 4.3099 | 4.21 | 4.23 | 25614.0 |
| 2016-05-13 | ABCO-DELISTED | Stock | 33.6 | 33.9 | 33.36 | 33.52 | 292209.0 |
| 2016-05-13 | ABDC-DELISTED | Stock | 11.3101 | 11.89 | 11.3101 | 11.87 | 26196.0 |
| 2016-05-13 | ABE-DELISTED | Stock | 11.9 | 11.9 | 11.83 | 11.83 | 5570.0 |
| 2016-05-13 | ABEO | Stock | 57.0 | 60.0 | 57.0 | 58.75 | 1908.0 |
| 2016-05-13 | ABEV | Stock | 5.44 | 5.47 | 5.27 | 5.28 | 12424200.0 |
| 2016-05-13 | ABG | Stock | 55.25 | 56.33 | 54.3 | 54.57 | 204500.0 |
| 2016-05-13 | ABIL-DELISTED | Stock | 3.13 | 3.2061 | 3.0 | 3.17 | 59010.0 |
| 2016-05-13 | ABM | Stock | 32.99 | 33.14 | 32.72 | 32.99 | 215300.0 |
| 2016-05-13 | ABMD-DELISTED | Stock | 94.0 | 95.39 | 93.52 | 94.07 | 249009.0 |
| 2016-05-13 | ABR | Stock | 7.13 | 7.14 | 7.05 | 7.11 | 95600.0 |
> showing 50 of 6,520 rows — these rows as CSV