PREVIEW / stock_daily / 2013-09-13
file: by_date/stock_daily/2013/2013-09-13.parquet size: 212 KB rows: 6,367 symbols: 3,519
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-13 | AAPL | Stock | 16.7621 | 16.8511 | 16.5964 | 16.6036 | 298835600.0 |
| 2013-09-13 | MSFT | Stock | 32.77 | 33.07 | 32.51 | 33.03 | 40899000.0 |
| 2013-09-13 | NVDA | Stock | 0.3938 | 0.3968 | 0.391 | 0.395 | 159696000.0 |
| 2013-09-13 | AMZN | Stock | 15.007 | 15.011 | 14.81 | 14.896 | 27012000.0 |
| 2013-09-13 | META | Stock | 45.04 | 45.08 | 43.93 | 44.31 | 52765300.0 |
| 2013-09-13 | TSLA | Stock | 10.8513 | 11.0913 | 10.8107 | 11.036 | 81018000.0 |
| 2013-09-13 | TLT | Stock | 103.51 | 103.83 | 103.23 | 103.55 | 6107612.0 |
| 2013-09-13 | ES | Stock | 40.21 | 40.45 | 40.17 | 40.29 | 1204300.0 |
| 2013-09-13 | CL | Stock | 59.43 | 59.69 | 59.27 | 59.43 | 1754500.0 |
| 2013-09-13 | A | Stock | 34.7639 | 34.7783 | 34.4993 | 34.6638 | 2993258.0 |
| 2013-09-13 | AABA-DELISTED | Stock | 29.47 | 29.47 | 28.805 | 29.26 | 13711205.0 |
| 2013-09-13 | AACG | Stock | 4.68 | 4.75 | 4.68 | 4.75 | 600.0 |
| 2013-09-13 | AAIC-DELISTED | Stock | 24.58 | 24.92 | 24.58 | 24.65 | 89708.0 |
| 2013-09-13 | AAMC-DELISTED | Stock | 103.5882 | 103.5882 | 101.4706 | 102.6147 | 3376.0 |
| 2013-09-13 | AAME | Stock | 3.9 | 3.96 | 3.87 | 3.93 | 4700.0 |
| 2013-09-13 | AAMRQ-DELISTED | Stock | 3.665 | 3.76 | 3.66 | 3.72 | 4246464.0 |
| 2013-09-13 | AAON | Stock | 11.1733 | 11.2756 | 11.0311 | 11.1733 | 86850.0 |
| 2013-09-13 | AAP | Stock | 80.58 | 80.58 | 79.26 | 79.38 | 414300.0 |
| 2013-09-13 | AAT | Stock | 30.11 | 30.37 | 29.9 | 30.21 | 101200.0 |
| 2013-09-13 | AAU-DELISTED | Stock | 1.5 | 1.5 | 1.436 | 1.48 | 151516.0 |
| 2013-09-13 | AAUAF-DELISTED | Stock | 1.49 | 1.49 | 1.431 | 1.49 | 152419.0 |
| 2013-09-13 | AAV-DELISTED | Stock | 3.83 | 3.89 | 3.8 | 3.86 | 51812.0 |
| 2013-09-13 | AAWW-DELISTED | Stock | 47.23 | 47.84 | 46.4 | 46.5 | 119863.0 |
| 2013-09-13 | AAXJ | Stock | 58.04 | 58.515 | 58.04 | 58.48 | 1365070.0 |
| 2013-09-13 | AAXN-DELISTED | Stock | 12.32 | 12.37 | 12.04 | 12.33 | 672467.0 |
| 2013-09-13 | AB | Stock | 20.02 | 20.17 | 19.8 | 20.12 | 364600.0 |
| 2013-09-13 | ABAC-DELISTED | Stock | 0.8045 | 0.81 | 0.7601 | 0.8 | 5805.0 |
| 2013-09-13 | ABAX-DELISTED | Stock | 41.08 | 41.2 | 40.31 | 40.41 | 92494.0 |
| 2013-09-13 | ABB-DELISTED | Stock | 22.79 | 22.96 | 22.67 | 22.92 | 691463.0 |
| 2013-09-13 | ABBNY-DELISTED | Stock | 22.79 | 22.96 | 22.67 | 22.91 | 712165.0 |
| 2013-09-13 | ABBV | Stock | 44.71 | 44.89 | 44.43 | 44.89 | 2273500.0 |
| 2013-09-13 | ABC-DELISTED | Stock | 60.63 | 60.78 | 60.09 | 60.27 | 1207265.0 |
| 2013-09-13 | ABCB | Stock | 18.93 | 19.04 | 18.68 | 18.91 | 14700.0 |
| 2013-09-13 | ABCD-DELISTED | Stock | 1.4702 | 1.5 | 1.46 | 1.49 | 4398.0 |
| 2013-09-13 | ABCO-DELISTED | Stock | 58.87 | 59.99 | 58.16 | 59.1 | 149882.0 |
| 2013-09-13 | ABE-DELISTED | Stock | 19.58 | 19.58 | 19.51 | 19.58 | 23168.0 |
| 2013-09-13 | ABEO | Stock | 462.5 | 462.5 | 412.5 | 450.0 | 91.0 |
| 2013-09-13 | ABFS-DELISTED | Stock | 27.55 | 27.5999 | 26.6628 | 26.87 | 345183.0 |
| 2013-09-13 | ABG | Stock | 52.73 | 52.86 | 52.23 | 52.63 | 113100.0 |
| 2013-09-13 | ABM | Stock | 25.78 | 25.86 | 25.67 | 25.72 | 126500.0 |
| 2013-09-13 | ABMD-DELISTED | Stock | 22.66 | 23.04 | 22.64 | 23.0 | 227549.0 |
| 2013-09-13 | ABR | Stock | 7.15 | 7.22 | 7.07 | 7.16 | 50100.0 |
| 2013-09-13 | ABR.A-DELISTED | Stock | 24.25 | 24.38 | 24.2499 | 24.379 | 3000.0 |
| 2013-09-13 | ABR.B-DELISTED | Stock | 23.55 | 23.55 | 23.55 | 23.55 | 190.0 |
| 2013-09-13 | ABT | Stock | 34.9 | 34.9 | 34.57 | 34.87 | 4882300.0 |
| 2013-09-13 | ABTL-DELISTED | Stock | 7.25 | 7.49 | 7.2499 | 7.4 | 64602.0 |
| 2013-09-13 | ABUS | Stock | 5.48 | 5.54 | 5.45 | 5.51 | 31200.0 |
| 2013-09-13 | ABV-DELISTED | Stock | 37.04 | 37.17 | 36.89 | 37.02 | 1325618.0 |
| 2013-09-13 | ABX-DELISTED | Stock | 17.51 | 17.84 | 17.39 | 17.72 | 14433196.0 |
| 2013-09-13 | ACAD | Stock | 22.84 | 23.22 | 22.4 | 23.12 | 2247100.0 |
> showing 50 of 6,367 rows — these rows as CSV