PREVIEW / stock_daily / 2015-10-07
file: by_date/stock_daily/2015/2015-10-07.parquet size: 222 KB rows: 6,651 symbols: 3,428
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-10-07 | AAPL | Stock | 27.935 | 27.9425 | 27.3525 | 27.695 | 187062400.0 |
| 2015-10-07 | MSFT | Stock | 47.1 | 47.35 | 45.95 | 46.8 | 27711500.0 |
| 2015-10-07 | NVDA | Stock | 0.6452 | 0.657 | 0.6348 | 0.6505 | 310152000.0 |
| 2015-10-07 | AMZN | Stock | 27.0895 | 27.1 | 26.45 | 27.097 | 76242000.0 |
| 2015-10-07 | GOOGL | Stock | 33.87 | 33.937 | 32.9055 | 33.5 | 44353440.0 |
| 2015-10-07 | META | Stock | 93.11 | 93.66 | 91.37 | 92.4 | 24129300.0 |
| 2015-10-07 | TSLA | Stock | 15.7753 | 15.8467 | 15.2747 | 15.464 | 102210000.0 |
| 2015-10-07 | TLT | Stock | 122.81 | 123.33 | 122.51 | 122.99 | 6712790.0 |
| 2015-10-07 | ES | Stock | 50.76 | 50.84 | 50.29 | 50.42 | 1487500.0 |
| 2015-10-07 | CL | Stock | 65.05 | 65.48 | 64.8 | 65.35 | 2278100.0 |
| 2015-10-07 | A | Stock | 35.2 | 35.78 | 35.1 | 35.54 | 3085400.0 |
| 2015-10-07 | AA.B-DELISTED | Stock | 37.3 | 37.69 | 36.58 | 37.09 | 93665.0 |
| 2015-10-07 | AABA-DELISTED | Stock | 31.28 | 31.99 | 31.21 | 31.88 | 11434333.0 |
| 2015-10-07 | AAC-DELISTED | Stock | 27.34 | 27.34 | 26.52 | 26.8 | 272730.0 |
| 2015-10-07 | AACG | Stock | 3.14 | 3.15 | 2.77 | 3.07 | 27300.0 |
| 2015-10-07 | AAIC-DELISTED | Stock | 14.7 | 15.25 | 14.7 | 15.25 | 289395.0 |
| 2015-10-07 | AAL | Stock | 38.41 | 39.41 | 37.76 | 39.31 | 10513700.0 |
| 2015-10-07 | AAMC-DELISTED | Stock | 7.6618 | 8.4118 | 7.6441 | 8.2353 | 65858.0 |
| 2015-10-07 | AAME | Stock | 4.09 | 4.09 | 3.98 | 3.98 | 3500.0 |
| 2015-10-07 | AAMI | Stock | 14.9 | 15.33 | 14.88 | 15.22 | 153600.0 |
| 2015-10-07 | AAOI | Stock | 19.29 | 19.83 | 18.86 | 19.81 | 203900.0 |
| 2015-10-07 | AAON | Stock | 13.4067 | 13.7667 | 13.4067 | 13.7533 | 108000.0 |
| 2015-10-07 | AAP | Stock | 191.4 | 192.18 | 188.91 | 190.35 | 990200.0 |
| 2015-10-07 | AAT | Stock | 41.46 | 41.96 | 41.37 | 41.96 | 339900.0 |
| 2015-10-07 | AAU-DELISTED | Stock | 0.57 | 0.5806 | 0.5502 | 0.57 | 46000.0 |
| 2015-10-07 | AAUAF-DELISTED | Stock | 0.57 | 0.5806 | 0.5502 | 0.57 | 46493.0 |
| 2015-10-07 | AAV-DELISTED | Stock | 6.19 | 6.37 | 6.12 | 6.18 | 231218.0 |
| 2015-10-07 | AAVL-DELISTED | Stock | 8.51 | 8.9 | 8.37 | 8.65 | 333810.0 |
| 2015-10-07 | AAWW-DELISTED | Stock | 39.36 | 40.69 | 39.36 | 40.3 | 339590.0 |
| 2015-10-07 | AAXJ | Stock | 56.39 | 56.87 | 56.19 | 56.57 | 1039326.0 |
| 2015-10-07 | AAXN-DELISTED | Stock | 24.24 | 25.73 | 24.1288 | 25.66 | 2371061.0 |
| 2015-10-07 | AB | Stock | 26.36 | 27.13 | 26.36 | 26.77 | 187200.0 |
| 2015-10-07 | ABAC-DELISTED | Stock | 0.5 | 0.55 | 0.5 | 0.5299 | 15129.0 |
| 2015-10-07 | ABAX-DELISTED | Stock | 44.65 | 45.13 | 43.76 | 44.99 | 136540.0 |
| 2015-10-07 | ABB-DELISTED | Stock | 18.53 | 18.62 | 18.31 | 18.43 | 1840522.0 |
| 2015-10-07 | ABBNY-DELISTED | Stock | 18.53 | 18.62 | 18.31 | 18.45 | 1890145.0 |
| 2015-10-07 | ABBV | Stock | 54.85 | 56.55 | 53.91 | 55.63 | 11056100.0 |
| 2015-10-07 | ABC-DELISTED | Stock | 93.35 | 93.73 | 92.26 | 92.95 | 2240494.0 |
| 2015-10-07 | ABCB | Stock | 28.14 | 28.47 | 27.99 | 28.44 | 112800.0 |
| 2015-10-07 | ABCD-DELISTED | Stock | 4.77 | 4.94 | 4.77 | 4.84 | 47058.0 |
| 2015-10-07 | ABCO-DELISTED | Stock | 40.93 | 43.25 | 40.7 | 43.22 | 412067.0 |
| 2015-10-07 | ABCW-DELISTED | Stock | 41.11 | 42.275 | 40.48 | 42.0 | 50724.0 |
| 2015-10-07 | ABDC-DELISTED | Stock | 11.9 | 12.8802 | 11.89 | 12.02 | 25847.0 |
| 2015-10-07 | ABE-DELISTED | Stock | 11.26 | 11.42 | 11.2301 | 11.42 | 4724.0 |
| 2015-10-07 | ABEO | Stock | 100.5 | 104.75 | 98.5 | 103.75 | 5024.0 |
| 2015-10-07 | ABEV | Stock | 5.21 | 5.27 | 5.11 | 5.15 | 14148100.0 |
| 2015-10-07 | ABG | Stock | 84.21 | 84.64 | 82.89 | 84.0 | 184300.0 |
| 2015-10-07 | ABGB-DELISTED | Stock | 5.0989 | 5.0989 | 4.9593 | 5.0101 | 12665.0 |
| 2015-10-07 | ABIL-DELISTED | Stock | 10.0299 | 10.0299 | 10.0299 | 10.0299 | 175.0 |
| 2015-10-07 | ABM | Stock | 28.13 | 28.56 | 28.07 | 28.33 | 612100.0 |
> showing 50 of 6,651 rows — these rows as CSV