PREVIEW / etf_daily / 2006-06-14
file: by_date/etf_daily/2006/2006-06-14.parquet size: 17 KB rows: 324
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-06-14 | SPY | ETF | 122.84 | 123.63 | 122.34 | 123.5 | 163566400.0 |
| 2006-06-14 | QQQ | ETF | 37.36 | 37.71 | 37.2 | 37.63 | 201888252.0 |
| 2006-06-14 | IWM | ETF | 66.76 | 67.68 | 66.55 | 67.45 | 106669400.0 |
| 2006-06-14 | DIA | ETF | 107.15 | 108.36 | 106.95 | 108.33 | 10351500.0 |
| 2006-06-14 | GLD | ETF | 56.65 | 56.91 | 55.05 | 55.62 | 12655100.0 |
| 2006-06-14 | TLT | ETF | 85.5 | 85.56 | 84.91 | 84.99 | 1439100.0 |
| 2006-06-14 | AAA | ETF | 55.86 | 55.91 | 55.27 | 55.5 | 11900.0 |
| 2006-06-14 | ADRE | ETF | 107.01 | 111.34 | 107.01 | 111.24 | 229088.0 |
| 2006-06-14 | AFK | ETF | 24.95 | 24.95 | 24.85 | 24.85 | 3500.0 |
| 2006-06-14 | AGG | ETF | 98.2 | 98.25 | 97.85 | 97.98 | 158000.0 |
| 2006-06-14 | AIQ | ETF | 26.75 | 28.45 | 26.75 | 27.05 | 10320.0 |
| 2006-06-14 | AIS | ETF | 1.14 | 1.1899 | 1.09 | 1.17 | 330000.0 |
| 2006-06-14 | AOM | ETF | 6.89 | 6.89 | 6.27 | 6.4 | 130100.0 |
| 2006-06-14 | ARB | ETF | 37.95 | 38.04 | 37.18 | 37.44 | 630500.0 |
| 2006-06-14 | BAB | ETF | 62.46 | 63.15 | 62.01 | 62.51 | 63200.0 |
| 2006-06-14 | BBC | ETF | 8.76 | 9.09 | 8.51 | 9.06 | 128300.0 |
| 2006-06-14 | BBH | ETF | 57.5333 | 57.8067 | 56.8633 | 57.4633 | 1309200.0 |
| 2006-06-14 | BCM | ETF | 69.11 | 69.11 | 67.56 | 68.4 | 36400.0 |
| 2006-06-14 | BITS | ETF | 21.2 | 23.12 | 21.2 | 22.8 | 30246.0 |
| 2006-06-14 | BKF | ETF | 6.35 | 6.65 | 5.91 | 6.2 | 80400.0 |
| 2006-06-14 | BNE | ETF | 13.36 | 13.68 | 13.28 | 13.55 | 143500.0 |
| 2006-06-14 | BRF | ETF | 13.9 | 13.96 | 13.9 | 13.96 | 22100.0 |
| 2006-06-14 | BTF | ETF | 88.75 | 88.75 | 88.49999999999999 | 88.49999999999999 | 560.0 |
| 2006-06-14 | CBON | ETF | 30.37 | 30.5 | 29.97 | 30.22 | 19964.0 |
| 2006-06-14 | CDL | ETF | 8.85 | 9.03 | 8.85 | 8.96 | 340100.0 |
| 2006-06-14 | CEF | ETF | 8.05 | 8.38 | 7.9 | 8.02 | 1601300.0 |
| 2006-06-14 | CFO | ETF | 9.54 | 9.54 | 9.4 | 9.4 | 5700.0 |
| 2006-06-14 | CGO | ETF | 13.99 | 14.0 | 13.73 | 13.78 | 27800.0 |
| 2006-06-14 | CHB | ETF | 9.59 | 9.73 | 9.12 | 9.24 | 2371100.0 |
| 2006-06-14 | CHI | ETF | 18.72 | 18.81 | 18.61 | 18.7 | 191300.0 |
| 2006-06-14 | CHIC | ETF | 18.7 | 19.28 | 18.7 | 19.25 | 279223.0 |
| 2006-06-14 | CHY | ETF | 16.13 | 16.19 | 16.04 | 16.1 | 122700.0 |
| 2006-06-14 | CIL | ETF | 25.09 | 25.09 | 25.0701 | 25.0701 | 400.0 |
| 2006-06-14 | CN | ETF | 31.11 | 31.9 | 31.11 | 31.84 | 38900.0 |
| 2006-06-14 | CNXT | ETF | 2.31 | 2.43 | 2.27 | 2.41 | 13995415.0 |
| 2006-06-14 | COMB | ETF | 9.9 | 9.9 | 9.49 | 9.68 | 20640.0 |
| 2006-06-14 | CPST | ETF | 2.24 | 2.4 | 2.23 | 2.34 | 2243914.0 |
| 2006-06-14 | CSA | ETF | 18.66 | 18.66 | 18.08 | 18.08 | 2000.0 |
| 2006-06-14 | CSB | ETF | 27.06 | 27.19 | 26.78 | 26.92 | 12900.0 |
| 2006-06-14 | CSQ | ETF | 13.6 | 13.62 | 13.53 | 13.6 | 321300.0 |
| 2006-06-14 | CTEC | ETF | 60.65 | 65.5 | 60.3 | 63.849999999999994 | 40497.200000000004 |
| 2006-06-14 | CYB | ETF | 5.48 | 5.5699 | 5.42 | 5.42 | 6000.0 |
| 2006-06-14 | DBC | ETF | 24.05 | 24.25 | 24.0 | 24.04 | 265700.0 |
| 2006-06-14 | DGT | ETF | 64.67 | 64.67 | 64.5 | 64.59 | 4000.0 |
| 2006-06-14 | DIG | ETF | 17.5625 | 17.725 | 17.5625 | 17.725 | 5840.0 |
| 2006-06-14 | DIV | ETF | 11.9 | 11.95 | 11.85 | 11.9 | 18100.0 |
| 2006-06-14 | DJP | ETF | 47.5 | 47.74 | 47.43 | 47.45 | 36200.0 |
| 2006-06-14 | DRIV | ETF | 38.46 | 39.59 | 38.44 | 39.16 | 679101.0 |
| 2006-06-14 | DUSA | ETF | 4.52 | 4.53 | 4.37 | 4.44 | 179847.0 |
| 2006-06-14 | DVY | ETF | 62.2 | 62.32 | 61.48 | 61.96 | 522700.0 |
> showing 50 of 324 rows — these rows as CSV