PREVIEW / etf_daily / 2006-06-29
file: by_date/etf_daily/2006/2006-06-29.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-29 | SPY | ETF | 125.2 | 127.35 | 125.17 | 127.27 | 110634800.0 |
| 2006-06-29 | QQQ | ETF | 37.96 | 38.96 | 37.9 | 38.96 | 182431073.0 |
| 2006-06-29 | IWM | ETF | 68.81 | 71.25 | 68.81 | 71.25 | 96533200.0 |
| 2006-06-29 | DIA | ETF | 110.23 | 111.87 | 110.13 | 111.8 | 8164300.0 |
| 2006-06-29 | GLD | ETF | 58.0 | 59.78 | 58.0 | 59.52 | 10748500.0 |
| 2006-06-29 | TLT | ETF | 83.58 | 83.82 | 83.36 | 83.51 | 1609300.0 |
| 2006-06-29 | AAA | ETF | 54.3 | 55.35 | 54.15 | 55.34 | 7400.0 |
| 2006-06-29 | ADRE | ETF | 118.29 | 123.99 | 118.29 | 123.99 | 163504.0 |
| 2006-06-29 | AFK | ETF | 24.84 | 24.9 | 24.78 | 24.79 | 12100.0 |
| 2006-06-29 | AGG | ETF | 97.15 | 97.47 | 97.1 | 97.45 | 248100.0 |
| 2006-06-29 | AIQ | ETF | 30.75 | 33.15 | 30.65 | 32.55 | 23660.0 |
| 2006-06-29 | AIS | ETF | 1.17 | 1.18 | 1.09 | 1.16 | 303700.0 |
| 2006-06-29 | AOM | ETF | 6.0 | 6.0 | 5.87 | 5.89 | 171200.0 |
| 2006-06-29 | ARB | ETF | 37.68 | 38.0 | 37.52 | 38.0 | 256600.0 |
| 2006-06-29 | BAB | ETF | 60.95 | 62.44 | 60.88 | 62.41 | 43300.0 |
| 2006-06-29 | BBC | ETF | 14.0 | 14.0 | 13.2 | 13.38 | 444900.0 |
| 2006-06-29 | BBH | ETF | 56.98 | 58.2633 | 56.98 | 58.16 | 2112300.0 |
| 2006-06-29 | BCM | ETF | 66.67 | 67.54 | 65.66 | 67.54 | 45900.0 |
| 2006-06-29 | BITS | ETF | 18.92 | 19.76 | 18.32 | 18.32 | 31458.0 |
| 2006-06-29 | BKF | ETF | 5.99 | 6.08 | 5.8 | 6.07 | 76600.0 |
| 2006-06-29 | BNE | ETF | 13.39 | 14.05 | 13.13 | 13.88 | 219400.0 |
| 2006-06-29 | BRF | ETF | 13.91 | 13.96 | 13.91 | 13.96 | 10300.0 |
| 2006-06-29 | BTF | ETF | 89.19999999999999 | 89.25 | 88.8 | 89.25 | 7200.0 |
| 2006-06-29 | CBON | ETF | 29.7 | 30.18 | 28.87 | 30.18 | 164646.0 |
| 2006-06-29 | CDL | ETF | 8.85 | 8.92 | 8.79 | 8.88 | 476100.0 |
| 2006-06-29 | CEF | ETF | 8.25 | 8.71 | 8.25 | 8.7 | 365700.0 |
| 2006-06-29 | CFO | ETF | 9.9 | 9.98 | 9.9 | 9.98 | 3700.0 |
| 2006-06-29 | CGO | ETF | 14.29 | 14.49 | 14.22 | 14.49 | 43200.0 |
| 2006-06-29 | CHB | ETF | 10.6 | 11.09 | 10.48 | 10.91 | 958500.0 |
| 2006-06-29 | CHI | ETF | 19.0 | 19.14 | 18.84 | 19.1299 | 103800.0 |
| 2006-06-29 | CHIC | ETF | 21.25 | 22.3 | 21.18 | 22.18 | 466019.0 |
| 2006-06-29 | CHY | ETF | 15.91 | 16.05 | 15.85 | 16.05 | 148500.0 |
| 2006-06-29 | CIL | ETF | 25.06 | 25.06 | 25.06 | 25.06 | 900.0 |
| 2006-06-29 | CN | ETF | 34.5 | 35.1 | 34.24 | 34.86 | 86900.0 |
| 2006-06-29 | CNXT | ETF | 2.25 | 2.4 | 2.24 | 2.35 | 16095864.0 |
| 2006-06-29 | COMB | ETF | 9.9 | 9.95 | 9.88 | 9.95 | 20910.0 |
| 2006-06-29 | CPST | ETF | 2.3 | 2.36 | 2.25 | 2.32 | 2868770.0 |
| 2006-06-29 | CSB | ETF | 27.12 | 27.47 | 27.0 | 27.47 | 10900.0 |
| 2006-06-29 | CSQ | ETF | 13.82 | 13.94 | 13.8 | 13.94 | 241800.0 |
| 2006-06-29 | CTEC | ETF | 62.9 | 63.75 | 62.599999999999994 | 63.05 | 15444.6 |
| 2006-06-29 | CYB | ETF | 6.1 | 6.75 | 6.1 | 6.64 | 165800.0 |
| 2006-06-29 | DBC | ETF | 24.76 | 25.19 | 24.73 | 25.19 | 346300.0 |
| 2006-06-29 | DDM | ETF | 5.9083 | 6.0875 | 5.9083 | 6.0858 | 1513200.0 |
| 2006-06-29 | DES | ETF | 16.9833 | 17.0133 | 16.9167 | 16.9233 | 5100.0 |
| 2006-06-29 | DEW | ETF | 50.49 | 51.71 | 50.49 | 51.71 | 3200.0 |
| 2006-06-29 | DFJ | ETF | 50.38 | 51.59 | 50.38 | 51.59 | 600.0 |
| 2006-06-29 | DGT | ETF | 65.85 | 66.62 | 65.85 | 66.62 | 11800.0 |
| 2006-06-29 | DHS | ETF | 50.3 | 50.81 | 50.21 | 50.81 | 3300.0 |
| 2006-06-29 | DIG | ETF | 18.0501 | 18.0501 | 18.05 | 18.05 | 240.0 |
| 2006-06-29 | DIM | ETF | 51.07 | 52.12 | 51.07 | 52.12 | 1600.0 |
> showing 50 of 351 rows — these rows as CSV