PREVIEW / stock_daily / 2015-10-29
file: by_date/stock_daily/2015/2015-10-29.parquet size: 221 KB rows: 6,586 symbols: 3,402
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-29 | AAPL | Stock | 29.675 | 30.1725 | 29.5675 | 30.1325 | 204909200.0 |
| 2015-10-29 | MSFT | Stock | 53.54 | 53.83 | 53.22 | 53.36 | 30202100.0 |
| 2015-10-29 | NVDA | Stock | 0.7052 | 0.7125 | 0.6908 | 0.692 | 327168000.0 |
| 2015-10-29 | AMZN | Stock | 30.885 | 31.377 | 30.7695 | 31.3275 | 77920000.0 |
| 2015-10-29 | GOOGL | Stock | 36.8315 | 37.3395 | 36.758 | 37.2425 | 36519140.0 |
| 2015-10-29 | META | Stock | 103.96 | 105.12 | 103.52 | 104.88 | 20316700.0 |
| 2015-10-29 | TSLA | Stock | 14.1167 | 14.25 | 14.0427 | 14.1087 | 27075000.0 |
| 2015-10-29 | TLT | Stock | 123.18 | 123.22 | 121.7 | 121.86 | 12107974.0 |
| 2015-10-29 | ES | Stock | 50.61 | 50.86 | 49.83 | 50.76 | 1265500.0 |
| 2015-10-29 | CL | Stock | 68.62 | 69.44 | 68.42 | 69.23 | 3511000.0 |
| 2015-10-29 | A | Stock | 37.47 | 37.77 | 37.28 | 37.7 | 1352300.0 |
| 2015-10-29 | AA.B-DELISTED | Stock | 32.0 | 32.446 | 31.97 | 32.27 | 146996.0 |
| 2015-10-29 | AABA-DELISTED | Stock | 34.87 | 35.15 | 34.7 | 35.04 | 10041326.0 |
| 2015-10-29 | AAC-DELISTED | Stock | 23.53 | 25.0 | 23.5 | 23.5 | 249113.0 |
| 2015-10-29 | AACG | Stock | 3.75 | 3.81 | 3.61 | 3.61 | 10600.0 |
| 2015-10-29 | AAIC-DELISTED | Stock | 13.76 | 13.85 | 13.592 | 13.72 | 261726.0 |
| 2015-10-29 | AAL | Stock | 45.63 | 46.1 | 45.21 | 45.86 | 5234400.0 |
| 2015-10-29 | AAMC-DELISTED | Stock | 7.3529 | 7.8324 | 6.9118 | 6.9912 | 40610.0 |
| 2015-10-29 | AAME | Stock | 4.36 | 4.44 | 4.36 | 4.44 | 4400.0 |
| 2015-10-29 | AAMI | Stock | 15.66 | 15.66 | 15.21 | 15.28 | 113500.0 |
| 2015-10-29 | AAOI | Stock | 20.74 | 21.0 | 20.24 | 20.41 | 428800.0 |
| 2015-10-29 | AAON | Stock | 14.1267 | 14.18 | 13.8267 | 13.9267 | 328650.0 |
| 2015-10-29 | AAP | Stock | 194.64 | 198.57 | 194.4 | 197.48 | 727700.0 |
| 2015-10-29 | AAT | Stock | 42.73 | 43.28 | 42.08 | 42.56 | 142300.0 |
| 2015-10-29 | AAU-DELISTED | Stock | 0.599 | 0.6199 | 0.56 | 0.5601 | 167977.0 |
| 2015-10-29 | AAUAF-DELISTED | Stock | 0.599 | 0.6199 | 0.56 | 0.58 | 172903.0 |
| 2015-10-29 | AAV-DELISTED | Stock | 5.45 | 5.567 | 5.41 | 5.53 | 74514.0 |
| 2015-10-29 | AAVL-DELISTED | Stock | 8.52 | 8.95 | 8.36 | 8.48 | 311878.0 |
| 2015-10-29 | AAWW-DELISTED | Stock | 39.97 | 41.54 | 39.97 | 40.99 | 195258.0 |
| 2015-10-29 | AAXJ | Stock | 56.53 | 56.725 | 56.41 | 56.59 | 480830.0 |
| 2015-10-29 | AAXN-DELISTED | Stock | 23.5 | 24.1 | 23.02 | 23.39 | 1373446.0 |
| 2015-10-29 | AB | Stock | 26.36 | 26.59 | 25.74 | 25.89 | 333800.0 |
| 2015-10-29 | ABAC-DELISTED | Stock | 0.62 | 0.65 | 0.6 | 0.64 | 11986.0 |
| 2015-10-29 | ABAX-DELISTED | Stock | 53.49 | 53.98 | 51.27 | 51.4 | 266286.0 |
| 2015-10-29 | ABB-DELISTED | Stock | 18.68 | 18.775 | 18.65 | 18.71 | 1304635.0 |
| 2015-10-29 | ABBNY-DELISTED | Stock | 18.68 | 18.775 | 18.65 | 18.72 | 1815396.0 |
| 2015-10-29 | ABBV | Stock | 53.2 | 55.18 | 53.02 | 54.1 | 9304400.0 |
| 2015-10-29 | ABC-DELISTED | Stock | 97.27 | 97.538 | 93.02 | 96.8 | 4684444.0 |
| 2015-10-29 | ABCB | Stock | 31.63 | 32.99 | 31.54 | 32.49 | 909600.0 |
| 2015-10-29 | ABCD-DELISTED | Stock | 4.84 | 4.86 | 4.79 | 4.84 | 24080.0 |
| 2015-10-29 | ABCO-DELISTED | Stock | 44.02 | 44.97 | 43.76 | 44.94 | 212457.0 |
| 2015-10-29 | ABCW-DELISTED | Stock | 41.99 | 42.07 | 41.73 | 42.03 | 22475.0 |
| 2015-10-29 | ABDC-DELISTED | Stock | 11.8 | 12.06 | 11.75 | 11.79 | 39345.0 |
| 2015-10-29 | ABE-DELISTED | Stock | 11.17 | 11.24 | 11.17 | 11.23 | 2212.0 |
| 2015-10-29 | ABEO | Stock | 101.0 | 103.5 | 98.5 | 100.5 | 4128.0 |
| 2015-10-29 | ABEOW-DELISTED | Stock | 1.6824 | 1.6824 | 1.42 | 1.4703 | 2100.0 |
| 2015-10-29 | ABEV | Stock | 4.87 | 4.95 | 4.81 | 4.87 | 13513000.0 |
| 2015-10-29 | ABG | Stock | 80.05 | 80.22 | 77.02 | 77.74 | 437800.0 |
| 2015-10-29 | ABGB-DELISTED | Stock | 4.64 | 4.66 | 4.58 | 4.59 | 16580.0 |
| 2015-10-29 | ABM | Stock | 28.21 | 28.21 | 26.98 | 27.89 | 936500.0 |
> showing 50 of 6,586 rows — these rows as CSV