PREVIEW / stock_daily / 2013-10-21
file: by_date/stock_daily/2013/2013-10-21.parquet size: 215 KB rows: 6,437 symbols: 3,548
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-10-21 | AAPL | Stock | 18.2775 | 18.725 | 18.2686 | 18.62 | 398106800.0 |
| 2013-10-21 | MSFT | Stock | 34.98 | 35.2 | 34.91 | 34.99 | 27433500.0 |
| 2013-10-21 | NVDA | Stock | 0.4 | 0.4003 | 0.395 | 0.3962 | 195008000.0 |
| 2013-10-21 | AMZN | Stock | 16.4945 | 16.5 | 16.19 | 16.322 | 50446000.0 |
| 2013-10-21 | META | Stock | 54.68 | 54.81 | 53.51 | 53.85 | 58235000.0 |
| 2013-10-21 | TSLA | Stock | 12.2187 | 12.226 | 11.4 | 11.5067 | 172981500.0 |
| 2013-10-21 | TLT | Stock | 106.91 | 106.92 | 106.459 | 106.7 | 6162621.0 |
| 2013-10-21 | ES | Stock | 42.31 | 42.38 | 41.96 | 42.23 | 1069000.0 |
| 2013-10-21 | CL | Stock | 62.76 | 62.78 | 61.86 | 62.26 | 3253500.0 |
| 2013-10-21 | A | Stock | 37.9399 | 38.0114 | 37.1245 | 37.1888 | 3573847.0 |
| 2013-10-21 | AABA-DELISTED | Stock | 33.65 | 34.35 | 33.65 | 34.06 | 17571975.0 |
| 2013-10-21 | AACG | Stock | 4.66 | 4.69 | 4.64 | 4.69 | 700.0 |
| 2013-10-21 | AAIC-DELISTED | Stock | 24.97 | 25.25 | 24.9 | 25.14 | 125884.0 |
| 2013-10-21 | AAMC-DELISTED | Stock | 150.2941 | 153.5294 | 149.3794 | 153.5294 | 5858.0 |
| 2013-10-21 | AAME | Stock | 3.99 | 4.05 | 3.99 | 4.05 | 5500.0 |
| 2013-10-21 | AAMRQ-DELISTED | Stock | 6.015 | 6.12 | 5.94 | 5.97 | 6326902.0 |
| 2013-10-21 | AAOI | Stock | 12.98 | 13.0 | 11.55 | 12.9 | 252600.0 |
| 2013-10-21 | AAON | Stock | 12.1244 | 12.1867 | 12.0489 | 12.0711 | 142875.0 |
| 2013-10-21 | AAP | Stock | 99.11 | 99.4 | 97.77 | 98.45 | 615800.0 |
| 2013-10-21 | AAT | Stock | 33.11 | 33.21 | 32.92 | 33.15 | 109600.0 |
| 2013-10-21 | AAU-DELISTED | Stock | 1.31 | 1.37 | 1.31 | 1.35 | 65823.0 |
| 2013-10-21 | AAUAF-DELISTED | Stock | 1.31 | 1.37 | 1.31 | 1.35 | 66123.0 |
| 2013-10-21 | AAV-DELISTED | Stock | 4.09 | 4.11 | 3.98 | 4.0 | 80392.0 |
| 2013-10-21 | AAWW-DELISTED | Stock | 46.11 | 46.541 | 45.655 | 46.07 | 133788.0 |
| 2013-10-21 | AAXJ | Stock | 61.48 | 61.48 | 61.05 | 61.15 | 1640957.0 |
| 2013-10-21 | AAXN-DELISTED | Stock | 15.88 | 15.9499 | 15.16 | 15.435 | 1137801.0 |
| 2013-10-21 | AB | Stock | 21.55 | 21.58 | 21.28 | 21.5 | 269400.0 |
| 2013-10-21 | ABAC-DELISTED | Stock | 1.76 | 1.87 | 1.69 | 1.74 | 112137.0 |
| 2013-10-21 | ABAX-DELISTED | Stock | 38.23 | 38.8199 | 37.85 | 38.75 | 182920.0 |
| 2013-10-21 | ABB-DELISTED | Stock | 23.94 | 24.12 | 23.93 | 24.03 | 2096765.0 |
| 2013-10-21 | ABBNY-DELISTED | Stock | 23.94 | 24.12 | 23.93 | 24.03 | 2146410.0 |
| 2013-10-21 | ABBV | Stock | 48.08 | 48.55 | 47.76 | 48.35 | 4713200.0 |
| 2013-10-21 | ABC-DELISTED | Stock | 64.57 | 64.64 | 63.62 | 63.86 | 1798960.0 |
| 2013-10-21 | ABCB | Stock | 17.84 | 18.07 | 17.84 | 17.89 | 96400.0 |
| 2013-10-21 | ABCD-DELISTED | Stock | 1.35 | 1.37 | 1.32 | 1.34 | 47848.0 |
| 2013-10-21 | ABCO-DELISTED | Stock | 68.17 | 68.3 | 67.13 | 67.98 | 186877.0 |
| 2013-10-21 | ABE-DELISTED | Stock | 20.5 | 20.6 | 20.428 | 20.59 | 6081.0 |
| 2013-10-21 | ABEO | Stock | 425.0 | 462.5 | 425.0 | 425.0 | 14.0 |
| 2013-10-21 | ABFS-DELISTED | Stock | 27.47 | 27.6231 | 25.95 | 26.84 | 476080.0 |
| 2013-10-21 | ABG | Stock | 54.08 | 54.24 | 53.26 | 54.2 | 394400.0 |
| 2013-10-21 | ABGB-DELISTED | Stock | 12.74 | 13.23 | 12.74 | 13.1 | 146495.0 |
| 2013-10-21 | ABM | Stock | 28.12 | 28.51 | 28.12 | 28.45 | 295500.0 |
| 2013-10-21 | ABMD-DELISTED | Stock | 20.18 | 20.52 | 20.18 | 20.325 | 200051.0 |
| 2013-10-21 | ABR | Stock | 6.96 | 7.04 | 6.9 | 6.94 | 124900.0 |
| 2013-10-21 | ABR.A-DELISTED | Stock | 24.85 | 24.8799 | 24.5 | 24.8399 | 3150.0 |
| 2013-10-21 | ABR.B-DELISTED | Stock | 23.82 | 23.82 | 23.82 | 23.82 | 100.0 |
| 2013-10-21 | ABT | Stock | 37.17 | 37.17 | 36.78 | 36.86 | 7663800.0 |
| 2013-10-21 | ABTL-DELISTED | Stock | 8.51 | 9.219 | 8.411 | 9.04 | 490639.0 |
| 2013-10-21 | ABUS | Stock | 9.23 | 9.38 | 8.7 | 8.75 | 325600.0 |
| 2013-10-21 | ABV-DELISTED | Stock | 39.74 | 39.77 | 39.16 | 39.53 | 1429497.0 |
> showing 50 of 6,437 rows — these rows as CSV