PREVIEW / etf_daily / 2005-12-07
file: by_date/etf_daily/2005/2005-12-07.parquet size: 16 KB rows: 293
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-07 | SPY | ETF | 126.77 | 126.87 | 125.68 | 126.08 | 66816500.0 |
| 2005-12-07 | QQQ | ETF | 42.01 | 42.03 | 41.629 | 41.86 | 83885425.0 |
| 2005-12-07 | IWM | ETF | 68.42 | 68.57 | 67.75 | 68.12 | 23412400.0 |
| 2005-12-07 | DIA | ETF | 108.68 | 108.73 | 107.69 | 108.1 | 8612400.0 |
| 2005-12-07 | GLD | ETF | 51.22 | 51.5 | 51.1 | 51.32 | 2279800.0 |
| 2005-12-07 | TLT | ETF | 89.8 | 89.91 | 89.52 | 89.67 | 386600.0 |
| 2005-12-07 | AAA | ETF | 53.59 | 53.93 | 53.52 | 53.93 | 3500.0 |
| 2005-12-07 | ADRE | ETF | 115.99 | 116.16 | 114.63 | 114.7 | 25372.0 |
| 2005-12-07 | AFK | ETF | 25.58 | 26.0 | 25.58 | 25.59 | 4700.0 |
| 2005-12-07 | AGG | ETF | 100.0 | 100.06 | 99.67 | 99.79 | 200800.0 |
| 2005-12-07 | AIQ | ETF | 28.0 | 28.45 | 27.65 | 28.0 | 17380.0 |
| 2005-12-07 | AIS | ETF | 1.39 | 1.5 | 1.35 | 1.48 | 800300.0 |
| 2005-12-07 | AOM | ETF | 3.5 | 3.5 | 3.5 | 3.5 | 1000.0 |
| 2005-12-07 | ARB | ETF | 39.92 | 40.08 | 39.45 | 39.5 | 102800.0 |
| 2005-12-07 | BAB | ETF | 57.96 | 58.58 | 57.85 | 58.0 | 185000.0 |
| 2005-12-07 | BBC | ETF | 13.07 | 13.1 | 12.06 | 12.06 | 451700.0 |
| 2005-12-07 | BBH | ETF | 68.8333 | 69.0 | 67.55 | 68.1933 | 2254500.0 |
| 2005-12-07 | BCM | ETF | 65.4 | 65.84 | 65.23 | 65.55 | 33400.0 |
| 2005-12-07 | BITS | ETF | 13.72 | 13.72 | 13.44 | 13.48 | 1550.0 |
| 2005-12-07 | BKF | ETF | 20.4 | 21.13 | 20.11 | 20.12 | 57400.0 |
| 2005-12-07 | BNE | ETF | 15.11 | 15.32 | 14.9 | 15.0 | 121300.0 |
| 2005-12-07 | BRF | ETF | 15.1 | 15.18 | 15.05 | 15.18 | 14800.0 |
| 2005-12-07 | BTF | ETF | 87.6 | 87.65 | 87.10000000000001 | 87.2 | 1640.0 |
| 2005-12-07 | CBON | ETF | 31.0 | 31.16 | 31.0 | 31.1 | 55037.0 |
| 2005-12-07 | CDL | ETF | 13.62 | 13.68 | 13.47 | 13.48 | 259300.0 |
| 2005-12-07 | CEF | ETF | 6.4 | 6.49 | 6.4 | 6.45 | 499000.0 |
| 2005-12-07 | CGO | ETF | 13.38 | 13.68 | 13.34 | 13.45 | 50400.0 |
| 2005-12-07 | CHB | ETF | 14.58 | 14.58 | 14.08 | 14.4 | 780600.0 |
| 2005-12-07 | CHI | ETF | 20.42 | 20.42 | 20.1 | 20.18 | 85600.0 |
| 2005-12-07 | CHIC | ETF | 19.2 | 20.24 | 19.13 | 19.67 | 462652.0 |
| 2005-12-07 | CHIR | ETF | 44.46 | 44.5899 | 44.4534 | 44.49 | 1224840.0 |
| 2005-12-07 | CHY | ETF | 15.95 | 15.95 | 15.64 | 15.67 | 158100.0 |
| 2005-12-07 | CIL | ETF | 25.15 | 25.25 | 25.13 | 25.13 | 3100.0 |
| 2005-12-07 | CIZ | ETF | 21.8 | 21.8 | 21.8 | 21.8 | 300.0 |
| 2005-12-07 | CN | ETF | 31.3 | 31.5 | 31.27 | 31.44 | 3100.0 |
| 2005-12-07 | CNXT | ETF | 2.61 | 2.65 | 2.55 | 2.65 | 9562448.0 |
| 2005-12-07 | COMB | ETF | 8.55 | 8.55 | 8.55 | 8.55 | 500.0 |
| 2005-12-07 | CPI | ETF | 27.38 | 27.6 | 27.3 | 27.55 | 2200.0 |
| 2005-12-07 | CPST | ETF | 3.81 | 3.84 | 3.65 | 3.7 | 4239529.0 |
| 2005-12-07 | CSA | ETF | 16.7 | 16.7 | 16.55 | 16.6 | 30600.0 |
| 2005-12-07 | CSB | ETF | 29.87 | 30.15 | 29.8 | 29.89 | 27900.0 |
| 2005-12-07 | CSQ | ETF | 13.05 | 13.0899 | 13.0 | 13.07 | 508700.0 |
| 2005-12-07 | CTEC | ETF | 53.49999999999999 | 53.49999999999999 | 49.55 | 50.55 | 6755.6 |
| 2005-12-07 | CURE | ETF | 0.0187 | 0.03 | 0.0187 | 0.0288 | 13858768.0 |
| 2005-12-07 | CYB | ETF | 3.71 | 3.71 | 3.68 | 3.68 | 3000.0 |
| 2005-12-07 | DGT | ETF | 65.8 | 65.82 | 65.36 | 65.47 | 2500.0 |
| 2005-12-07 | DIG | ETF | 15.0 | 15.575 | 15.0 | 15.575 | 12080.0 |
| 2005-12-07 | DIV | ETF | 12.0 | 12.02 | 11.94 | 12.01 | 31700.0 |
| 2005-12-07 | DRIV | ETF | 29.09 | 29.92 | 28.05 | 29.74 | 1729448.0 |
| 2005-12-07 | DUSA | ETF | 10.42 | 10.42 | 10.18 | 10.18 | 140069.0 |
> showing 50 of 293 rows — these rows as CSV