PREVIEW / etf_daily / 2006-10-31
file: by_date/etf_daily/2006/2006-10-31.parquet size: 19 KB rows: 376
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-31 | SPY | ETF | 138.07 | 138.26 | 137.25 | 137.79 | 71274100.0 |
| 2006-10-31 | QQQ | ETF | 42.56 | 42.76 | 42.31 | 42.58 | 135825470.0 |
| 2006-10-31 | IWM | ETF | 76.6 | 76.79 | 75.7 | 76.23 | 46092200.0 |
| 2006-10-31 | DIA | ETF | 120.85 | 121.03 | 120.12 | 120.73 | 8360000.0 |
| 2006-10-31 | GLD | ETF | 59.59 | 60.36 | 59.57 | 60.24 | 4603000.0 |
| 2006-10-31 | TLT | ETF | 89.25 | 89.87 | 89.14 | 89.81 | 964600.0 |
| 2006-10-31 | AAA | ETF | 55.84 | 56.03 | 55.75 | 55.75 | 5500.0 |
| 2006-10-31 | ADRE | ETF | 33.95 | 34.46 | 33.95 | 34.38 | 145212.0 |
| 2006-10-31 | AGG | ETF | 100.06 | 100.43 | 100.02 | 100.43 | 189800.0 |
| 2006-10-31 | AIQ | ETF | 42.0 | 42.4 | 41.8 | 42.3 | 19680.0 |
| 2006-10-31 | AIS | ETF | 1.18 | 1.28 | 1.18 | 1.26 | 115600.0 |
| 2006-10-31 | ARB | ETF | 42.32 | 42.5 | 41.75 | 42.0 | 164100.0 |
| 2006-10-31 | BAB | ETF | 87.06 | 87.908 | 87.02 | 87.4 | 39400.0 |
| 2006-10-31 | BBC | ETF | 9.2 | 9.25 | 9.17 | 9.19 | 122300.0 |
| 2006-10-31 | BBH | ETF | 64.2267 | 64.25 | 63.6333 | 63.9133 | 810300.0 |
| 2006-10-31 | BITS | ETF | 37.4 | 37.52 | 34.44 | 34.52 | 109197.0 |
| 2006-10-31 | BNE | ETF | 15.91 | 15.95 | 15.61 | 15.63 | 156700.0 |
| 2006-10-31 | BRF | ETF | 14.24 | 14.31 | 14.23 | 14.26 | 10000.0 |
| 2006-10-31 | BTF | ETF | 103.14999999999999 | 103.75 | 103.14999999999999 | 103.64999999999999 | 5480.0 |
| 2006-10-31 | CBON | ETF | 29.25 | 29.25 | 28.9 | 29.01 | 57149.0 |
| 2006-10-31 | CDL | ETF | 10.31 | 10.4 | 10.14 | 10.24 | 259700.0 |
| 2006-10-31 | CEF | ETF | 8.43 | 8.53 | 8.4 | 8.49 | 723500.0 |
| 2006-10-31 | CEW | ETF | 25.6 | 25.6 | 25.6 | 25.6 | 100.0 |
| 2006-10-31 | CFO | ETF | 10.5 | 10.5 | 10.4 | 10.4 | 3500.0 |
| 2006-10-31 | CGO | ETF | 15.69 | 15.71 | 15.58 | 15.62 | 21800.0 |
| 2006-10-31 | CHB | ETF | 9.78 | 9.78 | 9.07 | 9.26 | 1256900.0 |
| 2006-10-31 | CHI | ETF | 19.68 | 19.77 | 19.68 | 19.73 | 96700.0 |
| 2006-10-31 | CHIC | ETF | 28.88 | 29.0 | 27.4 | 27.65 | 482975.0 |
| 2006-10-31 | CHY | ETF | 17.0 | 17.04 | 16.96 | 16.98 | 109000.0 |
| 2006-10-31 | CIZ | ETF | 22.0999 | 22.6 | 22.0999 | 22.6 | 8600.0 |
| 2006-10-31 | CN | ETF | 35.68 | 35.97 | 35.56 | 35.94 | 28500.0 |
| 2006-10-31 | CNXT | ETF | 1.92 | 1.94 | 1.9 | 1.93 | 8610487.0 |
| 2006-10-31 | COMB | ETF | 9.92 | 9.98 | 9.66 | 9.8 | 16004.0 |
| 2006-10-31 | CPI | ETF | 23.8 | 23.8 | 23.8 | 23.8 | 100.0 |
| 2006-10-31 | CPST | ETF | 1.41 | 1.59 | 1.4 | 1.58 | 1720530.0 |
| 2006-10-31 | CSA | ETF | 22.3 | 22.31 | 20.9 | 22.08 | 428800.0 |
| 2006-10-31 | CSB | ETF | 30.62 | 30.75 | 30.45 | 30.58 | 8300.0 |
| 2006-10-31 | CSQ | ETF | 14.96 | 14.96 | 14.81 | 14.91 | 412600.0 |
| 2006-10-31 | CTEC | ETF | 76.69999999999999 | 77.5 | 75.63749999999999 | 77.35 | 32786.200000000004 |
| 2006-10-31 | CVY | ETF | 26.0 | 26.06 | 25.93 | 26.05 | 23800.0 |
| 2006-10-31 | CYB | ETF | 7.4 | 7.4 | 7.32 | 7.4 | 42400.0 |
| 2006-10-31 | DBC | ETF | 24.25 | 24.26 | 23.95 | 24.19 | 127200.0 |
| 2006-10-31 | DBV | ETF | 25.53 | 25.53 | 25.41 | 25.48 | 39600.0 |
| 2006-10-31 | DDM | ETF | 7.0383 | 7.0433 | 6.9475 | 7.0067 | 687600.0 |
| 2006-10-31 | DES | ETF | 18.8167 | 18.8267 | 18.63 | 18.7133 | 49800.0 |
| 2006-10-31 | DEW | ETF | 58.19 | 58.43 | 58.12 | 58.35 | 10300.0 |
| 2006-10-31 | DFE | ETF | 58.99 | 58.99 | 58.86 | 58.86 | 2100.0 |
| 2006-10-31 | DFJ | ETF | 49.7 | 49.92 | 49.64 | 49.76 | 1800.0 |
| 2006-10-31 | DGT | ETF | 73.6 | 73.76 | 73.15 | 73.47 | 25100.0 |
| 2006-10-31 | DHS | ETF | 56.45 | 56.45 | 56.07 | 56.16 | 21700.0 |
> showing 50 of 376 rows — these rows as CSV