PREVIEW / etf_daily / 2007-01-24
file: by_date/etf_daily/2007/2007-01-24.parquet size: 20 KB rows: 407
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-01-24 | SPY | ETF | 142.97 | 143.98 | 142.91 | 143.95 | 55834700.0 |
| 2007-01-24 | QQQ | ETF | 43.87 | 44.32 | 43.77 | 44.3 | 117691355.0 |
| 2007-01-24 | IWM | ETF | 78.01 | 78.82 | 77.94 | 78.77 | 30401400.0 |
| 2007-01-24 | DIA | ETF | 125.51 | 126.12 | 125.38 | 126.07 | 10118500.0 |
| 2007-01-24 | GLD | ETF | 63.71 | 64.41 | 63.37 | 64.33 | 5241200.0 |
| 2007-01-24 | TLT | ETF | 87.66 | 87.7 | 87.5 | 87.61 | 463700.0 |
| 2007-01-24 | AAA | ETF | 61.54 | 61.72 | 61.44 | 61.72 | 4700.0 |
| 2007-01-24 | ADRE | ETF | 39.57 | 39.87 | 39.37 | 39.87 | 449656.0 |
| 2007-01-24 | AGG | ETF | 99.84 | 99.84 | 99.65 | 99.67 | 358000.0 |
| 2007-01-24 | AIQ | ETF | 34.1 | 34.6 | 33.85 | 34.25 | 22220.0 |
| 2007-01-24 | AIS | ETF | 1.12 | 1.16 | 1.1 | 1.1506 | 116900.0 |
| 2007-01-24 | ARB | ETF | 45.6 | 45.9 | 45.5 | 45.82 | 147900.0 |
| 2007-01-24 | BAB | ETF | 106.37 | 106.4 | 105.28 | 105.86 | 79500.0 |
| 2007-01-24 | BBC | ETF | 4.9 | 5.08 | 4.8604 | 4.97 | 238600.0 |
| 2007-01-24 | BBH | ETF | 64.7667 | 65.3333 | 64.7667 | 65.3333 | 803700.0 |
| 2007-01-24 | BITS | ETF | 36.4 | 37.44 | 36.2548 | 37.28 | 10200.0 |
| 2007-01-24 | BNE | ETF | 15.24 | 15.46 | 15.15 | 15.22 | 137800.0 |
| 2007-01-24 | BRF | ETF | 14.42 | 14.45 | 14.42 | 14.43 | 10400.0 |
| 2007-01-24 | BTF | ETF | 108.55 | 108.75 | 108.49999999999999 | 108.75 | 1640.0 |
| 2007-01-24 | CBON | ETF | 33.2 | 33.49 | 32.98 | 33.4 | 85942.0 |
| 2007-01-24 | CDL | ETF | 10.33 | 10.34 | 10.22 | 10.32 | 162100.0 |
| 2007-01-24 | CEF | ETF | 9.35 | 9.41 | 9.23 | 9.39 | 379100.0 |
| 2007-01-24 | CEW | ETF | 25.85 | 25.98 | 25.77 | 25.8 | 2400.0 |
| 2007-01-24 | CGO | ETF | 16.86 | 17.15 | 16.86 | 16.98 | 38100.0 |
| 2007-01-24 | CHB | ETF | 8.33 | 8.55 | 8.31 | 8.44 | 928600.0 |
| 2007-01-24 | CHI | ETF | 20.2 | 20.3 | 20.15 | 20.27 | 112400.0 |
| 2007-01-24 | CHIC | ETF | 32.39 | 33.93 | 32.28 | 32.88 | 745938.0 |
| 2007-01-24 | CHY | ETF | 17.32 | 17.34 | 17.22 | 17.32 | 131500.0 |
| 2007-01-24 | CIL | ETF | 25.31 | 25.4189 | 25.31 | 25.3111 | 3100.0 |
| 2007-01-24 | CN | ETF | 49.9 | 51.04 | 49.75 | 50.9 | 149800.0 |
| 2007-01-24 | CNXT | ETF | 1.97 | 1.99 | 1.94 | 1.95 | 6245872.0 |
| 2007-01-24 | CPST | ETF | 0.95 | 0.96 | 0.85 | 0.95 | 14432007.0 |
| 2007-01-24 | CSA | ETF | 21.8 | 21.96 | 21.8 | 21.9 | 9000.0 |
| 2007-01-24 | CSB | ETF | 33.86 | 33.96 | 33.79 | 33.95 | 11900.0 |
| 2007-01-24 | CSD | ETF | 25.47 | 25.63 | 25.42 | 25.57 | 10300.0 |
| 2007-01-24 | CSM | ETF | 1.35 | 1.355 | 1.35 | 1.355 | 38800.0 |
| 2007-01-24 | CSQ | ETF | 15.45 | 15.47 | 15.36 | 15.43 | 498600.0 |
| 2007-01-24 | CTEC | ETF | 93.6 | 94.39999999999999 | 92.89999999999999 | 93.1 | 21407.600000000002 |
| 2007-01-24 | CVY | ETF | 26.6 | 26.72 | 26.55 | 26.72 | 40900.0 |
| 2007-01-24 | CWI | ETF | 24.6933 | 24.82 | 24.6933 | 24.8133 | 79050.0 |
| 2007-01-24 | DBA | ETF | 26.35 | 26.35 | 25.9 | 26.05 | 363300.0 |
| 2007-01-24 | DBB | ETF | 24.38 | 24.38 | 24.08 | 24.24 | 6900.0 |
| 2007-01-24 | DBC | ETF | 23.55 | 23.63 | 23.18 | 23.5 | 279000.0 |
| 2007-01-24 | DBE | ETF | 23.85 | 24.0 | 23.5 | 24.0 | 8900.0 |
| 2007-01-24 | DBO | ETF | 22.99 | 23.32 | 22.58 | 23.3 | 12000.0 |
| 2007-01-24 | DBP | ETF | 25.62 | 25.83 | 25.45 | 25.77 | 3500.0 |
| 2007-01-24 | DBS | ETF | 25.98 | 26.14 | 25.8 | 26.1076 | 7800.0 |
| 2007-01-24 | DBV | ETF | 26.5 | 26.5 | 26.27 | 26.47 | 273400.0 |
| 2007-01-24 | DDM | ETF | 6.9875 | 7.0542 | 6.9742 | 7.0542 | 745200.0 |
| 2007-01-24 | DEF | ETF | 25.6199 | 25.73 | 25.6 | 25.73 | 9900.0 |
> showing 50 of 407 rows — these rows as CSV