PREVIEW / etf_daily / 2007-03-07
file: by_date/etf_daily/2007/2007-03-07.parquet size: 21 KB rows: 439
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-07 | SPY | ETF | 139.59 | 140.46 | 139.4 | 139.56 | 115144900.0 |
| 2007-03-07 | QQQ | ETF | 42.86 | 42.98 | 42.65 | 42.68 | 116626654.0 |
| 2007-03-07 | IWM | ETF | 77.3 | 77.62 | 76.8 | 76.97 | 55408800.0 |
| 2007-03-07 | DIA | ETF | 122.01 | 122.6 | 121.87 | 122.0 | 6965700.0 |
| 2007-03-07 | GLD | ETF | 64.14 | 64.64 | 63.55 | 64.3 | 6131800.0 |
| 2007-03-07 | TLT | ETF | 90.08 | 90.5 | 89.98 | 90.43 | 915400.0 |
| 2007-03-07 | AAA | ETF | 59.99 | 60.3 | 59.85 | 60.14 | 8200.0 |
| 2007-03-07 | ADRE | ETF | 37.39 | 37.51 | 37.05 | 37.11 | 195142.0 |
| 2007-03-07 | AGG | ETF | 100.57 | 100.69 | 100.46 | 100.6 | 296500.0 |
| 2007-03-07 | AIQ | ETF | 36.45 | 38.3 | 36.45 | 37.55 | 61640.0 |
| 2007-03-07 | AIS | ETF | 1.13 | 1.14 | 1.1 | 1.11 | 79700.0 |
| 2007-03-07 | ARB | ETF | 45.44 | 45.46 | 44.39 | 44.72 | 293500.0 |
| 2007-03-07 | BAB | ETF | 99.97 | 100.4 | 98.84 | 99.27 | 81200.0 |
| 2007-03-07 | BBC | ETF | 3.92 | 3.9201 | 3.64 | 3.67 | 151600.0 |
| 2007-03-07 | BBH | ETF | 59.3833 | 59.3833 | 58.7667 | 58.9333 | 425400.0 |
| 2007-03-07 | BITS | ETF | 28.32 | 29.04 | 28.0 | 29.04 | 44862.0 |
| 2007-03-07 | BNE | ETF | 14.98 | 15.12 | 14.86 | 14.87 | 119000.0 |
| 2007-03-07 | BRF | ETF | 14.56 | 14.5601 | 14.53 | 14.53 | 2600.0 |
| 2007-03-07 | BTF | ETF | 107.69999999999999 | 108.75 | 107.6 | 108.24999999999999 | 2660.0 |
| 2007-03-07 | CBON | ETF | 31.46 | 31.46 | 30.18 | 30.98 | 49277.0 |
| 2007-03-07 | CDL | ETF | 9.78 | 9.81 | 9.67 | 9.79 | 344000.0 |
| 2007-03-07 | CEF | ETF | 9.19 | 9.31 | 9.15 | 9.25 | 304000.0 |
| 2007-03-07 | CGO | ETF | 16.3 | 16.59 | 16.06 | 16.33 | 25200.0 |
| 2007-03-07 | CHB | ETF | 7.4 | 7.83 | 7.38 | 7.72 | 2192200.0 |
| 2007-03-07 | CHI | ETF | 19.91 | 20.08 | 19.87 | 20.03 | 101400.0 |
| 2007-03-07 | CHIC | ETF | 28.4 | 28.58 | 28.01 | 28.36 | 300675.0 |
| 2007-03-07 | CHY | ETF | 16.53 | 16.65 | 16.53 | 16.63 | 122500.0 |
| 2007-03-07 | CIL | ETF | 25.49 | 25.49 | 25.49 | 25.49 | 100.0 |
| 2007-03-07 | CN | ETF | 43.0 | 44.0 | 43.0 | 43.35 | 119000.0 |
| 2007-03-07 | CNXT | ETF | 1.89 | 1.91 | 1.85 | 1.88 | 9588687.0 |
| 2007-03-07 | CPI | ETF | 22.85 | 22.85 | 22.85 | 22.85 | 1900.0 |
| 2007-03-07 | CPST | ETF | 0.8297 | 0.8297 | 0.7912 | 0.8045 | 1439444.0 |
| 2007-03-07 | CSA | ETF | 21.55 | 21.71 | 21.29 | 21.29 | 15100.0 |
| 2007-03-07 | CSB | ETF | 32.23 | 32.81 | 32.23 | 32.56 | 22400.0 |
| 2007-03-07 | CSD | ETF | 25.65 | 25.84 | 25.63 | 25.75 | 23500.0 |
| 2007-03-07 | CSQ | ETF | 14.81 | 14.87 | 14.69 | 14.74 | 434400.0 |
| 2007-03-07 | CTEC | ETF | 79.64999999999999 | 80.95 | 78.7 | 80.95 | 8036.400000000001 |
| 2007-03-07 | CVY | ETF | 26.29 | 26.34 | 26.09 | 26.19 | 17600.0 |
| 2007-03-07 | CWI | ETF | 24.2667 | 24.4333 | 24.26 | 24.3 | 42300.0 |
| 2007-03-07 | DBA | ETF | 26.25 | 26.57 | 26.15 | 26.44 | 175400.0 |
| 2007-03-07 | DBB | ETF | 24.0 | 24.24 | 24.0 | 24.24 | 3500.0 |
| 2007-03-07 | DBC | ETF | 24.77 | 25.05 | 24.69 | 25.0 | 533600.0 |
| 2007-03-07 | DBE | ETF | 26.55 | 26.63 | 26.38 | 26.53 | 23400.0 |
| 2007-03-07 | DBO | ETF | 25.79 | 26.16 | 25.7 | 26.15 | 67000.0 |
| 2007-03-07 | DBP | ETF | 25.47 | 25.74 | 25.47 | 25.62 | 8600.0 |
| 2007-03-07 | DBS | ETF | 25.25 | 25.62 | 25.17 | 25.49 | 8000.0 |
| 2007-03-07 | DBV | ETF | 26.0 | 26.019 | 25.8101 | 25.86 | 78100.0 |
| 2007-03-07 | DDM | ETF | 6.59 | 6.6358 | 6.5583 | 6.5692 | 2408400.0 |
| 2007-03-07 | DEF | ETF | 25.339 | 25.34 | 25.18 | 25.23 | 14600.0 |
| 2007-03-07 | DES | ETF | 18.8333 | 18.85 | 18.68 | 18.7333 | 58200.0 |
> showing 50 of 439 rows — these rows as CSV