PREVIEW / etf_daily / 2006-06-02
file: by_date/etf_daily/2006/2006-06-02.parquet size: 17 KB rows: 323
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-06-02 | SPY | ETF | 129.25 | 129.43 | 128.32 | 129.0 | 91702600.0 |
| 2006-06-02 | QQQ | ETF | 39.97 | 40.0 | 39.31 | 39.642 | 128865492.0 |
| 2006-06-02 | IWM | ETF | 73.74 | 73.84 | 72.68 | 73.22 | 49690000.0 |
| 2006-06-02 | DIA | ETF | 112.76 | 112.85 | 111.88 | 112.36 | 6554400.0 |
| 2006-06-02 | GLD | ETF | 63.1 | 63.59 | 62.53 | 63.5 | 6958900.0 |
| 2006-06-02 | TLT | ETF | 84.72 | 84.89 | 84.5 | 84.79 | 2041900.0 |
| 2006-06-02 | AAA | ETF | 59.86 | 60.01 | 59.63 | 59.97 | 18800.0 |
| 2006-06-02 | ADRE | ETF | 128.49 | 128.49 | 125.87 | 127.21 | 52644.0 |
| 2006-06-02 | AFK | ETF | 25.2 | 25.35 | 25.2 | 25.35 | 5400.0 |
| 2006-06-02 | AGG | ETF | 98.15 | 98.28 | 98.0 | 98.27 | 115500.0 |
| 2006-06-02 | AIQ | ETF | 30.0 | 30.5 | 29.85 | 30.45 | 11640.0 |
| 2006-06-02 | AIS | ETF | 1.35 | 1.37 | 1.32 | 1.32 | 223300.0 |
| 2006-06-02 | AOM | ETF | 7.17 | 7.33 | 7.15 | 7.29 | 11000.0 |
| 2006-06-02 | ARB | ETF | 40.41 | 40.6 | 39.83 | 40.02 | 317200.0 |
| 2006-06-02 | BAB | ETF | 65.63 | 65.73 | 64.91 | 65.53 | 55800.0 |
| 2006-06-02 | BBC | ETF | 11.25 | 11.25 | 10.5 | 10.63 | 319300.0 |
| 2006-06-02 | BBH | ETF | 60.33 | 60.67 | 58.6967 | 59.67 | 1821000.0 |
| 2006-06-02 | BCM | ETF | 72.0 | 72.16 | 71.09 | 71.48 | 32900.0 |
| 2006-06-02 | BITS | ETF | 25.64 | 25.96 | 24.36 | 25.72 | 33220.0 |
| 2006-06-02 | BKF | ETF | 7.27 | 7.45 | 7.0 | 7.01 | 48100.0 |
| 2006-06-02 | BNE | ETF | 14.95 | 14.96 | 14.63 | 14.89 | 128000.0 |
| 2006-06-02 | BRF | ETF | 13.96 | 14.0668 | 13.95 | 14.03 | 25100.0 |
| 2006-06-02 | BTF | ETF | 89.04999999999998 | 89.19999999999999 | 89.04999999999998 | 89.04999999999998 | 1040.0 |
| 2006-06-02 | CBON | ETF | 31.75 | 31.75 | 31.42 | 31.5 | 27170.0 |
| 2006-06-02 | CDL | ETF | 9.57 | 9.6 | 9.41 | 9.55 | 230800.0 |
| 2006-06-02 | CEF | ETF | 9.2 | 9.4 | 9.2 | 9.28 | 418400.0 |
| 2006-06-02 | CEW | ETF | 25.48 | 25.75 | 25.48 | 25.75 | 1400.0 |
| 2006-06-02 | CGO | ETF | 14.35 | 14.65 | 14.33 | 14.55 | 54000.0 |
| 2006-06-02 | CHB | ETF | 12.18 | 12.5 | 11.19 | 11.48 | 1460500.0 |
| 2006-06-02 | CHI | ETF | 19.85 | 20.15 | 19.85 | 20.11 | 71000.0 |
| 2006-06-02 | CHIC | ETF | 21.66 | 21.66 | 20.71 | 21.31 | 440953.0 |
| 2006-06-02 | CHY | ETF | 16.77 | 16.8799 | 16.72 | 16.82 | 162500.0 |
| 2006-06-02 | CIL | ETF | 25.18 | 25.18 | 25.18 | 25.18 | 600.0 |
| 2006-06-02 | CN | ETF | 33.82 | 34.1 | 33.4 | 33.92 | 261500.0 |
| 2006-06-02 | CNXT | ETF | 3.02 | 3.05 | 2.83 | 2.86 | 22489502.0 |
| 2006-06-02 | COMB | ETF | 10.21 | 10.25 | 10.15 | 10.25 | 16700.0 |
| 2006-06-02 | CPI | ETF | 32.24 | 32.29 | 32.24 | 32.29 | 4000.0 |
| 2006-06-02 | CPST | ETF | 3.045 | 3.08 | 2.97 | 3.0 | 1622706.0 |
| 2006-06-02 | CSA | ETF | 18.62 | 18.62 | 18.22 | 18.36 | 7900.0 |
| 2006-06-02 | CSB | ETF | 29.12 | 29.47 | 29.1 | 29.16 | 8500.0 |
| 2006-06-02 | CSQ | ETF | 14.04 | 14.13 | 13.97 | 14.08 | 280600.0 |
| 2006-06-02 | CTEC | ETF | 69.64999999999999 | 70.14999999999999 | 69.35 | 70.14999999999999 | 12371.0 |
| 2006-06-02 | CYB | ETF | 6.19 | 6.19 | 5.8501 | 5.97 | 13900.0 |
| 2006-06-02 | DBC | ETF | 25.4 | 25.86 | 25.3 | 25.71 | 349300.0 |
| 2006-06-02 | DGT | ETF | 67.75 | 67.97 | 67.69 | 67.97 | 5600.0 |
| 2006-06-02 | DIG | ETF | 17.875 | 17.875 | 17.875 | 17.875 | 880.0 |
| 2006-06-02 | DIV | ETF | 11.96 | 12.0 | 11.95 | 12.0 | 12800.0 |
| 2006-06-02 | DRIV | ETF | 45.16 | 45.34 | 43.36 | 43.56 | 1409955.0 |
| 2006-06-02 | DUSA | ETF | 5.82 | 5.86 | 5.01 | 5.3 | 311469.0 |
| 2006-06-02 | DVY | ETF | 64.1 | 64.25 | 63.75 | 64.15 | 369500.0 |
> showing 50 of 323 rows — these rows as CSV