PREVIEW / stock_daily / 2015-09-25
file: by_date/stock_daily/2015/2015-09-25.parquet size: 221 KB rows: 6,641 symbols: 3,449
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-09-25 | AAPL | Stock | 29.11 | 29.1725 | 28.505 | 28.6775 | 224607600.0 |
| 2015-09-25 | MSFT | Stock | 44.48 | 44.73 | 43.76 | 43.94 | 29384600.0 |
| 2015-09-25 | NVDA | Stock | 0.5933 | 0.6018 | 0.5845 | 0.5903 | 369692000.0 |
| 2015-09-25 | AMZN | Stock | 27.1285 | 27.14 | 26.07 | 26.2125 | 80620000.0 |
| 2015-09-25 | GOOGL | Stock | 32.929 | 32.929 | 31.9828 | 32.0075 | 48479840.0 |
| 2015-09-25 | META | Stock | 95.79 | 95.85 | 92.06 | 92.77 | 28961600.0 |
| 2015-09-25 | TSLA | Stock | 17.774 | 17.794 | 17.0767 | 17.1273 | 56601000.0 |
| 2015-09-25 | TLT | Stock | 121.65 | 121.93 | 121.2699 | 121.54 | 8383733.0 |
| 2015-09-25 | ES | Stock | 48.33 | 49.37 | 47.94 | 48.89 | 1733000.0 |
| 2015-09-25 | CL | Stock | 62.77 | 63.69 | 62.64 | 63.14 | 4545600.0 |
| 2015-09-25 | A | Stock | 34.7 | 35.02 | 34.1 | 34.45 | 2730700.0 |
| 2015-09-25 | AA.B-DELISTED | Stock | 33.1 | 33.44 | 32.72 | 32.82 | 16231.0 |
| 2015-09-25 | AABA-DELISTED | Stock | 29.66 | 29.71 | 28.905 | 29.125 | 10775655.0 |
| 2015-09-25 | AAC-DELISTED | Stock | 24.85 | 25.61 | 24.52 | 25.37 | 607259.0 |
| 2015-09-25 | AACG | Stock | 2.75 | 2.83 | 2.48 | 2.5 | 31000.0 |
| 2015-09-25 | AAIC-DELISTED | Stock | 15.76 | 15.89 | 15.62 | 15.79 | 466951.0 |
| 2015-09-25 | AAL | Stock | 40.93 | 41.03 | 39.92 | 40.24 | 7524900.0 |
| 2015-09-25 | AAMC-DELISTED | Stock | 7.1059 | 7.4647 | 7.1059 | 7.2441 | 36904.0 |
| 2015-09-25 | AAME | Stock | 3.95 | 4.0 | 3.89 | 4.0 | 7800.0 |
| 2015-09-25 | AAMI | Stock | 15.4 | 15.48 | 14.77 | 14.81 | 304100.0 |
| 2015-09-25 | AAOI | Stock | 18.89 | 19.12 | 17.5 | 17.64 | 386000.0 |
| 2015-09-25 | AAON | Stock | 13.16 | 13.3 | 12.9533 | 13.0933 | 276750.0 |
| 2015-09-25 | AAP | Stock | 175.84 | 178.76 | 175.6 | 176.84 | 481300.0 |
| 2015-09-25 | AAT | Stock | 40.08 | 40.78 | 39.9 | 40.6 | 199300.0 |
| 2015-09-25 | AAU-DELISTED | Stock | 0.52 | 0.5587 | 0.516 | 0.53 | 60443.0 |
| 2015-09-25 | AAUAF-DELISTED | Stock | 0.52 | 0.5587 | 0.516 | 0.53 | 60925.0 |
| 2015-09-25 | AAV-DELISTED | Stock | 5.51 | 5.51 | 5.26 | 5.32 | 66256.0 |
| 2015-09-25 | AAVL-DELISTED | Stock | 9.94 | 9.94 | 8.85 | 9.13 | 634525.0 |
| 2015-09-25 | AAWW-DELISTED | Stock | 35.79 | 36.11 | 34.66 | 35.22 | 530327.0 |
| 2015-09-25 | AAXJ | Stock | 52.73 | 52.84 | 52.05 | 52.18 | 1220142.0 |
| 2015-09-25 | AAXN-DELISTED | Stock | 24.36 | 24.3834 | 23.44 | 23.57 | 1334431.0 |
| 2015-09-25 | AB | Stock | 26.6 | 26.82 | 26.25 | 26.3 | 160700.0 |
| 2015-09-25 | ABAC-DELISTED | Stock | 0.61 | 0.61 | 0.51 | 0.56 | 34043.0 |
| 2015-09-25 | ABAX-DELISTED | Stock | 47.33 | 47.83 | 46.06 | 46.5501 | 166312.0 |
| 2015-09-25 | ABB-DELISTED | Stock | 17.43 | 17.45 | 17.21 | 17.27 | 2514196.0 |
| 2015-09-25 | ABBNY-DELISTED | Stock | 17.43 | 17.45 | 17.21 | 17.27 | 2572837.0 |
| 2015-09-25 | ABBV | Stock | 57.84 | 57.88 | 55.08 | 55.74 | 8673500.0 |
| 2015-09-25 | ABC-DELISTED | Stock | 102.39 | 102.465 | 99.39 | 99.87 | 1499926.0 |
| 2015-09-25 | ABCB | Stock | 28.6 | 28.83 | 28.36 | 28.36 | 158800.0 |
| 2015-09-25 | ABCD-DELISTED | Stock | 4.91 | 4.95 | 4.78 | 4.81 | 70173.0 |
| 2015-09-25 | ABCO-DELISTED | Stock | 47.33 | 47.33 | 44.62 | 45.29 | 293797.0 |
| 2015-09-25 | ABCW-DELISTED | Stock | 40.99 | 42.3 | 40.89 | 41.07 | 42883.0 |
| 2015-09-25 | ABDC-DELISTED | Stock | 12.86 | 13.28 | 12.62 | 12.784 | 376434.0 |
| 2015-09-25 | ABE-DELISTED | Stock | 10.9 | 10.9 | 10.88 | 10.88 | 4281.0 |
| 2015-09-25 | ABEO | Stock | 126.0 | 126.75 | 110.25 | 114.5 | 7748.0 |
| 2015-09-25 | ABEOW-DELISTED | Stock | 1.94 | 1.94 | 1.84 | 1.84 | 2362.0 |
| 2015-09-25 | ABEV | Stock | 4.81 | 4.96 | 4.75 | 4.87 | 20846400.0 |
| 2015-09-25 | ABG | Stock | 82.65 | 83.33 | 82.1 | 82.28 | 188600.0 |
| 2015-09-25 | ABGB-DELISTED | Stock | 5.07 | 5.07 | 4.81 | 4.88 | 79432.0 |
| 2015-09-25 | ABIL-DELISTED | Stock | 9.95 | 10.03 | 9.95 | 10.03 | 1506.0 |
> showing 50 of 6,641 rows — these rows as CSV