PREVIEW / stock_daily / 2009-10-02
file: by_date/stock_daily/2009/2009-10-02.parquet size: 185 KB rows: 5,822 symbols: 3,463
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-02 | AAPL | Stock | 6.4789 | 6.6407 | 6.4768 | 6.6036 | 553308000.0 |
| 2009-10-02 | MSFT | Stock | 24.46 | 25.09 | 24.43 | 24.96 | 51219700.0 |
| 2009-10-02 | NVDA | Stock | 0.3455 | 0.3538 | 0.3435 | 0.3462 | 612476000.0 |
| 2009-10-02 | AMZN | Stock | 4.5025 | 4.557 | 4.479 | 4.4925 | 100788000.0 |
| 2009-10-02 | TLT | Stock | 100.28 | 100.31 | 98.88 | 99.01 | 4827652.0 |
| 2009-10-02 | ES | Stock | 23.26 | 23.38 | 22.99 | 23.06 | 1956200.0 |
| 2009-10-02 | CL | Stock | 37.77 | 38.57 | 37.6 | 38.42 | 6175800.0 |
| 2009-10-02 | A | Stock | 18.8913 | 18.9342 | 18.5622 | 18.8197 | 4997011.0 |
| 2009-10-02 | AABA-DELISTED | Stock | 17.22 | 17.35 | 16.78 | 16.82 | 32348401.0 |
| 2009-10-02 | AACC-DELISTED | Stock | 6.9 | 7.49 | 6.9 | 7.16 | 147646.0 |
| 2009-10-02 | AACG | Stock | 5.6 | 5.6 | 5.5 | 5.54 | 4100.0 |
| 2009-10-02 | AAI-DELISTED | Stock | 5.65 | 6.24 | 5.65 | 6.05 | 3110869.0 |
| 2009-10-02 | AAIC-DELISTED | Stock | 9.2 | 9.4 | 8.8 | 9.0 | 1488138.0 |
| 2009-10-02 | AAME | Stock | 1.01 | 1.1 | 1.0 | 1.01 | 12500.0 |
| 2009-10-02 | AAON | Stock | 3.7827 | 3.8222 | 3.759 | 3.763 | 493594.0 |
| 2009-10-02 | AAP | Stock | 37.67 | 38.2 | 37.4 | 37.48 | 2629300.0 |
| 2009-10-02 | AATI-DELISTED | Stock | 3.44 | 3.45 | 3.2 | 3.36 | 861504.0 |
| 2009-10-02 | AAU-DELISTED | Stock | 0.69 | 0.69 | 0.67 | 0.69 | 94850.0 |
| 2009-10-02 | AAUAF-DELISTED | Stock | 0.69 | 0.69 | 0.67 | 0.69 | 109950.0 |
| 2009-10-02 | AAV-DELISTED | Stock | 6.42 | 6.42 | 6.12 | 6.37 | 1149868.0 |
| 2009-10-02 | AAWW-DELISTED | Stock | 29.07 | 29.85 | 28.16 | 29.24 | 318309.0 |
| 2009-10-02 | AAXJ | Stock | 51.23 | 51.44 | 50.51 | 51.3 | 314372.0 |
| 2009-10-02 | AAXN-DELISTED | Stock | 4.5 | 4.57 | 4.45 | 4.5 | 264489.0 |
| 2009-10-02 | AB | Stock | 25.45 | 25.89 | 24.4 | 24.52 | 829400.0 |
| 2009-10-02 | ABAX-DELISTED | Stock | 26.0 | 26.22 | 25.6 | 25.84 | 91596.0 |
| 2009-10-02 | ABB-DELISTED | Stock | 19.13 | 19.48 | 19.12 | 19.4005 | 3363488.0 |
| 2009-10-02 | ABBC-DELISTED | Stock | 7.52 | 7.89 | 7.52 | 7.75 | 27895.0 |
| 2009-10-02 | ABBNY-DELISTED | Stock | 19.13 | 19.48 | 19.12 | 19.42 | 3371088.0 |
| 2009-10-02 | ABC-DELISTED | Stock | 21.9 | 21.92 | 21.57 | 21.61 | 2447573.0 |
| 2009-10-02 | ABCB | Stock | 6.1062 | 7.4882 | 6.0865 | 6.9295 | 52442.0 |
| 2009-10-02 | ABCO-DELISTED | Stock | 12.93 | 13.039 | 12.75 | 12.82 | 60625.0 |
| 2009-10-02 | ABCW-DELISTED | Stock | 1.3115 | 1.373 | 1.2398 | 1.25 | 95220.0 |
| 2009-10-02 | ABD-DELISTED | Stock | 6.67 | 6.86 | 6.26 | 6.48 | 401320.0 |
| 2009-10-02 | ABE-DELISTED | Stock | 17.08 | 17.18 | 16.71 | 17.09 | 31006.0 |
| 2009-10-02 | ABEO | Stock | 3612.5 | 4000.0 | 3612.5 | 3750.0 | 141.0 |
| 2009-10-02 | ABFS-DELISTED | Stock | 28.51 | 28.58 | 27.14 | 27.35 | 921309.0 |
| 2009-10-02 | ABG | Stock | 12.18 | 12.45 | 11.91 | 12.29 | 233800.0 |
| 2009-10-02 | ABII-DELISTED | Stock | 36.26 | 36.39 | 35.57 | 36.38 | 50757.0 |
| 2009-10-02 | ABK-DELISTED | Stock | 1.45 | 1.57 | 1.41 | 1.52 | 16801442.0 |
| 2009-10-02 | ABM | Stock | 20.06 | 20.34 | 20.06 | 20.18 | 87400.0 |
| 2009-10-02 | ABMD-DELISTED | Stock | 9.39 | 9.91 | 9.33 | 9.88 | 539552.0 |
| 2009-10-02 | ABR | Stock | 2.73 | 2.8 | 2.61 | 2.76 | 226800.0 |
| 2009-10-02 | ABT | Stock | 23.2271 | 23.99 | 23.2271 | 23.9132 | 26714048.0 |
| 2009-10-02 | ABTL-DELISTED | Stock | 3.3532 | 3.3532 | 3.0992 | 3.15 | 12648.0 |
| 2009-10-02 | ABV-DELISTED | Stock | 81.53 | 84.41 | 81.28 | 84.16 | 1028104.0 |
| 2009-10-02 | ABVT-DELISTED | Stock | 47.35 | 48.41 | 47.35 | 47.67 | 53039.0 |
| 2009-10-02 | ABX-DELISTED | Stock | 35.89 | 36.9 | 35.71 | 36.07 | 15343609.0 |
| 2009-10-02 | ACAD | Stock | 1.51 | 1.65 | 1.5 | 1.65 | 1635900.0 |
| 2009-10-02 | ACAP-DELISTED | Stock | 28.48 | 29.63 | 28.48 | 29.28 | 67878.0 |
| 2009-10-02 | ACAS-DELISTED | Stock | 2.86 | 2.87 | 2.69 | 2.71 | 8918313.0 |
> showing 50 of 5,822 rows — these rows as CSV