PREVIEW / etf_daily / 2007-03-15
file: by_date/etf_daily/2007/2007-03-15.parquet size: 20 KB rows: 430
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-15 | SPY | ETF | 138.97 | 139.99 | 138.8 | 139.47 | 132435900.0 |
| 2007-03-15 | QQQ | ETF | 42.9 | 43.06 | 42.72 | 42.89 | 111627315.0 |
| 2007-03-15 | IWM | ETF | 77.12 | 77.92 | 77.12 | 77.8 | 84037300.0 |
| 2007-03-15 | DIA | ETF | 121.25 | 122.04 | 121.21 | 121.79 | 7905600.0 |
| 2007-03-15 | GLD | ETF | 64.03 | 64.46 | 63.88 | 63.98 | 7037700.0 |
| 2007-03-15 | TLT | ETF | 89.76 | 89.96 | 89.67 | 89.87 | 394900.0 |
| 2007-03-15 | AAA | ETF | 62.02 | 62.15 | 61.49 | 61.66 | 47800.0 |
| 2007-03-15 | ADRE | ETF | 37.72 | 38.06 | 37.58 | 37.89 | 191420.0 |
| 2007-03-15 | AGG | ETF | 100.81 | 100.81 | 100.52 | 100.57 | 201400.0 |
| 2007-03-15 | AIQ | ETF | 35.5 | 36.65 | 35.45 | 36.2 | 23920.0 |
| 2007-03-15 | AIS | ETF | 1.2199 | 1.2199 | 1.16 | 1.19 | 77300.0 |
| 2007-03-15 | ARB | ETF | 46.48 | 47.05 | 46.04 | 46.39 | 224500.0 |
| 2007-03-15 | BAB | ETF | 96.57 | 98.38 | 96.5 | 97.86 | 102300.0 |
| 2007-03-15 | BBC | ETF | 3.74 | 3.84 | 3.66 | 3.75 | 97900.0 |
| 2007-03-15 | BBH | ETF | 58.2667 | 58.6267 | 58.0333 | 58.2833 | 713700.0 |
| 2007-03-15 | BITS | ETF | 29.68 | 33.04 | 29.24 | 32.6 | 48149.0 |
| 2007-03-15 | BNE | ETF | 14.97 | 15.75 | 14.97 | 15.61 | 194400.0 |
| 2007-03-15 | BRF | ETF | 14.54 | 14.54 | 14.5 | 14.5 | 4200.0 |
| 2007-03-15 | BTF | ETF | 105.99999999999999 | 107.2 | 105.99999999999999 | 107.2 | 3940.0 |
| 2007-03-15 | CBON | ETF | 30.5 | 31.15 | 30.44 | 30.6 | 27901.0 |
| 2007-03-15 | CDL | ETF | 9.64 | 9.71 | 9.59 | 9.71 | 216800.0 |
| 2007-03-15 | CEF | ETF | 9.19 | 9.3 | 9.15 | 9.29 | 224500.0 |
| 2007-03-15 | CGO | ETF | 16.25 | 16.65 | 16.24 | 16.64 | 18500.0 |
| 2007-03-15 | CHB | ETF | 9.37 | 9.53 | 9.14 | 9.22 | 2734800.0 |
| 2007-03-15 | CHI | ETF | 19.9 | 20.12 | 19.82 | 20.0496 | 68000.0 |
| 2007-03-15 | CHIC | ETF | 26.95 | 27.22 | 26.93 | 27.2 | 362735.0 |
| 2007-03-15 | CHY | ETF | 16.26 | 16.58 | 16.24 | 16.47 | 155600.0 |
| 2007-03-15 | CIL | ETF | 25.57 | 25.57 | 25.57 | 25.57 | 1000.0 |
| 2007-03-15 | CN | ETF | 43.85 | 44.29 | 43.72 | 44.22 | 48500.0 |
| 2007-03-15 | CNXT | ETF | 1.69 | 1.7 | 1.65 | 1.66 | 8649084.0 |
| 2007-03-15 | CPST | ETF | 0.85 | 0.86 | 0.83 | 0.8505 | 1565012.0 |
| 2007-03-15 | CSA | ETF | 21.5 | 21.96 | 21.25 | 21.96 | 12500.0 |
| 2007-03-15 | CSB | ETF | 31.29 | 31.78 | 31.29 | 31.72 | 8600.0 |
| 2007-03-15 | CSD | ETF | 26.05 | 26.23 | 26.05 | 26.15 | 6300.0 |
| 2007-03-15 | CSQ | ETF | 14.73 | 14.87 | 14.67 | 14.83 | 283600.0 |
| 2007-03-15 | CTEC | ETF | 80.5 | 81.44999999999999 | 79.8 | 81.19999999999999 | 6448.0 |
| 2007-03-15 | CVY | ETF | 26.03 | 26.34 | 26.03 | 26.31 | 20600.0 |
| 2007-03-15 | CWI | ETF | 24.3733 | 24.3933 | 24.2533 | 24.3533 | 27000.0 |
| 2007-03-15 | DBA | ETF | 25.97 | 26.05 | 25.58 | 25.6 | 131400.0 |
| 2007-03-15 | DBB | ETF | 24.35 | 24.78 | 24.35 | 24.62 | 12100.0 |
| 2007-03-15 | DBC | ETF | 24.46 | 24.46 | 24.1 | 24.19 | 165300.0 |
| 2007-03-15 | DBE | ETF | 25.76 | 25.76 | 25.4 | 25.42 | 9100.0 |
| 2007-03-15 | DBO | ETF | 25.19 | 25.19 | 24.77 | 24.91 | 4800.0 |
| 2007-03-15 | DBP | ETF | 25.5 | 25.62 | 25.48 | 25.53 | 6700.0 |
| 2007-03-15 | DBS | ETF | 25.36 | 25.7 | 25.34 | 25.56 | 13000.0 |
| 2007-03-15 | DBV | ETF | 26.2 | 26.33 | 26.19 | 26.32 | 70200.0 |
| 2007-03-15 | DDM | ETF | 6.4867 | 6.5608 | 6.4725 | 6.5317 | 1243200.0 |
| 2007-03-15 | DEF | ETF | 25.31 | 25.41 | 25.31 | 25.35 | 6600.0 |
| 2007-03-15 | DES | ETF | 18.8333 | 18.9467 | 18.8333 | 18.9467 | 51000.0 |
| 2007-03-15 | DEW | ETF | 59.9 | 60.38 | 59.9 | 60.35 | 6400.0 |
> showing 50 of 430 rows — these rows as CSV