PREVIEW / stock_daily / 2011-05-12
file: by_date/stock_daily/2011/2011-05-12.parquet size: 197 KB rows: 6,127 symbols: 3,582
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-12 | AAPL | Stock | 12.3614 | 12.3971 | 12.2239 | 12.3775 | 322000000.0 |
| 2011-05-12 | MSFT | Stock | 25.35 | 25.39 | 25.1 | 25.32 | 77400000.0 |
| 2011-05-12 | NVDA | Stock | 0.495 | 0.513 | 0.4938 | 0.5125 | 1224000000.0 |
| 2011-05-12 | AMZN | Stock | 10.211 | 10.3095 | 10.031 | 10.3035 | 96000000.0 |
| 2011-05-12 | TSLA | Stock | 1.8047 | 1.8493 | 1.7767 | 1.8447 | 9420000.0 |
| 2011-05-12 | TLT | Stock | 94.95 | 95.11 | 93.91 | 94.23 | 8017425.0 |
| 2011-05-12 | ES | Stock | 35.55 | 36.07 | 35.55 | 36.01 | 1100000.0 |
| 2011-05-12 | CL | Stock | 42.51 | 43.73 | 42.405 | 43.605 | 7400000.0 |
| 2011-05-12 | A | Stock | 35.6509 | 36.1874 | 35.329 | 36.0014 | 5065373.0 |
| 2011-05-12 | AABA-DELISTED | Stock | 17.12 | 17.81 | 16.93 | 17.16 | 52057846.0 |
| 2011-05-12 | AACC-DELISTED | Stock | 4.62 | 4.66 | 4.44 | 4.55 | 36596.0 |
| 2011-05-12 | AACG | Stock | 8.76 | 8.9 | 8.5 | 8.82 | 14100.0 |
| 2011-05-12 | AAIC-DELISTED | Stock | 29.14 | 29.51 | 28.97 | 29.5 | 24154.0 |
| 2011-05-12 | AAME | Stock | 2.1 | 2.1 | 1.99 | 2.1 | 500.0 |
| 2011-05-12 | AAON | Stock | 6.477 | 6.6667 | 6.4632 | 6.6054 | 99731.0 |
| 2011-05-12 | AAP | Stock | 68.82 | 69.83 | 68.17 | 69.41 | 1422300.0 |
| 2011-05-12 | AAT | Stock | 21.98 | 22.05 | 21.68 | 22.01 | 43000.0 |
| 2011-05-12 | AATI-DELISTED | Stock | 4.01 | 4.06 | 3.99 | 4.01 | 138110.0 |
| 2011-05-12 | AAU-DELISTED | Stock | 3.92 | 4.1019 | 3.8561 | 4.04 | 688454.0 |
| 2011-05-12 | AAUAF-DELISTED | Stock | 3.91 | 4.14 | 3.89 | 4.05 | 684940.0 |
| 2011-05-12 | AAV-DELISTED | Stock | 7.66 | 7.77 | 7.57 | 7.69 | 423034.0 |
| 2011-05-12 | AAWW-DELISTED | Stock | 64.52 | 65.12 | 63.78 | 64.66 | 144866.0 |
| 2011-05-12 | AAXJ | Stock | 62.8 | 63.52 | 62.71 | 63.38 | 738256.0 |
| 2011-05-12 | AAXN-DELISTED | Stock | 4.45 | 4.68 | 4.432 | 4.65 | 391581.0 |
| 2011-05-12 | AB | Stock | 21.66 | 22.0 | 21.2 | 21.98 | 686000.0 |
| 2011-05-12 | ABAC-DELISTED | Stock | 2.96 | 3.1899 | 2.96 | 3.13 | 42000.0 |
| 2011-05-12 | ABAX-DELISTED | Stock | 27.58 | 28.42 | 27.24 | 28.16 | 59338.0 |
| 2011-05-12 | ABB-DELISTED | Stock | 26.04 | 26.57 | 25.89 | 26.45 | 2061171.0 |
| 2011-05-12 | ABBC-DELISTED | Stock | 11.62 | 11.83 | 11.5 | 11.81 | 27852.0 |
| 2011-05-12 | ABBNY-DELISTED | Stock | 26.04 | 26.57 | 25.89 | 26.46 | 2064311.0 |
| 2011-05-12 | ABC-DELISTED | Stock | 42.01 | 42.49 | 41.77 | 42.45 | 2087093.0 |
| 2011-05-12 | ABCB | Stock | 9.16 | 9.44 | 9.15 | 9.36 | 83700.0 |
| 2011-05-12 | ABCD-DELISTED | Stock | 3.08 | 3.17 | 3.08 | 3.14 | 15089.0 |
| 2011-05-12 | ABCO-DELISTED | Stock | 25.4 | 25.89 | 25.36 | 25.86 | 175019.0 |
| 2011-05-12 | ABCW-DELISTED | Stock | 0.85 | 0.9 | 0.85 | 0.86 | 46260.0 |
| 2011-05-12 | ABD-DELISTED | Stock | 9.21 | 9.741 | 9.14 | 9.58 | 120440.0 |
| 2011-05-12 | ABE-DELISTED | Stock | 18.6 | 18.81 | 18.4901 | 18.81 | 6635.0 |
| 2011-05-12 | ABEO | Stock | 2550.0 | 2562.5 | 2525.0 | 2562.5 | 7.0 |
| 2011-05-12 | ABFS-DELISTED | Stock | 23.69 | 24.31 | 23.3 | 24.07 | 176756.0 |
| 2011-05-12 | ABG | Stock | 16.64 | 17.28 | 16.28 | 17.11 | 343000.0 |
| 2011-05-12 | ABH-DELISTED | Stock | 26.33 | 26.33 | 25.6 | 25.85 | 881094.0 |
| 2011-05-12 | ABM | Stock | 23.74 | 24.53 | 23.61 | 24.5 | 317000.0 |
| 2011-05-12 | ABMD-DELISTED | Stock | 17.08 | 17.77 | 16.96 | 17.695 | 169273.0 |
| 2011-05-12 | ABR | Stock | 5.41 | 5.48 | 5.36 | 5.39 | 75000.0 |
| 2011-05-12 | ABT | Stock | 25.4534 | 25.7892 | 25.3095 | 25.6837 | 16783451.0 |
| 2011-05-12 | ABTL-DELISTED | Stock | 6.1 | 6.3 | 6.05 | 6.25 | 21002.0 |
| 2011-05-12 | ABUS | Stock | 2.82 | 2.82 | 2.7 | 2.74 | 4700.0 |
| 2011-05-12 | ABV-DELISTED | Stock | 31.56 | 31.72 | 31.14 | 31.61 | 2033661.0 |
| 2011-05-12 | ABVA-DELISTED | Stock | 6.76 | 6.79 | 6.7357 | 6.79 | 6477.0 |
| 2011-05-12 | ABVT-DELISTED | Stock | 63.95 | 65.79 | 63.9 | 65.63 | 106566.0 |
> showing 50 of 6,127 rows — these rows as CSV