PREVIEW / etf_daily / 2006-11-10
file: by_date/etf_daily/2006/2006-11-10.parquet size: 19 KB rows: 385
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-11-10 | SPY | ETF | 138.14 | 138.34 | 137.72 | 138.24 | 48991500.0 |
| 2006-11-10 | QQQ | ETF | 42.84 | 43.04 | 42.67 | 43.03 | 82435046.0 |
| 2006-11-10 | IWM | ETF | 75.77 | 76.57 | 75.61 | 76.52 | 43722400.0 |
| 2006-11-10 | DIA | ETF | 121.12 | 121.26 | 120.77 | 121.11 | 3718400.0 |
| 2006-11-10 | GLD | ETF | 62.7 | 62.82 | 62.06 | 62.49 | 4437000.0 |
| 2006-11-10 | TLT | ETF | 89.65 | 90.04 | 89.65 | 89.86 | 738100.0 |
| 2006-11-10 | AAA | ETF | 56.66 | 57.0 | 56.66 | 57.0 | 1900.0 |
| 2006-11-10 | ADRE | ETF | 35.54 | 35.54 | 35.32 | 35.4299 | 141167.0 |
| 2006-11-10 | AGG | ETF | 100.25 | 100.34 | 100.12 | 100.32 | 145400.0 |
| 2006-11-10 | AIQ | ETF | 38.0 | 38.65 | 36.8 | 38.35 | 20800.0 |
| 2006-11-10 | AIS | ETF | 1.22 | 1.25 | 1.21 | 1.25 | 84000.0 |
| 2006-11-10 | ARB | ETF | 42.69 | 43.96 | 42.66 | 43.64 | 195200.0 |
| 2006-11-10 | BAB | ETF | 87.61 | 88.0 | 87.3101 | 87.54 | 28800.0 |
| 2006-11-10 | BBC | ETF | 10.58 | 10.84 | 10.4 | 10.74 | 199700.0 |
| 2006-11-10 | BBH | ETF | 62.4333 | 62.6567 | 62.1333 | 62.65 | 963000.0 |
| 2006-11-10 | BITS | ETF | 38.32 | 39.48 | 37.84 | 38.44 | 49371.0 |
| 2006-11-10 | BNE | ETF | 14.82 | 15.09 | 14.57 | 15.01 | 128500.0 |
| 2006-11-10 | BRF | ETF | 14.3 | 14.34 | 14.26 | 14.34 | 18600.0 |
| 2006-11-10 | BTF | ETF | 105.05 | 105.29999999999998 | 105.05 | 105.15 | 620.0 |
| 2006-11-10 | CBON | ETF | 29.68 | 29.97 | 29.64 | 29.75 | 75403.0 |
| 2006-11-10 | CDL | ETF | 10.53 | 10.55 | 10.25 | 10.42 | 390600.0 |
| 2006-11-10 | CEF | ETF | 9.06 | 9.16 | 9.0 | 9.15 | 359200.0 |
| 2006-11-10 | CEW | ETF | 25.53 | 25.53 | 25.52 | 25.52 | 1000.0 |
| 2006-11-10 | CFO | ETF | 10.71 | 10.71 | 10.71 | 10.71 | 1000.0 |
| 2006-11-10 | CGO | ETF | 15.62 | 15.67 | 15.57 | 15.67 | 16600.0 |
| 2006-11-10 | CHB | ETF | 8.44 | 8.75 | 8.4 | 8.55 | 1373100.0 |
| 2006-11-10 | CHI | ETF | 19.53 | 19.75 | 19.53 | 19.6 | 83400.0 |
| 2006-11-10 | CHIC | ETF | 27.32 | 28.75 | 27.32 | 28.58 | 809925.0 |
| 2006-11-10 | CHY | ETF | 16.71 | 16.9 | 16.7 | 16.83 | 130800.0 |
| 2006-11-10 | CN | ETF | 39.55 | 39.62 | 38.97 | 39.28 | 60000.0 |
| 2006-11-10 | CNXT | ETF | 2.19 | 2.27 | 2.16 | 2.19 | 27422953.0 |
| 2006-11-10 | CPST | ETF | 1.37 | 1.43 | 1.32 | 1.4 | 4944599.0 |
| 2006-11-10 | CSA | ETF | 19.91 | 20.05 | 19.91 | 19.97 | 29400.0 |
| 2006-11-10 | CSB | ETF | 31.47 | 31.5 | 31.25 | 31.25 | 7800.0 |
| 2006-11-10 | CSM | ETF | 1.3125 | 1.3125 | 1.2975 | 1.2975 | 72000.0 |
| 2006-11-10 | CSQ | ETF | 14.8 | 14.84 | 14.77 | 14.83 | 285300.0 |
| 2006-11-10 | CTEC | ETF | 88.8 | 88.8 | 86.1 | 86.75 | 25583.4 |
| 2006-11-10 | CVY | ETF | 25.85 | 25.87 | 25.8 | 25.87 | 20800.0 |
| 2006-11-10 | CYB | ETF | 6.62 | 6.74 | 6.6 | 6.74 | 15000.0 |
| 2006-11-10 | DBC | ETF | 25.08 | 25.11 | 24.62 | 24.76 | 194400.0 |
| 2006-11-10 | DBV | ETF | 25.25 | 25.27 | 25.17 | 25.27 | 91300.0 |
| 2006-11-10 | DDM | ETF | 7.065 | 7.0667 | 7.0167 | 7.0508 | 742800.0 |
| 2006-11-10 | DES | ETF | 18.55 | 18.6667 | 18.5267 | 18.6667 | 21900.0 |
| 2006-11-10 | DEW | ETF | 59.44 | 59.53 | 59.41 | 59.52 | 2100.0 |
| 2006-11-10 | DFE | ETF | 60.28 | 60.45 | 60.28 | 60.42 | 5500.0 |
| 2006-11-10 | DFJ | ETF | 48.28 | 48.28 | 48.1 | 48.1 | 400.0 |
| 2006-11-10 | DGT | ETF | 74.3 | 74.3 | 73.95 | 74.13 | 5000.0 |
| 2006-11-10 | DHS | ETF | 56.05 | 56.05 | 55.76 | 55.87 | 27600.0 |
| 2006-11-10 | DIM | ETF | 59.95 | 59.95 | 59.75 | 59.85 | 10000.0 |
| 2006-11-10 | DIV | ETF | 13.14 | 13.3 | 13.14 | 13.25 | 49000.0 |
> showing 50 of 385 rows — these rows as CSV