PREVIEW / stock_daily / 2017-05-15
file: by_date/stock_daily/2017/2017-05-15.parquet size: 215 KB rows: 6,452 symbols: 3,007
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-05-15 | AAPL | Stock | 39.0025 | 39.1625 | 38.7625 | 38.925 | 104038800.0 |
| 2017-05-15 | MSFT | Stock | 68.14 | 68.48 | 67.57 | 68.43 | 31530300.0 |
| 2017-05-15 | NVDA | Stock | 3.239 | 3.3602 | 3.2345 | 3.3578 | 1087540000.0 |
| 2017-05-15 | AMZN | Stock | 47.9365 | 48.1575 | 47.803 | 47.8985 | 85412000.0 |
| 2017-05-15 | GOOGL | Stock | 47.7645 | 48.135 | 47.641 | 47.961 | 26753940.0 |
| 2017-05-15 | META | Stock | 150.17 | 151.48 | 149.77 | 150.19 | 15064700.0 |
| 2017-05-15 | TSLA | Stock | 21.2253 | 21.3467 | 20.8353 | 21.0587 | 114330000.0 |
| 2017-05-15 | TLT | Stock | 121.06 | 121.21 | 120.75 | 121.06 | 5173188.0 |
| 2017-05-15 | ES | Stock | 59.89 | 60.2 | 59.67 | 60.15 | 833400.0 |
| 2017-05-15 | CL | Stock | 71.3 | 71.84 | 71.28 | 71.65 | 2489600.0 |
| 2017-05-15 | A | Stock | 56.07 | 56.76 | 56.01 | 56.7 | 1472200.0 |
| 2017-05-15 | AA | Stock | 32.17 | 32.5 | 31.97 | 32.03 | 2384000.0 |
| 2017-05-15 | AAAP-DELISTED | Stock | 35.99 | 36.555 | 35.11 | 36.27 | 51554.0 |
| 2017-05-15 | AABA-DELISTED | Stock | 49.72 | 49.94 | 49.48 | 49.86 | 8306410.0 |
| 2017-05-15 | AAC-DELISTED | Stock | 7.17 | 7.325 | 7.01 | 7.23 | 78237.0 |
| 2017-05-15 | AACG | Stock | 3.75 | 3.75 | 3.58 | 3.58 | 1000.0 |
| 2017-05-15 | AAIC-DELISTED | Stock | 14.2 | 14.27 | 14.125 | 14.15 | 236886.0 |
| 2017-05-15 | AAL | Stock | 45.7 | 46.99 | 45.69 | 46.68 | 5534500.0 |
| 2017-05-15 | AAM.A-DELISTED | Stock | 25.8 | 25.86 | 25.75 | 25.85 | 52769.0 |
| 2017-05-15 | AAMC-DELISTED | Stock | 20.4706 | 22.3529 | 20.4706 | 21.6029 | 17235.0 |
| 2017-05-15 | AAME | Stock | 3.6 | 3.63 | 3.55 | 3.6 | 6800.0 |
| 2017-05-15 | AAMI | Stock | 15.11 | 15.37 | 15.11 | 15.14 | 404000.0 |
| 2017-05-15 | AAOI | Stock | 65.8 | 66.4 | 63.25 | 64.01 | 3112500.0 |
| 2017-05-15 | AAON | Stock | 24.2 | 24.5667 | 24.2 | 24.4 | 128850.0 |
| 2017-05-15 | AAP | Stock | 144.66 | 147.15 | 144.49 | 145.85 | 1097700.0 |
| 2017-05-15 | AAT | Stock | 39.37 | 39.69 | 39.14 | 39.31 | 176900.0 |
| 2017-05-15 | AAU-DELISTED | Stock | 1.48 | 1.48 | 1.3 | 1.36 | 430786.0 |
| 2017-05-15 | AAUAF-DELISTED | Stock | 1.48 | 1.48 | 1.3 | 1.36 | 445290.0 |
| 2017-05-15 | AAV-DELISTED | Stock | 6.6 | 6.675 | 6.525 | 6.6 | 76022.0 |
| 2017-05-15 | AAWW-DELISTED | Stock | 49.8 | 50.35 | 49.1 | 49.4 | 159097.0 |
| 2017-05-15 | AAXJ | Stock | 66.23 | 66.43 | 66.15 | 66.43 | 1104618.0 |
| 2017-05-15 | AAXN-DELISTED | Stock | 25.99 | 26.04 | 25.15 | 25.15 | 851421.0 |
| 2017-05-15 | AB | Stock | 21.15 | 21.4 | 21.05 | 21.25 | 685800.0 |
| 2017-05-15 | ABAC-DELISTED | Stock | 1.84 | 1.8495 | 1.77 | 1.7929 | 16270.0 |
| 2017-05-15 | ABAX-DELISTED | Stock | 47.56 | 48.43 | 47.21 | 48.1 | 69634.0 |
| 2017-05-15 | ABB-DELISTED | Stock | 24.75 | 24.84 | 24.73 | 24.78 | 1305558.0 |
| 2017-05-15 | ABBNY-DELISTED | Stock | 24.75 | 24.84 | 24.73 | 24.78 | 1369865.0 |
| 2017-05-15 | ABBV | Stock | 66.07 | 66.85 | 65.95 | 66.67 | 8527900.0 |
| 2017-05-15 | ABC-DELISTED | Stock | 88.49 | 90.99 | 88.47 | 89.91 | 1806567.0 |
| 2017-05-15 | ABCB | Stock | 44.8 | 45.45 | 44.35 | 45.4 | 228000.0 |
| 2017-05-15 | ABCD-DELISTED | Stock | 5.16 | 5.25 | 5.01 | 5.1 | 40380.0 |
| 2017-05-15 | ABCO-DELISTED | Stock | 51.4 | 52.5 | 51.35 | 52.1 | 207975.0 |
| 2017-05-15 | ABDC-DELISTED | Stock | 14.21 | 14.4 | 14.21 | 14.36 | 16504.0 |
| 2017-05-15 | ABE-DELISTED | Stock | 13.9 | 13.97 | 13.9 | 13.97 | 3755.0 |
| 2017-05-15 | ABEO | Stock | 157.5 | 160.0 | 151.25 | 155.0 | 13580.0 |
| 2017-05-15 | ABEOW-DELISTED | Stock | 3.4 | 3.5 | 3.4 | 3.5 | 1795.0 |
| 2017-05-15 | ABEV | Stock | 6.28 | 6.35 | 6.24 | 6.33 | 48047900.0 |
| 2017-05-15 | ABG | Stock | 56.35 | 57.65 | 56.35 | 57.05 | 163800.0 |
| 2017-05-15 | ABIL-DELISTED | Stock | 0.7001 | 0.7305 | 0.68 | 0.681 | 5879.0 |
| 2017-05-15 | ABM | Stock | 42.28 | 42.62 | 42.28 | 42.5 | 144700.0 |
> showing 50 of 6,452 rows — these rows as CSV