PREVIEW / etf_daily / 2006-06-06
file: by_date/etf_daily/2006/2006-06-06.parquet size: 17 KB rows: 326
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-06 | SPY | ETF | 127.21 | 127.38 | 125.76 | 126.81 | 130498600.0 |
| 2006-06-06 | QQQ | ETF | 38.85 | 38.95 | 38.35 | 38.75 | 127304218.0 |
| 2006-06-06 | IWM | ETF | 71.04 | 71.16 | 69.81 | 70.79 | 94747900.0 |
| 2006-06-06 | DIA | ETF | 110.78 | 110.94 | 109.21 | 109.99 | 15140100.0 |
| 2006-06-06 | GLD | ETF | 62.58 | 62.67 | 62.16 | 62.55 | 7175100.0 |
| 2006-06-06 | TLT | ETF | 84.66 | 85.18 | 84.59 | 85.08 | 2188000.0 |
| 2006-06-06 | AAA | ETF | 58.44 | 58.6 | 58.15 | 58.54 | 4200.0 |
| 2006-06-06 | ADRE | ETF | 123.19 | 123.19 | 119.57 | 121.11 | 208988.0 |
| 2006-06-06 | AFK | ETF | 25.28 | 25.36 | 25.28 | 25.28 | 82700.0 |
| 2006-06-06 | AGG | ETF | 98.08 | 98.25 | 97.88 | 98.21 | 255500.0 |
| 2006-06-06 | AIQ | ETF | 29.4 | 29.4 | 28.5 | 28.8 | 12140.0 |
| 2006-06-06 | AIS | ETF | 1.3 | 1.36 | 1.28 | 1.3 | 296500.0 |
| 2006-06-06 | AOM | ETF | 7.2 | 7.2 | 7.08 | 7.18 | 22400.0 |
| 2006-06-06 | ARB | ETF | 39.37 | 39.54 | 38.59 | 38.85 | 310600.0 |
| 2006-06-06 | BAB | ETF | 63.2 | 63.23 | 62.19 | 62.75 | 32500.0 |
| 2006-06-06 | BBC | ETF | 10.07 | 10.23 | 9.2 | 9.38 | 467100.0 |
| 2006-06-06 | BBH | ETF | 58.1633 | 58.5333 | 57.2533 | 57.9 | 2392800.0 |
| 2006-06-06 | BCM | ETF | 69.7 | 69.78 | 68.87 | 69.55 | 46700.0 |
| 2006-06-06 | BITS | ETF | 25.48 | 25.88 | 23.12 | 24.6 | 32709.0 |
| 2006-06-06 | BKF | ETF | 6.95 | 7.05 | 6.9 | 6.9 | 48100.0 |
| 2006-06-06 | BNE | ETF | 14.21 | 14.33 | 13.75 | 14.22 | 135400.0 |
| 2006-06-06 | BOSS | ETF | 32.3 | 32.3 | 31.51 | 31.51 | 200.0 |
| 2006-06-06 | BRF | ETF | 14.04 | 14.05 | 13.95 | 14.0 | 26000.0 |
| 2006-06-06 | BTF | ETF | 89.14999999999999 | 89.14999999999999 | 89.0 | 89.0 | 2480.0 |
| 2006-06-06 | CBON | ETF | 30.93 | 31.0 | 30.5 | 30.56 | 21499.0 |
| 2006-06-06 | CDL | ETF | 9.35 | 9.35 | 9.07 | 9.17 | 540300.0 |
| 2006-06-06 | CEF | ETF | 8.88 | 9.03 | 8.75 | 8.8 | 753700.0 |
| 2006-06-06 | CEW | ETF | 25.65 | 25.65 | 25.65 | 25.65 | 200.0 |
| 2006-06-06 | CFO | ETF | 10.15 | 10.15 | 10.06 | 10.08 | 6500.0 |
| 2006-06-06 | CGO | ETF | 14.57 | 14.8 | 14.5 | 14.8 | 27000.0 |
| 2006-06-06 | CHB | ETF | 10.82 | 11.2 | 10.65 | 11.02 | 1767000.0 |
| 2006-06-06 | CHI | ETF | 20.08 | 20.15 | 20.0 | 20.07 | 75300.0 |
| 2006-06-06 | CHIC | ETF | 20.62 | 20.97 | 20.51 | 20.76 | 424238.0 |
| 2006-06-06 | CHY | ETF | 16.9 | 16.92 | 16.76 | 16.8 | 172100.0 |
| 2006-06-06 | CIL | ETF | 25.0 | 25.1 | 25.0 | 25.1 | 1600.0 |
| 2006-06-06 | CN | ETF | 34.17 | 34.32 | 33.5832 | 33.76 | 50700.0 |
| 2006-06-06 | CNXT | ETF | 2.78 | 2.79 | 2.67 | 2.7 | 17610186.0 |
| 2006-06-06 | COMB | ETF | 10.03 | 10.04 | 9.85 | 9.9 | 6578.0 |
| 2006-06-06 | CPI | ETF | 32.6 | 32.87 | 32.6 | 32.87 | 700.0 |
| 2006-06-06 | CPST | ETF | 2.93 | 2.97 | 2.78 | 2.81 | 2080201.0 |
| 2006-06-06 | CSA | ETF | 18.6 | 18.85 | 18.01 | 18.85 | 9800.0 |
| 2006-06-06 | CSB | ETF | 28.58 | 28.65 | 28.23 | 28.57 | 5800.0 |
| 2006-06-06 | CSQ | ETF | 14.01 | 14.06 | 13.93 | 14.03 | 256500.0 |
| 2006-06-06 | CTEC | ETF | 68.85 | 70.14999999999999 | 68.1 | 68.44999999999999 | 16849.2 |
| 2006-06-06 | CYB | ETF | 6.12 | 6.134 | 5.9 | 5.95 | 23400.0 |
| 2006-06-06 | DBC | ETF | 25.4 | 25.5 | 25.2 | 25.42 | 329000.0 |
| 2006-06-06 | DGT | ETF | 67.02 | 67.07 | 66.44 | 66.81 | 3400.0 |
| 2006-06-06 | DIG | ETF | 17.85 | 17.875 | 17.85 | 17.875 | 4880.0 |
| 2006-06-06 | DIV | ETF | 11.97 | 12.0 | 11.93 | 12.0 | 19900.0 |
| 2006-06-06 | DRIV | ETF | 40.77 | 40.77 | 38.1 | 39.24 | 2523288.0 |
> showing 50 of 326 rows — these rows as CSV