PREVIEW / stock_daily / 2015-07-24
file: by_date/stock_daily/2015/2015-07-24.parquet size: 224 KB rows: 6,657 symbols: 3,477
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-24 | AAPL | Stock | 31.33 | 31.435 | 30.975 | 31.125 | 168649200.0 |
| 2015-07-24 | MSFT | Stock | 45.91 | 46.32 | 45.8 | 45.94 | 32333200.0 |
| 2015-07-24 | NVDA | Stock | 0.4948 | 0.4952 | 0.4835 | 0.4855 | 188844000.0 |
| 2015-07-24 | AMZN | Stock | 28.9495 | 29.0285 | 26.4675 | 26.471 | 438188000.0 |
| 2015-07-24 | GOOGL | Stock | 33.8385 | 33.8895 | 32.659 | 32.7385 | 82622740.0 |
| 2015-07-24 | META | Stock | 97.35 | 97.76 | 95.88 | 96.95 | 33444900.0 |
| 2015-07-24 | TSLA | Stock | 17.8253 | 18.0727 | 17.5947 | 17.694 | 42547500.0 |
| 2015-07-24 | TLT | Stock | 121.5 | 121.55 | 120.92 | 121.39 | 7307882.0 |
| 2015-07-24 | ES | Stock | 47.29 | 47.56 | 47.04 | 47.21 | 2538800.0 |
| 2015-07-24 | CL | Stock | 67.01 | 67.15 | 66.78 | 67.0 | 2317000.0 |
| 2015-07-24 | A | Stock | 40.11 | 40.17 | 39.22 | 39.31 | 1844900.0 |
| 2015-07-24 | AA.B-DELISTED | Stock | 37.63 | 37.63 | 35.97 | 36.33 | 29730.0 |
| 2015-07-24 | AABA-DELISTED | Stock | 39.58 | 39.58 | 38.67 | 38.84 | 7804694.0 |
| 2015-07-24 | AAC-DELISTED | Stock | 38.53 | 39.1 | 37.6 | 38.86 | 227776.0 |
| 2015-07-24 | AACG | Stock | 4.02 | 4.19 | 3.96 | 3.96 | 22000.0 |
| 2015-07-24 | AAIC-DELISTED | Stock | 19.37 | 19.498 | 18.7 | 18.88 | 625871.0 |
| 2015-07-24 | AAL | Stock | 43.0 | 43.11 | 39.62 | 39.63 | 20152600.0 |
| 2015-07-24 | AAMC-DELISTED | Stock | 40.7294 | 42.0088 | 40.5853 | 40.5941 | 15120.0 |
| 2015-07-24 | AAME | Stock | 3.65 | 3.65 | 3.65 | 3.65 | 1200.0 |
| 2015-07-24 | AAMI | Stock | 17.49 | 17.56 | 17.195 | 17.25 | 195900.0 |
| 2015-07-24 | AAOI | Stock | 18.71 | 18.92 | 18.4 | 18.55 | 198100.0 |
| 2015-07-24 | AAON | Stock | 15.0533 | 15.0933 | 14.6667 | 14.7667 | 166650.0 |
| 2015-07-24 | AAP | Stock | 168.66 | 170.06 | 167.8 | 168.31 | 529500.0 |
| 2015-07-24 | AAT | Stock | 41.23 | 41.84 | 41.11 | 41.55 | 206000.0 |
| 2015-07-24 | AAU-DELISTED | Stock | 0.653 | 0.657 | 0.6289 | 0.64 | 85033.0 |
| 2015-07-24 | AAUAF-DELISTED | Stock | 0.635 | 0.639 | 0.612 | 0.639 | 89315.0 |
| 2015-07-24 | AAV-DELISTED | Stock | 5.51 | 5.56 | 5.46 | 5.52 | 53884.0 |
| 2015-07-24 | AAVL-DELISTED | Stock | 15.37 | 15.52 | 14.55 | 14.73 | 774515.0 |
| 2015-07-24 | AAWW-DELISTED | Stock | 49.4 | 50.192 | 48.39 | 48.63 | 366308.0 |
| 2015-07-24 | AAXJ | Stock | 60.05 | 60.09 | 59.475 | 59.69 | 1237113.0 |
| 2015-07-24 | AAXN-DELISTED | Stock | 31.84 | 32.2049 | 30.6351 | 30.9001 | 1498145.0 |
| 2015-07-24 | AB | Stock | 27.46 | 27.54 | 26.22 | 26.48 | 477200.0 |
| 2015-07-24 | ABAC-DELISTED | Stock | 1.19 | 1.23 | 1.1624 | 1.23 | 14454.0 |
| 2015-07-24 | ABAX-DELISTED | Stock | 51.0 | 52.08 | 47.27 | 48.82 | 820401.0 |
| 2015-07-24 | ABB-DELISTED | Stock | 20.36 | 20.38 | 19.97 | 20.02 | 2558791.0 |
| 2015-07-24 | ABBNY-DELISTED | Stock | 20.36 | 20.38 | 19.97 | 20.0 | 2708619.0 |
| 2015-07-24 | ABBV | Stock | 67.53 | 69.02 | 67.35 | 68.08 | 13495200.0 |
| 2015-07-24 | ABC-DELISTED | Stock | 109.77 | 110.144 | 108.45 | 108.78 | 1890973.0 |
| 2015-07-24 | ABCB | Stock | 25.35 | 26.19 | 25.16 | 25.98 | 311500.0 |
| 2015-07-24 | ABCD-DELISTED | Stock | 4.98 | 5.07 | 4.86 | 4.93 | 65285.0 |
| 2015-07-24 | ABCO-DELISTED | Stock | 57.32 | 57.8 | 56.93 | 57.11 | 264384.0 |
| 2015-07-24 | ABCW-DELISTED | Stock | 38.32 | 38.62 | 37.47 | 37.47 | 16794.0 |
| 2015-07-24 | ABDC-DELISTED | Stock | 12.83 | 12.83 | 12.66 | 12.67 | 36837.0 |
| 2015-07-24 | ABE-DELISTED | Stock | 12.9 | 12.9 | 12.46 | 12.48 | 2618.0 |
| 2015-07-24 | ABEO | Stock | 147.25 | 151.75 | 142.75 | 143.5 | 9808.0 |
| 2015-07-24 | ABEOW-DELISTED | Stock | 2.09 | 2.09 | 1.93 | 1.93 | 390.0 |
| 2015-07-24 | ABEV | Stock | 5.76 | 5.77 | 5.62 | 5.65 | 30081500.0 |
| 2015-07-24 | ABG | Stock | 87.91 | 88.51 | 83.7 | 84.53 | 439000.0 |
| 2015-07-24 | ABGB-DELISTED | Stock | 11.94 | 12.4999 | 11.8 | 12.35 | 106761.0 |
| 2015-07-24 | ABIL-DELISTED | Stock | 9.95 | 9.99 | 9.95 | 9.99 | 520.0 |
> showing 50 of 6,657 rows — these rows as CSV