PREVIEW / stock_daily / 2010-01-12
file: by_date/stock_daily/2010/2010-01-12.parquet size: 189 KB rows: 5,920 symbols: 3,502
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-01-12 | AAPL | Stock | 7.4711 | 7.4918 | 7.3721 | 7.4186 | 594459600.0 |
| 2010-01-12 | MSFT | Stock | 30.15 | 30.4 | 29.91 | 30.07 | 65912100.0 |
| 2010-01-12 | NVDA | Stock | 0.4505 | 0.4522 | 0.4322 | 0.4418 | 627432000.0 |
| 2010-01-12 | AMZN | Stock | 6.4495 | 6.491 | 6.3275 | 6.3675 | 181926000.0 |
| 2010-01-12 | TLT | Stock | 90.16 | 90.39 | 89.8425 | 90.32 | 4321155.0 |
| 2010-01-12 | ES | Stock | 26.16 | 26.4 | 26.02 | 26.15 | 1083400.0 |
| 2010-01-12 | CL | Stock | 39.815 | 40.6 | 39.815 | 40.34 | 5733800.0 |
| 2010-01-12 | A | Stock | 21.8598 | 21.9242 | 21.6166 | 21.7811 | 2871073.0 |
| 2010-01-12 | AABA-DELISTED | Stock | 16.67 | 16.86 | 16.6 | 16.69 | 15499586.0 |
| 2010-01-12 | AACC-DELISTED | Stock | 6.57 | 6.57 | 6.31 | 6.35 | 18086.0 |
| 2010-01-12 | AAI-DELISTED | Stock | 5.07 | 5.2 | 5.06 | 5.2 | 5339320.0 |
| 2010-01-12 | AAIC-DELISTED | Stock | 15.82 | 16.15 | 15.82 | 16.15 | 11583.0 |
| 2010-01-12 | AAME | Stock | 1.33 | 1.44 | 1.26 | 1.4 | 5600.0 |
| 2010-01-12 | AAON | Stock | 3.9506 | 3.9763 | 3.8894 | 3.9111 | 222244.0 |
| 2010-01-12 | AAP | Stock | 39.43 | 39.72 | 38.82 | 39.54 | 1910800.0 |
| 2010-01-12 | AATI-DELISTED | Stock | 3.85 | 3.88 | 3.74 | 3.75 | 450791.0 |
| 2010-01-12 | AAU-DELISTED | Stock | 1.33 | 1.33 | 1.2 | 1.24 | 301774.0 |
| 2010-01-12 | AAUAF-DELISTED | Stock | 1.33 | 1.33 | 1.2 | 1.24 | 313774.0 |
| 2010-01-12 | AAV-DELISTED | Stock | 7.15 | 7.19 | 6.87 | 7.01 | 694658.0 |
| 2010-01-12 | AAWW-DELISTED | Stock | 39.03 | 39.46 | 38.4925 | 39.35 | 164300.0 |
| 2010-01-12 | AAXJ | Stock | 57.68 | 57.72 | 57.1 | 57.42 | 1028205.0 |
| 2010-01-12 | AAXN-DELISTED | Stock | 6.13 | 6.43 | 5.91 | 5.94 | 2546317.0 |
| 2010-01-12 | AB | Stock | 29.71 | 30.08 | 29.2 | 29.67 | 442400.0 |
| 2010-01-12 | ABAX-DELISTED | Stock | 26.09 | 26.2981 | 25.81 | 25.99 | 131758.0 |
| 2010-01-12 | ABB-DELISTED | Stock | 20.13 | 20.28 | 19.925 | 20.07 | 2946790.0 |
| 2010-01-12 | ABBC-DELISTED | Stock | 6.72 | 6.83 | 6.66 | 6.79 | 38831.0 |
| 2010-01-12 | ABBNY-DELISTED | Stock | 20.13 | 20.28 | 19.925 | 20.08 | 3297790.0 |
| 2010-01-12 | ABC-DELISTED | Stock | 26.28 | 26.55 | 26.19 | 26.54 | 3125703.0 |
| 2010-01-12 | ABCB | Stock | 7.6347 | 7.763 | 7.6347 | 7.6544 | 15187.0 |
| 2010-01-12 | ABCD-DELISTED | Stock | 3.99 | 4.0 | 3.67 | 4.0 | 23662.0 |
| 2010-01-12 | ABCO-DELISTED | Stock | 15.925 | 15.98 | 15.895 | 15.975 | 118995.0 |
| 2010-01-12 | ABCW-DELISTED | Stock | 0.75 | 0.94 | 0.75 | 0.91 | 636700.0 |
| 2010-01-12 | ABD-DELISTED | Stock | 8.16 | 8.18 | 7.87 | 8.0 | 365890.0 |
| 2010-01-12 | ABE-DELISTED | Stock | 16.84 | 17.04 | 16.81 | 16.85 | 13315.0 |
| 2010-01-12 | ABEO | Stock | 3937.5 | 4112.5 | 3875.0 | 4112.5 | 17.0 |
| 2010-01-12 | ABFS-DELISTED | Stock | 27.82 | 28.88 | 27.36 | 27.98 | 550750.0 |
| 2010-01-12 | ABG | Stock | 13.0 | 13.37 | 12.9 | 13.07 | 379200.0 |
| 2010-01-12 | ABII-DELISTED | Stock | 40.72 | 41.5499 | 40.23 | 41.13 | 39504.0 |
| 2010-01-12 | ABK-DELISTED | Stock | 0.813 | 0.82 | 0.78 | 0.8 | 12430318.0 |
| 2010-01-12 | ABM | Stock | 20.98 | 21.16 | 20.81 | 20.94 | 86700.0 |
| 2010-01-12 | ABMD-DELISTED | Stock | 8.06 | 8.15 | 7.8 | 7.87 | 148310.0 |
| 2010-01-12 | ABR | Stock | 2.34 | 2.34 | 2.25 | 2.32 | 175500.0 |
| 2010-01-12 | ABT | Stock | 26.485 | 26.6529 | 26.4034 | 26.4706 | 10939350.0 |
| 2010-01-12 | ABTL-DELISTED | Stock | 4.9 | 5.1 | 4.75 | 5.1 | 11222.0 |
| 2010-01-12 | ABV-DELISTED | Stock | 102.45 | 104.13 | 101.87 | 103.75 | 302836.0 |
| 2010-01-12 | ABVA-DELISTED | Stock | 2.92 | 3.1701 | 2.76 | 3.1701 | 2098.0 |
| 2010-01-12 | ABVT-DELISTED | Stock | 63.75 | 63.75 | 61.2901 | 62.3 | 97368.0 |
| 2010-01-12 | ABX-DELISTED | Stock | 41.16 | 41.52 | 39.95 | 40.25 | 12079138.0 |
| 2010-01-12 | ACAD | Stock | 1.48 | 1.48 | 1.41 | 1.41 | 323300.0 |
| 2010-01-12 | ACAP-DELISTED | Stock | 29.91 | 30.25 | 29.85 | 30.13 | 26736.0 |
> showing 50 of 5,920 rows — these rows as CSV