PREVIEW / stock_daily / 2010-12-20
file: by_date/stock_daily/2010/2010-12-20.parquet size: 198 KB rows: 6,098 symbols: 3,584
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-20 | AAPL | Stock | 11.4857 | 11.5446 | 11.3654 | 11.5075 | 385610400.0 |
| 2010-12-20 | MSFT | Stock | 27.95 | 27.99 | 27.68 | 27.81 | 52811000.0 |
| 2010-12-20 | NVDA | Stock | 0.3605 | 0.3622 | 0.3575 | 0.3578 | 344088000.0 |
| 2010-12-20 | AMZN | Stock | 8.9635 | 9.199 | 8.902 | 9.1645 | 174706000.0 |
| 2010-12-20 | TSLA | Stock | 2.1093 | 2.146 | 2.084 | 2.1133 | 7851000.0 |
| 2010-12-20 | TLT | Stock | 93.75 | 94.23 | 92.64 | 93.14 | 13703967.0 |
| 2010-12-20 | ES | Stock | 32.07 | 32.14 | 31.73 | 31.94 | 1326800.0 |
| 2010-12-20 | CL | Stock | 40.645 | 40.66 | 40.22 | 40.22 | 3850600.0 |
| 2010-12-20 | A | Stock | 28.6838 | 29.0916 | 28.226 | 29.0629 | 5625133.0 |
| 2010-12-20 | AABA-DELISTED | Stock | 16.4 | 16.42 | 16.15 | 16.28 | 17443582.0 |
| 2010-12-20 | AACC-DELISTED | Stock | 5.81 | 5.85 | 5.67 | 5.73 | 12141.0 |
| 2010-12-20 | AACG | Stock | 3.69 | 3.7 | 3.65 | 3.7 | 1400.0 |
| 2010-12-20 | AAI-DELISTED | Stock | 7.42 | 7.44 | 7.41 | 7.41 | 778248.0 |
| 2010-12-20 | AAIC-DELISTED | Stock | 24.17 | 25.23 | 24.05 | 24.96 | 56534.0 |
| 2010-12-20 | AAON | Stock | 5.6751 | 5.7284 | 5.4538 | 5.6711 | 262744.0 |
| 2010-12-20 | AAP | Stock | 66.69 | 67.57 | 66.31 | 67.39 | 650100.0 |
| 2010-12-20 | AATI-DELISTED | Stock | 3.99 | 3.99 | 3.92 | 3.95 | 58815.0 |
| 2010-12-20 | AAU-DELISTED | Stock | 4.77 | 5.12 | 4.74 | 5.03 | 1282013.0 |
| 2010-12-20 | AAUAF-DELISTED | Stock | 4.77 | 5.15 | 4.77 | 5.03 | 1280300.0 |
| 2010-12-20 | AAV-DELISTED | Stock | 6.26 | 6.35 | 6.21 | 6.28 | 322474.0 |
| 2010-12-20 | AAWW-DELISTED | Stock | 57.0 | 57.03 | 56.45 | 56.94 | 287286.0 |
| 2010-12-20 | AAXJ | Stock | 62.84 | 62.84 | 62.41 | 62.56 | 678197.0 |
| 2010-12-20 | AAXN-DELISTED | Stock | 4.91 | 5.1 | 4.87 | 4.88 | 841443.0 |
| 2010-12-20 | AB | Stock | 22.55 | 22.61 | 22.21 | 22.3 | 585100.0 |
| 2010-12-20 | ABAC-DELISTED | Stock | 5.89 | 6.1 | 5.6101 | 6.09 | 109133.0 |
| 2010-12-20 | ABAX-DELISTED | Stock | 27.76 | 28.28 | 27.66 | 27.86 | 115455.0 |
| 2010-12-20 | ABB-DELISTED | Stock | 21.89 | 21.9 | 21.67 | 21.73 | 1357365.0 |
| 2010-12-20 | ABBC-DELISTED | Stock | 11.7 | 11.96 | 11.7 | 11.91 | 54229.0 |
| 2010-12-20 | ABBNY-DELISTED | Stock | 21.89 | 21.9 | 21.67 | 21.71 | 1361967.0 |
| 2010-12-20 | ABC-DELISTED | Stock | 33.38 | 33.47 | 33.18 | 33.39 | 1925552.0 |
| 2010-12-20 | ABCB | Stock | 10.49 | 10.9 | 10.46 | 10.71 | 70100.0 |
| 2010-12-20 | ABCD-DELISTED | Stock | 3.4 | 3.46 | 3.28 | 3.3 | 22092.0 |
| 2010-12-20 | ABCO-DELISTED | Stock | 24.35 | 24.78 | 24.35 | 24.42 | 79287.0 |
| 2010-12-20 | ABCW-DELISTED | Stock | 1.1697 | 1.2087 | 1.1131 | 1.16 | 149760.0 |
| 2010-12-20 | ABD-DELISTED | Stock | 8.35 | 8.44 | 8.35 | 8.43 | 154350.0 |
| 2010-12-20 | ABE-DELISTED | Stock | 18.55 | 18.68 | 18.55 | 18.65 | 33977.0 |
| 2010-12-20 | ABEO | Stock | 3112.5 | 3112.5 | 3000.0 | 3100.0 | 20.0 |
| 2010-12-20 | ABFS-DELISTED | Stock | 26.3 | 26.97 | 26.23 | 26.29 | 296012.0 |
| 2010-12-20 | ABG | Stock | 17.01 | 17.57 | 16.92 | 17.5 | 241900.0 |
| 2010-12-20 | ABH-DELISTED | Stock | 22.4 | 23.0 | 22.4 | 22.95 | 278223.0 |
| 2010-12-20 | ABM | Stock | 26.49 | 26.7 | 26.22 | 26.31 | 303300.0 |
| 2010-12-20 | ABMD-DELISTED | Stock | 9.18 | 9.35 | 9.18 | 9.23 | 110230.0 |
| 2010-12-20 | ABR | Stock | 5.52 | 5.7 | 5.31 | 5.53 | 101900.0 |
| 2010-12-20 | ABT | Stock | 23.2991 | 23.3998 | 23.0928 | 23.1599 | 12841392.0 |
| 2010-12-20 | ABTL-DELISTED | Stock | 4.1475 | 4.2882 | 3.9495 | 3.95 | 22732.0 |
| 2010-12-20 | ABUS | Stock | 4.6 | 4.6 | 4.5 | 4.5 | 4300.0 |
| 2010-12-20 | ABV-DELISTED | Stock | 146.83 | 147.92 | 144.05 | 146.05 | 436122.0 |
| 2010-12-20 | ABVA-DELISTED | Stock | 3.57 | 3.6 | 3.57 | 3.6 | 3100.0 |
| 2010-12-20 | ABVT-DELISTED | Stock | 56.64 | 57.23 | 56.3301 | 56.79 | 85061.0 |
| 2010-12-20 | ABX-DELISTED | Stock | 52.03 | 52.28 | 51.62 | 51.84 | 3745019.0 |
> showing 50 of 6,098 rows — these rows as CSV