PREVIEW / etf_daily / 2006-06-22
file: by_date/etf_daily/2006/2006-06-22.parquet size: 18 KB rows: 351
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-22 | SPY | ETF | 124.95 | 125.06 | 124.04 | 124.46 | 74566100.0 |
| 2006-06-22 | QQQ | ETF | 38.6 | 38.68 | 37.99 | 38.19 | 143831509.0 |
| 2006-06-22 | IWM | ETF | 68.39 | 68.61 | 67.86 | 68.24 | 50947100.0 |
| 2006-06-22 | DIA | ETF | 110.59 | 110.67 | 109.79 | 110.2 | 4818100.0 |
| 2006-06-22 | GLD | ETF | 58.17 | 58.61 | 57.66 | 57.73 | 5374800.0 |
| 2006-06-22 | TLT | ETF | 83.84 | 83.9 | 83.56 | 83.59 | 745500.0 |
| 2006-06-22 | AAA | ETF | 53.94 | 54.26 | 53.75 | 54.06 | 4200.0 |
| 2006-06-22 | ADRE | ETF | 117.23 | 117.23 | 115.17 | 116.34 | 30040.0 |
| 2006-06-22 | AFK | ETF | 24.79 | 24.84 | 24.79 | 24.79 | 5100.0 |
| 2006-06-22 | AGG | ETF | 97.58 | 97.58 | 97.08 | 97.17 | 248700.0 |
| 2006-06-22 | AIQ | ETF | 32.25 | 33.45 | 29.9 | 30.25 | 21580.0 |
| 2006-06-22 | AIS | ETF | 1.17 | 1.17 | 1.15 | 1.15 | 58300.0 |
| 2006-06-22 | AOM | ETF | 6.3 | 6.38 | 6.18 | 6.2899 | 14500.0 |
| 2006-06-22 | ARB | ETF | 37.1 | 37.13 | 36.83 | 36.99 | 412200.0 |
| 2006-06-22 | BAB | ETF | 63.4 | 63.9 | 62.99 | 63.7 | 130800.0 |
| 2006-06-22 | BBC | ETF | 12.04 | 12.56 | 11.4 | 12.02 | 608700.0 |
| 2006-06-22 | BBH | ETF | 57.1167 | 57.1167 | 56.24 | 56.52 | 1384800.0 |
| 2006-06-22 | BCM | ETF | 67.3 | 68.26 | 67.3 | 67.62 | 38500.0 |
| 2006-06-22 | BITS | ETF | 18.88 | 19.28 | 18.4 | 18.76 | 47403.0 |
| 2006-06-22 | BKF | ETF | 6.3 | 6.5 | 6.2 | 6.21 | 43400.0 |
| 2006-06-22 | BNE | ETF | 13.71 | 13.8 | 13.51 | 13.74 | 237300.0 |
| 2006-06-22 | BRF | ETF | 14.0 | 14.0 | 13.96 | 13.96 | 10100.0 |
| 2006-06-22 | CBON | ETF | 29.79 | 29.79 | 29.21 | 29.27 | 45339.0 |
| 2006-06-22 | CDL | ETF | 8.75 | 8.89 | 8.66 | 8.82 | 786100.0 |
| 2006-06-22 | CEF | ETF | 8.65 | 8.65 | 8.46 | 8.52 | 413200.0 |
| 2006-06-22 | CEW | ETF | 26.22 | 26.22 | 26.22 | 26.22 | 100.0 |
| 2006-06-22 | CFO | ETF | 9.65 | 9.65 | 9.65 | 9.65 | 10000.0 |
| 2006-06-22 | CGO | ETF | 14.01 | 14.12 | 14.0 | 14.1 | 18600.0 |
| 2006-06-22 | CHB | ETF | 10.29 | 10.45 | 10.19 | 10.39 | 1454900.0 |
| 2006-06-22 | CHI | ETF | 19.23 | 19.2399 | 19.04 | 19.11 | 85700.0 |
| 2006-06-22 | CHIC | ETF | 19.82 | 20.68 | 19.82 | 20.53 | 349460.0 |
| 2006-06-22 | CHY | ETF | 16.01 | 16.0588 | 16.0 | 16.03 | 158200.0 |
| 2006-06-22 | CN | ETF | 32.82 | 32.92 | 32.55 | 32.73 | 34600.0 |
| 2006-06-22 | CNXT | ETF | 2.45 | 2.45 | 2.33 | 2.35 | 8834240.0 |
| 2006-06-22 | COMB | ETF | 9.535 | 9.9 | 9.535 | 9.77 | 11301.0 |
| 2006-06-22 | CPI | ETF | 31.05 | 31.05 | 30.4 | 30.4 | 800.0 |
| 2006-06-22 | CPST | ETF | 2.56 | 2.63 | 2.5 | 2.58 | 998456.0 |
| 2006-06-22 | CSA | ETF | 18.9 | 18.9 | 18.85 | 18.85 | 200.0 |
| 2006-06-22 | CSB | ETF | 26.99 | 26.99 | 26.84 | 26.96 | 5500.0 |
| 2006-06-22 | CSQ | ETF | 13.9 | 13.91 | 13.81 | 13.85 | 369700.0 |
| 2006-06-22 | CTEC | ETF | 64.05 | 64.5 | 62.75 | 63.550000000000004 | 22831.800000000003 |
| 2006-06-22 | CYB | ETF | 5.65 | 5.9 | 5.64 | 5.81 | 35600.0 |
| 2006-06-22 | DBC | ETF | 24.43 | 24.53 | 24.31 | 24.44 | 171900.0 |
| 2006-06-22 | DDM | ETF | 5.9317 | 5.9317 | 5.8867 | 5.93 | 606000.0 |
| 2006-06-22 | DES | ETF | 16.6433 | 16.6433 | 16.5733 | 16.5767 | 11700.0 |
| 2006-06-22 | DEW | ETF | 50.16 | 50.16 | 50.12 | 50.12 | 500.0 |
| 2006-06-22 | DFE | ETF | 50.82 | 50.91 | 50.76 | 50.76 | 1700.0 |
| 2006-06-22 | DFJ | ETF | 50.71 | 50.84 | 50.64 | 50.64 | 1200.0 |
| 2006-06-22 | DGT | ETF | 65.65 | 65.72 | 65.24 | 65.52 | 2600.0 |
| 2006-06-22 | DHS | ETF | 49.87 | 49.87 | 49.7 | 49.7 | 3300.0 |
> showing 50 of 351 rows — these rows as CSV