PREVIEW / stock_daily / 2015-12-29
file: by_date/stock_daily/2015/2015-12-29.parquet size: 222 KB rows: 6,658 symbols: 3,420
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-29 | AAPL | Stock | 26.74 | 27.3575 | 26.715 | 27.185 | 123724800.0 |
| 2015-12-29 | MSFT | Stock | 56.29 | 56.85 | 56.06 | 56.55 | 27731400.0 |
| 2015-12-29 | NVDA | Stock | 0.829 | 0.8445 | 0.8268 | 0.842 | 203660000.0 |
| 2015-12-29 | AMZN | Stock | 33.899 | 34.822 | 33.8945 | 34.6985 | 114700000.0 |
| 2015-12-29 | GOOGL | Stock | 39.3495 | 39.9345 | 39.3101 | 39.698 | 38429600.0 |
| 2015-12-29 | META | Stock | 106.42 | 107.74 | 106.25 | 107.26 | 17179900.0 |
| 2015-12-29 | TSLA | Stock | 15.3373 | 15.848 | 15.3033 | 15.8127 | 36094500.0 |
| 2015-12-29 | TLT | Stock | 121.69 | 121.74 | 120.01 | 120.16 | 7787496.0 |
| 2015-12-29 | ES | Stock | 52.08 | 52.24 | 51.85 | 51.9 | 1020300.0 |
| 2015-12-29 | CL | Stock | 67.33 | 67.73 | 67.23 | 67.65 | 1671700.0 |
| 2015-12-29 | A | Stock | 42.08 | 42.48 | 41.92 | 42.36 | 1757000.0 |
| 2015-12-29 | AA.B-DELISTED | Stock | 34.1 | 34.1 | 33.3 | 33.95 | 38891.0 |
| 2015-12-29 | AAAP-DELISTED | Stock | 29.78 | 29.995 | 29.27 | 29.73 | 16019.0 |
| 2015-12-29 | AABA-DELISTED | Stock | 33.63 | 34.17 | 33.6 | 34.04 | 10318916.0 |
| 2015-12-29 | AAC-DELISTED | Stock | 18.82 | 19.25 | 18.5 | 18.59 | 74717.0 |
| 2015-12-29 | AACG | Stock | 6.47 | 6.58 | 6.24 | 6.37 | 33600.0 |
| 2015-12-29 | AAIC-DELISTED | Stock | 13.88 | 14.07 | 13.57 | 13.72 | 330057.0 |
| 2015-12-29 | AAL | Stock | 43.25 | 43.62 | 43.03 | 43.5 | 4006900.0 |
| 2015-12-29 | AAMC-DELISTED | Stock | 5.3471 | 5.8706 | 5.1824 | 5.7176 | 229643.0 |
| 2015-12-29 | AAME | Stock | 4.75 | 4.98 | 4.75 | 4.98 | 5800.0 |
| 2015-12-29 | AAMI | Stock | 15.32 | 15.49 | 15.21 | 15.39 | 56300.0 |
| 2015-12-29 | AAOI | Stock | 17.66 | 18.09 | 17.56 | 18.04 | 199100.0 |
| 2015-12-29 | AAON | Stock | 15.7467 | 15.8067 | 15.5267 | 15.68 | 331350.0 |
| 2015-12-29 | AAP | Stock | 151.73 | 153.0 | 151.29 | 152.2 | 572800.0 |
| 2015-12-29 | AAT | Stock | 39.02 | 39.39 | 39.0 | 39.37 | 89800.0 |
| 2015-12-29 | AAU-DELISTED | Stock | 0.69 | 0.726 | 0.66 | 0.7 | 183449.0 |
| 2015-12-29 | AAUAF-DELISTED | Stock | 0.69 | 0.726 | 0.66 | 0.7 | 184385.0 |
| 2015-12-29 | AAV-DELISTED | Stock | 4.99 | 5.12 | 4.92 | 5.09 | 117096.0 |
| 2015-12-29 | AAVL-DELISTED | Stock | 9.34 | 9.75 | 9.26 | 9.72 | 257283.0 |
| 2015-12-29 | AAWW-DELISTED | Stock | 42.7 | 43.04 | 40.95 | 41.84 | 203630.0 |
| 2015-12-29 | AAXJ | Stock | 54.27 | 54.27 | 54.03 | 54.14 | 697798.0 |
| 2015-12-29 | AAXN-DELISTED | Stock | 17.29 | 17.65 | 17.025 | 17.41 | 1024489.0 |
| 2015-12-29 | AB | Stock | 24.62 | 24.86 | 24.4 | 24.69 | 247500.0 |
| 2015-12-29 | ABAC-DELISTED | Stock | 0.95 | 0.95 | 0.9174 | 0.9174 | 695.0 |
| 2015-12-29 | ABAX-DELISTED | Stock | 56.46 | 57.07 | 56.07 | 57.0 | 110989.0 |
| 2015-12-29 | ABB-DELISTED | Stock | 18.16 | 18.3 | 18.16 | 18.22 | 1370949.0 |
| 2015-12-29 | ABBNY-DELISTED | Stock | 18.16 | 18.3 | 18.16 | 18.23 | 1415144.0 |
| 2015-12-29 | ABBV | Stock | 59.02 | 59.7 | 59.02 | 59.45 | 5073900.0 |
| 2015-12-29 | ABC-DELISTED | Stock | 104.69 | 105.35 | 104.2795 | 104.748 | 700405.0 |
| 2015-12-29 | ABCB | Stock | 34.57 | 34.89 | 34.26 | 34.87 | 120400.0 |
| 2015-12-29 | ABCD-DELISTED | Stock | 5.05 | 5.14 | 5.03 | 5.0899 | 15475.0 |
| 2015-12-29 | ABCO-DELISTED | Stock | 50.58 | 51.26 | 50.03 | 50.84 | 95716.0 |
| 2015-12-29 | ABCW-DELISTED | Stock | 44.8 | 45.75 | 44.8 | 45.22 | 22146.0 |
| 2015-12-29 | ABDC-DELISTED | Stock | 11.86 | 12.1065 | 11.37 | 11.67 | 93032.0 |
| 2015-12-29 | ABE-DELISTED | Stock | 10.98 | 10.98 | 10.93 | 10.9561 | 2500.0 |
| 2015-12-29 | ABEO | Stock | 88.5 | 89.25 | 86.75 | 88.0 | 2948.0 |
| 2015-12-29 | ABEV | Stock | 4.69 | 4.72 | 4.64 | 4.68 | 11317900.0 |
| 2015-12-29 | ABG | Stock | 69.05 | 69.6 | 68.45 | 69.38 | 296300.0 |
| 2015-12-29 | ABGB-DELISTED | Stock | 1.53 | 1.5499 | 1.5 | 1.505 | 15400.0 |
| 2015-12-29 | ABIL-DELISTED | Stock | 9.29 | 9.29 | 9.08 | 9.1 | 23270.0 |
> showing 50 of 6,658 rows — these rows as CSV