PREVIEW / stock_daily / 2010-12-31
file: by_date/stock_daily/2010/2010-12-31.parquet size: 196 KB rows: 6,083 symbols: 3,557
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-12-31 | AAPL | Stock | 11.5339 | 11.5529 | 11.4754 | 11.52 | 193508000.0 |
| 2010-12-31 | MSFT | Stock | 27.8 | 27.92 | 27.63 | 27.91 | 24752000.0 |
| 2010-12-31 | NVDA | Stock | 0.375 | 0.3855 | 0.3745 | 0.385 | 391252000.0 |
| 2010-12-31 | AMZN | Stock | 9.098 | 9.115 | 8.9755 | 9.0 | 69038000.0 |
| 2010-12-31 | TSLA | Stock | 1.7713 | 1.8167 | 1.7667 | 1.7753 | 21268500.0 |
| 2010-12-31 | TLT | Stock | 93.51 | 94.7 | 93.44 | 94.12 | 8515951.0 |
| 2010-12-31 | ES | Stock | 32.08 | 32.21 | 31.86 | 31.88 | 860200.0 |
| 2010-12-31 | CL | Stock | 40.08 | 40.325 | 40.065 | 40.185 | 2218400.0 |
| 2010-12-31 | A | Stock | 29.6352 | 29.8283 | 29.4993 | 29.6352 | 2050726.0 |
| 2010-12-31 | AABA-DELISTED | Stock | 16.74 | 16.7599 | 16.55 | 16.655 | 7613609.0 |
| 2010-12-31 | AACC-DELISTED | Stock | 5.9 | 6.0 | 5.89 | 5.94 | 17435.0 |
| 2010-12-31 | AACG | Stock | 3.67 | 3.67 | 3.65 | 3.65 | 1000.0 |
| 2010-12-31 | AAI-DELISTED | Stock | 7.39 | 7.42 | 7.38 | 7.39 | 3164815.0 |
| 2010-12-31 | AAIC-DELISTED | Stock | 23.84 | 24.22 | 23.8 | 23.99 | 20958.0 |
| 2010-12-31 | AAME | Stock | 2.04 | 2.05 | 2.0 | 2.03 | 6300.0 |
| 2010-12-31 | AAON | Stock | 5.6889 | 5.6909 | 5.5565 | 5.5723 | 131119.0 |
| 2010-12-31 | AAP | Stock | 66.6 | 66.92 | 66.14 | 66.15 | 479900.0 |
| 2010-12-31 | AATI-DELISTED | Stock | 4.0 | 4.05 | 3.98 | 4.01 | 77227.0 |
| 2010-12-31 | AAU-DELISTED | Stock | 4.48 | 4.79 | 4.48 | 4.73 | 450071.0 |
| 2010-12-31 | AAUAF-DELISTED | Stock | 4.48 | 4.79 | 4.48 | 4.73 | 450403.0 |
| 2010-12-31 | AAV-DELISTED | Stock | 6.8 | 6.85 | 6.8 | 6.8 | 258095.0 |
| 2010-12-31 | AAWW-DELISTED | Stock | 56.42 | 56.42 | 55.57 | 55.85 | 101347.0 |
| 2010-12-31 | AAXJ | Stock | 63.78 | 63.82 | 63.58 | 63.7 | 676432.0 |
| 2010-12-31 | AAXN-DELISTED | Stock | 4.7 | 4.75 | 4.65 | 4.71 | 443402.0 |
| 2010-12-31 | AB | Stock | 22.63 | 23.38 | 22.56 | 23.33 | 651800.0 |
| 2010-12-31 | ABAC-DELISTED | Stock | 6.35 | 6.43 | 6.23 | 6.25 | 58058.0 |
| 2010-12-31 | ABAX-DELISTED | Stock | 27.37 | 27.37 | 26.52 | 26.85 | 131195.0 |
| 2010-12-31 | ABB-DELISTED | Stock | 22.16 | 22.58 | 22.14 | 22.46 | 1695540.0 |
| 2010-12-31 | ABBC-DELISTED | Stock | 12.03 | 12.06 | 11.901 | 11.93 | 18711.0 |
| 2010-12-31 | ABBNY-DELISTED | Stock | 22.16 | 22.58 | 22.14 | 22.45 | 1695950.0 |
| 2010-12-31 | ABC-DELISTED | Stock | 34.12 | 34.27 | 34.06 | 34.125 | 1092786.0 |
| 2010-12-31 | ABCB | Stock | 10.75 | 10.77 | 10.54 | 10.54 | 28700.0 |
| 2010-12-31 | ABCD-DELISTED | Stock | 3.45 | 3.46 | 3.4004 | 3.44 | 17277.0 |
| 2010-12-31 | ABCO-DELISTED | Stock | 24.18 | 24.3 | 23.74 | 23.81 | 38004.0 |
| 2010-12-31 | ABCW-DELISTED | Stock | 1.17 | 1.22 | 1.17 | 1.2 | 62000.0 |
| 2010-12-31 | ABD-DELISTED | Stock | 8.72 | 8.89 | 8.458 | 8.52 | 281780.0 |
| 2010-12-31 | ABE-DELISTED | Stock | 18.99 | 19.38 | 18.79 | 19.36 | 11695.0 |
| 2010-12-31 | ABEO | Stock | 3000.0 | 3100.0 | 3000.0 | 3100.0 | 24.0 |
| 2010-12-31 | ABFS-DELISTED | Stock | 27.36 | 27.69 | 27.25 | 27.42 | 137288.0 |
| 2010-12-31 | ABG | Stock | 18.77 | 18.83 | 18.34 | 18.48 | 194900.0 |
| 2010-12-31 | ABH-DELISTED | Stock | 23.51 | 23.715 | 23.0724 | 23.67 | 114567.0 |
| 2010-12-31 | ABM | Stock | 26.51 | 26.8 | 26.27 | 26.3 | 154000.0 |
| 2010-12-31 | ABMD-DELISTED | Stock | 9.7 | 9.8 | 9.59 | 9.6 | 141002.0 |
| 2010-12-31 | ABR | Stock | 5.89 | 6.03 | 5.85 | 5.96 | 18900.0 |
| 2010-12-31 | ABT | Stock | 22.7617 | 23.1168 | 22.7617 | 22.9872 | 11564402.0 |
| 2010-12-31 | ABTL-DELISTED | Stock | 4.0972 | 4.3248 | 4.0972 | 4.3 | 11491.0 |
| 2010-12-31 | ABUS | Stock | 4.61 | 4.71 | 4.54 | 4.7 | 3400.0 |
| 2010-12-31 | ABV-DELISTED | Stock | 31.85 | 32.0 | 30.99 | 31.042 | 1566540.0 |
| 2010-12-31 | ABVA-DELISTED | Stock | 3.82 | 3.89 | 3.82 | 3.89 | 520.0 |
| 2010-12-31 | ABVT-DELISTED | Stock | 57.64 | 58.6 | 57.4 | 58.46 | 87296.0 |
> showing 50 of 6,083 rows — these rows as CSV