PREVIEW / stock_daily / 2008-11-20
file: by_date/stock_daily/2008/2008-11-20.parquet size: 175 KB rows: 5,847 symbols: 3,521
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-11-20 | AAPL | Stock | 3.0443 | 3.0875 | 2.8571 | 2.8746 | 1716814400.0 |
| 2008-11-20 | MSFT | Stock | 18.12 | 18.84 | 17.5 | 17.53 | 139532800.0 |
| 2008-11-20 | NVDA | Stock | 0.1545 | 0.1622 | 0.1458 | 0.1475 | 847036000.0 |
| 2008-11-20 | AMZN | Stock | 1.7645 | 1.986 | 1.734 | 1.7515 | 368478000.0 |
| 2008-11-20 | TLT | Stock | 101.82 | 104.44 | 101.1 | 104.43 | 5459770.0 |
| 2008-11-20 | CL | Stock | 31.16 | 32.06 | 30.02 | 30.25 | 12410800.0 |
| 2008-11-20 | A | Stock | 12.1245 | 12.7468 | 11.5165 | 11.588 | 4679945.0 |
| 2008-11-20 | AABA-DELISTED | Stock | 9.1 | 10.01 | 8.94 | 8.97 | 37225909.0 |
| 2008-11-20 | AACC-DELISTED | Stock | 5.39 | 5.71 | 4.83 | 4.91 | 64647.0 |
| 2008-11-20 | AACG | Stock | 5.52 | 6.47 | 5.52 | 5.67 | 42000.0 |
| 2008-11-20 | AAI-DELISTED | Stock | 3.22 | 3.47 | 3.02 | 3.06 | 2700125.0 |
| 2008-11-20 | AAIC-DELISTED | Stock | 4.8 | 4.8 | 3.0 | 3.4 | 966729.0 |
| 2008-11-20 | AAME | Stock | 1.2 | 1.2 | 0.84 | 0.85 | 3200.0 |
| 2008-11-20 | AAON | Stock | 3.1921 | 3.3343 | 3.0222 | 3.0933 | 642937.0 |
| 2008-11-20 | AAP | Stock | 26.29 | 27.26 | 25.57 | 25.78 | 2484200.0 |
| 2008-11-20 | AATI-DELISTED | Stock | 2.28 | 2.35 | 1.98 | 2.02 | 255195.0 |
| 2008-11-20 | AAU-DELISTED | Stock | 0.39 | 0.42 | 0.33 | 0.39 | 139736.0 |
| 2008-11-20 | AAUAF-DELISTED | Stock | 0.39 | 0.4199 | 0.33 | 0.39 | 141736.0 |
| 2008-11-20 | AAV-DELISTED | Stock | 4.8 | 4.87 | 4.25 | 4.33 | 1605072.0 |
| 2008-11-20 | AAWW-DELISTED | Stock | 11.0 | 11.29 | 8.99 | 9.06 | 500611.0 |
| 2008-11-20 | AAXJ | Stock | 26.57 | 27.48 | 25.14 | 25.382 | 377363.0 |
| 2008-11-20 | AAXN-DELISTED | Stock | 2.79 | 3.03 | 2.64 | 2.68 | 1399006.0 |
| 2008-11-20 | AB | Stock | 13.96 | 14.0 | 11.63 | 11.84 | 913700.0 |
| 2008-11-20 | ABAX-DELISTED | Stock | 12.81 | 13.37 | 11.95 | 12.1 | 224472.0 |
| 2008-11-20 | ABB-DELISTED | Stock | 9.6 | 10.12 | 9.11 | 9.15 | 8800210.0 |
| 2008-11-20 | ABBC-DELISTED | Stock | 9.55 | 9.96 | 9.26 | 9.27 | 49867.0 |
| 2008-11-20 | ABBNY-DELISTED | Stock | 9.6 | 10.12 | 9.11 | 9.12 | 8879404.0 |
| 2008-11-20 | ABC-DELISTED | Stock | 14.74 | 14.88 | 13.64 | 13.74 | 8168040.0 |
| 2008-11-20 | ABCB | Stock | 7.9563 | 8.4814 | 6.8279 | 6.9933 | 37115.0 |
| 2008-11-20 | ABCO-DELISTED | Stock | 9.873 | 10.379 | 9.517 | 9.552 | 253764.0 |
| 2008-11-20 | ABCW-DELISTED | Stock | 2.66 | 2.66 | 2.42 | 2.47 | 152680.0 |
| 2008-11-20 | ABD-DELISTED | Stock | 1.14 | 1.29 | 0.96 | 0.98 | 1264710.0 |
| 2008-11-20 | ABE-DELISTED | Stock | 10.32 | 11.14 | 10.0 | 10.0 | 38854.0 |
| 2008-11-20 | ABEO | Stock | 1375.0 | 1437.5 | 1250.0 | 1437.5 | 16.0 |
| 2008-11-20 | ABFS-DELISTED | Stock | 20.19 | 21.32 | 19.41 | 20.6 | 1019779.0 |
| 2008-11-20 | ABG | Stock | 3.71 | 3.88 | 3.41 | 3.46 | 533200.0 |
| 2008-11-20 | ABII-DELISTED | Stock | 55.22 | 55.22 | 49.0001 | 52.0 | 21064.0 |
| 2008-11-20 | ABK-DELISTED | Stock | 0.97 | 1.49 | 0.9 | 1.26 | 46005865.0 |
| 2008-11-20 | ABM | Stock | 13.7 | 14.4 | 13.4 | 13.42 | 331300.0 |
| 2008-11-20 | ABMD-DELISTED | Stock | 12.23 | 12.79 | 11.27 | 11.31 | 279607.0 |
| 2008-11-20 | ABR | Stock | 2.73 | 2.85 | 1.81 | 2.2 | 677000.0 |
| 2008-11-20 | ABT | Stock | 26.0339 | 26.1059 | 23.7501 | 24.1579 | 35685077.0 |
| 2008-11-20 | ABTL-DELISTED | Stock | 2.553 | 2.8966 | 2.2973 | 2.597 | 21158.0 |
| 2008-11-20 | ABV-DELISTED | Stock | 40.96 | 44.55 | 38.54 | 40.0 | 1276196.0 |
| 2008-11-20 | ABVA-DELISTED | Stock | 2.61 | 2.89 | 2.55 | 2.63 | 400.0 |
| 2008-11-20 | ABX-DELISTED | Stock | 21.2 | 21.75 | 20.04 | 20.66 | 17932417.0 |
| 2008-11-20 | ACAD | Stock | 0.99 | 1.05 | 0.8 | 0.83 | 258200.0 |
| 2008-11-20 | ACAP-DELISTED | Stock | 34.6 | 36.35 | 32.71 | 32.88 | 79336.0 |
| 2008-11-20 | ACAS-DELISTED | Stock | 5.09 | 5.22 | 4.0 | 4.34 | 6904182.0 |
| 2008-11-20 | ACAT-DELISTED | Stock | 5.11 | 5.3548 | 4.77 | 4.85 | 29217.0 |
> showing 50 of 5,847 rows — these rows as CSV