PREVIEW / stock_daily / 2015-05-22
file: by_date/stock_daily/2015/2015-05-22.parquet size: 223 KB rows: 6,641 symbols: 3,496
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-22 | AAPL | Stock | 32.9 | 33.2425 | 32.85 | 33.135 | 182384000.0 |
| 2015-05-22 | MSFT | Stock | 47.3 | 47.35 | 46.82 | 46.9 | 25720600.0 |
| 2015-05-22 | NVDA | Stock | 0.5235 | 0.5255 | 0.5202 | 0.5215 | 212592000.0 |
| 2015-05-22 | AMZN | Stock | 21.5775 | 21.622 | 21.3805 | 21.3815 | 40412000.0 |
| 2015-05-22 | GOOGL | Stock | 27.723 | 27.912 | 27.681 | 27.726 | 24265760.0 |
| 2015-05-22 | META | Stock | 80.35 | 81.31 | 80.25 | 80.54 | 19567900.0 |
| 2015-05-22 | TSLA | Stock | 16.3587 | 16.5733 | 16.334 | 16.5153 | 33346500.0 |
| 2015-05-22 | TLT | Stock | 120.65 | 120.75 | 119.8 | 120.4 | 5417933.0 |
| 2015-05-22 | ES | Stock | 49.3 | 49.42 | 48.87 | 49.29 | 827900.0 |
| 2015-05-22 | CL | Stock | 68.89 | 68.9 | 68.46 | 68.5 | 1714600.0 |
| 2015-05-22 | A | Stock | 42.27 | 42.67 | 42.07 | 42.5 | 1484800.0 |
| 2015-05-22 | AA.B-DELISTED | Stock | 44.9 | 45.04 | 44.8 | 44.82 | 32894.0 |
| 2015-05-22 | AABA-DELISTED | Stock | 43.58 | 44.0 | 43.4699 | 43.48 | 9478104.0 |
| 2015-05-22 | AAC-DELISTED | Stock | 38.18 | 39.975 | 37.52 | 39.32 | 266411.0 |
| 2015-05-22 | AACG | Stock | 4.75 | 5.24 | 4.7 | 5.2 | 50300.0 |
| 2015-05-22 | AAIC-DELISTED | Stock | 21.2 | 21.27 | 20.86 | 20.97 | 270241.0 |
| 2015-05-22 | AAL | Stock | 42.7 | 42.93 | 42.02 | 42.61 | 16113100.0 |
| 2015-05-22 | AAMC-DELISTED | Stock | 54.4118 | 55.4559 | 53.8353 | 55.3647 | 11104.0 |
| 2015-05-22 | AAME | Stock | 3.39 | 3.4 | 3.33 | 3.4 | 3800.0 |
| 2015-05-22 | AAMI | Stock | 19.56 | 19.73 | 19.37 | 19.54 | 43000.0 |
| 2015-05-22 | AAOI | Stock | 15.68 | 16.96 | 15.45 | 16.67 | 613200.0 |
| 2015-05-22 | AAON | Stock | 16.0733 | 16.2333 | 15.92 | 16.2067 | 212550.0 |
| 2015-05-22 | AAP | Stock | 157.42 | 161.55 | 156.73 | 160.2 | 2201000.0 |
| 2015-05-22 | AAT | Stock | 40.39 | 40.73 | 40.08 | 40.41 | 85800.0 |
| 2015-05-22 | AAU-DELISTED | Stock | 0.91 | 0.9235 | 0.8501 | 0.9199 | 83407.0 |
| 2015-05-22 | AAUAF-DELISTED | Stock | 0.91 | 0.9234 | 0.85 | 0.9198 | 84270.0 |
| 2015-05-22 | AAV-DELISTED | Stock | 6.25 | 6.3 | 6.1334 | 6.18 | 73810.0 |
| 2015-05-22 | AAVL-DELISTED | Stock | 38.96 | 39.3 | 37.58 | 37.94 | 177327.0 |
| 2015-05-22 | AAWW-DELISTED | Stock | 57.47 | 58.09 | 56.76 | 57.14 | 264091.0 |
| 2015-05-22 | AAXJ | Stock | 68.34 | 68.565 | 68.23 | 68.42 | 1220248.0 |
| 2015-05-22 | AAXN-DELISTED | Stock | 32.38 | 32.4299 | 31.73 | 31.87 | 1041310.0 |
| 2015-05-22 | AB | Stock | 31.72 | 32.01 | 31.51 | 31.82 | 167900.0 |
| 2015-05-22 | ABAC-DELISTED | Stock | 1.69 | 1.69 | 1.683 | 1.683 | 670.0 |
| 2015-05-22 | ABAX-DELISTED | Stock | 52.94 | 53.21 | 52.26 | 52.66 | 63364.0 |
| 2015-05-22 | ABB-DELISTED | Stock | 21.68 | 21.76 | 21.65 | 21.69 | 837400.0 |
| 2015-05-22 | ABBNY-DELISTED | Stock | 21.68 | 21.76 | 21.65 | 21.68 | 892774.0 |
| 2015-05-22 | ABBV | Stock | 65.48 | 65.87 | 65.31 | 65.48 | 14041500.0 |
| 2015-05-22 | ABC-DELISTED | Stock | 113.76 | 114.335 | 113.53 | 113.83 | 1372338.0 |
| 2015-05-22 | ABCB | Stock | 25.85 | 25.97 | 25.48 | 25.51 | 71900.0 |
| 2015-05-22 | ABCD-DELISTED | Stock | 3.81 | 3.95 | 3.81 | 3.84 | 62198.0 |
| 2015-05-22 | ABCO-DELISTED | Stock | 46.82 | 47.63 | 46.67 | 47.0 | 95031.0 |
| 2015-05-22 | ABCW-DELISTED | Stock | 37.43 | 37.43 | 37.05 | 37.24 | 5822.0 |
| 2015-05-22 | ABDC-DELISTED | Stock | 13.91 | 14.0 | 13.73 | 13.755 | 34992.0 |
| 2015-05-22 | ABE-DELISTED | Stock | 13.4 | 13.4527 | 13.33 | 13.39 | 3333.0 |
| 2015-05-22 | ABEO | Stock | 220.0 | 227.0 | 215.0 | 219.0 | 41748.0 |
| 2015-05-22 | ABEOW-DELISTED | Stock | 3.91 | 4.3 | 3.86 | 4.0 | 42964.0 |
| 2015-05-22 | ABEV | Stock | 6.17 | 6.18 | 6.03 | 6.06 | 22625000.0 |
| 2015-05-22 | ABG | Stock | 86.36 | 87.07 | 85.37 | 85.87 | 136500.0 |
| 2015-05-22 | ABGB-DELISTED | Stock | 16.41 | 16.5 | 16.22 | 16.39 | 37013.0 |
| 2015-05-22 | ABM | Stock | 32.54 | 32.71 | 32.2 | 32.49 | 343900.0 |
> showing 50 of 6,641 rows — these rows as CSV