PREVIEW / etf_daily / 2006-11-29
file: by_date/etf_daily/2006/2006-11-29.parquet size: 19 KB rows: 382
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-29 | SPY | ETF | 139.47 | 140.53 | 139.08 | 140.47 | 90034900.0 |
| 2006-11-29 | QQQ | ETF | 44.0 | 44.18 | 43.66 | 44.07 | 139573986.0 |
| 2006-11-29 | IWM | ETF | 77.52 | 78.21 | 77.3 | 78.06 | 53282800.0 |
| 2006-11-29 | DIA | ETF | 121.59 | 122.4 | 121.55 | 122.33 | 9318400.0 |
| 2006-11-29 | GLD | ETF | 63.37 | 63.39 | 63.08 | 63.16 | 4006500.0 |
| 2006-11-29 | TLT | ETF | 91.3 | 91.36 | 90.91 | 90.93 | 1206400.0 |
| 2006-11-29 | AAA | ETF | 58.1 | 58.15 | 58.0 | 58.13 | 1700.0 |
| 2006-11-29 | ADRE | ETF | 35.96 | 36.624 | 35.96 | 36.57 | 123106.0 |
| 2006-11-29 | AGG | ETF | 100.94 | 100.95 | 100.69 | 100.76 | 300900.0 |
| 2006-11-29 | AIQ | ETF | 29.75 | 30.05 | 29.3 | 29.45 | 70700.0 |
| 2006-11-29 | AIS | ETF | 1.24 | 1.28 | 1.2399 | 1.26 | 363900.0 |
| 2006-11-29 | ARB | ETF | 44.64 | 44.98 | 44.35 | 44.76 | 110600.0 |
| 2006-11-29 | BAB | ETF | 96.15 | 96.92 | 95.74 | 95.82 | 71900.0 |
| 2006-11-29 | BBC | ETF | 5.43 | 5.45 | 5.3 | 5.41 | 165300.0 |
| 2006-11-29 | BBH | ETF | 62.4 | 63.0333 | 62.3333 | 62.92 | 909900.0 |
| 2006-11-29 | BITS | ETF | 32.72 | 34.28 | 32.72 | 33.92 | 29754.0 |
| 2006-11-29 | BNE | ETF | 15.74 | 15.95 | 15.72 | 15.76 | 214500.0 |
| 2006-11-29 | BRF | ETF | 14.31 | 14.35 | 14.3 | 14.31 | 12100.0 |
| 2006-11-29 | BTF | ETF | 105.5 | 107.5 | 105.25 | 107.5 | 4100.0 |
| 2006-11-29 | CBON | ETF | 30.32 | 31.03 | 30.32 | 30.82 | 44944.0 |
| 2006-11-29 | CDL | ETF | 9.55 | 9.64 | 9.44 | 9.52 | 461900.0 |
| 2006-11-29 | CEF | ETF | 10.23 | 10.23 | 10.0 | 10.01 | 709300.0 |
| 2006-11-29 | CEW | ETF | 25.6 | 25.6 | 25.58 | 25.58 | 200.0 |
| 2006-11-29 | CFO | ETF | 11.0 | 11.1 | 11.0 | 11.045 | 1800.0 |
| 2006-11-29 | CGO | ETF | 16.2 | 16.55 | 16.11 | 16.52 | 20100.0 |
| 2006-11-29 | CHB | ETF | 8.97 | 9.22 | 8.94 | 9.08 | 994300.0 |
| 2006-11-29 | CHI | ETF | 19.9 | 19.99 | 19.9 | 19.96 | 93400.0 |
| 2006-11-29 | CHIC | ETF | 29.43 | 31.24 | 29.37 | 30.89 | 1241317.0 |
| 2006-11-29 | CHY | ETF | 16.95 | 17.14 | 16.95 | 17.07 | 123700.0 |
| 2006-11-29 | CIL | ETF | 25.13 | 25.13 | 25.13 | 25.13 | 800.0 |
| 2006-11-29 | CN | ETF | 39.65 | 40.16 | 39.65 | 39.95 | 79200.0 |
| 2006-11-29 | CNXT | ETF | 2.11 | 2.14 | 2.1 | 2.1 | 17502323.0 |
| 2006-11-29 | CPST | ETF | 1.39 | 1.4 | 1.34 | 1.37 | 1195781.0 |
| 2006-11-29 | CSA | ETF | 21.35 | 21.85 | 21.35 | 21.85 | 40300.0 |
| 2006-11-29 | CSB | ETF | 31.91 | 32.16 | 31.82 | 32.15 | 6100.0 |
| 2006-11-29 | CSQ | ETF | 15.38 | 15.4 | 15.22 | 15.3 | 465400.0 |
| 2006-11-29 | CTEC | ETF | 91.95 | 94.49999999999999 | 91.8 | 94.04999999999998 | 30724.800000000003 |
| 2006-11-29 | CVY | ETF | 26.25 | 26.47 | 26.25 | 26.46 | 23400.0 |
| 2006-11-29 | DBC | ETF | 25.02 | 25.57 | 25.0 | 25.55 | 422700.0 |
| 2006-11-29 | DBV | ETF | 25.15 | 25.23 | 25.07 | 25.13 | 233400.0 |
| 2006-11-29 | DDM | ETF | 7.15 | 7.215 | 7.1308 | 7.2 | 1005600.0 |
| 2006-11-29 | DES | ETF | 18.95 | 19.1133 | 18.95 | 19.11 | 26100.0 |
| 2006-11-29 | DEW | ETF | 60.01 | 60.11 | 59.72 | 59.97 | 8100.0 |
| 2006-11-29 | DFE | ETF | 61.9 | 61.93 | 61.53 | 61.88 | 6400.0 |
| 2006-11-29 | DFJ | ETF | 49.45 | 49.52 | 49.17 | 49.45 | 22300.0 |
| 2006-11-29 | DGT | ETF | 74.6 | 75.0 | 74.53 | 74.92 | 116800.0 |
| 2006-11-29 | DHS | ETF | 56.45 | 56.79 | 56.45 | 56.67 | 12000.0 |
| 2006-11-29 | DIM | ETF | 61.1 | 61.2 | 60.83 | 61.16 | 9700.0 |
| 2006-11-29 | DIV | ETF | 13.3 | 13.36 | 13.27 | 13.36 | 30000.0 |
| 2006-11-29 | DJP | ETF | 49.94 | 50.7 | 49.93 | 50.68 | 212500.0 |
> showing 50 of 382 rows — these rows as CSV