PREVIEW / etf_daily / 2006-11-24
file: by_date/etf_daily/2006/2006-11-24.parquet size: 18 KB rows: 369
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-24 | SPY | ETF | 140.24 | 140.84 | 140.2 | 140.35 | 30998000.0 |
| 2006-11-24 | QQQ | ETF | 44.4 | 44.86 | 44.38 | 44.65 | 51798358.0 |
| 2006-11-24 | IWM | ETF | 78.37 | 79.03 | 78.23 | 78.56 | 17933400.0 |
| 2006-11-24 | DIA | ETF | 122.67 | 123.1 | 122.53 | 122.68 | 2480000.0 |
| 2006-11-24 | GLD | ETF | 63.48 | 63.68 | 63.31 | 63.5 | 6886100.0 |
| 2006-11-24 | TLT | ETF | 90.75 | 90.9 | 90.62 | 90.62 | 533400.0 |
| 2006-11-24 | AAA | ETF | 57.8 | 58.2 | 57.8 | 58.2 | 1300.0 |
| 2006-11-24 | ADRE | ETF | 36.27 | 36.61 | 36.12 | 36.55 | 32413.0 |
| 2006-11-24 | AGG | ETF | 100.7 | 100.78 | 100.65 | 100.69 | 176200.0 |
| 2006-11-24 | AIQ | ETF | 30.25 | 30.638 | 30.1 | 30.35 | 33500.0 |
| 2006-11-24 | AIS | ETF | 1.1899 | 1.22 | 1.0 | 1.2 | 93800.0 |
| 2006-11-24 | ARB | ETF | 44.43 | 45.25 | 44.34 | 45.0 | 52200.0 |
| 2006-11-24 | BAB | ETF | 94.82 | 95.8 | 94.79 | 95.18 | 34800.0 |
| 2006-11-24 | BBC | ETF | 5.28 | 5.45 | 5.25 | 5.32 | 171800.0 |
| 2006-11-24 | BBH | ETF | 62.5667 | 62.73 | 62.3767 | 62.4267 | 281100.0 |
| 2006-11-24 | BITS | ETF | 35.96 | 35.96 | 35.08 | 35.68 | 10202.0 |
| 2006-11-24 | BNE | ETF | 15.78 | 16.26 | 15.78 | 16.21 | 95200.0 |
| 2006-11-24 | BTF | ETF | 106.75 | 106.75 | 106.45149999999998 | 106.6 | 400.0 |
| 2006-11-24 | CBON | ETF | 30.21 | 30.27 | 30.1 | 30.22 | 14031.0 |
| 2006-11-24 | CDL | ETF | 9.79 | 9.79 | 9.56 | 9.57 | 199200.0 |
| 2006-11-24 | CEF | ETF | 9.51 | 9.77 | 9.5 | 9.73 | 531400.0 |
| 2006-11-24 | CEW | ETF | 25.58 | 25.58 | 25.58 | 25.58 | 300.0 |
| 2006-11-24 | CGO | ETF | 16.05 | 16.13 | 16.05 | 16.12 | 8800.0 |
| 2006-11-24 | CHB | ETF | 9.12 | 9.38 | 9.1 | 9.25 | 338100.0 |
| 2006-11-24 | CHI | ETF | 19.62 | 19.9 | 19.61 | 19.86 | 35200.0 |
| 2006-11-24 | CHIC | ETF | 29.14 | 29.55 | 28.83 | 29.45 | 133806.0 |
| 2006-11-24 | CHY | ETF | 16.9 | 16.9 | 16.85 | 16.9 | 64400.0 |
| 2006-11-24 | CN | ETF | 38.7 | 39.09 | 38.7 | 39.04 | 22200.0 |
| 2006-11-24 | CNXT | ETF | 2.24 | 2.26 | 2.22 | 2.25 | 1572834.0 |
| 2006-11-24 | CPI | ETF | 24.15 | 24.3599 | 24.15 | 24.3 | 700.0 |
| 2006-11-24 | CPST | ETF | 1.32 | 1.35 | 1.32 | 1.34 | 455737.0 |
| 2006-11-24 | CSA | ETF | 21.3 | 21.36 | 21.3 | 21.36 | 900.0 |
| 2006-11-24 | CSB | ETF | 31.92 | 32.13 | 31.86 | 32.11 | 7000.0 |
| 2006-11-24 | CSM | ETF | 1.325 | 1.325 | 1.325 | 1.325 | 20000.0 |
| 2006-11-24 | CSQ | ETF | 15.39 | 15.4 | 15.25 | 15.31 | 281500.0 |
| 2006-11-24 | CTEC | ETF | 90.19999999999999 | 91.35 | 89.7 | 90.35 | 5386.6 |
| 2006-11-24 | CVY | ETF | 26.4 | 26.44 | 26.3 | 26.43 | 17800.0 |
| 2006-11-24 | DBC | ETF | 24.85 | 25.09 | 24.82 | 25.09 | 63700.0 |
| 2006-11-24 | DBV | ETF | 25.0 | 25.08 | 24.89 | 25.06 | 29100.0 |
| 2006-11-24 | DDM | ETF | 7.25 | 7.3067 | 7.245 | 7.2708 | 436800.0 |
| 2006-11-24 | DES | ETF | 19.1 | 19.2233 | 19.1 | 19.2067 | 10200.0 |
| 2006-11-24 | DEW | ETF | 59.7 | 59.97 | 59.7 | 59.92 | 2800.0 |
| 2006-11-24 | DFE | ETF | 61.52 | 61.52 | 61.3 | 61.3 | 1500.0 |
| 2006-11-24 | DFJ | ETF | 47.88 | 48.01 | 47.75 | 47.75 | 29700.0 |
| 2006-11-24 | DGT | ETF | 74.4 | 74.86 | 74.4 | 74.76 | 4600.0 |
| 2006-11-24 | DHS | ETF | 56.75 | 56.8 | 56.66 | 56.71 | 5500.0 |
| 2006-11-24 | DIM | ETF | 60.47 | 60.76 | 60.47 | 60.55 | 9500.0 |
| 2006-11-24 | DIV | ETF | 13.24 | 13.32 | 13.17 | 13.32 | 15900.0 |
| 2006-11-24 | DJP | ETF | 49.8 | 50.1 | 49.78 | 50.1 | 45700.0 |
| 2006-11-24 | DLN | ETF | 28.4 | 28.465 | 28.4 | 28.435 | 6000.0 |
> showing 50 of 369 rows — these rows as CSV