PREVIEW / etf_daily / 2006-06-07
file: by_date/etf_daily/2006/2006-06-07.parquet size: 17 KB rows: 328
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-07 | SPY | ETF | 126.91 | 127.65 | 125.79 | 125.86 | 108599400.0 |
| 2006-06-07 | QQQ | ETF | 38.8 | 39.17 | 38.45 | 38.46 | 130867576.0 |
| 2006-06-07 | IWM | ETF | 70.82 | 71.82 | 70.01 | 70.1 | 81935900.0 |
| 2006-06-07 | DIA | ETF | 110.12 | 110.73 | 109.14 | 109.19 | 9062900.0 |
| 2006-06-07 | GLD | ETF | 61.54 | 62.85 | 61.35 | 62.28 | 10172700.0 |
| 2006-06-07 | TLT | ETF | 84.73 | 85.1 | 84.65 | 85.1 | 1324100.0 |
| 2006-06-07 | AAA | ETF | 57.47 | 57.87 | 57.31 | 57.7 | 4000.0 |
| 2006-06-07 | ADRE | ETF | 120.7 | 121.82 | 118.65 | 118.666 | 185824.0 |
| 2006-06-07 | AFK | ETF | 25.36 | 25.4 | 25.27 | 25.3 | 3400.0 |
| 2006-06-07 | AGG | ETF | 98.12 | 98.14 | 97.85 | 97.9 | 320000.0 |
| 2006-06-07 | AIQ | ETF | 29.8 | 29.8 | 27.75 | 27.8 | 26260.0 |
| 2006-06-07 | AIS | ETF | 1.27 | 1.32 | 1.27 | 1.3 | 118200.0 |
| 2006-06-07 | AOM | ETF | 7.15 | 7.23 | 7.1 | 7.15 | 25000.0 |
| 2006-06-07 | ARB | ETF | 38.83 | 39.46 | 38.56 | 38.78 | 450200.0 |
| 2006-06-07 | BAB | ETF | 62.53 | 63.42 | 62.35 | 62.8 | 26400.0 |
| 2006-06-07 | BBC | ETF | 9.45 | 9.93 | 9.4 | 9.51 | 290400.0 |
| 2006-06-07 | BBH | ETF | 57.9 | 58.3367 | 57.44 | 57.5733 | 2029200.0 |
| 2006-06-07 | BCM | ETF | 71.03 | 71.21 | 69.6 | 70.25 | 25000.0 |
| 2006-06-07 | BITS | ETF | 24.56 | 24.76 | 23.04 | 24.08 | 17918.0 |
| 2006-06-07 | BKF | ETF | 6.9 | 6.92 | 6.44 | 6.56 | 102800.0 |
| 2006-06-07 | BNE | ETF | 14.23 | 14.6 | 14.09 | 14.17 | 126200.0 |
| 2006-06-07 | BRF | ETF | 14.01 | 14.02 | 13.99 | 13.99 | 3600.0 |
| 2006-06-07 | BTF | ETF | 88.6 | 88.75 | 88.55 | 88.75 | 2640.0 |
| 2006-06-07 | CBON | ETF | 30.76 | 30.76 | 30.55 | 30.62 | 17851.0 |
| 2006-06-07 | CDL | ETF | 9.2 | 9.26 | 9.04 | 9.05 | 379000.0 |
| 2006-06-07 | CEF | ETF | 8.78 | 9.15 | 8.56 | 9.15 | 868700.0 |
| 2006-06-07 | CEW | ETF | 25.6 | 25.6 | 25.6 | 25.6 | 400.0 |
| 2006-06-07 | CFO | ETF | 10.05 | 10.06 | 10.04 | 10.04 | 11900.0 |
| 2006-06-07 | CGO | ETF | 14.8 | 14.8 | 14.55 | 14.6 | 35500.0 |
| 2006-06-07 | CHB | ETF | 11.05 | 11.37 | 10.86 | 11.14 | 1080400.0 |
| 2006-06-07 | CHI | ETF | 20.04 | 20.1 | 19.85 | 19.89 | 83700.0 |
| 2006-06-07 | CHIC | ETF | 20.73 | 21.37 | 20.51 | 20.84 | 584875.0 |
| 2006-06-07 | CHY | ETF | 16.88 | 16.93 | 16.76 | 16.86 | 147700.0 |
| 2006-06-07 | CIL | ETF | 25.1 | 25.18 | 25.1 | 25.18 | 3000.0 |
| 2006-06-07 | CN | ETF | 33.55 | 34.05 | 33.49 | 33.5 | 32100.0 |
| 2006-06-07 | CNXT | ETF | 2.73 | 2.78 | 2.6399 | 2.65 | 11237551.0 |
| 2006-06-07 | COMB | ETF | 9.98 | 10.05 | 9.9 | 9.95 | 13000.0 |
| 2006-06-07 | CPI | ETF | 32.89 | 33.2 | 32.87 | 33.2 | 3900.0 |
| 2006-06-07 | CPST | ETF | 2.81 | 2.88 | 2.76 | 2.78 | 1638832.0 |
| 2006-06-07 | CSA | ETF | 18.7 | 19.0 | 18.15 | 18.15 | 5400.0 |
| 2006-06-07 | CSB | ETF | 28.16 | 28.27 | 28.08 | 28.1 | 6300.0 |
| 2006-06-07 | CSQ | ETF | 14.06 | 14.08 | 13.94 | 14.08 | 318500.0 |
| 2006-06-07 | CTEC | ETF | 68.6 | 70.8 | 68.49999999999999 | 70.0 | 18621.600000000002 |
| 2006-06-07 | CYB | ETF | 5.9 | 6.0 | 5.9 | 5.96 | 4200.0 |
| 2006-06-07 | DBC | ETF | 25.3 | 25.35 | 25.1 | 25.25 | 176800.0 |
| 2006-06-07 | DGT | ETF | 66.6 | 67.08 | 66.51 | 66.54 | 4700.0 |
| 2006-06-07 | DIG | ETF | 17.85 | 17.8625 | 17.8 | 17.8 | 1280.0 |
| 2006-06-07 | DIV | ETF | 12.0 | 12.0 | 11.96 | 12.0 | 7400.0 |
| 2006-06-07 | DJP | ETF | 49.62 | 50.23 | 49.55 | 50.2 | 79700.0 |
| 2006-06-07 | DRIV | ETF | 39.12 | 40.47 | 39.12 | 39.25 | 897420.0 |
> showing 50 of 328 rows — these rows as CSV