PREVIEW / stock_daily / 2015-06-16
file: by_date/stock_daily/2015/2015-06-16.parquet size: 224 KB rows: 6,664 symbols: 3,506
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-06-16 | AAPL | Stock | 31.7575 | 31.9625 | 31.5925 | 31.9 | 125976400.0 |
| 2015-06-16 | MSFT | Stock | 45.35 | 46.24 | 45.3 | 45.83 | 27070300.0 |
| 2015-06-16 | NVDA | Stock | 0.5258 | 0.534 | 0.5205 | 0.5332 | 256892000.0 |
| 2015-06-16 | AMZN | Stock | 21.2075 | 21.3985 | 21.1335 | 21.363 | 45928000.0 |
| 2015-06-16 | GOOGL | Stock | 27.224 | 27.3345 | 27.0786 | 27.2435 | 32526980.0 |
| 2015-06-16 | META | Stock | 80.82 | 81.51 | 80.45 | 81.06 | 13693700.0 |
| 2015-06-16 | TSLA | Stock | 16.6753 | 16.896 | 16.6067 | 16.8747 | 29770500.0 |
| 2015-06-16 | TLT | Stock | 118.61 | 119.08 | 117.94 | 119.07 | 7046378.0 |
| 2015-06-16 | ES | Stock | 45.95 | 46.71 | 45.73 | 46.68 | 1431900.0 |
| 2015-06-16 | CL | Stock | 65.17 | 66.08 | 65.17 | 65.98 | 2204600.0 |
| 2015-06-16 | A | Stock | 39.59 | 39.81 | 39.38 | 39.79 | 1422600.0 |
| 2015-06-16 | AA.B-DELISTED | Stock | 43.45 | 43.45 | 42.65 | 43.15 | 36081.0 |
| 2015-06-16 | AABA-DELISTED | Stock | 40.35 | 41.4 | 40.02 | 40.64 | 19765238.0 |
| 2015-06-16 | AAC-DELISTED | Stock | 42.53 | 43.5 | 41.98 | 43.47 | 131351.0 |
| 2015-06-16 | AACG | Stock | 5.7 | 5.88 | 5.65 | 5.88 | 31500.0 |
| 2015-06-16 | AAIC-DELISTED | Stock | 20.69 | 20.72 | 20.53 | 20.72 | 278665.0 |
| 2015-06-16 | AAL | Stock | 40.13 | 40.32 | 39.32 | 39.48 | 9212100.0 |
| 2015-06-16 | AAMC-DELISTED | Stock | 46.1765 | 47.5294 | 44.1684 | 44.9441 | 36139.0 |
| 2015-06-16 | AAME | Stock | 3.6 | 3.76 | 3.6 | 3.65 | 8600.0 |
| 2015-06-16 | AAMI | Stock | 18.07 | 18.07 | 17.36 | 17.91 | 779900.0 |
| 2015-06-16 | AAOI | Stock | 19.03 | 19.25 | 18.55 | 18.86 | 170100.0 |
| 2015-06-16 | AAON | Stock | 15.6867 | 15.88 | 15.64 | 15.7067 | 164400.0 |
| 2015-06-16 | AAP | Stock | 158.41 | 159.59 | 157.87 | 159.05 | 524100.0 |
| 2015-06-16 | AAT | Stock | 39.39 | 39.88 | 39.38 | 39.64 | 463100.0 |
| 2015-06-16 | AAU-DELISTED | Stock | 0.8885 | 0.91 | 0.88 | 0.91 | 56203.0 |
| 2015-06-16 | AAUAF-DELISTED | Stock | 0.8885 | 0.91 | 0.88 | 0.91 | 56893.0 |
| 2015-06-16 | AAV-DELISTED | Stock | 6.37 | 6.42 | 6.2001 | 6.26 | 48757.0 |
| 2015-06-16 | AAVL-DELISTED | Stock | 19.22 | 21.0 | 17.01 | 17.03 | 9859842.0 |
| 2015-06-16 | AAWW-DELISTED | Stock | 54.34 | 54.78 | 53.64 | 53.74 | 242884.0 |
| 2015-06-16 | AAXJ | Stock | 63.27 | 63.59 | 63.26 | 63.46 | 2209648.0 |
| 2015-06-16 | AAXN-DELISTED | Stock | 34.79 | 35.22 | 34.42 | 34.6 | 1243489.0 |
| 2015-06-16 | AB | Stock | 30.59 | 31.15 | 30.59 | 31.0 | 199900.0 |
| 2015-06-16 | ABAC-DELISTED | Stock | 1.413 | 1.48 | 1.41 | 1.4201 | 10415.0 |
| 2015-06-16 | ABAX-DELISTED | Stock | 51.0 | 51.76 | 51.0 | 51.54 | 143069.0 |
| 2015-06-16 | ABB-DELISTED | Stock | 22.6 | 22.65 | 22.47 | 22.6 | 1871218.0 |
| 2015-06-16 | ABBNY-DELISTED | Stock | 22.6 | 22.65 | 22.47 | 22.59 | 1960094.0 |
| 2015-06-16 | ABBV | Stock | 66.72 | 67.4 | 66.62 | 66.77 | 5200700.0 |
| 2015-06-16 | ABC-DELISTED | Stock | 110.68 | 112.09 | 110.17 | 111.16 | 1483231.0 |
| 2015-06-16 | ABCB | Stock | 25.85 | 26.15 | 25.78 | 26.13 | 87800.0 |
| 2015-06-16 | ABCD-DELISTED | Stock | 4.26 | 4.27 | 4.12 | 4.21 | 50676.0 |
| 2015-06-16 | ABCO-DELISTED | Stock | 52.18 | 52.99 | 51.83 | 52.85 | 120437.0 |
| 2015-06-16 | ABCW-DELISTED | Stock | 37.0 | 37.05 | 36.97 | 36.98 | 40537.0 |
| 2015-06-16 | ABDC-DELISTED | Stock | 13.69 | 13.88 | 13.68 | 13.72 | 25311.0 |
| 2015-06-16 | ABE-DELISTED | Stock | 12.62 | 12.78 | 12.62 | 12.73 | 5600.0 |
| 2015-06-16 | ABEO | Stock | 180.5 | 184.0 | 176.75 | 177.0 | 28020.0 |
| 2015-06-16 | ABEOW-DELISTED | Stock | 2.82 | 2.9 | 2.81 | 2.81 | 3688.0 |
| 2015-06-16 | ABEV | Stock | 5.97 | 6.09 | 5.94 | 6.04 | 10721300.0 |
| 2015-06-16 | ABG | Stock | 87.02 | 88.92 | 86.39 | 88.67 | 218500.0 |
| 2015-06-16 | ABGB-DELISTED | Stock | 16.3 | 16.53 | 16.258 | 16.47 | 11188.0 |
| 2015-06-16 | ABIL-DELISTED | Stock | 9.99 | 10.0 | 9.9 | 9.9995 | 201300.0 |
> showing 50 of 6,664 rows — these rows as CSV