PREVIEW / stock_daily / 2015-08-03
file: by_date/stock_daily/2015/2015-08-03.parquet size: 223 KB rows: 6,660 symbols: 3,465
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-08-03 | AAPL | Stock | 30.375 | 30.6425 | 29.38 | 29.61 | 279904000.0 |
| 2015-08-03 | MSFT | Stock | 46.98 | 47.0 | 46.45 | 46.81 | 24125900.0 |
| 2015-08-03 | NVDA | Stock | 0.5028 | 0.5078 | 0.4963 | 0.5072 | 397132000.0 |
| 2015-08-03 | AMZN | Stock | 26.8725 | 27.022 | 26.468 | 26.7515 | 60284000.0 |
| 2015-08-03 | GOOGL | Stock | 32.883 | 33.3335 | 32.883 | 33.236 | 31348140.0 |
| 2015-08-03 | META | Stock | 93.53 | 95.08 | 92.8 | 94.14 | 29343100.0 |
| 2015-08-03 | TSLA | Stock | 17.7527 | 17.7807 | 17.138 | 17.3327 | 38302500.0 |
| 2015-08-03 | TLT | Stock | 122.32 | 123.75 | 122.32 | 123.55 | 11753736.0 |
| 2015-08-03 | ES | Stock | 49.77 | 50.22 | 49.58 | 49.85 | 1810000.0 |
| 2015-08-03 | CL | Stock | 67.66 | 68.47 | 67.59 | 68.42 | 3069700.0 |
| 2015-08-03 | A | Stock | 40.92 | 41.13 | 40.58 | 41.0 | 2104200.0 |
| 2015-08-03 | AA.B-DELISTED | Stock | 35.95 | 35.95 | 35.32 | 35.37 | 81479.0 |
| 2015-08-03 | AABA-DELISTED | Stock | 36.67 | 36.9762 | 36.37 | 36.7 | 9434734.0 |
| 2015-08-03 | AAC-DELISTED | Stock | 37.8 | 37.8 | 32.0432 | 32.8 | 1316950.0 |
| 2015-08-03 | AACG | Stock | 3.53 | 3.68 | 3.33 | 3.43 | 38600.0 |
| 2015-08-03 | AAIC-DELISTED | Stock | 19.13 | 19.25 | 18.88 | 19.13 | 252151.0 |
| 2015-08-03 | AAL | Stock | 40.24 | 41.85 | 40.21 | 41.71 | 9261900.0 |
| 2015-08-03 | AAMC-DELISTED | Stock | 39.4118 | 39.4118 | 37.3529 | 38.3676 | 21107.0 |
| 2015-08-03 | AAME | Stock | 3.65 | 3.72 | 3.51 | 3.72 | 1500.0 |
| 2015-08-03 | AAMI | Stock | 17.63 | 17.63 | 17.33 | 17.4 | 112800.0 |
| 2015-08-03 | AAOI | Stock | 19.59 | 19.79 | 18.6 | 19.02 | 291500.0 |
| 2015-08-03 | AAON | Stock | 14.8267 | 14.8267 | 14.42 | 14.5867 | 200100.0 |
| 2015-08-03 | AAP | Stock | 174.93 | 175.11 | 172.22 | 173.81 | 472300.0 |
| 2015-08-03 | AAT | Stock | 41.76 | 41.95 | 41.35 | 41.51 | 147400.0 |
| 2015-08-03 | AAU-DELISTED | Stock | 0.63 | 0.7799 | 0.63 | 0.7208 | 244940.0 |
| 2015-08-03 | AAUAF-DELISTED | Stock | 0.63 | 0.7799 | 0.63 | 0.7208 | 245829.0 |
| 2015-08-03 | AAV-DELISTED | Stock | 5.42 | 5.48 | 5.25 | 5.3 | 53487.0 |
| 2015-08-03 | AAVL-DELISTED | Stock | 14.78 | 15.63 | 14.65 | 15.38 | 295574.0 |
| 2015-08-03 | AAWW-DELISTED | Stock | 48.89 | 49.76 | 48.01 | 48.96 | 447163.0 |
| 2015-08-03 | AAXJ | Stock | 58.6 | 58.61 | 58.1932 | 58.35 | 3003448.0 |
| 2015-08-03 | AAXN-DELISTED | Stock | 27.03 | 27.0798 | 25.1 | 25.12 | 3536079.0 |
| 2015-08-03 | AB | Stock | 27.5 | 28.17 | 27.28 | 28.17 | 270800.0 |
| 2015-08-03 | ABAC-DELISTED | Stock | 1.0899 | 1.0899 | 1.03 | 1.06 | 9023.0 |
| 2015-08-03 | ABAX-DELISTED | Stock | 49.86 | 50.24 | 49.2 | 49.61 | 148314.0 |
| 2015-08-03 | ABB-DELISTED | Stock | 20.23 | 20.23 | 20.04 | 20.11 | 1337461.0 |
| 2015-08-03 | ABBNY-DELISTED | Stock | 20.23 | 20.23 | 20.04 | 20.1 | 1398317.0 |
| 2015-08-03 | ABBV | Stock | 70.19 | 70.79 | 69.28 | 69.73 | 9872300.0 |
| 2015-08-03 | ABC-DELISTED | Stock | 105.75 | 106.65 | 105.14 | 105.85 | 1507576.0 |
| 2015-08-03 | ABCB | Stock | 27.0 | 27.45 | 26.96 | 27.37 | 173600.0 |
| 2015-08-03 | ABCD-DELISTED | Stock | 4.68 | 4.91 | 4.6799 | 4.91 | 63559.0 |
| 2015-08-03 | ABCO-DELISTED | Stock | 59.76 | 60.24 | 58.6 | 59.37 | 177104.0 |
| 2015-08-03 | ABCW-DELISTED | Stock | 37.28 | 39.39 | 37.28 | 39.07 | 21250.0 |
| 2015-08-03 | ABDC-DELISTED | Stock | 12.5 | 12.72 | 12.35 | 12.36 | 20946.0 |
| 2015-08-03 | ABEO | Stock | 160.5 | 168.75 | 158.25 | 164.0 | 22040.0 |
| 2015-08-03 | ABEOW-DELISTED | Stock | 2.43 | 2.67 | 2.43 | 2.5 | 2608.0 |
| 2015-08-03 | ABEV | Stock | 5.65 | 5.69 | 5.61 | 5.66 | 7071600.0 |
| 2015-08-03 | ABG | Stock | 87.74 | 88.61 | 84.41 | 85.29 | 658200.0 |
| 2015-08-03 | ABGB-DELISTED | Stock | 8.24 | 8.39 | 7.67 | 7.76 | 275430.0 |
| 2015-08-03 | ABIL-DELISTED | Stock | 9.95 | 9.95 | 9.95 | 9.95 | 4000.0 |
| 2015-08-03 | ABM | Stock | 32.96 | 33.14 | 32.5 | 32.87 | 237700.0 |
> showing 50 of 6,660 rows — these rows as CSV