PREVIEW / stock_daily / 2015-12-11
file: by_date/stock_daily/2015/2015-12-11.parquet size: 221 KB rows: 6,639 symbols: 3,398
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-11 | AAPL | Stock | 28.7975 | 28.8475 | 28.2125 | 28.295 | 187544800.0 |
| 2015-12-11 | MSFT | Stock | 54.71 | 55.1 | 54.01 | 54.06 | 39549500.0 |
| 2015-12-11 | NVDA | Stock | 0.8162 | 0.822 | 0.8105 | 0.8123 | 227320000.0 |
| 2015-12-11 | AMZN | Stock | 32.5615 | 32.894 | 31.981 | 32.0075 | 109488000.0 |
| 2015-12-11 | GOOGL | Stock | 37.45 | 37.872 | 37.4325 | 37.521 | 43183280.0 |
| 2015-12-11 | META | Stock | 104.15 | 104.34 | 101.91 | 102.12 | 26427700.0 |
| 2015-12-11 | TSLA | Stock | 15.016 | 15.05 | 14.4427 | 14.468 | 49030500.0 |
| 2015-12-11 | TLT | Stock | 123.03 | 124.1 | 122.87 | 123.76 | 12300038.0 |
| 2015-12-11 | ES | Stock | 48.59 | 49.33 | 48.18 | 48.91 | 1351500.0 |
| 2015-12-11 | CL | Stock | 65.37 | 65.78 | 65.03 | 65.21 | 3525600.0 |
| 2015-12-11 | A | Stock | 40.75 | 40.75 | 40.06 | 40.19 | 2634400.0 |
| 2015-12-11 | AA.B-DELISTED | Stock | 31.32 | 31.32 | 30.25 | 30.33 | 90151.0 |
| 2015-12-11 | AAAP-DELISTED | Stock | 29.98 | 30.5 | 28.3101 | 29.71 | 37056.0 |
| 2015-12-11 | AABA-DELISTED | Stock | 34.01 | 34.15 | 32.82 | 32.91 | 13794666.0 |
| 2015-12-11 | AAC-DELISTED | Stock | 22.6 | 23.91 | 22.37 | 23.38 | 412307.0 |
| 2015-12-11 | AACG | Stock | 5.83 | 5.83 | 5.63 | 5.74 | 25300.0 |
| 2015-12-11 | AAIC-DELISTED | Stock | 12.88 | 12.96 | 12.5636 | 12.63 | 223081.0 |
| 2015-12-11 | AAL | Stock | 43.28 | 43.59 | 42.06 | 42.09 | 10235200.0 |
| 2015-12-11 | AAMC-DELISTED | Stock | 3.6029 | 3.7765 | 3.6029 | 3.6471 | 52040.0 |
| 2015-12-11 | AAME | Stock | 4.66 | 4.77 | 4.63 | 4.74 | 3900.0 |
| 2015-12-11 | AAMI | Stock | 14.57 | 14.73 | 13.855 | 14.22 | 419600.0 |
| 2015-12-11 | AAOI | Stock | 16.84 | 17.06 | 16.57 | 16.73 | 213400.0 |
| 2015-12-11 | AAON | Stock | 15.24 | 15.6667 | 15.0867 | 15.16 | 520350.0 |
| 2015-12-11 | AAP | Stock | 149.22 | 150.83 | 147.79 | 148.85 | 1012900.0 |
| 2015-12-11 | AAT | Stock | 38.05 | 38.51 | 37.77 | 38.28 | 203800.0 |
| 2015-12-11 | AAU-DELISTED | Stock | 0.5495 | 0.563 | 0.5319 | 0.56 | 97926.0 |
| 2015-12-11 | AAUAF-DELISTED | Stock | 0.5495 | 0.563 | 0.5319 | 0.56 | 99204.0 |
| 2015-12-11 | AAV-DELISTED | Stock | 4.55 | 4.56 | 4.5 | 4.53 | 68803.0 |
| 2015-12-11 | AAVL-DELISTED | Stock | 9.15 | 9.15 | 8.45 | 8.55 | 223967.0 |
| 2015-12-11 | AAWW-DELISTED | Stock | 39.52 | 40.34 | 38.26 | 38.58 | 184805.0 |
| 2015-12-11 | AAXJ | Stock | 52.85 | 52.93 | 52.51 | 52.56 | 998602.0 |
| 2015-12-11 | AAXN-DELISTED | Stock | 17.37 | 17.62 | 16.95 | 17.03 | 1449132.0 |
| 2015-12-11 | AB | Stock | 23.89 | 24.18 | 22.99 | 23.02 | 293200.0 |
| 2015-12-11 | ABAC-DELISTED | Stock | 0.991 | 1.18 | 0.858 | 1.1201 | 30636.0 |
| 2015-12-11 | ABAX-DELISTED | Stock | 52.81 | 52.86 | 51.45 | 51.7 | 102944.0 |
| 2015-12-11 | ABB-DELISTED | Stock | 17.9 | 17.98 | 17.77 | 17.78 | 2428370.0 |
| 2015-12-11 | ABBNY-DELISTED | Stock | 17.9 | 17.98 | 17.77 | 17.78 | 3384227.0 |
| 2015-12-11 | ABBV | Stock | 55.78 | 55.78 | 53.85 | 54.04 | 9388600.0 |
| 2015-12-11 | ABC-DELISTED | Stock | 101.49 | 102.81 | 101.29 | 102.08 | 1801821.0 |
| 2015-12-11 | ABCB | Stock | 33.0 | 33.61 | 32.48 | 32.85 | 286600.0 |
| 2015-12-11 | ABCD-DELISTED | Stock | 4.95 | 5.15 | 4.75 | 4.97 | 96993.0 |
| 2015-12-11 | ABCO-DELISTED | Stock | 50.68 | 51.41 | 50.37 | 50.68 | 179253.0 |
| 2015-12-11 | ABCW-DELISTED | Stock | 42.61 | 42.8999 | 41.735 | 41.91 | 19822.0 |
| 2015-12-11 | ABDC-DELISTED | Stock | 11.9 | 11.97 | 11.65 | 11.65 | 19650.0 |
| 2015-12-11 | ABE-DELISTED | Stock | 10.97 | 10.97 | 10.7 | 10.74 | 13837.0 |
| 2015-12-11 | ABEO | Stock | 87.75 | 89.5 | 85.25 | 88.0 | 3720.0 |
| 2015-12-11 | ABEOW-DELISTED | Stock | 1.28 | 1.28 | 1.25 | 1.27 | 1300.0 |
| 2015-12-11 | ABEV | Stock | 4.71 | 4.71 | 4.62 | 4.62 | 28158200.0 |
| 2015-12-11 | ABG | Stock | 71.78 | 72.34 | 70.16 | 70.3 | 318900.0 |
| 2015-12-11 | ABGB-DELISTED | Stock | 1.72 | 1.87 | 1.59 | 1.6375 | 128402.0 |
> showing 50 of 6,639 rows — these rows as CSV