PREVIEW / etf_daily / 2006-05-12
file: by_date/etf_daily/2006/2006-05-12.parquet size: 17 KB rows: 321
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-05-12 | SPY | ETF | 130.36 | 130.72 | 129.19 | 129.24 | 91726500.0 |
| 2006-05-12 | QQQ | ETF | 40.57 | 40.76 | 39.96 | 40.19 | 153954450.0 |
| 2006-05-12 | IWM | ETF | 74.81 | 74.85 | 73.5 | 73.5 | 62645500.0 |
| 2006-05-12 | DIA | ETF | 114.91 | 115.06 | 113.82 | 113.87 | 9974000.0 |
| 2006-05-12 | GLD | ETF | 71.84 | 72.26 | 70.2 | 71.12 | 20635500.0 |
| 2006-05-12 | TLT | ETF | 82.81 | 83.01 | 82.56 | 82.65 | 1804700.0 |
| 2006-05-12 | AAA | ETF | 62.13 | 62.21 | 61.66 | 61.79 | 6300.0 |
| 2006-05-12 | ADRE | ETF | 141.36 | 141.36 | 137.5 | 138.38 | 187184.0 |
| 2006-05-12 | AFK | ETF | 25.18 | 25.23 | 25.11 | 25.15 | 7500.0 |
| 2006-05-12 | AGG | ETF | 97.72 | 97.8 | 97.37 | 97.59 | 181800.0 |
| 2006-05-12 | AIQ | ETF | 31.35 | 31.75 | 31.0 | 31.5 | 12100.0 |
| 2006-05-12 | AIS | ETF | 1.5 | 1.52 | 1.42 | 1.49 | 156600.0 |
| 2006-05-12 | AOM | ETF | 6.95 | 7.05 | 6.85 | 7.05 | 25600.0 |
| 2006-05-12 | ARB | ETF | 36.35 | 37.61 | 36.07 | 37.41 | 601800.0 |
| 2006-05-12 | BAB | ETF | 64.85 | 65.15 | 64.17 | 64.22 | 27600.0 |
| 2006-05-12 | BBC | ETF | 13.99 | 13.99 | 12.56 | 12.96 | 347100.0 |
| 2006-05-12 | BBH | ETF | 57.4733 | 57.9 | 56.91 | 57.56 | 2443800.0 |
| 2006-05-12 | BCM | ETF | 72.74 | 74.27 | 72.69 | 74.26 | 30300.0 |
| 2006-05-12 | BITS | ETF | 30.6 | 30.88 | 28.28 | 28.8 | 86124.0 |
| 2006-05-12 | BKF | ETF | 7.95 | 8.19 | 7.8 | 8.03 | 258100.0 |
| 2006-05-12 | BNE | ETF | 14.0 | 14.24 | 13.54 | 13.56 | 328000.0 |
| 2006-05-12 | BRF | ETF | 13.98 | 14.03 | 13.91 | 14.03 | 17500.0 |
| 2006-05-12 | BTF | ETF | 88.94999999999999 | 89.19999999999999 | 88.9 | 89.04999999999998 | 5260.0 |
| 2006-05-12 | CBON | ETF | 32.03 | 32.72 | 31.0 | 31.02 | 15373.0 |
| 2006-05-12 | CDL | ETF | 10.37 | 10.52 | 10.23 | 10.43 | 368100.0 |
| 2006-05-12 | CEF | ETF | 10.42 | 10.5 | 9.8 | 9.93 | 1346900.0 |
| 2006-05-12 | CEW | ETF | 25.45 | 25.45 | 25.4001 | 25.4001 | 1400.0 |
| 2006-05-12 | CFO | ETF | 10.28 | 10.28 | 10.12 | 10.12 | 19500.0 |
| 2006-05-12 | CGO | ETF | 14.86 | 14.86 | 14.66 | 14.75 | 42100.0 |
| 2006-05-12 | CHB | ETF | 14.85 | 14.92 | 14.3 | 14.63 | 930700.0 |
| 2006-05-12 | CHI | ETF | 19.88 | 20.0 | 19.85 | 19.99 | 75000.0 |
| 2006-05-12 | CHIC | ETF | 22.43 | 22.57 | 21.6 | 21.69 | 200542.0 |
| 2006-05-12 | CHY | ETF | 16.04 | 16.09 | 16.0 | 16.05 | 84200.0 |
| 2006-05-12 | CIL | ETF | 25.85 | 25.85 | 25.85 | 25.85 | 2700.0 |
| 2006-05-12 | CIZ | ETF | 23.0 | 23.1 | 22.93 | 22.93 | 1000.0 |
| 2006-05-12 | CN | ETF | 39.05 | 39.05 | 37.8101 | 37.98 | 38400.0 |
| 2006-05-12 | CNXT | ETF | 3.445 | 3.47 | 3.32 | 3.37 | 20111356.0 |
| 2006-05-12 | COMB | ETF | 9.96 | 9.99 | 9.86 | 9.86 | 2200.0 |
| 2006-05-12 | CPI | ETF | 31.5 | 31.5 | 31.38 | 31.38 | 200.0 |
| 2006-05-12 | CPST | ETF | 3.41 | 3.45 | 3.15 | 3.18 | 2584850.0 |
| 2006-05-12 | CSA | ETF | 19.66 | 19.87 | 19.3 | 19.3 | 6000.0 |
| 2006-05-12 | CSB | ETF | 31.19 | 31.33 | 31.07 | 31.07 | 17100.0 |
| 2006-05-12 | CSQ | ETF | 13.98 | 14.0 | 13.8801 | 13.94 | 281400.0 |
| 2006-05-12 | CTEC | ETF | 62.99999999999999 | 64.85 | 62.15 | 63.949999999999996 | 9796.6 |
| 2006-05-12 | CYB | ETF | 6.0 | 6.0 | 5.71 | 5.75 | 28100.0 |
| 2006-05-12 | DBC | ETF | 27.0 | 27.15 | 26.72 | 26.85 | 1040100.0 |
| 2006-05-12 | DGT | ETF | 68.9 | 68.9 | 68.5 | 68.5 | 3700.0 |
| 2006-05-12 | DIV | ETF | 12.01 | 12.04 | 11.95 | 11.99 | 18900.0 |
| 2006-05-12 | DRIV | ETF | 45.485 | 46.2 | 44.26 | 45.65 | 550496.0 |
| 2006-05-12 | DUSA | ETF | 6.67 | 6.99 | 6.55 | 6.69 | 100908.0 |
> showing 50 of 321 rows — these rows as CSV