PREVIEW / etf_daily / 2006-07-24
file: by_date/etf_daily/2006/2006-07-24.parquet size: 18 KB rows: 356
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-07-24 | SPY | ETF | 124.44 | 126.32 | 124.44 | 126.21 | 92884000.0 |
| 2006-07-24 | QQQ | ETF | 35.85 | 36.4301 | 35.8 | 36.41 | 130301523.0 |
| 2006-07-24 | IWM | ETF | 67.26 | 68.91 | 67.25 | 68.88 | 72230300.0 |
| 2006-07-24 | DIA | ETF | 109.0 | 110.6 | 109.0 | 110.5 | 9628100.0 |
| 2006-07-24 | GLD | ETF | 60.63 | 61.23 | 59.83 | 61.14 | 7281000.0 |
| 2006-07-24 | TLT | ETF | 85.41 | 85.51 | 85.21 | 85.28 | 393900.0 |
| 2006-07-24 | AAA | ETF | 54.45 | 54.85 | 54.4 | 54.79 | 6000.0 |
| 2006-07-24 | ADRE | ETF | 30.24 | 31.09 | 30.24 | 31.02 | 734458.0 |
| 2006-07-24 | AFK | ETF | 24.98 | 25.03 | 24.98 | 25.01 | 1900.0 |
| 2006-07-24 | AGG | ETF | 98.08 | 98.21 | 98.05 | 98.17 | 172500.0 |
| 2006-07-24 | AIQ | ETF | 29.35 | 31.0 | 29.05 | 30.45 | 16660.0 |
| 2006-07-24 | AIS | ETF | 1.16 | 1.16 | 1.03 | 1.08 | 80700.0 |
| 2006-07-24 | AOM | ETF | 6.5 | 6.5 | 6.5 | 6.5 | 7400.0 |
| 2006-07-24 | ARB | ETF | 36.0 | 36.48 | 35.93 | 36.22 | 108600.0 |
| 2006-07-24 | BAB | ETF | 68.78 | 69.24 | 68.41 | 68.57 | 98200.0 |
| 2006-07-24 | BBC | ETF | 12.5 | 12.98 | 12.07 | 12.26 | 134500.0 |
| 2006-07-24 | BBH | ETF | 56.87 | 58.3033 | 56.87 | 58.0833 | 2086500.0 |
| 2006-07-24 | BITS | ETF | 17.8404 | 19.4 | 17.44 | 18.08 | 9157.0 |
| 2006-07-24 | BKF | ETF | 5.38 | 5.4 | 5.26 | 5.27 | 32400.0 |
| 2006-07-24 | BNE | ETF | 13.31 | 13.6 | 13.31 | 13.56 | 117300.0 |
| 2006-07-24 | BRF | ETF | 14.02 | 14.02 | 13.97 | 13.99 | 1400.0 |
| 2006-07-24 | BTF | ETF | 86.4 | 86.89999999999999 | 86.14999999999999 | 86.54999999999998 | 480.0 |
| 2006-07-24 | CBON | ETF | 32.32 | 32.49 | 32.25 | 32.47 | 57288.0 |
| 2006-07-24 | CDL | ETF | 8.9 | 8.93 | 8.75 | 8.85 | 118000.0 |
| 2006-07-24 | CEF | ETF | 8.45 | 8.53 | 8.41 | 8.5 | 408400.0 |
| 2006-07-24 | CEW | ETF | 25.9 | 25.9 | 25.9 | 25.9 | 9000.0 |
| 2006-07-24 | CFO | ETF | 9.75 | 9.75 | 9.75 | 9.75 | 1000.0 |
| 2006-07-24 | CGO | ETF | 14.83 | 14.83 | 14.53 | 14.65 | 30600.0 |
| 2006-07-24 | CHB | ETF | 8.36 | 8.7 | 8.29 | 8.6 | 1484100.0 |
| 2006-07-24 | CHI | ETF | 19.53 | 19.75 | 19.53 | 19.72 | 88300.0 |
| 2006-07-24 | CHIC | ETF | 24.5 | 25.5 | 24.45 | 25.49 | 734356.0 |
| 2006-07-24 | CHY | ETF | 16.0 | 16.13 | 16.0 | 16.08 | 112500.0 |
| 2006-07-24 | CIL | ETF | 25.2 | 25.2 | 25.2 | 25.2 | 200.0 |
| 2006-07-24 | CIZ | ETF | 22.1 | 22.1 | 22.1 | 22.1 | 400.0 |
| 2006-07-24 | CN | ETF | 36.25 | 36.56 | 35.97 | 36.1 | 294200.0 |
| 2006-07-24 | CNXT | ETF | 1.9 | 2.05 | 1.86 | 2.0 | 10384552.0 |
| 2006-07-24 | COMB | ETF | 9.79 | 9.8 | 9.51 | 9.71 | 15800.0 |
| 2006-07-24 | CPST | ETF | 2.05 | 2.15 | 1.99 | 2.12 | 1520040.0 |
| 2006-07-24 | CSA | ETF | 18.69 | 19.2 | 18.4 | 18.8 | 19500.0 |
| 2006-07-24 | CSB | ETF | 26.96 | 27.19 | 26.96 | 27.15 | 11300.0 |
| 2006-07-24 | CSQ | ETF | 13.98 | 14.08 | 13.95 | 14.08 | 401700.0 |
| 2006-07-24 | CTEC | ETF | 59.4 | 61.5 | 59.1 | 60.0 | 14683.800000000001 |
| 2006-07-24 | CYB | ETF | 5.53 | 5.53 | 5.33 | 5.36 | 77500.0 |
| 2006-07-24 | DBC | ETF | 25.37 | 25.6 | 25.11 | 25.6 | 214300.0 |
| 2006-07-24 | DDM | ETF | 5.8075 | 5.9167 | 5.7767 | 5.9058 | 2084400.0 |
| 2006-07-24 | DES | ETF | 16.92 | 17.1533 | 16.92 | 17.1533 | 12300.0 |
| 2006-07-24 | DEW | ETF | 51.32 | 51.88 | 51.32 | 51.88 | 2300.0 |
| 2006-07-24 | DFJ | ETF | 48.11 | 48.11 | 48.1 | 48.1 | 1600.0 |
| 2006-07-24 | DGT | ETF | 66.85 | 67.58 | 66.85 | 67.32 | 1700.0 |
| 2006-07-24 | DHS | ETF | 51.55 | 52.03 | 51.52 | 52.01 | 16000.0 |
> showing 50 of 356 rows — these rows as CSV