PREVIEW / stock_daily / 2015-06-01
file: by_date/stock_daily/2015/2015-06-01.parquet size: 223 KB rows: 6,660 symbols: 3,504
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-01 | AAPL | Stock | 32.57 | 32.8475 | 32.5125 | 32.635 | 128451200.0 |
| 2015-06-01 | MSFT | Stock | 47.06 | 47.77 | 46.62 | 47.23 | 28837300.0 |
| 2015-06-01 | NVDA | Stock | 0.5568 | 0.565 | 0.5532 | 0.5595 | 372660000.0 |
| 2015-06-01 | AMZN | Stock | 21.52 | 21.658 | 21.31 | 21.546 | 45066000.0 |
| 2015-06-01 | GOOGL | Stock | 27.4365 | 27.5285 | 27.179 | 27.4605 | 33210000.0 |
| 2015-06-01 | META | Stock | 79.3 | 80.38 | 78.66 | 80.29 | 18119000.0 |
| 2015-06-01 | TSLA | Stock | 16.7607 | 16.7733 | 16.498 | 16.63 | 37576500.0 |
| 2015-06-01 | TLT | Stock | 122.11 | 122.38 | 120.69 | 121.13 | 13108065.0 |
| 2015-06-01 | ES | Stock | 49.26 | 49.52 | 49.03 | 49.19 | 1122800.0 |
| 2015-06-01 | CL | Stock | 66.71 | 67.12 | 66.36 | 66.9 | 3447100.0 |
| 2015-06-01 | A | Stock | 41.43 | 41.43 | 40.85 | 40.92 | 2440000.0 |
| 2015-06-01 | AA.B-DELISTED | Stock | 44.85 | 44.85 | 43.44 | 43.89 | 53245.0 |
| 2015-06-01 | AABA-DELISTED | Stock | 43.14 | 43.63 | 42.91 | 43.36 | 10540413.0 |
| 2015-06-01 | AAC-DELISTED | Stock | 38.86 | 39.59 | 38.73 | 39.04 | 116963.0 |
| 2015-06-01 | AACG | Stock | 5.0 | 5.1 | 4.74 | 4.85 | 38100.0 |
| 2015-06-01 | AAIC-DELISTED | Stock | 20.66 | 21.135 | 20.66 | 21.13 | 250128.0 |
| 2015-06-01 | AAL | Stock | 42.61 | 44.38 | 42.09 | 44.18 | 21917100.0 |
| 2015-06-01 | AAMC-DELISTED | Stock | 47.7441 | 50.0 | 47.7441 | 49.1176 | 55961.0 |
| 2015-06-01 | AAME | Stock | 3.81 | 3.88 | 3.67 | 3.78 | 3600.0 |
| 2015-06-01 | AAMI | Stock | 19.52 | 20.02 | 19.17 | 19.25 | 101800.0 |
| 2015-06-01 | AAOI | Stock | 17.79 | 18.25 | 17.36 | 17.85 | 294400.0 |
| 2015-06-01 | AAON | Stock | 15.9467 | 16.0533 | 15.5533 | 15.8867 | 170400.0 |
| 2015-06-01 | AAP | Stock | 154.28 | 154.89 | 152.71 | 153.32 | 764100.0 |
| 2015-06-01 | AAT | Stock | 39.45 | 40.15 | 39.31 | 40.12 | 182000.0 |
| 2015-06-01 | AAU-DELISTED | Stock | 0.919 | 0.94 | 0.9 | 0.91 | 49899.0 |
| 2015-06-01 | AAUAF-DELISTED | Stock | 0.911 | 0.93 | 0.9 | 0.91 | 52978.0 |
| 2015-06-01 | AAV-DELISTED | Stock | 6.07 | 6.07 | 5.9 | 6.0 | 64009.0 |
| 2015-06-01 | AAVL-DELISTED | Stock | 37.53 | 37.89 | 35.64 | 37.24 | 245831.0 |
| 2015-06-01 | AAWW-DELISTED | Stock | 55.1 | 55.65 | 54.8 | 55.55 | 674766.0 |
| 2015-06-01 | AAXJ | Stock | 66.05 | 66.36 | 65.86 | 66.11 | 870005.0 |
| 2015-06-01 | AAXN-DELISTED | Stock | 31.7 | 31.8699 | 30.73 | 30.88 | 1583735.0 |
| 2015-06-01 | AB | Stock | 31.7 | 32.0 | 31.7 | 31.83 | 240100.0 |
| 2015-06-01 | ABAC-DELISTED | Stock | 1.63 | 1.63 | 1.48 | 1.5 | 90158.0 |
| 2015-06-01 | ABAX-DELISTED | Stock | 53.0 | 53.44 | 52.53 | 52.99 | 208630.0 |
| 2015-06-01 | ABB-DELISTED | Stock | 21.86 | 21.88 | 21.62 | 21.69 | 1376440.0 |
| 2015-06-01 | ABBNY-DELISTED | Stock | 21.86 | 21.88 | 21.62 | 21.67 | 1420155.0 |
| 2015-06-01 | ABBV | Stock | 66.8 | 67.26 | 66.26 | 66.93 | 12426700.0 |
| 2015-06-01 | ABC-DELISTED | Stock | 112.81 | 113.76 | 111.83 | 113.26 | 1186984.0 |
| 2015-06-01 | ABCB | Stock | 25.41 | 25.46 | 24.78 | 25.19 | 121600.0 |
| 2015-06-01 | ABCD-DELISTED | Stock | 4.35 | 4.4499 | 3.79 | 4.04 | 106444.0 |
| 2015-06-01 | ABCO-DELISTED | Stock | 50.5 | 52.2 | 50.14 | 51.78 | 400984.0 |
| 2015-06-01 | ABCW-DELISTED | Stock | 37.43 | 37.43 | 37.03 | 37.21 | 11107.0 |
| 2015-06-01 | ABDC-DELISTED | Stock | 13.86 | 13.86 | 13.63 | 13.69 | 22555.0 |
| 2015-06-01 | ABE-DELISTED | Stock | 12.77 | 12.9097 | 12.73 | 12.85 | 9910.0 |
| 2015-06-01 | ABEO | Stock | 191.5 | 195.0 | 177.0 | 177.0 | 69332.0 |
| 2015-06-01 | ABEOW-DELISTED | Stock | 3.24 | 3.5 | 3.01 | 3.4 | 49454.0 |
| 2015-06-01 | ABEV | Stock | 5.84 | 5.88 | 5.79 | 5.83 | 10477200.0 |
| 2015-06-01 | ABG | Stock | 85.1 | 86.95 | 84.59 | 85.93 | 219900.0 |
| 2015-06-01 | ABGB-DELISTED | Stock | 16.61 | 16.76 | 16.56 | 16.62 | 13921.0 |
| 2015-06-01 | ABIL-DELISTED | Stock | 9.91 | 9.91 | 9.9 | 9.9 | 487.0 |
> showing 50 of 6,660 rows — these rows as CSV