PREVIEW / stock_daily / 2015-09-15
file: by_date/stock_daily/2015/2015-09-15.parquet size: 221 KB rows: 6,645 symbols: 3,454
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-15 | AAPL | Stock | 28.9825 | 29.1325 | 28.605 | 29.07 | 173364800.0 |
| 2015-09-15 | MSFT | Stock | 43.19 | 44.29 | 43.08 | 43.98 | 28882200.0 |
| 2015-09-15 | NVDA | Stock | 0.5675 | 0.5765 | 0.5658 | 0.5735 | 327976000.0 |
| 2015-09-15 | AMZN | Stock | 26.1625 | 26.396 | 25.86 | 26.1185 | 57318000.0 |
| 2015-09-15 | GOOGL | Stock | 32.8355 | 33.4425 | 32.667 | 33.2535 | 35546400.0 |
| 2015-09-15 | META | Stock | 92.37 | 93.25 | 91.79 | 92.9 | 18859400.0 |
| 2015-09-15 | TSLA | Stock | 16.85 | 16.9733 | 16.6333 | 16.9047 | 44002500.0 |
| 2015-09-15 | TLT | Stock | 120.89 | 121.0499 | 119.12 | 119.25 | 11894974.0 |
| 2015-09-15 | ES | Stock | 46.35 | 46.82 | 46.07 | 46.7 | 1764600.0 |
| 2015-09-15 | CL | Stock | 62.07 | 62.64 | 61.37 | 62.43 | 3467400.0 |
| 2015-09-15 | A | Stock | 35.75 | 36.3 | 35.51 | 36.15 | 1752700.0 |
| 2015-09-15 | AA.B-DELISTED | Stock | 34.1 | 35.11 | 34.1 | 35.0 | 12798.0 |
| 2015-09-15 | AABA-DELISTED | Stock | 29.68 | 31.225 | 29.41 | 31.04 | 24403639.0 |
| 2015-09-15 | AAC-DELISTED | Stock | 23.47 | 23.49 | 22.53 | 22.55 | 136662.0 |
| 2015-09-15 | AACG | Stock | 2.45 | 2.45 | 2.29 | 2.35 | 20800.0 |
| 2015-09-15 | AAIC-DELISTED | Stock | 15.91 | 16.07 | 15.7 | 15.77 | 262744.0 |
| 2015-09-15 | AAL | Stock | 42.36 | 42.85 | 41.89 | 42.64 | 7008300.0 |
| 2015-09-15 | AAMC-DELISTED | Stock | 7.5147 | 8.8266 | 7.5147 | 8.1206 | 62625.0 |
| 2015-09-15 | AAME | Stock | 3.51 | 3.57 | 3.41 | 3.45 | 8100.0 |
| 2015-09-15 | AAMI | Stock | 16.26 | 16.5 | 16.26 | 16.4 | 253700.0 |
| 2015-09-15 | AAOI | Stock | 18.86 | 19.13 | 18.64 | 19.01 | 352500.0 |
| 2015-09-15 | AAON | Stock | 13.3267 | 13.66 | 13.2933 | 13.5467 | 177300.0 |
| 2015-09-15 | AAP | Stock | 175.03 | 177.84 | 173.35 | 176.85 | 822500.0 |
| 2015-09-15 | AAT | Stock | 38.89 | 39.15 | 38.66 | 39.03 | 127800.0 |
| 2015-09-15 | AAU-DELISTED | Stock | 0.4825 | 0.53 | 0.4825 | 0.51 | 34674.0 |
| 2015-09-15 | AAUAF-DELISTED | Stock | 0.4825 | 0.53 | 0.4825 | 0.51 | 35165.0 |
| 2015-09-15 | AAV-DELISTED | Stock | 5.34 | 5.46 | 5.29 | 5.33 | 111198.0 |
| 2015-09-15 | AAVL-DELISTED | Stock | 10.59 | 10.95 | 10.48 | 10.74 | 325652.0 |
| 2015-09-15 | AAWW-DELISTED | Stock | 38.67 | 40.21 | 38.67 | 40.0 | 164965.0 |
| 2015-09-15 | AAXJ | Stock | 53.27 | 53.95 | 53.26 | 53.81 | 1374473.0 |
| 2015-09-15 | AAXN-DELISTED | Stock | 23.97 | 24.32 | 23.35 | 24.12 | 679630.0 |
| 2015-09-15 | AB | Stock | 26.85 | 27.54 | 26.55 | 27.3 | 192500.0 |
| 2015-09-15 | ABAC-DELISTED | Stock | 0.71 | 0.71 | 0.6801 | 0.6801 | 2300.0 |
| 2015-09-15 | ABAX-DELISTED | Stock | 48.64 | 49.13 | 48.17 | 49.0 | 59960.0 |
| 2015-09-15 | ABB-DELISTED | Stock | 18.47 | 18.65 | 18.43 | 18.63 | 1745852.0 |
| 2015-09-15 | ABBNY-DELISTED | Stock | 18.47 | 18.65 | 18.43 | 18.62 | 1935844.0 |
| 2015-09-15 | ABBV | Stock | 58.98 | 59.44 | 58.37 | 59.2 | 10474700.0 |
| 2015-09-15 | ABC-DELISTED | Stock | 104.72 | 105.81 | 104.21 | 105.56 | 1234913.0 |
| 2015-09-15 | ABCB | Stock | 28.26 | 28.58 | 28.08 | 28.51 | 153300.0 |
| 2015-09-15 | ABCD-DELISTED | Stock | 4.91 | 5.0 | 4.89 | 4.94 | 24927.0 |
| 2015-09-15 | ABCO-DELISTED | Stock | 48.28 | 48.68 | 48.14 | 48.34 | 113834.0 |
| 2015-09-15 | ABCW-DELISTED | Stock | 42.06 | 42.06 | 40.5 | 40.85 | 58222.0 |
| 2015-09-15 | ABDC-DELISTED | Stock | 12.76 | 13.2 | 12.69 | 12.815 | 17222.0 |
| 2015-09-15 | ABE-DELISTED | Stock | 11.02 | 11.161 | 11.02 | 11.1507 | 15925.0 |
| 2015-09-15 | ABEO | Stock | 131.0 | 132.5 | 126.75 | 129.75 | 3012.0 |
| 2015-09-15 | ABEV | Stock | 4.89 | 4.94 | 4.86 | 4.9 | 17552700.0 |
| 2015-09-15 | ABG | Stock | 81.21 | 82.7 | 80.88 | 82.31 | 112900.0 |
| 2015-09-15 | ABGB-DELISTED | Stock | 5.77 | 5.84 | 5.56 | 5.69 | 307227.0 |
| 2015-09-15 | ABM | Stock | 29.64 | 30.0 | 29.56 | 29.9 | 381600.0 |
| 2015-09-15 | ABMD-DELISTED | Stock | 96.68 | 101.2002 | 96.01 | 100.29 | 552759.0 |
> showing 50 of 6,645 rows — these rows as CSV