PREVIEW / stock_daily / 2008-11-21
file: by_date/stock_daily/2008/2008-11-21.parquet size: 175 KB rows: 5,841 symbols: 3,506
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-21 | AAPL | Stock | 2.9261 | 3.0043 | 2.8264 | 2.9493 | 1569271200.0 |
| 2008-11-21 | MSFT | Stock | 18.02 | 19.7 | 17.98 | 19.68 | 157231900.0 |
| 2008-11-21 | NVDA | Stock | 0.1522 | 0.1595 | 0.1438 | 0.1595 | 599064000.0 |
| 2008-11-21 | AMZN | Stock | 1.8195 | 1.95 | 1.786 | 1.8935 | 300854000.0 |
| 2008-11-21 | TLT | Stock | 103.25 | 103.98 | 101.45 | 102.92 | 3249297.0 |
| 2008-11-21 | CL | Stock | 30.9 | 31.5 | 29.625 | 31.325 | 13177600.0 |
| 2008-11-21 | A | Stock | 11.8383 | 12.3963 | 11.2876 | 12.3677 | 4383988.0 |
| 2008-11-21 | AABA-DELISTED | Stock | 9.34 | 9.48 | 8.95 | 9.4 | 29668126.0 |
| 2008-11-21 | AACC-DELISTED | Stock | 5.14 | 5.21 | 4.27 | 4.95 | 122534.0 |
| 2008-11-21 | AACG | Stock | 6.02 | 6.3 | 5.98 | 6.3 | 14500.0 |
| 2008-11-21 | AAI-DELISTED | Stock | 3.24 | 3.24 | 2.54 | 2.66 | 4058989.0 |
| 2008-11-21 | AAIC-DELISTED | Stock | 3.6 | 6.8 | 3.4 | 6.6 | 1163275.0 |
| 2008-11-21 | AAME | Stock | 1.19 | 1.2 | 1.19 | 1.2 | 700.0 |
| 2008-11-21 | AAON | Stock | 3.1565 | 3.2652 | 2.9116 | 3.1348 | 912769.0 |
| 2008-11-21 | AAP | Stock | 26.38 | 26.58 | 24.03 | 26.57 | 1646500.0 |
| 2008-11-21 | AATI-DELISTED | Stock | 2.06 | 2.17 | 1.83 | 1.95 | 521364.0 |
| 2008-11-21 | AAU-DELISTED | Stock | 0.33 | 0.4 | 0.33 | 0.39 | 136840.0 |
| 2008-11-21 | AAUAF-DELISTED | Stock | 0.3301 | 0.4 | 0.33 | 0.39 | 139840.0 |
| 2008-11-21 | AAV-DELISTED | Stock | 4.59 | 4.64 | 4.1 | 4.5 | 1481671.0 |
| 2008-11-21 | AAWW-DELISTED | Stock | 9.27 | 10.12 | 9.01 | 9.97 | 514296.0 |
| 2008-11-21 | AAXJ | Stock | 27.28 | 28.5 | 26.2 | 28.5 | 282646.0 |
| 2008-11-21 | AAXN-DELISTED | Stock | 2.79 | 2.98 | 2.54 | 2.69 | 1195327.0 |
| 2008-11-21 | AB | Stock | 12.54 | 13.18 | 11.49 | 13.05 | 721400.0 |
| 2008-11-21 | ABAX-DELISTED | Stock | 12.34 | 12.92 | 11.29 | 12.53 | 368429.0 |
| 2008-11-21 | ABB-DELISTED | Stock | 10.09 | 10.09 | 9.28 | 9.98 | 9873193.0 |
| 2008-11-21 | ABBC-DELISTED | Stock | 9.37 | 9.85 | 9.0 | 9.85 | 100534.0 |
| 2008-11-21 | ABBNY-DELISTED | Stock | 10.09 | 10.09 | 9.28 | 9.95 | 10008608.0 |
| 2008-11-21 | ABC-DELISTED | Stock | 13.77 | 14.91 | 13.33 | 14.84 | 7442202.0 |
| 2008-11-21 | ABCB | Stock | 7.4213 | 9.1818 | 7.3824 | 8.958 | 47088.0 |
| 2008-11-21 | ABCO-DELISTED | Stock | 9.925 | 10.125 | 8.985 | 10.05 | 400450.0 |
| 2008-11-21 | ABCW-DELISTED | Stock | 2.8406 | 3.0495 | 2.3498 | 2.59 | 186890.0 |
| 2008-11-21 | ABD-DELISTED | Stock | 1.0595 | 1.112 | 1.0071 | 1.07 | 880920.0 |
| 2008-11-21 | ABE-DELISTED | Stock | 10.4 | 11.45 | 10.1 | 10.79 | 66476.0 |
| 2008-11-21 | ABEO | Stock | 1250.0 | 1375.0 | 1137.5 | 1375.0 | 19.0 |
| 2008-11-21 | ABFS-DELISTED | Stock | 20.99 | 22.6 | 20.08 | 22.58 | 669954.0 |
| 2008-11-21 | ABG | Stock | 3.56 | 3.73 | 3.2 | 3.65 | 527600.0 |
| 2008-11-21 | ABII-DELISTED | Stock | 51.62 | 52.0 | 46.28 | 48.97 | 31115.0 |
| 2008-11-21 | ABK-DELISTED | Stock | 1.44 | 1.47 | 1.05 | 1.24 | 14100516.0 |
| 2008-11-21 | ABM | Stock | 13.64 | 14.52 | 12.83 | 14.43 | 370200.0 |
| 2008-11-21 | ABMD-DELISTED | Stock | 11.48 | 11.92 | 10.54 | 11.85 | 756654.0 |
| 2008-11-21 | ABR | Stock | 1.89 | 2.15 | 1.77 | 1.86 | 325400.0 |
| 2008-11-21 | ABT | Stock | 24.2923 | 24.8057 | 23.1599 | 24.7193 | 36999166.0 |
| 2008-11-21 | ABTL-DELISTED | Stock | 3.3113 | 3.3113 | 2.4453 | 2.7 | 22181.0 |
| 2008-11-21 | ABV-DELISTED | Stock | 42.56 | 47.64 | 41.48 | 46.33 | 1926784.0 |
| 2008-11-21 | ABVA-DELISTED | Stock | 2.55 | 2.6 | 2.34 | 2.6 | 1586.0 |
| 2008-11-21 | ABX-DELISTED | Stock | 22.17 | 27.3 | 21.71 | 27.17 | 34090464.0 |
| 2008-11-21 | ACAD | Stock | 0.84 | 0.94 | 0.72 | 0.86 | 500100.0 |
| 2008-11-21 | ACAP-DELISTED | Stock | 33.36 | 34.0 | 28.93 | 33.7701 | 170102.0 |
| 2008-11-21 | ACAS-DELISTED | Stock | 4.84 | 4.85 | 3.87 | 4.43 | 5824882.0 |
| 2008-11-21 | ACAT-DELISTED | Stock | 5.07 | 5.3 | 4.56 | 5.2 | 64648.0 |
> showing 50 of 5,841 rows — these rows as CSV