PREVIEW / etf_daily / 2007-05-02
file: by_date/etf_daily/2007/2007-05-02.parquet size: 21 KB rows: 458
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-05-02 | SPY | ETF | 148.9 | 149.95 | 148.75 | 149.54 | 87129800.0 |
| 2007-05-02 | QQQ | ETF | 46.09 | 46.58 | 46.05 | 46.42 | 91992548.0 |
| 2007-05-02 | IWM | ETF | 81.07 | 82.44 | 80.92 | 82.15 | 49850600.0 |
| 2007-05-02 | DIA | ETF | 131.5 | 132.49 | 131.36 | 132.14 | 9341000.0 |
| 2007-05-02 | GLD | ETF | 66.34 | 66.75 | 66.11 | 66.66 | 4499300.0 |
| 2007-05-02 | TLT | ETF | 88.44 | 88.48 | 88.29 | 88.44 | 443900.0 |
| 2007-05-02 | AAA | ETF | 70.98 | 73.0 | 69.41 | 71.0 | 65300.0 |
| 2007-05-02 | ADRE | ETF | 41.01 | 41.699 | 41.01 | 41.65 | 122305.0 |
| 2007-05-02 | AGG | ETF | 100.08 | 100.77 | 99.8 | 100.05 | 255200.0 |
| 2007-05-02 | AIQ | ETF | 44.95 | 45.4 | 44.55 | 45.2 | 61820.0 |
| 2007-05-02 | AIS | ETF | 1.49 | 1.54 | 1.48 | 1.53 | 229600.0 |
| 2007-05-02 | ARB | ETF | 49.32 | 50.31 | 49.07 | 49.55 | 280100.0 |
| 2007-05-02 | BAB | ETF | 101.67 | 104.14 | 101.67 | 103.84 | 68200.0 |
| 2007-05-02 | BBH | ETF | 63.45 | 63.6767 | 63.2767 | 63.4733 | 421500.0 |
| 2007-05-02 | BITS | ETF | 34.28 | 35.16 | 33.72 | 34.36 | 28795.0 |
| 2007-05-02 | BIV | ETF | 75.29 | 75.34 | 75.29 | 75.33 | 6200.0 |
| 2007-05-02 | BLV | ETF | 75.57 | 75.68 | 75.57 | 75.67 | 7800.0 |
| 2007-05-02 | BMVP | ETF | 17.8 | 17.9566 | 17.8 | 17.9067 | 33200.0 |
| 2007-05-02 | BND | ETF | 75.37 | 75.41 | 75.29 | 75.33 | 28900.0 |
| 2007-05-02 | BNE | ETF | 16.59 | 16.91 | 16.49 | 16.88 | 131300.0 |
| 2007-05-02 | BRF | ETF | 14.51 | 14.51 | 14.5 | 14.5 | 4500.0 |
| 2007-05-02 | BSV | ETF | 75.27 | 75.28 | 75.2 | 75.21 | 45200.0 |
| 2007-05-02 | BTF | ETF | 110.99999999999999 | 111.99999999999999 | 110.99999999999999 | 111.99999999999999 | 1540.0 |
| 2007-05-02 | CBON | ETF | 30.9 | 31.12 | 30.55 | 30.85 | 48130.0 |
| 2007-05-02 | CDL | ETF | 9.12 | 9.2 | 9.06 | 9.07 | 310900.0 |
| 2007-05-02 | CEF | ETF | 9.26 | 9.49 | 9.22 | 9.45 | 264400.0 |
| 2007-05-02 | CGO | ETF | 17.61 | 17.98 | 17.61 | 17.94 | 28600.0 |
| 2007-05-02 | CHB | ETF | 10.16 | 10.63 | 10.15 | 10.28 | 1830750.0 |
| 2007-05-02 | CHI | ETF | 20.41 | 20.49 | 20.32 | 20.49 | 80400.0 |
| 2007-05-02 | CHIC | ETF | 27.16 | 28.17 | 27.16 | 27.35 | 607053.0 |
| 2007-05-02 | CHY | ETF | 17.13 | 17.2 | 17.1 | 17.1976 | 89600.0 |
| 2007-05-02 | CIL | ETF | 25.85 | 25.87 | 25.85 | 25.86 | 400.0 |
| 2007-05-02 | CN | ETF | 49.4 | 49.94 | 49.25 | 49.87 | 38700.0 |
| 2007-05-02 | CNXT | ETF | 1.54 | 1.58 | 1.5391 | 1.56 | 5930615.0 |
| 2007-05-02 | CPI | ETF | 21.85 | 22.15 | 21.85 | 22.15 | 600.0 |
| 2007-05-02 | CPST | ETF | 0.97 | 1.05 | 0.9402 | 1.03 | 3606356.0 |
| 2007-05-02 | CSA | ETF | 20.36 | 20.93 | 20.36 | 20.68 | 50500.0 |
| 2007-05-02 | CSB | ETF | 32.87 | 33.09 | 32.69 | 33.03 | 22500.0 |
| 2007-05-02 | CSD | ETF | 28.72 | 28.84 | 28.7 | 28.74 | 67800.0 |
| 2007-05-02 | CSM | ETF | 1.3675 | 1.3675 | 1.3675 | 1.3675 | 12400.0 |
| 2007-05-02 | CSQ | ETF | 15.4 | 15.45 | 15.34 | 15.4 | 295900.0 |
| 2007-05-02 | CTEC | ETF | 87.69999999999999 | 90.89999999999999 | 86.99999999999999 | 89.89999999999999 | 13729.0 |
| 2007-05-02 | CVY | ETF | 27.49 | 27.73 | 27.49 | 27.71 | 19500.0 |
| 2007-05-02 | CWI | ETF | 26.52 | 26.68 | 26.52 | 26.66 | 21300.0 |
| 2007-05-02 | CZA | ETF | 26.37 | 26.37 | 26.3275 | 26.3275 | 200.0 |
| 2007-05-02 | DBA | ETF | 25.4 | 25.42 | 25.06 | 25.12 | 266300.0 |
| 2007-05-02 | DBB | ETF | 27.96 | 28.12 | 27.62 | 27.76 | 81700.0 |
| 2007-05-02 | DBC | ETF | 25.63 | 25.63 | 25.21 | 25.42 | 303600.0 |
| 2007-05-02 | DBE | ETF | 27.95 | 27.95 | 27.39 | 27.56 | 256500.0 |
| 2007-05-02 | DBO | ETF | 26.4 | 26.43 | 26.13 | 26.26 | 4700.0 |
> showing 50 of 458 rows — these rows as CSV