PREVIEW / stock_daily / 2013-12-31
file: by_date/stock_daily/2013/2013-12-31.parquet size: 219 KB rows: 6,505 symbols: 3,554
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-31 | AAPL | Stock | 19.7918 | 20.0457 | 19.7857 | 20.0364 | 223084400.0 |
| 2013-12-31 | MSFT | Stock | 37.4 | 37.58 | 37.22 | 37.41 | 17503500.0 |
| 2013-12-31 | NVDA | Stock | 0.4 | 0.4025 | 0.3975 | 0.4005 | 235776000.0 |
| 2013-12-31 | AMZN | Stock | 19.729 | 19.9415 | 19.69 | 19.9395 | 39930000.0 |
| 2013-12-31 | META | Stock | 54.12 | 54.86 | 53.91 | 54.65 | 43076200.0 |
| 2013-12-31 | TSLA | Stock | 10.1547 | 10.2133 | 9.9107 | 10.0287 | 63936000.0 |
| 2013-12-31 | TLT | Stock | 102.29 | 102.55 | 101.17 | 101.86 | 7219195.0 |
| 2013-12-31 | ES | Stock | 42.45 | 42.52 | 42.25 | 42.39 | 1553000.0 |
| 2013-12-31 | CL | Stock | 65.42 | 65.52 | 65.0 | 65.21 | 1827400.0 |
| 2013-12-31 | A | Stock | 41.0944 | 41.166 | 40.8298 | 40.9084 | 1316077.0 |
| 2013-12-31 | AABA-DELISTED | Stock | 40.17 | 40.5 | 40.0 | 40.45 | 7990264.0 |
| 2013-12-31 | AACG | Stock | 4.05 | 4.05 | 4.01 | 4.01 | 3300.0 |
| 2013-12-31 | AAIC-DELISTED | Stock | 26.08 | 26.54 | 26.04 | 26.39 | 150117.0 |
| 2013-12-31 | AAL | Stock | 24.74 | 25.25 | 24.63 | 25.25 | 7166600.0 |
| 2013-12-31 | AAMC-DELISTED | Stock | 268.8235 | 289.7059 | 264.7059 | 273.5294 | 37475.0 |
| 2013-12-31 | AAME | Stock | 4.04 | 4.13 | 3.96 | 4.09 | 30700.0 |
| 2013-12-31 | AAOI | Stock | 15.0 | 15.1 | 14.71 | 15.01 | 83900.0 |
| 2013-12-31 | AAON | Stock | 14.4311 | 14.48 | 14.1511 | 14.2 | 342000.0 |
| 2013-12-31 | AAP | Stock | 109.8 | 111.41 | 109.49 | 110.68 | 381300.0 |
| 2013-12-31 | AAT | Stock | 31.98 | 32.14 | 31.33 | 31.43 | 129100.0 |
| 2013-12-31 | AAU-DELISTED | Stock | 1.13 | 1.19 | 1.11 | 1.17 | 122808.0 |
| 2013-12-31 | AAUAF-DELISTED | Stock | 1.13 | 1.19 | 1.11 | 1.17 | 125150.0 |
| 2013-12-31 | AAV-DELISTED | Stock | 4.32 | 4.42 | 4.31 | 4.34 | 107533.0 |
| 2013-12-31 | AAWW-DELISTED | Stock | 41.03 | 41.37 | 40.8 | 41.11 | 158740.0 |
| 2013-12-31 | AAXJ | Stock | 59.87 | 60.36 | 59.87 | 60.31 | 399154.0 |
| 2013-12-31 | AAXN-DELISTED | Stock | 15.91 | 16.15 | 15.8 | 15.87 | 619994.0 |
| 2013-12-31 | AB | Stock | 21.47 | 21.58 | 21.3 | 21.34 | 233500.0 |
| 2013-12-31 | ABAC-DELISTED | Stock | 2.27 | 2.27 | 2.18 | 2.18 | 28308.0 |
| 2013-12-31 | ABAX-DELISTED | Stock | 40.15 | 40.4 | 39.94 | 40.02 | 300373.0 |
| 2013-12-31 | ABB-DELISTED | Stock | 26.45 | 26.63 | 26.345 | 26.55 | 836611.0 |
| 2013-12-31 | ABBNY-DELISTED | Stock | 26.45 | 26.63 | 26.345 | 26.56 | 863765.0 |
| 2013-12-31 | ABBV | Stock | 52.99 | 53.06 | 52.36 | 52.81 | 3019700.0 |
| 2013-12-31 | ABC-DELISTED | Stock | 70.52 | 70.6401 | 70.09 | 70.33 | 546669.0 |
| 2013-12-31 | ABCB | Stock | 21.31 | 21.76 | 20.8 | 21.11 | 61600.0 |
| 2013-12-31 | ABCD-DELISTED | Stock | 1.69 | 1.74 | 1.68 | 1.68 | 26604.0 |
| 2013-12-31 | ABCO-DELISTED | Stock | 62.77 | 64.49 | 62.61 | 63.66 | 393755.0 |
| 2013-12-31 | ABE-DELISTED | Stock | 13.73 | 13.8 | 13.57 | 13.8 | 25111.0 |
| 2013-12-31 | ABEO | Stock | 287.5 | 312.5 | 287.5 | 312.5 | 96.0 |
| 2013-12-31 | ABEV | Stock | 7.4 | 7.4 | 7.2 | 7.35 | 3860200.0 |
| 2013-12-31 | ABFS-DELISTED | Stock | 33.8 | 33.82 | 33.38 | 33.68 | 189540.0 |
| 2013-12-31 | ABG | Stock | 53.47 | 54.09 | 53.47 | 53.74 | 88900.0 |
| 2013-12-31 | ABGB-DELISTED | Stock | 15.02 | 15.0788 | 14.83 | 15.0788 | 4681.0 |
| 2013-12-31 | ABM | Stock | 28.88 | 29.03 | 28.54 | 28.59 | 185500.0 |
| 2013-12-31 | ABMD-DELISTED | Stock | 27.47 | 27.47 | 26.69 | 26.72 | 345535.0 |
| 2013-12-31 | ABR | Stock | 6.6 | 6.81 | 6.59 | 6.66 | 120300.0 |
| 2013-12-31 | ABR.A-DELISTED | Stock | 24.2699 | 24.27 | 24.22 | 24.22 | 400.0 |
| 2013-12-31 | ABR.B-DELISTED | Stock | 22.4 | 22.61 | 22.4 | 22.61 | 300.0 |
| 2013-12-31 | ABT | Stock | 38.38 | 38.57 | 38.22 | 38.33 | 4594200.0 |
| 2013-12-31 | ABTL-DELISTED | Stock | 14.84 | 15.3 | 14.17 | 15.12 | 310994.0 |
| 2013-12-31 | ABUS | Stock | 7.66 | 7.98 | 7.66 | 7.97 | 52800.0 |
> showing 50 of 6,505 rows — these rows as CSV