PREVIEW / etf_daily / 2007-03-05
file: by_date/etf_daily/2007/2007-03-05.parquet size: 21 KB rows: 441
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-03-05 | SPY | ETF | 137.93 | 139.58 | 137.33 | 137.35 | 143750400.0 |
| 2007-03-05 | QQQ | ETF | 42.16 | 42.8 | 42.06 | 42.15 | 174692606.0 |
| 2007-03-05 | IWM | ETF | 76.09 | 77.29 | 75.15 | 75.17 | 122207900.0 |
| 2007-03-05 | DIA | ETF | 120.4 | 121.91 | 120.28 | 120.3 | 15602600.0 |
| 2007-03-05 | GLD | ETF | 63.12 | 63.78 | 62.62 | 62.93 | 9829800.0 |
| 2007-03-05 | TLT | ETF | 90.48 | 90.5 | 90.06 | 90.35 | 1505200.0 |
| 2007-03-05 | AAA | ETF | 59.41 | 59.58 | 59.2 | 59.26 | 49000.0 |
| 2007-03-05 | ADRE | ETF | 35.4 | 36.57 | 35.1 | 35.83 | 468489.0 |
| 2007-03-05 | AGG | ETF | 100.69 | 100.69 | 100.43 | 100.59 | 264700.0 |
| 2007-03-05 | AIQ | ETF | 34.55 | 35.15 | 33.0 | 34.9 | 35360.0 |
| 2007-03-05 | AIS | ETF | 1.14 | 1.16 | 1.09 | 1.1099 | 69900.0 |
| 2007-03-05 | ARB | ETF | 45.05 | 46.6 | 44.56 | 44.56 | 612700.0 |
| 2007-03-05 | BAB | ETF | 96.32 | 97.6987 | 95.55 | 96.7 | 162300.0 |
| 2007-03-05 | BBC | ETF | 3.99 | 4.0 | 3.7 | 3.729 | 302200.0 |
| 2007-03-05 | BBH | ETF | 58.3333 | 59.7133 | 58.3333 | 58.7833 | 834300.0 |
| 2007-03-05 | BITS | ETF | 27.16 | 28.6 | 27.12 | 27.92 | 71631.0 |
| 2007-03-05 | BNE | ETF | 14.83 | 15.32 | 14.83 | 14.96 | 151800.0 |
| 2007-03-05 | BOSS | ETF | 41.09 | 41.87 | 41.09 | 41.87 | 300.0 |
| 2007-03-05 | BRF | ETF | 14.6 | 14.6101 | 14.53 | 14.53 | 8300.0 |
| 2007-03-05 | BTF | ETF | 107.75 | 108.1 | 104.25 | 106.64999999999999 | 10160.0 |
| 2007-03-05 | CBON | ETF | 29.99 | 30.46 | 29.9 | 29.92 | 21916.0 |
| 2007-03-05 | CDL | ETF | 9.88 | 9.95 | 9.64 | 9.66 | 549900.0 |
| 2007-03-05 | CEF | ETF | 9.0 | 9.14 | 8.77 | 8.95 | 733900.0 |
| 2007-03-05 | CGO | ETF | 16.1 | 16.12 | 15.68 | 15.73 | 35200.0 |
| 2007-03-05 | CHB | ETF | 7.5 | 7.54 | 7.21 | 7.24 | 1943400.0 |
| 2007-03-05 | CHI | ETF | 19.99 | 20.03 | 19.8 | 19.81 | 113400.0 |
| 2007-03-05 | CHIC | ETF | 28.29 | 29.19 | 28.16 | 28.3 | 285819.0 |
| 2007-03-05 | CHY | ETF | 16.77 | 16.84 | 16.53 | 16.53 | 200500.0 |
| 2007-03-05 | CIL | ETF | 25.52 | 25.6 | 25.52 | 25.52 | 700.0 |
| 2007-03-05 | CN | ETF | 43.0 | 43.69 | 42.5 | 42.53 | 117100.0 |
| 2007-03-05 | CNXT | ETF | 1.9 | 1.92 | 1.84 | 1.85 | 11192719.0 |
| 2007-03-05 | CPST | ETF | 0.8805 | 0.89 | 0.752 | 0.77 | 7508486.0 |
| 2007-03-05 | CSA | ETF | 21.4 | 21.4 | 20.5 | 20.77 | 20800.0 |
| 2007-03-05 | CSB | ETF | 31.11 | 31.54 | 31.11 | 31.21 | 19200.0 |
| 2007-03-05 | CSD | ETF | 25.3 | 25.36 | 25.18 | 25.18 | 13900.0 |
| 2007-03-05 | CSM | ETF | 1.3 | 1.3 | 1.2775 | 1.2775 | 8400.0 |
| 2007-03-05 | CSQ | ETF | 14.74 | 14.84 | 14.61 | 14.64 | 301800.0 |
| 2007-03-05 | CTEC | ETF | 80.6 | 81.05 | 78.75 | 80.775 | 23397.800000000003 |
| 2007-03-05 | CVY | ETF | 25.9 | 26.11 | 25.79 | 25.79 | 64900.0 |
| 2007-03-05 | CWI | ETF | 23.7133 | 23.9467 | 23.66 | 23.66 | 25350.0 |
| 2007-03-05 | DBA | ETF | 25.84 | 26.34 | 25.7 | 26.34 | 253700.0 |
| 2007-03-05 | DBB | ETF | 23.01 | 23.5 | 22.71 | 23.24 | 10400.0 |
| 2007-03-05 | DBC | ETF | 24.26 | 24.58 | 24.16 | 24.43 | 658500.0 |
| 2007-03-05 | DBE | ETF | 25.92 | 26.01 | 25.62 | 25.76 | 47500.0 |
| 2007-03-05 | DBO | ETF | 25.01 | 25.45 | 24.99 | 25.11 | 21200.0 |
| 2007-03-05 | DBP | ETF | 24.94 | 25.38 | 24.0 | 25.08 | 14200.0 |
| 2007-03-05 | DBS | ETF | 24.54 | 25.2 | 24.36 | 24.92 | 31600.0 |
| 2007-03-05 | DBV | ETF | 25.85 | 25.88 | 25.71 | 25.72 | 288300.0 |
| 2007-03-05 | DDM | ETF | 6.3975 | 6.5625 | 6.3975 | 6.4075 | 3801600.0 |
| 2007-03-05 | DEF | ETF | 25.05 | 25.12 | 25.0 | 25.021 | 32100.0 |
> showing 50 of 441 rows — these rows as CSV