PREVIEW / stock_daily / 2010-12-23
file: by_date/stock_daily/2010/2010-12-23.parquet size: 196 KB rows: 6,068 symbols: 3,552
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-23 | AAPL | Stock | 11.6071 | 11.6125 | 11.5418 | 11.5571 | 223157200.0 |
| 2010-12-23 | MSFT | Stock | 27.97 | 28.32 | 27.96 | 28.3 | 24902500.0 |
| 2010-12-23 | NVDA | Stock | 0.3758 | 0.3758 | 0.3715 | 0.373 | 273784000.0 |
| 2010-12-23 | AMZN | Stock | 9.217 | 9.249 | 9.0945 | 9.1295 | 67164000.0 |
| 2010-12-23 | TSLA | Stock | 2.084 | 2.1653 | 1.9947 | 2.006 | 23289000.0 |
| 2010-12-23 | TLT | Stock | 93.18 | 93.23 | 92.53 | 92.93 | 7091738.0 |
| 2010-12-23 | ES | Stock | 31.88 | 32.0 | 31.77 | 31.86 | 942600.0 |
| 2010-12-23 | CL | Stock | 40.345 | 40.64 | 40.19 | 40.265 | 2650200.0 |
| 2010-12-23 | A | Stock | 29.2632 | 29.5565 | 29.2632 | 29.3777 | 2290483.0 |
| 2010-12-23 | AABA-DELISTED | Stock | 16.57 | 16.73 | 16.45 | 16.73 | 8585018.0 |
| 2010-12-23 | AACC-DELISTED | Stock | 5.76 | 5.9391 | 5.76 | 5.79 | 8043.0 |
| 2010-12-23 | AACG | Stock | 3.79 | 3.79 | 3.79 | 3.79 | 400.0 |
| 2010-12-23 | AAI-DELISTED | Stock | 7.38 | 7.4 | 7.35 | 7.36 | 1917529.0 |
| 2010-12-23 | AAIC-DELISTED | Stock | 24.87 | 24.87 | 24.48 | 24.57 | 28731.0 |
| 2010-12-23 | AAME | Stock | 1.97 | 2.0 | 1.97 | 2.0 | 300.0 |
| 2010-12-23 | AAON | Stock | 5.6849 | 5.756 | 5.6435 | 5.7165 | 183769.0 |
| 2010-12-23 | AAP | Stock | 66.46 | 66.83 | 66.39 | 66.57 | 408200.0 |
| 2010-12-23 | AATI-DELISTED | Stock | 3.98 | 3.99 | 3.9 | 3.96 | 87243.0 |
| 2010-12-23 | AAU-DELISTED | Stock | 4.75 | 4.75 | 3.99 | 4.37 | 2092783.0 |
| 2010-12-23 | AAUAF-DELISTED | Stock | 4.75 | 4.75 | 3.99 | 4.36 | 2092933.0 |
| 2010-12-23 | AAV-DELISTED | Stock | 6.64 | 6.78 | 6.58 | 6.67 | 258998.0 |
| 2010-12-23 | AAWW-DELISTED | Stock | 57.44 | 57.8 | 57.37 | 57.59 | 78962.0 |
| 2010-12-23 | AAXJ | Stock | 62.67 | 62.7 | 62.42 | 62.63 | 256985.0 |
| 2010-12-23 | AAXN-DELISTED | Stock | 4.81 | 4.85 | 4.7 | 4.74 | 286829.0 |
| 2010-12-23 | AB | Stock | 22.93 | 23.29 | 22.91 | 23.16 | 446800.0 |
| 2010-12-23 | ABAC-DELISTED | Stock | 5.95 | 6.0761 | 5.79 | 6.07 | 29205.0 |
| 2010-12-23 | ABAX-DELISTED | Stock | 27.68 | 27.74 | 27.24 | 27.28 | 59287.0 |
| 2010-12-23 | ABB-DELISTED | Stock | 21.97 | 22.01 | 21.87 | 21.9701 | 1327134.0 |
| 2010-12-23 | ABBC-DELISTED | Stock | 11.92 | 11.97 | 11.85 | 11.925 | 26615.0 |
| 2010-12-23 | ABBNY-DELISTED | Stock | 21.97 | 22.01 | 21.87 | 22.0 | 1333719.0 |
| 2010-12-23 | ABC-DELISTED | Stock | 34.08 | 34.5 | 34.07 | 34.39 | 2252592.0 |
| 2010-12-23 | ABCB | Stock | 10.62 | 10.71 | 10.43 | 10.55 | 23000.0 |
| 2010-12-23 | ABCD-DELISTED | Stock | 3.43 | 3.52 | 3.37 | 3.48 | 23031.0 |
| 2010-12-23 | ABCO-DELISTED | Stock | 24.18 | 24.48 | 24.04 | 24.14 | 92879.0 |
| 2010-12-23 | ABCW-DELISTED | Stock | 1.275 | 1.3447 | 1.2252 | 1.275 | 88130.0 |
| 2010-12-23 | ABD-DELISTED | Stock | 8.57 | 8.73 | 8.51 | 8.71 | 160680.0 |
| 2010-12-23 | ABE-DELISTED | Stock | 18.68 | 18.85 | 18.627 | 18.64 | 29602.0 |
| 2010-12-23 | ABEO | Stock | 3000.0 | 3250.0 | 3000.0 | 3137.5 | 80.0 |
| 2010-12-23 | ABFS-DELISTED | Stock | 27.25 | 27.4 | 26.85 | 26.95 | 126186.0 |
| 2010-12-23 | ABG | Stock | 18.12 | 18.31 | 17.99 | 18.06 | 88500.0 |
| 2010-12-23 | ABH-DELISTED | Stock | 23.62 | 24.0 | 23.59 | 23.85 | 141161.0 |
| 2010-12-23 | ABM | Stock | 26.65 | 26.8 | 26.46 | 26.57 | 129400.0 |
| 2010-12-23 | ABMD-DELISTED | Stock | 9.43 | 9.6 | 9.31 | 9.56 | 243248.0 |
| 2010-12-23 | ABR | Stock | 5.75 | 5.87 | 5.75 | 5.8 | 65600.0 |
| 2010-12-23 | ABT | Stock | 22.9009 | 23.0448 | 22.8913 | 22.9392 | 10838891.0 |
| 2010-12-23 | ABTL-DELISTED | Stock | 4.2025 | 4.3562 | 4.0539 | 4.1 | 17209.0 |
| 2010-12-23 | ABUS | Stock | 4.6 | 4.72 | 4.48 | 4.67 | 9000.0 |
| 2010-12-23 | ABV-DELISTED | Stock | 150.0 | 153.12 | 149.75 | 151.99 | 296375.0 |
| 2010-12-23 | ABVA-DELISTED | Stock | 3.63 | 4.0 | 3.63 | 4.0 | 6322.0 |
| 2010-12-23 | ABVT-DELISTED | Stock | 57.92 | 58.21 | 57.46 | 57.75 | 60043.0 |
> showing 50 of 6,068 rows — these rows as CSV