PREVIEW / etf_daily / 2007-03-02
file: by_date/etf_daily/2007/2007-03-02.parquet size: 21 KB rows: 435
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-02 | SPY | ETF | 140.05 | 140.66 | 138.66 | 138.67 | 162574000.0 |
| 2007-03-02 | QQQ | ETF | 42.78 | 43.14 | 42.47 | 42.48 | 183419959.0 |
| 2007-03-02 | IWM | ETF | 78.18 | 78.38 | 76.75 | 76.86 | 96274500.0 |
| 2007-03-02 | DIA | ETF | 122.0 | 122.47 | 120.96 | 120.96 | 17515400.0 |
| 2007-03-02 | GLD | ETF | 64.59 | 65.0 | 63.34 | 63.71 | 13732200.0 |
| 2007-03-02 | TLT | ETF | 89.96 | 90.48 | 89.67 | 90.2 | 1619800.0 |
| 2007-03-02 | AAA | ETF | 59.86 | 60.19 | 59.62 | 59.62 | 6100.0 |
| 2007-03-02 | ADRE | ETF | 37.28 | 37.61 | 36.82 | 36.84 | 281895.0 |
| 2007-03-02 | AGG | ETF | 100.54 | 100.68 | 100.39 | 100.65 | 187600.0 |
| 2007-03-02 | AIQ | ETF | 36.0 | 36.3 | 34.8 | 34.9 | 33600.0 |
| 2007-03-02 | AIS | ETF | 1.13 | 1.17 | 1.13 | 1.15 | 93200.0 |
| 2007-03-02 | ARB | ETF | 44.61 | 44.85 | 44.07 | 44.12 | 246500.0 |
| 2007-03-02 | BAB | ETF | 103.26 | 104.24 | 102.27 | 102.5 | 98300.0 |
| 2007-03-02 | BBC | ETF | 4.1201 | 4.13 | 4.02 | 4.04 | 153000.0 |
| 2007-03-02 | BBH | ETF | 59.3333 | 60.0 | 59.1367 | 59.1733 | 1448700.0 |
| 2007-03-02 | BITS | ETF | 26.92 | 28.24 | 26.8 | 27.44 | 119684.0 |
| 2007-03-02 | BNE | ETF | 15.48 | 15.55 | 14.94 | 14.94 | 137000.0 |
| 2007-03-02 | BRF | ETF | 14.6 | 14.6 | 14.6 | 14.6 | 100.0 |
| 2007-03-02 | BTF | ETF | 109.0 | 110.19999999999999 | 109.0 | 109.25 | 1060.0 |
| 2007-03-02 | CBON | ETF | 31.21 | 31.21 | 30.0 | 30.0 | 29613.0 |
| 2007-03-02 | CDL | ETF | 10.4 | 10.4 | 9.94 | 9.98 | 486800.0 |
| 2007-03-02 | CEF | ETF | 9.36 | 9.38 | 9.04 | 9.13 | 740200.0 |
| 2007-03-02 | CGO | ETF | 16.37 | 16.47 | 16.07 | 16.12 | 24500.0 |
| 2007-03-02 | CHB | ETF | 7.95 | 8.02 | 7.53 | 7.57 | 2260100.0 |
| 2007-03-02 | CHI | ETF | 20.19 | 20.39 | 20.05 | 20.06 | 107500.0 |
| 2007-03-02 | CHIC | ETF | 28.99 | 29.13 | 28.45 | 28.56 | 280446.0 |
| 2007-03-02 | CHY | ETF | 16.86 | 17.0 | 16.7 | 16.76 | 160500.0 |
| 2007-03-02 | CIL | ETF | 25.5 | 25.5 | 25.48 | 25.48 | 600.0 |
| 2007-03-02 | CN | ETF | 46.52 | 46.52 | 45.45 | 45.71 | 62700.0 |
| 2007-03-02 | CNXT | ETF | 1.99 | 2.0 | 1.9099 | 1.93 | 11641891.0 |
| 2007-03-02 | CPST | ETF | 0.8784 | 0.91 | 0.8564 | 0.9001 | 2681823.0 |
| 2007-03-02 | CSA | ETF | 21.82 | 22.07 | 21.57 | 21.58 | 3600.0 |
| 2007-03-02 | CSB | ETF | 31.54 | 31.85 | 31.5 | 31.55 | 21300.0 |
| 2007-03-02 | CSD | ETF | 25.77 | 25.81 | 25.53 | 25.62 | 17900.0 |
| 2007-03-02 | CSQ | ETF | 14.77 | 14.83 | 14.61 | 14.83 | 374400.0 |
| 2007-03-02 | CTEC | ETF | 81.4 | 83.05 | 80.99999999999999 | 81.05 | 8738.800000000001 |
| 2007-03-02 | CVY | ETF | 26.59 | 26.59 | 26.35 | 26.35 | 26500.0 |
| 2007-03-02 | CWI | ETF | 24.2867 | 24.3533 | 24.1267 | 24.1267 | 119700.0 |
| 2007-03-02 | DBA | ETF | 26.41 | 26.78 | 26.39 | 26.39 | 121900.0 |
| 2007-03-02 | DBB | ETF | 23.75 | 23.93 | 23.59 | 23.63 | 7800.0 |
| 2007-03-02 | DBC | ETF | 24.88 | 25.06 | 24.64 | 24.8 | 295700.0 |
| 2007-03-02 | DBE | ETF | 26.58 | 26.6 | 26.19 | 26.2 | 19200.0 |
| 2007-03-02 | DBO | ETF | 25.9 | 26.2 | 25.65 | 25.85 | 10200.0 |
| 2007-03-02 | DBP | ETF | 25.65 | 25.94 | 25.25 | 25.44 | 33700.0 |
| 2007-03-02 | DBS | ETF | 25.7 | 25.89 | 25.07 | 25.43 | 434600.0 |
| 2007-03-02 | DBV | ETF | 26.01 | 26.15 | 25.916 | 26.0 | 139900.0 |
| 2007-03-02 | DDM | ETF | 6.575 | 6.6217 | 6.4792 | 6.4792 | 3234000.0 |
| 2007-03-02 | DEF | ETF | 25.49 | 25.57 | 25.29 | 25.29 | 19200.0 |
| 2007-03-02 | DES | ETF | 18.9967 | 19.0433 | 18.81 | 18.86 | 40500.0 |
| 2007-03-02 | DEW | ETF | 60.25 | 60.47 | 59.91 | 60.06 | 27200.0 |
> showing 50 of 435 rows — these rows as CSV