PREVIEW / stock_daily / 2016-03-10
file: by_date/stock_daily/2016/2016-03-10.parquet size: 218 KB rows: 6,538 symbols: 3,315
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-03-10 | AAPL | Stock | 25.3525 | 25.56 | 25.0375 | 25.2925 | 134054400.0 |
| 2016-03-10 | MSFT | Stock | 52.93 | 52.94 | 51.16 | 52.05 | 38387800.0 |
| 2016-03-10 | NVDA | Stock | 0.798 | 0.8025 | 0.776 | 0.792 | 286084000.0 |
| 2016-03-10 | AMZN | Stock | 28.337 | 28.35 | 27.395 | 27.9465 | 78398000.0 |
| 2016-03-10 | GOOGL | Stock | 36.3895 | 36.827 | 36.1645 | 36.6085 | 44616220.0 |
| 2016-03-10 | META | Stock | 107.91 | 108.66 | 105.77 | 107.32 | 24854300.0 |
| 2016-03-10 | TSLA | Stock | 14.0 | 14.2193 | 13.378 | 13.6787 | 77887500.0 |
| 2016-03-10 | TLT | Stock | 129.5 | 129.84 | 127.92 | 128.66 | 10092026.0 |
| 2016-03-10 | ES | Stock | 56.92 | 57.25 | 56.07 | 56.5 | 2157900.0 |
| 2016-03-10 | CL | Stock | 68.11 | 68.45 | 67.53 | 68.23 | 2454300.0 |
| 2016-03-10 | A | Stock | 38.17 | 38.51 | 37.62 | 37.98 | 1615000.0 |
| 2016-03-10 | AA.B-DELISTED | Stock | 32.35 | 32.5 | 31.3801 | 32.5 | 15159.0 |
| 2016-03-10 | AAAP-DELISTED | Stock | 34.29 | 35.0 | 32.51 | 34.06 | 110864.0 |
| 2016-03-10 | AABA-DELISTED | Stock | 33.59 | 33.6 | 32.09 | 32.83 | 18434235.0 |
| 2016-03-10 | AAC-DELISTED | Stock | 17.13 | 18.0 | 16.62 | 16.955 | 337551.0 |
| 2016-03-10 | AACG | Stock | 4.89 | 4.93 | 4.66 | 4.93 | 1400.0 |
| 2016-03-10 | AAIC-DELISTED | Stock | 12.93 | 12.98 | 12.49 | 12.6 | 320140.0 |
| 2016-03-10 | AAL | Stock | 42.11 | 42.11 | 40.91 | 41.63 | 5814200.0 |
| 2016-03-10 | AAMC-DELISTED | Stock | 3.9118 | 3.9265 | 3.7678 | 3.8324 | 132913.0 |
| 2016-03-10 | AAMI | Stock | 11.79 | 11.92 | 11.455 | 11.7 | 109000.0 |
| 2016-03-10 | AAOI | Stock | 17.05 | 17.27 | 16.7 | 17.04 | 151100.0 |
| 2016-03-10 | AAON | Stock | 17.0133 | 17.0133 | 16.6733 | 16.7933 | 181350.0 |
| 2016-03-10 | AAP | Stock | 153.8 | 156.29 | 153.54 | 156.15 | 765200.0 |
| 2016-03-10 | AAT | Stock | 37.93 | 38.29 | 37.3 | 37.57 | 145800.0 |
| 2016-03-10 | AAU-DELISTED | Stock | 0.695 | 0.7298 | 0.6745 | 0.7236 | 305624.0 |
| 2016-03-10 | AAUAF-DELISTED | Stock | 0.695 | 0.7298 | 0.6745 | 0.7236 | 310058.0 |
| 2016-03-10 | AAV-DELISTED | Stock | 5.42 | 5.56 | 5.34 | 5.54 | 253271.0 |
| 2016-03-10 | AAVL-DELISTED | Stock | 5.17 | 5.35 | 5.04 | 5.07 | 269842.0 |
| 2016-03-10 | AAWW-DELISTED | Stock | 38.84 | 39.94 | 38.21 | 38.97 | 250916.0 |
| 2016-03-10 | AAXJ | Stock | 52.18 | 52.3 | 51.32 | 51.79 | 1268066.0 |
| 2016-03-10 | AAXN-DELISTED | Stock | 19.68 | 19.91 | 19.16 | 19.33 | 813895.0 |
| 2016-03-10 | AB | Stock | 22.34 | 22.58 | 21.8 | 22.0 | 430300.0 |
| 2016-03-10 | ABAC-DELISTED | Stock | 0.679 | 0.679 | 0.679 | 0.679 | 300.0 |
| 2016-03-10 | ABAX-DELISTED | Stock | 41.75 | 42.155 | 41.19 | 41.84 | 157061.0 |
| 2016-03-10 | ABB-DELISTED | Stock | 18.32 | 18.46 | 18.085 | 18.25 | 2342553.0 |
| 2016-03-10 | ABBNY-DELISTED | Stock | 18.32 | 18.46 | 18.085 | 18.24 | 2440315.0 |
| 2016-03-10 | ABBV | Stock | 56.56 | 57.37 | 55.32 | 56.23 | 5627900.0 |
| 2016-03-10 | ABC-DELISTED | Stock | 88.01 | 88.16 | 85.81 | 86.2 | 3151127.0 |
| 2016-03-10 | ABCB | Stock | 27.74 | 28.09 | 27.5 | 27.94 | 95500.0 |
| 2016-03-10 | ABCD-DELISTED | Stock | 4.48 | 4.48 | 4.265 | 4.38 | 39931.0 |
| 2016-03-10 | ABCO-DELISTED | Stock | 28.79 | 29.42 | 27.96 | 28.66 | 648436.0 |
| 2016-03-10 | ABCW-DELISTED | Stock | 43.16 | 43.47 | 42.94 | 43.29 | 31455.0 |
| 2016-03-10 | ABDC-DELISTED | Stock | 10.3 | 10.4 | 10.22 | 10.3201 | 26725.0 |
| 2016-03-10 | ABE-DELISTED | Stock | 11.0 | 11.11 | 10.99 | 11.11 | 14708.0 |
| 2016-03-10 | ABEO | Stock | 68.25 | 69.0 | 66.5 | 67.75 | 1024.0 |
| 2016-03-10 | ABEV | Stock | 5.02 | 5.12 | 4.92 | 5.1 | 32429700.0 |
| 2016-03-10 | ABG | Stock | 59.2 | 59.51 | 57.8 | 58.77 | 370000.0 |
| 2016-03-10 | ABGB-DELISTED | Stock | 1.49 | 1.58 | 1.42 | 1.5 | 87702.0 |
| 2016-03-10 | ABIL-DELISTED | Stock | 6.6 | 6.67 | 6.2 | 6.48 | 22509.0 |
| 2016-03-10 | ABM | Stock | 31.85 | 31.95 | 30.8 | 31.07 | 524700.0 |
> showing 50 of 6,538 rows — these rows as CSV