PREVIEW / stock_daily / 2015-12-31
file: by_date/stock_daily/2015/2015-12-31.parquet size: 222 KB rows: 6,684 symbols: 3,428
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-31 | AAPL | Stock | 26.7525 | 26.7575 | 26.205 | 26.315 | 163649200.0 |
| 2015-12-31 | MSFT | Stock | 56.04 | 56.19 | 55.42 | 55.48 | 27334100.0 |
| 2015-12-31 | NVDA | Stock | 0.8335 | 0.8372 | 0.824 | 0.824 | 148528000.0 |
| 2015-12-31 | AMZN | Stock | 34.304 | 34.3875 | 33.7945 | 33.7945 | 74992000.0 |
| 2015-12-31 | GOOGL | Stock | 39.391 | 39.4165 | 38.866 | 38.9005 | 32751220.0 |
| 2015-12-31 | META | Stock | 106.0 | 106.17 | 104.62 | 104.66 | 18391100.0 |
| 2015-12-31 | TSLA | Stock | 15.9007 | 16.23 | 15.8913 | 16.0007 | 40725000.0 |
| 2015-12-31 | TLT | Stock | 120.57 | 120.8607 | 120.25 | 120.58 | 7897690.0 |
| 2015-12-31 | ES | Stock | 51.89 | 51.9 | 50.55 | 51.07 | 2081200.0 |
| 2015-12-31 | CL | Stock | 67.21 | 67.29 | 66.61 | 66.62 | 2002100.0 |
| 2015-12-31 | A | Stock | 41.9 | 42.35 | 41.72 | 41.81 | 1451000.0 |
| 2015-12-31 | AA.B-DELISTED | Stock | 33.36 | 33.4245 | 32.61 | 33.31 | 48877.0 |
| 2015-12-31 | AAAP-DELISTED | Stock | 29.76 | 31.27 | 29.04 | 31.0 | 39055.0 |
| 2015-12-31 | AABA-DELISTED | Stock | 33.25 | 33.685 | 33.18 | 33.25 | 6955785.0 |
| 2015-12-31 | AAC-DELISTED | Stock | 18.55 | 19.25 | 18.477 | 19.1201 | 137405.0 |
| 2015-12-31 | AACG | Stock | 6.34 | 6.5 | 6.34 | 6.42 | 17000.0 |
| 2015-12-31 | AAIC-DELISTED | Stock | 13.28 | 13.38 | 13.13 | 13.23 | 300728.0 |
| 2015-12-31 | AAL | Stock | 42.54 | 42.57 | 41.83 | 42.35 | 6813800.0 |
| 2015-12-31 | AAMC-DELISTED | Stock | 5.0765 | 5.1206 | 4.9412 | 5.0471 | 105512.0 |
| 2015-12-31 | AAME | Stock | 4.96 | 4.99 | 4.87 | 4.99 | 4600.0 |
| 2015-12-31 | AAMI | Stock | 15.21 | 15.5 | 14.89 | 15.33 | 141300.0 |
| 2015-12-31 | AAOI | Stock | 17.72 | 17.74 | 17.15 | 17.16 | 103200.0 |
| 2015-12-31 | AAON | Stock | 15.7133 | 15.8933 | 15.46 | 15.48 | 316650.0 |
| 2015-12-31 | AAP | Stock | 151.26 | 151.94 | 150.45 | 150.51 | 766700.0 |
| 2015-12-31 | AAT | Stock | 39.23 | 39.23 | 38.2 | 38.35 | 320600.0 |
| 2015-12-31 | AAU-DELISTED | Stock | 0.66 | 0.69 | 0.63 | 0.678 | 139134.0 |
| 2015-12-31 | AAUAF-DELISTED | Stock | 0.66 | 0.69 | 0.63 | 0.678 | 141898.0 |
| 2015-12-31 | AAV-DELISTED | Stock | 4.89 | 5.1 | 4.89 | 5.07 | 31949.0 |
| 2015-12-31 | AAVL-DELISTED | Stock | 9.43 | 9.59 | 9.3616 | 9.52 | 207140.0 |
| 2015-12-31 | AAWW-DELISTED | Stock | 40.79 | 41.89 | 40.5 | 41.32 | 253430.0 |
| 2015-12-31 | AAXJ | Stock | 53.53 | 53.75 | 53.39 | 53.41 | 464207.0 |
| 2015-12-31 | AAXN-DELISTED | Stock | 17.76 | 17.81 | 17.25 | 17.29 | 1154229.0 |
| 2015-12-31 | AB | Stock | 24.52 | 24.52 | 23.78 | 23.85 | 214400.0 |
| 2015-12-31 | ABAC-DELISTED | Stock | 0.92 | 0.92 | 0.8031 | 0.9002 | 4105.0 |
| 2015-12-31 | ABAX-DELISTED | Stock | 57.44 | 57.47 | 55.41 | 55.69 | 150848.0 |
| 2015-12-31 | ABB-DELISTED | Stock | 17.89 | 17.9 | 17.73 | 17.74 | 944537.0 |
| 2015-12-31 | ABBNY-DELISTED | Stock | 17.89 | 17.9 | 17.73 | 17.73 | 989432.0 |
| 2015-12-31 | ABBV | Stock | 59.5 | 59.93 | 59.2 | 59.24 | 6104800.0 |
| 2015-12-31 | ABC-DELISTED | Stock | 104.47 | 105.12 | 103.68 | 103.68 | 979230.0 |
| 2015-12-31 | ABCB | Stock | 34.44 | 34.73 | 33.95 | 33.99 | 198700.0 |
| 2015-12-31 | ABCD-DELISTED | Stock | 5.03 | 5.09 | 4.85 | 4.85 | 96552.0 |
| 2015-12-31 | ABCO-DELISTED | Stock | 50.25 | 51.26 | 49.61 | 49.62 | 178876.0 |
| 2015-12-31 | ABCW-DELISTED | Stock | 44.75 | 44.75 | 43.43 | 43.55 | 18615.0 |
| 2015-12-31 | ABDC-DELISTED | Stock | 11.48 | 11.9 | 11.48 | 11.59 | 53980.0 |
| 2015-12-31 | ABE-DELISTED | Stock | 10.819 | 10.8551 | 10.81 | 10.8551 | 6079.0 |
| 2015-12-31 | ABEO | Stock | 85.25 | 88.5 | 83.75 | 84.0 | 5752.0 |
| 2015-12-31 | ABEV | Stock | 4.47 | 4.51 | 4.44 | 4.46 | 7005800.0 |
| 2015-12-31 | ABG | Stock | 67.84 | 68.63 | 67.28 | 67.44 | 368700.0 |
| 2015-12-31 | ABGB-DELISTED | Stock | 1.22 | 1.35 | 1.21 | 1.2501 | 129417.0 |
| 2015-12-31 | ABIL-DELISTED | Stock | 9.13 | 9.9 | 9.13 | 9.9 | 172127.0 |
> showing 50 of 6,684 rows — these rows as CSV