PREVIEW / stock_daily / 2015-09-30
file: by_date/stock_daily/2015/2015-09-30.parquet size: 221 KB rows: 6,658 symbols: 3,455
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-09-30 | AAPL | Stock | 27.5425 | 27.885 | 27.1825 | 27.575 | 265892000.0 |
| 2015-09-30 | MSFT | Stock | 43.88 | 44.3 | 43.66 | 44.26 | 34958900.0 |
| 2015-09-30 | NVDA | Stock | 0.5983 | 0.617 | 0.5948 | 0.6162 | 556380000.0 |
| 2015-09-30 | AMZN | Stock | 25.272 | 25.64 | 25.0835 | 25.5945 | 80094000.0 |
| 2015-09-30 | GOOGL | Stock | 31.5915 | 31.9655 | 31.4575 | 31.9185 | 52953100.0 |
| 2015-09-30 | META | Stock | 88.44 | 90.02 | 88.01 | 89.9 | 36169100.0 |
| 2015-09-30 | TSLA | Stock | 16.8 | 16.8267 | 16.156 | 16.56 | 73944000.0 |
| 2015-09-30 | TLT | Stock | 123.41 | 123.8 | 123.12 | 123.54 | 9832571.0 |
| 2015-09-30 | ES | Stock | 49.26 | 50.66 | 49.11 | 50.62 | 2556300.0 |
| 2015-09-30 | CL | Stock | 63.66 | 63.99 | 63.09 | 63.46 | 3529400.0 |
| 2015-09-30 | A | Stock | 34.08 | 34.43 | 33.67 | 34.33 | 2545700.0 |
| 2015-09-30 | AA.B-DELISTED | Stock | 34.0 | 34.0 | 33.22 | 33.73 | 39999.0 |
| 2015-09-30 | AABA-DELISTED | Stock | 28.63 | 29.11 | 28.49 | 28.9 | 16947043.0 |
| 2015-09-30 | AAC-DELISTED | Stock | 23.52 | 24.14 | 22.1 | 22.25 | 364808.0 |
| 2015-09-30 | AACG | Stock | 2.75 | 2.79 | 2.52 | 2.52 | 11200.0 |
| 2015-09-30 | AAIC-DELISTED | Stock | 14.09 | 14.09 | 13.71 | 14.05 | 466762.0 |
| 2015-09-30 | AAL | Stock | 39.18 | 39.68 | 37.72 | 38.83 | 15823700.0 |
| 2015-09-30 | AAMC-DELISTED | Stock | 7.0588 | 7.0588 | 6.7059 | 7.0441 | 37070.0 |
| 2015-09-30 | AAME | Stock | 4.04 | 4.05 | 4.01 | 4.04 | 4600.0 |
| 2015-09-30 | AAMI | Stock | 15.19 | 15.7 | 14.99 | 15.42 | 283000.0 |
| 2015-09-30 | AAOI | Stock | 17.1 | 18.92 | 16.89 | 18.78 | 468700.0 |
| 2015-09-30 | AAON | Stock | 12.8867 | 12.9933 | 12.7733 | 12.92 | 152700.0 |
| 2015-09-30 | AAP | Stock | 183.49 | 192.5 | 183.48 | 189.53 | 4119700.0 |
| 2015-09-30 | AAT | Stock | 41.02 | 41.31 | 40.52 | 40.86 | 486200.0 |
| 2015-09-30 | AAU-DELISTED | Stock | 0.565 | 0.6007 | 0.5638 | 0.5758 | 25089.0 |
| 2015-09-30 | AAUAF-DELISTED | Stock | 0.565 | 0.6007 | 0.5638 | 0.5758 | 25909.0 |
| 2015-09-30 | AAV-DELISTED | Stock | 5.17 | 5.25 | 5.08 | 5.22 | 141705.0 |
| 2015-09-30 | AAVL-DELISTED | Stock | 8.2 | 8.43 | 7.86 | 8.25 | 570639.0 |
| 2015-09-30 | AAWW-DELISTED | Stock | 34.48 | 34.97 | 34.14 | 34.56 | 207559.0 |
| 2015-09-30 | AAXJ | Stock | 52.44 | 52.81 | 52.275 | 52.75 | 1191644.0 |
| 2015-09-30 | AAXN-DELISTED | Stock | 21.89 | 22.23 | 21.605 | 22.02 | 1250760.0 |
| 2015-09-30 | AB | Stock | 26.22 | 26.84 | 26.12 | 26.6 | 180300.0 |
| 2015-09-30 | ABAC-DELISTED | Stock | 0.5549 | 0.5549 | 0.48 | 0.54 | 31866.0 |
| 2015-09-30 | ABAX-DELISTED | Stock | 43.24 | 44.43 | 43.24 | 43.99 | 188063.0 |
| 2015-09-30 | ABB-DELISTED | Stock | 17.67 | 17.74 | 17.51 | 17.67 | 1498635.0 |
| 2015-09-30 | ABBNY-DELISTED | Stock | 17.67 | 17.74 | 17.51 | 17.67 | 1755544.0 |
| 2015-09-30 | ABBV | Stock | 53.54 | 54.5 | 53.36 | 54.41 | 11895500.0 |
| 2015-09-30 | ABC-DELISTED | Stock | 96.08 | 96.68 | 94.07 | 94.99 | 1971112.0 |
| 2015-09-30 | ABCB | Stock | 28.62 | 28.82 | 28.39 | 28.75 | 331100.0 |
| 2015-09-30 | ABCD-DELISTED | Stock | 4.59 | 4.83 | 4.56 | 4.81 | 59359.0 |
| 2015-09-30 | ABCO-DELISTED | Stock | 45.5 | 45.89 | 44.06 | 45.54 | 513226.0 |
| 2015-09-30 | ABCW-DELISTED | Stock | 42.0 | 42.99 | 40.97 | 42.555 | 73424.0 |
| 2015-09-30 | ABDC-DELISTED | Stock | 11.75 | 12.27 | 11.41 | 11.59 | 136615.0 |
| 2015-09-30 | ABE-DELISTED | Stock | 10.63 | 10.78 | 10.62 | 10.71 | 10550.0 |
| 2015-09-30 | ABEO | Stock | 101.0 | 108.0 | 96.25 | 101.25 | 4632.0 |
| 2015-09-30 | ABEOW-DELISTED | Stock | 1.48 | 1.48 | 1.48 | 1.48 | 100.0 |
| 2015-09-30 | ABEV | Stock | 4.92 | 4.95 | 4.85 | 4.9 | 15789500.0 |
| 2015-09-30 | ABG | Stock | 80.91 | 83.83 | 79.29 | 81.15 | 424200.0 |
| 2015-09-30 | ABGB-DELISTED | Stock | 4.66 | 4.69 | 4.51 | 4.56 | 16065.0 |
| 2015-09-30 | ABM | Stock | 27.89 | 27.95 | 26.95 | 27.31 | 990700.0 |
> showing 50 of 6,658 rows — these rows as CSV