PREVIEW / etf_daily / 2006-07-18
file: by_date/etf_daily/2006/2006-07-18.parquet size: 18 KB rows: 355
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-07-18 | SPY | ETF | 123.71 | 124.05 | 122.39 | 123.97 | 122771000.0 |
| 2006-07-18 | QQQ | ETF | 36.22 | 36.33 | 35.54 | 36.15 | 207274677.0 |
| 2006-07-18 | IWM | ETF | 67.82 | 68.25 | 66.62 | 67.9 | 74235300.0 |
| 2006-07-18 | DIA | ETF | 107.75 | 108.24 | 106.89 | 108.19 | 11280500.0 |
| 2006-07-18 | GLD | ETF | 64.75 | 64.75 | 62.34 | 62.9 | 7639300.0 |
| 2006-07-18 | TLT | ETF | 84.7 | 84.75 | 84.4 | 84.44 | 621000.0 |
| 2006-07-18 | AAA | ETF | 54.17 | 54.6 | 53.5701 | 54.6 | 38000.0 |
| 2006-07-18 | ADRE | ETF | 29.55 | 29.89 | 29.24 | 29.78 | 421916.0 |
| 2006-07-18 | AFK | ETF | 25.0 | 25.07 | 25.0 | 25.05 | 5800.0 |
| 2006-07-18 | AGG | ETF | 97.58 | 97.7 | 97.47 | 97.6 | 223900.0 |
| 2006-07-18 | AIQ | ETF | 31.15 | 31.15 | 29.25 | 30.8 | 18320.0 |
| 2006-07-18 | AIS | ETF | 1.15 | 1.25 | 1.1124 | 1.13 | 596800.0 |
| 2006-07-18 | AOM | ETF | 6.45 | 6.53 | 6.45 | 6.46 | 20500.0 |
| 2006-07-18 | ARB | ETF | 36.5 | 36.8 | 36.22 | 36.65 | 153200.0 |
| 2006-07-18 | BAB | ETF | 62.98 | 63.34 | 62.44 | 63.1 | 61700.0 |
| 2006-07-18 | BBC | ETF | 12.45 | 12.5 | 11.91 | 12.06 | 219200.0 |
| 2006-07-18 | BBH | ETF | 56.9 | 57.1267 | 56.2667 | 56.92 | 1235700.0 |
| 2006-07-18 | BITS | ETF | 17.48 | 18.16 | 17.44 | 17.72 | 9773.0 |
| 2006-07-18 | BKF | ETF | 5.6 | 5.6 | 5.42 | 5.5 | 9200.0 |
| 2006-07-18 | BNE | ETF | 13.39 | 13.55 | 13.06 | 13.42 | 93800.0 |
| 2006-07-18 | BRF | ETF | 13.9 | 13.91 | 13.86 | 13.91 | 9900.0 |
| 2006-07-18 | BTF | ETF | 86.6 | 86.6 | 86.44999999999999 | 86.44999999999999 | 600.0 |
| 2006-07-18 | CBON | ETF | 30.6 | 30.95 | 30.44 | 30.87 | 8737.0 |
| 2006-07-18 | CDL | ETF | 8.7 | 8.93 | 8.69 | 8.9 | 302400.0 |
| 2006-07-18 | CEF | ETF | 9.25 | 9.29 | 8.82 | 8.87 | 593100.0 |
| 2006-07-18 | CEW | ETF | 25.92 | 25.92 | 25.92 | 25.92 | 400.0 |
| 2006-07-18 | CFO | ETF | 9.88 | 9.95 | 9.85 | 9.85 | 5500.0 |
| 2006-07-18 | CGO | ETF | 14.55 | 14.58 | 14.39 | 14.47 | 22200.0 |
| 2006-07-18 | CHB | ETF | 8.67 | 8.75 | 8.11 | 8.52 | 1467200.0 |
| 2006-07-18 | CHI | ETF | 19.35 | 19.4568 | 19.23 | 19.42 | 94900.0 |
| 2006-07-18 | CHIC | ETF | 23.32 | 23.4 | 22.57 | 23.01 | 737381.0 |
| 2006-07-18 | CHY | ETF | 16.0 | 16.06 | 15.94 | 16.02 | 113500.0 |
| 2006-07-18 | CIL | ETF | 25.21 | 25.21 | 25.21 | 25.21 | 200.0 |
| 2006-07-18 | CN | ETF | 34.17 | 34.57 | 34.14 | 34.57 | 53300.0 |
| 2006-07-18 | CNXT | ETF | 2.09 | 2.09 | 2.0 | 2.05 | 12912662.0 |
| 2006-07-18 | COMB | ETF | 9.79 | 9.8 | 9.79 | 9.8 | 200.0 |
| 2006-07-18 | CPI | ETF | 29.05 | 29.15 | 29.05 | 29.15 | 400.0 |
| 2006-07-18 | CPST | ETF | 2.0 | 2.16 | 1.89 | 1.94 | 2508525.0 |
| 2006-07-18 | CSA | ETF | 18.85 | 18.85 | 18.8 | 18.8 | 200.0 |
| 2006-07-18 | CSB | ETF | 26.9 | 26.9 | 26.42 | 26.57 | 12300.0 |
| 2006-07-18 | CSQ | ETF | 13.8 | 13.88 | 13.74 | 13.88 | 286600.0 |
| 2006-07-18 | CTEC | ETF | 57.85 | 60.4 | 57.85 | 59.349999999999994 | 24825.0 |
| 2006-07-18 | CYB | ETF | 5.9 | 5.94 | 5.83 | 5.83 | 31100.0 |
| 2006-07-18 | DBC | ETF | 26.09 | 26.26 | 25.55 | 25.74 | 206100.0 |
| 2006-07-18 | DDM | ETF | 5.67 | 5.67 | 5.5375 | 5.6542 | 1717200.0 |
| 2006-07-18 | DES | ETF | 16.87 | 16.8767 | 16.7333 | 16.8433 | 29700.0 |
| 2006-07-18 | DEW | ETF | 49.6 | 49.6 | 49.38 | 49.38 | 1600.0 |
| 2006-07-18 | DFJ | ETF | 46.59 | 46.66 | 46.5 | 46.66 | 800.0 |
| 2006-07-18 | DGT | ETF | 65.75 | 65.75 | 65.06 | 65.53 | 1800.0 |
| 2006-07-18 | DHS | ETF | 50.48 | 50.48 | 50.36 | 50.47 | 3100.0 |
> showing 50 of 355 rows — these rows as CSV