PREVIEW / etf_daily / 2006-07-19
file: by_date/etf_daily/2006/2006-07-19.parquet size: 18 KB rows: 357
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-19 | SPY | ETF | 124.18 | 126.26 | 123.72 | 125.69 | 133565300.0 |
| 2006-07-19 | QQQ | ETF | 36.1 | 36.83 | 36.09 | 36.62 | 193014681.0 |
| 2006-07-19 | IWM | ETF | 67.84 | 70.0 | 67.78 | 69.5 | 97816700.0 |
| 2006-07-19 | DIA | ETF | 108.44 | 110.44 | 108.1 | 110.04 | 11503300.0 |
| 2006-07-19 | GLD | ETF | 62.57 | 64.24 | 62.48 | 64.03 | 7261300.0 |
| 2006-07-19 | TLT | ETF | 84.33 | 85.3 | 84.24 | 85.24 | 1267400.0 |
| 2006-07-19 | AAA | ETF | 53.14 | 54.74 | 53.14 | 54.67 | 9000.0 |
| 2006-07-19 | ADRE | ETF | 29.84 | 31.1599 | 29.81 | 31.15 | 1395167.0 |
| 2006-07-19 | AFK | ETF | 25.0 | 25.0 | 24.94 | 24.94 | 5100.0 |
| 2006-07-19 | AGG | ETF | 97.47 | 97.98 | 97.41 | 97.98 | 121400.0 |
| 2006-07-19 | AIQ | ETF | 30.75 | 32.35 | 30.5 | 31.6 | 25960.0 |
| 2006-07-19 | AIS | ETF | 1.14 | 1.28 | 1.05 | 1.24 | 563600.0 |
| 2006-07-19 | AOM | ETF | 6.39 | 6.5 | 6.39 | 6.5 | 8300.0 |
| 2006-07-19 | ARB | ETF | 36.63 | 37.55 | 36.63 | 37.05 | 210100.0 |
| 2006-07-19 | BAB | ETF | 64.23 | 66.08 | 64.15 | 65.7 | 56100.0 |
| 2006-07-19 | BBC | ETF | 12.02 | 12.64 | 12.02 | 12.45 | 201200.0 |
| 2006-07-19 | BBH | ETF | 56.8667 | 58.0567 | 56.8667 | 57.6167 | 1553100.0 |
| 2006-07-19 | BITS | ETF | 17.84 | 19.56 | 17.84 | 18.36 | 17726.0 |
| 2006-07-19 | BKF | ETF | 5.55 | 5.555 | 5.36 | 5.43 | 28700.0 |
| 2006-07-19 | BNE | ETF | 13.32 | 13.62 | 13.32 | 13.5 | 184400.0 |
| 2006-07-19 | BRF | ETF | 13.9 | 13.97 | 13.88 | 13.97 | 7200.0 |
| 2006-07-19 | BTF | ETF | 86.44999999999999 | 87.39999999999999 | 86.44999999999999 | 87.05 | 10040.0 |
| 2006-07-19 | CBON | ETF | 31.0 | 32.52 | 30.91 | 32.25 | 75105.0 |
| 2006-07-19 | CDL | ETF | 8.94 | 9.13 | 8.91 | 9.13 | 268400.0 |
| 2006-07-19 | CEF | ETF | 8.88 | 9.11 | 8.8 | 8.97 | 531900.0 |
| 2006-07-19 | CEW | ETF | 25.8 | 25.92 | 25.8 | 25.85 | 19100.0 |
| 2006-07-19 | CFO | ETF | 9.9 | 9.98 | 9.9 | 9.9 | 6000.0 |
| 2006-07-19 | CGO | ETF | 14.57 | 14.64 | 14.39 | 14.52 | 24100.0 |
| 2006-07-19 | CHB | ETF | 8.55 | 9.01 | 8.51 | 8.89 | 1852200.0 |
| 2006-07-19 | CHI | ETF | 19.42 | 19.54 | 19.42 | 19.49 | 70800.0 |
| 2006-07-19 | CHIC | ETF | 23.11 | 23.42 | 22.4 | 22.51 | 658707.0 |
| 2006-07-19 | CHY | ETF | 15.92 | 16.05 | 15.91 | 16.04 | 101300.0 |
| 2006-07-19 | CIL | ETF | 25.2 | 25.23 | 25.15 | 25.23 | 4300.0 |
| 2006-07-19 | CN | ETF | 34.6 | 35.99 | 34.56 | 35.93 | 72200.0 |
| 2006-07-19 | CNXT | ETF | 2.05 | 2.16 | 2.03 | 2.13 | 10741666.0 |
| 2006-07-19 | COMB | ETF | 9.85 | 9.9 | 9.76 | 9.8 | 19223.0 |
| 2006-07-19 | CPST | ETF | 1.94 | 2.13 | 1.92 | 2.09 | 1178589.0 |
| 2006-07-19 | CSA | ETF | 18.85 | 18.85 | 18.32 | 18.7 | 6700.0 |
| 2006-07-19 | CSB | ETF | 26.6 | 27.2 | 26.54 | 27.13 | 23100.0 |
| 2006-07-19 | CSQ | ETF | 13.93 | 14.0 | 13.9 | 14.0 | 285400.0 |
| 2006-07-19 | CTEC | ETF | 58.849999999999994 | 59.74999999999999 | 57.8 | 58.6 | 15174.6 |
| 2006-07-19 | CYB | ETF | 5.8401 | 5.94 | 5.8401 | 5.85 | 24900.0 |
| 2006-07-19 | DBC | ETF | 25.67 | 25.83 | 25.25 | 25.83 | 236400.0 |
| 2006-07-19 | DDM | ETF | 5.7417 | 5.9058 | 5.715 | 5.8725 | 2227200.0 |
| 2006-07-19 | DES | ETF | 16.9667 | 17.3167 | 16.9667 | 17.3167 | 265500.0 |
| 2006-07-19 | DEW | ETF | 50.99 | 51.07 | 50.99 | 51.03 | 4400.0 |
| 2006-07-19 | DFE | ETF | 51.24 | 51.24 | 51.24 | 51.24 | 100.0 |
| 2006-07-19 | DFJ | ETF | 47.68 | 48.19 | 47.68 | 48.19 | 500.0 |
| 2006-07-19 | DGT | ETF | 65.75 | 66.93 | 65.75 | 66.74 | 1200.0 |
| 2006-07-19 | DHS | ETF | 51.4 | 51.63 | 51.4 | 51.62 | 9700.0 |
> showing 50 of 357 rows — these rows as CSV