PREVIEW / stock_daily / 2015-05-29
file: by_date/stock_daily/2015/2015-05-29.parquet size: 225 KB rows: 6,659 symbols: 3,509
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-05-29 | AAPL | Stock | 32.8075 | 32.8625 | 32.475 | 32.57 | 203538000.0 |
| 2015-05-29 | MSFT | Stock | 47.43 | 47.57 | 46.59 | 46.86 | 36519600.0 |
| 2015-05-29 | NVDA | Stock | 0.5535 | 0.557 | 0.5525 | 0.5532 | 335168000.0 |
| 2015-05-29 | AMZN | Stock | 21.3615 | 21.625 | 21.3615 | 21.4615 | 60322000.0 |
| 2015-05-29 | GOOGL | Stock | 27.66 | 27.697 | 27.252 | 27.266 | 43445640.0 |
| 2015-05-29 | META | Stock | 79.95 | 80.07 | 78.88 | 79.19 | 16134600.0 |
| 2015-05-29 | TSLA | Stock | 16.7333 | 16.858 | 16.6287 | 16.72 | 56839500.0 |
| 2015-05-29 | TLT | Stock | 123.23 | 123.57 | 122.51 | 122.71 | 7911982.0 |
| 2015-05-29 | ES | Stock | 49.26 | 49.52 | 49.01 | 49.25 | 1629100.0 |
| 2015-05-29 | CL | Stock | 67.21 | 67.35 | 66.74 | 66.79 | 4755200.0 |
| 2015-05-29 | A | Stock | 41.79 | 41.83 | 40.82 | 41.19 | 5022600.0 |
| 2015-05-29 | AA.B-DELISTED | Stock | 43.96 | 44.2 | 43.7 | 43.71 | 690937.0 |
| 2015-05-29 | AABA-DELISTED | Stock | 43.45 | 43.59 | 42.8101 | 42.93 | 10342749.0 |
| 2015-05-29 | AAC-DELISTED | Stock | 38.53 | 38.88 | 37.82 | 38.77 | 172262.0 |
| 2015-05-29 | AACG | Stock | 4.97 | 5.0 | 4.9 | 4.91 | 11200.0 |
| 2015-05-29 | AAIC-DELISTED | Stock | 20.78 | 20.85 | 20.58 | 20.69 | 314326.0 |
| 2015-05-29 | AAL | Stock | 41.68 | 42.6 | 41.32 | 42.37 | 13236100.0 |
| 2015-05-29 | AAMC-DELISTED | Stock | 50.9059 | 50.9059 | 47.3559 | 50.1147 | 75987.0 |
| 2015-05-29 | AAME | Stock | 3.39 | 3.97 | 3.39 | 3.8 | 30800.0 |
| 2015-05-29 | AAMI | Stock | 19.46 | 19.66 | 19.14 | 19.47 | 261900.0 |
| 2015-05-29 | AAOI | Stock | 18.05 | 18.68 | 17.735 | 17.86 | 279400.0 |
| 2015-05-29 | AAON | Stock | 16.1933 | 16.2867 | 15.6667 | 15.78 | 651000.0 |
| 2015-05-29 | AAP | Stock | 155.31 | 155.69 | 153.19 | 153.22 | 1032700.0 |
| 2015-05-29 | AAT | Stock | 39.95 | 40.12 | 39.16 | 39.35 | 604600.0 |
| 2015-05-29 | AAU-DELISTED | Stock | 0.91 | 0.9435 | 0.9002 | 0.92 | 65832.0 |
| 2015-05-29 | AAUAF-DELISTED | Stock | 0.91 | 0.9435 | 0.9002 | 0.92 | 66777.0 |
| 2015-05-29 | AAV-DELISTED | Stock | 6.1 | 6.13 | 5.9968 | 6.06 | 46787.0 |
| 2015-05-29 | AAVL-DELISTED | Stock | 37.33 | 38.05 | 36.86 | 37.28 | 288448.0 |
| 2015-05-29 | AAWW-DELISTED | Stock | 55.42 | 55.5 | 53.97 | 54.49 | 1000413.0 |
| 2015-05-29 | AAXJ | Stock | 66.29 | 66.58 | 65.98 | 66.03 | 2620101.0 |
| 2015-05-29 | AAXN-DELISTED | Stock | 31.71 | 31.91 | 31.4168 | 31.58 | 965636.0 |
| 2015-05-29 | AB | Stock | 31.8 | 31.84 | 31.27 | 31.36 | 128800.0 |
| 2015-05-29 | ABAC-DELISTED | Stock | 1.6001 | 1.62 | 1.6001 | 1.62 | 1100.0 |
| 2015-05-29 | ABAX-DELISTED | Stock | 52.8 | 53.4 | 52.52 | 53.09 | 161279.0 |
| 2015-05-29 | ABB-DELISTED | Stock | 21.94 | 22.08 | 21.74 | 21.85 | 1874528.0 |
| 2015-05-29 | ABBNY-DELISTED | Stock | 21.94 | 22.08 | 21.74 | 21.84 | 1931303.0 |
| 2015-05-29 | ABBV | Stock | 67.22 | 67.52 | 66.39 | 66.59 | 9451000.0 |
| 2015-05-29 | ABC-DELISTED | Stock | 113.22 | 114.4 | 112.6 | 112.61 | 4112486.0 |
| 2015-05-29 | ABCB | Stock | 25.21 | 25.47 | 24.81 | 25.19 | 115900.0 |
| 2015-05-29 | ABCD-DELISTED | Stock | 3.83 | 4.22 | 3.8 | 4.22 | 140767.0 |
| 2015-05-29 | ABCO-DELISTED | Stock | 49.42 | 51.32 | 48.97 | 50.77 | 397494.0 |
| 2015-05-29 | ABCW-DELISTED | Stock | 37.0 | 37.12 | 36.93 | 37.02 | 29931.0 |
| 2015-05-29 | ABDC-DELISTED | Stock | 13.85 | 13.8799 | 13.75 | 13.75 | 35128.0 |
| 2015-05-29 | ABE-DELISTED | Stock | 12.84 | 12.89 | 12.8 | 12.8 | 2769.0 |
| 2015-05-29 | ABEO | Stock | 215.0 | 216.5 | 192.0 | 196.25 | 80552.0 |
| 2015-05-29 | ABEOW-DELISTED | Stock | 3.78 | 4.06 | 3.4001 | 3.52 | 70401.0 |
| 2015-05-29 | ABEV | Stock | 5.82 | 5.85 | 5.73 | 5.75 | 19062100.0 |
| 2015-05-29 | ABG | Stock | 86.84 | 87.34 | 85.1 | 85.12 | 306100.0 |
| 2015-05-29 | ABGB-DELISTED | Stock | 16.79 | 16.91 | 16.7003 | 16.7575 | 11234.0 |
| 2015-05-29 | ABM | Stock | 32.72 | 32.83 | 32.34 | 32.44 | 253700.0 |
> showing 50 of 6,659 rows — these rows as CSV