PREVIEW / etf_daily / 2006-08-24
file: by_date/etf_daily/2006/2006-08-24.parquet size: 18 KB rows: 363
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-24 | SPY | ETF | 129.99 | 130.1 | 129.4 | 129.65 | 57983000.0 |
| 2006-08-24 | QQQ | ETF | 38.26 | 38.35 | 37.92 | 38.25 | 79002027.0 |
| 2006-08-24 | IWM | ETF | 69.72 | 69.87 | 68.91 | 69.48 | 32255600.0 |
| 2006-08-24 | DIA | ETF | 113.2 | 113.34 | 112.67 | 112.8 | 4049000.0 |
| 2006-08-24 | GLD | ETF | 61.98 | 62.06 | 61.45 | 61.75 | 2198000.0 |
| 2006-08-24 | TLT | ETF | 87.41 | 87.44 | 87.24 | 87.31 | 1206700.0 |
| 2006-08-24 | AAA | ETF | 57.8 | 57.9799 | 57.5 | 57.59 | 2600.0 |
| 2006-08-24 | ADRE | ETF | 31.97 | 32.12 | 31.6 | 31.86 | 344769.0 |
| 2006-08-24 | AFK | ETF | 25.31 | 25.35 | 25.31 | 25.35 | 5200.0 |
| 2006-08-24 | AGG | ETF | 99.36 | 99.37 | 99.22 | 99.22 | 199600.0 |
| 2006-08-24 | AIQ | ETF | 32.45 | 33.2 | 32.15 | 32.7 | 20200.0 |
| 2006-08-24 | AIS | ETF | 1.09 | 1.1 | 1.05 | 1.05 | 142200.0 |
| 2006-08-24 | AOM | ETF | 5.7 | 5.7 | 5.47 | 5.47 | 25000.0 |
| 2006-08-24 | ARB | ETF | 35.31 | 35.9 | 35.29 | 35.82 | 265200.0 |
| 2006-08-24 | BAB | ETF | 75.25 | 75.43 | 74.56 | 74.89 | 47300.0 |
| 2006-08-24 | BBC | ETF | 12.23 | 12.34 | 11.92 | 12.12 | 244800.0 |
| 2006-08-24 | BBH | ETF | 59.1833 | 59.4633 | 58.6433 | 58.9333 | 584100.0 |
| 2006-08-24 | BITS | ETF | 28.64 | 29.2 | 27.5544 | 28.32 | 31428.0 |
| 2006-08-24 | BKF | ETF | 4.05 | 4.05 | 3.9 | 3.9 | 38300.0 |
| 2006-08-24 | BNE | ETF | 15.1 | 15.21 | 14.7 | 14.94 | 98800.0 |
| 2006-08-24 | BRF | ETF | 14.09 | 14.1 | 14.08 | 14.1 | 7600.0 |
| 2006-08-24 | BTF | ETF | 90.74999999999999 | 90.74999999999999 | 90.5 | 90.7 | 1220.0 |
| 2006-08-24 | CBON | ETF | 34.14 | 34.14 | 33.62 | 33.81 | 24345.0 |
| 2006-08-24 | CDL | ETF | 8.65 | 8.8 | 8.63 | 8.75 | 301600.0 |
| 2006-08-24 | CEF | ETF | 9.09 | 9.09 | 8.91 | 8.92 | 354100.0 |
| 2006-08-24 | CEW | ETF | 26.35 | 26.44 | 26.19 | 26.19 | 1300.0 |
| 2006-08-24 | CFO | ETF | 10.1 | 10.1 | 10.1 | 10.1 | 7400.0 |
| 2006-08-24 | CGO | ETF | 15.18 | 15.42 | 15.18 | 15.25 | 20000.0 |
| 2006-08-24 | CHB | ETF | 6.0 | 6.15 | 5.77 | 5.91 | 965600.0 |
| 2006-08-24 | CHI | ETF | 20.27 | 20.34 | 20.22 | 20.2799 | 75800.0 |
| 2006-08-24 | CHIC | ETF | 27.62 | 27.62 | 26.53 | 26.84 | 421761.0 |
| 2006-08-24 | CHY | ETF | 16.35 | 16.44 | 16.31 | 16.34 | 153800.0 |
| 2006-08-24 | CIZ | ETF | 22.3 | 22.3 | 22.3 | 22.3 | 200.0 |
| 2006-08-24 | CN | ETF | 33.6 | 33.7 | 33.31 | 33.5 | 96900.0 |
| 2006-08-24 | CNXT | ETF | 2.18 | 2.19 | 2.07 | 2.1 | 12237623.0 |
| 2006-08-24 | COMB | ETF | 9.85 | 9.9 | 9.85 | 9.9 | 53300.0 |
| 2006-08-24 | CPI | ETF | 29.0 | 29.2 | 29.0 | 29.1 | 700.0 |
| 2006-08-24 | CPST | ETF | 1.89 | 1.89 | 1.82 | 1.85 | 1136411.0 |
| 2006-08-24 | CSA | ETF | 18.65 | 18.79 | 18.65 | 18.75 | 5200.0 |
| 2006-08-24 | CSB | ETF | 29.3 | 29.35 | 29.05 | 29.12 | 12000.0 |
| 2006-08-24 | CSQ | ETF | 14.4 | 14.44 | 14.33 | 14.4 | 333600.0 |
| 2006-08-24 | CTEC | ETF | 55.099999999999994 | 55.25 | 53.349999999999994 | 53.8 | 7305.400000000001 |
| 2006-08-24 | CYB | ETF | 5.6 | 5.64 | 5.52 | 5.64 | 76200.0 |
| 2006-08-24 | DBC | ETF | 24.83 | 25.07 | 24.77 | 25.07 | 241700.0 |
| 2006-08-24 | DDM | ETF | 6.1958 | 6.2067 | 6.1542 | 6.1833 | 712800.0 |
| 2006-08-24 | DES | ETF | 17.2967 | 17.2967 | 17.1967 | 17.2767 | 38700.0 |
| 2006-08-24 | DEW | ETF | 54.85 | 55.02 | 54.7 | 54.75 | 10600.0 |
| 2006-08-24 | DFE | ETF | 54.51 | 54.51 | 54.12 | 54.23 | 11400.0 |
| 2006-08-24 | DFJ | ETF | 51.81 | 51.95 | 51.81 | 51.95 | 2600.0 |
| 2006-08-24 | DGT | ETF | 70.8 | 71.06 | 70.77 | 70.87 | 8300.0 |
> showing 50 of 363 rows — these rows as CSV