PREVIEW / etf_daily / 2006-06-05
file: by_date/etf_daily/2006/2006-06-05.parquet size: 17 KB rows: 327
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-05 | SPY | ETF | 128.85 | 128.86 | 126.77 | 127.12 | 86105100.0 |
| 2006-06-05 | QQQ | ETF | 39.55 | 39.56 | 38.78 | 38.78 | 103300548.0 |
| 2006-06-05 | IWM | ETF | 73.06 | 73.15 | 70.86 | 71.09 | 66165900.0 |
| 2006-06-05 | DIA | ETF | 112.16 | 112.22 | 110.4 | 110.69 | 9940600.0 |
| 2006-06-05 | GLD | ETF | 63.82 | 64.19 | 63.12 | 63.29 | 6018600.0 |
| 2006-06-05 | TLT | ETF | 84.81 | 84.82 | 84.51 | 84.68 | 1102900.0 |
| 2006-06-05 | AAA | ETF | 59.3 | 59.43 | 59.18 | 59.35 | 4900.0 |
| 2006-06-05 | ADRE | ETF | 127.75 | 127.75 | 122.58 | 122.758 | 149960.0 |
| 2006-06-05 | AFK | ETF | 25.28 | 25.29 | 25.28 | 25.29 | 1200.0 |
| 2006-06-05 | AGG | ETF | 97.96 | 98.26 | 97.95 | 97.95 | 356200.0 |
| 2006-06-05 | AIQ | ETF | 30.1 | 30.7 | 29.65 | 29.75 | 28820.0 |
| 2006-06-05 | AIS | ETF | 1.34 | 1.34 | 1.28 | 1.33 | 214100.0 |
| 2006-06-05 | AOM | ETF | 7.19 | 7.28 | 7.16 | 7.26 | 9200.0 |
| 2006-06-05 | ARB | ETF | 39.78 | 40.0 | 39.28 | 39.33 | 238900.0 |
| 2006-06-05 | BAB | ETF | 64.2 | 64.32 | 63.0 | 63.0 | 55200.0 |
| 2006-06-05 | BBC | ETF | 10.88 | 10.95 | 10.01 | 10.12 | 238800.0 |
| 2006-06-05 | BBH | ETF | 59.3 | 59.3067 | 58.0 | 58.1633 | 2006700.0 |
| 2006-06-05 | BCM | ETF | 71.45 | 71.45 | 70.28 | 70.34 | 34300.0 |
| 2006-06-05 | BITS | ETF | 25.52 | 26.12 | 25.32 | 25.48 | 11717.0 |
| 2006-06-05 | BKF | ETF | 6.94 | 7.05 | 6.94 | 6.98 | 49100.0 |
| 2006-06-05 | BNE | ETF | 14.79 | 14.97 | 14.16 | 14.23 | 152800.0 |
| 2006-06-05 | BOSS | ETF | 33.4 | 33.4 | 32.35 | 32.35 | 100.0 |
| 2006-06-05 | BRF | ETF | 14.0 | 14.05 | 14.0 | 14.01 | 14400.0 |
| 2006-06-05 | BTF | ETF | 89.1 | 89.1 | 88.69999999999999 | 88.9 | 5660.0 |
| 2006-06-05 | CBON | ETF | 31.5 | 31.5 | 30.7 | 30.71 | 20271.0 |
| 2006-06-05 | CDL | ETF | 9.5 | 9.5 | 9.31 | 9.33 | 314000.0 |
| 2006-06-05 | CEF | ETF | 9.35 | 9.38 | 9.04 | 9.11 | 487200.0 |
| 2006-06-05 | CFO | ETF | 10.2 | 10.2 | 10.2 | 10.2 | 4200.0 |
| 2006-06-05 | CGO | ETF | 14.58 | 14.67 | 14.53 | 14.63 | 37400.0 |
| 2006-06-05 | CHB | ETF | 11.45 | 11.6399 | 10.86 | 11.02 | 1422600.0 |
| 2006-06-05 | CHI | ETF | 20.14 | 20.18 | 20.02 | 20.08 | 56800.0 |
| 2006-06-05 | CHIC | ETF | 21.24 | 21.35 | 20.46 | 20.49 | 380170.0 |
| 2006-06-05 | CHY | ETF | 16.92 | 16.9299 | 16.78 | 16.8 | 166800.0 |
| 2006-06-05 | CIL | ETF | 25.05 | 25.05 | 25.04 | 25.04 | 500.0 |
| 2006-06-05 | CIZ | ETF | 23.15 | 23.15 | 23.15 | 23.15 | 200.0 |
| 2006-06-05 | CN | ETF | 34.49 | 34.66 | 33.89 | 34.22 | 108100.0 |
| 2006-06-05 | CNXT | ETF | 2.87 | 2.87 | 2.72 | 2.748 | 12495583.0 |
| 2006-06-05 | COMB | ETF | 10.02 | 10.23 | 9.87 | 9.95 | 21332.0 |
| 2006-06-05 | CPI | ETF | 32.44 | 32.44 | 32.44 | 32.44 | 100.0 |
| 2006-06-05 | CPST | ETF | 3.04 | 3.07 | 2.85 | 2.97 | 2416741.0 |
| 2006-06-05 | CSA | ETF | 18.26 | 18.5 | 18.26 | 18.5 | 300.0 |
| 2006-06-05 | CSB | ETF | 29.33 | 29.33 | 28.86 | 28.86 | 7100.0 |
| 2006-06-05 | CSQ | ETF | 14.08 | 14.08 | 13.98 | 14.02 | 238700.0 |
| 2006-06-05 | CTEC | ETF | 70.0 | 70.2495 | 67.89999999999999 | 69.0 | 21585.800000000003 |
| 2006-06-05 | CYB | ETF | 5.95 | 6.05 | 5.9 | 5.97 | 58900.0 |
| 2006-06-05 | DBC | ETF | 25.77 | 25.92 | 25.55 | 25.64 | 492100.0 |
| 2006-06-05 | DGT | ETF | 67.75 | 67.86 | 67.1 | 67.1 | 2900.0 |
| 2006-06-05 | DIG | ETF | 17.925 | 17.925 | 17.925 | 17.925 | 80.0 |
| 2006-06-05 | DIV | ETF | 12.0 | 12.026 | 11.965 | 12.0 | 23900.0 |
| 2006-06-05 | DRIV | ETF | 43.32 | 43.45 | 40.72 | 40.81 | 2054056.0 |
> showing 50 of 327 rows — these rows as CSV