PREVIEW / stock_daily / 2015-12-22
file: by_date/stock_daily/2015/2015-12-22.parquet size: 222 KB rows: 6,657 symbols: 3,410
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-22 | AAPL | Stock | 26.85 | 26.93 | 26.6125 | 26.8075 | 131157600.0 |
| 2015-12-22 | MSFT | Stock | 54.99 | 55.48 | 54.5 | 55.35 | 28322200.0 |
| 2015-12-22 | NVDA | Stock | 0.825 | 0.8315 | 0.8182 | 0.8232 | 130012000.0 |
| 2015-12-22 | AMZN | Stock | 33.3415 | 33.4245 | 32.963 | 33.1575 | 53356000.0 |
| 2015-12-22 | GOOGL | Stock | 38.2135 | 38.517 | 38.06 | 38.3565 | 36338700.0 |
| 2015-12-22 | META | Stock | 105.22 | 105.66 | 104.81 | 105.51 | 14597100.0 |
| 2015-12-22 | TSLA | Stock | 15.666 | 15.77 | 15.3087 | 15.33 | 29422500.0 |
| 2015-12-22 | TLT | Stock | 122.65 | 122.8 | 121.991 | 122.31 | 5445763.0 |
| 2015-12-22 | ES | Stock | 50.3 | 50.83 | 49.73 | 50.69 | 1022900.0 |
| 2015-12-22 | CL | Stock | 66.15 | 66.69 | 65.69 | 66.58 | 2104300.0 |
| 2015-12-22 | A | Stock | 41.01 | 41.33 | 40.72 | 41.22 | 1643200.0 |
| 2015-12-22 | AA.B-DELISTED | Stock | 31.61 | 32.1655 | 31.5 | 32.12 | 88794.0 |
| 2015-12-22 | AAAP-DELISTED | Stock | 29.61 | 31.25 | 28.621 | 29.6307 | 20688.0 |
| 2015-12-22 | AABA-DELISTED | Stock | 32.99 | 34.21 | 32.97 | 34.19 | 12951539.0 |
| 2015-12-22 | AAC-DELISTED | Stock | 21.18 | 21.3799 | 20.19 | 20.19 | 217967.0 |
| 2015-12-22 | AACG | Stock | 6.1 | 6.13 | 6.01 | 6.01 | 24300.0 |
| 2015-12-22 | AAIC-DELISTED | Stock | 14.19 | 14.4531 | 14.1 | 14.44 | 278896.0 |
| 2015-12-22 | AAL | Stock | 42.56 | 43.08 | 42.36 | 42.9 | 5704700.0 |
| 2015-12-22 | AAMC-DELISTED | Stock | 4.5618 | 4.9882 | 4.5618 | 4.8706 | 350098.0 |
| 2015-12-22 | AAME | Stock | 4.72 | 4.72 | 4.52 | 4.72 | 9200.0 |
| 2015-12-22 | AAMI | Stock | 14.94 | 14.945 | 14.6 | 14.91 | 99300.0 |
| 2015-12-22 | AAOI | Stock | 17.01 | 17.13 | 16.62 | 16.92 | 155900.0 |
| 2015-12-22 | AAON | Stock | 15.2667 | 15.4267 | 15.04 | 15.4 | 180300.0 |
| 2015-12-22 | AAP | Stock | 150.11 | 150.49 | 147.28 | 147.83 | 869300.0 |
| 2015-12-22 | AAT | Stock | 38.5 | 38.71 | 38.28 | 38.43 | 385900.0 |
| 2015-12-22 | AAU-DELISTED | Stock | 0.62 | 0.6475 | 0.6106 | 0.63 | 94582.0 |
| 2015-12-22 | AAUAF-DELISTED | Stock | 0.62 | 0.6475 | 0.6106 | 0.63 | 107180.0 |
| 2015-12-22 | AAV-DELISTED | Stock | 4.67 | 4.74 | 4.65 | 4.74 | 194906.0 |
| 2015-12-22 | AAVL-DELISTED | Stock | 9.71 | 9.78 | 9.15 | 9.26 | 194386.0 |
| 2015-12-22 | AAWW-DELISTED | Stock | 41.54 | 42.33 | 41.32 | 41.74 | 223597.0 |
| 2015-12-22 | AAXJ | Stock | 53.83 | 54.05 | 53.65 | 53.94 | 1684078.0 |
| 2015-12-22 | AAXN-DELISTED | Stock | 18.0 | 18.05 | 17.14 | 17.49 | 1198457.0 |
| 2015-12-22 | AB | Stock | 23.99 | 24.53 | 23.99 | 24.34 | 203200.0 |
| 2015-12-22 | ABAC-DELISTED | Stock | 0.96 | 1.0 | 0.92 | 0.99 | 2602.0 |
| 2015-12-22 | ABAX-DELISTED | Stock | 52.75 | 54.28 | 52.39 | 54.0 | 116421.0 |
| 2015-12-22 | ABB-DELISTED | Stock | 17.59 | 17.78 | 17.54 | 17.74 | 1642288.0 |
| 2015-12-22 | ABBNY-DELISTED | Stock | 17.59 | 17.78 | 17.54 | 17.74 | 1684332.0 |
| 2015-12-22 | ABBV | Stock | 56.54 | 57.99 | 56.42 | 57.59 | 8390800.0 |
| 2015-12-22 | ABC-DELISTED | Stock | 103.0 | 103.44 | 102.2 | 103.18 | 937961.0 |
| 2015-12-22 | ABCB | Stock | 33.58 | 33.91 | 33.09 | 33.83 | 189100.0 |
| 2015-12-22 | ABCD-DELISTED | Stock | 5.16 | 5.19 | 5.1125 | 5.17 | 31726.0 |
| 2015-12-22 | ABCO-DELISTED | Stock | 49.26 | 49.43 | 48.66 | 49.09 | 108481.0 |
| 2015-12-22 | ABCW-DELISTED | Stock | 45.0 | 45.0 | 43.29 | 44.24 | 17558.0 |
| 2015-12-22 | ABDC-DELISTED | Stock | 11.5 | 12.27 | 11.345 | 11.88 | 26006.0 |
| 2015-12-22 | ABE-DELISTED | Stock | 10.84 | 10.89 | 10.8006 | 10.86 | 10545.0 |
| 2015-12-22 | ABEO | Stock | 88.75 | 89.25 | 86.5 | 88.0 | 2564.0 |
| 2015-12-22 | ABEOW-DELISTED | Stock | 1.4 | 1.4 | 1.4 | 1.4 | 840.0 |
| 2015-12-22 | ABEV | Stock | 4.42 | 4.51 | 4.38 | 4.49 | 14092400.0 |
| 2015-12-22 | ABG | Stock | 68.53 | 69.42 | 67.61 | 69.14 | 220600.0 |
| 2015-12-22 | ABGB-DELISTED | Stock | 1.55 | 1.58 | 1.5213 | 1.55 | 20364.0 |
> showing 50 of 6,657 rows — these rows as CSV