PREVIEW / etf_daily / 2007-08-24
file: by_date/etf_daily/2007/2007-08-24.parquet size: 22 KB rows: 493
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-24 | SPY | ETF | 146.48 | 148.33 | 146.28 | 148.33 | 128901900.0 |
| 2007-08-24 | QQQ | ETF | 47.38 | 48.24 | 47.32 | 48.2 | 88192108.0 |
| 2007-08-24 | IWM | ETF | 78.58 | 79.7 | 78.36 | 79.63 | 64735000.0 |
| 2007-08-24 | DIA | ETF | 132.19 | 133.75 | 132.03 | 133.64 | 9666100.0 |
| 2007-08-24 | GLD | ETF | 65.42 | 66.21 | 65.31 | 66.11 | 3648300.0 |
| 2007-08-24 | TLT | ETF | 87.77 | 88.08 | 87.56 | 87.85 | 1614600.0 |
| 2007-08-24 | ADRE | ETF | 44.18 | 45.45 | 44.12 | 45.41 | 206663.0 |
| 2007-08-24 | AGG | ETF | 99.27 | 99.31 | 99.03 | 99.05 | 293700.0 |
| 2007-08-24 | AIQ | ETF | 45.6 | 46.0 | 44.1 | 44.9 | 28820.0 |
| 2007-08-24 | AIS | ETF | 1.43 | 1.44 | 1.37 | 1.43 | 220100.0 |
| 2007-08-24 | ARB | ETF | 50.54 | 51.03 | 50.24 | 50.86 | 151300.0 |
| 2007-08-24 | BBH | ETF | 54.2833 | 54.6133 | 54.0933 | 54.6133 | 182100.0 |
| 2007-08-24 | BIL | ETF | 91.84 | 91.94 | 91.8 | 91.94 | 14050.0 |
| 2007-08-24 | BITS | ETF | 26.52 | 26.8 | 26.36 | 26.72 | 6123.0 |
| 2007-08-24 | BIV | ETF | 75.03 | 75.04 | 74.89 | 74.96 | 38700.0 |
| 2007-08-24 | BLV | ETF | 74.16 | 74.23 | 74.0 | 74.18 | 9700.0 |
| 2007-08-24 | BMVP | ETF | 16.8033 | 17.0117 | 16.78 | 17.0033 | 75200.0 |
| 2007-08-24 | BND | ETF | 75.03 | 75.07 | 74.89 | 75.04 | 54300.0 |
| 2007-08-24 | BNE | ETF | 16.77 | 17.07 | 16.58 | 16.94 | 191600.0 |
| 2007-08-24 | BRF | ETF | 14.55 | 14.59 | 14.55 | 14.58 | 2600.0 |
| 2007-08-24 | BSV | ETF | 75.64 | 75.67 | 75.51 | 75.62 | 31500.0 |
| 2007-08-24 | BTF | ETF | 103.64999999999999 | 105.39999999999999 | 103.6 | 105.39999999999999 | 2180.0 |
| 2007-08-24 | CBON | ETF | 25.56 | 25.56 | 24.49 | 25.27 | 53347.0 |
| 2007-08-24 | CDL | ETF | 4.09 | 4.18 | 4.0 | 4.12 | 1570400.0 |
| 2007-08-24 | CEF | ETF | 9.1 | 9.29 | 9.1 | 9.21 | 338000.0 |
| 2007-08-24 | CGO | ETF | 17.1 | 17.252 | 16.94 | 17.12 | 27500.0 |
| 2007-08-24 | CGW | ETF | 23.99 | 24.42 | 23.97 | 24.42 | 111200.0 |
| 2007-08-24 | CHB | ETF | 10.97 | 11.31 | 10.83 | 11.24 | 987600.0 |
| 2007-08-24 | CHI | ETF | 16.74 | 16.89 | 16.65 | 16.72 | 102600.0 |
| 2007-08-24 | CHIC | ETF | 17.76 | 18.08 | 17.47 | 18.08 | 307844.0 |
| 2007-08-24 | CHW | ETF | 13.6 | 13.79 | 13.49 | 13.66 | 73200.0 |
| 2007-08-24 | CHY | ETF | 14.74 | 14.75 | 14.47 | 14.51 | 126400.0 |
| 2007-08-24 | CN | ETF | 48.6 | 50.35 | 48.33 | 50.02 | 212900.0 |
| 2007-08-24 | CNXT | ETF | 1.13 | 1.16 | 1.13 | 1.15 | 3596298.0 |
| 2007-08-24 | CPI | ETF | 24.65 | 24.85 | 24.5 | 24.85 | 1700.0 |
| 2007-08-24 | CPST | ETF | 1.0 | 1.01 | 0.972 | 0.99 | 949240.0 |
| 2007-08-24 | CSA | ETF | 17.67 | 17.72 | 17.09 | 17.57 | 39900.0 |
| 2007-08-24 | CSD | ETF | 28.62 | 28.95 | 28.56 | 28.95 | 19000.0 |
| 2007-08-24 | CSM | ETF | 1.4275 | 1.4275 | 1.4275 | 1.4275 | 5600.0 |
| 2007-08-24 | CSQ | ETF | 14.27 | 14.4 | 14.27 | 14.4 | 288200.0 |
| 2007-08-24 | CTEC | ETF | 99.39999999999999 | 100.25 | 99.19999999999999 | 99.64999999999999 | 14471.2 |
| 2007-08-24 | CVY | ETF | 26.02 | 26.15 | 25.92 | 26.15 | 44300.0 |
| 2007-08-24 | CWI | ETF | 26.3267 | 26.6467 | 26.32 | 26.6467 | 119400.0 |
| 2007-08-24 | CZA | ETF | 25.36 | 25.55 | 25.36 | 25.55 | 2000.0 |
| 2007-08-24 | DBA | ETF | 26.73 | 26.78 | 26.5 | 26.73 | 345100.0 |
| 2007-08-24 | DBB | ETF | 25.43 | 26.3 | 25.33 | 26.3 | 38900.0 |
| 2007-08-24 | DBC | ETF | 25.35 | 25.63 | 25.31 | 25.63 | 175100.0 |
| 2007-08-24 | DBE | ETF | 27.6 | 27.83 | 27.54 | 27.79 | 4600.0 |
| 2007-08-24 | DBO | ETF | 25.94 | 26.41 | 25.0 | 26.34 | 5900.0 |
| 2007-08-24 | DBP | ETF | 25.43 | 25.74 | 25.36 | 25.74 | 17600.0 |
> showing 50 of 493 rows — these rows as CSV