PREVIEW / stock_daily / 2015-12-07
file: by_date/stock_daily/2015/2015-12-07.parquet size: 222 KB rows: 6,643 symbols: 3,414
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-12-07 | AAPL | Stock | 29.745 | 29.965 | 29.4525 | 29.57 | 128336800.0 |
| 2015-12-07 | MSFT | Stock | 55.79 | 55.97 | 55.29 | 55.81 | 30709800.0 |
| 2015-12-07 | NVDA | Stock | 0.8435 | 0.8435 | 0.8252 | 0.8278 | 333588000.0 |
| 2015-12-07 | AMZN | Stock | 33.737 | 33.773 | 33.025 | 33.4915 | 74656000.0 |
| 2015-12-07 | GOOGL | Stock | 39.003 | 39.05 | 38.336 | 38.6495 | 36625740.0 |
| 2015-12-07 | META | Stock | 106.48 | 106.83 | 104.66 | 105.61 | 15474900.0 |
| 2015-12-07 | TSLA | Stock | 15.18 | 15.7087 | 15.0767 | 15.4087 | 47163000.0 |
| 2015-12-07 | TLT | Stock | 120.81 | 122.46 | 120.8 | 121.75 | 9016691.0 |
| 2015-12-07 | ES | Stock | 50.42 | 51.2 | 50.3 | 51.18 | 1915200.0 |
| 2015-12-07 | CL | Stock | 66.39 | 66.56 | 66.09 | 66.34 | 3895600.0 |
| 2015-12-07 | A | Stock | 40.92 | 41.1 | 40.54 | 40.7 | 2004500.0 |
| 2015-12-07 | AA.B-DELISTED | Stock | 32.45 | 32.46 | 31.07 | 31.23 | 42552.0 |
| 2015-12-07 | AAAP-DELISTED | Stock | 26.43 | 30.305 | 26.43 | 28.82 | 71777.0 |
| 2015-12-07 | AABA-DELISTED | Stock | 34.76 | 34.92 | 34.47 | 34.68 | 11413343.0 |
| 2015-12-07 | AAC-DELISTED | Stock | 22.37 | 22.895 | 21.02 | 21.63 | 160643.0 |
| 2015-12-07 | AACG | Stock | 5.6 | 5.77 | 5.6 | 5.61 | 26000.0 |
| 2015-12-07 | AAIC-DELISTED | Stock | 13.45 | 13.59 | 13.098 | 13.21 | 357464.0 |
| 2015-12-07 | AAL | Stock | 45.35 | 46.49 | 45.22 | 45.78 | 8911700.0 |
| 2015-12-07 | AAMC-DELISTED | Stock | 4.3235 | 4.3235 | 3.6618 | 4.0824 | 240319.0 |
| 2015-12-07 | AAME | Stock | 4.73 | 4.78 | 4.66 | 4.77 | 2600.0 |
| 2015-12-07 | AAMI | Stock | 15.74 | 15.74 | 15.4 | 15.57 | 110300.0 |
| 2015-12-07 | AAOI | Stock | 17.97 | 17.97 | 17.33 | 17.43 | 224700.0 |
| 2015-12-07 | AAON | Stock | 16.3067 | 16.3067 | 15.8933 | 16.04 | 194250.0 |
| 2015-12-07 | AAP | Stock | 155.68 | 156.9 | 150.62 | 151.22 | 1358500.0 |
| 2015-12-07 | AAT | Stock | 38.81 | 39.09 | 38.77 | 39.0 | 120600.0 |
| 2015-12-07 | AAU-DELISTED | Stock | 0.55 | 0.5551 | 0.53 | 0.53 | 44970.0 |
| 2015-12-07 | AAUAF-DELISTED | Stock | 0.55 | 0.5551 | 0.53 | 0.53 | 46352.0 |
| 2015-12-07 | AAV-DELISTED | Stock | 4.69 | 4.75 | 4.4 | 4.44 | 128213.0 |
| 2015-12-07 | AAVL-DELISTED | Stock | 9.38 | 9.38 | 8.8199 | 8.94 | 174683.0 |
| 2015-12-07 | AAWW-DELISTED | Stock | 41.18 | 41.98 | 39.3 | 39.38 | 180259.0 |
| 2015-12-07 | AAXJ | Stock | 55.18 | 55.18 | 54.72 | 54.92 | 878407.0 |
| 2015-12-07 | AAXN-DELISTED | Stock | 17.88 | 17.92 | 16.98 | 17.26 | 1360150.0 |
| 2015-12-07 | AB | Stock | 24.28 | 24.57 | 23.68 | 23.85 | 213100.0 |
| 2015-12-07 | ABAC-DELISTED | Stock | 1.21 | 1.21 | 0.85 | 1.14 | 34270.0 |
| 2015-12-07 | ABAX-DELISTED | Stock | 54.15 | 54.51 | 53.86 | 54.25 | 71545.0 |
| 2015-12-07 | ABB-DELISTED | Stock | 18.59 | 18.59 | 18.4301 | 18.5 | 1868356.0 |
| 2015-12-07 | ABBNY-DELISTED | Stock | 18.59 | 18.59 | 18.4301 | 18.49 | 1911303.0 |
| 2015-12-07 | ABBV | Stock | 57.9 | 57.99 | 55.76 | 56.27 | 7890900.0 |
| 2015-12-07 | ABC-DELISTED | Stock | 99.92 | 100.4 | 99.34 | 99.97 | 1136041.0 |
| 2015-12-07 | ABCB | Stock | 34.9 | 34.99 | 34.55 | 34.84 | 235900.0 |
| 2015-12-07 | ABCD-DELISTED | Stock | 5.15 | 5.15 | 5.04 | 5.06 | 44702.0 |
| 2015-12-07 | ABCO-DELISTED | Stock | 53.03 | 53.03 | 50.9 | 51.43 | 177662.0 |
| 2015-12-07 | ABCW-DELISTED | Stock | 43.9 | 44.67 | 42.63 | 43.05 | 49672.0 |
| 2015-12-07 | ABDC-DELISTED | Stock | 12.12 | 12.26 | 12.0 | 12.2 | 29305.0 |
| 2015-12-07 | ABE-DELISTED | Stock | 11.1 | 11.1399 | 11.0346 | 11.0445 | 9558.0 |
| 2015-12-07 | ABEO | Stock | 100.5 | 101.25 | 90.0 | 91.75 | 5752.0 |
| 2015-12-07 | ABEOW-DELISTED | Stock | 1.32 | 1.35 | 1.32 | 1.35 | 1380.0 |
| 2015-12-07 | ABEV | Stock | 4.96 | 4.98 | 4.85 | 4.88 | 14466300.0 |
| 2015-12-07 | ABG | Stock | 73.5 | 73.91 | 72.43 | 73.17 | 261200.0 |
| 2015-12-07 | ABGB-DELISTED | Stock | 2.07 | 2.07 | 1.94 | 2.03 | 71220.0 |
> showing 50 of 6,643 rows — these rows as CSV