PREVIEW / etf_daily / 2006-06-13
file: by_date/etf_daily/2006/2006-06-13.parquet size: 17 KB rows: 329
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-13 | SPY | ETF | 123.74 | 124.84 | 122.55 | 122.55 | 185688800.0 |
| 2006-06-13 | QQQ | ETF | 37.52 | 37.8 | 37.16 | 37.25 | 207140244.0 |
| 2006-06-13 | IWM | ETF | 67.65 | 68.85 | 66.6 | 66.65 | 139584200.0 |
| 2006-06-13 | DIA | ETF | 107.97 | 108.69 | 106.96 | 106.97 | 13085700.0 |
| 2006-06-13 | GLD | ETF | 58.1 | 58.65 | 55.81 | 55.92 | 26220600.0 |
| 2006-06-13 | TLT | ETF | 85.85 | 85.94 | 85.55 | 85.85 | 1448300.0 |
| 2006-06-13 | AAA | ETF | 55.76 | 56.07 | 55.56 | 55.71 | 17300.0 |
| 2006-06-13 | ADRE | ETF | 108.5 | 111.03 | 107.22 | 107.89 | 276424.0 |
| 2006-06-13 | AFK | ETF | 25.0 | 25.08 | 24.96 | 24.97 | 9200.0 |
| 2006-06-13 | AGG | ETF | 98.4 | 98.44 | 98.11 | 98.35 | 258900.0 |
| 2006-06-13 | AIQ | ETF | 27.35 | 28.15 | 26.85 | 27.1 | 24380.0 |
| 2006-06-13 | AIS | ETF | 1.21 | 1.26 | 1.13 | 1.1899 | 250300.0 |
| 2006-06-13 | AOM | ETF | 7.25 | 7.25 | 6.97 | 7.07 | 7300.0 |
| 2006-06-13 | ARB | ETF | 37.65 | 38.24 | 37.63 | 37.99 | 542400.0 |
| 2006-06-13 | BAB | ETF | 61.78 | 62.09 | 60.19 | 60.5 | 68000.0 |
| 2006-06-13 | BBC | ETF | 9.09 | 9.09 | 8.11 | 8.75 | 243200.0 |
| 2006-06-13 | BBH | ETF | 56.7 | 58.1033 | 56.7 | 57.44 | 2050800.0 |
| 2006-06-13 | BCM | ETF | 71.26 | 71.26 | 68.89 | 69.1 | 37900.0 |
| 2006-06-13 | BITS | ETF | 23.96 | 24.36 | 21.04 | 22.52 | 48534.0 |
| 2006-06-13 | BKF | ETF | 6.75 | 6.87 | 6.38 | 6.39 | 55100.0 |
| 2006-06-13 | BNE | ETF | 13.56 | 13.85 | 13.23 | 13.34 | 188100.0 |
| 2006-06-13 | BOSS | ETF | 31.11 | 31.11 | 30.51 | 30.51 | 300.0 |
| 2006-06-13 | BRF | ETF | 13.97 | 14.01 | 13.95 | 13.95 | 27800.0 |
| 2006-06-13 | BTF | ETF | 88.69999999999999 | 88.85 | 88.45 | 88.75 | 520.0 |
| 2006-06-13 | CBON | ETF | 30.74 | 30.93 | 30.33 | 30.46 | 56821.0 |
| 2006-06-13 | CDL | ETF | 8.9 | 9.042 | 8.86 | 8.91 | 526700.0 |
| 2006-06-13 | CEF | ETF | 7.95 | 7.97 | 7.68 | 7.9 | 2094300.0 |
| 2006-06-13 | CEW | ETF | 25.65 | 25.65 | 25.65 | 25.65 | 100.0 |
| 2006-06-13 | CFO | ETF | 9.75 | 9.75 | 9.65 | 9.65 | 11500.0 |
| 2006-06-13 | CGO | ETF | 14.33 | 14.35 | 13.89 | 13.99 | 53300.0 |
| 2006-06-13 | CHB | ETF | 10.1 | 10.16 | 9.62 | 9.69 | 2095400.0 |
| 2006-06-13 | CHI | ETF | 19.39 | 19.39 | 18.82 | 18.93 | 227600.0 |
| 2006-06-13 | CHIC | ETF | 19.5 | 19.77 | 18.5 | 18.68 | 681784.0 |
| 2006-06-13 | CHY | ETF | 16.4 | 16.49 | 16.12 | 16.23 | 171900.0 |
| 2006-06-13 | CIL | ETF | 25.04 | 25.14 | 25.04 | 25.14 | 2700.0 |
| 2006-06-13 | CIZ | ETF | 23.1 | 23.15 | 23.1 | 23.15 | 400.0 |
| 2006-06-13 | CN | ETF | 31.7 | 31.92 | 30.82 | 30.82 | 69800.0 |
| 2006-06-13 | CNXT | ETF | 2.385 | 2.48 | 2.28 | 2.33 | 15311691.0 |
| 2006-06-13 | COMB | ETF | 9.61 | 9.98 | 9.61 | 9.8 | 12183.0 |
| 2006-06-13 | CPI | ETF | 33.2 | 33.2 | 33.2 | 33.2 | 100.0 |
| 2006-06-13 | CPST | ETF | 2.38 | 2.42 | 2.22 | 2.24 | 2500216.0 |
| 2006-06-13 | CSA | ETF | 18.99 | 18.99 | 18.614 | 18.614 | 2500.0 |
| 2006-06-13 | CSB | ETF | 26.86 | 27.0 | 26.6 | 26.67 | 3900.0 |
| 2006-06-13 | CSQ | ETF | 13.85 | 13.85 | 13.6 | 13.67 | 339900.0 |
| 2006-06-13 | CTEC | ETF | 67.3 | 68.0 | 58.8 | 60.449999999999996 | 57839.4 |
| 2006-06-13 | CYB | ETF | 5.28 | 5.6 | 5.28 | 5.52 | 84800.0 |
| 2006-06-13 | DBC | ETF | 24.3 | 24.55 | 24.0 | 24.05 | 886700.0 |
| 2006-06-13 | DGT | ETF | 65.15 | 65.38 | 64.47 | 64.74 | 7000.0 |
| 2006-06-13 | DIG | ETF | 17.7 | 17.7 | 17.4625 | 17.4625 | 28320.0 |
| 2006-06-13 | DIV | ETF | 11.89 | 11.99 | 11.86 | 11.95 | 12600.0 |
> showing 50 of 329 rows — these rows as CSV