PREVIEW / stock_daily / 2015-01-14
file: by_date/stock_daily/2015/2015-01-14.parquet size: 222 KB rows: 6,652 symbols: 3,536
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-01-14 | AAPL | Stock | 27.26 | 27.6225 | 27.125 | 27.45 | 195826400.0 |
| 2015-01-14 | MSFT | Stock | 45.96 | 46.24 | 45.62 | 45.96 | 29719600.0 |
| 2015-01-14 | NVDA | Stock | 0.4862 | 0.495 | 0.485 | 0.4935 | 155260000.0 |
| 2015-01-14 | AMZN | Stock | 14.5965 | 14.7955 | 14.325 | 14.6635 | 110774000.0 |
| 2015-01-14 | GOOGL | Stock | 25.021 | 25.413 | 24.908 | 25.2965 | 52799180.0 |
| 2015-01-14 | META | Stock | 76.42 | 77.2 | 76.03 | 76.28 | 25918600.0 |
| 2015-01-14 | TSLA | Stock | 12.3887 | 13.0133 | 12.3333 | 12.846 | 173278500.0 |
| 2015-01-14 | TLT | Stock | 133.72 | 134.12 | 132.7 | 132.82 | 12324546.0 |
| 2015-01-14 | ES | Stock | 53.23 | 54.17 | 53.2 | 54.15 | 1422800.0 |
| 2015-01-14 | CL | Stock | 67.89 | 68.63 | 67.84 | 68.45 | 2579200.0 |
| 2015-01-14 | A | Stock | 39.03 | 39.1 | 38.21 | 39.06 | 5134000.0 |
| 2015-01-14 | AA.B-DELISTED | Stock | 49.6 | 49.6 | 47.78 | 48.6999 | 210587.0 |
| 2015-01-14 | AABA-DELISTED | Stock | 47.7 | 48.09 | 47.07 | 47.51 | 14441574.0 |
| 2015-01-14 | AAC-DELISTED | Stock | 29.42 | 29.77 | 28.85 | 29.66 | 22097.0 |
| 2015-01-14 | AACG | Stock | 4.69 | 4.75 | 4.47 | 4.75 | 60200.0 |
| 2015-01-14 | AAIC-DELISTED | Stock | 25.68 | 25.77 | 25.55 | 25.75 | 186639.0 |
| 2015-01-14 | AAL | Stock | 49.41 | 50.23 | 48.1 | 49.41 | 15684700.0 |
| 2015-01-14 | AAMC-DELISTED | Stock | 61.1441 | 67.7559 | 43.5294 | 60.3882 | 259723.0 |
| 2015-01-14 | AAME | Stock | 3.89 | 4.0 | 3.89 | 4.0 | 200.0 |
| 2015-01-14 | AAMI | Stock | 15.5 | 15.875 | 15.41 | 15.55 | 134200.0 |
| 2015-01-14 | AAOI | Stock | 9.01 | 9.12 | 8.51 | 8.8 | 557900.0 |
| 2015-01-14 | AAON | Stock | 14.3067 | 14.6467 | 14.3067 | 14.54 | 145500.0 |
| 2015-01-14 | AAP | Stock | 151.9 | 153.16 | 149.38 | 150.83 | 719400.0 |
| 2015-01-14 | AAT | Stock | 42.67 | 44.1 | 42.61 | 43.92 | 221200.0 |
| 2015-01-14 | AAU-DELISTED | Stock | 1.14 | 1.15 | 1.088 | 1.15 | 514430.0 |
| 2015-01-14 | AAUAF-DELISTED | Stock | 1.12 | 1.15 | 1.069 | 1.15 | 526000.0 |
| 2015-01-14 | AAV-DELISTED | Stock | 4.38 | 4.582 | 4.31 | 4.55 | 149644.0 |
| 2015-01-14 | AAVL-DELISTED | Stock | 57.9 | 58.99 | 56.76 | 56.94 | 127776.0 |
| 2015-01-14 | AAWW-DELISTED | Stock | 45.87 | 46.66 | 45.2 | 45.89 | 200927.0 |
| 2015-01-14 | AAXJ | Stock | 61.36 | 61.49 | 60.96 | 61.43 | 1837034.0 |
| 2015-01-14 | AAXN-DELISTED | Stock | 25.33 | 26.24 | 25.12 | 25.9 | 1767526.0 |
| 2015-01-14 | AB | Stock | 25.5 | 25.75 | 25.38 | 25.59 | 163500.0 |
| 2015-01-14 | ABAC-DELISTED | Stock | 1.4559 | 1.52 | 1.4 | 1.44 | 17100.0 |
| 2015-01-14 | ABAX-DELISTED | Stock | 56.37 | 58.65 | 56.37 | 57.74 | 195083.0 |
| 2015-01-14 | ABB-DELISTED | Stock | 19.44 | 19.51 | 19.26 | 19.495 | 1504742.0 |
| 2015-01-14 | ABBNY-DELISTED | Stock | 19.44 | 19.51 | 19.26 | 19.5 | 1594658.0 |
| 2015-01-14 | ABBV | Stock | 62.62 | 64.07 | 61.86 | 63.7 | 9448300.0 |
| 2015-01-14 | ABC-DELISTED | Stock | 91.42 | 92.87 | 90.59 | 92.1 | 1764435.0 |
| 2015-01-14 | ABCB | Stock | 23.54 | 24.8 | 23.5 | 23.63 | 54400.0 |
| 2015-01-14 | ABCD-DELISTED | Stock | 1.77 | 1.84 | 1.77 | 1.83 | 14129.0 |
| 2015-01-14 | ABCO-DELISTED | Stock | 48.09 | 48.29 | 46.99 | 48.04 | 97664.0 |
| 2015-01-14 | ABCW-DELISTED | Stock | 34.8 | 34.93 | 34.63 | 34.9 | 7555.0 |
| 2015-01-14 | ABDC-DELISTED | Stock | 12.98 | 13.036 | 12.748 | 12.92 | 42204.0 |
| 2015-01-14 | ABE-DELISTED | Stock | 13.1 | 13.1 | 13.0151 | 13.0151 | 2051.0 |
| 2015-01-14 | ABEO | Stock | 78.75 | 79.0 | 77.0 | 77.5 | 760.0 |
| 2015-01-14 | ABEOW-DELISTED | Stock | 0.8 | 0.84 | 0.7 | 0.84 | 6200.0 |
| 2015-01-14 | ABEV | Stock | 6.34 | 6.43 | 6.34 | 6.41 | 11177100.0 |
| 2015-01-14 | ABG | Stock | 71.89 | 72.62 | 70.7 | 72.23 | 372700.0 |
| 2015-01-14 | ABGB-DELISTED | Stock | 16.38 | 16.49 | 16.05 | 16.38 | 80626.0 |
| 2015-01-14 | ABIL-DELISTED | Stock | 9.75 | 9.9 | 9.75 | 9.9 | 19098.0 |
> showing 50 of 6,652 rows — these rows as CSV