PREVIEW / stock_daily / 2015-12-09
file: by_date/stock_daily/2015/2015-12-09.parquet size: 221 KB rows: 6,623 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-09 | AAPL | Stock | 29.41 | 29.4225 | 28.77 | 28.905 | 185445600.0 |
| 2015-12-09 | MSFT | Stock | 55.37 | 55.87 | 54.51 | 54.98 | 36373200.0 |
| 2015-12-09 | NVDA | Stock | 0.8388 | 0.8438 | 0.8092 | 0.8178 | 372676000.0 |
| 2015-12-09 | AMZN | Stock | 33.9 | 33.95 | 32.784 | 33.2395 | 103164000.0 |
| 2015-12-09 | GOOGL | Stock | 38.555 | 38.8046 | 37.6003 | 38.1275 | 46549420.0 |
| 2015-12-09 | META | Stock | 106.18 | 106.44 | 103.55 | 104.6 | 23517300.0 |
| 2015-12-09 | TSLA | Stock | 15.1133 | 15.1667 | 14.7147 | 14.968 | 45867000.0 |
| 2015-12-09 | TLT | Stock | 121.35 | 122.145 | 120.51 | 121.68 | 8993896.0 |
| 2015-12-09 | ES | Stock | 50.9 | 51.68 | 50.66 | 50.84 | 1450000.0 |
| 2015-12-09 | CL | Stock | 66.02 | 67.1 | 65.75 | 66.08 | 3052500.0 |
| 2015-12-09 | A | Stock | 41.25 | 41.8 | 40.91 | 40.98 | 4133300.0 |
| 2015-12-09 | AA.B-DELISTED | Stock | 30.11 | 30.86 | 30.1 | 30.8 | 131415.0 |
| 2015-12-09 | AAAP-DELISTED | Stock | 31.03 | 31.3 | 28.8 | 29.38 | 48747.0 |
| 2015-12-09 | AABA-DELISTED | Stock | 35.8 | 35.84 | 33.15 | 34.4 | 42925507.0 |
| 2015-12-09 | AAC-DELISTED | Stock | 23.0 | 24.59 | 21.91 | 22.83 | 267945.0 |
| 2015-12-09 | AACG | Stock | 5.82 | 6.08 | 5.72 | 5.95 | 93900.0 |
| 2015-12-09 | AAIC-DELISTED | Stock | 12.98 | 13.25 | 12.875 | 12.96 | 251124.0 |
| 2015-12-09 | AAL | Stock | 44.3 | 45.19 | 43.19 | 43.65 | 8001000.0 |
| 2015-12-09 | AAMC-DELISTED | Stock | 3.7647 | 3.9441 | 3.6029 | 3.7147 | 101626.0 |
| 2015-12-09 | AAME | Stock | 4.99 | 4.99 | 4.84 | 4.9 | 7300.0 |
| 2015-12-09 | AAMI | Stock | 15.08 | 15.25 | 14.78 | 14.8 | 72000.0 |
| 2015-12-09 | AAOI | Stock | 17.13 | 17.71 | 17.0 | 17.47 | 259900.0 |
| 2015-12-09 | AAON | Stock | 16.18 | 16.4867 | 15.5933 | 15.6133 | 310350.0 |
| 2015-12-09 | AAP | Stock | 149.75 | 156.26 | 149.65 | 153.21 | 1699900.0 |
| 2015-12-09 | AAT | Stock | 39.12 | 39.19 | 38.42 | 38.78 | 118200.0 |
| 2015-12-09 | AAU-DELISTED | Stock | 0.53 | 0.5488 | 0.53 | 0.54 | 18270.0 |
| 2015-12-09 | AAUAF-DELISTED | Stock | 0.53 | 0.5488 | 0.53 | 0.54 | 18778.0 |
| 2015-12-09 | AAV-DELISTED | Stock | 4.57 | 4.71 | 4.51 | 4.59 | 61686.0 |
| 2015-12-09 | AAVL-DELISTED | Stock | 9.23 | 9.395 | 8.95 | 9.05 | 181061.0 |
| 2015-12-09 | AAWW-DELISTED | Stock | 38.1 | 39.68 | 38.1 | 39.35 | 214433.0 |
| 2015-12-09 | AAXJ | Stock | 53.86 | 54.41 | 53.66 | 53.92 | 2038503.0 |
| 2015-12-09 | AAXN-DELISTED | Stock | 16.78 | 17.04 | 16.33 | 16.61 | 1808284.0 |
| 2015-12-09 | AB | Stock | 23.0 | 24.27 | 23.0 | 23.73 | 549500.0 |
| 2015-12-09 | ABAC-DELISTED | Stock | 1.06 | 1.2 | 1.06 | 1.18 | 33003.0 |
| 2015-12-09 | ABAX-DELISTED | Stock | 54.1 | 54.35 | 52.71 | 53.03 | 50162.0 |
| 2015-12-09 | ABB-DELISTED | Stock | 18.21 | 18.48 | 18.13 | 18.24 | 2503977.0 |
| 2015-12-09 | ABBNY-DELISTED | Stock | 18.21 | 18.48 | 18.13 | 18.24 | 2715364.0 |
| 2015-12-09 | ABBV | Stock | 56.28 | 57.44 | 55.72 | 56.03 | 6207900.0 |
| 2015-12-09 | ABC-DELISTED | Stock | 99.53 | 101.01 | 99.37 | 100.68 | 3110418.0 |
| 2015-12-09 | ABCB | Stock | 34.75 | 34.92 | 34.05 | 34.29 | 290000.0 |
| 2015-12-09 | ABCD-DELISTED | Stock | 5.07 | 5.07 | 4.95 | 5.0199 | 25132.0 |
| 2015-12-09 | ABCO-DELISTED | Stock | 52.17 | 52.52 | 50.99 | 51.11 | 160229.0 |
| 2015-12-09 | ABCW-DELISTED | Stock | 43.07 | 43.35 | 41.94 | 42.34 | 14294.0 |
| 2015-12-09 | ABDC-DELISTED | Stock | 12.18 | 12.18 | 11.95 | 12.06 | 34183.0 |
| 2015-12-09 | ABE-DELISTED | Stock | 10.83 | 11.0 | 10.83 | 10.97 | 13745.0 |
| 2015-12-09 | ABEO | Stock | 92.25 | 94.0 | 87.75 | 89.0 | 3828.0 |
| 2015-12-09 | ABEV | Stock | 4.9 | 4.98 | 4.83 | 4.89 | 21701500.0 |
| 2015-12-09 | ABG | Stock | 73.04 | 74.02 | 72.73 | 73.53 | 299600.0 |
| 2015-12-09 | ABGB-DELISTED | Stock | 1.9 | 1.99 | 1.81 | 1.85 | 52729.0 |
| 2015-12-09 | ABIL-DELISTED | Stock | 10.09 | 10.1 | 10.08 | 10.09 | 214172.0 |
> showing 50 of 6,623 rows — these rows as CSV