PREVIEW / stock_daily / 2014-05-30
file: by_date/stock_daily/2014/2014-05-30.parquet size: 219 KB rows: 6,548 symbols: 3,564
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-30 | AAPL | Stock | 22.785 | 23.0061 | 22.4607 | 22.6071 | 564020800.0 |
| 2014-05-30 | MSFT | Stock | 40.45 | 40.97 | 40.25 | 40.94 | 34567600.0 |
| 2014-05-30 | NVDA | Stock | 0.4738 | 0.4763 | 0.4713 | 0.475 | 239128000.0 |
| 2014-05-30 | AMZN | Stock | 15.7215 | 15.7325 | 15.3785 | 15.6275 | 85204000.0 |
| 2014-05-30 | GOOGL | Stock | 28.582 | 28.629 | 28.2895 | 28.5825 | 37434740.0 |
| 2014-05-30 | META | Stock | 63.95 | 64.17 | 62.56 | 63.3 | 45253500.0 |
| 2014-05-30 | TSLA | Stock | 14.02 | 14.32 | 13.8013 | 13.8513 | 83716500.0 |
| 2014-05-30 | TLT | Stock | 113.96 | 114.4 | 113.8095 | 114.1 | 6519281.0 |
| 2014-05-30 | ES | Stock | 45.07 | 45.44 | 45.02 | 45.4 | 1638600.0 |
| 2014-05-30 | CL | Stock | 66.94 | 68.47 | 66.85 | 68.4 | 7885400.0 |
| 2014-05-30 | A | Stock | 40.6795 | 40.8512 | 40.2289 | 40.7296 | 3560986.0 |
| 2014-05-30 | AABA-DELISTED | Stock | 34.88 | 34.93 | 34.13 | 34.65 | 12521768.0 |
| 2014-05-30 | AACG | Stock | 4.74 | 5.3 | 4.74 | 5.3 | 55600.0 |
| 2014-05-30 | AAIC-DELISTED | Stock | 27.59 | 27.66 | 27.5301 | 27.65 | 164706.0 |
| 2014-05-30 | AAL | Stock | 39.83 | 40.17 | 39.68 | 40.16 | 13888300.0 |
| 2014-05-30 | AAMC-DELISTED | Stock | 283.9318 | 291.1765 | 282.3529 | 289.1647 | 47192.0 |
| 2014-05-30 | AAME | Stock | 3.61 | 3.65 | 3.5 | 3.6 | 8100.0 |
| 2014-05-30 | AAOI | Stock | 21.52 | 21.8 | 20.8 | 21.41 | 244300.0 |
| 2014-05-30 | AAON | Stock | 13.9689 | 14.0133 | 13.7778 | 13.8667 | 233100.0 |
| 2014-05-30 | AAP | Stock | 122.33 | 124.3 | 122.33 | 124.17 | 679900.0 |
| 2014-05-30 | AAT | Stock | 34.55 | 34.63 | 34.28 | 34.3 | 177700.0 |
| 2014-05-30 | AAU-DELISTED | Stock | 1.38 | 1.38 | 1.3 | 1.35 | 120897.0 |
| 2014-05-30 | AAUAF-DELISTED | Stock | 1.35 | 1.35 | 1.29 | 1.35 | 126242.0 |
| 2014-05-30 | AAV-DELISTED | Stock | 5.82 | 6.06 | 5.79 | 6.02 | 496825.0 |
| 2014-05-30 | AAWW-DELISTED | Stock | 37.48 | 37.6 | 36.42 | 36.6 | 120076.0 |
| 2014-05-30 | AAXJ | Stock | 61.98 | 62.06 | 61.73 | 61.8 | 339083.0 |
| 2014-05-30 | AAXN-DELISTED | Stock | 13.52 | 13.57 | 13.23 | 13.28 | 602346.0 |
| 2014-05-30 | AB | Stock | 23.82 | 24.36 | 23.8 | 24.25 | 607400.0 |
| 2014-05-30 | ABAC-DELISTED | Stock | 2.194 | 2.2 | 2.13 | 2.17 | 41312.0 |
| 2014-05-30 | ABAX-DELISTED | Stock | 42.0 | 42.21 | 41.24 | 41.25 | 80115.0 |
| 2014-05-30 | ABB-DELISTED | Stock | 23.75 | 23.77 | 23.66 | 23.74 | 1234618.0 |
| 2014-05-30 | ABBNY-DELISTED | Stock | 23.75 | 23.77 | 23.66 | 23.74 | 1407550.0 |
| 2014-05-30 | ABBV | Stock | 53.98 | 54.43 | 53.89 | 54.33 | 4025600.0 |
| 2014-05-30 | ABC-DELISTED | Stock | 73.34 | 73.57 | 72.72 | 73.2 | 3343785.0 |
| 2014-05-30 | ABCB | Stock | 21.12 | 21.3 | 20.91 | 21.01 | 56100.0 |
| 2014-05-30 | ABCD-DELISTED | Stock | 2.2391 | 2.24 | 2.2391 | 2.24 | 800.0 |
| 2014-05-30 | ABCO-DELISTED | Stock | 49.19 | 49.27 | 48.05 | 48.38 | 157286.0 |
| 2014-05-30 | ABDC-DELISTED | Stock | 14.81 | 14.9 | 14.8 | 14.9 | 4900.0 |
| 2014-05-30 | ABE-DELISTED | Stock | 14.09 | 14.09 | 14.04 | 14.05 | 10654.0 |
| 2014-05-30 | ABEO | Stock | 525.0 | 537.5 | 475.0 | 537.5 | 32.0 |
| 2014-05-30 | ABEV | Stock | 7.17 | 7.2 | 7.04 | 7.04 | 12738700.0 |
| 2014-05-30 | ABG | Stock | 64.77 | 65.02 | 64.44 | 64.64 | 125100.0 |
| 2014-05-30 | ABGB-DELISTED | Stock | 23.49 | 23.91 | 23.45 | 23.873 | 10825.0 |
| 2014-05-30 | ABIL-DELISTED | Stock | 9.77 | 9.77 | 9.77 | 9.77 | 200.0 |
| 2014-05-30 | ABM | Stock | 27.41 | 27.43 | 27.06 | 27.27 | 150300.0 |
| 2014-05-30 | ABMD-DELISTED | Stock | 22.05 | 22.86 | 21.99 | 22.8 | 537208.0 |
| 2014-05-30 | ABR | Stock | 7.32 | 7.32 | 7.22 | 7.27 | 131200.0 |
| 2014-05-30 | ABR.A-DELISTED | Stock | 24.4 | 24.42 | 24.35 | 24.38 | 16255.0 |
| 2014-05-30 | ABR.B-DELISTED | Stock | 23.83 | 23.84 | 23.83 | 23.84 | 3240.0 |
| 2014-05-30 | ABR.C-DELISTED | Stock | 25.001 | 25.05 | 25.0 | 25.0499 | 3200.0 |
> showing 50 of 6,548 rows — these rows as CSV