PREVIEW / stock_daily / 2008-10-20
file: by_date/stock_daily/2008/2008-10-20.parquet size: 178 KB rows: 5,773 symbols: 3,483
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-10-20 | AAPL | Stock | 3.5636 | 3.5725 | 3.3443 | 3.5157 | 1549170000.0 |
| 2008-10-20 | MSFT | Stock | 24.2 | 24.75 | 23.01 | 24.72 | 93484300.0 |
| 2008-10-20 | NVDA | Stock | 0.1978 | 0.1992 | 0.1903 | 0.195 | 595764000.0 |
| 2008-10-20 | AMZN | Stock | 2.6085 | 2.655 | 2.4955 | 2.6485 | 169042000.0 |
| 2008-10-20 | TLT | Stock | 93.44 | 94.94 | 93.36 | 94.62 | 1146711.0 |
| 2008-10-20 | CL | Stock | 31.81 | 32.305 | 31.165 | 32.305 | 6597800.0 |
| 2008-10-20 | A | Stock | 16.3519 | 17.0601 | 15.98 | 17.0601 | 2529681.0 |
| 2008-10-20 | AABA-DELISTED | Stock | 12.99 | 13.04 | 12.33 | 12.85 | 24948398.0 |
| 2008-10-20 | AACC-DELISTED | Stock | 8.51 | 9.7 | 8.33 | 9.65 | 96415.0 |
| 2008-10-20 | AACG | Stock | 8.7 | 9.06 | 8.52 | 8.6 | 80300.0 |
| 2008-10-20 | AAI-DELISTED | Stock | 3.1 | 3.35 | 3.02 | 3.19 | 2321201.0 |
| 2008-10-20 | AAIC-DELISTED | Stock | 11.2 | 12.0 | 11.0 | 11.0 | 308828.0 |
| 2008-10-20 | AAME | Stock | 1.0 | 1.2 | 0.93 | 0.93 | 2200.0 |
| 2008-10-20 | AAON | Stock | 3.0696 | 3.1368 | 2.9827 | 3.117 | 317419.0 |
| 2008-10-20 | AAP | Stock | 27.89 | 29.78 | 27.89 | 29.78 | 1779000.0 |
| 2008-10-20 | AATI-DELISTED | Stock | 3.55 | 3.59 | 3.35 | 3.38 | 223609.0 |
| 2008-10-20 | AAU-DELISTED | Stock | 0.63 | 0.69 | 0.59 | 0.66 | 185880.0 |
| 2008-10-20 | AAUAF-DELISTED | Stock | 0.6301 | 0.69 | 0.59 | 0.66 | 200165.0 |
| 2008-10-20 | AAV-DELISTED | Stock | 6.64 | 6.87 | 6.37 | 6.79 | 1017459.0 |
| 2008-10-20 | AAWW-DELISTED | Stock | 29.53 | 29.74 | 27.44 | 29.31 | 176744.0 |
| 2008-10-20 | AAXJ | Stock | 33.6 | 34.58 | 33.4 | 34.5 | 127201.0 |
| 2008-10-20 | AAXN-DELISTED | Stock | 4.9 | 5.06 | 4.81 | 5.05 | 353825.0 |
| 2008-10-20 | AB | Stock | 25.17 | 25.17 | 22.96 | 23.82 | 517700.0 |
| 2008-10-20 | ABAX-DELISTED | Stock | 14.26 | 14.7 | 14.03 | 14.64 | 222424.0 |
| 2008-10-20 | ABB-DELISTED | Stock | 15.37 | 16.07 | 15.24 | 16.05 | 4548211.0 |
| 2008-10-20 | ABBC-DELISTED | Stock | 9.8 | 10.03 | 9.65 | 9.99 | 45567.0 |
| 2008-10-20 | ABBNY-DELISTED | Stock | 15.37 | 16.07 | 15.24 | 16.05 | 4558011.0 |
| 2008-10-20 | ABC-DELISTED | Stock | 15.41 | 16.34 | 15.36 | 16.32 | 3086802.0 |
| 2008-10-20 | ABCB | Stock | 13.4322 | 13.4322 | 12.0219 | 12.2358 | 30638.0 |
| 2008-10-20 | ABCO-DELISTED | Stock | 12.3 | 12.685 | 11.675 | 12.145 | 460940.0 |
| 2008-10-20 | ABCW-DELISTED | Stock | 6.035 | 6.2145 | 5.6061 | 6.025 | 139670.0 |
| 2008-10-20 | ABD-DELISTED | Stock | 4.2 | 4.2 | 3.82 | 4.01 | 289980.0 |
| 2008-10-20 | ABE-DELISTED | Stock | 13.18 | 14.28 | 13.01 | 14.22 | 26279.0 |
| 2008-10-20 | ABEO | Stock | 2950.0 | 2962.5 | 2937.5 | 2937.5 | 5.0 |
| 2008-10-20 | ABFS-DELISTED | Stock | 29.38 | 30.94 | 29.1 | 30.24 | 465468.0 |
| 2008-10-20 | ABG | Stock | 3.86 | 4.06 | 3.84 | 3.85 | 465400.0 |
| 2008-10-20 | ABII-DELISTED | Stock | 64.78 | 66.0 | 62.42 | 65.52 | 7361.0 |
| 2008-10-20 | ABK-DELISTED | Stock | 3.77 | 3.94 | 3.1 | 3.37 | 40604446.0 |
| 2008-10-20 | ABM | Stock | 14.96 | 15.13 | 14.55 | 15.13 | 319500.0 |
| 2008-10-20 | ABMD-DELISTED | Stock | 13.05 | 13.74 | 13.01 | 13.6 | 242462.0 |
| 2008-10-20 | ABR | Stock | 5.81 | 6.25 | 5.2 | 5.27 | 198900.0 |
| 2008-10-20 | ABT | Stock | 26.8304 | 27.8236 | 26.5665 | 27.6125 | 19806378.0 |
| 2008-10-20 | ABTL-DELISTED | Stock | 2.6498 | 2.6503 | 2.5002 | 2.5002 | 2015.0 |
| 2008-10-20 | ABV-DELISTED | Stock | 47.08 | 48.96 | 46.82 | 48.51 | 847212.0 |
| 2008-10-20 | ABVA-DELISTED | Stock | 3.73 | 3.78 | 3.07 | 3.78 | 9811.0 |
| 2008-10-20 | ABX-DELISTED | Stock | 24.48 | 26.63 | 23.54 | 26.5 | 11538394.0 |
| 2008-10-20 | ACAD | Stock | 1.92 | 2.0 | 1.87 | 2.0 | 137100.0 |
| 2008-10-20 | ACAP-DELISTED | Stock | 37.79 | 39.96 | 37.23 | 39.76 | 55114.0 |
| 2008-10-20 | ACAS-DELISTED | Stock | 15.22 | 15.97 | 14.87 | 15.61 | 2645465.0 |
| 2008-10-20 | ACAT-DELISTED | Stock | 6.06 | 6.68 | 6.06 | 6.32 | 99304.0 |
> showing 50 of 5,773 rows — these rows as CSV