PREVIEW / stock_daily / 2015-05-08
file: by_date/stock_daily/2015/2015-05-08.parquet size: 223 KB rows: 6,651 symbols: 3,494
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-08 | AAPL | Stock | 31.67 | 31.905 | 31.5275 | 31.905 | 222201600.0 |
| 2015-05-08 | MSFT | Stock | 47.55 | 47.98 | 47.52 | 47.75 | 35364900.0 |
| 2015-05-08 | NVDA | Stock | 0.5253 | 0.546 | 0.5122 | 0.5207 | 1146552000.0 |
| 2015-05-08 | AMZN | Stock | 21.5375 | 21.76 | 21.5085 | 21.6845 | 58176000.0 |
| 2015-05-08 | GOOGL | Stock | 27.4435 | 27.64 | 27.4015 | 27.4475 | 28225280.0 |
| 2015-05-08 | META | Stock | 79.1 | 79.23 | 78.03 | 78.51 | 19943600.0 |
| 2015-05-08 | TSLA | Stock | 15.7327 | 15.894 | 15.58 | 15.774 | 70023000.0 |
| 2015-05-08 | TLT | Stock | 123.38 | 123.55 | 122.31 | 122.51 | 11716437.0 |
| 2015-05-08 | ES | Stock | 48.26 | 48.7 | 48.03 | 48.46 | 2324600.0 |
| 2015-05-08 | CL | Stock | 68.5 | 68.64 | 67.98 | 68.2 | 3029900.0 |
| 2015-05-08 | A | Stock | 42.23 | 42.53 | 42.21 | 42.5 | 1033800.0 |
| 2015-05-08 | AA.B-DELISTED | Stock | 46.58 | 46.78 | 46.17 | 46.65 | 48995.0 |
| 2015-05-08 | AABA-DELISTED | Stock | 44.34 | 44.55 | 44.0 | 44.065 | 15012513.0 |
| 2015-05-08 | AAC-DELISTED | Stock | 31.39 | 31.72 | 30.88 | 31.7 | 79950.0 |
| 2015-05-08 | AACG | Stock | 4.54 | 4.8 | 4.53 | 4.72 | 6500.0 |
| 2015-05-08 | AAIC-DELISTED | Stock | 21.34 | 21.34 | 21.13 | 21.16 | 258576.0 |
| 2015-05-08 | AAL | Stock | 49.23 | 49.83 | 48.93 | 49.04 | 6478200.0 |
| 2015-05-08 | AAMC-DELISTED | Stock | 68.4265 | 68.4265 | 56.2324 | 60.1912 | 38005.0 |
| 2015-05-08 | AAME | Stock | 3.9 | 3.96 | 3.85 | 3.93 | 5800.0 |
| 2015-05-08 | AAMI | Stock | 19.46 | 19.75 | 19.32 | 19.59 | 62700.0 |
| 2015-05-08 | AAOI | Stock | 14.5 | 15.4 | 14.0 | 15.14 | 566000.0 |
| 2015-05-08 | AAON | Stock | 15.4067 | 15.4067 | 15.0667 | 15.1733 | 196050.0 |
| 2015-05-08 | AAP | Stock | 145.46 | 147.0 | 144.37 | 144.76 | 579700.0 |
| 2015-05-08 | AAT | Stock | 40.55 | 41.23 | 40.2 | 40.4 | 631800.0 |
| 2015-05-08 | AAU-DELISTED | Stock | 0.76 | 0.8144 | 0.7579 | 0.8 | 63423.0 |
| 2015-05-08 | AAUAF-DELISTED | Stock | 0.77 | 0.8275 | 0.77 | 0.8 | 62917.0 |
| 2015-05-08 | AAV-DELISTED | Stock | 5.88 | 6.11 | 5.78 | 6.08 | 117563.0 |
| 2015-05-08 | AAVL-DELISTED | Stock | 33.45 | 33.9 | 32.1 | 32.43 | 205644.0 |
| 2015-05-08 | AAWW-DELISTED | Stock | 57.4 | 57.67 | 56.43 | 56.5 | 568549.0 |
| 2015-05-08 | AAXJ | Stock | 67.54 | 67.93 | 67.54 | 67.715 | 2263227.0 |
| 2015-05-08 | AAXN-DELISTED | Stock | 32.79 | 32.89 | 31.12 | 31.93 | 4602766.0 |
| 2015-05-08 | AB | Stock | 31.72 | 31.77 | 31.16 | 31.17 | 155100.0 |
| 2015-05-08 | ABAC-DELISTED | Stock | 1.57 | 1.62 | 1.54 | 1.6199 | 17090.0 |
| 2015-05-08 | ABAX-DELISTED | Stock | 55.0 | 55.8 | 53.95 | 54.24 | 177342.0 |
| 2015-05-08 | ABB-DELISTED | Stock | 21.89 | 21.98 | 21.85 | 21.89 | 1778672.0 |
| 2015-05-08 | ABBNY-DELISTED | Stock | 21.89 | 21.98 | 21.85 | 21.89 | 1907737.0 |
| 2015-05-08 | ABBV | Stock | 65.1 | 65.8 | 64.9 | 65.24 | 7541100.0 |
| 2015-05-08 | ABC-DELISTED | Stock | 114.54 | 116.0 | 114.53 | 115.27 | 2257008.0 |
| 2015-05-08 | ABCB | Stock | 25.37 | 25.47 | 25.07 | 25.14 | 81700.0 |
| 2015-05-08 | ABCD-DELISTED | Stock | 3.055 | 3.07 | 2.95 | 2.97 | 9952.0 |
| 2015-05-08 | ABCO-DELISTED | Stock | 50.0 | 50.0 | 48.62 | 48.98 | 246678.0 |
| 2015-05-08 | ABCW-DELISTED | Stock | 36.65 | 36.81 | 35.7 | 36.28 | 15197.0 |
| 2015-05-08 | ABDC-DELISTED | Stock | 13.73 | 13.81 | 13.45 | 13.8 | 56963.0 |
| 2015-05-08 | ABE-DELISTED | Stock | 13.16 | 13.23 | 12.98 | 13.23 | 2846.0 |
| 2015-05-08 | ABEO | Stock | 183.75 | 198.75 | 166.5 | 183.5 | 273012.0 |
| 2015-05-08 | ABEOW-DELISTED | Stock | 2.78 | 3.11 | 2.1 | 2.5 | 236310.0 |
| 2015-05-08 | ABEV | Stock | 6.53 | 6.68 | 6.5 | 6.67 | 20097900.0 |
| 2015-05-08 | ABG | Stock | 85.69 | 86.74 | 85.02 | 85.84 | 319300.0 |
| 2015-05-08 | ABGB-DELISTED | Stock | 16.19 | 16.27 | 16.0567 | 16.27 | 12805.0 |
| 2015-05-08 | ABIL-DELISTED | Stock | 9.95 | 9.97 | 9.95 | 9.955 | 11100.0 |
> showing 50 of 6,651 rows — these rows as CSV