PREVIEW / etf_daily / 2006-08-18
file: by_date/etf_daily/2006/2006-08-18.parquet size: 18 KB rows: 359
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-18 | SPY | ETF | 130.19 | 130.69 | 129.59 | 130.69 | 58288400.0 |
| 2006-08-18 | QQQ | ETF | 38.65 | 38.83 | 38.28 | 38.79 | 97774825.0 |
| 2006-08-18 | IWM | ETF | 70.8 | 70.94 | 70.01 | 70.94 | 36413600.0 |
| 2006-08-18 | DIA | ETF | 113.45 | 113.8 | 113.08 | 113.8 | 3983200.0 |
| 2006-08-18 | GLD | ETF | 61.49 | 61.5 | 60.3 | 61.04 | 6418400.0 |
| 2006-08-18 | TLT | ETF | 86.72 | 86.91 | 86.65 | 86.77 | 1050700.0 |
| 2006-08-18 | AAA | ETF | 57.32 | 57.38 | 56.97 | 57.31 | 2700.0 |
| 2006-08-18 | ADRE | ETF | 32.64 | 32.6845 | 32.3448 | 32.63 | 188114.0 |
| 2006-08-18 | AFK | ETF | 25.27 | 25.3 | 25.19 | 25.3 | 8900.0 |
| 2006-08-18 | AGG | ETF | 99.12 | 99.16 | 98.99 | 99.01 | 449000.0 |
| 2006-08-18 | AIQ | ETF | 32.75 | 32.95 | 32.0 | 32.1 | 11140.0 |
| 2006-08-18 | AIS | ETF | 0.89 | 0.9 | 0.86 | 0.9 | 135200.0 |
| 2006-08-18 | AOM | ETF | 5.7401 | 5.81 | 5.74 | 5.7899 | 7100.0 |
| 2006-08-18 | ARB | ETF | 36.33 | 36.33 | 35.64 | 35.86 | 56500.0 |
| 2006-08-18 | BAB | ETF | 74.35 | 74.96 | 74.31 | 74.9 | 74000.0 |
| 2006-08-18 | BBC | ETF | 12.56 | 12.64 | 12.26 | 12.41 | 160500.0 |
| 2006-08-18 | BBH | ETF | 60.01 | 60.01 | 59.4433 | 59.67 | 934800.0 |
| 2006-08-18 | BITS | ETF | 26.0 | 27.28 | 25.92 | 27.16 | 26960.0 |
| 2006-08-18 | BKF | ETF | 3.99 | 4.05 | 3.99 | 4.01 | 46400.0 |
| 2006-08-18 | BNE | ETF | 15.62 | 15.64 | 15.35 | 15.4 | 110000.0 |
| 2006-08-18 | BRF | ETF | 14.15 | 14.15 | 14.07 | 14.1 | 14800.0 |
| 2006-08-18 | BTF | ETF | 90.64999999999999 | 91.14999999999999 | 90.64999999999999 | 91.14999999999999 | 5680.0 |
| 2006-08-18 | CBON | ETF | 33.4 | 33.54 | 33.09 | 33.4 | 65720.0 |
| 2006-08-18 | CDL | ETF | 8.79 | 8.85 | 8.74 | 8.75 | 200600.0 |
| 2006-08-18 | CEF | ETF | 8.83 | 8.9 | 8.77 | 8.82 | 220500.0 |
| 2006-08-18 | CFO | ETF | 9.97 | 9.97 | 9.97 | 9.97 | 1000.0 |
| 2006-08-18 | CGO | ETF | 15.47 | 15.66 | 15.47 | 15.56 | 34600.0 |
| 2006-08-18 | CHB | ETF | 6.24 | 6.26 | 6.0 | 6.14 | 689400.0 |
| 2006-08-18 | CHI | ETF | 20.31 | 20.41 | 20.3 | 20.41 | 67900.0 |
| 2006-08-18 | CHIC | ETF | 27.36 | 27.5 | 26.87 | 27.35 | 192687.0 |
| 2006-08-18 | CHY | ETF | 16.38 | 16.46 | 16.34 | 16.46 | 142600.0 |
| 2006-08-18 | CIL | ETF | 25.52 | 25.52 | 25.52 | 25.52 | 400.0 |
| 2006-08-18 | CN | ETF | 36.78 | 36.94 | 36.35 | 36.55 | 39600.0 |
| 2006-08-18 | CNXT | ETF | 2.07 | 2.2 | 2.02 | 2.18 | 22210566.0 |
| 2006-08-18 | COMB | ETF | 9.9 | 9.94 | 9.81 | 9.89 | 93800.0 |
| 2006-08-18 | CPST | ETF | 2.05 | 2.05 | 1.94 | 2.0 | 942108.0 |
| 2006-08-18 | CSA | ETF | 18.5 | 18.5 | 18.32 | 18.5 | 15600.0 |
| 2006-08-18 | CSB | ETF | 28.86 | 28.95 | 28.66 | 28.95 | 17000.0 |
| 2006-08-18 | CSQ | ETF | 14.33 | 14.45 | 14.33 | 14.45 | 419400.0 |
| 2006-08-18 | CTEC | ETF | 54.699999999999996 | 55.55 | 54.5 | 55.05 | 5911.400000000001 |
| 2006-08-18 | CYB | ETF | 5.7 | 5.84 | 5.7 | 5.8 | 25700.0 |
| 2006-08-18 | DBC | ETF | 24.83 | 24.85 | 24.558 | 24.81 | 180900.0 |
| 2006-08-18 | DDM | ETF | 6.2417 | 6.2717 | 6.2067 | 6.2667 | 705600.0 |
| 2006-08-18 | DES | ETF | 17.4467 | 17.4933 | 17.3667 | 17.4733 | 26700.0 |
| 2006-08-18 | DEW | ETF | 54.25 | 54.33 | 54.17 | 54.33 | 1500.0 |
| 2006-08-18 | DFE | ETF | 55.0 | 55.15 | 55.0 | 55.15 | 7500.0 |
| 2006-08-18 | DFJ | ETF | 51.97 | 52.11 | 51.97 | 52.11 | 4400.0 |
| 2006-08-18 | DGT | ETF | 70.7 | 71.0 | 70.52 | 70.98 | 6500.0 |
| 2006-08-18 | DHS | ETF | 53.5 | 53.66 | 53.4 | 53.66 | 9000.0 |
| 2006-08-18 | DIM | ETF | 55.28 | 55.28 | 55.27 | 55.28 | 1700.0 |
> showing 50 of 359 rows — these rows as CSV