PREVIEW / stock_daily / 2015-02-05
file: by_date/stock_daily/2015/2015-02-05.parquet size: 223 KB rows: 6,642 symbols: 3,519
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-05 | AAPL | Stock | 30.005 | 30.0575 | 29.8125 | 29.985 | 168984800.0 |
| 2015-02-05 | MSFT | Stock | 42.22 | 42.64 | 41.86 | 42.45 | 36548200.0 |
| 2015-02-05 | NVDA | Stock | 0.5045 | 0.5125 | 0.504 | 0.5122 | 140448000.0 |
| 2015-02-05 | AMZN | Stock | 18.3 | 18.94 | 18.295 | 18.6945 | 144952000.0 |
| 2015-02-05 | GOOGL | Stock | 26.3965 | 26.5345 | 26.282 | 26.4915 | 33175020.0 |
| 2015-02-05 | META | Stock | 75.71 | 75.98 | 75.21 | 75.61 | 15062600.0 |
| 2015-02-05 | TSLA | Stock | 14.6587 | 15.032 | 14.6427 | 14.7327 | 52843500.0 |
| 2015-02-05 | TLT | Stock | 134.0 | 134.23 | 133.11 | 133.32 | 8334585.0 |
| 2015-02-05 | ES | Stock | 55.9 | 56.4 | 55.48 | 56.28 | 1231700.0 |
| 2015-02-05 | CL | Stock | 69.49 | 70.18 | 69.3 | 69.79 | 3408400.0 |
| 2015-02-05 | A | Stock | 39.22 | 39.82 | 39.22 | 39.53 | 1826300.0 |
| 2015-02-05 | AA.B-DELISTED | Stock | 53.17 | 53.65 | 52.1 | 53.63 | 31690.0 |
| 2015-02-05 | AABA-DELISTED | Stock | 44.08 | 44.255 | 43.025 | 43.54 | 17294477.0 |
| 2015-02-05 | AAC-DELISTED | Stock | 27.66 | 28.66 | 26.42 | 28.54 | 61224.0 |
| 2015-02-05 | AACG | Stock | 4.95 | 4.95 | 4.75 | 4.82 | 1500.0 |
| 2015-02-05 | AAIC-DELISTED | Stock | 24.83 | 24.88 | 24.2211 | 24.63 | 1069412.0 |
| 2015-02-05 | AAL | Stock | 49.46 | 49.46 | 47.6 | 48.81 | 9220900.0 |
| 2015-02-05 | AAMC-DELISTED | Stock | 54.4088 | 55.0 | 52.9647 | 54.4118 | 15235.0 |
| 2015-02-05 | AAME | Stock | 4.0 | 4.02 | 3.99 | 3.99 | 1000.0 |
| 2015-02-05 | AAMI | Stock | 16.1 | 16.25 | 15.73 | 16.2 | 86500.0 |
| 2015-02-05 | AAOI | Stock | 9.24 | 9.48 | 9.099 | 9.37 | 110300.0 |
| 2015-02-05 | AAON | Stock | 15.84 | 15.8533 | 15.5267 | 15.7867 | 176400.0 |
| 2015-02-05 | AAP | Stock | 157.74 | 160.66 | 156.79 | 160.16 | 1294200.0 |
| 2015-02-05 | AAT | Stock | 43.88 | 44.33 | 43.72 | 44.21 | 144000.0 |
| 2015-02-05 | AAU-DELISTED | Stock | 1.19 | 1.19 | 1.12 | 1.1584 | 146913.0 |
| 2015-02-05 | AAUAF-DELISTED | Stock | 1.19 | 1.19 | 1.12 | 1.16 | 147363.0 |
| 2015-02-05 | AAV-DELISTED | Stock | 4.43 | 4.64 | 4.41 | 4.51 | 120336.0 |
| 2015-02-05 | AAVL-DELISTED | Stock | 33.78 | 34.77 | 32.47 | 33.265 | 431873.0 |
| 2015-02-05 | AAWW-DELISTED | Stock | 48.06 | 48.71 | 47.66 | 48.34 | 153854.0 |
| 2015-02-05 | AAXJ | Stock | 63.27 | 63.63 | 63.18 | 63.59 | 745813.0 |
| 2015-02-05 | AAXN-DELISTED | Stock | 26.55 | 27.0 | 26.28 | 26.98 | 1101866.0 |
| 2015-02-05 | AB | Stock | 24.87 | 25.21 | 24.75 | 24.99 | 226500.0 |
| 2015-02-05 | ABAC-DELISTED | Stock | 1.75 | 1.75 | 1.54 | 1.64 | 11038.0 |
| 2015-02-05 | ABAX-DELISTED | Stock | 58.75 | 59.3557 | 58.68 | 58.92 | 222085.0 |
| 2015-02-05 | ABB-DELISTED | Stock | 20.19 | 20.44 | 20.16 | 20.36 | 2500176.0 |
| 2015-02-05 | ABBNY-DELISTED | Stock | 20.19 | 20.44 | 20.16 | 20.36 | 2581844.0 |
| 2015-02-05 | ABBV | Stock | 57.55 | 58.26 | 56.15 | 57.99 | 18964700.0 |
| 2015-02-05 | ABC-DELISTED | Stock | 96.27 | 96.67 | 95.98 | 96.33 | 945729.0 |
| 2015-02-05 | ABCB | Stock | 24.57 | 25.33 | 24.53 | 25.13 | 194200.0 |
| 2015-02-05 | ABCD-DELISTED | Stock | 2.59 | 2.7 | 2.511 | 2.68 | 11667.0 |
| 2015-02-05 | ABCO-DELISTED | Stock | 49.35 | 49.87 | 48.98 | 49.86 | 238477.0 |
| 2015-02-05 | ABCW-DELISTED | Stock | 33.09 | 33.47 | 32.57 | 33.45 | 11608.0 |
| 2015-02-05 | ABDC-DELISTED | Stock | 13.21 | 13.87 | 13.21 | 13.59 | 107643.0 |
| 2015-02-05 | ABE-DELISTED | Stock | 13.23 | 13.23 | 13.16 | 13.18 | 8616.0 |
| 2015-02-05 | ABEO | Stock | 77.0 | 78.75 | 77.0 | 77.5 | 48.0 |
| 2015-02-05 | ABEOW-DELISTED | Stock | 0.72 | 0.8 | 0.68 | 0.8 | 6100.0 |
| 2015-02-05 | ABEV | Stock | 6.33 | 6.53 | 6.28 | 6.53 | 13994700.0 |
| 2015-02-05 | ABG | Stock | 79.3 | 79.7 | 77.65 | 77.92 | 457600.0 |
| 2015-02-05 | ABGB-DELISTED | Stock | 15.47 | 15.58 | 15.35 | 15.45 | 135469.0 |
| 2015-02-05 | ABM | Stock | 29.96 | 30.19 | 29.87 | 30.0 | 189700.0 |
> showing 50 of 6,642 rows — these rows as CSV