PREVIEW / stock_daily / 2011-02-24
file: by_date/stock_daily/2011/2011-02-24.parquet size: 196 KB rows: 6,077 symbols: 3,549
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-24 | AAPL | Stock | 12.2864 | 12.3268 | 12.0846 | 12.2457 | 499900800.0 |
| 2011-02-24 | MSFT | Stock | 26.64 | 27.06 | 26.5 | 26.77 | 64494200.0 |
| 2011-02-24 | NVDA | Stock | 0.5555 | 0.576 | 0.5515 | 0.5662 | 1246120000.0 |
| 2011-02-24 | AMZN | Stock | 8.843 | 8.9875 | 8.728 | 8.8875 | 93130000.0 |
| 2011-02-24 | TSLA | Stock | 1.452 | 1.5053 | 1.4333 | 1.502 | 15829500.0 |
| 2011-02-24 | TLT | Stock | 91.63 | 92.04 | 91.44 | 91.74 | 12111667.0 |
| 2011-02-24 | ES | Stock | 33.22 | 33.36 | 33.02 | 33.17 | 1646400.0 |
| 2011-02-24 | CL | Stock | 39.135 | 39.26 | 38.625 | 38.83 | 5621800.0 |
| 2011-02-24 | A | Stock | 28.8555 | 29.721 | 28.7411 | 29.4349 | 6228789.0 |
| 2011-02-24 | AABA-DELISTED | Stock | 16.66 | 16.73 | 16.04 | 16.38 | 31412892.0 |
| 2011-02-24 | AACC-DELISTED | Stock | 5.65 | 5.88 | 5.63 | 5.85 | 22092.0 |
| 2011-02-24 | AACG | Stock | 4.89 | 5.5 | 4.89 | 5.5 | 12100.0 |
| 2011-02-24 | AAI-DELISTED | Stock | 7.31 | 7.37 | 7.28 | 7.31 | 5417575.0 |
| 2011-02-24 | AAIC-DELISTED | Stock | 27.53 | 27.75 | 27.25 | 27.66 | 26135.0 |
| 2011-02-24 | AAME | Stock | 2.04 | 2.04 | 1.97 | 2.04 | 400.0 |
| 2011-02-24 | AAON | Stock | 5.9437 | 6.0879 | 5.9338 | 5.9694 | 244012.0 |
| 2011-02-24 | AAP | Stock | 60.54 | 61.71 | 60.54 | 61.32 | 1792200.0 |
| 2011-02-24 | AAT | Stock | 21.02 | 21.23 | 21.0 | 21.08 | 78400.0 |
| 2011-02-24 | AATI-DELISTED | Stock | 4.23 | 4.32 | 4.17 | 4.25 | 207685.0 |
| 2011-02-24 | AAU-DELISTED | Stock | 4.1 | 4.11 | 3.86 | 3.879 | 248016.0 |
| 2011-02-24 | AAUAF-DELISTED | Stock | 4.1 | 4.11 | 3.86 | 3.879 | 248216.0 |
| 2011-02-24 | AAV-DELISTED | Stock | 7.7 | 7.71 | 7.53 | 7.57 | 298686.0 |
| 2011-02-24 | AAWW-DELISTED | Stock | 66.87 | 68.07 | 65.91 | 67.92 | 274108.0 |
| 2011-02-24 | AAXJ | Stock | 59.36 | 59.38 | 58.8 | 59.25 | 409901.0 |
| 2011-02-24 | AAXN-DELISTED | Stock | 3.94 | 4.01 | 3.74 | 3.75 | 1151289.0 |
| 2011-02-24 | AB | Stock | 21.61 | 22.08 | 21.61 | 22.03 | 502100.0 |
| 2011-02-24 | ABAC-DELISTED | Stock | 4.78 | 4.87 | 4.45 | 4.7 | 101115.0 |
| 2011-02-24 | ABAX-DELISTED | Stock | 25.91 | 25.91 | 25.3 | 25.78 | 69729.0 |
| 2011-02-24 | ABB-DELISTED | Stock | 23.98 | 24.095 | 23.89 | 24.02 | 2926467.0 |
| 2011-02-24 | ABBC-DELISTED | Stock | 12.74 | 12.74 | 12.37 | 12.57 | 48890.0 |
| 2011-02-24 | ABBNY-DELISTED | Stock | 23.98 | 24.095 | 23.89 | 24.02 | 2999994.0 |
| 2011-02-24 | ABC-DELISTED | Stock | 36.97 | 36.97 | 36.31 | 36.7 | 1786772.0 |
| 2011-02-24 | ABCB | Stock | 9.97 | 9.97 | 9.87 | 9.94 | 55700.0 |
| 2011-02-24 | ABCD-DELISTED | Stock | 3.68 | 3.7 | 3.57 | 3.6 | 89370.0 |
| 2011-02-24 | ABCO-DELISTED | Stock | 25.59 | 25.59 | 24.97 | 25.23 | 239622.0 |
| 2011-02-24 | ABCW-DELISTED | Stock | 1.15 | 1.19 | 1.11 | 1.13 | 159590.0 |
| 2011-02-24 | ABD-DELISTED | Stock | 8.25 | 8.4 | 8.19 | 8.32 | 274140.0 |
| 2011-02-24 | ABE-DELISTED | Stock | 17.58 | 17.94 | 17.4 | 17.62 | 14669.0 |
| 2011-02-24 | ABEO | Stock | 2937.5 | 2937.5 | 2625.0 | 2887.5 | 13.0 |
| 2011-02-24 | ABFS-DELISTED | Stock | 24.01 | 24.035 | 23.15 | 23.53 | 288298.0 |
| 2011-02-24 | ABG | Stock | 18.35 | 18.37 | 17.8 | 18.16 | 410600.0 |
| 2011-02-24 | ABH-DELISTED | Stock | 27.19 | 28.08 | 26.82 | 27.8 | 585343.0 |
| 2011-02-24 | ABM | Stock | 26.09 | 26.26 | 25.79 | 26.0 | 237600.0 |
| 2011-02-24 | ABMD-DELISTED | Stock | 12.3 | 12.85 | 12.3 | 12.84 | 230780.0 |
| 2011-02-24 | ABR | Stock | 6.2 | 6.43 | 6.07 | 6.23 | 103000.0 |
| 2011-02-24 | ABT | Stock | 22.3251 | 22.6562 | 22.2387 | 22.6466 | 27052730.0 |
| 2011-02-24 | ABTL-DELISTED | Stock | 5.5 | 5.9 | 5.5 | 5.9 | 51908.0 |
| 2011-02-24 | ABUS | Stock | 4.97 | 4.99 | 4.86 | 4.96 | 18200.0 |
| 2011-02-24 | ABV-DELISTED | Stock | 26.57 | 26.58 | 26.25 | 26.29 | 2346497.0 |
| 2011-02-24 | ABVA-DELISTED | Stock | 4.61 | 4.61 | 4.55 | 4.55 | 2025.0 |
> showing 50 of 6,077 rows — these rows as CSV