PREVIEW / stock_daily / 2017-08-24
file: by_date/stock_daily/2017/2017-08-24.parquet size: 212 KB rows: 6,426 symbols: 2,930
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 |
|---|---|---|---|---|---|---|---|
| 2017-08-24 | AAPL | Stock | 40.1075 | 40.185 | 39.6375 | 39.8175 | 79275600.0 |
| 2017-08-24 | MSFT | Stock | 72.74 | 72.86 | 72.07 | 72.69 | 17098300.0 |
| 2017-08-24 | NVDA | Stock | 4.1775 | 4.182 | 4.103 | 4.1298 | 469700000.0 |
| 2017-08-24 | AMZN | Stock | 47.871 | 47.95 | 47.057 | 47.6225 | 103914000.0 |
| 2017-08-24 | GOOGL | Stock | 47.1855 | 47.3155 | 46.537 | 46.8445 | 25891180.0 |
| 2017-08-24 | META | Stock | 168.88 | 169.29 | 166.41 | 167.74 | 14030400.0 |
| 2017-08-24 | TSLA | Stock | 23.5013 | 23.7773 | 23.316 | 23.5287 | 68770500.0 |
| 2017-08-24 | TLT | Stock | 126.88 | 127.31 | 126.72 | 126.83 | 5569401.0 |
| 2017-08-24 | ES | Stock | 63.14 | 63.4 | 62.93 | 62.97 | 1394400.0 |
| 2017-08-24 | CL | Stock | 71.34 | 71.42 | 70.69 | 70.78 | 3685800.0 |
| 2017-08-24 | A | Stock | 62.87 | 63.15 | 62.35 | 62.68 | 1584500.0 |
| 2017-08-24 | AA | Stock | 40.88 | 41.55 | 40.56 | 41.34 | 3189300.0 |
| 2017-08-24 | AAAP-DELISTED | Stock | 48.26 | 49.05 | 48.09 | 48.84 | 17123.0 |
| 2017-08-24 | AABA-DELISTED | Stock | 66.08 | 66.1999 | 65.34 | 65.5 | 3797818.0 |
| 2017-08-24 | AAC-DELISTED | Stock | 8.93 | 9.19 | 8.9 | 9.11 | 54176.0 |
| 2017-08-24 | AACG | Stock | 4.74 | 4.74 | 4.61 | 4.62 | 1600.0 |
| 2017-08-24 | AAIC-DELISTED | Stock | 12.99 | 13.06 | 12.96 | 13.02 | 189657.0 |
| 2017-08-24 | AAL | Stock | 44.13 | 44.15 | 42.67 | 42.92 | 7057500.0 |
| 2017-08-24 | AAM.A-DELISTED | Stock | 26.15 | 26.4 | 26.15 | 26.3145 | 25055.0 |
| 2017-08-24 | AAMC-DELISTED | Stock | 22.9706 | 23.5294 | 22.9706 | 23.5294 | 1928.0 |
| 2017-08-24 | AAME | Stock | 3.4 | 3.4 | 3.31 | 3.4 | 1900.0 |
| 2017-08-24 | AAMI | Stock | 13.55 | 13.63 | 13.43 | 13.5 | 630300.0 |
| 2017-08-24 | AAOI | Stock | 64.79 | 64.9 | 61.72 | 62.39 | 2697100.0 |
| 2017-08-24 | AAON | Stock | 21.2667 | 21.3333 | 20.9667 | 21.2 | 111450.0 |
| 2017-08-24 | AAP | Stock | 94.18 | 95.25 | 92.36 | 93.1 | 1407800.0 |
| 2017-08-24 | AAT | Stock | 40.39 | 40.92 | 40.24 | 40.28 | 398000.0 |
| 2017-08-24 | AAU-DELISTED | Stock | 1.11 | 1.13 | 1.1 | 1.12 | 129107.0 |
| 2017-08-24 | AAUAF-DELISTED | Stock | 1.11 | 1.13 | 1.1 | 1.13 | 130722.0 |
| 2017-08-24 | AAV-DELISTED | Stock | 6.45 | 6.45 | 6.35 | 6.4 | 22040.0 |
| 2017-08-24 | AAWW-DELISTED | Stock | 63.3 | 63.45 | 62.5 | 63.25 | 114660.0 |
| 2017-08-24 | AAXJ | Stock | 71.72 | 71.89 | 71.46 | 71.8 | 5299425.0 |
| 2017-08-24 | AAXN-DELISTED | Stock | 21.81 | 22.09 | 21.7525 | 21.85 | 447629.0 |
| 2017-08-24 | AB | Stock | 23.65 | 23.65 | 23.25 | 23.25 | 149400.0 |
| 2017-08-24 | ABAC-DELISTED | Stock | 2.17 | 2.2 | 2.06 | 2.14 | 5379.0 |
| 2017-08-24 | ABAX-DELISTED | Stock | 46.17 | 46.62 | 45.97 | 46.05 | 66847.0 |
| 2017-08-24 | ABB-DELISTED | Stock | 23.14 | 23.2 | 23.08 | 23.1 | 1470926.0 |
| 2017-08-24 | ABBNY-DELISTED | Stock | 23.14 | 23.2 | 23.08 | 23.1 | 1538342.0 |
| 2017-08-24 | ABBV | Stock | 71.72 | 72.31 | 71.4 | 72.11 | 4088300.0 |
| 2017-08-24 | ABC-DELISTED | Stock | 78.33 | 78.9 | 77.855 | 78.4 | 988848.0 |
| 2017-08-24 | ABCB | Stock | 44.0 | 44.9 | 43.65 | 44.4 | 215100.0 |
| 2017-08-24 | ABCD-DELISTED | Stock | 5.15 | 5.19 | 5.12 | 5.15 | 18938.0 |
| 2017-08-24 | ABCO-DELISTED | Stock | 51.5 | 51.65 | 50.7 | 51.0 | 265548.0 |
| 2017-08-24 | ABDC-DELISTED | Stock | 10.52 | 10.7 | 10.41 | 10.44 | 44600.0 |
| 2017-08-24 | ABE-DELISTED | Stock | 13.83 | 14.086 | 13.83 | 13.84 | 2161.0 |
| 2017-08-24 | ABEO | Stock | 221.25 | 242.5 | 221.25 | 240.0 | 34228.0 |
| 2017-08-24 | ABEOW-DELISTED | Stock | 4.7 | 5.15 | 4.6571 | 4.81 | 11420.0 |
| 2017-08-24 | ABEV | Stock | 6.29 | 6.3 | 6.23 | 6.24 | 12190300.0 |
| 2017-08-24 | ABG | Stock | 51.35 | 52.3 | 50.35 | 50.75 | 139000.0 |
| 2017-08-24 | ABIL-DELISTED | Stock | 0.7045 | 0.979 | 0.69 | 0.8399 | 1140681.0 |
| 2017-08-24 | ABM | Stock | 43.86 | 43.96 | 43.59 | 43.78 | 108700.0 |
> showing 50 of 6,426 rows — these rows as CSV