PREVIEW / stock_daily / 2010-02-24
file: by_date/stock_daily/2010/2010-02-24.parquet size: 189 KB rows: 5,889 symbols: 3,483
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-24 | AAPL | Stock | 7.0796 | 7.1943 | 7.0657 | 7.1664 | 460566400.0 |
| 2010-02-24 | MSFT | Stock | 28.52 | 28.79 | 28.38 | 28.63 | 43165900.0 |
| 2010-02-24 | NVDA | Stock | 0.4088 | 0.4178 | 0.4075 | 0.4138 | 445868000.0 |
| 2010-02-24 | AMZN | Stock | 5.898 | 5.99 | 5.8575 | 5.986 | 147798000.0 |
| 2010-02-24 | TLT | Stock | 90.55 | 90.88 | 90.18 | 90.69 | 4423881.0 |
| 2010-02-24 | ES | Stock | 26.42 | 26.58 | 26.01 | 26.26 | 1582800.0 |
| 2010-02-24 | CL | Stock | 41.04 | 41.52 | 40.925 | 41.48 | 4016000.0 |
| 2010-02-24 | A | Stock | 22.1531 | 22.3462 | 22.0744 | 22.3391 | 3945855.0 |
| 2010-02-24 | AABA-DELISTED | Stock | 15.48 | 15.71 | 15.33 | 15.59 | 18983113.0 |
| 2010-02-24 | AACC-DELISTED | Stock | 5.79 | 5.8 | 5.69 | 5.72 | 80982.0 |
| 2010-02-24 | AACG | Stock | 3.6 | 3.89 | 3.5 | 3.8 | 18900.0 |
| 2010-02-24 | AAI-DELISTED | Stock | 4.95 | 4.96 | 4.83 | 4.86 | 1986765.0 |
| 2010-02-24 | AAIC-DELISTED | Stock | 18.53 | 18.5735 | 17.91 | 18.1599 | 51769.0 |
| 2010-02-24 | AAME | Stock | 1.41 | 1.41 | 1.36 | 1.4 | 1600.0 |
| 2010-02-24 | AAON | Stock | 4.2864 | 4.3022 | 4.2331 | 4.2528 | 237431.0 |
| 2010-02-24 | AAP | Stock | 40.34 | 40.53 | 40.15 | 40.46 | 1441500.0 |
| 2010-02-24 | AATI-DELISTED | Stock | 3.14 | 3.43 | 3.13 | 3.4 | 801807.0 |
| 2010-02-24 | AAU-DELISTED | Stock | 0.8896 | 0.9094 | 0.8895 | 0.89 | 116710.0 |
| 2010-02-24 | AAUAF-DELISTED | Stock | 0.8901 | 0.91 | 0.89 | 0.891 | 116810.0 |
| 2010-02-24 | AAV-DELISTED | Stock | 6.92 | 7.05 | 6.88 | 6.99 | 298087.0 |
| 2010-02-24 | AAWW-DELISTED | Stock | 41.17 | 42.55 | 40.32 | 42.35 | 920225.0 |
| 2010-02-24 | AAXJ | Stock | 52.91 | 53.07 | 52.5 | 52.92 | 778113.0 |
| 2010-02-24 | AAXN-DELISTED | Stock | 7.01 | 7.26 | 7.0 | 7.22 | 1316865.0 |
| 2010-02-24 | AB | Stock | 26.19 | 26.85 | 26.08 | 26.73 | 285900.0 |
| 2010-02-24 | ABAX-DELISTED | Stock | 25.46 | 25.55 | 25.25 | 25.36 | 55990.0 |
| 2010-02-24 | ABB-DELISTED | Stock | 19.72 | 19.98 | 19.62 | 19.92 | 2142078.0 |
| 2010-02-24 | ABBC-DELISTED | Stock | 7.57 | 7.66 | 7.55 | 7.65 | 21733.0 |
| 2010-02-24 | ABBNY-DELISTED | Stock | 19.72 | 19.98 | 19.62 | 19.91 | 2146728.0 |
| 2010-02-24 | ABC-DELISTED | Stock | 27.77 | 28.04 | 27.76 | 27.9 | 2577276.0 |
| 2010-02-24 | ABCB | Stock | 9.5408 | 9.5408 | 9.3828 | 9.5013 | 25819.0 |
| 2010-02-24 | ABCO-DELISTED | Stock | 16.195 | 16.21 | 15.96 | 16.0 | 197338.0 |
| 2010-02-24 | ABCW-DELISTED | Stock | 1.1699 | 1.1897 | 1.1501 | 1.16 | 32000.0 |
| 2010-02-24 | ABD-DELISTED | Stock | 7.27 | 7.453 | 7.23 | 7.38 | 298800.0 |
| 2010-02-24 | ABE-DELISTED | Stock | 16.0 | 16.04 | 15.96 | 16.003 | 4474.0 |
| 2010-02-24 | ABEO | Stock | 3362.5 | 3362.5 | 3000.0 | 3250.0 | 26.0 |
| 2010-02-24 | ABFS-DELISTED | Stock | 24.7 | 25.73 | 24.47 | 25.64 | 540959.0 |
| 2010-02-24 | ABG | Stock | 11.56 | 11.73 | 11.43 | 11.59 | 268400.0 |
| 2010-02-24 | ABII-DELISTED | Stock | 32.99 | 32.99 | 32.27 | 32.45 | 48980.0 |
| 2010-02-24 | ABK-DELISTED | Stock | 0.77 | 0.794 | 0.72 | 0.722 | 11630930.0 |
| 2010-02-24 | ABM | Stock | 20.66 | 20.97 | 20.61 | 20.75 | 90900.0 |
| 2010-02-24 | ABMD-DELISTED | Stock | 10.03 | 10.13 | 9.96 | 9.99 | 262928.0 |
| 2010-02-24 | ABR | Stock | 2.41 | 2.5 | 2.37 | 2.4 | 66100.0 |
| 2010-02-24 | ABT | Stock | 26.0004 | 26.1683 | 25.866 | 26.0675 | 14141309.0 |
| 2010-02-24 | ABTL-DELISTED | Stock | 5.3 | 5.45 | 5.25 | 5.25 | 8500.0 |
| 2010-02-24 | ABV-DELISTED | Stock | 97.18 | 97.93 | 96.25 | 97.33 | 250359.0 |
| 2010-02-24 | ABVA-DELISTED | Stock | 2.59 | 2.59 | 2.59 | 2.59 | 100.0 |
| 2010-02-24 | ABVT-DELISTED | Stock | 61.18 | 62.27 | 60.81 | 61.25 | 44991.0 |
| 2010-02-24 | ABX-DELISTED | Stock | 37.07 | 37.79 | 36.55 | 36.72 | 10458446.0 |
| 2010-02-24 | ACAD | Stock | 1.32 | 1.32 | 1.27 | 1.27 | 118500.0 |
| 2010-02-24 | ACAP-DELISTED | Stock | 29.52 | 29.52 | 28.63 | 28.86 | 38192.0 |
> showing 50 of 5,889 rows — these rows as CSV