PREVIEW / stock_daily / 2015-04-28
file: by_date/stock_daily/2015/2015-04-28.parquet size: 224 KB rows: 6,640 symbols: 3,505
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-04-28 | AAPL | Stock | 33.615 | 33.635 | 32.3925 | 32.64 | 475696000.0 |
| 2015-04-28 | MSFT | Stock | 47.78 | 49.21 | 47.7 | 49.16 | 60730800.0 |
| 2015-04-28 | NVDA | Stock | 0.554 | 0.5598 | 0.5488 | 0.5578 | 234484000.0 |
| 2015-04-28 | AMZN | Stock | 21.9255 | 21.95 | 21.402 | 21.4655 | 82810000.0 |
| 2015-04-28 | GOOGL | Stock | 28.216 | 28.3915 | 28.048 | 28.2185 | 37195740.0 |
| 2015-04-28 | META | Stock | 81.83 | 81.9 | 80.23 | 80.68 | 23775300.0 |
| 2015-04-28 | TSLA | Stock | 15.65 | 15.7 | 15.202 | 15.3653 | 91281000.0 |
| 2015-04-28 | TLT | Stock | 128.17 | 128.74 | 127.26 | 127.29 | 7464325.0 |
| 2015-04-28 | ES | Stock | 49.6 | 50.44 | 49.43 | 50.39 | 1119900.0 |
| 2015-04-28 | CL | Stock | 68.79 | 69.18 | 68.43 | 68.77 | 2420700.0 |
| 2015-04-28 | A | Stock | 41.87 | 42.31 | 41.57 | 42.18 | 1803500.0 |
| 2015-04-28 | AA.B-DELISTED | Stock | 45.78 | 46.05 | 45.36 | 45.5761 | 42941.0 |
| 2015-04-28 | AABA-DELISTED | Stock | 44.34 | 44.57 | 43.935 | 44.34 | 6737711.0 |
| 2015-04-28 | AAC-DELISTED | Stock | 31.15 | 31.79 | 30.61 | 31.77 | 157893.0 |
| 2015-04-28 | AACG | Stock | 4.71 | 4.71 | 4.6 | 4.6 | 17900.0 |
| 2015-04-28 | AAIC-DELISTED | Stock | 21.88 | 22.25 | 21.0 | 22.04 | 1593135.0 |
| 2015-04-28 | AAL | Stock | 51.7 | 51.82 | 50.01 | 51.19 | 9235700.0 |
| 2015-04-28 | AAMC-DELISTED | Stock | 62.3206 | 63.9471 | 61.3147 | 63.7618 | 19856.0 |
| 2015-04-28 | AAME | Stock | 3.96 | 3.97 | 3.96 | 3.97 | 1200.0 |
| 2015-04-28 | AAMI | Stock | 19.41 | 19.71 | 19.32 | 19.68 | 53600.0 |
| 2015-04-28 | AAOI | Stock | 14.81 | 15.15 | 14.642 | 15.1 | 146900.0 |
| 2015-04-28 | AAON | Stock | 16.4467 | 16.6867 | 16.3267 | 16.6333 | 148500.0 |
| 2015-04-28 | AAP | Stock | 145.0 | 145.23 | 143.0 | 144.5 | 794300.0 |
| 2015-04-28 | AAT | Stock | 41.65 | 41.73 | 41.2 | 41.59 | 99000.0 |
| 2015-04-28 | AAU-DELISTED | Stock | 0.822 | 0.8308 | 0.818 | 0.818 | 127318.0 |
| 2015-04-28 | AAUAF-DELISTED | Stock | 0.8234 | 0.8322 | 0.8193 | 0.8193 | 127509.0 |
| 2015-04-28 | AAV-DELISTED | Stock | 5.94 | 6.02 | 5.94 | 6.01 | 65191.0 |
| 2015-04-28 | AAVL-DELISTED | Stock | 35.43 | 36.56 | 34.0 | 36.34 | 263887.0 |
| 2015-04-28 | AAWW-DELISTED | Stock | 42.32 | 43.56 | 42.32 | 43.56 | 119323.0 |
| 2015-04-28 | AAXJ | Stock | 69.82 | 69.91 | 69.5 | 69.835 | 1445525.0 |
| 2015-04-28 | AAXN-DELISTED | Stock | 28.85 | 29.35 | 28.05 | 28.89 | 2859355.0 |
| 2015-04-28 | AB | Stock | 31.29 | 31.6 | 31.09 | 31.35 | 167100.0 |
| 2015-04-28 | ABAC-DELISTED | Stock | 1.78 | 1.78 | 1.69 | 1.7 | 31095.0 |
| 2015-04-28 | ABAX-DELISTED | Stock | 62.84 | 64.66 | 62.2102 | 64.57 | 208747.0 |
| 2015-04-28 | ABB-DELISTED | Stock | 21.83 | 22.085 | 21.78 | 22.06 | 2691377.0 |
| 2015-04-28 | ABBNY-DELISTED | Stock | 21.82 | 22.085 | 21.78 | 22.06 | 3142082.0 |
| 2015-04-28 | ABBV | Stock | 64.6 | 66.49 | 64.2 | 66.49 | 13084900.0 |
| 2015-04-28 | ABC-DELISTED | Stock | 114.0 | 114.62 | 112.61 | 113.99 | 1145184.0 |
| 2015-04-28 | ABCB | Stock | 24.9 | 25.51 | 24.9 | 25.46 | 73500.0 |
| 2015-04-28 | ABCD-DELISTED | Stock | 3.0 | 3.08 | 2.99 | 3.07 | 18941.0 |
| 2015-04-28 | ABCO-DELISTED | Stock | 52.42 | 53.63 | 52.36 | 53.25 | 131342.0 |
| 2015-04-28 | ABCW-DELISTED | Stock | 34.56 | 35.0 | 34.55 | 35.0 | 205326.0 |
| 2015-04-28 | ABDC-DELISTED | Stock | 13.84 | 13.9 | 13.7 | 13.88 | 39607.0 |
| 2015-04-28 | ABE-DELISTED | Stock | 13.4158 | 13.4158 | 13.4116 | 13.4149 | 1226.0 |
| 2015-04-28 | ABEO | Stock | 87.0 | 87.25 | 80.75 | 81.0 | 7672.0 |
| 2015-04-28 | ABEOW-DELISTED | Stock | 1.49 | 1.49 | 1.42 | 1.42 | 300.0 |
| 2015-04-28 | ABEV | Stock | 6.5 | 6.51 | 6.41 | 6.43 | 9313800.0 |
| 2015-04-28 | ABG | Stock | 86.49 | 86.7 | 84.97 | 86.64 | 280600.0 |
| 2015-04-28 | ABGB-DELISTED | Stock | 16.65 | 16.73 | 16.505 | 16.62 | 8630.0 |
| 2015-04-28 | ABIL-DELISTED | Stock | 9.69 | 10.11 | 9.69 | 10.11 | 1110.0 |
> showing 50 of 6,640 rows — these rows as CSV