PREVIEW / stock_daily / 2010-06-02
file: by_date/stock_daily/2010/2010-06-02.parquet size: 191 KB rows: 5,943 symbols: 3,502
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-02 | AAPL | Stock | 9.4479 | 9.4571 | 9.2975 | 9.4268 | 688548000.0 |
| 2010-06-02 | MSFT | Stock | 26.06 | 26.48 | 25.73 | 26.46 | 65718800.0 |
| 2010-06-02 | NVDA | Stock | 0.315 | 0.3185 | 0.313 | 0.318 | 649088000.0 |
| 2010-06-02 | AMZN | Stock | 6.201 | 6.3215 | 6.0825 | 6.3155 | 95294000.0 |
| 2010-06-02 | TLT | Stock | 96.99 | 97.19 | 95.82 | 95.93 | 5656398.0 |
| 2010-06-02 | ES | Stock | 25.4 | 25.91 | 25.25 | 25.88 | 1480000.0 |
| 2010-06-02 | CL | Stock | 38.635 | 39.12 | 38.32 | 39.11 | 9404000.0 |
| 2010-06-02 | A | Stock | 22.6753 | 23.0472 | 22.3605 | 23.0472 | 3572170.0 |
| 2010-06-02 | AABA-DELISTED | Stock | 15.04 | 15.2 | 14.96 | 15.2 | 24931508.0 |
| 2010-06-02 | AACC-DELISTED | Stock | 5.7 | 5.85 | 5.29 | 5.5 | 120524.0 |
| 2010-06-02 | AACG | Stock | 3.26 | 3.31 | 3.26 | 3.31 | 300.0 |
| 2010-06-02 | AAI-DELISTED | Stock | 5.69 | 5.89 | 5.67 | 5.89 | 4590790.0 |
| 2010-06-02 | AAIC-DELISTED | Stock | 18.7 | 18.89 | 18.23 | 18.84 | 37710.0 |
| 2010-06-02 | AAON | Stock | 4.5946 | 4.7822 | 4.5709 | 4.7763 | 405506.0 |
| 2010-06-02 | AAP | Stock | 50.41 | 51.36 | 50.41 | 51.35 | 1549900.0 |
| 2010-06-02 | AATI-DELISTED | Stock | 3.46 | 3.63 | 3.44 | 3.62 | 325272.0 |
| 2010-06-02 | AAU-DELISTED | Stock | 0.94 | 0.99 | 0.905 | 0.95 | 260647.0 |
| 2010-06-02 | AAUAF-DELISTED | Stock | 0.94 | 0.99 | 0.905 | 0.95 | 263187.0 |
| 2010-06-02 | AAV-DELISTED | Stock | 5.92 | 6.28 | 5.87 | 6.27 | 706110.0 |
| 2010-06-02 | AAWW-DELISTED | Stock | 50.32 | 53.31 | 50.02 | 53.17 | 388052.0 |
| 2010-06-02 | AAXJ | Stock | 50.75 | 52.6 | 50.75 | 52.54 | 552281.0 |
| 2010-06-02 | AAXN-DELISTED | Stock | 4.18 | 4.33 | 4.14 | 4.31 | 865854.0 |
| 2010-06-02 | AB | Stock | 28.53 | 28.68 | 28.08 | 28.48 | 233000.0 |
| 2010-06-02 | ABAX-DELISTED | Stock | 22.27 | 22.8 | 22.01 | 22.79 | 99612.0 |
| 2010-06-02 | ABB-DELISTED | Stock | 16.925 | 17.2 | 16.81 | 17.18 | 5882686.0 |
| 2010-06-02 | ABBC-DELISTED | Stock | 9.03 | 9.13 | 8.92 | 9.05 | 60121.0 |
| 2010-06-02 | ABBNY-DELISTED | Stock | 16.925 | 17.2 | 16.81 | 17.18 | 5968651.0 |
| 2010-06-02 | ABC-DELISTED | Stock | 30.87 | 31.76 | 30.73 | 31.75 | 3875955.0 |
| 2010-06-02 | ABCB | Stock | 10.6791 | 10.928 | 10.4801 | 10.9081 | 122480.0 |
| 2010-06-02 | ABCD-DELISTED | Stock | 4.8 | 4.8 | 4.56 | 4.75 | 15690.0 |
| 2010-06-02 | ABCO-DELISTED | Stock | 18.558 | 18.792 | 18.213 | 18.702 | 72155.0 |
| 2010-06-02 | ABCW-DELISTED | Stock | 0.77 | 0.8 | 0.74 | 0.8 | 81460.0 |
| 2010-06-02 | ABD-DELISTED | Stock | 6.72 | 6.8802 | 6.5898 | 6.73 | 430320.0 |
| 2010-06-02 | ABE-DELISTED | Stock | 15.25 | 15.59 | 15.16 | 15.59 | 10472.0 |
| 2010-06-02 | ABEO | Stock | 2875.0 | 2950.0 | 2812.5 | 2875.0 | 23.0 |
| 2010-06-02 | ABFS-DELISTED | Stock | 22.69 | 23.1 | 22.26 | 22.72 | 458461.0 |
| 2010-06-02 | ABG | Stock | 12.54 | 12.73 | 12.25 | 12.67 | 282000.0 |
| 2010-06-02 | ABII-DELISTED | Stock | 51.58 | 54.88 | 50.05 | 54.37 | 287331.0 |
| 2010-06-02 | ABK-DELISTED | Stock | 1.24 | 1.27 | 1.19 | 1.24 | 16951666.0 |
| 2010-06-02 | ABM | Stock | 21.2 | 22.0 | 21.06 | 21.81 | 233900.0 |
| 2010-06-02 | ABMD-DELISTED | Stock | 9.5 | 9.89 | 9.43 | 9.79 | 314798.0 |
| 2010-06-02 | ABR | Stock | 3.48 | 3.59 | 3.32 | 3.57 | 104200.0 |
| 2010-06-02 | ABT | Stock | 22.5506 | 22.7953 | 22.3155 | 22.7809 | 18735723.0 |
| 2010-06-02 | ABTL-DELISTED | Stock | 5.874 | 6.4262 | 5.623 | 6.376 | 79302.0 |
| 2010-06-02 | ABV-DELISTED | Stock | 95.74 | 97.63 | 94.89 | 97.6 | 622504.0 |
| 2010-06-02 | ABVT-DELISTED | Stock | 44.16 | 46.5 | 43.86 | 46.19 | 303120.0 |
| 2010-06-02 | ABX-DELISTED | Stock | 42.75 | 43.24 | 42.6 | 43.12 | 8982370.0 |
| 2010-06-02 | ACAD | Stock | 1.32 | 1.35 | 1.29 | 1.35 | 117700.0 |
| 2010-06-02 | ACAP-DELISTED | Stock | 30.36 | 32.81 | 30.36 | 31.24 | 125278.0 |
| 2010-06-02 | ACAS-DELISTED | Stock | 5.15 | 5.24 | 5.05 | 5.22 | 5731345.0 |
> showing 50 of 5,943 rows — these rows as CSV