PREVIEW / etf_daily / 2008-10-28
file: by_date/etf_daily/2008/2008-10-28.parquet size: 27 KB rows: 612
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-28 | SPY | ETF | 87.34 | 94.24 | 84.53 | 93.76 | 639939500.0 |
| 2008-10-28 | QQQ | ETF | 29.68 | 31.88 | 28.85 | 31.86 | 327367565.0 |
| 2008-10-28 | IWM | ETF | 45.73 | 48.7 | 44.08 | 48.45 | 114981800.0 |
| 2008-10-28 | DIA | ETF | 83.84 | 91.14 | 81.7 | 91.14 | 53376100.0 |
| 2008-10-28 | GLD | ETF | 73.03 | 73.8 | 71.7 | 73.79 | 8468100.0 |
| 2008-10-28 | TLT | ETF | 96.18 | 96.9 | 95.15 | 95.39 | 1505500.0 |
| 2008-10-28 | AAXJ | ETF | 27.63 | 29.9 | 26.67 | 29.9 | 145500.0 |
| 2008-10-28 | ACWI | ETF | 29.44 | 31.2 | 28.63 | 31.2 | 244600.0 |
| 2008-10-28 | ACWX | ETF | 26.68 | 28.6 | 26.34 | 28.6 | 52736.0 |
| 2008-10-28 | ADRE | ETF | 22.5 | 24.77 | 21.9 | 24.77 | 781008.0 |
| 2008-10-28 | AFK | ETF | 21.99 | 21.99 | 21.76 | 21.7601 | 3304.0 |
| 2008-10-28 | AGG | ETF | 94.7 | 95.24 | 93.75 | 94.58 | 602700.0 |
| 2008-10-28 | AIA | ETF | 22.466 | 24.56 | 22.3 | 24.5 | 68959.0 |
| 2008-10-28 | AIQ | ETF | 34.05 | 34.4 | 31.9 | 34.25 | 45188.0 |
| 2008-10-28 | AIS | ETF | 0.52 | 0.52 | 0.45 | 0.48 | 88800.0 |
| 2008-10-28 | AIVI | ETF | 34.16 | 35.68 | 32.63 | 35.68 | 10800.0 |
| 2008-10-28 | ARB | ETF | 27.31 | 28.55 | 26.08 | 28.5 | 374684.0 |
| 2008-10-28 | BAL | ETF | 29.54 | 29.54 | 29.5 | 29.5 | 600.0 |
| 2008-10-28 | BBH | ETF | 54.12 | 56.2167 | 53.48 | 55.6333 | 1460700.0 |
| 2008-10-28 | BIL | ETF | 91.94 | 92.06 | 91.8 | 91.88 | 186750.0 |
| 2008-10-28 | BITS | ETF | 15.36 | 15.6 | 15.04 | 15.6 | 1370.0 |
| 2008-10-28 | BIV | ETF | 71.02 | 71.53 | 70.62 | 70.69 | 39000.0 |
| 2008-10-28 | BJK | ETF | 15.22 | 15.22 | 13.31 | 15.09 | 8700.0 |
| 2008-10-28 | BKF | ETF | 20.75 | 22.37 | 19.54 | 22.329 | 147905.0 |
| 2008-10-28 | BLV | ETF | 67.32 | 67.4 | 66.5 | 66.77 | 36000.0 |
| 2008-10-28 | BMVP | ETF | 9.72 | 10.5 | 9.69 | 10.5 | 51966.0 |
| 2008-10-28 | BND | ETF | 73.95 | 73.95 | 73.0 | 73.13 | 185900.0 |
| 2008-10-28 | BNE | ETF | 6.07 | 6.88 | 5.79 | 6.86 | 199755.0 |
| 2008-10-28 | BRF | ETF | 14.78 | 14.78 | 14.78 | 14.78 | 2800.0 |
| 2008-10-28 | BSV | ETF | 75.08 | 76.06 | 75.08 | 75.25 | 95700.0 |
| 2008-10-28 | BTF | ETF | 61.9 | 61.9 | 56.699999999999996 | 58.849999999999994 | 46281.0 |
| 2008-10-28 | BWX | ETF | 24.46 | 24.465 | 24.125 | 24.125 | 158590.0 |
| 2008-10-28 | CBON | ETF | 2.5 | 2.71 | 2.38 | 2.38 | 116654.0 |
| 2008-10-28 | CDL | ETF | 0.32 | 0.32 | 0.27 | 0.28 | 547510.0 |
| 2008-10-28 | CEF | ETF | 8.5 | 8.83 | 8.4 | 8.8 | 525200.0 |
| 2008-10-28 | CGO | ETF | 8.89 | 9.29 | 8.77 | 9.21 | 67740.0 |
| 2008-10-28 | CGW | ETF | 13.21 | 14.75 | 13.125 | 14.6 | 227494.0 |
| 2008-10-28 | CHB | ETF | 1.9 | 1.99 | 1.37 | 1.61 | 3437470.0 |
| 2008-10-28 | CHI | ETF | 8.94 | 9.4 | 8.59 | 9.21 | 245740.0 |
| 2008-10-28 | CHIC | ETF | 6.77 | 6.87 | 6.37 | 6.86 | 445977.0 |
| 2008-10-28 | CHW | ETF | 5.78 | 5.79 | 5.25 | 5.63 | 246249.0 |
| 2008-10-28 | CHY | ETF | 8.89 | 8.8999 | 8.22 | 8.7 | 170927.0 |
| 2008-10-28 | CMF | ETF | 49.935 | 49.935 | 48.925 | 49.474 | 4200.0 |
| 2008-10-28 | CNXT | ETF | 1.58 | 1.65 | 1.52 | 1.53 | 514776.0 |
| 2008-10-28 | COW | ETF | 35.95 | 35.95 | 35.27 | 35.74 | 39827.0 |
| 2008-10-28 | CPI | ETF | 23.0 | 23.0 | 23.0 | 23.0 | 100.0 |
| 2008-10-28 | CPST | ETF | 1.23 | 1.24 | 1.11 | 1.18 | 2083483.0 |
| 2008-10-28 | CSA | ETF | 9.81 | 10.07 | 9.02 | 9.9 | 229766.0 |
| 2008-10-28 | CSB | ETF | 14.5 | 15.75 | 14.2 | 15.5 | 47310.0 |
| 2008-10-28 | CSD | ETF | 11.89 | 12.33 | 11.47 | 12.32 | 11500.0 |
> showing 50 of 612 rows — these rows as CSV