PREVIEW / etf_daily / 2006-08-29
file: by_date/etf_daily/2006/2006-08-29.parquet size: 18 KB rows: 363
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-29 | SPY | ETF | 130.49 | 130.83 | 129.81 | 130.58 | 61817800.0 |
| 2006-08-29 | QQQ | ETF | 38.58 | 38.76 | 38.18 | 38.73 | 104869211.0 |
| 2006-08-29 | IWM | ETF | 70.51 | 71.25 | 69.88 | 71.25 | 53031100.0 |
| 2006-08-29 | DIA | ETF | 113.46 | 113.76 | 112.93 | 113.51 | 4967000.0 |
| 2006-08-29 | GLD | ETF | 61.0 | 61.09 | 60.32 | 60.94 | 3609800.0 |
| 2006-08-29 | TLT | ETF | 87.25 | 87.64 | 86.98 | 87.64 | 1345600.0 |
| 2006-08-29 | AAA | ETF | 58.45 | 58.79 | 58.21 | 58.79 | 2500.0 |
| 2006-08-29 | ADRE | ETF | 32.3 | 32.31 | 32.02 | 32.2922 | 28232.0 |
| 2006-08-29 | AFK | ETF | 25.33 | 25.39 | 25.32 | 25.32 | 1500.0 |
| 2006-08-29 | AGG | ETF | 99.26 | 99.3 | 99.05 | 99.27 | 134600.0 |
| 2006-08-29 | AIQ | ETF | 32.15 | 32.65 | 31.9 | 32.05 | 23620.0 |
| 2006-08-29 | AIS | ETF | 1.02 | 1.04 | 0.99 | 1.0 | 158600.0 |
| 2006-08-29 | AOM | ETF | 5.09 | 5.09 | 4.97 | 5.03 | 34300.0 |
| 2006-08-29 | ARB | ETF | 36.1 | 36.58 | 36.05 | 36.47 | 129600.0 |
| 2006-08-29 | BAB | ETF | 79.05 | 79.66 | 78.02 | 78.52 | 389600.0 |
| 2006-08-29 | BBC | ETF | 11.76 | 11.9499 | 11.51 | 11.8 | 204200.0 |
| 2006-08-29 | BBH | ETF | 59.1 | 59.96 | 59.1 | 59.8 | 1447500.0 |
| 2006-08-29 | BITS | ETF | 28.8 | 28.96 | 27.824 | 28.6 | 20197.0 |
| 2006-08-29 | BKF | ETF | 4.0 | 4.0 | 3.96 | 4.0 | 59500.0 |
| 2006-08-29 | BNE | ETF | 14.88 | 15.24 | 14.86 | 15.2 | 154900.0 |
| 2006-08-29 | BRF | ETF | 14.12 | 14.15 | 14.11 | 14.11 | 4700.0 |
| 2006-08-29 | BTF | ETF | 91.5 | 91.6 | 91.125 | 91.54999999999998 | 6180.0 |
| 2006-08-29 | CBON | ETF | 33.95 | 34.002 | 33.75 | 34.0 | 16606.0 |
| 2006-08-29 | CDL | ETF | 8.69 | 8.91 | 8.57 | 8.89 | 396900.0 |
| 2006-08-29 | CEF | ETF | 8.81 | 8.85 | 8.73 | 8.84 | 284800.0 |
| 2006-08-29 | CEW | ETF | 25.44 | 25.44 | 25.25 | 25.4 | 700.0 |
| 2006-08-29 | CFO | ETF | 10.1 | 10.1 | 10.05 | 10.05 | 101500.0 |
| 2006-08-29 | CGO | ETF | 15.51 | 15.55 | 15.33 | 15.48 | 20800.0 |
| 2006-08-29 | CHB | ETF | 6.17 | 6.23 | 6.0 | 6.08 | 923800.0 |
| 2006-08-29 | CHI | ETF | 20.0 | 20.31 | 20.0 | 20.27 | 94600.0 |
| 2006-08-29 | CHIC | ETF | 26.88 | 27.05 | 26.53 | 26.99 | 249370.0 |
| 2006-08-29 | CHY | ETF | 16.49 | 16.54 | 16.45 | 16.52 | 145300.0 |
| 2006-08-29 | CIZ | ETF | 22.1 | 22.1 | 21.8 | 21.8 | 800.0 |
| 2006-08-29 | CN | ETF | 33.86 | 34.23 | 33.64 | 34.03 | 102800.0 |
| 2006-08-29 | CNXT | ETF | 2.08 | 2.09 | 1.98 | 2.07 | 18266984.0 |
| 2006-08-29 | COMB | ETF | 10.09 | 10.1 | 9.93 | 10.03 | 56604.0 |
| 2006-08-29 | CPI | ETF | 29.15 | 29.29 | 29.1 | 29.1 | 800.0 |
| 2006-08-29 | CPST | ETF | 1.85 | 1.92 | 1.85 | 1.91 | 554398.0 |
| 2006-08-29 | CSA | ETF | 19.3 | 19.51 | 19.18 | 19.51 | 9700.0 |
| 2006-08-29 | CSB | ETF | 28.63 | 28.68 | 28.41 | 28.66 | 9200.0 |
| 2006-08-29 | CSQ | ETF | 14.5 | 14.51 | 14.35 | 14.4 | 371400.0 |
| 2006-08-29 | CTEC | ETF | 54.349999999999994 | 55.199999999999996 | 54.349999999999994 | 55.0 | 16905.8 |
| 2006-08-29 | CYB | ETF | 6.04 | 6.2 | 6.02 | 6.2 | 85700.0 |
| 2006-08-29 | DBC | ETF | 24.62 | 24.7 | 24.5 | 24.63 | 230700.0 |
| 2006-08-29 | DDM | ETF | 6.2333 | 6.2642 | 6.1817 | 6.2642 | 1003200.0 |
| 2006-08-29 | DES | ETF | 17.37 | 17.53 | 17.2833 | 17.53 | 36300.0 |
| 2006-08-29 | DEW | ETF | 55.69 | 55.88 | 55.12 | 55.88 | 11500.0 |
| 2006-08-29 | DFE | ETF | 54.62 | 54.9 | 54.28 | 54.9 | 2100.0 |
| 2006-08-29 | DFJ | ETF | 51.5 | 51.64 | 51.06 | 51.64 | 1900.0 |
| 2006-08-29 | DGT | ETF | 71.4 | 71.57 | 70.91 | 71.5 | 25400.0 |
> showing 50 of 363 rows — these rows as CSV