PREVIEW / stock_daily / 2015-10-26
file: by_date/stock_daily/2015/2015-10-26.parquet size: 221 KB rows: 6,641 symbols: 3,430
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-10-26 | AAPL | Stock | 29.52 | 29.5325 | 28.73 | 28.82 | 265335200.0 |
| 2015-10-26 | MSFT | Stock | 52.53 | 54.32 | 52.5 | 54.25 | 64633300.0 |
| 2015-10-26 | NVDA | Stock | 0.7153 | 0.717 | 0.705 | 0.7115 | 247436000.0 |
| 2015-10-26 | AMZN | Stock | 30.115 | 30.4925 | 29.8145 | 30.4305 | 85394000.0 |
| 2015-10-26 | GOOGL | Stock | 36.001 | 36.7475 | 36.001 | 36.556 | 48776940.0 |
| 2015-10-26 | META | Stock | 102.2 | 103.81 | 101.55 | 103.77 | 25961200.0 |
| 2015-10-26 | TSLA | Stock | 14.092 | 14.392 | 14.0 | 14.3507 | 50871000.0 |
| 2015-10-26 | TLT | Stock | 123.87 | 124.2 | 123.81 | 124.02 | 5859785.0 |
| 2015-10-26 | ES | Stock | 51.78 | 52.09 | 51.36 | 52.05 | 903000.0 |
| 2015-10-26 | CL | Stock | 68.82 | 69.32 | 68.66 | 68.72 | 3933600.0 |
| 2015-10-26 | A | Stock | 36.98 | 37.11 | 36.69 | 36.83 | 1948400.0 |
| 2015-10-26 | AA.B-DELISTED | Stock | 33.44 | 33.44 | 31.85 | 32.05 | 84693.0 |
| 2015-10-26 | AABA-DELISTED | Stock | 33.13 | 33.49 | 33.0 | 33.4 | 15222239.0 |
| 2015-10-26 | AAC-DELISTED | Stock | 26.01 | 26.61 | 25.05 | 26.15 | 155479.0 |
| 2015-10-26 | AACG | Stock | 3.75 | 3.98 | 3.74 | 3.9 | 18300.0 |
| 2015-10-26 | AAIC-DELISTED | Stock | 15.09 | 15.3 | 14.66 | 14.75 | 338618.0 |
| 2015-10-26 | AAL | Stock | 45.36 | 46.57 | 44.99 | 46.47 | 11026200.0 |
| 2015-10-26 | AAMC-DELISTED | Stock | 7.7971 | 7.9794 | 7.3941 | 7.4118 | 14515.0 |
| 2015-10-26 | AAME | Stock | 4.27 | 4.42 | 4.24 | 4.25 | 5100.0 |
| 2015-10-26 | AAMI | Stock | 15.35 | 15.35 | 15.06 | 15.12 | 121400.0 |
| 2015-10-26 | AAOI | Stock | 19.62 | 20.005 | 19.53 | 19.81 | 240200.0 |
| 2015-10-26 | AAON | Stock | 14.3333 | 14.3733 | 14.1133 | 14.1267 | 117150.0 |
| 2015-10-26 | AAP | Stock | 192.82 | 194.19 | 191.89 | 192.45 | 500100.0 |
| 2015-10-26 | AAT | Stock | 43.5 | 43.64 | 43.11 | 43.34 | 79500.0 |
| 2015-10-26 | AAU-DELISTED | Stock | 0.58 | 0.5988 | 0.564 | 0.5969 | 250473.0 |
| 2015-10-26 | AAUAF-DELISTED | Stock | 0.58 | 0.5988 | 0.564 | 0.59 | 252062.0 |
| 2015-10-26 | AAV-DELISTED | Stock | 5.8 | 5.8 | 5.47 | 5.52 | 57947.0 |
| 2015-10-26 | AAVL-DELISTED | Stock | 7.66 | 7.9 | 7.46 | 7.48 | 318335.0 |
| 2015-10-26 | AAWW-DELISTED | Stock | 41.21 | 41.755 | 40.55 | 41.04 | 151756.0 |
| 2015-10-26 | AAXJ | Stock | 58.14 | 58.28 | 58.04 | 58.13 | 445929.0 |
| 2015-10-26 | AAXN-DELISTED | Stock | 23.22 | 24.23 | 22.83 | 23.56 | 2202810.0 |
| 2015-10-26 | AB | Stock | 27.4 | 27.7 | 26.98 | 27.17 | 284100.0 |
| 2015-10-26 | ABAC-DELISTED | Stock | 0.63 | 0.63 | 0.58 | 0.6092 | 9850.0 |
| 2015-10-26 | ABAX-DELISTED | Stock | 43.0 | 43.34 | 42.138 | 43.13 | 207143.0 |
| 2015-10-26 | ABB-DELISTED | Stock | 18.71 | 18.74 | 18.445 | 18.47 | 1613800.0 |
| 2015-10-26 | ABBNY-DELISTED | Stock | 18.71 | 18.74 | 18.445 | 18.47 | 1656891.0 |
| 2015-10-26 | ABBV | Stock | 50.17 | 52.48 | 49.35 | 51.87 | 13890400.0 |
| 2015-10-26 | ABC-DELISTED | Stock | 93.06 | 94.16 | 92.84 | 93.64 | 2251820.0 |
| 2015-10-26 | ABCB | Stock | 30.14 | 30.53 | 30.08 | 30.47 | 224900.0 |
| 2015-10-26 | ABCD-DELISTED | Stock | 4.97 | 5.0 | 4.65 | 4.82 | 57915.0 |
| 2015-10-26 | ABCO-DELISTED | Stock | 44.06 | 44.37 | 43.5 | 43.74 | 220185.0 |
| 2015-10-26 | ABCW-DELISTED | Stock | 42.23 | 42.23 | 41.66 | 41.69 | 5205.0 |
| 2015-10-26 | ABDC-DELISTED | Stock | 12.35 | 12.35 | 11.82 | 12.23 | 20067.0 |
| 2015-10-26 | ABE-DELISTED | Stock | 11.49 | 11.49 | 11.448 | 11.48 | 600.0 |
| 2015-10-26 | ABEO | Stock | 103.75 | 105.5 | 97.5 | 99.0 | 2336.0 |
| 2015-10-26 | ABEOW-DELISTED | Stock | 1.61 | 1.61 | 1.41 | 1.41 | 1000.0 |
| 2015-10-26 | ABEV | Stock | 5.07 | 5.08 | 4.97 | 4.97 | 15647900.0 |
| 2015-10-26 | ABG | Stock | 80.75 | 80.84 | 79.02 | 80.26 | 318500.0 |
| 2015-10-26 | ABGB-DELISTED | Stock | 4.82 | 4.92 | 4.8 | 4.84 | 37740.0 |
| 2015-10-26 | ABIL-DELISTED | Stock | 10.0 | 10.08 | 10.0 | 10.07 | 1357.0 |
> showing 50 of 6,641 rows — these rows as CSV