PREVIEW / stock_daily / 2015-12-24
file: by_date/stock_daily/2015/2015-12-24.parquet size: 214 KB rows: 6,494 symbols: 3,318
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-24 | AAPL | Stock | 27.25 | 27.25 | 26.9875 | 27.0075 | 54281600.0 |
| 2015-12-24 | MSFT | Stock | 55.86 | 55.96 | 55.43 | 55.67 | 9558500.0 |
| 2015-12-24 | NVDA | Stock | 0.824 | 0.8312 | 0.8228 | 0.8292 | 52448000.0 |
| 2015-12-24 | AMZN | Stock | 33.1675 | 33.234 | 33.03 | 33.1395 | 21824000.0 |
| 2015-12-24 | GOOGL | Stock | 38.426 | 38.46 | 38.2195 | 38.292 | 10422820.0 |
| 2015-12-24 | META | Stock | 104.74 | 105.32 | 104.5 | 105.02 | 6501800.0 |
| 2015-12-24 | TSLA | Stock | 15.3707 | 15.4587 | 15.2187 | 15.3713 | 10620000.0 |
| 2015-12-24 | TLT | Stock | 121.47 | 121.87 | 121.4 | 121.83 | 3364567.0 |
| 2015-12-24 | ES | Stock | 51.61 | 51.92 | 51.46 | 51.74 | 672600.0 |
| 2015-12-24 | CL | Stock | 67.0 | 67.28 | 66.86 | 66.99 | 882100.0 |
| 2015-12-24 | A | Stock | 41.79 | 42.26 | 41.67 | 42.14 | 874500.0 |
| 2015-12-24 | AA.B-DELISTED | Stock | 34.26 | 34.26 | 33.41 | 33.96 | 40421.0 |
| 2015-12-24 | AAAP-DELISTED | Stock | 30.47 | 30.47 | 29.4501 | 29.83 | 7621.0 |
| 2015-12-24 | AABA-DELISTED | Stock | 34.19 | 34.74 | 34.1 | 34.11 | 3246107.0 |
| 2015-12-24 | AAC-DELISTED | Stock | 18.63 | 19.64 | 18.63 | 19.23 | 87313.0 |
| 2015-12-24 | AACG | Stock | 6.19 | 6.8 | 6.19 | 6.72 | 99000.0 |
| 2015-12-24 | AAIC-DELISTED | Stock | 14.52 | 14.69 | 14.5 | 14.63 | 172450.0 |
| 2015-12-24 | AAL | Stock | 43.27 | 44.19 | 43.11 | 43.81 | 3307000.0 |
| 2015-12-24 | AAMC-DELISTED | Stock | 5.6618 | 6.0235 | 5.4088 | 5.9706 | 143789.0 |
| 2015-12-24 | AAME | Stock | 4.68 | 4.75 | 4.68 | 4.74 | 1000.0 |
| 2015-12-24 | AAMI | Stock | 15.27 | 15.34 | 15.15 | 15.3 | 28100.0 |
| 2015-12-24 | AAOI | Stock | 17.18 | 17.73 | 17.09 | 17.58 | 149300.0 |
| 2015-12-24 | AAON | Stock | 15.5933 | 15.8667 | 15.3333 | 15.7867 | 153000.0 |
| 2015-12-24 | AAP | Stock | 148.28 | 150.32 | 148.27 | 149.13 | 381700.0 |
| 2015-12-24 | AAT | Stock | 38.6 | 39.01 | 38.47 | 38.85 | 52700.0 |
| 2015-12-24 | AAU-DELISTED | Stock | 0.68 | 0.7 | 0.65 | 0.666 | 104705.0 |
| 2015-12-24 | AAUAF-DELISTED | Stock | 0.68 | 0.7 | 0.65 | 0.666 | 105521.0 |
| 2015-12-24 | AAV-DELISTED | Stock | 4.97 | 5.0 | 4.91 | 4.93 | 16646.0 |
| 2015-12-24 | AAVL-DELISTED | Stock | 9.37 | 9.62 | 9.3555 | 9.55 | 119831.0 |
| 2015-12-24 | AAWW-DELISTED | Stock | 43.4 | 43.82 | 42.41 | 43.77 | 97849.0 |
| 2015-12-24 | AAXJ | Stock | 55.52 | 55.52 | 53.97 | 54.48 | 381108.0 |
| 2015-12-24 | AAXN-DELISTED | Stock | 17.93 | 18.2255 | 17.62 | 17.84 | 566737.0 |
| 2015-12-24 | AB | Stock | 25.0 | 25.07 | 24.59 | 24.86 | 476500.0 |
| 2015-12-24 | ABAC-DELISTED | Stock | 0.91 | 0.93 | 0.88 | 0.9199 | 1929.0 |
| 2015-12-24 | ABAX-DELISTED | Stock | 54.75 | 56.02 | 53.7474 | 54.97 | 78416.0 |
| 2015-12-24 | ABB-DELISTED | Stock | 18.03 | 18.18 | 18.03 | 18.13 | 514742.0 |
| 2015-12-24 | ABBNY-DELISTED | Stock | 18.03 | 18.18 | 18.03 | 18.13 | 528404.0 |
| 2015-12-24 | ABBV | Stock | 58.38 | 58.73 | 58.0 | 58.46 | 2152900.0 |
| 2015-12-24 | ABC-DELISTED | Stock | 103.71 | 104.19 | 103.52 | 103.98 | 381363.0 |
| 2015-12-24 | ABCB | Stock | 34.0 | 34.42 | 33.93 | 34.16 | 168800.0 |
| 2015-12-24 | ABCD-DELISTED | Stock | 5.14 | 5.14 | 5.02 | 5.06 | 6307.0 |
| 2015-12-24 | ABCO-DELISTED | Stock | 50.25 | 50.61 | 49.53 | 50.12 | 55723.0 |
| 2015-12-24 | ABCW-DELISTED | Stock | 44.26 | 44.71 | 43.95 | 43.99 | 4085.0 |
| 2015-12-24 | ABDC-DELISTED | Stock | 12.315 | 12.32 | 11.85 | 12.09 | 35407.0 |
| 2015-12-24 | ABE-DELISTED | Stock | 10.78 | 10.95 | 10.78 | 10.9105 | 5001.0 |
| 2015-12-24 | ABEO | Stock | 90.0 | 92.5 | 90.0 | 91.25 | 816.0 |
| 2015-12-24 | ABEV | Stock | 4.58 | 4.62 | 4.54 | 4.57 | 3627800.0 |
| 2015-12-24 | ABG | Stock | 68.86 | 69.29 | 68.18 | 68.9 | 108900.0 |
| 2015-12-24 | ABGB-DELISTED | Stock | 1.51 | 1.61 | 1.5 | 1.54 | 26314.0 |
| 2015-12-24 | ABIL-DELISTED | Stock | 9.5 | 9.5 | 8.94 | 9.0 | 22600.0 |
> showing 50 of 6,494 rows — these rows as CSV