PREVIEW / stock_daily / 2010-02-04
file: by_date/stock_daily/2010/2010-02-04.parquet size: 188 KB rows: 5,913 symbols: 3,494
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-02-04 | AAPL | Stock | 7.0261 | 7.0846 | 6.8418 | 6.8589 | 757652000.0 |
| 2010-02-04 | MSFT | Stock | 28.38 | 28.5 | 27.81 | 27.84 | 77850000.0 |
| 2010-02-04 | NVDA | Stock | 0.4182 | 0.4182 | 0.393 | 0.3975 | 783480000.0 |
| 2010-02-04 | AMZN | Stock | 5.932 | 6.0165 | 5.787 | 5.797 | 255680000.0 |
| 2010-02-04 | TLT | Stock | 90.99 | 91.82 | 90.9 | 91.78 | 6095145.0 |
| 2010-02-04 | ES | Stock | 25.78 | 25.85 | 25.2 | 25.22 | 1843500.0 |
| 2010-02-04 | CL | Stock | 40.23 | 40.375 | 39.805 | 39.835 | 7284000.0 |
| 2010-02-04 | A | Stock | 20.9585 | 21.0658 | 20.701 | 20.794 | 6632392.0 |
| 2010-02-04 | AABA-DELISTED | Stock | 15.34 | 15.52 | 14.99 | 15.0 | 26874188.0 |
| 2010-02-04 | AACC-DELISTED | Stock | 5.5 | 5.78 | 5.2 | 5.23 | 30996.0 |
| 2010-02-04 | AACG | Stock | 3.46 | 3.52 | 3.3 | 3.41 | 21100.0 |
| 2010-02-04 | AAI-DELISTED | Stock | 4.84 | 4.84 | 4.52 | 4.56 | 5608611.0 |
| 2010-02-04 | AAIC-DELISTED | Stock | 15.12 | 15.4 | 14.7 | 15.4 | 59983.0 |
| 2010-02-04 | AAME | Stock | 1.35 | 1.35 | 1.35 | 1.35 | 2000.0 |
| 2010-02-04 | AAON | Stock | 4.0593 | 4.079 | 4.0178 | 4.0533 | 629269.0 |
| 2010-02-04 | AAP | Stock | 41.06 | 41.73 | 40.69 | 40.93 | 1611600.0 |
| 2010-02-04 | AATI-DELISTED | Stock | 3.48 | 3.58 | 3.35 | 3.49 | 436895.0 |
| 2010-02-04 | AAU-DELISTED | Stock | 0.93 | 0.93 | 0.873 | 0.8851 | 136065.0 |
| 2010-02-04 | AAUAF-DELISTED | Stock | 0.93 | 0.93 | 0.873 | 0.8851 | 137265.0 |
| 2010-02-04 | AAV-DELISTED | Stock | 6.51 | 6.58 | 6.35 | 6.3699 | 587020.0 |
| 2010-02-04 | AAWW-DELISTED | Stock | 38.55 | 38.86 | 36.45 | 38.18 | 810301.0 |
| 2010-02-04 | AAXJ | Stock | 52.7 | 52.75 | 51.26 | 51.34 | 395707.0 |
| 2010-02-04 | AAXN-DELISTED | Stock | 5.78 | 5.8 | 5.63 | 5.63 | 721268.0 |
| 2010-02-04 | AB | Stock | 27.0 | 27.04 | 25.75 | 25.85 | 404600.0 |
| 2010-02-04 | ABAX-DELISTED | Stock | 24.1 | 24.1 | 23.1 | 23.13 | 117771.0 |
| 2010-02-04 | ABB-DELISTED | Stock | 18.39 | 18.43 | 17.9 | 17.91 | 4635871.0 |
| 2010-02-04 | ABBC-DELISTED | Stock | 7.09 | 7.19 | 7.09 | 7.1 | 64840.0 |
| 2010-02-04 | ABBNY-DELISTED | Stock | 18.39 | 18.43 | 17.9 | 17.93 | 4635871.0 |
| 2010-02-04 | ABC-DELISTED | Stock | 28.26 | 28.26 | 27.42 | 27.42 | 4570174.0 |
| 2010-02-04 | ABCB | Stock | 9.0964 | 9.2544 | 9.0174 | 9.1359 | 80493.0 |
| 2010-02-04 | ABCD-DELISTED | Stock | 3.56 | 3.79 | 3.55 | 3.72 | 35903.0 |
| 2010-02-04 | ABCO-DELISTED | Stock | 15.92 | 16.075 | 15.91 | 15.94 | 162328.0 |
| 2010-02-04 | ABCW-DELISTED | Stock | 1.17 | 1.19 | 1.02 | 1.04 | 141540.0 |
| 2010-02-04 | ABD-DELISTED | Stock | 7.71 | 7.78 | 7.2 | 7.21 | 488250.0 |
| 2010-02-04 | ABE-DELISTED | Stock | 16.14 | 16.16 | 15.631 | 15.65 | 19425.0 |
| 2010-02-04 | ABEO | Stock | 3500.0 | 3500.0 | 3312.5 | 3475.0 | 9.0 |
| 2010-02-04 | ABFS-DELISTED | Stock | 22.3 | 22.5294 | 21.77 | 21.79 | 427602.0 |
| 2010-02-04 | ABG | Stock | 11.79 | 11.88 | 11.24 | 11.42 | 337500.0 |
| 2010-02-04 | ABII-DELISTED | Stock | 40.91 | 41.01 | 39.88 | 40.08 | 55665.0 |
| 2010-02-04 | ABK-DELISTED | Stock | 0.69 | 0.69 | 0.63 | 0.6311 | 10815615.0 |
| 2010-02-04 | ABM | Stock | 19.48 | 19.55 | 19.13 | 19.37 | 182000.0 |
| 2010-02-04 | ABMD-DELISTED | Stock | 8.0 | 8.44 | 7.95 | 8.28 | 1247961.0 |
| 2010-02-04 | ABR | Stock | 2.34 | 2.37 | 2.09 | 2.14 | 115100.0 |
| 2010-02-04 | ABT | Stock | 26.269 | 26.269 | 25.8084 | 25.8228 | 19169446.0 |
| 2010-02-04 | ABTL-DELISTED | Stock | 5.4998 | 5.4998 | 5.1002 | 5.2502 | 5696.0 |
| 2010-02-04 | ABV-DELISTED | Stock | 95.49 | 96.25 | 91.47 | 91.66 | 626783.0 |
| 2010-02-04 | ABVA-DELISTED | Stock | 2.77 | 2.8299 | 2.6 | 2.8299 | 4681.0 |
| 2010-02-04 | ABVT-DELISTED | Stock | 59.06 | 59.26 | 56.72 | 56.81 | 95769.0 |
| 2010-02-04 | ABX-DELISTED | Stock | 35.15 | 35.2 | 33.75 | 33.94 | 16305510.0 |
| 2010-02-04 | ACAD | Stock | 1.46 | 1.46 | 1.31 | 1.36 | 756300.0 |
> showing 50 of 5,913 rows — these rows as CSV