PREVIEW / etf_daily / 2006-08-11
file: by_date/etf_daily/2006/2006-08-11.parquet size: 18 KB rows: 358
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-11 | SPY | ETF | 127.17 | 127.2 | 126.39 | 127.01 | 47482200.0 |
| 2006-08-11 | QQQ | ETF | 36.65 | 36.69 | 36.37 | 36.53 | 86930474.0 |
| 2006-08-11 | IWM | ETF | 68.06 | 68.07 | 67.23 | 67.6 | 42757200.0 |
| 2006-08-11 | DIA | ETF | 111.06 | 111.15 | 110.55 | 111.05 | 5275000.0 |
| 2006-08-11 | GLD | ETF | 63.58 | 64.1 | 62.24 | 62.71 | 6962800.0 |
| 2006-08-11 | TLT | ETF | 85.47 | 85.53 | 85.36 | 85.4 | 450800.0 |
| 2006-08-11 | AAA | ETF | 56.65 | 56.81 | 56.4 | 56.4 | 10800.0 |
| 2006-08-11 | ADRE | ETF | 32.24 | 32.25 | 31.97 | 32.086 | 103152.0 |
| 2006-08-11 | AFK | ETF | 25.16 | 25.27 | 25.16 | 25.2 | 2400.0 |
| 2006-08-11 | AGG | ETF | 98.52 | 98.52 | 98.39 | 98.47 | 109600.0 |
| 2006-08-11 | AIQ | ETF | 31.8 | 32.2 | 30.35 | 30.65 | 29100.0 |
| 2006-08-11 | AIS | ETF | 0.99 | 0.9952 | 0.9399 | 0.95 | 218400.0 |
| 2006-08-11 | AOM | ETF | 5.78 | 5.8 | 5.71 | 5.72 | 13400.0 |
| 2006-08-11 | ARB | ETF | 35.64 | 35.7 | 35.1 | 35.48 | 165200.0 |
| 2006-08-11 | BAB | ETF | 70.84 | 70.88 | 69.26 | 69.33 | 122700.0 |
| 2006-08-11 | BBC | ETF | 13.05 | 13.11 | 12.67 | 12.7 | 206300.0 |
| 2006-08-11 | BBH | ETF | 58.0933 | 58.2167 | 57.73 | 58.0567 | 456600.0 |
| 2006-08-11 | BITS | ETF | 22.4 | 23.28 | 22.232 | 23.12 | 34600.0 |
| 2006-08-11 | BKF | ETF | 4.05 | 4.05 | 4.0 | 4.01 | 13200.0 |
| 2006-08-11 | BNE | ETF | 14.95 | 15.24 | 14.75 | 15.19 | 172000.0 |
| 2006-08-11 | BRF | ETF | 14.06 | 14.08 | 14.03 | 14.03 | 11600.0 |
| 2006-08-11 | BTF | ETF | 89.89999999999999 | 89.94999999999999 | 89.25 | 89.25 | 2700.0 |
| 2006-08-11 | CBON | ETF | 32.98 | 32.98 | 32.19 | 32.65 | 16477.0 |
| 2006-08-11 | CDL | ETF | 8.7 | 8.75 | 8.62 | 8.67 | 190500.0 |
| 2006-08-11 | CEF | ETF | 8.95 | 9.09 | 8.88 | 8.99 | 407900.0 |
| 2006-08-11 | CEW | ETF | 25.96 | 26.0299 | 25.96 | 26.0299 | 200.0 |
| 2006-08-11 | CFO | ETF | 10.01 | 10.01 | 10.0 | 10.01 | 10000.0 |
| 2006-08-11 | CGO | ETF | 15.01 | 15.15 | 14.9 | 15.08 | 26800.0 |
| 2006-08-11 | CHB | ETF | 5.24 | 5.58 | 5.2 | 5.47 | 3618000.0 |
| 2006-08-11 | CHI | ETF | 20.15 | 20.24 | 20.0601 | 20.23 | 73300.0 |
| 2006-08-11 | CHIC | ETF | 26.1 | 26.1 | 25.17 | 25.7 | 164979.0 |
| 2006-08-11 | CHY | ETF | 16.15 | 16.23 | 16.11 | 16.23 | 80200.0 |
| 2006-08-11 | CIZ | ETF | 22.0 | 22.0 | 22.0 | 22.0 | 100.0 |
| 2006-08-11 | CN | ETF | 36.6 | 36.6 | 36.1 | 36.42 | 41600.0 |
| 2006-08-11 | CNXT | ETF | 1.71 | 1.75 | 1.65 | 1.66 | 10672301.0 |
| 2006-08-11 | COMB | ETF | 9.85 | 9.85 | 9.84 | 9.84 | 500.0 |
| 2006-08-11 | CPST | ETF | 1.951 | 1.97 | 1.85 | 1.86 | 817104.0 |
| 2006-08-11 | CSA | ETF | 18.4 | 18.5 | 18.3201 | 18.37 | 9700.0 |
| 2006-08-11 | CSB | ETF | 25.52 | 25.76 | 25.51 | 25.56 | 8100.0 |
| 2006-08-11 | CSQ | ETF | 14.17 | 14.21 | 14.08 | 14.2 | 258300.0 |
| 2006-08-11 | CTEC | ETF | 55.65 | 55.99999999999999 | 54.85 | 55.199999999999996 | 9057.800000000001 |
| 2006-08-11 | CYB | ETF | 5.5 | 5.68 | 5.5 | 5.55 | 25200.0 |
| 2006-08-11 | DBC | ETF | 25.89 | 25.92 | 25.35 | 25.54 | 179500.0 |
| 2006-08-11 | DDM | ETF | 5.9692 | 5.9692 | 5.905 | 5.9508 | 712800.0 |
| 2006-08-11 | DES | ETF | 16.9567 | 16.9567 | 16.9 | 16.9 | 6000.0 |
| 2006-08-11 | DEW | ETF | 52.95 | 53.18 | 52.9 | 53.04 | 9000.0 |
| 2006-08-11 | DFJ | ETF | 49.73 | 49.84 | 49.73 | 49.84 | 200.0 |
| 2006-08-11 | DGT | ETF | 71.3 | 71.3 | 69.08 | 69.4 | 13100.0 |
| 2006-08-11 | DHS | ETF | 52.6 | 52.6 | 52.26 | 52.45 | 25000.0 |
| 2006-08-11 | DIM | ETF | 53.5 | 53.82 | 53.5 | 53.82 | 4300.0 |
> showing 50 of 358 rows — these rows as CSV