PREVIEW / etf_daily / 2007-04-02
file: by_date/etf_daily/2007/2007-04-02.parquet size: 21 KB rows: 440
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-04-02 | SPY | ETF | 142.16 | 142.46 | 141.48 | 142.16 | 79416400.0 |
| 2007-04-02 | QQQ | ETF | 43.67 | 43.76 | 43.3 | 43.59 | 89630085.0 |
| 2007-04-02 | IWM | ETF | 79.61 | 79.77 | 79.15 | 79.65 | 36558700.0 |
| 2007-04-02 | DIA | ETF | 123.57 | 123.82 | 123.11 | 123.65 | 6195200.0 |
| 2007-04-02 | GLD | ETF | 65.74 | 66.14 | 65.03 | 65.85 | 5378100.0 |
| 2007-04-02 | TLT | ETF | 88.11 | 88.22 | 88.01 | 88.1 | 579600.0 |
| 2007-04-02 | AAA | ETF | 65.46 | 65.75 | 65.37 | 65.74 | 13700.0 |
| 2007-04-02 | ADRE | ETF | 39.4 | 39.9 | 39.3601 | 39.9 | 131071.0 |
| 2007-04-02 | AGG | ETF | 100.19 | 100.19 | 99.81 | 100.0 | 1065300.0 |
| 2007-04-02 | AIQ | ETF | 41.25 | 44.25 | 41.25 | 43.4 | 45580.0 |
| 2007-04-02 | AIS | ETF | 1.3 | 1.51 | 1.25 | 1.46 | 1717000.0 |
| 2007-04-02 | ARB | ETF | 46.95 | 47.14 | 46.69 | 47.08 | 140200.0 |
| 2007-04-02 | BAB | ETF | 98.36 | 99.5 | 97.75 | 98.74 | 44500.0 |
| 2007-04-02 | BBH | ETF | 59.0 | 59.0867 | 58.44 | 58.72 | 335700.0 |
| 2007-04-02 | BITS | ETF | 32.08 | 32.16 | 30.48 | 31.56 | 23842.0 |
| 2007-04-02 | BNE | ETF | 15.73 | 15.76 | 15.5 | 15.73 | 151500.0 |
| 2007-04-02 | BRF | ETF | 14.54 | 14.54 | 14.514 | 14.514 | 600.0 |
| 2007-04-02 | BTF | ETF | 108.1 | 108.55 | 108.1 | 108.55 | 60.0 |
| 2007-04-02 | CBON | ETF | 30.83 | 31.0501 | 30.42 | 30.85 | 31319.0 |
| 2007-04-02 | CDL | ETF | 9.54 | 9.54 | 9.44 | 9.49 | 182100.0 |
| 2007-04-02 | CEF | ETF | 9.39 | 9.49 | 9.25 | 9.4 | 217000.0 |
| 2007-04-02 | CGO | ETF | 17.14 | 17.27 | 17.13 | 17.2 | 20400.0 |
| 2007-04-02 | CHB | ETF | 8.8 | 8.86 | 8.72 | 8.81 | 881100.0 |
| 2007-04-02 | CHI | ETF | 20.2 | 20.23 | 20.14 | 20.18 | 54100.0 |
| 2007-04-02 | CHIC | ETF | 29.03 | 30.07 | 28.89 | 29.7 | 586565.0 |
| 2007-04-02 | CHY | ETF | 16.92 | 16.99 | 16.9 | 16.98 | 69100.0 |
| 2007-04-02 | CIL | ETF | 25.71 | 25.77 | 25.7 | 25.77 | 900.0 |
| 2007-04-02 | CN | ETF | 51.4 | 51.4 | 50.35 | 50.53 | 121100.0 |
| 2007-04-02 | CNXT | ETF | 1.66 | 1.68 | 1.64 | 1.66 | 5192348.0 |
| 2007-04-02 | CPST | ETF | 1.06 | 1.06 | 1.01 | 1.01 | 1055972.0 |
| 2007-04-02 | CSA | ETF | 21.08 | 21.64 | 20.85 | 21.64 | 60400.0 |
| 2007-04-02 | CSB | ETF | 33.04 | 33.21 | 32.88 | 33.21 | 8400.0 |
| 2007-04-02 | CSD | ETF | 27.41 | 27.41 | 27.29 | 27.38 | 5100.0 |
| 2007-04-02 | CSM | ETF | 1.3525 | 1.3525 | 1.3525 | 1.3525 | 1600.0 |
| 2007-04-02 | CSQ | ETF | 15.09 | 15.13 | 15.05 | 15.1 | 191100.0 |
| 2007-04-02 | CTEC | ETF | 85.85000000000001 | 89.64999999999999 | 85.25 | 89.25 | 17886.600000000002 |
| 2007-04-02 | CVY | ETF | 26.65 | 26.65 | 26.5 | 26.62 | 22400.0 |
| 2007-04-02 | CWI | ETF | 25.4933 | 25.5733 | 25.42 | 25.56 | 8700.0 |
| 2007-04-02 | DBA | ETF | 24.88 | 25.22 | 24.53 | 25.07 | 291800.0 |
| 2007-04-02 | DBB | ETF | 24.7 | 24.85 | 24.43 | 24.85 | 5800.0 |
| 2007-04-02 | DBC | ETF | 25.01 | 25.37 | 24.86 | 25.13 | 296700.0 |
| 2007-04-02 | DBE | ETF | 27.92 | 28.13 | 27.78 | 27.86 | 158500.0 |
| 2007-04-02 | DBO | ETF | 27.13 | 27.51 | 22.05 | 27.23 | 30700.0 |
| 2007-04-02 | DBP | ETF | 25.99 | 26.26 | 25.89 | 26.26 | 11400.0 |
| 2007-04-02 | DBS | ETF | 25.85 | 26.18 | 25.636 | 26.18 | 24700.0 |
| 2007-04-02 | DBV | ETF | 27.18 | 27.22 | 27.11 | 27.22 | 70600.0 |
| 2007-04-02 | DDM | ETF | 6.7183 | 6.7233 | 6.6558 | 6.7125 | 546000.0 |
| 2007-04-02 | DEF | ETF | 25.93 | 26.09 | 25.93 | 26.0 | 7300.0 |
| 2007-04-02 | DES | ETF | 19.1733 | 19.1733 | 19.0833 | 19.1667 | 26100.0 |
| 2007-04-02 | DEW | ETF | 63.82 | 64.02 | 63.62 | 64.02 | 8700.0 |
> showing 50 of 440 rows — these rows as CSV