PREVIEW / stock_daily / 2015-11-03
file: by_date/stock_daily/2015/2015-11-03.parquet size: 222 KB rows: 6,627 symbols: 3,413
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-03 | AAPL | Stock | 30.1975 | 30.8725 | 30.175 | 30.6425 | 182076000.0 |
| 2015-11-03 | MSFT | Stock | 52.93 | 54.39 | 52.9 | 54.15 | 36596900.0 |
| 2015-11-03 | NVDA | Stock | 0.7133 | 0.7173 | 0.7045 | 0.7125 | 376768000.0 |
| 2015-11-03 | AMZN | Stock | 31.4765 | 31.4945 | 31.1 | 31.2655 | 64938000.0 |
| 2015-11-03 | GOOGL | Stock | 37.2715 | 37.5849 | 37.058 | 37.441 | 36306000.0 |
| 2015-11-03 | META | Stock | 103.22 | 103.65 | 102.4 | 102.58 | 21242300.0 |
| 2015-11-03 | TSLA | Stock | 14.2567 | 14.296 | 13.85 | 13.89 | 124987500.0 |
| 2015-11-03 | TLT | Stock | 121.65 | 121.74 | 120.79 | 120.95 | 8921581.0 |
| 2015-11-03 | ES | Stock | 50.1 | 51.54 | 50.1 | 51.45 | 1557900.0 |
| 2015-11-03 | CL | Stock | 67.24 | 68.11 | 66.9 | 68.0 | 3728100.0 |
| 2015-11-03 | A | Stock | 38.31 | 38.52 | 38.16 | 38.27 | 1485800.0 |
| 2015-11-03 | AA.B-DELISTED | Stock | 32.58 | 33.5 | 32.58 | 33.3 | 26257.0 |
| 2015-11-03 | AABA-DELISTED | Stock | 35.17 | 35.34 | 34.65 | 34.71 | 11467296.0 |
| 2015-11-03 | AAC-DELISTED | Stock | 22.21 | 22.54 | 21.48 | 21.76 | 364233.0 |
| 2015-11-03 | AACG | Stock | 4.25 | 4.47 | 4.21 | 4.38 | 8600.0 |
| 2015-11-03 | AAIC-DELISTED | Stock | 13.98 | 14.32 | 13.98 | 14.25 | 161775.0 |
| 2015-11-03 | AAL | Stock | 47.02 | 47.09 | 46.08 | 46.5 | 6983200.0 |
| 2015-11-03 | AAMC-DELISTED | Stock | 7.6912 | 10.8471 | 7.6191 | 9.9412 | 204694.0 |
| 2015-11-03 | AAME | Stock | 4.79 | 4.9 | 4.72 | 4.74 | 12900.0 |
| 2015-11-03 | AAMI | Stock | 15.85 | 16.23 | 15.52 | 16.21 | 197000.0 |
| 2015-11-03 | AAOI | Stock | 20.39 | 20.91 | 20.13 | 20.43 | 312200.0 |
| 2015-11-03 | AAON | Stock | 14.3 | 15.32 | 14.16 | 15.1467 | 400050.0 |
| 2015-11-03 | AAP | Stock | 200.15 | 200.64 | 196.64 | 198.7 | 674100.0 |
| 2015-11-03 | AAT | Stock | 42.52 | 42.64 | 42.1 | 42.18 | 179400.0 |
| 2015-11-03 | AAU-DELISTED | Stock | 0.5813 | 0.5822 | 0.55 | 0.57 | 221992.0 |
| 2015-11-03 | AAUAF-DELISTED | Stock | 0.5813 | 0.5822 | 0.55 | 0.58 | 224665.0 |
| 2015-11-03 | AAV-DELISTED | Stock | 5.58 | 5.93 | 5.58 | 5.89 | 108610.0 |
| 2015-11-03 | AAVL-DELISTED | Stock | 9.05 | 9.3898 | 8.95 | 9.26 | 410661.0 |
| 2015-11-03 | AAWW-DELISTED | Stock | 42.64 | 43.03 | 41.73 | 42.44 | 274890.0 |
| 2015-11-03 | AAXJ | Stock | 57.13 | 58.0 | 57.13 | 57.79 | 767510.0 |
| 2015-11-03 | AAXN-DELISTED | Stock | 23.0 | 23.0 | 20.25 | 20.91 | 9058245.0 |
| 2015-11-03 | AB | Stock | 25.61 | 25.86 | 25.33 | 25.53 | 253800.0 |
| 2015-11-03 | ABAC-DELISTED | Stock | 0.65 | 0.65 | 0.648 | 0.648 | 2500.0 |
| 2015-11-03 | ABAX-DELISTED | Stock | 51.2 | 52.33 | 50.746 | 51.55 | 145365.0 |
| 2015-11-03 | ABB-DELISTED | Stock | 18.99 | 19.14 | 18.93 | 19.05 | 1102883.0 |
| 2015-11-03 | ABBNY-DELISTED | Stock | 18.99 | 19.14 | 18.93 | 19.05 | 1151323.0 |
| 2015-11-03 | ABBV | Stock | 63.12 | 63.72 | 61.92 | 62.43 | 8754700.0 |
| 2015-11-03 | ABC-DELISTED | Stock | 97.44 | 98.17 | 96.77 | 97.66 | 1474251.0 |
| 2015-11-03 | ABCB | Stock | 31.23 | 31.39 | 31.01 | 31.29 | 419200.0 |
| 2015-11-03 | ABCD-DELISTED | Stock | 5.05 | 5.16 | 4.94 | 5.16 | 34412.0 |
| 2015-11-03 | ABCO-DELISTED | Stock | 43.53 | 43.97 | 42.88 | 43.44 | 328416.0 |
| 2015-11-03 | ABCW-DELISTED | Stock | 42.04 | 42.04 | 41.36 | 41.87 | 23105.0 |
| 2015-11-03 | ABDC-DELISTED | Stock | 12.06 | 12.2499 | 11.8 | 11.9 | 37461.0 |
| 2015-11-03 | ABE-DELISTED | Stock | 11.39 | 11.69 | 11.39 | 11.6401 | 7278.0 |
| 2015-11-03 | ABEO | Stock | 103.25 | 113.0 | 102.75 | 109.5 | 5944.0 |
| 2015-11-03 | ABEOW-DELISTED | Stock | 1.41 | 1.66 | 1.41 | 1.66 | 9540.0 |
| 2015-11-03 | ABEV | Stock | 4.98 | 5.19 | 4.98 | 5.17 | 19666900.0 |
| 2015-11-03 | ABG | Stock | 80.0 | 80.91 | 79.2 | 80.82 | 311800.0 |
| 2015-11-03 | ABGB-DELISTED | Stock | 5.43 | 5.49 | 5.41 | 5.49 | 11461.0 |
| 2015-11-03 | ABIL-DELISTED | Stock | 10.0 | 10.0 | 10.0 | 10.0 | 100.0 |
> showing 50 of 6,627 rows — these rows as CSV