PREVIEW / stock_daily / 2015-10-01
file: by_date/stock_daily/2015/2015-10-01.parquet size: 219 KB rows: 6,594 symbols: 3,406
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-10-01 | AAPL | Stock | 27.2675 | 27.405 | 26.8275 | 27.395 | 255716400.0 |
| 2015-10-01 | MSFT | Stock | 44.75 | 44.75 | 43.75 | 44.61 | 28657900.0 |
| 2015-10-01 | NVDA | Stock | 0.6162 | 0.618 | 0.5868 | 0.6043 | 489296000.0 |
| 2015-10-01 | AMZN | Stock | 25.55 | 26.04 | 25.3 | 26.036 | 75370000.0 |
| 2015-10-01 | GOOGL | Stock | 31.897 | 32.192 | 31.5558 | 32.1 | 42506300.0 |
| 2015-10-01 | META | Stock | 90.05 | 90.95 | 88.36 | 90.95 | 29283700.0 |
| 2015-10-01 | TSLA | Stock | 16.5007 | 16.5667 | 15.8087 | 15.992 | 68595000.0 |
| 2015-10-01 | TLT | Stock | 124.08 | 124.52 | 123.66 | 123.81 | 9069447.0 |
| 2015-10-01 | ES | Stock | 50.71 | 50.71 | 49.26 | 49.92 | 1934800.0 |
| 2015-10-01 | CL | Stock | 63.58 | 63.95 | 63.21 | 63.72 | 4253800.0 |
| 2015-10-01 | A | Stock | 34.32 | 34.48 | 33.48 | 33.74 | 3011400.0 |
| 2015-10-01 | AA.B-DELISTED | Stock | 34.98 | 34.98 | 32.66 | 32.67 | 47459.0 |
| 2015-10-01 | AABA-DELISTED | Stock | 28.95 | 29.0 | 28.44 | 28.92 | 13691813.0 |
| 2015-10-01 | AAC-DELISTED | Stock | 22.27 | 22.69 | 22.11 | 22.6 | 169191.0 |
| 2015-10-01 | AACG | Stock | 2.59 | 2.72 | 2.55 | 2.72 | 7200.0 |
| 2015-10-01 | AAIC-DELISTED | Stock | 14.03 | 14.27 | 13.88 | 13.98 | 243799.0 |
| 2015-10-01 | AAL | Stock | 38.5 | 39.27 | 37.84 | 39.2 | 9175100.0 |
| 2015-10-01 | AAMC-DELISTED | Stock | 6.8412 | 6.9412 | 6.5618 | 6.8529 | 29332.0 |
| 2015-10-01 | AAME | Stock | 4.04 | 4.05 | 3.86 | 4.05 | 4400.0 |
| 2015-10-01 | AAMI | Stock | 15.41 | 15.41 | 14.78 | 14.96 | 111800.0 |
| 2015-10-01 | AAOI | Stock | 18.74 | 18.79 | 17.7 | 18.04 | 348600.0 |
| 2015-10-01 | AAON | Stock | 12.9133 | 12.9667 | 12.6667 | 12.7933 | 201300.0 |
| 2015-10-01 | AAP | Stock | 190.28 | 192.64 | 188.1 | 192.04 | 1587000.0 |
| 2015-10-01 | AAT | Stock | 41.01 | 41.36 | 40.79 | 41.35 | 309800.0 |
| 2015-10-01 | AAU-DELISTED | Stock | 0.584 | 0.59 | 0.55 | 0.5683 | 32812.0 |
| 2015-10-01 | AAUAF-DELISTED | Stock | 0.584 | 0.59 | 0.55 | 0.5683 | 33029.0 |
| 2015-10-01 | AAV-DELISTED | Stock | 5.32 | 5.51 | 5.32 | 5.4 | 112460.0 |
| 2015-10-01 | AAVL-DELISTED | Stock | 8.27 | 8.36 | 7.9 | 8.01 | 416921.0 |
| 2015-10-01 | AAWW-DELISTED | Stock | 34.49 | 35.57 | 34.39 | 35.0 | 197143.0 |
| 2015-10-01 | AAXJ | Stock | 53.03 | 53.31 | 52.65 | 53.01 | 2744798.0 |
| 2015-10-01 | AAXN-DELISTED | Stock | 22.07 | 22.45 | 21.75 | 22.23 | 789141.0 |
| 2015-10-01 | AB | Stock | 26.7 | 26.98 | 25.37 | 25.58 | 364800.0 |
| 2015-10-01 | ABAC-DELISTED | Stock | 0.53 | 0.53 | 0.5 | 0.5 | 3644.0 |
| 2015-10-01 | ABAX-DELISTED | Stock | 44.07 | 44.19 | 42.76 | 43.49 | 176524.0 |
| 2015-10-01 | ABB-DELISTED | Stock | 17.72 | 17.7751 | 17.41 | 17.545 | 1726764.0 |
| 2015-10-01 | ABBNY-DELISTED | Stock | 17.72 | 17.7751 | 17.41 | 17.54 | 1833795.0 |
| 2015-10-01 | ABBV | Stock | 54.68 | 55.23 | 53.93 | 55.13 | 9255800.0 |
| 2015-10-01 | ABC-DELISTED | Stock | 94.99 | 95.11 | 93.2 | 94.5 | 2712986.0 |
| 2015-10-01 | ABCB | Stock | 28.83 | 29.4 | 27.79 | 28.28 | 528200.0 |
| 2015-10-01 | ABCD-DELISTED | Stock | 4.82 | 4.82 | 4.61 | 4.76 | 39088.0 |
| 2015-10-01 | ABCO-DELISTED | Stock | 45.68 | 46.02 | 44.385 | 44.78 | 438151.0 |
| 2015-10-01 | ABCW-DELISTED | Stock | 42.5 | 42.5 | 40.07 | 41.12 | 30830.0 |
| 2015-10-01 | ABDC-DELISTED | Stock | 11.57 | 11.7 | 11.51 | 11.64 | 35460.0 |
| 2015-10-01 | ABE-DELISTED | Stock | 10.76 | 10.77 | 10.66 | 10.67 | 4058.0 |
| 2015-10-01 | ABEO | Stock | 100.75 | 105.5 | 95.5 | 103.5 | 4468.0 |
| 2015-10-01 | ABEOW-DELISTED | Stock | 1.54 | 1.54 | 1.48 | 1.48 | 1300.0 |
| 2015-10-01 | ABEV | Stock | 4.9 | 4.95 | 4.82 | 4.93 | 12935800.0 |
| 2015-10-01 | ABG | Stock | 81.1 | 83.11 | 78.48 | 81.51 | 691600.0 |
| 2015-10-01 | ABGB-DELISTED | Stock | 4.57 | 4.6028 | 4.46 | 4.485 | 88162.0 |
| 2015-10-01 | ABIL-DELISTED | Stock | 9.98 | 9.98 | 9.95 | 9.95 | 400.0 |
> showing 50 of 6,594 rows — these rows as CSV