PREVIEW / stock_daily / 2013-11-26
file: by_date/stock_daily/2013/2013-11-26.parquet size: 216 KB rows: 6,484 symbols: 3,565
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-26 | AAPL | Stock | 18.7186 | 19.1479 | 18.7143 | 19.05 | 401382800.0 |
| 2013-11-26 | MSFT | Stock | 37.57 | 37.65 | 37.35 | 37.35 | 34465300.0 |
| 2013-11-26 | NVDA | Stock | 0.392 | 0.3953 | 0.3895 | 0.391 | 753176000.0 |
| 2013-11-26 | AMZN | Stock | 18.8805 | 19.125 | 18.741 | 19.0685 | 54488000.0 |
| 2013-11-26 | META | Stock | 44.66 | 46.17 | 43.55 | 45.89 | 82016000.0 |
| 2013-11-26 | TSLA | Stock | 7.9587 | 8.1813 | 7.74 | 8.0333 | 208282500.0 |
| 2013-11-26 | TLT | Stock | 104.49 | 104.93 | 104.48 | 104.6 | 6659203.0 |
| 2013-11-26 | ES | Stock | 41.9 | 41.96 | 41.19 | 41.22 | 2366600.0 |
| 2013-11-26 | CL | Stock | 66.1 | 66.44 | 65.78 | 66.01 | 2539800.0 |
| 2013-11-26 | A | Stock | 38.0973 | 38.5765 | 38.0758 | 38.3763 | 4468427.0 |
| 2013-11-26 | AABA-DELISTED | Stock | 36.32 | 36.75 | 36.11 | 36.645 | 10098641.0 |
| 2013-11-26 | AACG | Stock | 4.2 | 4.2 | 4.1 | 4.15 | 7400.0 |
| 2013-11-26 | AAIC-DELISTED | Stock | 26.58 | 26.7 | 26.5 | 26.52 | 95594.0 |
| 2013-11-26 | AAMC-DELISTED | Stock | 211.7647 | 211.7647 | 211.7206 | 211.7647 | 2778.0 |
| 2013-11-26 | AAME | Stock | 4.01 | 4.05 | 4.01 | 4.02 | 2900.0 |
| 2013-11-26 | AAMRQ-DELISTED | Stock | 12.015 | 12.07 | 11.85 | 11.97 | 9509535.0 |
| 2013-11-26 | AAOI | Stock | 12.64 | 12.64 | 12.23 | 12.63 | 46600.0 |
| 2013-11-26 | AAON | Stock | 12.8844 | 13.5111 | 12.3156 | 13.4933 | 229500.0 |
| 2013-11-26 | AAP | Stock | 100.0 | 102.84 | 99.95 | 101.51 | 2340800.0 |
| 2013-11-26 | AAT | Stock | 31.98 | 32.09 | 31.32 | 31.49 | 156600.0 |
| 2013-11-26 | AAU-DELISTED | Stock | 1.06 | 1.08 | 1.03 | 1.08 | 910340.0 |
| 2013-11-26 | AAUAF-DELISTED | Stock | 1.08 | 1.1 | 1.05 | 1.08 | 898879.0 |
| 2013-11-26 | AAV-DELISTED | Stock | 3.94 | 4.03 | 3.94 | 4.03 | 137634.0 |
| 2013-11-26 | AAWW-DELISTED | Stock | 36.75 | 37.28 | 36.75 | 37.04 | 387007.0 |
| 2013-11-26 | AAXJ | Stock | 60.08 | 60.18 | 59.74 | 60.04 | 447554.0 |
| 2013-11-26 | AAXN-DELISTED | Stock | 17.83 | 18.02 | 17.65 | 17.77 | 926033.0 |
| 2013-11-26 | AB | Stock | 21.97 | 22.33 | 21.97 | 22.15 | 330000.0 |
| 2013-11-26 | ABAC-DELISTED | Stock | 1.73 | 1.79 | 1.73 | 1.7746 | 25047.0 |
| 2013-11-26 | ABAX-DELISTED | Stock | 35.72 | 36.02 | 35.496 | 35.95 | 111511.0 |
| 2013-11-26 | ABB-DELISTED | Stock | 25.39 | 25.44 | 25.3 | 25.35 | 762267.0 |
| 2013-11-26 | ABBNY-DELISTED | Stock | 25.39 | 25.44 | 25.3 | 25.36 | 924798.0 |
| 2013-11-26 | ABBV | Stock | 48.38 | 49.18 | 48.31 | 48.6 | 4732300.0 |
| 2013-11-26 | ABC-DELISTED | Stock | 70.77 | 71.16 | 70.29 | 70.61 | 1448171.0 |
| 2013-11-26 | ABCB | Stock | 19.9 | 20.25 | 19.73 | 20.15 | 54500.0 |
| 2013-11-26 | ABCD-DELISTED | Stock | 1.56 | 1.57 | 1.5 | 1.55 | 46909.0 |
| 2013-11-26 | ABCO-DELISTED | Stock | 64.0 | 64.0 | 63.12 | 63.44 | 183218.0 |
| 2013-11-26 | ABE-DELISTED | Stock | 19.78 | 19.78 | 19.6608 | 19.7 | 1679.0 |
| 2013-11-26 | ABEO | Stock | 350.0 | 375.0 | 312.5 | 375.0 | 49.0 |
| 2013-11-26 | ABEV | Stock | 7.49 | 7.72 | 7.42 | 7.7 | 6597900.0 |
| 2013-11-26 | ABFS-DELISTED | Stock | 32.11 | 32.5 | 31.89 | 32.27 | 475125.0 |
| 2013-11-26 | ABG | Stock | 51.5 | 52.0 | 51.2 | 51.29 | 188800.0 |
| 2013-11-26 | ABGB-DELISTED | Stock | 11.75 | 11.78 | 11.381 | 11.78 | 5425.0 |
| 2013-11-26 | ABM | Stock | 27.91 | 28.0 | 27.86 | 27.92 | 207200.0 |
| 2013-11-26 | ABMD-DELISTED | Stock | 28.18 | 28.63 | 28.16 | 28.22 | 356222.0 |
| 2013-11-26 | ABR | Stock | 6.59 | 6.73 | 6.58 | 6.67 | 75600.0 |
| 2013-11-26 | ABR.A-DELISTED | Stock | 24.6 | 24.62 | 24.6 | 24.62 | 1610.0 |
| 2013-11-26 | ABR.B-DELISTED | Stock | 22.5 | 22.5 | 22.5 | 22.5 | 200.0 |
| 2013-11-26 | ABT | Stock | 38.29 | 38.29 | 37.9 | 38.07 | 4831200.0 |
| 2013-11-26 | ABTL-DELISTED | Stock | 12.09 | 12.22 | 11.7 | 12.01 | 380861.0 |
| 2013-11-26 | ABUS | Stock | 7.82 | 8.09 | 7.8 | 8.09 | 94600.0 |
> showing 50 of 6,484 rows — these rows as CSV