PREVIEW / stock_daily / 2015-02-02
file: by_date/stock_daily/2015/2015-02-02.parquet size: 223 KB rows: 6,642 symbols: 3,530
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-02-02 | AAPL | Stock | 29.5125 | 29.7925 | 29.02 | 29.6575 | 250956400.0 |
| 2015-02-02 | MSFT | Stock | 40.59 | 41.37 | 40.23 | 41.28 | 50352500.0 |
| 2015-02-02 | NVDA | Stock | 0.483 | 0.4925 | 0.4735 | 0.4905 | 259604000.0 |
| 2015-02-02 | AMZN | Stock | 17.5025 | 18.25 | 17.5005 | 18.2235 | 204638000.0 |
| 2015-02-02 | GOOGL | Stock | 26.716 | 26.825 | 26.086 | 26.61 | 75377220.0 |
| 2015-02-02 | META | Stock | 76.11 | 76.14 | 73.75 | 74.99 | 41955300.0 |
| 2015-02-02 | TSLA | Stock | 13.598 | 14.13 | 13.5533 | 14.0627 | 62238000.0 |
| 2015-02-02 | TLT | Stock | 136.7 | 137.92 | 136.66 | 137.48 | 13689942.0 |
| 2015-02-02 | ES | Stock | 55.46 | 56.23 | 54.83 | 56.15 | 2120300.0 |
| 2015-02-02 | CL | Stock | 67.36 | 69.09 | 66.98 | 68.99 | 4609000.0 |
| 2015-02-02 | A | Stock | 37.9 | 38.76 | 37.71 | 38.69 | 2508500.0 |
| 2015-02-02 | AA.B-DELISTED | Stock | 50.75 | 51.25 | 50.6 | 51.22 | 39864.0 |
| 2015-02-02 | AABA-DELISTED | Stock | 44.39 | 44.76 | 43.88 | 44.69 | 18789576.0 |
| 2015-02-02 | AAC-DELISTED | Stock | 25.71 | 25.71 | 25.0 | 25.56 | 59947.0 |
| 2015-02-02 | AACG | Stock | 4.86 | 4.88 | 4.62 | 4.75 | 5900.0 |
| 2015-02-02 | AAIC-DELISTED | Stock | 26.63 | 26.71 | 26.401 | 26.56 | 245569.0 |
| 2015-02-02 | AAL | Stock | 48.58 | 48.93 | 46.21 | 48.72 | 22413100.0 |
| 2015-02-02 | AAMC-DELISTED | Stock | 47.0588 | 47.5676 | 45.5882 | 45.9794 | 24188.0 |
| 2015-02-02 | AAME | Stock | 3.97 | 3.99 | 3.97 | 3.99 | 500.0 |
| 2015-02-02 | AAMI | Stock | 15.24 | 16.04 | 15.07 | 15.98 | 130100.0 |
| 2015-02-02 | AAOI | Stock | 8.97 | 8.97 | 8.63 | 8.71 | 132900.0 |
| 2015-02-02 | AAON | Stock | 14.6267 | 15.06 | 14.5533 | 15.04 | 142800.0 |
| 2015-02-02 | AAP | Stock | 159.0 | 159.47 | 153.29 | 155.97 | 820100.0 |
| 2015-02-02 | AAT | Stock | 44.33 | 44.33 | 42.99 | 43.91 | 195800.0 |
| 2015-02-02 | AAU-DELISTED | Stock | 1.2 | 1.2003 | 1.15 | 1.16 | 195539.0 |
| 2015-02-02 | AAUAF-DELISTED | Stock | 1.2 | 1.2003 | 1.15 | 1.16 | 196800.0 |
| 2015-02-02 | AAV-DELISTED | Stock | 4.28 | 4.28 | 4.12 | 4.17 | 99607.0 |
| 2015-02-02 | AAVL-DELISTED | Stock | 39.77 | 39.99 | 36.01 | 37.57 | 308444.0 |
| 2015-02-02 | AAWW-DELISTED | Stock | 45.47 | 46.1 | 44.34 | 46.05 | 206067.0 |
| 2015-02-02 | AAXJ | Stock | 62.68 | 63.05 | 62.46 | 62.92 | 1152691.0 |
| 2015-02-02 | AAXN-DELISTED | Stock | 26.98 | 27.02 | 25.92 | 26.885 | 1325079.0 |
| 2015-02-02 | AB | Stock | 24.19 | 24.6 | 24.06 | 24.37 | 576400.0 |
| 2015-02-02 | ABAC-DELISTED | Stock | 1.57 | 1.6 | 1.504 | 1.6 | 11300.0 |
| 2015-02-02 | ABAX-DELISTED | Stock | 61.7 | 62.3254 | 60.371 | 61.12 | 298878.0 |
| 2015-02-02 | ABB-DELISTED | Stock | 19.34 | 19.5903 | 19.281 | 19.55 | 2255309.0 |
| 2015-02-02 | ABBNY-DELISTED | Stock | 19.34 | 19.5903 | 19.281 | 19.55 | 2604299.0 |
| 2015-02-02 | ABBV | Stock | 61.49 | 61.49 | 58.65 | 60.7 | 11491100.0 |
| 2015-02-02 | ABC-DELISTED | Stock | 95.57 | 95.77 | 93.6 | 95.15 | 1528151.0 |
| 2015-02-02 | ABCB | Stock | 24.25 | 24.74 | 24.12 | 24.58 | 103700.0 |
| 2015-02-02 | ABCD-DELISTED | Stock | 2.51 | 2.71 | 2.51 | 2.66 | 79581.0 |
| 2015-02-02 | ABCO-DELISTED | Stock | 47.08 | 47.68 | 45.95 | 47.38 | 288560.0 |
| 2015-02-02 | ABCW-DELISTED | Stock | 33.5 | 33.9 | 33.0 | 33.4 | 36086.0 |
| 2015-02-02 | ABDC-DELISTED | Stock | 12.91 | 13.04 | 12.9 | 12.99 | 17421.0 |
| 2015-02-02 | ABE-DELISTED | Stock | 13.05 | 13.05 | 12.87 | 12.94 | 79268.0 |
| 2015-02-02 | ABEO | Stock | 77.5 | 82.5 | 77.5 | 79.75 | 528.0 |
| 2015-02-02 | ABEV | Stock | 6.48 | 6.53 | 6.38 | 6.5 | 10524000.0 |
| 2015-02-02 | ABG | Stock | 74.59 | 76.13 | 73.33 | 76.1 | 336800.0 |
| 2015-02-02 | ABGB-DELISTED | Stock | 14.5 | 15.41 | 14.483 | 15.35 | 56108.0 |
| 2015-02-02 | ABIL-DELISTED | Stock | 9.81 | 9.82 | 9.81 | 9.82 | 800.0 |
| 2015-02-02 | ABM | Stock | 28.94 | 29.37 | 28.63 | 29.31 | 175300.0 |
> showing 50 of 6,642 rows — these rows as CSV