PREVIEW / etf_daily / 2006-08-30
file: by_date/etf_daily/2006/2006-08-30.parquet size: 18 KB rows: 361
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-30 | SPY | ETF | 130.87 | 131.04 | 130.55 | 130.66 | 50052200.0 |
| 2006-08-30 | QQQ | ETF | 38.74 | 39.03 | 38.6 | 38.91 | 75714760.0 |
| 2006-08-30 | IWM | ETF | 71.31 | 72.0 | 71.04 | 71.8 | 43890900.0 |
| 2006-08-30 | DIA | ETF | 113.75 | 114.07 | 113.56 | 113.76 | 4297200.0 |
| 2006-08-30 | GLD | ETF | 61.49 | 61.66 | 61.09 | 61.42 | 2901600.0 |
| 2006-08-30 | TLT | ETF | 87.83 | 87.87 | 87.66 | 87.87 | 1180500.0 |
| 2006-08-30 | AAA | ETF | 58.64 | 58.71 | 58.3 | 58.47 | 9100.0 |
| 2006-08-30 | ADRE | ETF | 32.51 | 32.64 | 32.234 | 32.41 | 130629.0 |
| 2006-08-30 | AFK | ETF | 25.31 | 25.39 | 25.31 | 25.38 | 5300.0 |
| 2006-08-30 | AGG | ETF | 99.31 | 99.45 | 99.31 | 99.42 | 146500.0 |
| 2006-08-30 | AIQ | ETF | 32.05 | 32.7 | 32.0 | 32.35 | 25240.0 |
| 2006-08-30 | AIS | ETF | 1.07 | 1.14 | 1.01 | 1.05 | 232700.0 |
| 2006-08-30 | AOM | ETF | 9.0 | 9.9 | 9.0 | 9.9 | 5441800.0 |
| 2006-08-30 | ARB | ETF | 36.8 | 37.43 | 36.72 | 37.25 | 294300.0 |
| 2006-08-30 | BAB | ETF | 77.75 | 77.81 | 77.3 | 77.73 | 58700.0 |
| 2006-08-30 | BBC | ETF | 12.0 | 12.01 | 11.52 | 11.74 | 194800.0 |
| 2006-08-30 | BBH | ETF | 59.8733 | 60.15 | 59.6033 | 59.84 | 669900.0 |
| 2006-08-30 | BITS | ETF | 28.8 | 29.36 | 28.8 | 29.36 | 32196.0 |
| 2006-08-30 | BKF | ETF | 3.98 | 3.98 | 3.91 | 3.95 | 58200.0 |
| 2006-08-30 | BNE | ETF | 15.18 | 15.38 | 15.05 | 15.16 | 187000.0 |
| 2006-08-30 | BRF | ETF | 14.1 | 14.1 | 14.1 | 14.1 | 1500.0 |
| 2006-08-30 | BTF | ETF | 91.5 | 92.05 | 91.5 | 91.8 | 24840.0 |
| 2006-08-30 | CBON | ETF | 33.575 | 34.024 | 33.575 | 34.0 | 13391.0 |
| 2006-08-30 | CDL | ETF | 8.92 | 8.99 | 8.89 | 8.94 | 311900.0 |
| 2006-08-30 | CEF | ETF | 8.87 | 8.92 | 8.78 | 8.82 | 313700.0 |
| 2006-08-30 | CEW | ETF | 25.35 | 25.36 | 25.35 | 25.36 | 800.0 |
| 2006-08-30 | CFO | ETF | 10.1 | 10.1 | 10.05 | 10.05 | 11000.0 |
| 2006-08-30 | CGO | ETF | 15.59 | 15.6 | 15.36 | 15.5 | 28100.0 |
| 2006-08-30 | CHB | ETF | 6.12 | 6.26 | 6.02 | 6.15 | 2234200.0 |
| 2006-08-30 | CHI | ETF | 20.29 | 20.35 | 20.27 | 20.32 | 67800.0 |
| 2006-08-30 | CHIC | ETF | 27.07 | 27.08 | 26.65 | 26.89 | 335692.0 |
| 2006-08-30 | CHY | ETF | 16.57 | 16.68 | 16.52 | 16.68 | 130100.0 |
| 2006-08-30 | CIZ | ETF | 21.8 | 21.8 | 21.55 | 21.55 | 1400.0 |
| 2006-08-30 | CN | ETF | 35.0 | 35.54 | 34.95 | 35.54 | 86900.0 |
| 2006-08-30 | CNXT | ETF | 2.07 | 2.1401 | 2.04 | 2.11 | 15334200.0 |
| 2006-08-30 | COMB | ETF | 10.0 | 10.0 | 9.85 | 9.93 | 11287.0 |
| 2006-08-30 | CPST | ETF | 1.9 | 2.03 | 1.86 | 1.96 | 1205180.0 |
| 2006-08-30 | CSA | ETF | 19.51 | 19.7 | 19.42 | 19.7 | 23800.0 |
| 2006-08-30 | CSB | ETF | 28.53 | 28.69 | 28.5 | 28.59 | 4400.0 |
| 2006-08-30 | CSQ | ETF | 14.43 | 14.48 | 14.39 | 14.48 | 283900.0 |
| 2006-08-30 | CTEC | ETF | 55.0 | 56.15 | 55.0 | 55.449999999999996 | 20064.800000000003 |
| 2006-08-30 | CYB | ETF | 6.25 | 6.55 | 6.25 | 6.44 | 143300.0 |
| 2006-08-30 | DBC | ETF | 24.64 | 25.0 | 24.46 | 25.0 | 122500.0 |
| 2006-08-30 | DDM | ETF | 6.2625 | 6.2917 | 6.2483 | 6.2775 | 621600.0 |
| 2006-08-30 | DES | ETF | 17.5833 | 17.6767 | 17.5433 | 17.6267 | 236700.0 |
| 2006-08-30 | DEW | ETF | 55.61 | 56.3 | 55.61 | 55.7 | 36700.0 |
| 2006-08-30 | DFE | ETF | 54.9 | 54.95 | 54.56 | 54.82 | 47000.0 |
| 2006-08-30 | DFJ | ETF | 51.65 | 51.65 | 51.11 | 51.4 | 3700.0 |
| 2006-08-30 | DGT | ETF | 71.54 | 71.72 | 71.39 | 71.5 | 8900.0 |
| 2006-08-30 | DHS | ETF | 54.05 | 54.11 | 53.99 | 54.05 | 63200.0 |
> showing 50 of 361 rows — these rows as CSV