PREVIEW / stock_daily / 2015-08-05
file: by_date/stock_daily/2015/2015-08-05.parquet size: 223 KB rows: 6,667 symbols: 3,477
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-05 | AAPL | Stock | 28.2375 | 29.36 | 28.025 | 28.85 | 397250400.0 |
| 2015-08-05 | MSFT | Stock | 47.98 | 48.41 | 47.54 | 47.58 | 26959700.0 |
| 2015-08-05 | NVDA | Stock | 0.5218 | 0.5222 | 0.5135 | 0.5145 | 234628000.0 |
| 2015-08-05 | AMZN | Stock | 26.94 | 26.957 | 26.706 | 26.8505 | 57788000.0 |
| 2015-08-05 | GOOGL | Stock | 33.2875 | 33.9955 | 33.2791 | 33.6645 | 36447740.0 |
| 2015-08-05 | META | Stock | 95.25 | 97.09 | 95.18 | 96.44 | 29813200.0 |
| 2015-08-05 | TSLA | Stock | 17.572 | 18.0667 | 17.36 | 18.0087 | 93214500.0 |
| 2015-08-05 | TLT | Stock | 121.77 | 121.91 | 121.19 | 121.65 | 7574389.0 |
| 2015-08-05 | ES | Stock | 49.29 | 49.55 | 49.08 | 49.24 | 836600.0 |
| 2015-08-05 | CL | Stock | 68.77 | 69.23 | 68.34 | 69.08 | 2578900.0 |
| 2015-08-05 | A | Stock | 40.94 | 41.19 | 40.69 | 40.72 | 949500.0 |
| 2015-08-05 | AA.B-DELISTED | Stock | 36.0 | 36.88 | 35.91 | 35.92 | 28805.0 |
| 2015-08-05 | AABA-DELISTED | Stock | 37.32 | 37.71 | 37.23 | 37.25 | 6375883.0 |
| 2015-08-05 | AAC-DELISTED | Stock | 21.0 | 25.27 | 20.31 | 20.75 | 2588174.0 |
| 2015-08-05 | AACG | Stock | 3.56 | 3.56 | 3.42 | 3.43 | 7400.0 |
| 2015-08-05 | AAIC-DELISTED | Stock | 18.89 | 18.99 | 18.62 | 18.7 | 188149.0 |
| 2015-08-05 | AAL | Stock | 42.85 | 43.3 | 42.59 | 42.96 | 7581000.0 |
| 2015-08-05 | AAMC-DELISTED | Stock | 38.1471 | 39.4118 | 38.0662 | 39.3382 | 13692.0 |
| 2015-08-05 | AAMI | Stock | 17.35 | 17.49 | 16.96 | 17.06 | 166800.0 |
| 2015-08-05 | AAOI | Stock | 19.1 | 19.55 | 18.86 | 19.0 | 435800.0 |
| 2015-08-05 | AAON | Stock | 14.6867 | 14.82 | 14.54 | 14.64 | 212250.0 |
| 2015-08-05 | AAP | Stock | 175.52 | 177.22 | 174.09 | 175.27 | 810400.0 |
| 2015-08-05 | AAT | Stock | 41.08 | 41.68 | 40.13 | 40.37 | 369000.0 |
| 2015-08-05 | AAU-DELISTED | Stock | 0.74 | 0.74 | 0.6876 | 0.69 | 48919.0 |
| 2015-08-05 | AAUAF-DELISTED | Stock | 0.74 | 0.74 | 0.6876 | 0.69 | 49124.0 |
| 2015-08-05 | AAV-DELISTED | Stock | 5.68 | 5.92 | 5.6 | 5.61 | 67578.0 |
| 2015-08-05 | AAVL-DELISTED | Stock | 15.37 | 15.6 | 14.86 | 15.0 | 306042.0 |
| 2015-08-05 | AAWW-DELISTED | Stock | 47.99 | 48.86 | 46.973 | 47.61 | 396135.0 |
| 2015-08-05 | AAXJ | Stock | 59.09 | 59.23 | 58.71 | 58.82 | 998854.0 |
| 2015-08-05 | AAXN-DELISTED | Stock | 26.05 | 26.42 | 25.26 | 25.315 | 2339347.0 |
| 2015-08-05 | AB | Stock | 29.15 | 29.49 | 28.36 | 28.38 | 560500.0 |
| 2015-08-05 | ABAC-DELISTED | Stock | 1.09 | 1.1 | 0.99 | 1.1 | 23381.0 |
| 2015-08-05 | ABAX-DELISTED | Stock | 49.64 | 50.66 | 49.362 | 49.8 | 294464.0 |
| 2015-08-05 | ABB-DELISTED | Stock | 20.33 | 20.55 | 20.31 | 20.37 | 2471822.0 |
| 2015-08-05 | ABBNY-DELISTED | Stock | 20.33 | 20.55 | 20.31 | 20.37 | 2868126.0 |
| 2015-08-05 | ABBV | Stock | 70.1 | 70.64 | 70.05 | 70.3 | 10090200.0 |
| 2015-08-05 | ABC-DELISTED | Stock | 106.65 | 107.5 | 106.42 | 107.22 | 1342955.0 |
| 2015-08-05 | ABCB | Stock | 27.85 | 28.28 | 27.85 | 28.24 | 132500.0 |
| 2015-08-05 | ABCD-DELISTED | Stock | 4.8 | 4.9 | 4.7601 | 4.8 | 35155.0 |
| 2015-08-05 | ABCO-DELISTED | Stock | 54.0 | 54.0 | 46.92 | 46.99 | 2396573.0 |
| 2015-08-05 | ABCW-DELISTED | Stock | 39.33 | 40.0 | 39.07 | 39.72 | 10372.0 |
| 2015-08-05 | ABDC-DELISTED | Stock | 12.32 | 12.3688 | 12.12 | 12.13 | 30064.0 |
| 2015-08-05 | ABE-DELISTED | Stock | 12.5 | 12.65 | 12.4 | 12.5398 | 6586.0 |
| 2015-08-05 | ABEO | Stock | 170.75 | 175.0 | 157.5 | 159.25 | 17596.0 |
| 2015-08-05 | ABEOW-DELISTED | Stock | 2.3 | 2.8 | 2.3 | 2.4 | 8647.0 |
| 2015-08-05 | ABEV | Stock | 5.63 | 5.72 | 5.63 | 5.7 | 13298200.0 |
| 2015-08-05 | ABG | Stock | 84.81 | 86.59 | 84.65 | 85.8 | 480600.0 |
| 2015-08-05 | ABGB-DELISTED | Stock | 6.16 | 6.24 | 5.8 | 5.95 | 355261.0 |
| 2015-08-05 | ABIL-DELISTED | Stock | 10.05 | 10.05 | 9.95 | 9.95 | 3000.0 |
| 2015-08-05 | ABM | Stock | 33.14 | 33.47 | 32.72 | 33.24 | 223100.0 |
> showing 50 of 6,667 rows — these rows as CSV