PREVIEW / stock_daily / 2013-10-02
file: by_date/stock_daily/2013/2013-10-02.parquet size: 213 KB rows: 6,378 symbols: 3,528
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-02 | AAPL | Stock | 17.3439 | 17.5643 | 17.2768 | 17.4843 | 289184000.0 |
| 2013-10-02 | MSFT | Stock | 33.36 | 34.03 | 33.29 | 33.92 | 46946800.0 |
| 2013-10-02 | NVDA | Stock | 0.3848 | 0.39 | 0.3848 | 0.3885 | 162036000.0 |
| 2013-10-02 | AMZN | Stock | 15.902 | 16.0865 | 15.876 | 16.0255 | 44348000.0 |
| 2013-10-02 | META | Stock | 50.13 | 51.1 | 49.95 | 50.28 | 62834000.0 |
| 2013-10-02 | TSLA | Stock | 12.5727 | 12.7887 | 11.6933 | 12.0633 | 311631000.0 |
| 2013-10-02 | TLT | Stock | 105.93 | 106.48 | 105.76 | 105.96 | 5967420.0 |
| 2013-10-02 | ES | Stock | 41.18 | 41.59 | 41.16 | 41.47 | 1678200.0 |
| 2013-10-02 | CL | Stock | 59.7 | 59.75 | 59.03 | 59.43 | 2736900.0 |
| 2013-10-02 | A | Stock | 36.9027 | 36.9886 | 36.588 | 36.8884 | 2825078.0 |
| 2013-10-02 | AABA-DELISTED | Stock | 34.15 | 34.6951 | 33.9 | 34.15 | 21080905.0 |
| 2013-10-02 | AACG | Stock | 4.97 | 4.97 | 4.9 | 4.91 | 500.0 |
| 2013-10-02 | AAIC-DELISTED | Stock | 24.01 | 24.17 | 23.81 | 23.95 | 118193.0 |
| 2013-10-02 | AAMC-DELISTED | Stock | 161.7647 | 179.4118 | 161.7647 | 177.3529 | 96179.0 |
| 2013-10-02 | AAME | Stock | 4.0 | 4.0 | 3.96 | 4.0 | 5000.0 |
| 2013-10-02 | AAMRQ-DELISTED | Stock | 4.49 | 4.68 | 4.48 | 4.56 | 7434628.0 |
| 2013-10-02 | AAOI | Stock | 9.99 | 10.0 | 9.89 | 9.97 | 94000.0 |
| 2013-10-02 | AAON | Stock | 12.28 | 12.3244 | 11.8444 | 11.9022 | 182700.0 |
| 2013-10-02 | AAP | Stock | 82.9 | 83.05 | 82.0 | 82.62 | 437400.0 |
| 2013-10-02 | AAT | Stock | 30.86 | 31.09 | 30.62 | 31.01 | 74800.0 |
| 2013-10-02 | AAU-DELISTED | Stock | 1.33 | 1.4 | 1.3 | 1.36 | 109989.0 |
| 2013-10-02 | AAUAF-DELISTED | Stock | 1.33 | 1.4 | 1.3 | 1.36 | 110389.0 |
| 2013-10-02 | AAV-DELISTED | Stock | 3.87 | 3.94 | 3.86 | 3.87 | 90264.0 |
| 2013-10-02 | AAWW-DELISTED | Stock | 45.95 | 46.29 | 45.71 | 45.97 | 94738.0 |
| 2013-10-02 | AAXJ | Stock | 59.0 | 59.42 | 58.85 | 59.41 | 347692.0 |
| 2013-10-02 | AAXN-DELISTED | Stock | 15.97 | 17.16 | 15.6201 | 16.645 | 3203905.0 |
| 2013-10-02 | AB | Stock | 19.52 | 19.7 | 19.5 | 19.59 | 152700.0 |
| 2013-10-02 | ABAC-DELISTED | Stock | 1.03 | 1.03 | 0.9551 | 1.02 | 135993.0 |
| 2013-10-02 | ABAX-DELISTED | Stock | 41.44 | 41.964 | 41.16 | 41.24 | 86602.0 |
| 2013-10-02 | ABB-DELISTED | Stock | 23.56 | 23.6 | 23.42 | 23.6 | 687147.0 |
| 2013-10-02 | ABBNY-DELISTED | Stock | 23.56 | 23.6 | 23.42 | 23.6 | 696834.0 |
| 2013-10-02 | ABBV | Stock | 45.34 | 45.97 | 45.12 | 45.95 | 4056800.0 |
| 2013-10-02 | ABC-DELISTED | Stock | 62.18 | 62.3 | 61.58 | 62.21 | 1148057.0 |
| 2013-10-02 | ABCB | Stock | 18.38 | 18.57 | 18.08 | 18.23 | 108500.0 |
| 2013-10-02 | ABCD-DELISTED | Stock | 1.4 | 1.49 | 1.4 | 1.45 | 16343.0 |
| 2013-10-02 | ABCO-DELISTED | Stock | 59.98 | 61.66 | 59.14 | 61.31 | 147212.0 |
| 2013-10-02 | ABE-DELISTED | Stock | 19.55 | 19.76 | 19.41 | 19.75 | 5462.0 |
| 2013-10-02 | ABEO | Stock | 487.5 | 487.5 | 437.5 | 450.0 | 32.0 |
| 2013-10-02 | ABFS-DELISTED | Stock | 26.56 | 26.6 | 26.1945 | 26.48 | 402731.0 |
| 2013-10-02 | ABG | Stock | 53.43 | 55.64 | 52.65 | 55.61 | 421600.0 |
| 2013-10-02 | ABM | Stock | 26.7 | 26.7 | 26.39 | 26.45 | 148800.0 |
| 2013-10-02 | ABMD-DELISTED | Stock | 19.07 | 19.15 | 18.795 | 18.89 | 269437.0 |
| 2013-10-02 | ABR | Stock | 6.9 | 6.91 | 6.82 | 6.85 | 131000.0 |
| 2013-10-02 | ABR.A-DELISTED | Stock | 24.73 | 24.8499 | 24.73 | 24.8499 | 1100.0 |
| 2013-10-02 | ABR.B-DELISTED | Stock | 23.49 | 23.5 | 23.49 | 23.5 | 2514.0 |
| 2013-10-02 | ABT | Stock | 33.48 | 33.92 | 33.47 | 33.9 | 8420200.0 |
| 2013-10-02 | ABTL-DELISTED | Stock | 7.3 | 7.33 | 7.1504 | 7.33 | 26977.0 |
| 2013-10-02 | ABUS | Stock | 7.24 | 7.47 | 7.14 | 7.26 | 110600.0 |
| 2013-10-02 | ABV-DELISTED | Stock | 38.47 | 38.68 | 38.045 | 38.65 | 1272522.0 |
| 2013-10-02 | ABX-DELISTED | Stock | 18.32 | 18.79 | 18.23 | 18.41 | 16317173.0 |
> showing 50 of 6,378 rows — these rows as CSV