PREVIEW / etf_daily / 2005-12-12
file: by_date/etf_daily/2005/2005-12-12.parquet size: 16 KB rows: 292
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-12 | SPY | ETF | 126.71 | 126.86 | 125.96 | 126.45 | 48389900.0 |
| 2005-12-12 | QQQ | ETF | 41.87 | 41.94 | 41.68 | 41.867 | 44869979.0 |
| 2005-12-12 | IWM | ETF | 68.88 | 68.97 | 68.28 | 68.85 | 24178300.0 |
| 2005-12-12 | DIA | ETF | 108.1 | 108.2 | 107.42 | 107.72 | 5095700.0 |
| 2005-12-12 | GLD | ETF | 53.09 | 53.76 | 52.25 | 52.56 | 7504600.0 |
| 2005-12-12 | TLT | ETF | 89.75 | 89.75 | 89.14 | 89.37 | 440500.0 |
| 2005-12-12 | AAA | ETF | 55.0 | 55.11 | 54.83 | 54.95 | 1300.0 |
| 2005-12-12 | ADRE | ETF | 112.44 | 115.56 | 112.44 | 115.3 | 44680.0 |
| 2005-12-12 | AFK | ETF | 25.52 | 25.59 | 25.52 | 25.55 | 4600.0 |
| 2005-12-12 | AGG | ETF | 100.05 | 100.09 | 99.7 | 99.75 | 122400.0 |
| 2005-12-12 | AIQ | ETF | 27.85 | 29.75 | 27.8 | 29.15 | 12120.0 |
| 2005-12-12 | AIS | ETF | 1.45 | 1.52 | 1.39 | 1.49 | 341000.0 |
| 2005-12-12 | AOM | ETF | 3.45 | 3.53 | 3.41 | 3.45 | 29300.0 |
| 2005-12-12 | ARB | ETF | 39.9 | 39.96 | 39.48 | 39.69 | 107300.0 |
| 2005-12-12 | BAB | ETF | 58.87 | 58.96 | 58.63 | 58.68 | 16300.0 |
| 2005-12-12 | BBC | ETF | 13.0 | 13.0 | 12.5 | 12.77 | 425700.0 |
| 2005-12-12 | BBH | ETF | 68.1467 | 68.2233 | 67.13 | 67.6667 | 1415400.0 |
| 2005-12-12 | BCM | ETF | 65.54 | 65.6 | 64.89 | 64.89 | 30500.0 |
| 2005-12-12 | BITS | ETF | 13.004 | 13.72 | 13.0 | 13.36 | 3864.0 |
| 2005-12-12 | BKF | ETF | 20.25 | 20.45 | 20.16 | 20.18 | 53800.0 |
| 2005-12-12 | BNE | ETF | 14.98 | 15.36 | 14.76 | 15.22 | 224100.0 |
| 2005-12-12 | BRF | ETF | 15.05 | 15.2 | 15.05 | 15.11 | 18100.0 |
| 2005-12-12 | BTF | ETF | 87.3 | 88.39999999999999 | 87.3 | 87.3 | 2440.0 |
| 2005-12-12 | CBON | ETF | 31.08 | 31.35 | 31.08 | 31.3001 | 122848.0 |
| 2005-12-12 | CDL | ETF | 13.33 | 13.58 | 13.33 | 13.37 | 232200.0 |
| 2005-12-12 | CEF | ETF | 6.33 | 6.6 | 6.28 | 6.28 | 2191800.0 |
| 2005-12-12 | CGO | ETF | 13.37 | 13.55 | 13.26 | 13.43 | 39500.0 |
| 2005-12-12 | CHB | ETF | 14.48 | 14.78 | 14.4 | 14.45 | 403600.0 |
| 2005-12-12 | CHI | ETF | 20.41 | 20.56 | 20.28 | 20.52 | 97400.0 |
| 2005-12-12 | CHIC | ETF | 19.69 | 20.08 | 19.6 | 19.73 | 187298.0 |
| 2005-12-12 | CHIR | ETF | 44.5899 | 44.6001 | 44.4999 | 44.52 | 728810.0 |
| 2005-12-12 | CHY | ETF | 15.94 | 16.04 | 15.87 | 16.03 | 122200.0 |
| 2005-12-12 | CIL | ETF | 25.16 | 25.26 | 25.15 | 25.15 | 1900.0 |
| 2005-12-12 | CN | ETF | 31.0 | 31.0 | 30.45 | 30.68 | 103800.0 |
| 2005-12-12 | CNXT | ETF | 2.63 | 2.64 | 2.55 | 2.55 | 4481464.0 |
| 2005-12-12 | COMB | ETF | 8.55 | 8.55 | 8.55 | 8.55 | 200.0 |
| 2005-12-12 | CPST | ETF | 3.47 | 3.74 | 3.47 | 3.67 | 2736465.0 |
| 2005-12-12 | CSA | ETF | 16.55 | 16.69 | 16.4 | 16.44 | 37400.0 |
| 2005-12-12 | CSB | ETF | 31.15 | 31.26 | 31.1 | 31.2 | 21700.0 |
| 2005-12-12 | CSM | ETF | 2.4425 | 2.4425 | 2.4425 | 2.4425 | 10000.0 |
| 2005-12-12 | CSQ | ETF | 13.06 | 13.14 | 12.95 | 12.99 | 579200.0 |
| 2005-12-12 | CTEC | ETF | 51.3 | 52.0 | 51.199999999999996 | 51.65 | 4496.2 |
| 2005-12-12 | CURE | ETF | 0.0262 | 0.0275 | 0.0225 | 0.0239 | 4726072.0 |
| 2005-12-12 | CYB | ETF | 3.7 | 3.7 | 3.56 | 3.56 | 17300.0 |
| 2005-12-12 | DGT | ETF | 65.74 | 65.75 | 65.62 | 65.74 | 2800.0 |
| 2005-12-12 | DIG | ETF | 15.625 | 15.9375 | 15.625 | 15.75 | 10560.0 |
| 2005-12-12 | DIV | ETF | 11.9 | 12.01 | 11.9 | 11.97 | 40600.0 |
| 2005-12-12 | DRIV | ETF | 29.84 | 29.85 | 28.2 | 28.89 | 1349192.0 |
| 2005-12-12 | DUSA | ETF | 9.99 | 10.0 | 9.65 | 9.71 | 223611.0 |
| 2005-12-12 | DVY | ETF | 62.31 | 62.45 | 61.8 | 62.16 | 335100.0 |
> showing 50 of 292 rows — these rows as CSV