PREVIEW / stock_daily / 2015-05-28
file: by_date/stock_daily/2015/2015-05-28.parquet size: 223 KB rows: 6,651 symbols: 3,506
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-05-28 | AAPL | Stock | 32.965 | 32.9875 | 32.775 | 32.945 | 122933200.0 |
| 2015-05-28 | MSFT | Stock | 47.5 | 48.02 | 47.39 | 47.45 | 19283700.0 |
| 2015-05-28 | NVDA | Stock | 0.546 | 0.5552 | 0.545 | 0.5535 | 327656000.0 |
| 2015-05-28 | AMZN | Stock | 21.4855 | 21.5675 | 21.2735 | 21.3285 | 38248000.0 |
| 2015-05-28 | GOOGL | Stock | 27.6895 | 27.788 | 27.54 | 27.709 | 23546360.0 |
| 2015-05-28 | META | Stock | 80.25 | 81.07 | 80.0 | 80.15 | 11982000.0 |
| 2015-05-28 | TSLA | Stock | 16.4687 | 16.7867 | 16.3367 | 16.7633 | 54709500.0 |
| 2015-05-28 | TLT | Stock | 122.5 | 123.03 | 122.22 | 122.44 | 6237616.0 |
| 2015-05-28 | ES | Stock | 48.68 | 49.34 | 48.55 | 49.25 | 1242500.0 |
| 2015-05-28 | CL | Stock | 67.54 | 67.63 | 67.17 | 67.33 | 2077400.0 |
| 2015-05-28 | A | Stock | 42.45 | 42.71 | 41.35 | 41.75 | 3347400.0 |
| 2015-05-28 | AA.B-DELISTED | Stock | 44.09 | 44.3 | 43.97 | 44.26 | 93222.0 |
| 2015-05-28 | AABA-DELISTED | Stock | 43.06 | 43.42 | 42.93 | 43.075 | 7490787.0 |
| 2015-05-28 | AAC-DELISTED | Stock | 38.56 | 39.0 | 38.31 | 38.52 | 63935.0 |
| 2015-05-28 | AACG | Stock | 4.72 | 4.99 | 4.7 | 4.99 | 7800.0 |
| 2015-05-28 | AAIC-DELISTED | Stock | 20.75 | 20.89 | 20.65 | 20.78 | 198105.0 |
| 2015-05-28 | AAL | Stock | 42.25 | 42.5 | 41.77 | 41.97 | 9238800.0 |
| 2015-05-28 | AAMC-DELISTED | Stock | 50.4441 | 51.6118 | 50.2059 | 50.9 | 44540.0 |
| 2015-05-28 | AAME | Stock | 3.2 | 3.38 | 3.2 | 3.3 | 16200.0 |
| 2015-05-28 | AAMI | Stock | 19.34 | 19.6 | 19.3 | 19.49 | 53300.0 |
| 2015-05-28 | AAOI | Stock | 18.65 | 18.95 | 17.33 | 18.01 | 431800.0 |
| 2015-05-28 | AAON | Stock | 16.2867 | 16.2867 | 16.0667 | 16.2067 | 230700.0 |
| 2015-05-28 | AAP | Stock | 157.25 | 158.05 | 155.63 | 156.35 | 643600.0 |
| 2015-05-28 | AAT | Stock | 40.27 | 40.5 | 39.67 | 40.04 | 139200.0 |
| 2015-05-28 | AAU-DELISTED | Stock | 0.875 | 0.91 | 0.875 | 0.904 | 76450.0 |
| 2015-05-28 | AAUAF-DELISTED | Stock | 0.875 | 0.91 | 0.875 | 0.904 | 81587.0 |
| 2015-05-28 | AAV-DELISTED | Stock | 5.98 | 6.121 | 5.88 | 6.12 | 112121.0 |
| 2015-05-28 | AAVL-DELISTED | Stock | 38.69 | 38.98 | 36.6 | 37.28 | 336747.0 |
| 2015-05-28 | AAWW-DELISTED | Stock | 56.0 | 56.66 | 54.94 | 55.88 | 841290.0 |
| 2015-05-28 | AAXJ | Stock | 66.31 | 66.83 | 66.31 | 66.61 | 3485748.0 |
| 2015-05-28 | AAXN-DELISTED | Stock | 31.43 | 32.4 | 31.27 | 31.92 | 1477019.0 |
| 2015-05-28 | AB | Stock | 31.45 | 31.86 | 31.3 | 31.83 | 100400.0 |
| 2015-05-28 | ABAC-DELISTED | Stock | 1.63 | 1.66 | 1.5901 | 1.61 | 2900.0 |
| 2015-05-28 | ABAX-DELISTED | Stock | 53.22 | 53.44 | 52.65 | 52.8 | 204433.0 |
| 2015-05-28 | ABB-DELISTED | Stock | 21.89 | 21.99 | 21.86 | 21.99 | 1524040.0 |
| 2015-05-28 | ABBNY-DELISTED | Stock | 21.89 | 21.99 | 21.86 | 21.98 | 1571279.0 |
| 2015-05-28 | ABBV | Stock | 67.42 | 67.53 | 66.63 | 67.47 | 12891500.0 |
| 2015-05-28 | ABC-DELISTED | Stock | 113.15 | 114.06 | 112.93 | 113.11 | 1195795.0 |
| 2015-05-28 | ABCB | Stock | 25.15 | 25.47 | 24.98 | 25.25 | 71200.0 |
| 2015-05-28 | ABCD-DELISTED | Stock | 3.69 | 3.84 | 3.69 | 3.84 | 15345.0 |
| 2015-05-28 | ABCO-DELISTED | Stock | 49.49 | 49.61 | 49.0 | 49.52 | 159965.0 |
| 2015-05-28 | ABCW-DELISTED | Stock | 37.1 | 37.1 | 37.01 | 37.1 | 9400.0 |
| 2015-05-28 | ABDC-DELISTED | Stock | 13.88 | 13.98 | 13.705 | 13.74 | 45196.0 |
| 2015-05-28 | ABE-DELISTED | Stock | 13.02 | 13.02 | 12.8301 | 12.88 | 10566.0 |
| 2015-05-28 | ABEO | Stock | 222.0 | 227.5 | 214.25 | 217.0 | 70020.0 |
| 2015-05-28 | ABEOW-DELISTED | Stock | 4.5 | 4.5 | 3.74 | 3.83 | 32404.0 |
| 2015-05-28 | ABEV | Stock | 5.76 | 5.85 | 5.73 | 5.83 | 11547000.0 |
| 2015-05-28 | ABG | Stock | 86.91 | 87.24 | 86.38 | 86.71 | 147700.0 |
| 2015-05-28 | ABGB-DELISTED | Stock | 16.47 | 16.81 | 16.38 | 16.81 | 14603.0 |
| 2015-05-28 | ABM | Stock | 32.67 | 32.86 | 32.47 | 32.71 | 147800.0 |
> showing 50 of 6,651 rows — these rows as CSV