PREVIEW / stock_daily / 2015-08-19
file: by_date/stock_daily/2015/2015-08-19.parquet size: 222 KB rows: 6,630 symbols: 3,448
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-08-19 | AAPL | Stock | 29.025 | 29.13 | 28.67 | 28.7525 | 193146000.0 |
| 2015-08-19 | MSFT | Stock | 46.78 | 47.08 | 46.3 | 46.61 | 31485500.0 |
| 2015-08-19 | NVDA | Stock | 0.5762 | 0.5828 | 0.5685 | 0.5748 | 249248000.0 |
| 2015-08-19 | AMZN | Stock | 26.687 | 26.8625 | 26.45 | 26.646 | 46480000.0 |
| 2015-08-19 | GOOGL | Stock | 34.5055 | 35.01 | 34.34 | 34.702 | 50193940.0 |
| 2015-08-19 | META | Stock | 94.63 | 96.1 | 94.16 | 95.31 | 23251300.0 |
| 2015-08-19 | TSLA | Stock | 17.3553 | 17.3767 | 17.0013 | 17.0167 | 54064500.0 |
| 2015-08-19 | TLT | Stock | 123.06 | 124.93 | 122.99 | 124.76 | 10735974.0 |
| 2015-08-19 | ES | Stock | 51.32 | 51.79 | 51.02 | 51.68 | 1534400.0 |
| 2015-08-19 | CL | Stock | 67.34 | 67.5 | 66.6 | 66.74 | 3165400.0 |
| 2015-08-19 | A | Stock | 38.69 | 38.81 | 38.3 | 38.4 | 2730400.0 |
| 2015-08-19 | AA.B-DELISTED | Stock | 34.3 | 34.5 | 34.0 | 34.0 | 38519.0 |
| 2015-08-19 | AABA-DELISTED | Stock | 35.67 | 35.67 | 35.025 | 35.1999 | 8599071.0 |
| 2015-08-19 | AAC-DELISTED | Stock | 23.82 | 24.1214 | 21.86 | 22.8001 | 453512.0 |
| 2015-08-19 | AACG | Stock | 3.02 | 3.02 | 2.91 | 2.92 | 27500.0 |
| 2015-08-19 | AAIC-DELISTED | Stock | 18.11 | 18.19 | 17.94 | 17.98 | 186595.0 |
| 2015-08-19 | AAL | Stock | 43.53 | 44.27 | 43.21 | 43.53 | 8374000.0 |
| 2015-08-19 | AAMC-DELISTED | Stock | 17.6471 | 17.8088 | 12.3882 | 12.65 | 297089.0 |
| 2015-08-19 | AAME | Stock | 3.53 | 3.6 | 3.5 | 3.6 | 4400.0 |
| 2015-08-19 | AAMI | Stock | 17.52 | 17.64 | 17.24 | 17.47 | 155600.0 |
| 2015-08-19 | AAOI | Stock | 21.63 | 22.0 | 21.24 | 21.72 | 338600.0 |
| 2015-08-19 | AAON | Stock | 15.3333 | 15.34 | 15.1 | 15.12 | 196050.0 |
| 2015-08-19 | AAP | Stock | 185.28 | 188.5 | 184.39 | 187.84 | 912100.0 |
| 2015-08-19 | AAT | Stock | 42.11 | 42.21 | 41.71 | 42.0 | 162900.0 |
| 2015-08-19 | AAU-DELISTED | Stock | 0.62 | 0.6316 | 0.59 | 0.63 | 119028.0 |
| 2015-08-19 | AAUAF-DELISTED | Stock | 0.62 | 0.6316 | 0.59 | 0.63 | 119229.0 |
| 2015-08-19 | AAV-DELISTED | Stock | 5.31 | 5.35 | 5.2 | 5.27 | 69477.0 |
| 2015-08-19 | AAVL-DELISTED | Stock | 10.91 | 11.16 | 10.3605 | 10.85 | 797705.0 |
| 2015-08-19 | AAWW-DELISTED | Stock | 44.84 | 45.06 | 43.96 | 43.96 | 310290.0 |
| 2015-08-19 | AAXJ | Stock | 55.38 | 55.46 | 54.61 | 54.99 | 1606072.0 |
| 2015-08-19 | AAXN-DELISTED | Stock | 23.5 | 23.65 | 22.6 | 23.03 | 1852917.0 |
| 2015-08-19 | AB | Stock | 28.29 | 28.55 | 27.89 | 28.04 | 262000.0 |
| 2015-08-19 | ABAC-DELISTED | Stock | 0.87 | 0.87 | 0.7737 | 0.8442 | 41571.0 |
| 2015-08-19 | ABAX-DELISTED | Stock | 47.67 | 48.0846 | 47.2 | 47.62 | 141335.0 |
| 2015-08-19 | ABB-DELISTED | Stock | 19.62 | 19.83 | 19.575 | 19.71 | 2313322.0 |
| 2015-08-19 | ABBNY-DELISTED | Stock | 19.62 | 19.83 | 19.575 | 19.7 | 2375048.0 |
| 2015-08-19 | ABBV | Stock | 68.75 | 69.08 | 68.21 | 68.59 | 6270300.0 |
| 2015-08-19 | ABC-DELISTED | Stock | 104.52 | 107.02 | 103.85 | 106.14 | 1811537.0 |
| 2015-08-19 | ABCB | Stock | 28.22 | 28.54 | 27.9 | 28.13 | 74100.0 |
| 2015-08-19 | ABCD-DELISTED | Stock | 4.66 | 4.78 | 4.55 | 4.67 | 91157.0 |
| 2015-08-19 | ABCO-DELISTED | Stock | 52.56 | 52.72 | 51.94 | 52.08 | 320098.0 |
| 2015-08-19 | ABCW-DELISTED | Stock | 40.18 | 40.845 | 40.0 | 40.0 | 10527.0 |
| 2015-08-19 | ABDC-DELISTED | Stock | 13.0 | 13.0 | 12.7 | 12.98 | 21563.0 |
| 2015-08-19 | ABE-DELISTED | Stock | 11.5001 | 11.69 | 11.5 | 11.69 | 9501.0 |
| 2015-08-19 | ABEO | Stock | 129.75 | 136.75 | 127.75 | 134.75 | 11752.0 |
| 2015-08-19 | ABEOW-DELISTED | Stock | 2.25 | 2.25 | 1.73 | 2.18 | 9589.0 |
| 2015-08-19 | ABEV | Stock | 5.35 | 5.36 | 5.16 | 5.19 | 26251600.0 |
| 2015-08-19 | ABG | Stock | 83.95 | 84.43 | 83.04 | 83.31 | 175300.0 |
| 2015-08-19 | ABGB-DELISTED | Stock | 4.46 | 4.47 | 4.1647 | 4.26 | 205822.0 |
| 2015-08-19 | ABM | Stock | 33.51 | 33.7 | 33.29 | 33.45 | 74800.0 |
> showing 50 of 6,630 rows — these rows as CSV