PREVIEW / stock_daily / 2015-07-30
file: by_date/stock_daily/2015/2015-07-30.parquet size: 223 KB rows: 6,640 symbols: 3,468
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-07-30 | AAPL | Stock | 30.58 | 30.6425 | 30.4275 | 30.5925 | 134513200.0 |
| 2015-07-30 | MSFT | Stock | 46.26 | 47.4 | 45.93 | 46.88 | 39777900.0 |
| 2015-07-30 | NVDA | Stock | 0.498 | 0.5055 | 0.498 | 0.5005 | 190180000.0 |
| 2015-07-30 | AMZN | Stock | 26.3825 | 26.96 | 26.2145 | 26.838 | 74862000.0 |
| 2015-07-30 | GOOGL | Stock | 32.872 | 33.4025 | 32.5845 | 33.228 | 39606900.0 |
| 2015-07-30 | META | Stock | 94.91 | 95.81 | 91.8 | 95.21 | 86211300.0 |
| 2015-07-30 | TSLA | Stock | 17.5127 | 17.796 | 17.474 | 17.786 | 30519000.0 |
| 2015-07-30 | TLT | Stock | 121.21 | 121.935 | 121.15 | 121.63 | 6146626.0 |
| 2015-07-30 | ES | Stock | 48.13 | 48.87 | 48.03 | 48.77 | 1360800.0 |
| 2015-07-30 | CL | Stock | 68.75 | 68.8 | 67.31 | 68.02 | 5488800.0 |
| 2015-07-30 | A | Stock | 40.26 | 41.05 | 40.07 | 40.97 | 2440400.0 |
| 2015-07-30 | AA.B-DELISTED | Stock | 36.9 | 37.42 | 36.5 | 36.65 | 31852.0 |
| 2015-07-30 | AABA-DELISTED | Stock | 37.51 | 37.69 | 37.3 | 37.415 | 9079285.0 |
| 2015-07-30 | AAC-DELISTED | Stock | 39.07 | 40.28 | 37.0 | 37.52 | 1013717.0 |
| 2015-07-30 | AACG | Stock | 3.5 | 3.9 | 3.31 | 3.44 | 44600.0 |
| 2015-07-30 | AAIC-DELISTED | Stock | 18.84 | 19.14 | 18.82 | 18.91 | 301931.0 |
| 2015-07-30 | AAL | Stock | 40.58 | 40.93 | 39.92 | 40.27 | 5855800.0 |
| 2015-07-30 | AAMC-DELISTED | Stock | 40.2971 | 40.3382 | 38.8235 | 38.8235 | 10696.0 |
| 2015-07-30 | AAME | Stock | 3.67 | 3.7 | 3.67 | 3.7 | 1200.0 |
| 2015-07-30 | AAMI | Stock | 17.75 | 17.91 | 17.21 | 17.66 | 199200.0 |
| 2015-07-30 | AAOI | Stock | 18.15 | 18.68 | 18.05 | 18.56 | 206500.0 |
| 2015-07-30 | AAON | Stock | 14.8067 | 15.02 | 14.7467 | 14.9067 | 187350.0 |
| 2015-07-30 | AAP | Stock | 172.98 | 173.68 | 170.91 | 172.54 | 509700.0 |
| 2015-07-30 | AAT | Stock | 41.2 | 41.45 | 40.97 | 41.16 | 100900.0 |
| 2015-07-30 | AAU-DELISTED | Stock | 0.6 | 0.63 | 0.5874 | 0.6292 | 34417.0 |
| 2015-07-30 | AAUAF-DELISTED | Stock | 0.6 | 0.63 | 0.5866 | 0.63 | 34812.0 |
| 2015-07-30 | AAV-DELISTED | Stock | 5.6 | 5.7 | 5.53 | 5.57 | 36071.0 |
| 2015-07-30 | AAVL-DELISTED | Stock | 14.15 | 14.58 | 14.01 | 14.28 | 235114.0 |
| 2015-07-30 | AAWW-DELISTED | Stock | 50.77 | 52.8799 | 46.45 | 48.65 | 2067422.0 |
| 2015-07-30 | AAXJ | Stock | 59.01 | 59.07 | 58.7099 | 59.01 | 582721.0 |
| 2015-07-30 | AAXN-DELISTED | Stock | 32.03 | 32.82 | 27.63 | 28.11 | 9031334.0 |
| 2015-07-30 | AB | Stock | 27.66 | 27.88 | 27.1 | 27.18 | 146700.0 |
| 2015-07-30 | ABAC-DELISTED | Stock | 1.12 | 1.12 | 1.07 | 1.0999 | 3797.0 |
| 2015-07-30 | ABAX-DELISTED | Stock | 48.61 | 49.57 | 47.99 | 49.19 | 156428.0 |
| 2015-07-30 | ABB-DELISTED | Stock | 20.04 | 20.08 | 19.95 | 20.05 | 1033352.0 |
| 2015-07-30 | ABBNY-DELISTED | Stock | 20.04 | 20.08 | 19.95 | 20.04 | 1219030.0 |
| 2015-07-30 | ABBV | Stock | 70.86 | 70.88 | 69.27 | 70.16 | 6820400.0 |
| 2015-07-30 | ABC-DELISTED | Stock | 107.49 | 107.49 | 104.31 | 104.47 | 3465727.0 |
| 2015-07-30 | ABCB | Stock | 26.45 | 27.0 | 26.42 | 26.93 | 141800.0 |
| 2015-07-30 | ABCD-DELISTED | Stock | 4.75 | 4.84 | 4.55 | 4.57 | 124463.0 |
| 2015-07-30 | ABCO-DELISTED | Stock | 58.45 | 60.05 | 58.34 | 59.51 | 388740.0 |
| 2015-07-30 | ABCW-DELISTED | Stock | 37.74 | 38.34 | 37.3801 | 38.2799 | 9235.0 |
| 2015-07-30 | ABDC-DELISTED | Stock | 12.46 | 12.69 | 12.34 | 12.56 | 44489.0 |
| 2015-07-30 | ABE-DELISTED | Stock | 12.5 | 12.64 | 12.47 | 12.58 | 11744.0 |
| 2015-07-30 | ABEO | Stock | 152.5 | 155.5 | 148.0 | 150.0 | 6936.0 |
| 2015-07-30 | ABEOW-DELISTED | Stock | 2.15 | 2.15 | 2.15 | 2.15 | 113.0 |
| 2015-07-30 | ABEV | Stock | 5.61 | 5.63 | 5.53 | 5.59 | 19206600.0 |
| 2015-07-30 | ABG | Stock | 85.23 | 88.11 | 84.93 | 87.55 | 422300.0 |
| 2015-07-30 | ABGB-DELISTED | Stock | 11.91 | 11.91 | 10.76 | 11.06 | 37403.0 |
| 2015-07-30 | ABIL-DELISTED | Stock | 10.0 | 10.0 | 9.99 | 9.99 | 2000.0 |
> showing 50 of 6,640 rows — these rows as CSV