PREVIEW / stock_daily / 2012-05-15
file: by_date/stock_daily/2012/2012-05-15.parquet size: 198 KB rows: 6,185 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 |
|---|---|---|---|---|---|---|---|
| 2012-05-15 | AAPL | Stock | 20.0518 | 20.115 | 19.7054 | 19.7561 | 476336000.0 |
| 2012-05-15 | MSFT | Stock | 30.64 | 30.8 | 30.15 | 30.21 | 61822800.0 |
| 2012-05-15 | NVDA | Stock | 0.3283 | 0.3355 | 0.3235 | 0.325 | 599940000.0 |
| 2012-05-15 | AMZN | Stock | 11.325 | 11.5305 | 11.15 | 11.2195 | 114274000.0 |
| 2012-05-15 | TSLA | Stock | 2.0173 | 2.064 | 1.948 | 1.962 | 23785500.0 |
| 2012-05-15 | TLT | Stock | 121.09 | 121.73 | 120.82 | 121.66 | 6766374.0 |
| 2012-05-15 | ES | Stock | 36.2 | 36.29 | 35.7 | 35.78 | 1949400.0 |
| 2012-05-15 | CL | Stock | 49.84 | 50.91 | 49.83 | 50.52 | 13296200.0 |
| 2012-05-15 | A | Stock | 29.2632 | 29.7353 | 28.9056 | 28.9771 | 9783064.0 |
| 2012-05-15 | AABA-DELISTED | Stock | 15.47 | 15.55 | 15.34 | 15.41 | 13145278.0 |
| 2012-05-15 | AACC-DELISTED | Stock | 5.9 | 5.99 | 5.82 | 5.9 | 22424.0 |
| 2012-05-15 | AACG | Stock | 6.72 | 6.75 | 6.72 | 6.75 | 300.0 |
| 2012-05-15 | AAIC-DELISTED | Stock | 23.33 | 23.49 | 23.12 | 23.26 | 45893.0 |
| 2012-05-15 | AAME | Stock | 2.8 | 2.8 | 2.63 | 2.75 | 4000.0 |
| 2012-05-15 | AAMRQ-DELISTED | Stock | 0.51 | 0.54 | 0.51 | 0.511 | 1106198.0 |
| 2012-05-15 | AAON | Stock | 5.6059 | 5.837 | 5.6 | 5.7689 | 421875.0 |
| 2012-05-15 | AAP | Stock | 82.31 | 82.68 | 80.54 | 81.08 | 1850400.0 |
| 2012-05-15 | AAT | Stock | 23.62 | 23.8 | 23.47 | 23.76 | 151000.0 |
| 2012-05-15 | AAU-DELISTED | Stock | 2.0 | 2.04 | 1.78 | 1.78 | 363432.0 |
| 2012-05-15 | AAUAF-DELISTED | Stock | 2.0 | 2.04 | 1.78 | 1.78 | 363632.0 |
| 2012-05-15 | AAV-DELISTED | Stock | 3.01 | 3.01 | 2.88 | 2.92 | 384970.0 |
| 2012-05-15 | AAWW-DELISTED | Stock | 48.47 | 48.57 | 47.2 | 47.51 | 312223.0 |
| 2012-05-15 | AAXJ | Stock | 52.69 | 52.93 | 52.28 | 52.4 | 2345665.0 |
| 2012-05-15 | AAXN-DELISTED | Stock | 5.19 | 5.27 | 5.15 | 5.15 | 410494.0 |
| 2012-05-15 | AB | Stock | 14.71 | 14.77 | 14.38 | 14.58 | 182000.0 |
| 2012-05-15 | ABAC-DELISTED | Stock | 1.51 | 1.5101 | 1.29 | 1.43 | 56292.0 |
| 2012-05-15 | ABAX-DELISTED | Stock | 34.45 | 34.69 | 34.07 | 34.26 | 67507.0 |
| 2012-05-15 | ABB-DELISTED | Stock | 16.44 | 16.56 | 16.305 | 16.44 | 5561979.0 |
| 2012-05-15 | ABBNY-DELISTED | Stock | 16.44 | 16.56 | 16.305 | 16.45 | 5577890.0 |
| 2012-05-15 | ABC-DELISTED | Stock | 36.54 | 36.89 | 36.35 | 36.4 | 1938994.0 |
| 2012-05-15 | ABCB | Stock | 12.22 | 12.31 | 12.06 | 12.12 | 31000.0 |
| 2012-05-15 | ABCD-DELISTED | Stock | 1.77 | 1.81 | 1.77 | 1.8 | 31713.0 |
| 2012-05-15 | ABCO-DELISTED | Stock | 46.88 | 47.31 | 46.74 | 47.07 | 301078.0 |
| 2012-05-15 | ABCW-DELISTED | Stock | 0.6225 | 0.6928 | 0.5522 | 0.6928 | 7750.0 |
| 2012-05-15 | ABE-DELISTED | Stock | 18.8096 | 18.8096 | 18.56 | 18.56 | 4065.0 |
| 2012-05-15 | ABEO | Stock | 1062.5 | 1112.5 | 1062.5 | 1100.0 | 5.0 |
| 2012-05-15 | ABFS-DELISTED | Stock | 13.17 | 13.41 | 12.99 | 13.0 | 459619.0 |
| 2012-05-15 | ABG | Stock | 25.86 | 26.26 | 25.43 | 25.84 | 478400.0 |
| 2012-05-15 | ABH-DELISTED | Stock | 11.0 | 11.0 | 10.64 | 10.77 | 281628.0 |
| 2012-05-15 | ABM | Stock | 22.45 | 22.84 | 22.34 | 22.75 | 158000.0 |
| 2012-05-15 | ABMD-DELISTED | Stock | 23.11 | 23.83 | 22.93 | 23.77 | 503941.0 |
| 2012-05-15 | ABR | Stock | 6.32 | 6.56 | 6.3 | 6.46 | 68000.0 |
| 2012-05-15 | ABT | Stock | 29.6468 | 29.7908 | 29.5653 | 29.6948 | 13527095.0 |
| 2012-05-15 | ABTL-DELISTED | Stock | 3.8031 | 3.9964 | 3.7471 | 3.9469 | 13348.0 |
| 2012-05-15 | ABUS | Stock | 2.2 | 2.2 | 1.89 | 1.96 | 45900.0 |
| 2012-05-15 | ABV-DELISTED | Stock | 38.69 | 39.25 | 38.67 | 38.81 | 2606273.0 |
| 2012-05-15 | ABVA-DELISTED | Stock | 4.09 | 4.15 | 4.06 | 4.15 | 1368.0 |
| 2012-05-15 | ABVT-DELISTED | Stock | 83.22 | 83.26 | 83.2 | 83.24 | 346004.0 |
| 2012-05-15 | ABX-DELISTED | Stock | 36.62 | 36.68 | 34.86 | 35.01 | 11119645.0 |
| 2012-05-15 | ACAD | Stock | 1.6 | 1.67 | 1.56 | 1.58 | 391800.0 |
> showing 50 of 6,185 rows — these rows as CSV