PREVIEW / stock_daily / 2013-09-16
file: by_date/stock_daily/2013/2013-09-16.parquet size: 213 KB rows: 6,380 symbols: 3,522
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-09-16 | AAPL | Stock | 16.4643 | 16.4861 | 15.9721 | 16.0757 | 543706800.0 |
| 2013-09-16 | MSFT | Stock | 33.38 | 33.5 | 32.73 | 32.8 | 52839700.0 |
| 2013-09-16 | NVDA | Stock | 0.3982 | 0.401 | 0.3938 | 0.3953 | 231412000.0 |
| 2013-09-16 | AMZN | Stock | 14.991 | 15.05 | 14.763 | 14.803 | 36168000.0 |
| 2013-09-16 | META | Stock | 44.85 | 44.94 | 42.43 | 42.51 | 70424200.0 |
| 2013-09-16 | TSLA | Stock | 11.2 | 11.39 | 11.0567 | 11.1053 | 113623500.0 |
| 2013-09-16 | TLT | Stock | 104.33 | 104.41 | 102.85 | 102.86 | 8737467.0 |
| 2013-09-16 | ES | Stock | 40.76 | 41.0 | 40.3 | 40.4 | 1494000.0 |
| 2013-09-16 | CL | Stock | 59.78 | 60.24 | 59.67 | 60.02 | 2384100.0 |
| 2013-09-16 | A | Stock | 35.093 | 35.1788 | 34.7496 | 34.8641 | 2600140.0 |
| 2013-09-16 | AABA-DELISTED | Stock | 29.64 | 30.04 | 29.51 | 29.61 | 13910157.0 |
| 2013-09-16 | AACG | Stock | 4.97 | 5.0 | 4.9 | 5.0 | 3100.0 |
| 2013-09-16 | AAIC-DELISTED | Stock | 25.0 | 25.22 | 24.91 | 24.95 | 132103.0 |
| 2013-09-16 | AAMC-DELISTED | Stock | 102.9412 | 104.0559 | 102.9412 | 102.9412 | 9415.0 |
| 2013-09-16 | AAME | Stock | 3.92 | 3.97 | 3.75 | 3.94 | 17100.0 |
| 2013-09-16 | AAMRQ-DELISTED | Stock | 3.795 | 3.86 | 3.77 | 3.81 | 5460890.0 |
| 2013-09-16 | AAON | Stock | 11.3111 | 11.3111 | 11.0044 | 11.0356 | 94950.0 |
| 2013-09-16 | AAP | Stock | 80.02 | 80.21 | 79.67 | 79.72 | 573300.0 |
| 2013-09-16 | AAT | Stock | 30.78 | 30.84 | 30.37 | 30.38 | 149000.0 |
| 2013-09-16 | AAU-DELISTED | Stock | 1.471 | 1.491 | 1.369 | 1.42 | 458643.0 |
| 2013-09-16 | AAUAF-DELISTED | Stock | 1.45 | 1.47 | 1.35 | 1.42 | 481129.0 |
| 2013-09-16 | AAV-DELISTED | Stock | 3.91 | 3.91 | 3.73 | 3.75 | 133741.0 |
| 2013-09-16 | AAWW-DELISTED | Stock | 47.04 | 47.67 | 46.64 | 46.9 | 125443.0 |
| 2013-09-16 | AAXJ | Stock | 59.38 | 59.51 | 59.17 | 59.25 | 1306635.0 |
| 2013-09-16 | AAXN-DELISTED | Stock | 12.69 | 13.42 | 12.53 | 13.18 | 2304682.0 |
| 2013-09-16 | AB | Stock | 20.48 | 20.75 | 20.12 | 20.22 | 390700.0 |
| 2013-09-16 | ABAC-DELISTED | Stock | 0.848 | 0.848 | 0.81 | 0.81 | 2800.0 |
| 2013-09-16 | ABAX-DELISTED | Stock | 40.75 | 40.87 | 40.06 | 40.4 | 192639.0 |
| 2013-09-16 | ABB-DELISTED | Stock | 23.28 | 23.28 | 23.12 | 23.14 | 799547.0 |
| 2013-09-16 | ABBNY-DELISTED | Stock | 23.28 | 23.28 | 23.12 | 23.13 | 828936.0 |
| 2013-09-16 | ABBV | Stock | 45.32 | 45.95 | 45.19 | 45.82 | 3531700.0 |
| 2013-09-16 | ABC-DELISTED | Stock | 60.75 | 61.26 | 60.66 | 60.96 | 1001570.0 |
| 2013-09-16 | ABCB | Stock | 19.11 | 19.19 | 19.05 | 19.1 | 33700.0 |
| 2013-09-16 | ABCD-DELISTED | Stock | 1.74 | 1.74 | 1.5112 | 1.6 | 4868.0 |
| 2013-09-16 | ABCO-DELISTED | Stock | 59.45 | 59.45 | 57.98 | 58.0 | 133180.0 |
| 2013-09-16 | ABE-DELISTED | Stock | 19.68 | 19.68 | 19.46 | 19.55 | 4248.0 |
| 2013-09-16 | ABEO | Stock | 462.5 | 475.0 | 412.5 | 412.5 | 72.0 |
| 2013-09-16 | ABFS-DELISTED | Stock | 26.73 | 26.75 | 25.01 | 25.37 | 689278.0 |
| 2013-09-16 | ABG | Stock | 53.6 | 53.78 | 52.84 | 52.93 | 180000.0 |
| 2013-09-16 | ABM | Stock | 25.87 | 25.97 | 25.75 | 25.86 | 166100.0 |
| 2013-09-16 | ABMD-DELISTED | Stock | 23.25 | 23.59 | 22.96 | 23.42 | 227404.0 |
| 2013-09-16 | ABR | Stock | 7.2 | 7.25 | 7.15 | 7.17 | 81600.0 |
| 2013-09-16 | ABR.A-DELISTED | Stock | 24.55 | 24.7 | 24.55 | 24.6 | 3047.0 |
| 2013-09-16 | ABR.B-DELISTED | Stock | 23.55 | 23.55 | 23.55 | 23.55 | 102.0 |
| 2013-09-16 | ABT | Stock | 35.1 | 35.3 | 34.95 | 35.01 | 5714500.0 |
| 2013-09-16 | ABTL-DELISTED | Stock | 7.5 | 7.58 | 7.2755 | 7.48 | 46562.0 |
| 2013-09-16 | ABUS | Stock | 5.57 | 5.96 | 5.49 | 5.96 | 195400.0 |
| 2013-09-16 | ABV-DELISTED | Stock | 37.17 | 37.39 | 36.87 | 37.06 | 1173380.0 |
| 2013-09-16 | ABX-DELISTED | Stock | 18.11 | 18.63 | 18.01 | 18.13 | 20033627.0 |
| 2013-09-16 | ACAD | Stock | 23.5 | 23.92 | 23.0 | 23.29 | 2031400.0 |
> showing 50 of 6,380 rows — these rows as CSV