PREVIEW / stock_daily / 2010-12-07
file: by_date/stock_daily/2010/2010-12-07.parquet size: 196 KB rows: 6,075 symbols: 3,563
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-07 | AAPL | Stock | 11.5643 | 11.5711 | 11.3614 | 11.3646 | 391454000.0 |
| 2010-12-07 | MSFT | Stock | 27.08 | 27.13 | 26.85 | 26.87 | 57860500.0 |
| 2010-12-07 | NVDA | Stock | 0.3713 | 0.3833 | 0.3705 | 0.3745 | 1026812000.0 |
| 2010-12-07 | AMZN | Stock | 9.025 | 9.0735 | 8.8285 | 8.8385 | 101542000.0 |
| 2010-12-07 | TSLA | Stock | 2.0327 | 2.16 | 2.0033 | 2.104 | 19669500.0 |
| 2010-12-07 | TLT | Stock | 94.72 | 94.92 | 93.16 | 94.17 | 18536791.0 |
| 2010-12-07 | ES | Stock | 31.75 | 31.77 | 31.24 | 31.33 | 1026400.0 |
| 2010-12-07 | CL | Stock | 39.07 | 39.2 | 38.935 | 39.085 | 6150600.0 |
| 2010-12-07 | A | Stock | 26.8884 | 27.0959 | 26.824 | 26.8813 | 5754727.0 |
| 2010-12-07 | AABA-DELISTED | Stock | 16.52 | 17.07 | 16.496 | 16.94 | 28948948.0 |
| 2010-12-07 | AACC-DELISTED | Stock | 5.93 | 5.93 | 5.85 | 5.9 | 15764.0 |
| 2010-12-07 | AACG | Stock | 3.97 | 4.0 | 3.91 | 4.0 | 6700.0 |
| 2010-12-07 | AAI-DELISTED | Stock | 7.46 | 7.46 | 7.43 | 7.45 | 2755498.0 |
| 2010-12-07 | AAIC-DELISTED | Stock | 25.23 | 25.2981 | 24.36 | 24.44 | 76506.0 |
| 2010-12-07 | AAME | Stock | 1.97 | 1.98 | 1.97 | 1.98 | 400.0 |
| 2010-12-07 | AAON | Stock | 5.4321 | 5.677 | 5.4222 | 5.6691 | 249075.0 |
| 2010-12-07 | AAP | Stock | 69.38 | 69.51 | 67.11 | 67.2 | 1168900.0 |
| 2010-12-07 | AATI-DELISTED | Stock | 3.77 | 3.906 | 3.77 | 3.84 | 276406.0 |
| 2010-12-07 | AAU-DELISTED | Stock | 4.41 | 4.45 | 4.26 | 4.35 | 415435.0 |
| 2010-12-07 | AAUAF-DELISTED | Stock | 4.41 | 4.45 | 4.26 | 4.35 | 416935.0 |
| 2010-12-07 | AAV-DELISTED | Stock | 6.6 | 6.64 | 6.48 | 6.51 | 347804.0 |
| 2010-12-07 | AAWW-DELISTED | Stock | 58.48 | 60.05 | 57.88 | 59.19 | 285064.0 |
| 2010-12-07 | AAXJ | Stock | 64.17 | 64.19 | 63.38 | 63.38 | 334793.0 |
| 2010-12-07 | AAXN-DELISTED | Stock | 4.19 | 4.2 | 4.08 | 4.09 | 255829.0 |
| 2010-12-07 | AB | Stock | 23.58 | 23.75 | 23.46 | 23.48 | 450300.0 |
| 2010-12-07 | ABAC-DELISTED | Stock | 5.71 | 5.71 | 5.32 | 5.41 | 41976.0 |
| 2010-12-07 | ABAX-DELISTED | Stock | 28.48 | 28.48 | 27.78 | 28.35 | 134966.0 |
| 2010-12-07 | ABB-DELISTED | Stock | 20.93 | 20.97 | 20.52 | 20.53 | 1706662.0 |
| 2010-12-07 | ABBC-DELISTED | Stock | 11.79 | 12.0 | 11.77 | 11.82 | 55315.0 |
| 2010-12-07 | ABBNY-DELISTED | Stock | 20.92 | 20.97 | 20.52 | 20.52 | 1726800.0 |
| 2010-12-07 | ABC-DELISTED | Stock | 32.4 | 32.5 | 32.18 | 32.27 | 2455224.0 |
| 2010-12-07 | ABCB | Stock | 10.03 | 10.03 | 9.91 | 9.97 | 67200.0 |
| 2010-12-07 | ABCD-DELISTED | Stock | 3.23 | 3.25 | 3.1 | 3.22 | 16858.0 |
| 2010-12-07 | ABCO-DELISTED | Stock | 24.41 | 24.92 | 24.32 | 24.69 | 112327.0 |
| 2010-12-07 | ABCW-DELISTED | Stock | 1.31 | 1.5 | 1.3 | 1.38 | 728120.0 |
| 2010-12-07 | ABD-DELISTED | Stock | 7.48 | 7.51 | 7.31 | 7.42 | 486530.0 |
| 2010-12-07 | ABE-DELISTED | Stock | 18.84 | 19.16 | 18.7 | 18.75 | 79275.0 |
| 2010-12-07 | ABEO | Stock | 3437.5 | 3500.0 | 3437.5 | 3500.0 | 13.0 |
| 2010-12-07 | ABFS-DELISTED | Stock | 28.33 | 28.7 | 27.35 | 28.14 | 319271.0 |
| 2010-12-07 | ABG | Stock | 17.37 | 17.45 | 17.15 | 17.28 | 252800.0 |
| 2010-12-07 | ABM | Stock | 22.44 | 23.23 | 21.5 | 21.83 | 4552500.0 |
| 2010-12-07 | ABMD-DELISTED | Stock | 10.66 | 10.7 | 9.55 | 9.87 | 2206830.0 |
| 2010-12-07 | ABR | Stock | 5.32 | 5.36 | 5.25 | 5.3 | 45500.0 |
| 2010-12-07 | ABT | Stock | 22.6226 | 22.661 | 22.4546 | 22.4978 | 19987078.0 |
| 2010-12-07 | ABTL-DELISTED | Stock | 4.05 | 4.05 | 3.85 | 4.0 | 2897.0 |
| 2010-12-07 | ABUS | Stock | 4.98 | 5.07 | 4.89 | 4.93 | 3900.0 |
| 2010-12-07 | ABV-DELISTED | Stock | 143.03 | 143.32 | 140.12 | 140.32 | 465202.0 |
| 2010-12-07 | ABVA-DELISTED | Stock | 3.59 | 3.6 | 3.59 | 3.6 | 800.0 |
| 2010-12-07 | ABVT-DELISTED | Stock | 58.0 | 58.0 | 56.7701 | 57.11 | 133358.0 |
| 2010-12-07 | ABX-DELISTED | Stock | 55.48 | 55.72 | 53.91 | 54.09 | 9101940.0 |
> showing 50 of 6,075 rows — these rows as CSV