PREVIEW / stock_daily / 2015-08-24
file: by_date/stock_daily/2015/2015-08-24.parquet size: 223 KB rows: 6,731 symbols: 3,512
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-08-24 | AAPL | Stock | 23.7175 | 27.2 | 23.0 | 25.78 | 648825200.0 |
| 2015-08-24 | MSFT | Stock | 40.45 | 42.69 | 39.72 | 41.68 | 88753700.0 |
| 2015-08-24 | NVDA | Stock | 0.5068 | 0.5458 | 0.5 | 0.5178 | 682284000.0 |
| 2015-08-24 | AMZN | Stock | 23.179 | 23.829 | 22.55 | 23.1685 | 201952000.0 |
| 2015-08-24 | GOOGL | Stock | 30.03 | 32.2165 | 29.6545 | 30.9055 | 129788600.0 |
| 2015-08-24 | META | Stock | 77.03 | 82.09 | 72.0 | 82.09 | 83710700.0 |
| 2015-08-24 | TSLA | Stock | 13.5193 | 15.4267 | 13.0 | 14.5913 | 143724000.0 |
| 2015-08-24 | TLT | Stock | 128.31 | 128.92 | 125.82 | 126.36 | 16663414.0 |
| 2015-08-24 | ES | Stock | 49.33 | 50.61 | 48.68 | 48.92 | 3000900.0 |
| 2015-08-24 | CL | Stock | 61.9 | 62.5 | 50.84 | 61.95 | 9060100.0 |
| 2015-08-24 | A | Stock | 33.87 | 36.01 | 33.57 | 34.68 | 4115000.0 |
| 2015-08-24 | AA.B-DELISTED | Stock | 32.4 | 32.797 | 30.62 | 31.87 | 177776.0 |
| 2015-08-24 | AABA-DELISTED | Stock | 29.03 | 32.28 | 28.85 | 31.315 | 21520397.0 |
| 2015-08-24 | AAC-DELISTED | Stock | 22.46 | 23.89 | 21.88 | 22.3 | 460300.0 |
| 2015-08-24 | AACG | Stock | 2.64 | 2.64 | 2.41 | 2.41 | 41200.0 |
| 2015-08-24 | AAIC-DELISTED | Stock | 16.62 | 16.88 | 13.79 | 16.45 | 666657.0 |
| 2015-08-24 | AAL | Stock | 36.0 | 39.9 | 34.1 | 37.62 | 19612700.0 |
| 2015-08-24 | AAMC-DELISTED | Stock | 8.9265 | 10.0118 | 8.9265 | 9.6471 | 97053.0 |
| 2015-08-24 | AAME | Stock | 3.62 | 3.64 | 3.42 | 3.49 | 1800.0 |
| 2015-08-24 | AAMI | Stock | 15.84 | 16.305 | 15.18 | 15.46 | 334500.0 |
| 2015-08-24 | AAOI | Stock | 18.57 | 19.93 | 17.99 | 19.06 | 771400.0 |
| 2015-08-24 | AAON | Stock | 13.66 | 14.2067 | 13.4267 | 13.6 | 295500.0 |
| 2015-08-24 | AAP | Stock | 173.26 | 178.7 | 151.3 | 173.75 | 1459800.0 |
| 2015-08-24 | AAT | Stock | 38.07 | 39.66 | 38.07 | 38.95 | 311500.0 |
| 2015-08-24 | AAU-DELISTED | Stock | 0.6 | 0.6 | 0.4865 | 0.56 | 137277.0 |
| 2015-08-24 | AAUAF-DELISTED | Stock | 0.6 | 0.6 | 0.4865 | 0.56 | 138314.0 |
| 2015-08-24 | AAV-DELISTED | Stock | 4.68 | 4.91 | 4.63 | 4.75 | 203673.0 |
| 2015-08-24 | AAVL-DELISTED | Stock | 10.2 | 10.89 | 9.94 | 10.16 | 767477.0 |
| 2015-08-24 | AAWW-DELISTED | Stock | 39.7 | 41.12 | 37.033 | 39.75 | 521726.0 |
| 2015-08-24 | AAXJ | Stock | 48.11 | 51.21 | 47.61 | 49.56 | 4640576.0 |
| 2015-08-24 | AAXN-DELISTED | Stock | 19.01 | 21.495 | 18.05 | 20.4 | 3146192.0 |
| 2015-08-24 | AB | Stock | 24.78 | 25.23 | 22.0 | 25.18 | 716800.0 |
| 2015-08-24 | ABAC-DELISTED | Stock | 0.614 | 0.688 | 0.48 | 0.6501 | 38288.0 |
| 2015-08-24 | ABAX-DELISTED | Stock | 45.24 | 47.17 | 44.07 | 45.74 | 177379.0 |
| 2015-08-24 | ABB-DELISTED | Stock | 18.68 | 19.22 | 18.42 | 18.71 | 5012870.0 |
| 2015-08-24 | ABBNY-DELISTED | Stock | 18.68 | 19.22 | 18.42 | 18.71 | 5190103.0 |
| 2015-08-24 | ABBV | Stock | 61.17 | 64.85 | 53.87 | 63.45 | 24292600.0 |
| 2015-08-24 | ABC-DELISTED | Stock | 93.0 | 100.85 | 91.48 | 98.53 | 3987460.0 |
| 2015-08-24 | ABCB | Stock | 26.54 | 27.4 | 26.37 | 26.7 | 305300.0 |
| 2015-08-24 | ABCD-DELISTED | Stock | 4.45 | 4.85 | 4.4 | 4.67 | 160736.0 |
| 2015-08-24 | ABCO-DELISTED | Stock | 48.37 | 50.81 | 47.79 | 49.23 | 523303.0 |
| 2015-08-24 | ABCW-DELISTED | Stock | 39.01 | 40.12 | 37.06 | 39.03 | 19711.0 |
| 2015-08-24 | ABDC-DELISTED | Stock | 10.36 | 12.325 | 10.01 | 11.76 | 107286.0 |
| 2015-08-24 | ABE-DELISTED | Stock | 10.34 | 10.81 | 10.15 | 10.75 | 9146.0 |
| 2015-08-24 | ABEO | Stock | 106.75 | 109.5 | 100.75 | 107.75 | 11740.0 |
| 2015-08-24 | ABEOW-DELISTED | Stock | 1.52 | 1.86 | 1.26 | 1.26 | 2680.0 |
| 2015-08-24 | ABEV | Stock | 4.84 | 5.06 | 4.72 | 5.02 | 22435700.0 |
| 2015-08-24 | ABG | Stock | 74.24 | 78.91 | 70.73 | 76.54 | 520800.0 |
| 2015-08-24 | ABGB-DELISTED | Stock | 4.2 | 4.52 | 4.17 | 4.39 | 111311.0 |
| 2015-08-24 | ABIL-DELISTED | Stock | 9.95 | 10.0499 | 9.95 | 10.0499 | 400.0 |
> showing 50 of 6,731 rows — these rows as CSV