PREVIEW / etf_daily / 2006-06-28
file: by_date/etf_daily/2006/2006-06-28.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-06-28 | SPY | ETF | 124.19 | 124.77 | 123.65 | 124.75 | 62368100.0 |
| 2006-06-28 | QQQ | ETF | 37.63 | 37.84 | 37.38 | 37.81 | 91578394.0 |
| 2006-06-28 | IWM | ETF | 68.35 | 68.6 | 67.5 | 68.6 | 46405900.0 |
| 2006-06-28 | DIA | ETF | 109.44 | 109.84 | 108.97 | 109.82 | 3983900.0 |
| 2006-06-28 | GLD | ETF | 58.15 | 58.19 | 57.35 | 57.54 | 2898900.0 |
| 2006-06-28 | TLT | ETF | 83.63 | 83.63 | 83.19 | 83.23 | 381300.0 |
| 2006-06-28 | AAA | ETF | 54.01 | 54.35 | 53.95 | 54.25 | 7400.0 |
| 2006-06-28 | ADRE | ETF | 116.5 | 117.9 | 116.47 | 117.8999 | 62932.0 |
| 2006-06-28 | AFK | ETF | 24.84 | 24.85 | 24.78 | 24.8 | 90700.0 |
| 2006-06-28 | AGG | ETF | 97.36 | 97.36 | 97.1 | 97.11 | 108000.0 |
| 2006-06-28 | AIQ | ETF | 30.4 | 31.15 | 30.1 | 30.5 | 16540.0 |
| 2006-06-28 | AIS | ETF | 1.2 | 1.2 | 1.1 | 1.14 | 97500.0 |
| 2006-06-28 | AOM | ETF | 6.12 | 6.12 | 6.03 | 6.0999 | 6600.0 |
| 2006-06-28 | ARB | ETF | 36.9 | 37.59 | 36.65 | 37.51 | 287500.0 |
| 2006-06-28 | BAB | ETF | 60.87 | 61.27 | 60.61 | 61.1 | 36800.0 |
| 2006-06-28 | BBC | ETF | 14.06 | 14.15 | 13.6 | 13.81 | 359300.0 |
| 2006-06-28 | BBH | ETF | 56.7667 | 56.9433 | 56.0667 | 56.6867 | 1660800.0 |
| 2006-06-28 | BCM | ETF | 66.1 | 66.12 | 65.27 | 65.86 | 42900.0 |
| 2006-06-28 | BITS | ETF | 18.04 | 19.16 | 17.8 | 18.72 | 29566.0 |
| 2006-06-28 | BKF | ETF | 6.2 | 6.2 | 5.91 | 5.96 | 57000.0 |
| 2006-06-28 | BNE | ETF | 13.38 | 13.56 | 13.1 | 13.29 | 136500.0 |
| 2006-06-28 | BRF | ETF | 14.0 | 14.01 | 13.94 | 13.97 | 8300.0 |
| 2006-06-28 | BTF | ETF | 88.39999999999999 | 88.49999999999999 | 88.3505 | 88.49999999999999 | 1380.0 |
| 2006-06-28 | CBON | ETF | 30.27 | 30.42 | 30.08 | 30.25 | 13622.0 |
| 2006-06-28 | CDL | ETF | 8.77 | 8.92 | 8.74 | 8.81 | 301600.0 |
| 2006-06-28 | CEF | ETF | 8.22 | 8.28 | 8.19 | 8.23 | 311100.0 |
| 2006-06-28 | CFO | ETF | 9.8 | 9.8 | 9.8 | 9.8 | 200.0 |
| 2006-06-28 | CGO | ETF | 14.22 | 14.2944 | 14.22 | 14.27 | 15100.0 |
| 2006-06-28 | CHB | ETF | 10.67 | 10.68 | 10.4 | 10.51 | 873100.0 |
| 2006-06-28 | CHI | ETF | 18.88 | 19.02 | 18.85 | 19.0 | 71800.0 |
| 2006-06-28 | CHIC | ETF | 21.29 | 21.45 | 20.76 | 21.08 | 289181.0 |
| 2006-06-28 | CHY | ETF | 15.95 | 16.02 | 15.88 | 15.94 | 128600.0 |
| 2006-06-28 | CIL | ETF | 25.14 | 25.17 | 25.14 | 25.14 | 1500.0 |
| 2006-06-28 | CIZ | ETF | 22.25 | 22.25 | 22.25 | 22.25 | 300.0 |
| 2006-06-28 | CN | ETF | 33.93 | 34.02 | 33.74 | 34.02 | 30900.0 |
| 2006-06-28 | CNXT | ETF | 2.23 | 2.29 | 2.14 | 2.21 | 14454505.0 |
| 2006-06-28 | COMB | ETF | 9.85 | 9.9 | 9.7 | 9.9 | 5600.0 |
| 2006-06-28 | CPI | ETF | 29.5 | 29.75 | 29.5 | 29.75 | 3100.0 |
| 2006-06-28 | CPST | ETF | 2.4 | 2.42 | 2.25 | 2.32 | 2527561.0 |
| 2006-06-28 | CSA | ETF | 19.86 | 19.9676 | 19.77 | 19.85 | 8300.0 |
| 2006-06-28 | CSB | ETF | 26.81 | 26.92 | 26.7 | 26.9 | 17900.0 |
| 2006-06-28 | CSQ | ETF | 13.87 | 13.92 | 13.81 | 13.89 | 207300.0 |
| 2006-06-28 | CTEC | ETF | 63.8 | 63.8 | 62.05 | 62.99999999999999 | 25263.0 |
| 2006-06-28 | CYB | ETF | 6.15 | 6.2 | 6.05 | 6.12 | 20500.0 |
| 2006-06-28 | DBC | ETF | 24.67 | 24.77 | 24.43 | 24.65 | 205500.0 |
| 2006-06-28 | DDM | ETF | 5.8208 | 5.86 | 5.7967 | 5.8525 | 584400.0 |
| 2006-06-28 | DES | ETF | 16.7433 | 16.7433 | 16.6667 | 16.67 | 5400.0 |
| 2006-06-28 | DFE | ETF | 50.95 | 50.95 | 50.95 | 50.95 | 500.0 |
| 2006-06-28 | DFJ | ETF | 49.58 | 49.58 | 49.58 | 49.58 | 200.0 |
| 2006-06-28 | DGT | ETF | 65.4 | 65.43 | 65.4 | 65.43 | 800.0 |
> showing 50 of 357 rows — these rows as CSV