PREVIEW / stock_daily / 2008-07-17
file: by_date/stock_daily/2008/2008-07-17.parquet size: 184 KB rows: 5,755 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-07-17 | AAPL | Stock | 6.2179 | 6.2493 | 6.1211 | 6.1361 | 757526000.0 |
| 2008-07-17 | MSFT | Stock | 27.58 | 27.91 | 27.11 | 27.52 | 96526100.0 |
| 2008-07-17 | NVDA | Stock | 0.2875 | 0.2875 | 0.273 | 0.284 | 862080000.0 |
| 2008-07-17 | AMZN | Stock | 3.56 | 3.619 | 3.387 | 3.6055 | 191948000.0 |
| 2008-07-17 | TLT | Stock | 91.26 | 91.61 | 90.56 | 90.79 | 5899839.0 |
| 2008-07-17 | CL | Stock | 34.665 | 35.035 | 34.0 | 34.85 | 7107600.0 |
| 2008-07-17 | A | Stock | 24.6066 | 25.2575 | 24.6066 | 25.1359 | 4302625.0 |
| 2008-07-17 | AABA-DELISTED | Stock | 23.49 | 23.49 | 22.41 | 22.44 | 31126667.0 |
| 2008-07-17 | AACC-DELISTED | Stock | 10.4 | 11.07 | 10.29 | 11.0 | 233672.0 |
| 2008-07-17 | AACG | Stock | 12.0 | 12.1 | 12.0 | 12.03 | 1400.0 |
| 2008-07-17 | AAI-DELISTED | Stock | 1.75 | 1.97 | 1.57 | 1.97 | 4602433.0 |
| 2008-07-17 | AAIC-DELISTED | Stock | 34.8 | 39.8 | 34.8 | 39.2 | 741103.0 |
| 2008-07-17 | AAME | Stock | 1.6 | 1.65 | 1.6 | 1.65 | 5600.0 |
| 2008-07-17 | AAON | Stock | 3.441 | 3.5931 | 3.356 | 3.4232 | 376650.0 |
| 2008-07-17 | AAP | Stock | 39.65 | 40.91 | 38.42 | 40.81 | 1507700.0 |
| 2008-07-17 | AATI-DELISTED | Stock | 4.55 | 4.68 | 4.46 | 4.65 | 262688.0 |
| 2008-07-17 | AAU-DELISTED | Stock | 2.23 | 2.23 | 2.04 | 2.05 | 77560.0 |
| 2008-07-17 | AAUAF-DELISTED | Stock | 2.23 | 2.23 | 2.04 | 2.0501 | 80560.0 |
| 2008-07-17 | AAV-DELISTED | Stock | 11.77 | 12.08 | 11.08 | 11.34 | 969277.0 |
| 2008-07-17 | AAWW-DELISTED | Stock | 49.49 | 49.49 | 48.15 | 49.04 | 326822.0 |
| 2008-07-17 | AAXN-DELISTED | Stock | 5.97 | 5.99 | 5.62 | 5.74 | 974487.0 |
| 2008-07-17 | AB | Stock | 49.33 | 52.07 | 47.75 | 51.63 | 1005800.0 |
| 2008-07-17 | ABAX-DELISTED | Stock | 23.15 | 23.44 | 22.71 | 22.95 | 328671.0 |
| 2008-07-17 | ABB-DELISTED | Stock | 28.2 | 28.46 | 27.92 | 28.16 | 4443068.0 |
| 2008-07-17 | ABBC-DELISTED | Stock | 9.22 | 9.3 | 9.1 | 9.29 | 180280.0 |
| 2008-07-17 | ABBNY-DELISTED | Stock | 28.2 | 28.4578 | 27.92 | 28.16 | 4534093.0 |
| 2008-07-17 | ABC-DELISTED | Stock | 19.2 | 19.26 | 18.83 | 19.06 | 3101016.0 |
| 2008-07-17 | ABCB | Stock | 8.6954 | 9.4833 | 8.3453 | 8.7732 | 108467.0 |
| 2008-07-17 | ABCO-DELISTED | Stock | 18.26 | 18.69 | 17.94 | 18.66 | 283330.0 |
| 2008-07-17 | ABCW-DELISTED | Stock | 6.48 | 7.7 | 6.48 | 7.64 | 412180.0 |
| 2008-07-17 | ABD-DELISTED | Stock | 7.93 | 8.04 | 7.74 | 7.95 | 2006540.0 |
| 2008-07-17 | ABE-DELISTED | Stock | 20.16 | 20.302 | 19.95 | 20.14 | 20060.0 |
| 2008-07-17 | ABEO | Stock | 3312.5 | 3500.0 | 3312.5 | 3500.0 | 16.0 |
| 2008-07-17 | ABFS-DELISTED | Stock | 39.57 | 42.48 | 39.23 | 42.1 | 1503808.0 |
| 2008-07-17 | ABG | Stock | 11.12 | 11.91 | 10.84 | 11.82 | 613400.0 |
| 2008-07-17 | ABII-DELISTED | Stock | 66.11 | 72.0 | 62.18 | 72.0 | 17474.0 |
| 2008-07-17 | ABK-DELISTED | Stock | 2.25 | 2.3 | 2.01 | 2.15 | 22096750.0 |
| 2008-07-17 | ABM | Stock | 22.52 | 22.69 | 21.83 | 22.64 | 237000.0 |
| 2008-07-17 | ABMD-DELISTED | Stock | 18.75 | 19.1 | 18.69 | 18.9 | 197377.0 |
| 2008-07-17 | ABP-DELISTED | Stock | 4.38 | 4.43 | 4.1 | 4.15 | 485873.0 |
| 2008-07-17 | ABR | Stock | 8.62 | 9.22 | 8.5 | 9.01 | 233800.0 |
| 2008-07-17 | ABT | Stock | 27.3966 | 27.8188 | 26.4274 | 27.5885 | 20353689.0 |
| 2008-07-17 | ABTL-DELISTED | Stock | 5.3932 | 6.2664 | 5.3418 | 5.65 | 22442.0 |
| 2008-07-17 | ABV-DELISTED | Stock | 62.79 | 63.61 | 61.79 | 61.99 | 1009623.0 |
| 2008-07-17 | ABVA-DELISTED | Stock | 3.68 | 3.68 | 3.68 | 3.68 | 400.0 |
| 2008-07-17 | ABX-DELISTED | Stock | 47.94 | 49.43 | 46.8 | 47.41 | 10725901.0 |
| 2008-07-17 | ACAD | Stock | 3.45 | 3.72 | 3.45 | 3.72 | 497500.0 |
| 2008-07-17 | ACAP-DELISTED | Stock | 42.35 | 42.88 | 41.6 | 42.88 | 109736.0 |
| 2008-07-17 | ACAS-DELISTED | Stock | 21.08 | 22.0 | 19.76 | 21.56 | 6213981.0 |
| 2008-07-17 | ACAT-DELISTED | Stock | 6.52 | 7.76 | 6.52 | 7.76 | 316728.0 |
> showing 50 of 5,755 rows — these rows as CSV