PREVIEW / stock_daily / 2015-02-04
file: by_date/stock_daily/2015/2015-02-04.parquet size: 223 KB rows: 6,664 symbols: 3,546
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-02-04 | AAPL | Stock | 29.625 | 30.1275 | 29.5775 | 29.89 | 280598800.0 |
| 2015-02-04 | MSFT | Stock | 41.94 | 42.21 | 41.36 | 41.84 | 41614800.0 |
| 2015-02-04 | NVDA | Stock | 0.5013 | 0.5098 | 0.4998 | 0.504 | 181516000.0 |
| 2015-02-04 | AMZN | Stock | 17.919 | 18.375 | 17.9115 | 18.2375 | 83398000.0 |
| 2015-02-04 | GOOGL | Stock | 26.657 | 26.8373 | 26.2515 | 26.305 | 33896640.0 |
| 2015-02-04 | META | Stock | 75.09 | 76.35 | 75.01 | 75.63 | 20277400.0 |
| 2015-02-04 | TSLA | Stock | 14.5527 | 14.7653 | 14.4533 | 14.57 | 49581000.0 |
| 2015-02-04 | TLT | Stock | 133.49 | 134.99 | 133.1201 | 134.8 | 11360416.0 |
| 2015-02-04 | ES | Stock | 55.75 | 56.52 | 55.48 | 55.61 | 1739300.0 |
| 2015-02-04 | CL | Stock | 69.25 | 69.79 | 69.04 | 69.2 | 3075300.0 |
| 2015-02-04 | A | Stock | 39.33 | 39.46 | 38.82 | 39.11 | 2567400.0 |
| 2015-02-04 | AA.B-DELISTED | Stock | 52.4 | 52.5599 | 52.13 | 52.13 | 9925.0 |
| 2015-02-04 | AABA-DELISTED | Stock | 44.8 | 44.975 | 43.875 | 44.03 | 14855293.0 |
| 2015-02-04 | AAC-DELISTED | Stock | 27.49 | 27.77 | 27.06 | 27.32 | 45720.0 |
| 2015-02-04 | AACG | Stock | 4.75 | 4.93 | 4.75 | 4.93 | 1000.0 |
| 2015-02-04 | AAIC-DELISTED | Stock | 25.98 | 26.06 | 24.33 | 24.83 | 1883289.0 |
| 2015-02-04 | AAL | Stock | 48.62 | 49.79 | 48.23 | 49.46 | 11836800.0 |
| 2015-02-04 | AAMC-DELISTED | Stock | 48.7147 | 51.7618 | 48.0544 | 50.1176 | 16691.0 |
| 2015-02-04 | AAME | Stock | 3.99 | 4.0 | 3.97 | 3.97 | 2500.0 |
| 2015-02-04 | AAMI | Stock | 16.01 | 16.19 | 16.0 | 16.12 | 77000.0 |
| 2015-02-04 | AAOI | Stock | 9.03 | 9.3 | 8.78 | 9.15 | 161100.0 |
| 2015-02-04 | AAON | Stock | 15.4533 | 15.9667 | 15.4533 | 15.7267 | 271350.0 |
| 2015-02-04 | AAP | Stock | 156.76 | 157.27 | 154.52 | 156.47 | 745000.0 |
| 2015-02-04 | AAT | Stock | 43.81 | 44.08 | 43.58 | 43.66 | 127200.0 |
| 2015-02-04 | AAU-DELISTED | Stock | 1.15 | 1.19 | 1.13 | 1.16 | 167877.0 |
| 2015-02-04 | AAUAF-DELISTED | Stock | 1.13 | 1.16 | 1.11 | 1.16 | 172772.0 |
| 2015-02-04 | AAV-DELISTED | Stock | 4.38 | 4.56 | 4.2671 | 4.42 | 191486.0 |
| 2015-02-04 | AAVL-DELISTED | Stock | 35.59 | 35.59 | 33.25 | 33.54 | 279333.0 |
| 2015-02-04 | AAWW-DELISTED | Stock | 46.88 | 48.16 | 46.79 | 47.73 | 182578.0 |
| 2015-02-04 | AAXJ | Stock | 64.0 | 64.08 | 63.45 | 63.62 | 4902155.0 |
| 2015-02-04 | AAXN-DELISTED | Stock | 25.8 | 26.65 | 25.77 | 26.42 | 1242464.0 |
| 2015-02-04 | AB | Stock | 24.17 | 24.87 | 24.1 | 24.72 | 340200.0 |
| 2015-02-04 | ABAC-DELISTED | Stock | 1.6544 | 1.68 | 1.62 | 1.68 | 6958.0 |
| 2015-02-04 | ABAX-DELISTED | Stock | 59.07 | 59.28 | 58.16 | 58.46 | 267983.0 |
| 2015-02-04 | ABB-DELISTED | Stock | 19.85 | 20.06 | 19.76 | 19.84 | 3136510.0 |
| 2015-02-04 | ABBNY-DELISTED | Stock | 19.85 | 20.06 | 19.7432 | 19.84 | 3511017.0 |
| 2015-02-04 | ABBV | Stock | 58.95 | 58.95 | 56.65 | 56.91 | 31250600.0 |
| 2015-02-04 | ABC-DELISTED | Stock | 95.62 | 96.454 | 95.2315 | 95.86 | 1643213.0 |
| 2015-02-04 | ABCB | Stock | 25.01 | 25.32 | 24.8 | 24.89 | 183300.0 |
| 2015-02-04 | ABCD-DELISTED | Stock | 2.67 | 2.7 | 2.41 | 2.55 | 11591.0 |
| 2015-02-04 | ABCO-DELISTED | Stock | 49.64 | 50.24 | 49.17 | 49.44 | 233874.0 |
| 2015-02-04 | ABCW-DELISTED | Stock | 33.47 | 33.69 | 32.8 | 33.69 | 5324.0 |
| 2015-02-04 | ABDC-DELISTED | Stock | 13.01 | 13.96 | 13.01 | 13.34 | 28274.0 |
| 2015-02-04 | ABE-DELISTED | Stock | 13.12 | 13.2107 | 13.12 | 13.21 | 4157.0 |
| 2015-02-04 | ABEO | Stock | 78.75 | 78.75 | 77.25 | 77.5 | 168.0 |
| 2015-02-04 | ABEV | Stock | 6.33 | 6.45 | 6.31 | 6.37 | 15325100.0 |
| 2015-02-04 | ABG | Stock | 79.75 | 80.84 | 77.19 | 78.48 | 737700.0 |
| 2015-02-04 | ABGB-DELISTED | Stock | 15.33 | 15.5 | 15.18 | 15.29 | 54994.0 |
| 2015-02-04 | ABIL-DELISTED | Stock | 9.95 | 9.96 | 9.95 | 9.96 | 200.0 |
| 2015-02-04 | ABM | Stock | 30.04 | 30.2 | 29.72 | 29.79 | 268000.0 |
> showing 50 of 6,664 rows — these rows as CSV