PREVIEW / etf_daily / 2006-05-22
file: by_date/etf_daily/2006/2006-05-22.parquet size: 17 KB rows: 329
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-22 | SPY | ETF | 126.28 | 127.17 | 125.5 | 126.13 | 110852800.0 |
| 2006-05-22 | QQQ | ETF | 39.02 | 39.24 | 38.62 | 38.97 | 169606643.0 |
| 2006-05-22 | IWM | ETF | 71.24 | 71.67 | 70.09 | 71.1 | 89895900.0 |
| 2006-05-22 | DIA | ETF | 110.71 | 111.66 | 110.27 | 110.97 | 16605100.0 |
| 2006-05-22 | GLD | ETF | 64.42 | 65.42 | 63.8 | 65.3 | 11977700.0 |
| 2006-05-22 | TLT | ETF | 84.84 | 85.15 | 84.48 | 84.61 | 2652000.0 |
| 2006-05-22 | AAA | ETF | 58.85 | 59.09 | 58.69 | 59.05 | 14000.0 |
| 2006-05-22 | ADRE | ETF | 125.1 | 127.0 | 120.2764 | 122.79 | 228404.0 |
| 2006-05-22 | AFK | ETF | 25.16 | 25.21 | 25.14 | 25.2 | 2100.0 |
| 2006-05-22 | AGG | ETF | 98.43 | 98.55 | 98.17 | 98.26 | 374300.0 |
| 2006-05-22 | AIQ | ETF | 32.75 | 32.95 | 31.0 | 31.8 | 23280.0 |
| 2006-05-22 | AIS | ETF | 1.32 | 1.32 | 1.14 | 1.3 | 751300.0 |
| 2006-05-22 | AOM | ETF | 7.43 | 7.43 | 7.3 | 7.4 | 15000.0 |
| 2006-05-22 | ARB | ETF | 39.75 | 39.79 | 39.2 | 39.31 | 488800.0 |
| 2006-05-22 | BAB | ETF | 62.26 | 63.44 | 61.29 | 62.7 | 115700.0 |
| 2006-05-22 | BBC | ETF | 11.18 | 11.2 | 10.65 | 10.9 | 235000.0 |
| 2006-05-22 | BBH | ETF | 57.3233 | 57.9033 | 56.6667 | 57.2333 | 2362500.0 |
| 2006-05-22 | BCM | ETF | 71.75 | 71.75 | 71.12 | 71.67 | 13700.0 |
| 2006-05-22 | BITS | ETF | 25.84 | 25.84 | 24.2 | 24.56 | 30276.0 |
| 2006-05-22 | BKF | ETF | 7.76 | 7.9 | 7.64 | 7.83 | 67100.0 |
| 2006-05-22 | BNE | ETF | 14.35 | 14.83 | 14.25 | 14.53 | 194100.0 |
| 2006-05-22 | BOSS | ETF | 33.04 | 33.04 | 31.71 | 31.71 | 100.0 |
| 2006-05-22 | BRF | ETF | 13.95 | 14.0 | 13.95 | 13.97 | 2400.0 |
| 2006-05-22 | BTF | ETF | 89.1 | 89.19999999999999 | 88.49999999999999 | 88.85 | 4640.0 |
| 2006-05-22 | CBON | ETF | 31.29 | 32.31 | 31.22 | 31.81 | 19317.0 |
| 2006-05-22 | CDL | ETF | 10.44 | 10.57 | 10.25 | 10.49 | 223600.0 |
| 2006-05-22 | CEF | ETF | 8.9 | 8.96 | 8.75 | 8.9 | 1066800.0 |
| 2006-05-22 | CFO | ETF | 10.12 | 10.12 | 9.95 | 10.03 | 77200.0 |
| 2006-05-22 | CGO | ETF | 14.57 | 14.61 | 13.94 | 14.25 | 57200.0 |
| 2006-05-22 | CHB | ETF | 13.91 | 13.97 | 13.14 | 13.5 | 934700.0 |
| 2006-05-22 | CHI | ETF | 19.6 | 19.73 | 19.6 | 19.6999 | 66400.0 |
| 2006-05-22 | CHIC | ETF | 21.97 | 22.0 | 21.75 | 21.77 | 305910.0 |
| 2006-05-22 | CHY | ETF | 16.2 | 16.34 | 16.17 | 16.34 | 148100.0 |
| 2006-05-22 | CIL | ETF | 25.81 | 25.81 | 25.81 | 25.81 | 200.0 |
| 2006-05-22 | CIZ | ETF | 23.03 | 23.1 | 22.15 | 23.1 | 6100.0 |
| 2006-05-22 | CN | ETF | 31.0 | 31.74 | 31.0 | 31.58 | 138200.0 |
| 2006-05-22 | CNXT | ETF | 3.17 | 3.23 | 3.09 | 3.16 | 16854896.0 |
| 2006-05-22 | COMB | ETF | 9.59 | 10.08 | 9.59 | 10.08 | 15036.0 |
| 2006-05-22 | CPST | ETF | 3.06 | 3.09 | 2.71 | 2.81 | 3625576.0 |
| 2006-05-22 | CSA | ETF | 18.64 | 19.2 | 18.64 | 19.2 | 3500.0 |
| 2006-05-22 | CSB | ETF | 29.17 | 29.23 | 28.87 | 29.1 | 5500.0 |
| 2006-05-22 | CSQ | ETF | 13.86 | 13.86 | 13.68 | 13.74 | 385000.0 |
| 2006-05-22 | CTEC | ETF | 63.75 | 64.3 | 62.64999999999999 | 63.75 | 16947.8 |
| 2006-05-22 | CYB | ETF | 5.85 | 5.9 | 5.72 | 5.79 | 47900.0 |
| 2006-05-22 | DBC | ETF | 25.1 | 25.63 | 25.1 | 25.62 | 863900.0 |
| 2006-05-22 | DGT | ETF | 66.57 | 67.03 | 66.57 | 66.9 | 2300.0 |
| 2006-05-22 | DIG | ETF | 17.7375 | 17.7375 | 17.7375 | 17.7375 | 12320.0 |
| 2006-05-22 | DIV | ETF | 11.8 | 11.8 | 11.59 | 11.72 | 11500.0 |
| 2006-05-22 | DRIV | ETF | 44.3 | 45.49 | 43.89 | 45.28 | 1041884.0 |
| 2006-05-22 | DSI | ETF | 6.325 | 6.385 | 6.325 | 6.385 | 40600.0 |
> showing 50 of 329 rows — these rows as CSV