PREVIEW / stock_daily / 2015-12-04
file: by_date/stock_daily/2015/2015-12-04.parquet size: 222 KB rows: 6,623 symbols: 3,394
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-04 | AAPL | Stock | 28.8225 | 29.8125 | 28.7775 | 29.7575 | 231108000.0 |
| 2015-12-04 | MSFT | Stock | 54.12 | 56.23 | 54.1 | 55.91 | 43963700.0 |
| 2015-12-04 | NVDA | Stock | 0.8108 | 0.8452 | 0.8108 | 0.8438 | 458756000.0 |
| 2015-12-04 | AMZN | Stock | 33.3 | 33.739 | 33.07 | 33.632 | 90696000.0 |
| 2015-12-04 | GOOGL | Stock | 38.4855 | 39.121 | 38.2755 | 38.9605 | 49799960.0 |
| 2015-12-04 | META | Stock | 104.81 | 107.73 | 104.11 | 106.18 | 21224700.0 |
| 2015-12-04 | TSLA | Stock | 15.4973 | 15.5513 | 15.1773 | 15.3587 | 38604000.0 |
| 2015-12-04 | TLT | Stock | 119.53 | 120.93 | 119.47 | 120.58 | 11843829.0 |
| 2015-12-04 | ES | Stock | 49.65 | 50.67 | 49.51 | 50.63 | 1300600.0 |
| 2015-12-04 | CL | Stock | 65.97 | 66.76 | 65.7 | 66.34 | 4603800.0 |
| 2015-12-04 | A | Stock | 40.23 | 41.21 | 40.13 | 41.1 | 2519100.0 |
| 2015-12-04 | AA.B-DELISTED | Stock | 31.35 | 32.3099 | 31.33 | 32.2999 | 43159.0 |
| 2015-12-04 | AAAP-DELISTED | Stock | 26.21 | 26.64 | 26.016 | 26.5 | 7632.0 |
| 2015-12-04 | AABA-DELISTED | Stock | 34.34 | 35.2 | 34.18 | 34.9 | 14756642.0 |
| 2015-12-04 | AAC-DELISTED | Stock | 22.84 | 23.67 | 21.5901 | 22.49 | 264648.0 |
| 2015-12-04 | AACG | Stock | 5.33 | 5.85 | 5.17 | 5.51 | 27200.0 |
| 2015-12-04 | AAIC-DELISTED | Stock | 13.46 | 13.62 | 13.44 | 13.52 | 261793.0 |
| 2015-12-04 | AAL | Stock | 43.82 | 44.99 | 43.82 | 44.97 | 9460900.0 |
| 2015-12-04 | AAMC-DELISTED | Stock | 4.6176 | 4.9635 | 4.2735 | 4.3088 | 79115.0 |
| 2015-12-04 | AAME | Stock | 4.75 | 4.75 | 4.72 | 4.75 | 1500.0 |
| 2015-12-04 | AAMI | Stock | 15.8 | 15.94 | 15.73 | 15.81 | 353700.0 |
| 2015-12-04 | AAOI | Stock | 17.83 | 18.11 | 17.51 | 17.98 | 279600.0 |
| 2015-12-04 | AAON | Stock | 15.8333 | 16.4067 | 15.8 | 16.3533 | 247050.0 |
| 2015-12-04 | AAP | Stock | 155.06 | 156.33 | 154.18 | 155.83 | 996300.0 |
| 2015-12-04 | AAT | Stock | 38.5 | 39.46 | 38.5 | 39.13 | 169400.0 |
| 2015-12-04 | AAU-DELISTED | Stock | 0.515 | 0.547 | 0.515 | 0.5431 | 58451.0 |
| 2015-12-04 | AAUAF-DELISTED | Stock | 0.515 | 0.547 | 0.515 | 0.5431 | 58841.0 |
| 2015-12-04 | AAV-DELISTED | Stock | 4.96 | 4.99 | 4.81 | 4.81 | 79513.0 |
| 2015-12-04 | AAVL-DELISTED | Stock | 9.29 | 9.56 | 9.19 | 9.38 | 160530.0 |
| 2015-12-04 | AAWW-DELISTED | Stock | 40.71 | 41.585 | 40.255 | 41.27 | 203686.0 |
| 2015-12-04 | AAXJ | Stock | 54.94 | 55.76 | 54.79 | 55.66 | 2852291.0 |
| 2015-12-04 | AAXN-DELISTED | Stock | 17.68 | 17.97 | 17.46 | 17.78 | 1264506.0 |
| 2015-12-04 | AB | Stock | 23.83 | 24.52 | 23.64 | 24.37 | 339800.0 |
| 2015-12-04 | ABAC-DELISTED | Stock | 0.901 | 1.21 | 0.88 | 1.184 | 85892.0 |
| 2015-12-04 | ABAX-DELISTED | Stock | 53.92 | 54.5 | 53.54 | 54.31 | 59073.0 |
| 2015-12-04 | ABB-DELISTED | Stock | 18.53 | 18.75 | 18.51 | 18.72 | 2128074.0 |
| 2015-12-04 | ABBNY-DELISTED | Stock | 18.53 | 18.75 | 18.51 | 18.73 | 2273414.0 |
| 2015-12-04 | ABBV | Stock | 56.5 | 57.48 | 56.2 | 57.18 | 6748100.0 |
| 2015-12-04 | ABC-DELISTED | Stock | 99.12 | 100.4 | 98.54 | 99.86 | 1504493.0 |
| 2015-12-04 | ABCB | Stock | 34.12 | 34.93 | 34.04 | 34.88 | 161200.0 |
| 2015-12-04 | ABCD-DELISTED | Stock | 5.09 | 5.14 | 5.02 | 5.11 | 31436.0 |
| 2015-12-04 | ABCO-DELISTED | Stock | 52.24 | 53.125 | 51.98 | 52.96 | 149208.0 |
| 2015-12-04 | ABCW-DELISTED | Stock | 41.35 | 43.8599 | 41.35 | 43.72 | 194688.0 |
| 2015-12-04 | ABDC-DELISTED | Stock | 12.36 | 12.73 | 12.0285 | 12.11 | 25631.0 |
| 2015-12-04 | ABE-DELISTED | Stock | 11.1 | 11.12 | 11.1 | 11.12 | 1101.0 |
| 2015-12-04 | ABEO | Stock | 102.25 | 105.25 | 100.25 | 101.25 | 2508.0 |
| 2015-12-04 | ABEOW-DELISTED | Stock | 1.41 | 1.464 | 1.25 | 1.33 | 4601.0 |
| 2015-12-04 | ABEV | Stock | 4.92 | 5.03 | 4.87 | 4.87 | 14952700.0 |
| 2015-12-04 | ABG | Stock | 73.09 | 74.2 | 73.09 | 73.81 | 162400.0 |
| 2015-12-04 | ABGB-DELISTED | Stock | 2.09 | 2.29 | 2.08 | 2.24 | 130770.0 |
> showing 50 of 6,623 rows — these rows as CSV