PREVIEW / etf_daily / 2006-06-16
file: by_date/etf_daily/2006/2006-06-16.parquet size: 17 KB rows: 335
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-06-16 | SPY | ETF | 125.29 | 125.56 | 124.46 | 124.65 | 94253500.0 |
| 2006-06-16 | QQQ | ETF | 38.55 | 38.68 | 38.2 | 38.34 | 120017376.0 |
| 2006-06-16 | IWM | ETF | 69.6 | 69.7 | 68.57 | 68.85 | 66852400.0 |
| 2006-06-16 | DIA | ETF | 109.92 | 110.38 | 109.71 | 109.98 | 5751300.0 |
| 2006-06-16 | GLD | ETF | 57.3 | 57.93 | 56.43 | 57.68 | 7319400.0 |
| 2006-06-16 | TLT | ETF | 84.7 | 84.76 | 84.18 | 84.31 | 1184600.0 |
| 2006-06-16 | AAA | ETF | 55.62 | 55.62 | 55.0001 | 55.24 | 3600.0 |
| 2006-06-16 | ADRE | ETF | 117.34 | 117.34 | 114.25 | 115.81 | 344088.0 |
| 2006-06-16 | AFK | ETF | 24.83 | 24.88 | 24.79 | 24.87 | 5400.0 |
| 2006-06-16 | AGG | ETF | 97.97 | 98.0 | 97.56 | 97.76 | 227900.0 |
| 2006-06-16 | AIQ | ETF | 28.75 | 30.0 | 27.5 | 27.65 | 64740.0 |
| 2006-06-16 | AIS | ETF | 1.2 | 1.3 | 1.18 | 1.19 | 108700.0 |
| 2006-06-16 | AOM | ETF | 6.18 | 6.27 | 6.05 | 6.22 | 22100.0 |
| 2006-06-16 | ARB | ETF | 37.79 | 37.85 | 37.4 | 37.56 | 667200.0 |
| 2006-06-16 | BAB | ETF | 65.27 | 66.0 | 64.8601 | 65.6 | 52300.0 |
| 2006-06-16 | BBC | ETF | 9.99 | 10.4 | 9.9801 | 10.05 | 116900.0 |
| 2006-06-16 | BBH | ETF | 57.93 | 58.3133 | 57.4533 | 58.0033 | 1649700.0 |
| 2006-06-16 | BCM | ETF | 67.7 | 69.01 | 67.61 | 68.56 | 47200.0 |
| 2006-06-16 | BITS | ETF | 23.56 | 23.72 | 23.28 | 23.4 | 9486.0 |
| 2006-06-16 | BKF | ETF | 6.25 | 6.35 | 6.02 | 6.09 | 144000.0 |
| 2006-06-16 | BNE | ETF | 13.79 | 13.86 | 13.28 | 13.53 | 971000.0 |
| 2006-06-16 | BRF | ETF | 13.99 | 14.01 | 13.92 | 13.98 | 10900.0 |
| 2006-06-16 | BTF | ETF | 88.75 | 89.25 | 88.75 | 89.25 | 1360.0 |
| 2006-06-16 | CBON | ETF | 30.6 | 30.6 | 30.144 | 30.18 | 68197.0 |
| 2006-06-16 | CDL | ETF | 9.07 | 9.11 | 8.88 | 8.91 | 717800.0 |
| 2006-06-16 | CEF | ETF | 8.58 | 8.64 | 8.35 | 8.47 | 553000.0 |
| 2006-06-16 | CEW | ETF | 25.62 | 25.78 | 25.62 | 25.78 | 1000.0 |
| 2006-06-16 | CFO | ETF | 9.7 | 9.7 | 9.7 | 9.7 | 14400.0 |
| 2006-06-16 | CGO | ETF | 13.87 | 13.97 | 13.75 | 13.94 | 20300.0 |
| 2006-06-16 | CHB | ETF | 9.96 | 9.99 | 9.44 | 9.69 | 2511900.0 |
| 2006-06-16 | CHI | ETF | 18.9 | 19.06 | 18.8601 | 19.02 | 82700.0 |
| 2006-06-16 | CHIC | ETF | 20.17 | 20.25 | 19.58 | 19.78 | 344593.0 |
| 2006-06-16 | CHY | ETF | 16.1 | 16.12 | 15.99 | 16.02 | 1445900.0 |
| 2006-06-16 | CIL | ETF | 25.11 | 25.13 | 25.03 | 25.13 | 2900.0 |
| 2006-06-16 | CIZ | ETF | 23.1 | 23.1 | 23.1 | 23.1 | 200.0 |
| 2006-06-16 | CN | ETF | 33.0 | 33.0 | 32.56 | 32.75 | 55600.0 |
| 2006-06-16 | CNXT | ETF | 2.53 | 2.55 | 2.43 | 2.45 | 13994430.0 |
| 2006-06-16 | COMB | ETF | 9.85 | 9.94 | 9.82 | 9.93 | 10500.0 |
| 2006-06-16 | CPST | ETF | 2.48 | 2.48 | 2.32 | 2.35 | 939505.0 |
| 2006-06-16 | CSA | ETF | 18.5 | 19.1 | 18.5 | 19.05 | 10300.0 |
| 2006-06-16 | CSB | ETF | 27.84 | 27.84 | 27.5 | 27.66 | 33600.0 |
| 2006-06-16 | CSQ | ETF | 13.68 | 13.82 | 13.58 | 13.79 | 301700.0 |
| 2006-06-16 | CTEC | ETF | 63.75 | 65.05 | 63.3 | 64.8 | 16378.800000000001 |
| 2006-06-16 | CYB | ETF | 5.45 | 5.6 | 5.45 | 5.6 | 10500.0 |
| 2006-06-16 | DBC | ETF | 24.21 | 24.35 | 24.0 | 24.35 | 202400.0 |
| 2006-06-16 | DES | ETF | 16.9033 | 16.9033 | 16.7267 | 16.7367 | 32400.0 |
| 2006-06-16 | DEW | ETF | 50.35 | 50.35 | 49.95 | 50.31 | 2100.0 |
| 2006-06-16 | DFE | ETF | 50.86 | 50.9399 | 50.78 | 50.87 | 4000.0 |
| 2006-06-16 | DFJ | ETF | 50.5 | 50.5 | 49.88 | 49.98 | 11600.0 |
| 2006-06-16 | DGT | ETF | 65.25 | 65.31 | 65.1 | 65.1 | 5700.0 |
> showing 50 of 335 rows — these rows as CSV