PREVIEW / stock_daily / 2010-12-28
file: by_date/stock_daily/2010/2010-12-28.parquet size: 195 KB rows: 6,073 symbols: 3,547
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-28 | AAPL | Stock | 11.6396 | 11.6664 | 11.6093 | 11.6239 | 175924000.0 |
| 2010-12-28 | MSFT | Stock | 27.97 | 28.17 | 27.96 | 28.01 | 23042200.0 |
| 2010-12-28 | NVDA | Stock | 0.375 | 0.3775 | 0.3713 | 0.3735 | 194260000.0 |
| 2010-12-28 | AMZN | Stock | 9.105 | 9.1385 | 9.0525 | 9.0545 | 39500000.0 |
| 2010-12-28 | TSLA | Stock | 1.7233 | 1.7833 | 1.6667 | 1.7607 | 60844500.0 |
| 2010-12-28 | TLT | Stock | 92.93 | 93.07 | 91.31 | 91.61 | 13976189.0 |
| 2010-12-28 | ES | Stock | 31.83 | 31.98 | 31.6 | 31.92 | 947100.0 |
| 2010-12-28 | CL | Stock | 40.385 | 40.455 | 40.0 | 40.39 | 4481200.0 |
| 2010-12-28 | A | Stock | 29.9928 | 30.1001 | 29.6066 | 29.6924 | 4221960.0 |
| 2010-12-28 | AABA-DELISTED | Stock | 16.47 | 16.54 | 16.33 | 16.41 | 8388841.0 |
| 2010-12-28 | AACC-DELISTED | Stock | 5.95 | 6.03 | 5.85 | 5.96 | 12389.0 |
| 2010-12-28 | AACG | Stock | 3.73 | 3.73 | 3.71 | 3.71 | 1100.0 |
| 2010-12-28 | AAI-DELISTED | Stock | 7.38 | 7.44 | 7.37 | 7.4 | 1493222.0 |
| 2010-12-28 | AAIC-DELISTED | Stock | 24.4 | 24.4 | 24.175 | 24.29 | 18018.0 |
| 2010-12-28 | AAME | Stock | 2.0 | 2.05 | 1.96 | 2.0 | 13300.0 |
| 2010-12-28 | AAON | Stock | 5.7462 | 5.7778 | 5.681 | 5.683 | 132131.0 |
| 2010-12-28 | AAP | Stock | 66.42 | 66.66 | 66.01 | 66.25 | 459200.0 |
| 2010-12-28 | AATI-DELISTED | Stock | 3.99 | 3.99 | 3.9 | 3.95 | 44358.0 |
| 2010-12-28 | AAU-DELISTED | Stock | 4.33 | 4.76 | 4.33 | 4.6628 | 417875.0 |
| 2010-12-28 | AAUAF-DELISTED | Stock | 4.33 | 4.76 | 4.33 | 4.6628 | 417975.0 |
| 2010-12-28 | AAV-DELISTED | Stock | 6.55 | 6.69 | 6.52 | 6.65 | 218719.0 |
| 2010-12-28 | AAWW-DELISTED | Stock | 57.45 | 57.59 | 56.27 | 56.48 | 57075.0 |
| 2010-12-28 | AAXJ | Stock | 62.83 | 62.87 | 62.61 | 62.73 | 202552.0 |
| 2010-12-28 | AAXN-DELISTED | Stock | 4.83 | 4.95 | 4.78 | 4.86 | 334027.0 |
| 2010-12-28 | AB | Stock | 23.19 | 23.19 | 22.68 | 22.71 | 435500.0 |
| 2010-12-28 | ABAC-DELISTED | Stock | 5.95 | 6.16 | 5.87 | 5.87 | 38013.0 |
| 2010-12-28 | ABAX-DELISTED | Stock | 27.08 | 27.15 | 26.76 | 27.01 | 116339.0 |
| 2010-12-28 | ABB-DELISTED | Stock | 22.05 | 22.09 | 21.92 | 21.96 | 787066.0 |
| 2010-12-28 | ABBC-DELISTED | Stock | 11.92 | 12.0 | 11.92 | 11.97 | 11545.0 |
| 2010-12-28 | ABBNY-DELISTED | Stock | 22.05 | 22.09 | 21.92 | 21.94 | 789171.0 |
| 2010-12-28 | ABC-DELISTED | Stock | 34.35 | 34.47 | 34.11 | 34.2 | 1157628.0 |
| 2010-12-28 | ABCB | Stock | 10.95 | 11.05 | 10.81 | 10.96 | 49700.0 |
| 2010-12-28 | ABCD-DELISTED | Stock | 3.49 | 3.49 | 3.44 | 3.46 | 9516.0 |
| 2010-12-28 | ABCO-DELISTED | Stock | 24.69 | 24.7 | 23.67 | 24.04 | 96400.0 |
| 2010-12-28 | ABCW-DELISTED | Stock | 1.3 | 1.35 | 1.17 | 1.22 | 119650.0 |
| 2010-12-28 | ABD-DELISTED | Stock | 8.76 | 8.79 | 8.63 | 8.71 | 142780.0 |
| 2010-12-28 | ABE-DELISTED | Stock | 18.11 | 18.91 | 18.01 | 18.63 | 21266.0 |
| 2010-12-28 | ABEO | Stock | 3175.0 | 3175.0 | 3012.5 | 3112.5 | 57.0 |
| 2010-12-28 | ABFS-DELISTED | Stock | 27.17 | 27.4 | 26.775 | 26.88 | 115001.0 |
| 2010-12-28 | ABG | Stock | 18.07 | 18.18 | 17.72 | 17.82 | 124500.0 |
| 2010-12-28 | ABH-DELISTED | Stock | 23.76 | 23.8 | 23.41 | 23.5 | 88306.0 |
| 2010-12-28 | ABM | Stock | 26.76 | 26.84 | 26.55 | 26.79 | 107300.0 |
| 2010-12-28 | ABMD-DELISTED | Stock | 9.8 | 9.8 | 9.71 | 9.78 | 117008.0 |
| 2010-12-28 | ABR | Stock | 6.0 | 6.05 | 5.84 | 5.95 | 75100.0 |
| 2010-12-28 | ABT | Stock | 22.8049 | 22.8145 | 22.661 | 22.7377 | 15750938.0 |
| 2010-12-28 | ABTL-DELISTED | Stock | 4.252 | 4.2525 | 4.0988 | 4.15 | 6126.0 |
| 2010-12-28 | ABUS | Stock | 4.72 | 4.77 | 4.72 | 4.77 | 1000.0 |
| 2010-12-28 | ABV-DELISTED | Stock | 30.36 | 30.39 | 29.85 | 30.04 | 1333631.0 |
| 2010-12-28 | ABVA-DELISTED | Stock | 3.96 | 4.0 | 3.92 | 4.0 | 924.0 |
| 2010-12-28 | ABVT-DELISTED | Stock | 57.46 | 57.8 | 56.75 | 57.03 | 45694.0 |
> showing 50 of 6,073 rows — these rows as CSV