PREVIEW / stock_daily / 2008-01-31
file: by_date/stock_daily/2008/2008-01-31.parquet size: 182 KB rows: 5,693 symbols: 3,454
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-31 | AAPL | Stock | 4.6232 | 4.8804 | 4.6214 | 4.8343 | 1345674400.0 |
| 2008-01-31 | MSFT | Stock | 31.91 | 32.74 | 31.72 | 32.6 | 103642200.0 |
| 2008-01-31 | NVDA | Stock | 0.616 | 0.6263 | 0.5958 | 0.6148 | 588708000.0 |
| 2008-01-31 | AMZN | Stock | 3.4455 | 3.9435 | 3.442 | 3.885 | 857718000.0 |
| 2008-01-31 | TLT | Stock | 95.3 | 95.4299 | 94.63 | 95.01 | 11440965.0 |
| 2008-01-31 | CL | Stock | 37.44 | 38.605 | 37.065 | 38.25 | 11878000.0 |
| 2008-01-31 | A | Stock | 24.02 | 24.4134 | 23.8412 | 24.2203 | 8476214.0 |
| 2008-01-31 | AABA-DELISTED | Stock | 18.87 | 19.35 | 18.72 | 19.14 | 41475440.0 |
| 2008-01-31 | AACC-DELISTED | Stock | 9.35 | 9.67 | 9.35 | 9.65 | 151165.0 |
| 2008-01-31 | AACG | Stock | 8.49 | 10.3 | 8.49 | 9.55 | 182300.0 |
| 2008-01-31 | AAI-DELISTED | Stock | 8.45 | 8.79 | 8.37 | 8.64 | 2213300.0 |
| 2008-01-31 | AAIC-DELISTED | Stock | 63.8 | 68.6 | 63.8 | 64.6 | 1412603.0 |
| 2008-01-31 | AAME | Stock | 1.64 | 1.65 | 1.57 | 1.59 | 3500.0 |
| 2008-01-31 | AAON | Stock | 3.2553 | 3.5793 | 3.2415 | 3.516 | 471319.0 |
| 2008-01-31 | AAP | Stock | 34.4 | 36.13 | 34.18 | 35.78 | 1412100.0 |
| 2008-01-31 | AATI-DELISTED | Stock | 6.8 | 6.94 | 6.62 | 6.74 | 634005.0 |
| 2008-01-31 | AAU-DELISTED | Stock | 2.7 | 2.7 | 2.6 | 2.6 | 31025.0 |
| 2008-01-31 | AAUAF-DELISTED | Stock | 2.7 | 2.7 | 2.58 | 2.58 | 32625.0 |
| 2008-01-31 | AAV-DELISTED | Stock | 9.5 | 9.71 | 9.43 | 9.64 | 368932.0 |
| 2008-01-31 | AAWW-DELISTED | Stock | 48.34 | 50.05 | 48.34 | 49.94 | 255176.0 |
| 2008-01-31 | AAXN-DELISTED | Stock | 10.65 | 11.55 | 10.58 | 11.45 | 1843033.0 |
| 2008-01-31 | AB | Stock | 66.49 | 67.71 | 65.05 | 66.39 | 701000.0 |
| 2008-01-31 | ABAX-DELISTED | Stock | 32.93 | 33.27 | 30.95 | 32.53 | 773087.0 |
| 2008-01-31 | ABB-DELISTED | Stock | 23.89 | 25.31 | 23.84 | 24.97 | 6531823.0 |
| 2008-01-31 | ABBC-DELISTED | Stock | 9.12 | 9.45 | 9.12 | 9.44 | 98412.0 |
| 2008-01-31 | ABBNY-DELISTED | Stock | 23.89 | 25.31 | 23.84 | 25.02 | 6532323.0 |
| 2008-01-31 | ABC-DELISTED | Stock | 23.22 | 23.82 | 22.98 | 23.3 | 4027300.0 |
| 2008-01-31 | ABCB | Stock | 14.3367 | 15.3774 | 13.7337 | 15.3483 | 49760.0 |
| 2008-01-31 | ABCO-DELISTED | Stock | 31.36 | 32.32 | 31.21 | 31.85 | 258624.0 |
| 2008-01-31 | ABCW-DELISTED | Stock | 22.7 | 25.58 | 22.39 | 25.0 | 220510.0 |
| 2008-01-31 | ABD-DELISTED | Stock | 12.8 | 13.64 | 12.64 | 13.55 | 597950.0 |
| 2008-01-31 | ABE-DELISTED | Stock | 22.5 | 23.63 | 22.18 | 23.53 | 30400.0 |
| 2008-01-31 | ABEO | Stock | 3437.5 | 3750.0 | 3437.5 | 3500.0 | 4.0 |
| 2008-01-31 | ABFS-DELISTED | Stock | 29.28 | 31.28 | 29.2 | 30.74 | 1353277.0 |
| 2008-01-31 | ABG | Stock | 13.03 | 14.52 | 12.89 | 14.22 | 1036800.0 |
| 2008-01-31 | ABII-DELISTED | Stock | 61.948 | 61.948 | 59.0 | 59.39 | 13356.0 |
| 2008-01-31 | ABK-DELISTED | Stock | 9.86 | 12.4 | 9.7 | 11.64 | 14657757.0 |
| 2008-01-31 | ABM | Stock | 19.25 | 20.95 | 19.25 | 20.72 | 303700.0 |
| 2008-01-31 | ABMD-DELISTED | Stock | 14.86 | 15.25 | 14.79 | 15.11 | 318910.0 |
| 2008-01-31 | ABP-DELISTED | Stock | 3.6 | 3.76 | 3.5 | 3.73 | 268598.0 |
| 2008-01-31 | ABR | Stock | 17.25 | 17.96 | 17.0 | 17.68 | 585500.0 |
| 2008-01-31 | ABT | Stock | 26.4946 | 27.2047 | 25.3766 | 26.9552 | 21681117.0 |
| 2008-01-31 | ABTL-DELISTED | Stock | 12.275 | 12.476 | 11.524 | 12.025 | 252880.0 |
| 2008-01-31 | ABV-DELISTED | Stock | 70.24 | 71.7 | 68.41 | 70.94 | 1157916.0 |
| 2008-01-31 | ABVA-DELISTED | Stock | 6.4499 | 6.4499 | 6.2219 | 6.36 | 1600.0 |
| 2008-01-31 | ABVT-DELISTED | Stock | 75.25 | 75.75 | 70.0 | 75.75 | 1512.0 |
| 2008-01-31 | ABX-DELISTED | Stock | 52.39 | 52.51 | 50.82 | 51.53 | 14968709.0 |
| 2008-01-31 | ACAD | Stock | 10.57 | 12.2 | 10.49 | 11.86 | 621100.0 |
| 2008-01-31 | ACAP-DELISTED | Stock | 39.07 | 41.59 | 38.99 | 41.31 | 55205.0 |
| 2008-01-31 | ACAS-DELISTED | Stock | 32.77 | 35.53 | 32.45 | 35.1 | 5346919.0 |
> showing 50 of 5,693 rows — these rows as CSV