PREVIEW / stock_daily / 2015-12-21
file: by_date/stock_daily/2015/2015-12-21.parquet size: 222 KB rows: 6,648 symbols: 3,408
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-12-21 | AAPL | Stock | 26.82 | 26.8425 | 26.3925 | 26.8325 | 190362400.0 |
| 2015-12-21 | MSFT | Stock | 54.88 | 55.35 | 54.23 | 54.83 | 37246300.0 |
| 2015-12-21 | NVDA | Stock | 0.8123 | 0.8232 | 0.805 | 0.8225 | 284216000.0 |
| 2015-12-21 | AMZN | Stock | 33.425 | 33.495 | 32.9465 | 33.2255 | 65018000.0 |
| 2015-12-21 | GOOGL | Stock | 38.1525 | 38.3175 | 37.7075 | 38.04 | 34847360.0 |
| 2015-12-21 | META | Stock | 104.91 | 105.15 | 103.6 | 104.77 | 16138800.0 |
| 2015-12-21 | TSLA | Stock | 15.446 | 15.722 | 15.4053 | 15.504 | 29298000.0 |
| 2015-12-21 | TLT | Stock | 123.43 | 123.78 | 122.92 | 123.2 | 7494943.0 |
| 2015-12-21 | ES | Stock | 50.59 | 50.73 | 49.84 | 50.07 | 1550300.0 |
| 2015-12-21 | CL | Stock | 66.02 | 66.15 | 65.5 | 65.98 | 2725300.0 |
| 2015-12-21 | A | Stock | 40.51 | 41.12 | 40.44 | 40.83 | 1734500.0 |
| 2015-12-21 | AA.B-DELISTED | Stock | 31.54 | 31.812 | 31.5 | 31.6 | 239558.0 |
| 2015-12-21 | AAAP-DELISTED | Stock | 32.92 | 32.92 | 29.65 | 29.95 | 21919.0 |
| 2015-12-21 | AABA-DELISTED | Stock | 33.11 | 33.3 | 32.69 | 32.965 | 8652844.0 |
| 2015-12-21 | AAC-DELISTED | Stock | 22.09 | 22.09 | 18.25 | 21.2 | 1197619.0 |
| 2015-12-21 | AACG | Stock | 6.1 | 6.16 | 6.02 | 6.09 | 36800.0 |
| 2015-12-21 | AAIC-DELISTED | Stock | 14.53 | 14.64 | 14.05 | 14.12 | 327099.0 |
| 2015-12-21 | AAL | Stock | 41.35 | 42.43 | 41.35 | 42.4 | 6597500.0 |
| 2015-12-21 | AAMC-DELISTED | Stock | 4.4382 | 4.7059 | 4.3941 | 4.5147 | 212925.0 |
| 2015-12-21 | AAME | Stock | 4.66 | 4.74 | 4.66 | 4.74 | 2100.0 |
| 2015-12-21 | AAMI | Stock | 14.82 | 14.98 | 14.75 | 14.97 | 135300.0 |
| 2015-12-21 | AAOI | Stock | 17.14 | 17.36 | 16.85 | 17.0 | 263000.0 |
| 2015-12-21 | AAON | Stock | 15.2533 | 15.4467 | 15.1267 | 15.2333 | 155850.0 |
| 2015-12-21 | AAP | Stock | 150.81 | 151.49 | 148.25 | 149.65 | 1131500.0 |
| 2015-12-21 | AAT | Stock | 38.46 | 38.72 | 38.16 | 38.41 | 158400.0 |
| 2015-12-21 | AAU-DELISTED | Stock | 0.62 | 0.62 | 0.58 | 0.615 | 111374.0 |
| 2015-12-21 | AAUAF-DELISTED | Stock | 0.62 | 0.62 | 0.58 | 0.61 | 112895.0 |
| 2015-12-21 | AAV-DELISTED | Stock | 4.66 | 4.77 | 4.58 | 4.68 | 56365.0 |
| 2015-12-21 | AAVL-DELISTED | Stock | 9.31 | 9.69 | 8.99 | 9.69 | 196391.0 |
| 2015-12-21 | AAWW-DELISTED | Stock | 40.0 | 41.52 | 39.75 | 41.42 | 190265.0 |
| 2015-12-21 | AAXJ | Stock | 53.97 | 54.0 | 53.34 | 53.67 | 2355220.0 |
| 2015-12-21 | AAXN-DELISTED | Stock | 17.08 | 18.1 | 17.01 | 17.94 | 1670478.0 |
| 2015-12-21 | AB | Stock | 23.3 | 24.18 | 23.3 | 23.93 | 283400.0 |
| 2015-12-21 | ABAC-DELISTED | Stock | 0.9542 | 0.98 | 0.9542 | 0.9601 | 6600.0 |
| 2015-12-21 | ABAX-DELISTED | Stock | 51.69 | 53.21 | 51.09 | 52.55 | 153114.0 |
| 2015-12-21 | ABB-DELISTED | Stock | 17.62 | 17.65 | 17.46 | 17.54 | 2363745.0 |
| 2015-12-21 | ABBNY-DELISTED | Stock | 17.62 | 17.65 | 17.46 | 17.55 | 2414217.0 |
| 2015-12-21 | ABBV | Stock | 56.0 | 56.26 | 55.7 | 56.2 | 4572100.0 |
| 2015-12-21 | ABC-DELISTED | Stock | 102.17 | 102.92 | 101.61 | 102.89 | 1480006.0 |
| 2015-12-21 | ABCB | Stock | 33.15 | 34.01 | 33.15 | 33.44 | 232000.0 |
| 2015-12-21 | ABCD-DELISTED | Stock | 5.13 | 5.16 | 5.11 | 5.16 | 19955.0 |
| 2015-12-21 | ABCO-DELISTED | Stock | 49.18 | 49.98 | 48.71 | 49.14 | 175580.0 |
| 2015-12-21 | ABCW-DELISTED | Stock | 45.15 | 45.56 | 44.6 | 45.05 | 20227.0 |
| 2015-12-21 | ABDC-DELISTED | Stock | 11.41 | 11.645 | 11.05 | 11.47 | 16495.0 |
| 2015-12-21 | ABE-DELISTED | Stock | 10.78 | 10.835 | 10.68 | 10.8001 | 2954.0 |
| 2015-12-21 | ABEO | Stock | 90.75 | 90.75 | 85.75 | 88.5 | 2372.0 |
| 2015-12-21 | ABEOW-DELISTED | Stock | 1.25 | 1.57 | 0.89 | 1.36 | 5224.0 |
| 2015-12-21 | ABEV | Stock | 4.51 | 4.57 | 4.43 | 4.45 | 12148400.0 |
| 2015-12-21 | ABG | Stock | 67.05 | 68.37 | 66.79 | 68.3 | 604500.0 |
| 2015-12-21 | ABGB-DELISTED | Stock | 1.62 | 1.62 | 1.5 | 1.51 | 26639.0 |
> showing 50 of 6,648 rows — these rows as CSV