PREVIEW / etf_daily / 2006-11-30
file: by_date/etf_daily/2006/2006-11-30.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-11-30 | SPY | ETF | 140.44 | 141.05 | 139.76 | 140.53 | 83994300.0 |
| 2006-11-30 | QQQ | ETF | 44.05 | 44.28 | 43.79 | 44.04 | 125015540.0 |
| 2006-11-30 | IWM | ETF | 77.9 | 78.6 | 77.5 | 78.07 | 58605000.0 |
| 2006-11-30 | DIA | ETF | 122.33 | 122.77 | 121.63 | 122.28 | 12809400.0 |
| 2006-11-30 | GLD | ETF | 64.07 | 64.43 | 63.9 | 64.39 | 6362700.0 |
| 2006-11-30 | TLT | ETF | 91.27 | 91.63 | 91.14 | 91.53 | 1428600.0 |
| 2006-11-30 | AAA | ETF | 58.24 | 58.5706 | 58.11 | 58.51 | 1200.0 |
| 2006-11-30 | ADRE | ETF | 36.7 | 36.9 | 36.466 | 36.88 | 117911.0 |
| 2006-11-30 | AGG | ETF | 100.94 | 101.13 | 100.86 | 101.07 | 210500.0 |
| 2006-11-30 | AIQ | ETF | 29.4 | 29.95 | 29.15 | 29.8 | 83400.0 |
| 2006-11-30 | AIS | ETF | 1.27 | 1.3 | 1.25 | 1.29 | 143300.0 |
| 2006-11-30 | ARB | ETF | 44.76 | 44.76 | 44.1 | 44.11 | 135800.0 |
| 2006-11-30 | BAB | ETF | 96.33 | 97.36 | 95.53 | 96.96 | 85800.0 |
| 2006-11-30 | BBC | ETF | 5.43 | 5.43 | 5.3 | 5.31 | 117600.0 |
| 2006-11-30 | BBH | ETF | 63.0767 | 63.2 | 62.4333 | 62.4967 | 991800.0 |
| 2006-11-30 | BITS | ETF | 34.52 | 35.24 | 34.0 | 35.0 | 34693.0 |
| 2006-11-30 | BNE | ETF | 15.68 | 15.89 | 15.59 | 15.82 | 202300.0 |
| 2006-11-30 | BOSS | ETF | 40.15 | 40.15 | 40.15 | 40.15 | 100.0 |
| 2006-11-30 | BRF | ETF | 14.33 | 14.3512 | 14.33 | 14.33 | 13400.0 |
| 2006-11-30 | BTF | ETF | 107.5 | 107.94999999999999 | 106.99999999999999 | 107.94999999999999 | 4420.0 |
| 2006-11-30 | CBON | ETF | 30.99 | 30.99 | 30.39 | 30.39 | 34261.0 |
| 2006-11-30 | CDL | ETF | 9.5 | 9.55 | 9.44 | 9.51 | 534400.0 |
| 2006-11-30 | CEF | ETF | 9.45 | 10.0 | 9.45 | 9.84 | 3693600.0 |
| 2006-11-30 | CEW | ETF | 25.59 | 25.6 | 25.59 | 25.6 | 1000.0 |
| 2006-11-30 | CFO | ETF | 11.05 | 11.05 | 11.02 | 11.02 | 16100.0 |
| 2006-11-30 | CGO | ETF | 16.6 | 16.79 | 16.46 | 16.76 | 29100.0 |
| 2006-11-30 | CHB | ETF | 9.08 | 9.76 | 9.07 | 9.35 | 2024300.0 |
| 2006-11-30 | CHI | ETF | 19.92 | 20.06 | 19.9 | 20.01 | 114900.0 |
| 2006-11-30 | CHIC | ETF | 30.88 | 30.88 | 29.67 | 30.16 | 758213.0 |
| 2006-11-30 | CHY | ETF | 17.06 | 17.22 | 17.06 | 17.18 | 87400.0 |
| 2006-11-30 | CIL | ETF | 25.12 | 25.13 | 25.12 | 25.13 | 500.0 |
| 2006-11-30 | CN | ETF | 39.89 | 40.1 | 39.54 | 40.0 | 45600.0 |
| 2006-11-30 | CNXT | ETF | 2.11 | 2.2 | 2.08 | 2.15 | 20272484.0 |
| 2006-11-30 | CPST | ETF | 1.36 | 1.39 | 1.34 | 1.36 | 921983.0 |
| 2006-11-30 | CSA | ETF | 21.9 | 21.9 | 21.76 | 21.88 | 59600.0 |
| 2006-11-30 | CSB | ETF | 32.44 | 32.79 | 32.44 | 32.76 | 8200.0 |
| 2006-11-30 | CSM | ETF | 1.3225 | 1.325 | 1.32 | 1.325 | 50000.0 |
| 2006-11-30 | CSQ | ETF | 15.3 | 15.37 | 15.22 | 15.33 | 385900.0 |
| 2006-11-30 | CTEC | ETF | 94.04999999999998 | 94.35 | 91.64999999999999 | 91.89999999999999 | 15342.6 |
| 2006-11-30 | CVY | ETF | 26.5 | 26.6 | 26.41 | 26.53 | 85600.0 |
| 2006-11-30 | DBC | ETF | 25.73 | 25.9 | 25.61 | 25.78 | 347000.0 |
| 2006-11-30 | DBV | ETF | 25.21 | 25.23 | 25.06 | 25.14 | 138900.0 |
| 2006-11-30 | DDM | ETF | 7.2208 | 7.2592 | 7.1267 | 7.2183 | 1101600.0 |
| 2006-11-30 | DES | ETF | 19.09 | 19.2167 | 19.0067 | 19.1367 | 60000.0 |
| 2006-11-30 | DEW | ETF | 60.23 | 60.53 | 60.1 | 60.41 | 6200.0 |
| 2006-11-30 | DFE | ETF | 62.4 | 63.09 | 62.4 | 62.9 | 23500.0 |
| 2006-11-30 | DFJ | ETF | 49.85 | 50.15 | 49.8 | 49.93 | 4700.0 |
| 2006-11-30 | DGT | ETF | 74.81 | 75.2 | 74.61 | 75.07 | 14500.0 |
| 2006-11-30 | DHS | ETF | 56.7 | 56.94 | 56.56 | 56.74 | 23700.0 |
| 2006-11-30 | DIM | ETF | 61.4 | 61.65 | 61.28 | 61.5 | 21500.0 |
> showing 50 of 383 rows — these rows as CSV