PREVIEW / stock_daily / 2015-05-05
file: by_date/stock_daily/2015/2015-05-05.parquet size: 224 KB rows: 6,680 symbols: 3,523
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-05-05 | AAPL | Stock | 32.0375 | 32.1125 | 31.445 | 31.45 | 197085600.0 |
| 2015-05-05 | MSFT | Stock | 47.82 | 48.16 | 47.31 | 47.6 | 50369200.0 |
| 2015-05-05 | NVDA | Stock | 0.5632 | 0.564 | 0.5482 | 0.5508 | 292928000.0 |
| 2015-05-05 | AMZN | Stock | 21.1425 | 21.3755 | 21.051 | 21.0595 | 57128000.0 |
| 2015-05-05 | GOOGL | Stock | 27.508 | 27.6305 | 27.1185 | 27.1522 | 28528340.0 |
| 2015-05-05 | META | Stock | 78.55 | 78.8 | 77.22 | 77.56 | 22311300.0 |
| 2015-05-05 | TSLA | Stock | 15.8507 | 15.9667 | 15.2753 | 15.53 | 86953500.0 |
| 2015-05-05 | TLT | Stock | 122.86 | 123.03 | 121.69 | 122.66 | 13935494.0 |
| 2015-05-05 | ES | Stock | 49.41 | 49.5 | 48.09 | 48.22 | 1257000.0 |
| 2015-05-05 | CL | Stock | 68.14 | 68.24 | 67.32 | 67.38 | 3182200.0 |
| 2015-05-05 | A | Stock | 41.72 | 41.85 | 41.46 | 41.59 | 1254800.0 |
| 2015-05-05 | AA.B-DELISTED | Stock | 47.22 | 47.33 | 46.41 | 46.49 | 152461.0 |
| 2015-05-05 | AABA-DELISTED | Stock | 41.84 | 42.0 | 40.81 | 41.31 | 17647198.0 |
| 2015-05-05 | AAC-DELISTED | Stock | 34.1 | 34.2 | 31.91 | 32.0 | 112413.0 |
| 2015-05-05 | AACG | Stock | 4.42 | 4.49 | 4.41 | 4.49 | 8500.0 |
| 2015-05-05 | AAIC-DELISTED | Stock | 21.65 | 21.79 | 21.35 | 21.37 | 383434.0 |
| 2015-05-05 | AAL | Stock | 48.21 | 48.71 | 46.9 | 47.01 | 11385000.0 |
| 2015-05-05 | AAMC-DELISTED | Stock | 63.8265 | 66.1765 | 63.8265 | 64.7059 | 85377.0 |
| 2015-05-05 | AAME | Stock | 3.96 | 3.96 | 3.88 | 3.96 | 5900.0 |
| 2015-05-05 | AAMI | Stock | 19.54 | 19.65 | 19.25 | 19.62 | 88900.0 |
| 2015-05-05 | AAOI | Stock | 13.71 | 14.07 | 13.21 | 13.44 | 252600.0 |
| 2015-05-05 | AAON | Stock | 16.0333 | 16.1667 | 15.7867 | 15.8933 | 143100.0 |
| 2015-05-05 | AAP | Stock | 145.45 | 145.73 | 143.42 | 143.99 | 680100.0 |
| 2015-05-05 | AAT | Stock | 40.1 | 40.63 | 39.16 | 39.28 | 242900.0 |
| 2015-05-05 | AAU-DELISTED | Stock | 0.81 | 0.82 | 0.7985 | 0.802 | 30293.0 |
| 2015-05-05 | AAUAF-DELISTED | Stock | 0.81 | 0.8205 | 0.8 | 0.804 | 30898.0 |
| 2015-05-05 | AAV-DELISTED | Stock | 6.14 | 6.231 | 5.93 | 5.96 | 95746.0 |
| 2015-05-05 | AAVL-DELISTED | Stock | 30.8 | 31.03 | 29.05 | 29.46 | 167599.0 |
| 2015-05-05 | AAWW-DELISTED | Stock | 53.97 | 56.125 | 53.43 | 55.25 | 830519.0 |
| 2015-05-05 | AAXJ | Stock | 68.45 | 68.55 | 67.89 | 67.98 | 1188897.0 |
| 2015-05-05 | AAXN-DELISTED | Stock | 33.97 | 35.0 | 33.87 | 34.6 | 5923242.0 |
| 2015-05-05 | AB | Stock | 32.41 | 32.5 | 31.7 | 31.8 | 360400.0 |
| 2015-05-05 | ABAC-DELISTED | Stock | 1.6218 | 1.67 | 1.62 | 1.62 | 15241.0 |
| 2015-05-05 | ABAX-DELISTED | Stock | 55.02 | 55.24 | 53.08 | 53.14 | 227118.0 |
| 2015-05-05 | ABB-DELISTED | Stock | 21.57 | 21.62 | 21.33 | 21.35 | 1370914.0 |
| 2015-05-05 | ABBNY-DELISTED | Stock | 21.57 | 21.62 | 21.33 | 21.34 | 1642099.0 |
| 2015-05-05 | ABBV | Stock | 64.2 | 64.9 | 63.78 | 63.86 | 7635900.0 |
| 2015-05-05 | ABC-DELISTED | Stock | 115.62 | 115.75 | 114.4 | 114.69 | 1529033.0 |
| 2015-05-05 | ABCB | Stock | 24.71 | 24.9 | 24.42 | 24.76 | 398700.0 |
| 2015-05-05 | ABCD-DELISTED | Stock | 3.0 | 3.0 | 2.95 | 2.9646 | 11362.0 |
| 2015-05-05 | ABCO-DELISTED | Stock | 51.75 | 52.53 | 48.69 | 50.95 | 311121.0 |
| 2015-05-05 | ABCW-DELISTED | Stock | 36.63 | 37.6499 | 36.48 | 37.21 | 27344.0 |
| 2015-05-05 | ABDC-DELISTED | Stock | 13.69 | 13.85 | 13.69 | 13.76 | 20639.0 |
| 2015-05-05 | ABE-DELISTED | Stock | 13.19 | 13.26 | 13.13 | 13.15 | 48748.0 |
| 2015-05-05 | ABEO | Stock | 113.5 | 194.25 | 108.25 | 149.25 | 2504692.0 |
| 2015-05-05 | ABEOW-DELISTED | Stock | 2.03 | 3.49 | 1.8 | 2.63 | 613430.0 |
| 2015-05-05 | ABEV | Stock | 6.25 | 6.41 | 6.24 | 6.39 | 13199000.0 |
| 2015-05-05 | ABG | Stock | 85.02 | 85.98 | 83.63 | 83.73 | 269700.0 |
| 2015-05-05 | ABGB-DELISTED | Stock | 16.05 | 16.33 | 15.98 | 16.24 | 31512.0 |
| 2015-05-05 | ABIL-DELISTED | Stock | 10.2 | 10.75 | 10.2 | 10.48 | 2271.0 |
> showing 50 of 6,680 rows — these rows as CSV