PREVIEW / etf_daily / 2006-08-28
file: by_date/etf_daily/2006/2006-08-28.parquet size: 18 KB rows: 362
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-08-28 | SPY | ETF | 129.65 | 130.82 | 129.64 | 130.43 | 52681500.0 |
| 2006-08-28 | QQQ | ETF | 38.28 | 38.79 | 38.24 | 38.61 | 80085884.0 |
| 2006-08-28 | IWM | ETF | 69.54 | 70.47 | 69.52 | 70.34 | 26650300.0 |
| 2006-08-28 | DIA | ETF | 112.74 | 113.87 | 112.73 | 113.44 | 3875800.0 |
| 2006-08-28 | GLD | ETF | 61.8 | 61.8 | 60.83 | 61.0 | 3584600.0 |
| 2006-08-28 | TLT | ETF | 87.41 | 87.52 | 87.24 | 87.52 | 582300.0 |
| 2006-08-28 | AAA | ETF | 57.6 | 57.95 | 57.55 | 57.85 | 5300.0 |
| 2006-08-28 | ADRE | ETF | 31.91 | 32.21 | 31.73 | 32.14 | 121889.0 |
| 2006-08-28 | AFK | ETF | 25.35 | 25.4 | 25.35 | 25.4 | 9400.0 |
| 2006-08-28 | AGG | ETF | 99.22 | 99.4 | 99.18 | 99.23 | 294200.0 |
| 2006-08-28 | AIQ | ETF | 32.5 | 32.5 | 31.85 | 32.1 | 11220.0 |
| 2006-08-28 | AIS | ETF | 1.06 | 1.07 | 1.0 | 1.0099 | 234000.0 |
| 2006-08-28 | AOM | ETF | 5.56 | 5.56 | 4.75 | 5.25 | 107700.0 |
| 2006-08-28 | ARB | ETF | 35.78 | 36.1344 | 35.7 | 36.01 | 107700.0 |
| 2006-08-28 | BAB | ETF | 74.99 | 75.84 | 74.92 | 75.68 | 96500.0 |
| 2006-08-28 | BBC | ETF | 12.2 | 12.23 | 11.51 | 11.9 | 250500.0 |
| 2006-08-28 | BBH | ETF | 59.2667 | 59.74 | 58.9133 | 59.45 | 453000.0 |
| 2006-08-28 | BITS | ETF | 28.72 | 29.88 | 28.28 | 28.6 | 23857.0 |
| 2006-08-28 | BKF | ETF | 3.97 | 3.99 | 3.966 | 3.98 | 4800.0 |
| 2006-08-28 | BNE | ETF | 14.59 | 14.94 | 14.57 | 14.85 | 127600.0 |
| 2006-08-28 | BRF | ETF | 14.1 | 14.1 | 14.1 | 14.1 | 700.0 |
| 2006-08-28 | BTF | ETF | 90.89999999999999 | 91.44999999999999 | 90.8125 | 91.3 | 3000.0 |
| 2006-08-28 | CBON | ETF | 33.82 | 33.96 | 33.75 | 33.91 | 18647.0 |
| 2006-08-28 | CDL | ETF | 8.69 | 8.74 | 8.61 | 8.64 | 227900.0 |
| 2006-08-28 | CEF | ETF | 8.93 | 8.98 | 8.8 | 8.81 | 267500.0 |
| 2006-08-28 | CEW | ETF | 26.36 | 26.44 | 26.36 | 26.44 | 500.0 |
| 2006-08-28 | CFO | ETF | 10.11 | 10.11 | 10.1 | 10.1 | 3300.0 |
| 2006-08-28 | CGO | ETF | 15.34 | 15.44 | 15.26 | 15.44 | 25600.0 |
| 2006-08-28 | CHB | ETF | 6.07 | 6.25 | 6.0001 | 6.16 | 796100.0 |
| 2006-08-28 | CHI | ETF | 20.27 | 20.33 | 20.18 | 20.22 | 154700.0 |
| 2006-08-28 | CHIC | ETF | 26.7 | 27.23 | 26.39 | 26.79 | 232964.0 |
| 2006-08-28 | CHY | ETF | 16.45 | 16.48 | 16.37 | 16.48 | 151000.0 |
| 2006-08-28 | CIZ | ETF | 22.15 | 22.2 | 22.15 | 22.2 | 200.0 |
| 2006-08-28 | CN | ETF | 33.94 | 33.9501 | 33.53 | 33.69 | 68700.0 |
| 2006-08-28 | CNXT | ETF | 2.131 | 2.14 | 2.05 | 2.08 | 17402024.0 |
| 2006-08-28 | COMB | ETF | 9.92 | 10.15 | 9.92 | 10.15 | 5499.0 |
| 2006-08-28 | CPI | ETF | 29.3 | 29.3 | 29.3 | 29.3 | 400.0 |
| 2006-08-28 | CPST | ETF | 1.92 | 1.93 | 1.86 | 1.88 | 469770.0 |
| 2006-08-28 | CSA | ETF | 18.94 | 19.36 | 18.94 | 19.36 | 7300.0 |
| 2006-08-28 | CSB | ETF | 28.46 | 28.6 | 28.41 | 28.57 | 10300.0 |
| 2006-08-28 | CSQ | ETF | 14.36 | 14.48 | 14.3 | 14.48 | 377500.0 |
| 2006-08-28 | CTEC | ETF | 53.8 | 55.49999999999999 | 53.8 | 54.45 | 22939.2 |
| 2006-08-28 | CYB | ETF | 5.85 | 6.05 | 5.8299 | 5.9726 | 143200.0 |
| 2006-08-28 | DBC | ETF | 24.94 | 25.03 | 24.57 | 24.67 | 354700.0 |
| 2006-08-28 | DDM | ETF | 6.1717 | 6.2767 | 6.165 | 6.2383 | 639600.0 |
| 2006-08-28 | DES | ETF | 17.2667 | 17.3767 | 17.2233 | 17.3667 | 67500.0 |
| 2006-08-28 | DEW | ETF | 55.23 | 55.97 | 55.23 | 55.5 | 25000.0 |
| 2006-08-28 | DFE | ETF | 54.34 | 54.64 | 54.34 | 54.49 | 9600.0 |
| 2006-08-28 | DFJ | ETF | 50.51 | 50.8 | 50.42 | 50.61 | 1200.0 |
| 2006-08-28 | DGT | ETF | 71.1 | 71.45 | 70.95 | 71.34 | 7900.0 |
> showing 50 of 362 rows — these rows as CSV