PREVIEW / etf_daily / 2006-10-03
file: by_date/etf_daily/2006/2006-10-03.parquet size: 18 KB rows: 365
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-03 | SPY | ETF | 132.89 | 133.87 | 132.65 | 133.36 | 73108100.0 |
| 2006-10-03 | QQQ | ETF | 40.05 | 40.48 | 39.88 | 40.31 | 116292790.0 |
| 2006-10-03 | IWM | ETF | 71.25 | 71.83 | 70.68 | 71.22 | 45911000.0 |
| 2006-10-03 | DIA | ETF | 116.51 | 117.49 | 116.44 | 117.14 | 8935000.0 |
| 2006-10-03 | GLD | ETF | 57.93 | 58.14 | 56.91 | 57.11 | 5233800.0 |
| 2006-10-03 | TLT | ETF | 89.4 | 89.44 | 89.15 | 89.18 | 854900.0 |
| 2006-10-03 | AAA | ETF | 55.58 | 55.58 | 55.34 | 55.34 | 20600.0 |
| 2006-10-03 | ADRE | ETF | 32.1 | 32.22 | 31.8 | 31.8632 | 282624.0 |
| 2006-10-03 | AGG | ETF | 99.89 | 99.9 | 99.61 | 99.82 | 342400.0 |
| 2006-10-03 | AIQ | ETF | 38.1 | 38.3 | 36.75 | 36.85 | 25580.0 |
| 2006-10-03 | AIS | ETF | 1.04 | 1.1 | 1.04 | 1.05 | 91700.0 |
| 2006-10-03 | ARB | ETF | 37.0 | 37.26 | 36.72 | 37.01 | 178800.0 |
| 2006-10-03 | BAB | ETF | 81.43 | 82.83 | 81.39 | 82.6 | 70200.0 |
| 2006-10-03 | BBC | ETF | 8.85 | 9.19 | 8.75 | 9.14 | 272400.0 |
| 2006-10-03 | BBH | ETF | 61.3333 | 61.3333 | 60.71 | 61.0933 | 820200.0 |
| 2006-10-03 | BITS | ETF | 41.0 | 41.4 | 36.4 | 36.92 | 174156.0 |
| 2006-10-03 | BNE | ETF | 14.43 | 14.76 | 14.13 | 14.72 | 228100.0 |
| 2006-10-03 | BRF | ETF | 14.29 | 14.32 | 14.28 | 14.3 | 8200.0 |
| 2006-10-03 | BTF | ETF | 95.8 | 96.19999999999999 | 95.8 | 95.85000000000001 | 2040.0 |
| 2006-10-03 | CBON | ETF | 30.6 | 31.34 | 30.6 | 30.98 | 84615.0 |
| 2006-10-03 | CDL | ETF | 9.44 | 9.88 | 9.34 | 9.8 | 1015600.0 |
| 2006-10-03 | CEF | ETF | 8.0 | 8.19 | 7.97 | 8.07 | 624700.0 |
| 2006-10-03 | CFO | ETF | 9.8 | 9.8 | 9.75 | 9.75 | 11000.0 |
| 2006-10-03 | CGO | ETF | 15.33 | 15.56 | 15.27 | 15.46 | 26200.0 |
| 2006-10-03 | CHB | ETF | 6.93 | 6.98 | 6.75 | 6.88 | 1188400.0 |
| 2006-10-03 | CHI | ETF | 19.58 | 19.59 | 19.4 | 19.4 | 147900.0 |
| 2006-10-03 | CHIC | ETF | 26.6 | 27.44 | 26.12 | 27.28 | 605641.0 |
| 2006-10-03 | CHY | ETF | 16.89 | 16.89 | 16.6 | 16.62 | 181000.0 |
| 2006-10-03 | CIL | ETF | 25.63 | 25.63 | 25.63 | 25.63 | 400.0 |
| 2006-10-03 | CIZ | ETF | 22.55 | 22.55 | 22.55 | 22.55 | 100.0 |
| 2006-10-03 | CN | ETF | 35.6 | 36.12 | 35.46 | 36.02 | 54000.0 |
| 2006-10-03 | CNXT | ETF | 1.915 | 1.92 | 1.78 | 1.8 | 29391058.0 |
| 2006-10-03 | COMB | ETF | 10.0 | 10.0 | 9.95 | 10.0 | 5775.0 |
| 2006-10-03 | CPI | ETF | 23.47 | 23.5 | 23.03 | 23.5 | 5000.0 |
| 2006-10-03 | CPST | ETF | 1.55 | 1.6401 | 1.45 | 1.46 | 3793974.0 |
| 2006-10-03 | CSA | ETF | 21.02 | 21.2401 | 21.02 | 21.2401 | 28200.0 |
| 2006-10-03 | CSB | ETF | 30.12 | 30.45 | 30.0101 | 30.12 | 26300.0 |
| 2006-10-03 | CSQ | ETF | 14.78 | 14.79 | 14.65 | 14.7 | 325000.0 |
| 2006-10-03 | CTEC | ETF | 60.8 | 62.5 | 59.45 | 62.449999999999996 | 7700.0 |
| 2006-10-03 | CVY | ETF | 25.03 | 25.07 | 24.94 | 24.94 | 42900.0 |
| 2006-10-03 | CYB | ETF | 6.74 | 6.74 | 6.69 | 6.71 | 7400.0 |
| 2006-10-03 | DBC | ETF | 23.51 | 23.51 | 23.1796 | 23.3 | 193100.0 |
| 2006-10-03 | DBV | ETF | 25.04 | 25.04 | 24.99 | 25.0 | 19800.0 |
| 2006-10-03 | DDM | ETF | 6.5375 | 6.67 | 6.5375 | 6.635 | 702000.0 |
| 2006-10-03 | DES | ETF | 17.7367 | 17.9567 | 17.7367 | 17.8567 | 23700.0 |
| 2006-10-03 | DEW | ETF | 55.65 | 56.06 | 55.58 | 55.88 | 3800.0 |
| 2006-10-03 | DFE | ETF | 56.02 | 56.38 | 56.02 | 56.24 | 700.0 |
| 2006-10-03 | DFJ | ETF | 50.0 | 50.26 | 49.65 | 50.11 | 8100.0 |
| 2006-10-03 | DGT | ETF | 71.45 | 71.84 | 71.19 | 71.6 | 39600.0 |
| 2006-10-03 | DHS | ETF | 55.0 | 55.4 | 55.0 | 55.21 | 15200.0 |
> showing 50 of 365 rows — these rows as CSV