PREVIEW / stock_daily / 2015-03-05
file: by_date/stock_daily/2015/2015-03-05.parquet size: 222 KB rows: 6,611 symbols: 3,494
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-03-05 | AAPL | Stock | 32.145 | 32.1875 | 31.44 | 31.6025 | 226068400.0 |
| 2015-03-05 | MSFT | Stock | 43.07 | 43.24 | 42.82 | 43.11 | 23193500.0 |
| 2015-03-05 | NVDA | Stock | 0.5608 | 0.5725 | 0.5592 | 0.5715 | 323056000.0 |
| 2015-03-05 | AMZN | Stock | 19.2805 | 19.421 | 19.1945 | 19.3915 | 53870000.0 |
| 2015-03-05 | GOOGL | Stock | 28.981 | 29.16 | 28.9115 | 29.0718 | 35917780.0 |
| 2015-03-05 | META | Stock | 81.23 | 81.99 | 81.05 | 81.21 | 27825700.0 |
| 2015-03-05 | TSLA | Stock | 13.5233 | 13.746 | 13.3433 | 13.3753 | 73155000.0 |
| 2015-03-05 | TLT | Stock | 126.53 | 126.88 | 125.9 | 126.29 | 6044998.0 |
| 2015-03-05 | ES | Stock | 50.2 | 50.76 | 49.95 | 50.55 | 867800.0 |
| 2015-03-05 | CL | Stock | 70.97 | 71.56 | 70.79 | 71.46 | 3713300.0 |
| 2015-03-05 | A | Stock | 41.99 | 42.24 | 41.84 | 42.22 | 1376500.0 |
| 2015-03-05 | AA.B-DELISTED | Stock | 47.78 | 47.78 | 47.03 | 47.3 | 214369.0 |
| 2015-03-05 | AABA-DELISTED | Stock | 44.08 | 44.31 | 43.5 | 44.17 | 11354960.0 |
| 2015-03-05 | AAC-DELISTED | Stock | 32.54 | 32.54 | 31.32 | 32.04 | 181032.0 |
| 2015-03-05 | AACG | Stock | 4.02 | 4.19 | 4.0 | 4.06 | 3200.0 |
| 2015-03-05 | AAIC-DELISTED | Stock | 25.17 | 25.226 | 25.01 | 25.19 | 137227.0 |
| 2015-03-05 | AAL | Stock | 49.19 | 49.2 | 47.78 | 48.4 | 7041000.0 |
| 2015-03-05 | AAMC-DELISTED | Stock | 60.2882 | 60.291 | 59.8118 | 59.8118 | 5280.0 |
| 2015-03-05 | AAME | Stock | 3.99 | 3.99 | 3.98 | 3.98 | 1200.0 |
| 2015-03-05 | AAMI | Stock | 17.5 | 17.95 | 17.34 | 17.65 | 87100.0 |
| 2015-03-05 | AAOI | Stock | 12.96 | 13.1 | 12.67 | 12.74 | 260500.0 |
| 2015-03-05 | AAON | Stock | 14.8533 | 14.9333 | 14.6 | 14.82 | 129150.0 |
| 2015-03-05 | AAP | Stock | 151.82 | 153.23 | 150.93 | 152.52 | 753200.0 |
| 2015-03-05 | AAT | Stock | 41.61 | 41.97 | 41.47 | 41.65 | 130400.0 |
| 2015-03-05 | AAU-DELISTED | Stock | 1.06 | 1.07 | 1.05 | 1.05 | 92304.0 |
| 2015-03-05 | AAUAF-DELISTED | Stock | 1.05 | 1.06 | 1.04 | 1.05 | 94170.0 |
| 2015-03-05 | AAV-DELISTED | Stock | 5.41 | 5.44 | 5.36 | 5.37 | 71966.0 |
| 2015-03-05 | AAVL-DELISTED | Stock | 36.93 | 38.2374 | 35.96 | 37.89 | 332536.0 |
| 2015-03-05 | AAWW-DELISTED | Stock | 46.28 | 46.94 | 45.72 | 46.3 | 148673.0 |
| 2015-03-05 | AAXJ | Stock | 63.27 | 63.29 | 63.0 | 63.11 | 627488.0 |
| 2015-03-05 | AAXN-DELISTED | Stock | 22.84 | 22.9199 | 22.3 | 22.54 | 1309116.0 |
| 2015-03-05 | AB | Stock | 28.51 | 28.91 | 28.44 | 28.58 | 334600.0 |
| 2015-03-05 | ABAC-DELISTED | Stock | 1.47 | 1.54 | 1.43 | 1.54 | 10729.0 |
| 2015-03-05 | ABAX-DELISTED | Stock | 62.44 | 62.64 | 61.98 | 62.14 | 120743.0 |
| 2015-03-05 | ABB-DELISTED | Stock | 21.11 | 21.167 | 20.98 | 21.04 | 893165.0 |
| 2015-03-05 | ABBNY-DELISTED | Stock | 21.11 | 21.167 | 20.98 | 21.05 | 966624.0 |
| 2015-03-05 | ABBV | Stock | 57.21 | 59.48 | 56.65 | 56.86 | 47051800.0 |
| 2015-03-05 | ABC-DELISTED | Stock | 103.74 | 103.9199 | 103.17 | 103.61 | 1091960.0 |
| 2015-03-05 | ABCB | Stock | 25.54 | 25.76 | 25.25 | 25.6 | 64800.0 |
| 2015-03-05 | ABCD-DELISTED | Stock | 2.78 | 2.85 | 2.75 | 2.8399 | 64062.0 |
| 2015-03-05 | ABCO-DELISTED | Stock | 53.66 | 54.168 | 53.03 | 53.74 | 192118.0 |
| 2015-03-05 | ABCW-DELISTED | Stock | 34.14 | 34.4899 | 33.84 | 33.89 | 5014.0 |
| 2015-03-05 | ABDC-DELISTED | Stock | 13.65 | 13.73 | 13.5 | 13.57 | 24486.0 |
| 2015-03-05 | ABE-DELISTED | Stock | 12.99 | 13.0399 | 12.99 | 13.0 | 3458.0 |
| 2015-03-05 | ABEO | Stock | 87.75 | 90.0 | 86.25 | 88.75 | 10572.0 |
| 2015-03-05 | ABEOW-DELISTED | Stock | 1.1 | 1.1 | 1.1 | 1.1 | 500.0 |
| 2015-03-05 | ABEV | Stock | 6.15 | 6.21 | 6.06 | 6.14 | 15325700.0 |
| 2015-03-05 | ABG | Stock | 77.02 | 79.16 | 76.6 | 78.6 | 411000.0 |
| 2015-03-05 | ABGB-DELISTED | Stock | 17.2 | 17.44 | 17.1301 | 17.37 | 125661.0 |
| 2015-03-05 | ABIL-DELISTED | Stock | 9.89 | 10.0 | 9.89 | 9.9 | 6751.0 |
> showing 50 of 6,611 rows — these rows as CSV