PREVIEW / stock_daily / 2013-11-29
file: by_date/stock_daily/2013/2013-11-29.parquet size: 210 KB rows: 6,312 symbols: 3,447
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-29 | AAPL | Stock | 19.6243 | 19.9404 | 19.5646 | 19.8596 | 318127600.0 |
| 2013-11-29 | MSFT | Stock | 37.82 | 38.29 | 37.82 | 38.13 | 22090400.0 |
| 2013-11-29 | NVDA | Stock | 0.3925 | 0.3935 | 0.3875 | 0.39 | 116964000.0 |
| 2013-11-29 | AMZN | Stock | 19.455 | 19.705 | 19.431 | 19.681 | 48120000.0 |
| 2013-11-29 | META | Stock | 46.75 | 47.21 | 46.5 | 47.01 | 22953900.0 |
| 2013-11-29 | TSLA | Stock | 8.6513 | 8.706 | 8.4653 | 8.4853 | 145743000.0 |
| 2013-11-29 | TLT | Stock | 104.08 | 104.6 | 103.95 | 104.45 | 5084399.0 |
| 2013-11-29 | ES | Stock | 40.77 | 41.39 | 40.77 | 41.08 | 951700.0 |
| 2013-11-29 | CL | Stock | 65.9 | 66.4 | 65.73 | 65.81 | 1621600.0 |
| 2013-11-29 | A | Stock | 38.5193 | 38.6052 | 38.2403 | 38.319 | 1216819.0 |
| 2013-11-29 | AABA-DELISTED | Stock | 36.91 | 37.35 | 36.9 | 36.99 | 6434103.0 |
| 2013-11-29 | AACG | Stock | 4.08 | 4.09 | 4.01 | 4.09 | 8300.0 |
| 2013-11-29 | AAIC-DELISTED | Stock | 26.73 | 26.9 | 26.59 | 26.71 | 75288.0 |
| 2013-11-29 | AAMC-DELISTED | Stock | 216.1765 | 217.0382 | 213.2353 | 213.2353 | 1734.0 |
| 2013-11-29 | AAME | Stock | 4.0 | 4.0 | 4.0 | 4.0 | 200.0 |
| 2013-11-29 | AAMRQ-DELISTED | Stock | 12.29 | 12.35 | 11.97 | 12.02 | 3088402.0 |
| 2013-11-29 | AAOI | Stock | 12.96 | 13.24 | 12.25 | 13.19 | 54600.0 |
| 2013-11-29 | AAON | Stock | 13.7244 | 13.8 | 13.5911 | 13.6756 | 87750.0 |
| 2013-11-29 | AAP | Stock | 101.88 | 102.11 | 101.01 | 101.01 | 247600.0 |
| 2013-11-29 | AAT | Stock | 31.57 | 31.95 | 31.12 | 31.19 | 68000.0 |
| 2013-11-29 | AAU-DELISTED | Stock | 1.13 | 1.17 | 1.11 | 1.16 | 82922.0 |
| 2013-11-29 | AAUAF-DELISTED | Stock | 1.12 | 1.16 | 1.1 | 1.16 | 83843.0 |
| 2013-11-29 | AAV-DELISTED | Stock | 4.0 | 4.08 | 3.992 | 4.045 | 86286.0 |
| 2013-11-29 | AAWW-DELISTED | Stock | 38.4 | 38.83 | 38.12 | 38.36 | 146488.0 |
| 2013-11-29 | AAXJ | Stock | 60.8 | 61.24 | 60.8 | 61.13 | 1038067.0 |
| 2013-11-29 | AAXN-DELISTED | Stock | 17.59 | 17.689 | 17.1701 | 17.19 | 510802.0 |
| 2013-11-29 | AB | Stock | 22.14 | 22.38 | 22.1 | 22.19 | 310000.0 |
| 2013-11-29 | ABAC-DELISTED | Stock | 1.83 | 1.8555 | 1.78 | 1.79 | 22769.0 |
| 2013-11-29 | ABAX-DELISTED | Stock | 36.47 | 36.66 | 35.8201 | 35.98 | 45926.0 |
| 2013-11-29 | ABB-DELISTED | Stock | 25.63 | 25.7399 | 25.51 | 25.54 | 545984.0 |
| 2013-11-29 | ABBNY-DELISTED | Stock | 25.63 | 25.7399 | 25.51 | 25.55 | 559060.0 |
| 2013-11-29 | ABBV | Stock | 48.43 | 48.93 | 48.07 | 48.45 | 4044300.0 |
| 2013-11-29 | ABC-DELISTED | Stock | 70.7 | 70.88 | 70.39 | 70.52 | 382515.0 |
| 2013-11-29 | ABCB | Stock | 20.7 | 20.8 | 20.43 | 20.47 | 27500.0 |
| 2013-11-29 | ABCD-DELISTED | Stock | 1.56 | 1.56 | 1.51 | 1.56 | 5962.0 |
| 2013-11-29 | ABCO-DELISTED | Stock | 64.97 | 65.98 | 64.27 | 64.69 | 113895.0 |
| 2013-11-29 | ABE-DELISTED | Stock | 19.55 | 19.726 | 19.55 | 19.726 | 14949.0 |
| 2013-11-29 | ABEO | Stock | 362.5 | 375.0 | 362.5 | 375.0 | 40.0 |
| 2013-11-29 | ABEV | Stock | 7.45 | 7.57 | 7.44 | 7.56 | 3735300.0 |
| 2013-11-29 | ABFS-DELISTED | Stock | 32.74 | 33.16 | 32.35 | 32.52 | 150028.0 |
| 2013-11-29 | ABG | Stock | 52.15 | 52.38 | 51.4 | 51.92 | 63900.0 |
| 2013-11-29 | ABGB-DELISTED | Stock | 13.31 | 13.443 | 13.25 | 13.25 | 16187.0 |
| 2013-11-29 | ABM | Stock | 28.0 | 28.02 | 27.81 | 27.81 | 118700.0 |
| 2013-11-29 | ABMD-DELISTED | Stock | 28.7 | 28.889 | 28.52 | 28.57 | 111565.0 |
| 2013-11-29 | ABR | Stock | 6.68 | 6.68 | 6.6 | 6.63 | 31500.0 |
| 2013-11-29 | ABR.A-DELISTED | Stock | 24.59 | 24.59 | 24.59 | 24.59 | 325.0 |
| 2013-11-29 | ABR.B-DELISTED | Stock | 22.8399 | 22.8399 | 22.79 | 22.79 | 700.0 |
| 2013-11-29 | ABT | Stock | 38.44 | 38.5 | 38.08 | 38.19 | 3512700.0 |
| 2013-11-29 | ABTL-DELISTED | Stock | 12.33 | 12.6794 | 12.29 | 12.42 | 119626.0 |
| 2013-11-29 | ABUS | Stock | 8.02 | 8.4 | 8.01 | 8.15 | 141100.0 |
> showing 50 of 6,312 rows — these rows as CSV