PREVIEW / stock_daily / 2017-05-24
file: by_date/stock_daily/2017/2017-05-24.parquet size: 214 KB rows: 6,426 symbols: 2,999
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-24 | AAPL | Stock | 38.46 | 38.5425 | 38.1675 | 38.335 | 76712000.0 |
| 2017-05-24 | MSFT | Stock | 68.87 | 68.88 | 68.45 | 68.77 | 14593900.0 |
| 2017-05-24 | NVDA | Stock | 3.524 | 3.5268 | 3.452 | 3.4642 | 815996000.0 |
| 2017-05-24 | AMZN | Stock | 48.8 | 49.05 | 48.5115 | 49.0175 | 48920000.0 |
| 2017-05-24 | GOOGL | Stock | 48.763 | 48.9058 | 48.5815 | 48.8805 | 22849760.0 |
| 2017-05-24 | META | Stock | 148.51 | 150.23 | 148.42 | 150.04 | 17862400.0 |
| 2017-05-24 | TSLA | Stock | 20.434 | 20.7333 | 20.36 | 20.6813 | 75499500.0 |
| 2017-05-24 | TLT | Stock | 122.8 | 123.26 | 122.54 | 123.23 | 7468346.0 |
| 2017-05-24 | ES | Stock | 61.28 | 61.46 | 61.14 | 61.41 | 1023300.0 |
| 2017-05-24 | CL | Stock | 74.05 | 74.72 | 73.93 | 74.6 | 2595700.0 |
| 2017-05-24 | A | Stock | 58.5 | 59.34 | 58.07 | 59.23 | 4060100.0 |
| 2017-05-24 | AA | Stock | 33.27 | 33.92 | 33.045 | 33.51 | 3338200.0 |
| 2017-05-24 | AAAP-DELISTED | Stock | 38.15 | 39.76 | 37.9 | 38.74 | 112802.0 |
| 2017-05-24 | AABA-DELISTED | Stock | 50.4 | 50.59 | 49.9 | 50.32 | 10600519.0 |
| 2017-05-24 | AAC-DELISTED | Stock | 7.18 | 7.2397 | 7.01 | 7.02 | 344089.0 |
| 2017-05-24 | AACG | Stock | 3.53 | 3.53 | 3.5 | 3.53 | 3300.0 |
| 2017-05-24 | AAIC-DELISTED | Stock | 14.45 | 14.58 | 14.42 | 14.48 | 330152.0 |
| 2017-05-24 | AAL | Stock | 46.74 | 47.43 | 46.65 | 46.77 | 3885100.0 |
| 2017-05-24 | AAM.A-DELISTED | Stock | 25.75 | 25.81 | 25.65 | 25.72 | 68140.0 |
| 2017-05-24 | AAMC-DELISTED | Stock | 23.6029 | 27.3529 | 23.6029 | 26.1765 | 72498.0 |
| 2017-05-24 | AAMI | Stock | 14.05 | 14.05 | 13.69 | 13.81 | 551200.0 |
| 2017-05-24 | AAOI | Stock | 68.25 | 70.23 | 67.86 | 68.63 | 2010100.0 |
| 2017-05-24 | AAON | Stock | 24.5 | 24.7 | 24.1667 | 24.6 | 179850.0 |
| 2017-05-24 | AAP | Stock | 131.65 | 135.9 | 131.3 | 133.02 | 5963900.0 |
| 2017-05-24 | AAT | Stock | 39.22 | 39.93 | 39.22 | 39.62 | 330100.0 |
| 2017-05-24 | AAU-DELISTED | Stock | 1.25 | 1.2854 | 1.24 | 1.25 | 179331.0 |
| 2017-05-24 | AAUAF-DELISTED | Stock | 1.25 | 1.2854 | 1.24 | 1.26 | 182330.0 |
| 2017-05-24 | AAV-DELISTED | Stock | 6.7 | 6.75 | 6.5 | 6.6 | 124509.0 |
| 2017-05-24 | AAWW-DELISTED | Stock | 48.7 | 48.85 | 48.05 | 48.65 | 206217.0 |
| 2017-05-24 | AAXJ | Stock | 66.43 | 66.55 | 66.335 | 66.48 | 1100479.0 |
| 2017-05-24 | AAXN-DELISTED | Stock | 24.88 | 25.01 | 24.69 | 24.8 | 407793.0 |
| 2017-05-24 | AB | Stock | 21.1 | 21.28 | 20.85 | 20.95 | 567600.0 |
| 2017-05-24 | ABAC-DELISTED | Stock | 1.901 | 1.9356 | 1.89 | 1.89 | 23726.0 |
| 2017-05-24 | ABAX-DELISTED | Stock | 48.15 | 48.84 | 47.81 | 48.665 | 45320.0 |
| 2017-05-24 | ABB-DELISTED | Stock | 24.91 | 25.075 | 24.89 | 24.965 | 1183983.0 |
| 2017-05-24 | ABBNY-DELISTED | Stock | 24.92 | 25.075 | 24.89 | 24.97 | 1228189.0 |
| 2017-05-24 | ABBV | Stock | 65.79 | 66.12 | 65.57 | 65.93 | 3174600.0 |
| 2017-05-24 | ABC-DELISTED | Stock | 89.38 | 90.32 | 88.55 | 89.99 | 964315.0 |
| 2017-05-24 | ABCB | Stock | 45.4 | 46.25 | 45.0 | 45.25 | 140800.0 |
| 2017-05-24 | ABCD-DELISTED | Stock | 5.01 | 5.17 | 4.99 | 4.99 | 9888.0 |
| 2017-05-24 | ABCO-DELISTED | Stock | 51.0 | 51.3 | 50.85 | 50.85 | 162517.0 |
| 2017-05-24 | ABDC-DELISTED | Stock | 13.46 | 13.54 | 13.39 | 13.4 | 145453.0 |
| 2017-05-24 | ABE-DELISTED | Stock | 13.82 | 13.82 | 13.8193 | 13.8193 | 1431.0 |
| 2017-05-24 | ABEO | Stock | 147.5 | 148.75 | 146.25 | 147.5 | 2708.0 |
| 2017-05-24 | ABEV | Stock | 5.79 | 5.8 | 5.72 | 5.74 | 27494900.0 |
| 2017-05-24 | ABG | Stock | 55.75 | 57.3 | 55.65 | 56.25 | 120400.0 |
| 2017-05-24 | ABIL-DELISTED | Stock | 0.7 | 0.77 | 0.65 | 0.685 | 82874.0 |
| 2017-05-24 | ABM | Stock | 42.16 | 42.36 | 41.98 | 42.1 | 156900.0 |
| 2017-05-24 | ABMD-DELISTED | Stock | 135.0 | 135.44 | 134.105 | 134.89 | 347774.0 |
| 2017-05-24 | ABR | Stock | 8.25 | 8.29 | 8.16 | 8.19 | 491900.0 |
> showing 50 of 6,426 rows — these rows as CSV