PREVIEW / stock_daily / 2013-10-09
file: by_date/stock_daily/2013/2013-10-09.parquet size: 213 KB rows: 6,410 symbols: 3,545
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-09 | AAPL | Stock | 17.3086 | 17.4211 | 17.0814 | 17.3782 | 301725200.0 |
| 2013-10-09 | MSFT | Stock | 33.07 | 33.35 | 32.96 | 33.07 | 35878600.0 |
| 2013-10-09 | NVDA | Stock | 0.389 | 0.3893 | 0.3785 | 0.3805 | 275860000.0 |
| 2013-10-09 | AMZN | Stock | 15.171 | 15.175 | 14.825 | 14.9115 | 64948000.0 |
| 2013-10-09 | META | Stock | 47.38 | 47.84 | 45.26 | 46.77 | 147297000.0 |
| 2013-10-09 | TSLA | Stock | 11.6487 | 11.666 | 10.7667 | 11.252 | 229747500.0 |
| 2013-10-09 | TLT | Stock | 105.87 | 105.94 | 105.295 | 105.32 | 8439196.0 |
| 2013-10-09 | ES | Stock | 41.1 | 41.76 | 41.0 | 41.2 | 1109900.0 |
| 2013-10-09 | CL | Stock | 59.07 | 60.27 | 58.94 | 59.83 | 4594700.0 |
| 2013-10-09 | A | Stock | 35.9299 | 36.0372 | 35.329 | 35.7296 | 3397979.0 |
| 2013-10-09 | AABA-DELISTED | Stock | 33.04 | 33.33 | 31.79 | 33.01 | 33139637.0 |
| 2013-10-09 | AACG | Stock | 4.92 | 4.93 | 4.5 | 4.65 | 4600.0 |
| 2013-10-09 | AAIC-DELISTED | Stock | 22.83 | 23.024 | 22.83 | 22.92 | 188933.0 |
| 2013-10-09 | AAMC-DELISTED | Stock | 182.9941 | 182.9941 | 161.7647 | 169.1176 | 21522.0 |
| 2013-10-09 | AAME | Stock | 4.04 | 4.04 | 4.01 | 4.04 | 29000.0 |
| 2013-10-09 | AAMRQ-DELISTED | Stock | 5.1 | 5.25 | 4.91 | 5.02 | 4222319.0 |
| 2013-10-09 | AAOI | Stock | 10.14 | 10.21 | 10.14 | 10.15 | 14800.0 |
| 2013-10-09 | AAON | Stock | 11.0622 | 11.4267 | 11.0044 | 11.3156 | 146250.0 |
| 2013-10-09 | AAP | Stock | 81.22 | 81.41 | 80.28 | 80.48 | 530100.0 |
| 2013-10-09 | AAT | Stock | 30.78 | 30.96 | 30.62 | 30.77 | 286800.0 |
| 2013-10-09 | AAU-DELISTED | Stock | 1.36 | 1.38 | 1.3 | 1.32 | 128127.0 |
| 2013-10-09 | AAUAF-DELISTED | Stock | 1.33 | 1.349 | 1.28 | 1.32 | 138506.0 |
| 2013-10-09 | AAV-DELISTED | Stock | 3.77 | 3.79 | 3.71 | 3.73 | 121279.0 |
| 2013-10-09 | AAWW-DELISTED | Stock | 43.34 | 43.61 | 42.54 | 43.2 | 159948.0 |
| 2013-10-09 | AAXJ | Stock | 59.48 | 59.81 | 59.17 | 59.61 | 313660.0 |
| 2013-10-09 | AAXN-DELISTED | Stock | 14.91 | 15.22 | 14.25 | 14.54 | 2191465.0 |
| 2013-10-09 | AB | Stock | 19.71 | 19.99 | 19.5 | 19.8 | 414900.0 |
| 2013-10-09 | ABAC-DELISTED | Stock | 1.29 | 1.88 | 1.2799 | 1.64 | 1334603.0 |
| 2013-10-09 | ABAX-DELISTED | Stock | 39.06 | 39.59 | 38.786 | 38.92 | 147424.0 |
| 2013-10-09 | ABB-DELISTED | Stock | 22.74 | 22.87 | 22.6599 | 22.78 | 1536322.0 |
| 2013-10-09 | ABBNY-DELISTED | Stock | 22.75 | 22.87 | 22.6599 | 22.77 | 1690716.0 |
| 2013-10-09 | ABBV | Stock | 44.72 | 45.31 | 44.32 | 44.81 | 5113000.0 |
| 2013-10-09 | ABC-DELISTED | Stock | 61.29 | 61.475 | 60.78 | 61.26 | 1546845.0 |
| 2013-10-09 | ABCB | Stock | 17.78 | 17.95 | 17.54 | 17.69 | 85200.0 |
| 2013-10-09 | ABCD-DELISTED | Stock | 1.4 | 1.46 | 1.4 | 1.46 | 1770.0 |
| 2013-10-09 | ABCO-DELISTED | Stock | 60.26 | 60.97 | 59.46 | 59.8 | 357559.0 |
| 2013-10-09 | ABE-DELISTED | Stock | 19.85 | 19.97 | 19.68 | 19.68 | 3722.0 |
| 2013-10-09 | ABEO | Stock | 450.0 | 487.5 | 450.0 | 450.0 | 2.0 |
| 2013-10-09 | ABFS-DELISTED | Stock | 22.11 | 22.27 | 21.35 | 21.62 | 581523.0 |
| 2013-10-09 | ABG | Stock | 51.71 | 51.74 | 48.87 | 51.14 | 718000.0 |
| 2013-10-09 | ABM | Stock | 25.9 | 26.08 | 25.76 | 25.85 | 170900.0 |
| 2013-10-09 | ABMD-DELISTED | Stock | 19.75 | 19.95 | 19.32 | 19.59 | 363231.0 |
| 2013-10-09 | ABR | Stock | 6.75 | 6.77 | 6.66 | 6.69 | 133400.0 |
| 2013-10-09 | ABR.A-DELISTED | Stock | 24.86 | 24.86 | 24.5 | 24.501 | 842.0 |
| 2013-10-09 | ABR.B-DELISTED | Stock | 23.5 | 23.5 | 23.498 | 23.498 | 425.0 |
| 2013-10-09 | ABT | Stock | 33.03 | 33.39 | 32.75 | 33.17 | 8165400.0 |
| 2013-10-09 | ABTL-DELISTED | Stock | 7.32 | 7.6925 | 7.29 | 7.33 | 31896.0 |
| 2013-10-09 | ABUS | Stock | 9.91 | 9.99 | 8.42 | 8.77 | 584800.0 |
| 2013-10-09 | ABV-DELISTED | Stock | 37.9 | 38.01 | 37.44 | 37.75 | 1573239.0 |
| 2013-10-09 | ABX-DELISTED | Stock | 17.56 | 17.89 | 17.18 | 17.66 | 12404341.0 |
> showing 50 of 6,410 rows — these rows as CSV