PREVIEW / stock_daily / 2017-06-15
file: by_date/stock_daily/2017/2017-06-15.parquet size: 214 KB rows: 6,451 symbols: 3,006
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-06-15 | AAPL | Stock | 35.83 | 36.12 | 35.5525 | 36.0725 | 128661600.0 |
| 2017-06-15 | MSFT | Stock | 69.27 | 70.21 | 68.8 | 69.9 | 26068700.0 |
| 2017-06-15 | NVDA | Stock | 3.674 | 3.84 | 3.6625 | 3.8093 | 963824000.0 |
| 2017-06-15 | AMZN | Stock | 47.935 | 48.2865 | 47.543 | 48.2085 | 107478000.0 |
| 2017-06-15 | GOOGL | Stock | 47.401 | 48.0339 | 47.0185 | 48.009 | 48552780.0 |
| 2017-06-15 | META | Stock | 147.67 | 150.04 | 146.37 | 149.8 | 18994200.0 |
| 2017-06-15 | TSLA | Stock | 24.8333 | 25.0307 | 24.4327 | 25.0227 | 156397500.0 |
| 2017-06-15 | TLT | Stock | 126.09 | 126.33 | 125.83 | 126.1 | 5863708.0 |
| 2017-06-15 | ES | Stock | 62.43 | 62.7 | 62.18 | 62.62 | 1008000.0 |
| 2017-06-15 | CL | Stock | 75.71 | 76.57 | 75.52 | 76.35 | 2226500.0 |
| 2017-06-15 | A | Stock | 59.22 | 59.29 | 58.82 | 59.21 | 1091800.0 |
| 2017-06-15 | AA | Stock | 31.12 | 31.45 | 30.61 | 30.74 | 3226900.0 |
| 2017-06-15 | AAAP-DELISTED | Stock | 36.22 | 38.545 | 36.22 | 37.0 | 180455.0 |
| 2017-06-15 | AABA-DELISTED | Stock | 52.18 | 52.76 | 51.645 | 52.62 | 58204073.0 |
| 2017-06-15 | AAC-DELISTED | Stock | 6.69 | 6.8 | 6.59 | 6.62 | 29258.0 |
| 2017-06-15 | AACG | Stock | 4.77 | 4.83 | 4.61 | 4.83 | 24200.0 |
| 2017-06-15 | AAIC-DELISTED | Stock | 14.62 | 14.7901 | 14.62 | 14.7 | 373026.0 |
| 2017-06-15 | AAL | Stock | 49.14 | 49.32 | 48.37 | 49.11 | 4579600.0 |
| 2017-06-15 | AAM.A-DELISTED | Stock | 25.69 | 25.69 | 25.57 | 25.64 | 74743.0 |
| 2017-06-15 | AAMC-DELISTED | Stock | 25.8235 | 25.8235 | 24.7353 | 24.7353 | 1720.0 |
| 2017-06-15 | AAME | Stock | 3.75 | 3.75 | 3.65 | 3.65 | 1200.0 |
| 2017-06-15 | AAMI | Stock | 14.67 | 14.88 | 14.65 | 14.7 | 785400.0 |
| 2017-06-15 | AAOI | Stock | 58.25 | 62.99 | 57.55 | 62.23 | 4006600.0 |
| 2017-06-15 | AAON | Stock | 25.1333 | 25.4667 | 25.0667 | 25.1 | 144450.0 |
| 2017-06-15 | AAP | Stock | 130.53 | 131.81 | 129.1 | 131.15 | 1220600.0 |
| 2017-06-15 | AAT | Stock | 40.57 | 41.15 | 40.57 | 40.88 | 326900.0 |
| 2017-06-15 | AAU-DELISTED | Stock | 1.35 | 1.36 | 1.32 | 1.345 | 109802.0 |
| 2017-06-15 | AAUAF-DELISTED | Stock | 1.35 | 1.36 | 1.32 | 1.36 | 112065.0 |
| 2017-06-15 | AAV-DELISTED | Stock | 6.1 | 6.2 | 6.05 | 6.1 | 85132.0 |
| 2017-06-15 | AAWW-DELISTED | Stock | 52.65 | 53.25 | 52.1 | 52.75 | 134693.0 |
| 2017-06-15 | AAXJ | Stock | 66.95 | 67.1405 | 66.76 | 67.1 | 660321.0 |
| 2017-06-15 | AAXN-DELISTED | Stock | 24.1 | 25.0 | 24.04 | 24.76 | 515444.0 |
| 2017-06-15 | AB | Stock | 23.1 | 23.3 | 22.95 | 23.1 | 314600.0 |
| 2017-06-15 | ABAC-DELISTED | Stock | 2.1 | 2.16 | 2.0982 | 2.12 | 8851.0 |
| 2017-06-15 | ABAX-DELISTED | Stock | 51.29 | 51.83 | 50.93 | 51.59 | 95390.0 |
| 2017-06-15 | ABB-DELISTED | Stock | 24.77 | 24.94 | 24.75 | 24.915 | 1992764.0 |
| 2017-06-15 | ABBNY-DELISTED | Stock | 24.77 | 24.94 | 24.75 | 24.91 | 2043441.0 |
| 2017-06-15 | ABBV | Stock | 70.34 | 70.65 | 69.88 | 70.6 | 4682700.0 |
| 2017-06-15 | ABC-DELISTED | Stock | 93.57 | 95.18 | 92.75 | 94.44 | 1543913.0 |
| 2017-06-15 | ABCB | Stock | 47.65 | 48.8 | 47.65 | 48.4 | 74800.0 |
| 2017-06-15 | ABCD-DELISTED | Stock | 4.9 | 4.95 | 4.895 | 4.95 | 7335.0 |
| 2017-06-15 | ABCO-DELISTED | Stock | 51.3 | 51.8 | 51.0 | 51.45 | 98104.0 |
| 2017-06-15 | ABDC-DELISTED | Stock | 13.3 | 13.5203 | 13.3 | 13.3 | 30994.0 |
| 2017-06-15 | ABE-DELISTED | Stock | 13.81 | 13.81 | 13.71 | 13.7848 | 1787.0 |
| 2017-06-15 | ABEO | Stock | 123.75 | 126.25 | 117.5 | 118.75 | 5872.0 |
| 2017-06-15 | ABEV | Stock | 5.48 | 5.49 | 5.42 | 5.45 | 13059900.0 |
| 2017-06-15 | ABG | Stock | 57.3 | 58.3 | 56.05 | 57.75 | 99900.0 |
| 2017-06-15 | ABIL-DELISTED | Stock | 1.34 | 1.35 | 1.23 | 1.28 | 659117.0 |
| 2017-06-15 | ABM | Stock | 40.43 | 41.19 | 40.36 | 41.17 | 324600.0 |
| 2017-06-15 | ABMD-DELISTED | Stock | 141.01 | 143.29 | 140.288 | 142.88 | 175488.0 |
> showing 50 of 6,451 rows — these rows as CSV