PREVIEW / stock_daily / 2017-11-30
file: by_date/stock_daily/2017/2017-11-30.parquet size: 218 KB rows: 6,517 symbols: 2,923
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-11-30 | AAPL | Stock | 42.6075 | 43.035 | 42.11 | 42.9625 | 166108800.0 |
| 2017-11-30 | MSFT | Stock | 83.51 | 84.52 | 83.34 | 84.17 | 33054600.0 |
| 2017-11-30 | NVDA | Stock | 4.98 | 5.067 | 4.9163 | 5.0178 | 823768000.0 |
| 2017-11-30 | AMZN | Stock | 58.355 | 58.9285 | 58.0 | 58.8375 | 90184000.0 |
| 2017-11-30 | GOOGL | Stock | 51.997 | 52.207 | 51.5035 | 51.8085 | 45091800.0 |
| 2017-11-30 | META | Stock | 176.85 | 178.28 | 175.2 | 177.18 | 25307600.0 |
| 2017-11-30 | TSLA | Stock | 20.5707 | 20.7133 | 20.3027 | 20.59 | 65274000.0 |
| 2017-11-30 | TLT | Stock | 125.31 | 125.52 | 124.4399 | 125.12 | 9630008.0 |
| 2017-11-30 | ES | Stock | 64.57 | 64.94 | 64.43 | 64.85 | 3708400.0 |
| 2017-11-30 | CL | Stock | 71.91 | 72.97 | 71.91 | 72.45 | 4557500.0 |
| 2017-11-30 | A | Stock | 68.97 | 69.59 | 68.21 | 69.24 | 1922500.0 |
| 2017-11-30 | AA | Stock | 41.5 | 42.16 | 41.13 | 41.51 | 4407400.0 |
| 2017-11-30 | AAAP-DELISTED | Stock | 81.39 | 81.39 | 81.27 | 81.35 | 1370750.0 |
| 2017-11-30 | AABA-DELISTED | Stock | 70.31 | 70.84 | 69.37 | 70.17 | 16519316.0 |
| 2017-11-30 | AAC-DELISTED | Stock | 9.15 | 9.26 | 8.94 | 9.12 | 150238.0 |
| 2017-11-30 | AACG | Stock | 5.01 | 5.05 | 5.0 | 5.02 | 11400.0 |
| 2017-11-30 | AAIC-DELISTED | Stock | 11.97 | 11.97 | 11.725 | 11.81 | 338387.0 |
| 2017-11-30 | AAL | Stock | 49.76 | 51.11 | 49.3 | 50.49 | 6016200.0 |
| 2017-11-30 | AAM.A-DELISTED | Stock | 25.97 | 26.04 | 25.791 | 25.85 | 31874.0 |
| 2017-11-30 | AAMC-DELISTED | Stock | 21.1765 | 21.7647 | 21.1471 | 21.1765 | 16133.0 |
| 2017-11-30 | AAME | Stock | 3.76 | 3.77 | 3.6 | 3.6 | 3300.0 |
| 2017-11-30 | AAMI | Stock | 16.59 | 16.59 | 16.27 | 16.4 | 505100.0 |
| 2017-11-30 | AAOI | Stock | 43.3 | 45.02 | 43.06 | 43.66 | 1254200.0 |
| 2017-11-30 | AAON | Stock | 24.6333 | 24.6333 | 24.2333 | 24.3 | 243000.0 |
| 2017-11-30 | AAP | Stock | 99.58 | 101.65 | 98.67 | 101.0 | 2353900.0 |
| 2017-11-30 | AAT | Stock | 39.87 | 39.88 | 39.26 | 39.36 | 338800.0 |
| 2017-11-30 | AAU-DELISTED | Stock | 0.8971 | 0.9001 | 0.877 | 0.89 | 79143.0 |
| 2017-11-30 | AAUAF-DELISTED | Stock | 0.8971 | 0.9001 | 0.877 | 0.89 | 79941.0 |
| 2017-11-30 | AAV-DELISTED | Stock | 4.7 | 4.85 | 4.625 | 4.7 | 171260.0 |
| 2017-11-30 | AAWW-DELISTED | Stock | 56.8 | 58.4 | 56.0 | 57.75 | 262037.0 |
| 2017-11-30 | AAXJ | Stock | 76.19 | 76.19 | 75.56 | 75.63 | 1811953.0 |
| 2017-11-30 | AAXN-DELISTED | Stock | 24.99 | 25.22 | 24.725 | 24.87 | 431199.0 |
| 2017-11-30 | AB | Stock | 25.0 | 25.15 | 24.79 | 25.0 | 234000.0 |
| 2017-11-30 | ABAC-DELISTED | Stock | 3.08 | 3.08 | 2.9 | 2.955 | 9524.0 |
| 2017-11-30 | ABAX-DELISTED | Stock | 51.6 | 51.6 | 47.83 | 48.7 | 175244.0 |
| 2017-11-30 | ABB-DELISTED | Stock | 25.67 | 25.8 | 25.6 | 25.73 | 1860230.0 |
| 2017-11-30 | ABBNY-DELISTED | Stock | 25.67 | 25.8 | 25.6 | 25.74 | 2234750.0 |
| 2017-11-30 | ABBV | Stock | 96.36 | 97.53 | 96.21 | 96.92 | 7889600.0 |
| 2017-11-30 | ABC-DELISTED | Stock | 85.0 | 86.1 | 83.89 | 84.83 | 1469360.0 |
| 2017-11-30 | ABCB | Stock | 51.3 | 51.3 | 49.55 | 49.6 | 246800.0 |
| 2017-11-30 | ABCD-DELISTED | Stock | 5.81 | 5.95 | 5.63 | 5.91 | 83096.0 |
| 2017-11-30 | ABDC-DELISTED | Stock | 8.49 | 8.65 | 8.3448 | 8.57 | 123070.0 |
| 2017-11-30 | ABE-DELISTED | Stock | 14.05 | 14.2109 | 14.05 | 14.15 | 50775.0 |
| 2017-11-30 | ABEO | Stock | 418.75 | 435.25 | 403.75 | 432.5 | 34484.0 |
| 2017-11-30 | ABEV | Stock | 6.28 | 6.31 | 6.15 | 6.19 | 21462500.0 |
| 2017-11-30 | ABG | Stock | 67.7 | 68.25 | 65.7 | 65.8 | 146600.0 |
| 2017-11-30 | ABIL-DELISTED | Stock | 0.53 | 0.5699 | 0.4648 | 0.51 | 320025.0 |
| 2017-11-30 | ABLX-DELISTED | Stock | 22.67 | 23.47 | 22.61 | 23.06 | 169312.0 |
| 2017-11-30 | ABM | Stock | 42.44 | 42.86 | 42.02 | 42.8 | 290400.0 |
| 2017-11-30 | ABMD-DELISTED | Stock | 195.15 | 196.18 | 193.08 | 194.81 | 276940.0 |
> showing 50 of 6,517 rows — these rows as CSV