PREVIEW / stock_daily / 2013-11-19
file: by_date/stock_daily/2013/2013-11-19.parquet size: 215 KB rows: 6,439 symbols: 3,547
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-19 | AAPL | Stock | 18.5368 | 18.6921 | 18.4989 | 18.5554 | 208938800.0 |
| 2013-11-19 | MSFT | Stock | 36.85 | 37.23 | 36.67 | 36.74 | 44275000.0 |
| 2013-11-19 | NVDA | Stock | 0.3905 | 0.394 | 0.3855 | 0.386 | 206716000.0 |
| 2013-11-19 | AMZN | Stock | 18.291 | 18.439 | 18.125 | 18.247 | 38096000.0 |
| 2013-11-19 | META | Stock | 46.26 | 47.0 | 45.72 | 46.36 | 75602000.0 |
| 2013-11-19 | TSLA | Stock | 7.962 | 8.6 | 7.948 | 8.406 | 297243000.0 |
| 2013-11-19 | TLT | Stock | 104.95 | 105.14 | 104.41 | 104.56 | 7251137.0 |
| 2013-11-19 | ES | Stock | 42.8 | 42.83 | 42.26 | 42.42 | 1155000.0 |
| 2013-11-19 | CL | Stock | 64.97 | 65.39 | 64.95 | 65.28 | 2381900.0 |
| 2013-11-19 | A | Stock | 38.3906 | 38.7625 | 38.3047 | 38.4979 | 3457254.0 |
| 2013-11-19 | AABA-DELISTED | Stock | 34.98 | 35.165 | 34.51 | 34.62 | 13920254.0 |
| 2013-11-19 | AACG | Stock | 4.11 | 4.16 | 4.11 | 4.15 | 3300.0 |
| 2013-11-19 | AAIC-DELISTED | Stock | 25.84 | 25.95 | 25.52 | 25.55 | 85278.0 |
| 2013-11-19 | AAMC-DELISTED | Stock | 183.8235 | 183.8235 | 178.6735 | 178.9765 | 1374.0 |
| 2013-11-19 | AAME | Stock | 4.03 | 4.04 | 4.02 | 4.02 | 1800.0 |
| 2013-11-19 | AAMRQ-DELISTED | Stock | 12.365 | 12.5 | 12.2 | 12.2 | 7560549.0 |
| 2013-11-19 | AAOI | Stock | 12.34 | 12.49 | 12.24 | 12.43 | 10400.0 |
| 2013-11-19 | AAON | Stock | 12.1778 | 12.5822 | 12.1156 | 12.2178 | 221625.0 |
| 2013-11-19 | AAP | Stock | 98.33 | 98.33 | 96.99 | 97.06 | 476400.0 |
| 2013-11-19 | AAT | Stock | 31.94 | 32.25 | 31.55 | 31.59 | 119700.0 |
| 2013-11-19 | AAU-DELISTED | Stock | 1.17 | 1.202 | 1.15 | 1.16 | 55428.0 |
| 2013-11-19 | AAUAF-DELISTED | Stock | 1.17 | 1.202 | 1.15 | 1.16 | 56178.0 |
| 2013-11-19 | AAV-DELISTED | Stock | 3.9 | 3.93 | 3.87 | 3.92 | 132727.0 |
| 2013-11-19 | AAWW-DELISTED | Stock | 38.43 | 38.7 | 37.31 | 37.32 | 419254.0 |
| 2013-11-19 | AAXJ | Stock | 61.03 | 61.18 | 60.82 | 60.84 | 344353.0 |
| 2013-11-19 | AAXN-DELISTED | Stock | 17.15 | 17.47 | 16.59 | 16.7 | 1286681.0 |
| 2013-11-19 | AB | Stock | 21.69 | 21.96 | 21.42 | 21.49 | 227800.0 |
| 2013-11-19 | ABAC-DELISTED | Stock | 1.95 | 1.99 | 1.47 | 1.72 | 333807.0 |
| 2013-11-19 | ABAX-DELISTED | Stock | 35.48 | 35.92 | 35.088 | 35.34 | 209551.0 |
| 2013-11-19 | ABB-DELISTED | Stock | 25.35 | 25.44 | 25.163 | 25.25 | 803760.0 |
| 2013-11-19 | ABBNY-DELISTED | Stock | 25.35 | 25.44 | 25.163 | 25.26 | 807625.0 |
| 2013-11-19 | ABBV | Stock | 48.73 | 49.0 | 48.37 | 48.46 | 4050700.0 |
| 2013-11-19 | ABC-DELISTED | Stock | 69.01 | 69.49 | 68.67 | 68.88 | 1390252.0 |
| 2013-11-19 | ABCB | Stock | 19.26 | 19.87 | 18.21 | 19.22 | 46500.0 |
| 2013-11-19 | ABCD-DELISTED | Stock | 1.5199 | 1.5199 | 1.43 | 1.45 | 28864.0 |
| 2013-11-19 | ABCO-DELISTED | Stock | 61.47 | 62.34 | 60.43 | 60.85 | 135027.0 |
| 2013-11-19 | ABE-DELISTED | Stock | 19.87 | 19.873 | 19.86 | 19.86 | 2098.0 |
| 2013-11-19 | ABEO | Stock | 375.0 | 400.0 | 362.5 | 375.0 | 5.0 |
| 2013-11-19 | ABEV | Stock | 7.83 | 7.85 | 7.48 | 7.59 | 8533000.0 |
| 2013-11-19 | ABFS-DELISTED | Stock | 32.18 | 33.0 | 31.52 | 31.91 | 339495.0 |
| 2013-11-19 | ABG | Stock | 49.9 | 50.52 | 48.72 | 49.14 | 286700.0 |
| 2013-11-19 | ABGB-DELISTED | Stock | 11.09 | 11.13 | 10.82 | 11.0 | 267144.0 |
| 2013-11-19 | ABM | Stock | 27.77 | 28.05 | 27.45 | 27.52 | 140300.0 |
| 2013-11-19 | ABMD-DELISTED | Stock | 26.94 | 27.49 | 26.7 | 27.25 | 229514.0 |
| 2013-11-19 | ABR | Stock | 6.62 | 6.68 | 6.53 | 6.59 | 128400.0 |
| 2013-11-19 | ABR.A-DELISTED | Stock | 24.4999 | 24.5 | 24.35 | 24.35 | 1685.0 |
| 2013-11-19 | ABR.B-DELISTED | Stock | 22.85 | 22.95 | 22.85 | 22.95 | 700.0 |
| 2013-11-19 | ABT | Stock | 37.93 | 38.73 | 37.87 | 38.71 | 9906100.0 |
| 2013-11-19 | ABTL-DELISTED | Stock | 10.64 | 10.98 | 9.59 | 9.8399 | 279600.0 |
| 2013-11-19 | ABUS | Stock | 7.84 | 7.95 | 7.67 | 7.72 | 88100.0 |
> showing 50 of 6,439 rows — these rows as CSV