PREVIEW / stock_daily / 2008-10-21
file: by_date/stock_daily/2008/2008-10-21.parquet size: 178 KB rows: 5,771 symbols: 3,473
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-21 | AAPL | Stock | 3.4625 | 3.4964 | 3.2557 | 3.2675 | 2193660000.0 |
| 2008-10-21 | MSFT | Stock | 24.3 | 25.01 | 23.27 | 23.36 | 100385600.0 |
| 2008-10-21 | NVDA | Stock | 0.1913 | 0.1933 | 0.179 | 0.18 | 659116000.0 |
| 2008-10-21 | AMZN | Stock | 2.593 | 2.6475 | 2.496 | 2.5115 | 173392000.0 |
| 2008-10-21 | TLT | Stock | 95.09 | 95.99 | 94.74 | 95.12 | 1243652.0 |
| 2008-10-21 | CL | Stock | 31.87 | 32.49 | 31.255 | 31.44 | 5335800.0 |
| 2008-10-21 | A | Stock | 16.7525 | 17.1245 | 16.1803 | 16.2589 | 3114325.0 |
| 2008-10-21 | AABA-DELISTED | Stock | 12.62 | 12.74 | 12.04 | 12.06 | 28279616.0 |
| 2008-10-21 | AACC-DELISTED | Stock | 9.44 | 9.44 | 8.63 | 9.04 | 134890.0 |
| 2008-10-21 | AACG | Stock | 8.69 | 8.98 | 8.57 | 8.98 | 2900.0 |
| 2008-10-21 | AAI-DELISTED | Stock | 3.2 | 3.32 | 3.0 | 3.09 | 2373920.0 |
| 2008-10-21 | AAIC-DELISTED | Stock | 11.0 | 12.2 | 11.0 | 11.8 | 486537.0 |
| 2008-10-21 | AAME | Stock | 1.0 | 1.16 | 1.0 | 1.16 | 5700.0 |
| 2008-10-21 | AAON | Stock | 3.0775 | 3.1052 | 2.9649 | 2.9867 | 127069.0 |
| 2008-10-21 | AAP | Stock | 29.76 | 30.13 | 28.89 | 29.0 | 1363200.0 |
| 2008-10-21 | AATI-DELISTED | Stock | 3.33 | 3.45 | 3.19 | 3.29 | 230364.0 |
| 2008-10-21 | AAU-DELISTED | Stock | 0.61 | 0.65 | 0.58 | 0.6 | 46760.0 |
| 2008-10-21 | AAUAF-DELISTED | Stock | 0.61 | 0.65 | 0.58 | 0.6 | 48986.0 |
| 2008-10-21 | AAV-DELISTED | Stock | 6.73 | 6.82 | 6.52 | 6.61 | 925071.0 |
| 2008-10-21 | AAWW-DELISTED | Stock | 28.84 | 30.23 | 28.24 | 29.01 | 251437.0 |
| 2008-10-21 | AAXJ | Stock | 33.9 | 33.9 | 32.67 | 32.67 | 130967.0 |
| 2008-10-21 | AAXN-DELISTED | Stock | 4.99 | 5.07 | 4.78 | 4.86 | 291347.0 |
| 2008-10-21 | AB | Stock | 23.64 | 24.82 | 22.74 | 22.85 | 596800.0 |
| 2008-10-21 | ABAX-DELISTED | Stock | 14.45 | 15.03 | 13.76 | 13.98 | 239279.0 |
| 2008-10-21 | ABB-DELISTED | Stock | 15.71 | 16.13 | 15.3 | 15.52 | 5759357.0 |
| 2008-10-21 | ABBC-DELISTED | Stock | 9.85 | 10.03 | 9.6 | 9.77 | 53754.0 |
| 2008-10-21 | ABBNY-DELISTED | Stock | 15.71 | 16.13 | 15.3 | 15.52 | 6674292.0 |
| 2008-10-21 | ABC-DELISTED | Stock | 16.18 | 16.94 | 15.96 | 16.44 | 3854466.0 |
| 2008-10-21 | ABCB | Stock | 11.7204 | 11.7204 | 9.8821 | 10.1739 | 32797.0 |
| 2008-10-21 | ABCO-DELISTED | Stock | 11.998 | 12.742 | 11.973 | 12.207 | 374188.0 |
| 2008-10-21 | ABCW-DELISTED | Stock | 5.86 | 6.07 | 5.5 | 5.77 | 139140.0 |
| 2008-10-21 | ABD-DELISTED | Stock | 3.9298 | 4.0595 | 3.7403 | 3.7702 | 444930.0 |
| 2008-10-21 | ABE-DELISTED | Stock | 15.05 | 15.05 | 13.25 | 13.5 | 15873.0 |
| 2008-10-21 | ABEO | Stock | 2937.5 | 2937.5 | 2850.0 | 2850.0 | 6.0 |
| 2008-10-21 | ABFS-DELISTED | Stock | 30.01 | 30.23 | 28.98 | 29.45 | 895577.0 |
| 2008-10-21 | ABG | Stock | 3.76 | 3.81 | 3.25 | 3.35 | 540200.0 |
| 2008-10-21 | ABII-DELISTED | Stock | 63.61 | 65.5 | 62.165 | 65.0 | 10774.0 |
| 2008-10-21 | ABK-DELISTED | Stock | 3.09 | 3.43 | 2.95 | 3.0 | 20011999.0 |
| 2008-10-21 | ABM | Stock | 14.88 | 15.45 | 14.63 | 15.2 | 416100.0 |
| 2008-10-21 | ABMD-DELISTED | Stock | 13.41 | 13.88 | 13.1 | 13.18 | 291856.0 |
| 2008-10-21 | ABR | Stock | 5.2 | 5.3 | 4.9 | 4.99 | 167600.0 |
| 2008-10-21 | ABT | Stock | 27.6941 | 27.7564 | 26.7584 | 26.864 | 16692580.0 |
| 2008-10-21 | ABTL-DELISTED | Stock | 2.65 | 2.75 | 2.45 | 2.6 | 85371.0 |
| 2008-10-21 | ABV-DELISTED | Stock | 47.03 | 48.41 | 44.97 | 45.21 | 1005986.0 |
| 2008-10-21 | ABVA-DELISTED | Stock | 3.72 | 3.75 | 3.72 | 3.75 | 300.0 |
| 2008-10-21 | ABVT-DELISTED | Stock | 54.0 | 54.0 | 54.0 | 54.0 | 1478.0 |
| 2008-10-21 | ABX-DELISTED | Stock | 25.27 | 25.37 | 23.55 | 23.66 | 13048894.0 |
| 2008-10-21 | ACAD | Stock | 1.97 | 2.0 | 1.78 | 1.79 | 79700.0 |
| 2008-10-21 | ACAP-DELISTED | Stock | 38.69 | 40.32 | 38.5075 | 39.22 | 79162.0 |
| 2008-10-21 | ACAS-DELISTED | Stock | 15.19 | 15.95 | 15.0 | 15.04 | 1895581.0 |
> showing 50 of 5,771 rows — these rows as CSV