PREVIEW / stock_daily / 2015-04-24
file: by_date/stock_daily/2015/2015-04-24.parquet size: 223 KB rows: 6,654 symbols: 3,517
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-24 | AAPL | Stock | 32.6225 | 32.6575 | 32.3075 | 32.57 | 178103600.0 |
| 2015-04-24 | MSFT | Stock | 45.66 | 48.14 | 45.65 | 47.87 | 130933700.0 |
| 2015-04-24 | NVDA | Stock | 0.5552 | 0.5555 | 0.5445 | 0.5508 | 240960000.0 |
| 2015-04-24 | AMZN | Stock | 21.95 | 22.6325 | 21.95 | 22.255 | 343538000.0 |
| 2015-04-24 | GOOGL | Stock | 29.0025 | 29.235 | 28.4175 | 28.683 | 92168060.0 |
| 2015-04-24 | META | Stock | 82.77 | 82.94 | 81.48 | 81.53 | 29660400.0 |
| 2015-04-24 | TSLA | Stock | 14.7 | 14.72 | 14.534 | 14.562 | 36417000.0 |
| 2015-04-24 | TLT | Stock | 128.64 | 129.43 | 128.59 | 129.07 | 4773030.0 |
| 2015-04-24 | ES | Stock | 49.56 | 50.46 | 49.38 | 50.29 | 1634700.0 |
| 2015-04-24 | CL | Stock | 69.25 | 69.46 | 69.01 | 69.17 | 2282600.0 |
| 2015-04-24 | A | Stock | 42.71 | 42.81 | 42.42 | 42.49 | 2200200.0 |
| 2015-04-24 | AA.B-DELISTED | Stock | 45.15 | 45.7 | 44.81 | 44.9499 | 38975.0 |
| 2015-04-24 | AABA-DELISTED | Stock | 43.73 | 44.71 | 43.69 | 44.52 | 10512739.0 |
| 2015-04-24 | AAC-DELISTED | Stock | 33.0 | 33.25 | 32.16 | 32.41 | 39949.0 |
| 2015-04-24 | AACG | Stock | 4.7 | 4.87 | 4.7 | 4.84 | 33900.0 |
| 2015-04-24 | AAIC-DELISTED | Stock | 23.64 | 23.79 | 23.62 | 23.62 | 162405.0 |
| 2015-04-24 | AAL | Stock | 51.98 | 53.47 | 51.49 | 52.71 | 20248100.0 |
| 2015-04-24 | AAMC-DELISTED | Stock | 65.3088 | 65.3088 | 62.5735 | 64.1147 | 56749.0 |
| 2015-04-24 | AAME | Stock | 3.96 | 3.96 | 3.96 | 3.96 | 900.0 |
| 2015-04-24 | AAMI | Stock | 19.264 | 19.44 | 19.15 | 19.38 | 38800.0 |
| 2015-04-24 | AAOI | Stock | 14.96 | 15.09 | 14.58 | 14.85 | 122600.0 |
| 2015-04-24 | AAON | Stock | 16.6667 | 16.6667 | 16.4067 | 16.44 | 160650.0 |
| 2015-04-24 | AAP | Stock | 144.82 | 148.74 | 143.2 | 148.61 | 1441600.0 |
| 2015-04-24 | AAT | Stock | 41.48 | 41.67 | 41.21 | 41.49 | 271300.0 |
| 2015-04-24 | AAU-DELISTED | Stock | 0.82 | 0.8226 | 0.7992 | 0.8008 | 81031.0 |
| 2015-04-24 | AAUAF-DELISTED | Stock | 0.82 | 0.8234 | 0.8 | 0.8016 | 81809.0 |
| 2015-04-24 | AAV-DELISTED | Stock | 6.01 | 6.02 | 5.889 | 5.97 | 183788.0 |
| 2015-04-24 | AAVL-DELISTED | Stock | 38.62 | 39.71 | 37.39 | 37.66 | 149083.0 |
| 2015-04-24 | AAWW-DELISTED | Stock | 43.18 | 43.43 | 42.26 | 43.04 | 83955.0 |
| 2015-04-24 | AAXJ | Stock | 69.7 | 69.7 | 69.45 | 69.505 | 779240.0 |
| 2015-04-24 | AAXN-DELISTED | Stock | 29.63 | 30.0 | 29.51 | 29.67 | 1211563.0 |
| 2015-04-24 | AB | Stock | 31.77 | 31.9 | 31.56 | 31.69 | 217200.0 |
| 2015-04-24 | ABAC-DELISTED | Stock | 1.69 | 1.72 | 1.69 | 1.72 | 4231.0 |
| 2015-04-24 | ABAX-DELISTED | Stock | 63.57 | 63.91 | 63.2999 | 63.62 | 60835.0 |
| 2015-04-24 | ABB-DELISTED | Stock | 21.66 | 21.73 | 21.57 | 21.69 | 1115453.0 |
| 2015-04-24 | ABBNY-DELISTED | Stock | 21.66 | 21.73 | 21.57 | 21.69 | 1458987.0 |
| 2015-04-24 | ABBV | Stock | 64.31 | 66.37 | 64.14 | 66.07 | 14859500.0 |
| 2015-04-24 | ABC-DELISTED | Stock | 115.1 | 115.98 | 114.19 | 115.5 | 716537.0 |
| 2015-04-24 | ABCB | Stock | 25.07 | 25.38 | 24.46 | 24.82 | 131200.0 |
| 2015-04-24 | ABCD-DELISTED | Stock | 3.0 | 3.146 | 2.97 | 3.085 | 100713.0 |
| 2015-04-24 | ABCO-DELISTED | Stock | 51.82 | 52.39 | 50.87 | 52.24 | 205760.0 |
| 2015-04-24 | ABCW-DELISTED | Stock | 34.16 | 34.5 | 33.98 | 34.345 | 8270.0 |
| 2015-04-24 | ABDC-DELISTED | Stock | 13.8232 | 13.9 | 13.66 | 13.75 | 29085.0 |
| 2015-04-24 | ABE-DELISTED | Stock | 13.51 | 13.51 | 13.45 | 13.45 | 7016.0 |
| 2015-04-24 | ABEO | Stock | 92.5 | 96.75 | 89.0 | 94.5 | 17080.0 |
| 2015-04-24 | ABEOW-DELISTED | Stock | 1.6 | 1.605 | 1.52 | 1.52 | 21395.0 |
| 2015-04-24 | ABEV | Stock | 6.36 | 6.44 | 6.33 | 6.4 | 22892400.0 |
| 2015-04-24 | ABG | Stock | 87.83 | 88.25 | 87.01 | 87.79 | 241200.0 |
| 2015-04-24 | ABGB-DELISTED | Stock | 16.19 | 16.46 | 16.04 | 16.33 | 29629.0 |
| 2015-04-24 | ABIL-DELISTED | Stock | 10.74 | 10.74 | 10.1 | 10.13 | 57655.0 |
> showing 50 of 6,654 rows — these rows as CSV