PREVIEW / stock_daily / 2015-08-18
file: by_date/stock_daily/2015/2015-08-18.parquet size: 222 KB rows: 6,639 symbols: 3,443
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-08-18 | AAPL | Stock | 29.1075 | 29.36 | 29.0025 | 29.125 | 138242800.0 |
| 2015-08-18 | MSFT | Stock | 46.84 | 47.43 | 46.7 | 47.27 | 23574100.0 |
| 2015-08-18 | NVDA | Stock | 0.5805 | 0.5845 | 0.5725 | 0.577 | 287084000.0 |
| 2015-08-18 | AMZN | Stock | 26.752 | 26.9745 | 26.65 | 26.751 | 41426000.0 |
| 2015-08-18 | GOOGL | Stock | 34.5535 | 34.7878 | 34.266 | 34.4365 | 27710880.0 |
| 2015-08-18 | META | Stock | 94.08 | 95.85 | 94.04 | 95.17 | 22278800.0 |
| 2015-08-18 | TSLA | Stock | 17.0253 | 17.3967 | 16.904 | 17.3813 | 62925000.0 |
| 2015-08-18 | TLT | Stock | 123.8 | 124.29 | 123.38 | 123.54 | 5024294.0 |
| 2015-08-18 | ES | Stock | 51.39 | 51.64 | 51.17 | 51.47 | 1803300.0 |
| 2015-08-18 | CL | Stock | 67.67 | 68.02 | 67.49 | 67.69 | 2230700.0 |
| 2015-08-18 | A | Stock | 39.11 | 40.35 | 39.0 | 39.02 | 6416900.0 |
| 2015-08-18 | AA.B-DELISTED | Stock | 34.83 | 35.3 | 34.32 | 34.41 | 35039.0 |
| 2015-08-18 | AABA-DELISTED | Stock | 35.78 | 36.1872 | 35.6 | 35.69 | 10309206.0 |
| 2015-08-18 | AAC-DELISTED | Stock | 23.15 | 25.74 | 23.05 | 24.05 | 757148.0 |
| 2015-08-18 | AACG | Stock | 3.02 | 3.19 | 3.01 | 3.02 | 6400.0 |
| 2015-08-18 | AAIC-DELISTED | Stock | 18.3 | 18.31 | 18.11 | 18.18 | 145224.0 |
| 2015-08-18 | AAL | Stock | 44.06 | 44.45 | 43.24 | 43.63 | 6317200.0 |
| 2015-08-18 | AAMC-DELISTED | Stock | 23.4412 | 23.4412 | 16.4706 | 17.65 | 189135.0 |
| 2015-08-18 | AAME | Stock | 3.66 | 3.67 | 3.5 | 3.65 | 3800.0 |
| 2015-08-18 | AAMI | Stock | 17.57 | 17.72 | 17.42 | 17.64 | 114000.0 |
| 2015-08-18 | AAOI | Stock | 22.0 | 22.29 | 21.77 | 21.83 | 405500.0 |
| 2015-08-18 | AAON | Stock | 15.3333 | 15.4133 | 15.22 | 15.36 | 203400.0 |
| 2015-08-18 | AAP | Stock | 186.22 | 186.27 | 183.59 | 185.77 | 1508100.0 |
| 2015-08-18 | AAT | Stock | 42.15 | 42.28 | 41.94 | 42.22 | 105200.0 |
| 2015-08-18 | AAU-DELISTED | Stock | 0.582 | 0.653 | 0.582 | 0.6027 | 45540.0 |
| 2015-08-18 | AAUAF-DELISTED | Stock | 0.582 | 0.653 | 0.582 | 0.6027 | 45986.0 |
| 2015-08-18 | AAV-DELISTED | Stock | 5.3001 | 5.38 | 5.19 | 5.34 | 104171.0 |
| 2015-08-18 | AAVL-DELISTED | Stock | 10.8 | 11.5099 | 10.8 | 11.05 | 687604.0 |
| 2015-08-18 | AAWW-DELISTED | Stock | 44.95 | 45.8 | 44.7 | 45.21 | 232105.0 |
| 2015-08-18 | AAXJ | Stock | 55.66 | 55.9 | 55.62 | 55.67 | 1164953.0 |
| 2015-08-18 | AAXN-DELISTED | Stock | 23.98 | 24.23 | 23.5 | 23.91 | 968639.0 |
| 2015-08-18 | AB | Stock | 28.59 | 28.8 | 28.21 | 28.31 | 270700.0 |
| 2015-08-18 | ABAC-DELISTED | Stock | 0.88 | 0.91 | 0.8701 | 0.9099 | 3500.0 |
| 2015-08-18 | ABAX-DELISTED | Stock | 48.3 | 48.46 | 47.85 | 47.93 | 114596.0 |
| 2015-08-18 | ABB-DELISTED | Stock | 19.92 | 19.965 | 19.84 | 19.89 | 807136.0 |
| 2015-08-18 | ABBNY-DELISTED | Stock | 19.92 | 19.965 | 19.84 | 19.88 | 885534.0 |
| 2015-08-18 | ABBV | Stock | 69.42 | 69.74 | 68.67 | 68.86 | 6376500.0 |
| 2015-08-18 | ABC-DELISTED | Stock | 104.36 | 105.87 | 104.36 | 104.91 | 933179.0 |
| 2015-08-18 | ABCB | Stock | 28.43 | 28.94 | 28.16 | 28.31 | 113800.0 |
| 2015-08-18 | ABCD-DELISTED | Stock | 4.72 | 4.78 | 4.62 | 4.66 | 59473.0 |
| 2015-08-18 | ABCO-DELISTED | Stock | 52.35 | 53.17 | 52.06 | 52.49 | 376937.0 |
| 2015-08-18 | ABCW-DELISTED | Stock | 41.02 | 41.18 | 40.09 | 40.09 | 10464.0 |
| 2015-08-18 | ABDC-DELISTED | Stock | 13.04 | 13.15 | 12.88 | 12.99 | 9115.0 |
| 2015-08-18 | ABE-DELISTED | Stock | 11.82 | 11.82 | 11.62 | 11.72 | 4754.0 |
| 2015-08-18 | ABEO | Stock | 135.75 | 137.25 | 130.25 | 131.0 | 6356.0 |
| 2015-08-18 | ABEOW-DELISTED | Stock | 2.13 | 2.53 | 1.58 | 1.58 | 8574.0 |
| 2015-08-18 | ABEV | Stock | 5.29 | 5.53 | 5.26 | 5.39 | 19910700.0 |
| 2015-08-18 | ABG | Stock | 84.7 | 85.26 | 83.73 | 84.62 | 228000.0 |
| 2015-08-18 | ABGB-DELISTED | Stock | 4.83 | 4.87 | 4.6 | 4.69 | 108051.0 |
| 2015-08-18 | ABM | Stock | 33.7 | 34.0 | 33.65 | 33.76 | 213000.0 |
> showing 50 of 6,639 rows — these rows as CSV