PREVIEW / etf_daily / 2006-08-22
file: by_date/etf_daily/2006/2006-08-22.parquet size: 18 KB rows: 361
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-08-22 | SPY | ETF | 129.99 | 130.52 | 129.68 | 130.12 | 60839900.0 |
| 2006-08-22 | QQQ | ETF | 38.36 | 38.81 | 38.2 | 38.43 | 102133232.0 |
| 2006-08-22 | IWM | ETF | 70.1 | 70.62 | 69.97 | 70.41 | 22657900.0 |
| 2006-08-22 | DIA | ETF | 113.28 | 113.75 | 112.93 | 113.28 | 3930800.0 |
| 2006-08-22 | GLD | ETF | 62.05 | 62.2 | 61.61 | 62.05 | 4067700.0 |
| 2006-08-22 | TLT | ETF | 87.0 | 87.23 | 86.97 | 87.11 | 749300.0 |
| 2006-08-22 | AAA | ETF | 56.88 | 57.1 | 56.83 | 57.1 | 6700.0 |
| 2006-08-22 | ADRE | ETF | 32.53 | 32.68 | 32.38 | 32.5425 | 70193.0 |
| 2006-08-22 | AFK | ETF | 25.34 | 25.34 | 25.25 | 25.25 | 9000.0 |
| 2006-08-22 | AGG | ETF | 99.21 | 99.3 | 99.13 | 99.27 | 432000.0 |
| 2006-08-22 | AIQ | ETF | 32.25 | 32.8 | 32.05 | 32.25 | 10460.0 |
| 2006-08-22 | AIS | ETF | 0.9 | 1.02 | 0.89 | 1.02 | 650700.0 |
| 2006-08-22 | AOM | ETF | 5.61 | 5.7 | 5.55 | 5.55 | 15600.0 |
| 2006-08-22 | ARB | ETF | 35.2 | 35.62 | 35.04 | 35.62 | 241400.0 |
| 2006-08-22 | BAB | ETF | 75.03 | 75.65 | 74.64 | 74.96 | 65100.0 |
| 2006-08-22 | BBC | ETF | 12.23 | 12.45 | 12.13 | 12.4 | 149500.0 |
| 2006-08-22 | BBH | ETF | 59.5 | 59.8633 | 58.82 | 58.9533 | 885300.0 |
| 2006-08-22 | BITS | ETF | 28.36 | 29.72 | 28.28 | 29.28 | 47892.0 |
| 2006-08-22 | BKF | ETF | 4.06 | 4.09 | 4.05 | 4.07 | 11600.0 |
| 2006-08-22 | BNE | ETF | 15.2 | 15.42 | 15.05 | 15.18 | 111300.0 |
| 2006-08-22 | BRF | ETF | 14.14 | 14.17 | 14.11 | 14.11 | 7300.0 |
| 2006-08-22 | BTF | ETF | 90.25 | 91.1 | 90.25 | 91.1 | 5620.0 |
| 2006-08-22 | CBON | ETF | 33.82 | 33.99 | 33.67 | 33.92 | 37496.0 |
| 2006-08-22 | CDL | ETF | 8.68 | 8.74 | 8.64 | 8.69 | 251900.0 |
| 2006-08-22 | CEF | ETF | 9.1 | 9.1 | 9.01 | 9.06 | 218800.0 |
| 2006-08-22 | CEW | ETF | 26.1 | 26.1 | 26.1 | 26.1 | 100.0 |
| 2006-08-22 | CFO | ETF | 10.05 | 10.1 | 10.05 | 10.06 | 4700.0 |
| 2006-08-22 | CGO | ETF | 15.57 | 15.6 | 15.25 | 15.33 | 36300.0 |
| 2006-08-22 | CHB | ETF | 6.31 | 6.42 | 6.15 | 6.26 | 1086600.0 |
| 2006-08-22 | CHI | ETF | 20.34 | 20.35 | 20.25 | 20.28 | 106000.0 |
| 2006-08-22 | CHIC | ETF | 27.7 | 28.03 | 27.5 | 27.56 | 592004.0 |
| 2006-08-22 | CHY | ETF | 16.48 | 16.5 | 16.37 | 16.41 | 126100.0 |
| 2006-08-22 | CIL | ETF | 25.52 | 25.52 | 25.52 | 25.52 | 400.0 |
| 2006-08-22 | CIZ | ETF | 22.0 | 22.15 | 22.0 | 22.15 | 1000.0 |
| 2006-08-22 | CN | ETF | 36.59 | 36.95 | 36.52 | 36.63 | 26200.0 |
| 2006-08-22 | CNXT | ETF | 2.06 | 2.22 | 2.03 | 2.2 | 21222705.0 |
| 2006-08-22 | COMB | ETF | 9.8 | 10.0 | 9.8 | 9.99 | 129271.0 |
| 2006-08-22 | CPI | ETF | 28.9 | 28.9 | 28.9 | 28.9 | 200.0 |
| 2006-08-22 | CPST | ETF | 1.95 | 1.96 | 1.87 | 1.91 | 877069.0 |
| 2006-08-22 | CSA | ETF | 18.5 | 18.65 | 18.35 | 18.43 | 31500.0 |
| 2006-08-22 | CSB | ETF | 29.21 | 29.37 | 29.18 | 29.28 | 13600.0 |
| 2006-08-22 | CSQ | ETF | 14.41 | 14.45 | 14.39 | 14.45 | 394500.0 |
| 2006-08-22 | CTEC | ETF | 53.49999999999999 | 54.74999999999999 | 53.15 | 53.4 | 8139.400000000001 |
| 2006-08-22 | CYB | ETF | 5.8 | 5.81 | 5.5 | 5.66 | 80800.0 |
| 2006-08-22 | DBC | ETF | 24.98 | 25.02 | 24.85 | 24.97 | 281500.0 |
| 2006-08-22 | DDM | ETF | 6.225 | 6.2725 | 6.1775 | 6.2233 | 688800.0 |
| 2006-08-22 | DES | ETF | 17.35 | 17.45 | 17.35 | 17.4467 | 13200.0 |
| 2006-08-22 | DEW | ETF | 54.33 | 54.4 | 54.16 | 54.3 | 17400.0 |
| 2006-08-22 | DFE | ETF | 55.5 | 55.7 | 55.5 | 55.57 | 400.0 |
| 2006-08-22 | DFJ | ETF | 51.37 | 51.37 | 51.2 | 51.33 | 500.0 |
> showing 50 of 361 rows — these rows as CSV