PREVIEW / etf_daily / 2006-10-11
file: by_date/etf_daily/2006/2006-10-11.parquet size: 18 KB rows: 362
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-11 | SPY | ETF | 134.84 | 135.43 | 134.3 | 135.11 | 104071800.0 |
| 2006-10-11 | QQQ | ETF | 41.43 | 41.83 | 41.17 | 41.54 | 136568189.0 |
| 2006-10-11 | IWM | ETF | 73.78 | 74.29 | 73.11 | 73.81 | 52430000.0 |
| 2006-10-11 | DIA | ETF | 118.21 | 118.78 | 117.91 | 118.58 | 8384200.0 |
| 2006-10-11 | GLD | ETF | 57.3 | 57.52 | 56.7 | 56.88 | 2944200.0 |
| 2006-10-11 | TLT | ETF | 87.95 | 88.03 | 87.42 | 87.55 | 1521600.0 |
| 2006-10-11 | AAA | ETF | 54.07 | 54.5 | 54.01 | 54.02 | 4800.0 |
| 2006-10-11 | ADRE | ETF | 33.05 | 33.17 | 32.76 | 32.96 | 138634.0 |
| 2006-10-11 | AGG | ETF | 99.48 | 99.51 | 99.15 | 99.24 | 275600.0 |
| 2006-10-11 | AIQ | ETF | 38.85 | 38.85 | 38.0 | 38.65 | 9840.0 |
| 2006-10-11 | AIS | ETF | 1.14 | 1.17 | 1.12 | 1.14 | 277400.0 |
| 2006-10-11 | ARB | ETF | 38.22 | 38.49 | 38.05 | 38.31 | 184700.0 |
| 2006-10-11 | BAB | ETF | 80.77 | 81.68 | 80.73 | 81.5 | 113600.0 |
| 2006-10-11 | BBC | ETF | 8.68 | 8.9 | 8.4 | 8.5 | 301200.0 |
| 2006-10-11 | BBH | ETF | 62.5833 | 62.6433 | 61.94 | 62.42 | 979800.0 |
| 2006-10-11 | BITS | ETF | 36.08 | 36.32 | 34.6 | 35.0 | 22750.0 |
| 2006-10-11 | BNE | ETF | 14.95 | 15.09 | 14.76 | 14.96 | 139300.0 |
| 2006-10-11 | BRF | ETF | 14.21 | 14.238 | 14.2 | 14.22 | 29700.0 |
| 2006-10-11 | BTF | ETF | 98.49999999999999 | 98.64999999999999 | 98.35000000000001 | 98.55 | 2120.0 |
| 2006-10-11 | CBON | ETF | 31.74 | 31.86 | 31.53 | 31.68 | 19176.0 |
| 2006-10-11 | CDL | ETF | 9.6 | 9.6 | 9.38 | 9.46 | 372300.0 |
| 2006-10-11 | CEF | ETF | 8.07 | 8.17 | 8.05 | 8.06 | 169800.0 |
| 2006-10-11 | CFO | ETF | 9.76 | 9.76 | 9.76 | 9.76 | 3300.0 |
| 2006-10-11 | CGO | ETF | 15.53 | 15.9 | 15.5 | 15.7 | 32100.0 |
| 2006-10-11 | CHB | ETF | 7.61 | 7.76 | 7.48 | 7.58 | 1400300.0 |
| 2006-10-11 | CHI | ETF | 19.3 | 19.3015 | 19.22 | 19.27 | 96300.0 |
| 2006-10-11 | CHIC | ETF | 27.39 | 27.39 | 26.84 | 27.13 | 314675.0 |
| 2006-10-11 | CHY | ETF | 16.92 | 16.92 | 16.81 | 16.81 | 117100.0 |
| 2006-10-11 | CN | ETF | 35.55 | 35.84 | 35.29 | 35.66 | 40700.0 |
| 2006-10-11 | CNXT | ETF | 1.81 | 1.88 | 1.81 | 1.85 | 11095205.0 |
| 2006-10-11 | COMB | ETF | 10.11 | 10.11 | 10.1 | 10.1 | 200.0 |
| 2006-10-11 | CPI | ETF | 23.49 | 24.7 | 23.45 | 24.7 | 10400.0 |
| 2006-10-11 | CPST | ETF | 1.54 | 1.57 | 1.52 | 1.52 | 853754.0 |
| 2006-10-11 | CSA | ETF | 21.72 | 21.73 | 21.72 | 21.72 | 4100.0 |
| 2006-10-11 | CSB | ETF | 29.84 | 30.16 | 29.79 | 29.94 | 11100.0 |
| 2006-10-11 | CSQ | ETF | 14.75 | 14.79 | 14.71 | 14.79 | 354400.0 |
| 2006-10-11 | CTEC | ETF | 62.449999999999996 | 62.5 | 62.05 | 62.24999999999999 | 5508.6 |
| 2006-10-11 | CVY | ETF | 25.35 | 25.36 | 25.26 | 25.26 | 18300.0 |
| 2006-10-11 | CYB | ETF | 7.13 | 7.26 | 7.13 | 7.16 | 93400.0 |
| 2006-10-11 | DBC | ETF | 23.5 | 23.75 | 23.3 | 23.38 | 424000.0 |
| 2006-10-11 | DBV | ETF | 25.49 | 25.5 | 25.4 | 25.45 | 31700.0 |
| 2006-10-11 | DDM | ETF | 6.7392 | 6.7983 | 6.7067 | 6.7692 | 474000.0 |
| 2006-10-11 | DES | ETF | 18.19 | 18.26 | 18.1167 | 18.1533 | 31800.0 |
| 2006-10-11 | DEW | ETF | 56.1 | 56.48 | 56.0 | 56.14 | 3900.0 |
| 2006-10-11 | DFE | ETF | 56.23 | 56.56 | 56.23 | 56.42 | 700.0 |
| 2006-10-11 | DFJ | ETF | 47.77 | 48.06 | 47.7 | 47.8 | 14700.0 |
| 2006-10-11 | DGT | ETF | 72.1 | 72.23 | 71.88 | 72.0 | 119600.0 |
| 2006-10-11 | DHS | ETF | 55.3 | 55.46 | 55.15 | 55.39 | 25000.0 |
| 2006-10-11 | DIM | ETF | 56.7 | 56.99 | 56.48 | 56.75 | 9200.0 |
| 2006-10-11 | DIV | ETF | 12.7 | 12.75 | 12.67 | 12.74 | 29600.0 |
> showing 50 of 362 rows — these rows as CSV