PREVIEW / etf_daily / 2006-05-16
file: by_date/etf_daily/2006/2006-05-16.parquet size: 17 KB rows: 320
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-05-16 | SPY | ETF | 129.76 | 130.0 | 129.01 | 129.31 | 62137600.0 |
| 2006-05-16 | QQQ | ETF | 40.16 | 40.26 | 39.77 | 39.86 | 132405520.0 |
| 2006-05-16 | IWM | ETF | 73.46 | 73.87 | 72.94 | 73.29 | 35594500.0 |
| 2006-05-16 | DIA | ETF | 114.4 | 114.72 | 114.0 | 114.3 | 6972200.0 |
| 2006-05-16 | GLD | ETF | 68.32 | 68.86 | 67.87 | 68.61 | 12221900.0 |
| 2006-05-16 | TLT | ETF | 83.08 | 83.64 | 83.08 | 83.6 | 1677600.0 |
| 2006-05-16 | AAA | ETF | 61.29 | 61.29 | 60.9601 | 61.15 | 6300.0 |
| 2006-05-16 | ADRE | ETF | 134.3 | 136.0 | 132.62 | 134.95 | 50904.0 |
| 2006-05-16 | AFK | ETF | 25.16 | 25.19 | 25.16 | 25.17 | 6800.0 |
| 2006-05-16 | AGG | ETF | 97.65 | 98.17 | 97.65 | 98.13 | 471300.0 |
| 2006-05-16 | AIQ | ETF | 31.65 | 33.0 | 31.25 | 32.15 | 37260.0 |
| 2006-05-16 | AIS | ETF | 1.47 | 1.47 | 1.37 | 1.46 | 114300.0 |
| 2006-05-16 | AOM | ETF | 6.94 | 7.25 | 6.94 | 7.25 | 24100.0 |
| 2006-05-16 | ARB | ETF | 37.78 | 38.26 | 37.53 | 38.04 | 994500.0 |
| 2006-05-16 | BAB | ETF | 63.67 | 63.67 | 63.03 | 63.59 | 12700.0 |
| 2006-05-16 | BBC | ETF | 11.71 | 12.29 | 11.7 | 11.98 | 265700.0 |
| 2006-05-16 | BBH | ETF | 58.4833 | 58.7433 | 58.0167 | 58.3167 | 2751000.0 |
| 2006-05-16 | BCM | ETF | 74.4 | 75.41 | 74.4 | 75.41 | 32500.0 |
| 2006-05-16 | BITS | ETF | 27.44 | 28.0 | 26.4 | 27.52 | 37401.0 |
| 2006-05-16 | BKF | ETF | 7.81 | 7.91 | 7.81 | 7.89 | 89400.0 |
| 2006-05-16 | BNE | ETF | 13.39 | 14.41 | 13.39 | 14.1 | 210000.0 |
| 2006-05-16 | BRF | ETF | 14.01 | 14.01 | 13.98 | 13.98 | 3000.0 |
| 2006-05-16 | BTF | ETF | 88.9 | 89.1 | 88.9 | 88.9 | 7040.0 |
| 2006-05-16 | CBON | ETF | 32.07 | 33.0 | 32.07 | 32.37 | 21399.0 |
| 2006-05-16 | CDL | ETF | 10.37 | 10.69 | 10.28 | 10.64 | 591900.0 |
| 2006-05-16 | CEF | ETF | 9.32 | 9.54 | 9.32 | 9.39 | 1067400.0 |
| 2006-05-16 | CEW | ETF | 25.74 | 25.75 | 25.74 | 25.75 | 1000.0 |
| 2006-05-16 | CFO | ETF | 10.2 | 10.3 | 10.2 | 10.22 | 9700.0 |
| 2006-05-16 | CGO | ETF | 14.56 | 14.67 | 14.56 | 14.66 | 38300.0 |
| 2006-05-16 | CHB | ETF | 14.5 | 14.8 | 14.01 | 14.22 | 520000.0 |
| 2006-05-16 | CHI | ETF | 19.93 | 19.94 | 19.85 | 19.88 | 69100.0 |
| 2006-05-16 | CHIC | ETF | 21.59 | 21.8 | 21.5 | 21.5 | 198519.0 |
| 2006-05-16 | CHY | ETF | 16.05 | 16.06 | 15.99 | 16.04 | 94300.0 |
| 2006-05-16 | CIL | ETF | 25.77 | 25.92 | 25.77 | 25.88 | 3300.0 |
| 2006-05-16 | CN | ETF | 36.95 | 37.15 | 36.8501 | 37.03 | 62000.0 |
| 2006-05-16 | CNXT | ETF | 3.219 | 3.41 | 3.2 | 3.28 | 13943335.0 |
| 2006-05-16 | COMB | ETF | 10.05 | 10.07 | 9.88 | 9.96 | 6623.0 |
| 2006-05-16 | CPST | ETF | 3.255 | 3.35 | 3.05 | 3.09 | 1728907.0 |
| 2006-05-16 | CSA | ETF | 19.3 | 19.48 | 19.3 | 19.38 | 2800.0 |
| 2006-05-16 | CSB | ETF | 30.61 | 30.68 | 30.53 | 30.67 | 4600.0 |
| 2006-05-16 | CSQ | ETF | 13.85 | 13.88 | 13.76 | 13.81 | 324700.0 |
| 2006-05-16 | CTEC | ETF | 64.25 | 65.14999999999999 | 62.5 | 63.15 | 11013.400000000001 |
| 2006-05-16 | CYB | ETF | 5.58 | 5.6 | 5.31 | 5.5 | 87400.0 |
| 2006-05-16 | DBC | ETF | 25.95 | 26.29 | 25.81 | 26.02 | 602500.0 |
| 2006-05-16 | DGT | ETF | 68.85 | 68.85 | 68.51 | 68.61 | 9900.0 |
| 2006-05-16 | DIG | ETF | 17.875 | 17.875 | 17.825 | 17.825 | 1680.0 |
| 2006-05-16 | DIV | ETF | 11.85 | 11.85 | 11.78 | 11.83 | 20000.0 |
| 2006-05-16 | DRIV | ETF | 46.43 | 47.31 | 46.15 | 46.98 | 651308.0 |
| 2006-05-16 | DUSA | ETF | 6.99 | 7.25 | 6.76 | 6.86 | 518053.0 |
| 2006-05-16 | DVY | ETF | 63.61 | 63.75 | 63.32 | 63.65 | 431400.0 |
> showing 50 of 320 rows — these rows as CSV