PREVIEW / etf_daily / 2006-12-14
file: by_date/etf_daily/2006/2006-12-14.parquet size: 19 KB rows: 383
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-12-14 | SPY | ETF | 141.86 | 143.24 | 141.84 | 143.12 | 64755200.0 |
| 2006-12-14 | QQQ | ETF | 43.97 | 44.57 | 43.94 | 44.37 | 109144918.0 |
| 2006-12-14 | IWM | ETF | 78.62 | 79.59 | 78.56 | 78.97 | 52286200.0 |
| 2006-12-14 | DIA | ETF | 123.21 | 124.38 | 123.2 | 124.23 | 6851000.0 |
| 2006-12-14 | GLD | ETF | 62.29 | 62.47 | 62.04 | 62.12 | 2237300.0 |
| 2006-12-14 | TLT | ETF | 89.82 | 89.9 | 89.6 | 89.68 | 687600.0 |
| 2006-12-14 | AAA | ETF | 61.03 | 61.03 | 60.51 | 60.72 | 3600.0 |
| 2006-12-14 | ADRE | ETF | 37.5 | 37.8 | 37.47 | 37.79 | 97400.0 |
| 2006-12-14 | AGG | ETF | 100.48 | 100.48 | 100.26 | 100.33 | 2320000.0 |
| 2006-12-14 | AIQ | ETF | 31.8 | 32.0 | 31.05 | 31.3 | 35400.0 |
| 2006-12-14 | AIS | ETF | 1.17 | 1.18 | 1.13 | 1.15 | 289200.0 |
| 2006-12-14 | ARB | ETF | 44.36 | 44.92 | 44.21 | 44.63 | 191400.0 |
| 2006-12-14 | BAB | ETF | 102.5 | 102.94 | 101.5299 | 101.86 | 77200.0 |
| 2006-12-14 | BBC | ETF | 4.1 | 4.65 | 4.01 | 4.65 | 608400.0 |
| 2006-12-14 | BBH | ETF | 61.9267 | 62.35 | 61.7333 | 61.8667 | 1528800.0 |
| 2006-12-14 | BITS | ETF | 34.12 | 34.76 | 33.56 | 34.04 | 10883.0 |
| 2006-12-14 | BNE | ETF | 15.61 | 15.8 | 15.55 | 15.56 | 99800.0 |
| 2006-12-14 | BRF | ETF | 14.21 | 14.29 | 14.21 | 14.28 | 19200.0 |
| 2006-12-14 | BTF | ETF | 112.6 | 113.75 | 112.6 | 113.39999999999999 | 1440.0 |
| 2006-12-14 | CBON | ETF | 30.33 | 30.49 | 30.22 | 30.24 | 36302.0 |
| 2006-12-14 | CDL | ETF | 9.66 | 9.79 | 9.55 | 9.65 | 711600.0 |
| 2006-12-14 | CEF | ETF | 9.51 | 9.55 | 9.45 | 9.45 | 240700.0 |
| 2006-12-14 | CEW | ETF | 25.63 | 25.63 | 25.6 | 25.61 | 700.0 |
| 2006-12-14 | CFO | ETF | 11.13 | 11.13 | 11.12 | 11.12 | 9100.0 |
| 2006-12-14 | CGO | ETF | 16.4 | 17.04 | 16.4 | 16.78 | 25000.0 |
| 2006-12-14 | CHB | ETF | 9.62 | 9.84 | 9.505 | 9.73 | 871400.0 |
| 2006-12-14 | CHI | ETF | 20.08 | 20.19 | 20.08 | 20.1001 | 63500.0 |
| 2006-12-14 | CHIC | ETF | 31.04 | 31.85 | 31.01 | 31.62 | 485461.0 |
| 2006-12-14 | CHY | ETF | 17.1 | 17.11 | 16.95 | 16.99 | 122000.0 |
| 2006-12-14 | CIL | ETF | 25.34 | 25.34 | 25.34 | 25.34 | 1000.0 |
| 2006-12-14 | CN | ETF | 46.8 | 47.15 | 46.8 | 47.15 | 59700.0 |
| 2006-12-14 | CNXT | ETF | 2.15 | 2.1701 | 2.13 | 2.17 | 5865902.0 |
| 2006-12-14 | CPI | ETF | 23.64 | 23.64 | 23.64 | 23.64 | 200.0 |
| 2006-12-14 | CPST | ETF | 1.29 | 1.34 | 1.29 | 1.3 | 932823.0 |
| 2006-12-14 | CSA | ETF | 22.0 | 22.03 | 21.4 | 21.4 | 15600.0 |
| 2006-12-14 | CSB | ETF | 33.13 | 33.34 | 33.12 | 33.28 | 12800.0 |
| 2006-12-14 | CSM | ETF | 1.3175 | 1.32 | 1.3175 | 1.32 | 800.0 |
| 2006-12-14 | CSQ | ETF | 15.55 | 15.59 | 15.41 | 15.56 | 423200.0 |
| 2006-12-14 | CTEC | ETF | 93.49999999999999 | 95.29999999999998 | 93.49999999999999 | 95.0 | 24433.4 |
| 2006-12-14 | CVY | ETF | 26.82 | 26.95 | 26.78 | 26.95 | 28400.0 |
| 2006-12-14 | DBC | ETF | 25.35 | 25.55 | 25.25 | 25.4 | 190500.0 |
| 2006-12-14 | DBV | ETF | 25.5 | 25.59 | 25.43 | 25.56 | 29100.0 |
| 2006-12-14 | DDM | ETF | 7.3017 | 7.4292 | 7.3017 | 7.4125 | 925200.0 |
| 2006-12-14 | DES | ETF | 19.2733 | 19.43 | 19.2733 | 19.35 | 69900.0 |
| 2006-12-14 | DEW | ETF | 61.8 | 61.94 | 61.7 | 61.94 | 10700.0 |
| 2006-12-14 | DFE | ETF | 64.55 | 64.75 | 64.47 | 64.7 | 16600.0 |
| 2006-12-14 | DFJ | ETF | 50.93 | 51.2 | 50.93 | 51.07 | 39400.0 |
| 2006-12-14 | DGT | ETF | 75.85 | 76.47 | 75.83 | 76.29 | 52000.0 |
| 2006-12-14 | DHS | ETF | 57.41 | 57.87 | 57.41 | 57.83 | 22200.0 |
| 2006-12-14 | DIM | ETF | 63.25 | 63.47 | 63.25 | 63.42 | 17300.0 |
> showing 50 of 383 rows — these rows as CSV