PREVIEW / etf_daily / 2006-10-02
file: by_date/etf_daily/2006/2006-10-02.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-10-02 | SPY | ETF | 133.54 | 133.83 | 132.95 | 133.08 | 51687400.0 |
| 2006-10-02 | QQQ | ETF | 40.6 | 40.7 | 40.08 | 40.14 | 97150512.0 |
| 2006-10-02 | IWM | ETF | 71.97 | 72.21 | 71.14 | 71.32 | 42184900.0 |
| 2006-10-02 | DIA | ETF | 116.75 | 117.2 | 116.47 | 116.62 | 7034700.0 |
| 2006-10-02 | GLD | ETF | 59.8 | 59.88 | 59.03 | 59.15 | 2018800.0 |
| 2006-10-02 | TLT | ETF | 89.1 | 89.45 | 88.97 | 89.3 | 1211900.0 |
| 2006-10-02 | AAA | ETF | 55.77 | 55.9 | 55.59 | 55.75 | 18500.0 |
| 2006-10-02 | ADRE | ETF | 32.84 | 32.84 | 32.29 | 32.37 | 88524.0 |
| 2006-10-02 | AGG | ETF | 99.74 | 99.95 | 99.7 | 99.84 | 174200.0 |
| 2006-10-02 | AIQ | ETF | 39.15 | 39.4 | 38.25 | 38.5 | 7160.0 |
| 2006-10-02 | AIS | ETF | 1.1 | 1.1 | 1.05 | 1.06 | 33800.0 |
| 2006-10-02 | ARB | ETF | 36.85 | 37.2696 | 36.65 | 37.0 | 188500.0 |
| 2006-10-02 | BAB | ETF | 80.7 | 81.8 | 80.66 | 81.74 | 64000.0 |
| 2006-10-02 | BBC | ETF | 9.1 | 9.19 | 8.53 | 8.81 | 532100.0 |
| 2006-10-02 | BBH | ETF | 61.2933 | 62.0133 | 60.9 | 61.0967 | 1470900.0 |
| 2006-10-02 | BITS | ETF | 38.76 | 41.48 | 37.32 | 41.0 | 140071.0 |
| 2006-10-02 | BNE | ETF | 14.21 | 14.49 | 14.07 | 14.42 | 165600.0 |
| 2006-10-02 | BOSS | ETF | 35.3 | 35.3 | 35.3 | 35.3 | 300.0 |
| 2006-10-02 | BRF | ETF | 14.26 | 14.3 | 14.14 | 14.29 | 59200.0 |
| 2006-10-02 | BTF | ETF | 95.64999999999999 | 95.85000000000001 | 95.64999999999999 | 95.85000000000001 | 500.0 |
| 2006-10-02 | CBON | ETF | 30.64 | 30.8 | 30.42 | 30.72 | 92204.0 |
| 2006-10-02 | CDL | ETF | 9.42 | 9.6 | 9.4 | 9.54 | 311400.0 |
| 2006-10-02 | CEF | ETF | 8.55 | 8.55 | 8.3 | 8.3 | 306400.0 |
| 2006-10-02 | CFO | ETF | 9.9 | 9.9 | 9.9 | 9.9 | 600.0 |
| 2006-10-02 | CGO | ETF | 15.26 | 15.33 | 15.22 | 15.33 | 15100.0 |
| 2006-10-02 | CHB | ETF | 6.93 | 7.07 | 6.73 | 6.93 | 1122000.0 |
| 2006-10-02 | CHI | ETF | 19.63 | 19.6999 | 19.55 | 19.59 | 96400.0 |
| 2006-10-02 | CHIC | ETF | 27.25 | 27.28 | 26.38 | 26.57 | 967668.0 |
| 2006-10-02 | CHY | ETF | 16.89 | 16.9 | 16.77 | 16.86 | 82400.0 |
| 2006-10-02 | CIZ | ETF | 22.65 | 22.65 | 22.65 | 22.65 | 200.0 |
| 2006-10-02 | CN | ETF | 35.98 | 36.16 | 35.86 | 36.0 | 26300.0 |
| 2006-10-02 | CNXT | ETF | 1.99 | 2.0 | 1.88 | 1.92 | 14372562.0 |
| 2006-10-02 | COMB | ETF | 9.95 | 10.0 | 9.95 | 10.0 | 8250.0 |
| 2006-10-02 | CPI | ETF | 23.95 | 23.95 | 23.55 | 23.55 | 700.0 |
| 2006-10-02 | CPST | ETF | 1.42 | 1.59 | 1.4 | 1.55 | 4169949.0 |
| 2006-10-02 | CSA | ETF | 20.8 | 20.98 | 20.8 | 20.95 | 25200.0 |
| 2006-10-02 | CSB | ETF | 30.53 | 30.67 | 30.45 | 30.57 | 10400.0 |
| 2006-10-02 | CSQ | ETF | 14.81 | 14.82 | 14.73 | 14.78 | 241100.0 |
| 2006-10-02 | CTEC | ETF | 60.199999999999996 | 61.6 | 59.800000000000004 | 61.6 | 11481.800000000001 |
| 2006-10-02 | CVY | ETF | 25.12 | 26.0 | 25.05 | 25.07 | 63700.0 |
| 2006-10-02 | CYB | ETF | 6.65 | 6.75 | 6.61 | 6.72 | 62800.0 |
| 2006-10-02 | DBC | ETF | 24.0 | 24.11 | 23.6 | 23.69 | 170700.0 |
| 2006-10-02 | DBV | ETF | 25.0 | 25.03 | 24.9502 | 25.01 | 15100.0 |
| 2006-10-02 | DDM | ETF | 6.5667 | 6.6217 | 6.5417 | 6.5692 | 700800.0 |
| 2006-10-02 | DES | ETF | 17.9 | 17.9667 | 17.7567 | 17.8167 | 58200.0 |
| 2006-10-02 | DEW | ETF | 55.88 | 56.07 | 55.6 | 55.78 | 1100.0 |
| 2006-10-02 | DFE | ETF | 56.47 | 56.5 | 56.23 | 56.23 | 3600.0 |
| 2006-10-02 | DFJ | ETF | 50.4 | 50.69 | 50.4 | 50.52 | 2800.0 |
| 2006-10-02 | DGT | ETF | 71.65 | 71.8 | 71.42 | 71.55 | 39600.0 |
| 2006-10-02 | DHS | ETF | 55.13 | 55.2 | 54.91 | 55.0 | 16300.0 |
> showing 50 of 362 rows — these rows as CSV