PREVIEW / etf_daily / 2006-07-11
file: by_date/etf_daily/2006/2006-07-11.parquet size: 18 KB rows: 346
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-07-11 | SPY | ETF | 126.61 | 127.41 | 125.94 | 127.41 | 73640800.0 |
| 2006-07-11 | QQQ | ETF | 37.28 | 37.74 | 37.08 | 37.64 | 136121590.0 |
| 2006-07-11 | IWM | ETF | 70.11 | 71.12 | 69.6 | 71.12 | 63444700.0 |
| 2006-07-11 | DIA | ETF | 110.85 | 111.53 | 110.29 | 111.47 | 5236100.0 |
| 2006-07-11 | GLD | ETF | 62.83 | 63.98 | 62.7 | 63.81 | 5787000.0 |
| 2006-07-11 | TLT | ETF | 84.59 | 84.86 | 84.58 | 84.64 | 423800.0 |
| 2006-07-11 | AAA | ETF | 55.95 | 56.46 | 55.9 | 56.46 | 3500.0 |
| 2006-07-11 | ADRE | ETF | 31.13 | 32.98 | 30.32 | 31.36 | 285570.0 |
| 2006-07-11 | AFK | ETF | 24.89 | 25.1 | 24.89 | 25.1 | 9600.0 |
| 2006-07-11 | AGG | ETF | 97.6 | 97.7 | 97.46 | 97.61 | 204000.0 |
| 2006-07-11 | AIQ | ETF | 31.25 | 32.9 | 31.25 | 32.9 | 16700.0 |
| 2006-07-11 | AIS | ETF | 1.12 | 1.14 | 1.05 | 1.1 | 82500.0 |
| 2006-07-11 | AOM | ETF | 5.8 | 6.0 | 5.8 | 6.0 | 53200.0 |
| 2006-07-11 | ARB | ETF | 38.04 | 38.04 | 36.87 | 37.83 | 224600.0 |
| 2006-07-11 | BAB | ETF | 67.0 | 67.0 | 65.94 | 66.67 | 101700.0 |
| 2006-07-11 | BBC | ETF | 13.1 | 13.4 | 12.4 | 13.38 | 349800.0 |
| 2006-07-11 | BBH | ETF | 59.8333 | 59.98 | 59.2667 | 59.66 | 2361000.0 |
| 2006-07-11 | BITS | ETF | 17.92 | 18.48 | 17.8 | 18.32 | 5285.0 |
| 2006-07-11 | BKF | ETF | 5.98 | 5.98 | 5.65 | 5.79 | 34300.0 |
| 2006-07-11 | BNE | ETF | 13.97 | 14.11 | 13.71 | 14.11 | 165600.0 |
| 2006-07-11 | BRF | ETF | 13.94 | 13.99 | 13.94 | 13.95 | 6200.0 |
| 2006-07-11 | BTF | ETF | 88.64999999999999 | 89.64999999999999 | 88.55 | 89.64999999999999 | 740.0 |
| 2006-07-11 | CBON | ETF | 32.55 | 32.65 | 32.1 | 32.55 | 56907.0 |
| 2006-07-11 | CDL | ETF | 8.93 | 9.05 | 8.87 | 9.03 | 182700.0 |
| 2006-07-11 | CEF | ETF | 8.7 | 8.99 | 8.69 | 8.98 | 428400.0 |
| 2006-07-11 | CFO | ETF | 10.0 | 10.0 | 9.95 | 10.0 | 40500.0 |
| 2006-07-11 | CGO | ETF | 14.8 | 14.8 | 14.51 | 14.55 | 27600.0 |
| 2006-07-11 | CHB | ETF | 10.36 | 10.36 | 9.78 | 10.03 | 1396200.0 |
| 2006-07-11 | CHI | ETF | 19.4 | 19.55 | 19.32 | 19.46 | 61000.0 |
| 2006-07-11 | CHIC | ETF | 22.79 | 23.0 | 22.4 | 22.96 | 327054.0 |
| 2006-07-11 | CHY | ETF | 16.03 | 16.04 | 15.91 | 16.03 | 98300.0 |
| 2006-07-11 | CIL | ETF | 25.12 | 25.12 | 25.12 | 25.12 | 300.0 |
| 2006-07-11 | CN | ETF | 35.8 | 36.18 | 35.05 | 36.11 | 102900.0 |
| 2006-07-11 | CNXT | ETF | 2.09 | 2.23 | 2.02 | 2.22 | 14660206.0 |
| 2006-07-11 | COMB | ETF | 9.89 | 9.92 | 9.89 | 9.9 | 3000.0 |
| 2006-07-11 | CPST | ETF | 2.34 | 2.35 | 2.26 | 2.28 | 1005582.0 |
| 2006-07-11 | CSA | ETF | 19.0 | 19.05 | 18.7 | 18.7 | 7900.0 |
| 2006-07-11 | CSB | ETF | 27.68 | 27.83 | 27.48 | 27.78 | 6200.0 |
| 2006-07-11 | CSQ | ETF | 13.93 | 14.02 | 13.88 | 14.02 | 271900.0 |
| 2006-07-11 | CTEC | ETF | 63.25 | 65.99999999999999 | 62.75 | 64.89999999999999 | 19758.4 |
| 2006-07-11 | CYB | ETF | 6.27 | 6.4 | 6.2001 | 6.21 | 14400.0 |
| 2006-07-11 | DBC | ETF | 25.99 | 26.18 | 25.859 | 26.13 | 232800.0 |
| 2006-07-11 | DDM | ETF | 5.9867 | 6.0367 | 5.9158 | 6.025 | 2047200.0 |
| 2006-07-11 | DES | ETF | 17.1933 | 17.36 | 17.1 | 17.36 | 14400.0 |
| 2006-07-11 | DFJ | ETF | 50.99 | 51.12 | 50.98 | 50.98 | 900.0 |
| 2006-07-11 | DGT | ETF | 67.68 | 67.97 | 67.28 | 67.97 | 4400.0 |
| 2006-07-11 | DHS | ETF | 51.41 | 51.59 | 51.24 | 51.59 | 6600.0 |
| 2006-07-11 | DIM | ETF | 52.7 | 53.04 | 52.51 | 53.04 | 3500.0 |
| 2006-07-11 | DIV | ETF | 12.0 | 12.05 | 11.97 | 12.05 | 30300.0 |
| 2006-07-11 | DJP | ETF | 50.82 | 51.0 | 50.82 | 50.96 | 32700.0 |
> showing 50 of 346 rows — these rows as CSV