PREVIEW / etf_daily / 2008-11-28
file: by_date/etf_daily/2008/2008-11-28.parquet size: 26 KB rows: 595
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-28 | SPY | ETF | 88.63 | 90.13 | 88.48 | 90.09 | 118308100.0 |
| 2008-11-28 | QQQ | ETF | 29.04 | 29.19 | 28.83 | 29.12 | 41242835.0 |
| 2008-11-28 | IWM | ETF | 46.29 | 48.26 | 46.16 | 47.34 | 24156600.0 |
| 2008-11-28 | DIA | ETF | 86.68 | 88.36 | 86.68 | 88.3 | 6958800.0 |
| 2008-11-28 | GLD | ETF | 80.04 | 80.75 | 79.8 | 80.31 | 3658700.0 |
| 2008-11-28 | TLT | ETF | 105.25 | 105.97 | 104.94 | 105.72 | 986400.0 |
| 2008-11-28 | AAXJ | ETF | 30.36 | 30.58 | 30.02 | 30.53 | 87500.0 |
| 2008-11-28 | ACWI | ETF | 30.37 | 30.75 | 30.01 | 30.74 | 188100.0 |
| 2008-11-28 | ACWX | ETF | 28.3 | 28.68 | 27.89 | 28.575 | 76513.0 |
| 2008-11-28 | ADRE | ETF | 25.33 | 25.82 | 25.23 | 25.82 | 95689.0 |
| 2008-11-28 | AFK | ETF | 21.455 | 21.455 | 21.45 | 21.45 | 900.0 |
| 2008-11-28 | AGG | ETF | 98.93 | 99.26 | 98.1 | 98.45 | 294800.0 |
| 2008-11-28 | AIA | ETF | 23.36 | 23.55 | 23.36 | 23.55 | 17330.0 |
| 2008-11-28 | AIQ | ETF | 38.6 | 39.1 | 37.85 | 39.1 | 22371.0 |
| 2008-11-28 | AIS | ETF | 0.38 | 0.38 | 0.3788 | 0.38 | 4100.0 |
| 2008-11-28 | AIVI | ETF | 34.21 | 34.87 | 34.21 | 34.79 | 78900.0 |
| 2008-11-28 | AOA | ETF | 23.1 | 23.1 | 23.1 | 23.1 | 100.0 |
| 2008-11-28 | AOK | ETF | 24.7 | 24.77 | 24.648 | 24.77 | 1800.0 |
| 2008-11-28 | AOM | ETF | 24.0 | 24.68 | 23.78 | 24.68 | 8000.0 |
| 2008-11-28 | AOR | ETF | 26.2 | 27.8 | 26.2 | 27.8 | 450.0 |
| 2008-11-28 | ARB | ETF | 13.28 | 14.23 | 12.85 | 14.03 | 207650.0 |
| 2008-11-28 | BAL | ETF | 27.57 | 27.57 | 27.57 | 27.57 | 200.0 |
| 2008-11-28 | BBH | ETF | 53.6133 | 54.2733 | 53.16 | 54.2733 | 178200.0 |
| 2008-11-28 | BIL | ETF | 91.94 | 91.94 | 91.66 | 91.66 | 39700.0 |
| 2008-11-28 | BITS | ETF | 16.08 | 17.0 | 16.08 | 17.0 | 1100.0 |
| 2008-11-28 | BIV | ETF | 74.58 | 74.95 | 73.84 | 74.76 | 26000.0 |
| 2008-11-28 | BKF | ETF | 23.03 | 23.82 | 20.66 | 23.39 | 174572.0 |
| 2008-11-28 | BLV | ETF | 71.58 | 71.83 | 71.36 | 71.67 | 4000.0 |
| 2008-11-28 | BMVP | ETF | 10.39 | 10.5321 | 10.3267 | 10.5 | 12447.0 |
| 2008-11-28 | BND | ETF | 75.53 | 75.69 | 75.09 | 75.69 | 97200.0 |
| 2008-11-28 | BNE | ETF | 3.0 | 3.56 | 2.96 | 3.56 | 88535.0 |
| 2008-11-28 | BRF | ETF | 14.93 | 14.9401 | 14.93 | 14.9401 | 4500.0 |
| 2008-11-28 | BSV | ETF | 78.29 | 78.35 | 78.01 | 78.35 | 29000.0 |
| 2008-11-28 | BTF | ETF | 44.24999999999999 | 46.8 | 44.2495 | 45.82749999999999 | 40178.8 |
| 2008-11-28 | BWX | ETF | 25.175 | 25.175 | 25.05 | 25.15 | 60148.0 |
| 2008-11-28 | CBON | ETF | 2.25 | 2.45 | 2.16 | 2.16 | 27346.0 |
| 2008-11-28 | CDL | ETF | 0.18 | 0.18 | 0.16 | 0.18 | 602209.0 |
| 2008-11-28 | CEF | ETF | 9.92 | 10.19 | 9.92 | 10.0 | 377600.0 |
| 2008-11-28 | CGO | ETF | 8.45 | 9.02 | 8.4 | 8.4999 | 11458.0 |
| 2008-11-28 | CGW | ETF | 14.12 | 14.54 | 13.94 | 14.29 | 32889.0 |
| 2008-11-28 | CHB | ETF | 0.89 | 0.89 | 0.71 | 0.73 | 340800.0 |
| 2008-11-28 | CHI | ETF | 7.5 | 7.67 | 7.4 | 7.5645 | 66212.0 |
| 2008-11-28 | CHIC | ETF | 4.96 | 5.12 | 4.68 | 5.0 | 187271.0 |
| 2008-11-28 | CHW | ETF | 4.97 | 5.2 | 4.9154 | 5.16 | 65539.0 |
| 2008-11-28 | CHY | ETF | 6.85 | 7.0 | 6.78 | 6.89 | 84166.0 |
| 2008-11-28 | CMF | ETF | 48.375 | 48.375 | 48.152 | 48.152 | 1006.0 |
| 2008-11-28 | CNXT | ETF | 1.05 | 1.13 | 1.0 | 1.02 | 186449.0 |
| 2008-11-28 | COW | ETF | 35.23 | 35.5 | 35.23 | 35.36 | 27972.0 |
| 2008-11-28 | CPI | ETF | 21.5 | 21.5 | 21.5 | 21.5 | 200.0 |
| 2008-11-28 | CPST | ETF | 0.96 | 0.96 | 0.77 | 0.86 | 907813.0 |
> showing 50 of 595 rows — these rows as CSV