PREVIEW / etf_daily / 2006-01-11
file: by_date/etf_daily/2006/2006-01-11.parquet size: 16 KB rows: 302
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-01-11 | SPY | ETF | 129.02 | 129.44 | 128.73 | 129.31 | 49598900.0 |
| 2006-01-11 | QQQ | ETF | 43.01 | 43.31 | 42.87 | 43.21 | 100777623.0 |
| 2006-01-11 | IWM | ETF | 70.71 | 70.73 | 70.04 | 70.58 | 29588700.0 |
| 2006-01-11 | DIA | ETF | 110.11 | 110.46 | 109.88 | 110.43 | 4388600.0 |
| 2006-01-11 | GLD | ETF | 54.24 | 54.77 | 54.07 | 54.53 | 4209500.0 |
| 2006-01-11 | TLT | ETF | 91.25 | 91.29 | 90.75 | 90.89 | 394600.0 |
| 2006-01-11 | AAA | ETF | 55.18 | 55.56 | 55.1 | 55.55 | 3700.0 |
| 2006-01-11 | ADRE | ETF | 121.0 | 123.85 | 120.63 | 123.85 | 107452.0 |
| 2006-01-11 | AFK | ETF | 25.3 | 25.32 | 25.2 | 25.3 | 47100.0 |
| 2006-01-11 | AGG | ETF | 100.73 | 100.75 | 100.41 | 100.49 | 111000.0 |
| 2006-01-11 | AIQ | ETF | 28.1 | 28.4 | 27.25 | 28.2 | 25560.0 |
| 2006-01-11 | AIS | ETF | 1.45 | 1.5 | 1.4 | 1.45 | 345200.0 |
| 2006-01-11 | AOM | ETF | 4.42 | 4.72 | 4.4 | 4.72 | 40000.0 |
| 2006-01-11 | ARB | ETF | 39.65 | 39.8 | 38.66 | 39.25 | 145000.0 |
| 2006-01-11 | BAB | ETF | 59.37 | 60.05 | 59.37 | 59.73 | 58800.0 |
| 2006-01-11 | BBC | ETF | 15.51 | 16.47 | 15.15 | 16.25 | 361000.0 |
| 2006-01-11 | BBH | ETF | 66.4167 | 67.46 | 66.3333 | 66.7833 | 3324000.0 |
| 2006-01-11 | BCM | ETF | 68.5 | 69.72 | 68.46 | 69.5 | 42800.0 |
| 2006-01-11 | BITS | ETF | 14.4 | 14.48 | 13.64 | 13.84 | 9895.0 |
| 2006-01-11 | BKF | ETF | 18.48 | 18.75 | 18.32 | 18.46 | 70000.0 |
| 2006-01-11 | BNE | ETF | 15.14 | 15.17 | 14.78 | 15.17 | 91600.0 |
| 2006-01-11 | BRF | ETF | 15.4 | 15.4 | 15.33 | 15.33 | 2800.0 |
| 2006-01-11 | BTF | ETF | 85.99999999999999 | 86.25 | 85.74999999999999 | 86.19999999999999 | 2420.0 |
| 2006-01-11 | CBON | ETF | 32.98 | 32.98 | 32.54 | 32.6 | 18192.0 |
| 2006-01-11 | CDL | ETF | 13.3 | 13.33 | 13.17 | 13.18 | 273400.0 |
| 2006-01-11 | CEF | ETF | 7.07 | 7.18 | 7.07 | 7.15 | 472000.0 |
| 2006-01-11 | CEW | ETF | 26.2 | 26.25 | 26.2 | 26.24 | 2300.0 |
| 2006-01-11 | CFO | ETF | 9.9 | 10.0 | 9.9 | 9.9 | 20100.0 |
| 2006-01-11 | CGO | ETF | 14.34 | 14.74 | 14.15 | 14.56 | 36200.0 |
| 2006-01-11 | CHB | ETF | 14.21 | 14.24 | 13.95 | 14.05 | 375400.0 |
| 2006-01-11 | CHI | ETF | 20.11 | 20.2 | 19.92 | 20.04 | 101800.0 |
| 2006-01-11 | CHIC | ETF | 20.59 | 20.9 | 19.97 | 20.01 | 943063.0 |
| 2006-01-11 | CHIR | ETF | 44.73 | 44.7801 | 44.6499 | 44.7201 | 974971.0 |
| 2006-01-11 | CHY | ETF | 16.0 | 16.029 | 15.881 | 15.95 | 90800.0 |
| 2006-01-11 | CIL | ETF | 25.33 | 25.35 | 25.33 | 25.33 | 2200.0 |
| 2006-01-11 | CIZ | ETF | 22.7 | 23.0 | 22.7 | 23.0 | 6200.0 |
| 2006-01-11 | CN | ETF | 34.98 | 35.3 | 34.97 | 35.03 | 43500.0 |
| 2006-01-11 | CNXT | ETF | 3.08 | 3.45 | 3.04 | 3.31 | 111745640.0 |
| 2006-01-11 | COMB | ETF | 8.35 | 8.35 | 8.35 | 8.35 | 912.0 |
| 2006-01-11 | CPST | ETF | 3.23 | 3.63 | 3.22 | 3.6199 | 9006609.0 |
| 2006-01-11 | CSA | ETF | 17.48 | 17.75 | 17.48 | 17.65 | 24800.0 |
| 2006-01-11 | CSB | ETF | 32.26 | 32.55 | 32.21 | 32.55 | 19600.0 |
| 2006-01-11 | CSM | ETF | 2.46 | 2.46 | 2.46 | 2.46 | 10800.0 |
| 2006-01-11 | CSQ | ETF | 14.44 | 14.44 | 13.96 | 14.08 | 490400.0 |
| 2006-01-11 | CTEC | ETF | 50.14999999999999 | 50.14999999999999 | 48.49999999999999 | 48.849999999999994 | 22570.4 |
| 2006-01-11 | CURE | ETF | 0.0288 | 0.0312 | 0.0286 | 0.0312 | 2018792.0 |
| 2006-01-11 | CYB | ETF | 3.77 | 3.99 | 3.77 | 3.91 | 6700.0 |
| 2006-01-11 | DGT | ETF | 67.16 | 67.52 | 67.07 | 67.48 | 5200.0 |
| 2006-01-11 | DIG | ETF | 16.95 | 16.95 | 16.95 | 16.95 | 400.0 |
| 2006-01-11 | DIV | ETF | 12.55 | 12.62 | 12.48 | 12.48 | 30900.0 |
> showing 50 of 302 rows — these rows as CSV