PREVIEW / etf_daily / 2006-11-22
file: by_date/etf_daily/2006/2006-11-22.parquet size: 19 KB rows: 383
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-11-22 | SPY | ETF | 140.75 | 141.16 | 140.5 | 140.92 | 45505300.0 |
| 2006-11-22 | QQQ | ETF | 44.58 | 44.75 | 44.26 | 44.73 | 69877362.0 |
| 2006-11-22 | IWM | ETF | 78.97 | 79.11 | 78.56 | 78.92 | 33281900.0 |
| 2006-11-22 | DIA | ETF | 123.23 | 123.51 | 122.93 | 123.25 | 3947300.0 |
| 2006-11-22 | GLD | ETF | 62.64 | 63.07 | 62.25 | 62.5 | 4863600.0 |
| 2006-11-22 | TLT | ETF | 90.36 | 90.51 | 90.27 | 90.46 | 770300.0 |
| 2006-11-22 | AAA | ETF | 57.95 | 58.13 | 57.75 | 58.07 | 2700.0 |
| 2006-11-22 | ADRE | ETF | 36.37 | 36.531 | 36.26 | 36.48 | 66213.0 |
| 2006-11-22 | AGG | ETF | 100.47 | 100.68 | 100.45 | 100.66 | 274000.0 |
| 2006-11-22 | AIQ | ETF | 29.9 | 30.7 | 29.4 | 30.5 | 220220.0 |
| 2006-11-22 | AIS | ETF | 1.16 | 1.2 | 1.16 | 1.19 | 50200.0 |
| 2006-11-22 | ARB | ETF | 44.98 | 44.99 | 44.5 | 44.62 | 149000.0 |
| 2006-11-22 | BAB | ETF | 93.74 | 94.48 | 93.21 | 93.9 | 58000.0 |
| 2006-11-22 | BBC | ETF | 5.77 | 5.77 | 5.25 | 5.4 | 720000.0 |
| 2006-11-22 | BBH | ETF | 62.45 | 62.7767 | 62.3967 | 62.73 | 180900.0 |
| 2006-11-22 | BITS | ETF | 35.08 | 35.76 | 34.6 | 35.76 | 18137.0 |
| 2006-11-22 | BNE | ETF | 15.78 | 15.96 | 15.61 | 15.88 | 142800.0 |
| 2006-11-22 | BRF | ETF | 14.31 | 14.31 | 14.22 | 14.27 | 11400.0 |
| 2006-11-22 | BTF | ETF | 106.3 | 106.95 | 106.19999999999999 | 106.95 | 3860.0 |
| 2006-11-22 | CBON | ETF | 30.53 | 30.53 | 30.03 | 30.19 | 17222.0 |
| 2006-11-22 | CDL | ETF | 9.87 | 9.99 | 9.76 | 9.78 | 298000.0 |
| 2006-11-22 | CEF | ETF | 9.27 | 9.38 | 9.2 | 9.37 | 506100.0 |
| 2006-11-22 | CFO | ETF | 10.85 | 10.85 | 10.65 | 10.85 | 13900.0 |
| 2006-11-22 | CGO | ETF | 16.22 | 16.25 | 15.85 | 16.03 | 30600.0 |
| 2006-11-22 | CHB | ETF | 9.16 | 9.38 | 9.1 | 9.17 | 799300.0 |
| 2006-11-22 | CHI | ETF | 19.77 | 19.84 | 19.66 | 19.72 | 118500.0 |
| 2006-11-22 | CHIC | ETF | 28.9 | 29.6 | 28.5 | 29.33 | 657334.0 |
| 2006-11-22 | CHY | ETF | 17.05 | 17.07 | 16.84 | 16.89 | 150200.0 |
| 2006-11-22 | CIL | ETF | 25.94 | 25.94 | 25.94 | 25.94 | 200.0 |
| 2006-11-22 | CN | ETF | 38.6 | 38.97 | 38.53 | 38.95 | 41200.0 |
| 2006-11-22 | CNXT | ETF | 2.22 | 2.2702 | 2.22 | 2.25 | 6977464.0 |
| 2006-11-22 | CPST | ETF | 1.3 | 1.34 | 1.3 | 1.32 | 738034.0 |
| 2006-11-22 | CSA | ETF | 21.32 | 21.35 | 21.15 | 21.3 | 30300.0 |
| 2006-11-22 | CSB | ETF | 31.75 | 31.9 | 31.75 | 31.9 | 9500.0 |
| 2006-11-22 | CSM | ETF | 1.3225 | 1.325 | 1.3225 | 1.325 | 8000.0 |
| 2006-11-22 | CSQ | ETF | 15.12 | 15.35 | 15.09 | 15.27 | 714300.0 |
| 2006-11-22 | CTEC | ETF | 90.74999999999999 | 91.25 | 90.15 | 90.74999999999999 | 11827.0 |
| 2006-11-22 | CVY | ETF | 26.44 | 26.44 | 26.3 | 26.36 | 79600.0 |
| 2006-11-22 | DBC | ETF | 24.85 | 24.93 | 24.42 | 24.75 | 170700.0 |
| 2006-11-22 | DBV | ETF | 25.43 | 25.43 | 25.22 | 25.31 | 133000.0 |
| 2006-11-22 | DDM | ETF | 7.325 | 7.3583 | 7.2958 | 7.3275 | 582000.0 |
| 2006-11-22 | DES | ETF | 19.25 | 19.2767 | 19.1533 | 19.2067 | 74400.0 |
| 2006-11-22 | DEW | ETF | 59.92 | 60.05 | 59.75 | 59.97 | 6400.0 |
| 2006-11-22 | DFE | ETF | 61.2 | 61.29 | 61.19 | 61.29 | 14200.0 |
| 2006-11-22 | DFJ | ETF | 47.72 | 47.77 | 47.52 | 47.7 | 51500.0 |
| 2006-11-22 | DGT | ETF | 74.8 | 74.91 | 74.64 | 74.81 | 29200.0 |
| 2006-11-22 | DHS | ETF | 56.75 | 56.92 | 56.69 | 56.81 | 17000.0 |
| 2006-11-22 | DIM | ETF | 60.53 | 60.64 | 60.47 | 60.6 | 8300.0 |
| 2006-11-22 | DIV | ETF | 13.27 | 13.34 | 13.25 | 13.3 | 6100.0 |
| 2006-11-22 | DJP | ETF | 49.57 | 49.64 | 49.05 | 49.32 | 238400.0 |
> showing 50 of 383 rows — these rows as CSV