PREVIEW / etf_daily / 2006-11-03
file: by_date/etf_daily/2006/2006-11-03.parquet size: 19 KB rows: 382
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-11-03 | SPY | ETF | 137.27 | 137.39 | 135.62 | 136.54 | 71346400.0 |
| 2006-11-03 | QQQ | ETF | 42.1 | 42.19 | 41.61 | 41.93 | 119314198.0 |
| 2006-11-03 | IWM | ETF | 74.82 | 75.24 | 74.21 | 74.83 | 49053800.0 |
| 2006-11-03 | DIA | ETF | 120.46 | 120.62 | 119.6 | 119.78 | 6840900.0 |
| 2006-11-03 | GLD | ETF | 61.81 | 62.5 | 61.65 | 62.3 | 7359200.0 |
| 2006-11-03 | TLT | ETF | 88.67 | 88.84 | 88.3 | 88.53 | 1534100.0 |
| 2006-11-03 | AAA | ETF | 56.5 | 56.5291 | 56.02 | 56.3 | 195300.0 |
| 2006-11-03 | ADRE | ETF | 34.7 | 34.74 | 34.47 | 34.64 | 93087.0 |
| 2006-11-03 | AGG | ETF | 99.66 | 99.7 | 99.38 | 99.55 | 172600.0 |
| 2006-11-03 | AIQ | ETF | 38.85 | 39.7 | 36.8 | 38.6 | 66620.0 |
| 2006-11-03 | AIS | ETF | 1.22 | 1.23 | 1.2 | 1.23 | 122000.0 |
| 2006-11-03 | ARB | ETF | 41.45 | 42.1 | 41.45 | 42.02 | 439700.0 |
| 2006-11-03 | BAB | ETF | 86.75 | 87.1 | 85.42 | 85.79 | 98900.0 |
| 2006-11-03 | BBC | ETF | 9.08 | 9.3 | 9.07 | 9.25 | 100000.0 |
| 2006-11-03 | BBH | ETF | 63.1 | 63.1267 | 62.53 | 62.75 | 732600.0 |
| 2006-11-03 | BITS | ETF | 31.96 | 33.48 | 31.24 | 32.8 | 59898.0 |
| 2006-11-03 | BNE | ETF | 15.44 | 15.47 | 15.1 | 15.3 | 132400.0 |
| 2006-11-03 | BRF | ETF | 14.27 | 14.3 | 14.27 | 14.3 | 6900.0 |
| 2006-11-03 | BTF | ETF | 102.79999999999998 | 102.89999999999999 | 102.6 | 102.89999999999999 | 2780.0 |
| 2006-11-03 | CBON | ETF | 29.12 | 29.2 | 28.93 | 29.19 | 94246.0 |
| 2006-11-03 | CDL | ETF | 10.04 | 10.09 | 9.88 | 9.93 | 206300.0 |
| 2006-11-03 | CEF | ETF | 8.86 | 8.9 | 8.79 | 8.87 | 313100.0 |
| 2006-11-03 | CEW | ETF | 25.46 | 25.46 | 25.46 | 25.46 | 100.0 |
| 2006-11-03 | CFO | ETF | 10.3 | 10.3 | 10.3 | 10.3 | 500.0 |
| 2006-11-03 | CGO | ETF | 15.75 | 15.79 | 15.6 | 15.7 | 24900.0 |
| 2006-11-03 | CHB | ETF | 8.94 | 9.03 | 8.55 | 8.88 | 1102700.0 |
| 2006-11-03 | CHI | ETF | 19.47 | 19.55 | 19.35 | 19.38 | 87500.0 |
| 2006-11-03 | CHIC | ETF | 25.96 | 26.65 | 25.77 | 26.33 | 473542.0 |
| 2006-11-03 | CHY | ETF | 16.81 | 16.95 | 16.71 | 16.78 | 106200.0 |
| 2006-11-03 | CIL | ETF | 25.79 | 25.79 | 25.79 | 25.79 | 300.0 |
| 2006-11-03 | CN | ETF | 35.08 | 35.25 | 34.78 | 34.99 | 44900.0 |
| 2006-11-03 | CNXT | ETF | 1.93 | 1.96 | 1.91 | 1.93 | 7446602.0 |
| 2006-11-03 | COMB | ETF | 9.41 | 9.56 | 9.41 | 9.49 | 4300.0 |
| 2006-11-03 | CPI | ETF | 24.0 | 24.0 | 24.0 | 24.0 | 600.0 |
| 2006-11-03 | CPST | ETF | 1.54 | 1.57 | 1.48 | 1.49 | 907306.0 |
| 2006-11-03 | CSA | ETF | 20.7499 | 20.75 | 20.2501 | 20.35 | 72600.0 |
| 2006-11-03 | CSB | ETF | 30.64 | 30.73 | 30.34 | 30.61 | 4900.0 |
| 2006-11-03 | CSQ | ETF | 14.8 | 14.89 | 14.7801 | 14.85 | 330000.0 |
| 2006-11-03 | CTEC | ETF | 80.25 | 80.95 | 79.74999999999999 | 80.44999999999999 | 26736.2 |
| 2006-11-03 | CVY | ETF | 25.69 | 25.75 | 25.65 | 25.69 | 42700.0 |
| 2006-11-03 | CYB | ETF | 6.5 | 6.71 | 6.45 | 6.65 | 82600.0 |
| 2006-11-03 | DBC | ETF | 24.54 | 24.75 | 24.39 | 24.71 | 195900.0 |
| 2006-11-03 | DBV | ETF | 25.59 | 25.63 | 25.57 | 25.59 | 57800.0 |
| 2006-11-03 | DDM | ETF | 6.9583 | 6.9833 | 6.8833 | 6.9083 | 1119600.0 |
| 2006-11-03 | DES | ETF | 18.45 | 18.4667 | 18.29 | 18.4033 | 54300.0 |
| 2006-11-03 | DEW | ETF | 58.35 | 58.41 | 58.21 | 58.23 | 9700.0 |
| 2006-11-03 | DFE | ETF | 58.78 | 58.93 | 58.72 | 58.81 | 6500.0 |
| 2006-11-03 | DFJ | ETF | 49.74 | 49.74 | 49.58 | 49.64 | 3000.0 |
| 2006-11-03 | DGT | ETF | 73.47 | 73.67 | 73.19 | 73.4 | 6100.0 |
| 2006-11-03 | DHS | ETF | 55.98 | 55.98 | 55.58 | 55.65 | 22700.0 |
> showing 50 of 382 rows — these rows as CSV