PREVIEW / etf_daily / 2007-06-22
file: by_date/etf_daily/2007/2007-06-22.parquet size: 23 KB rows: 494
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-06-22 | SPY | ETF | 151.52 | 151.77 | 149.85 | 150.55 | 204964700.0 |
| 2007-06-22 | QQQ | ETF | 47.64 | 47.71 | 47.14 | 47.29 | 153419868.0 |
| 2007-06-22 | IWM | ETF | 83.36 | 83.48 | 82.3 | 82.92 | 93984100.0 |
| 2007-06-22 | DIA | ETF | 134.95 | 135.18 | 133.54 | 133.97 | 22142200.0 |
| 2007-06-22 | GLD | ETF | 64.9 | 64.98 | 64.43 | 64.78 | 1890800.0 |
| 2007-06-22 | TLT | ETF | 83.05 | 83.77 | 82.95 | 83.76 | 2118900.0 |
| 2007-06-22 | ADRE | ETF | 46.0 | 46.15 | 45.44 | 45.57 | 171694.0 |
| 2007-06-22 | AGG | ETF | 97.85 | 98.08 | 97.63 | 98.08 | 357900.0 |
| 2007-06-22 | AIQ | ETF | 45.45 | 45.45 | 43.7 | 43.7 | 174060.0 |
| 2007-06-22 | AIS | ETF | 1.91 | 1.91 | 1.75 | 1.8 | 473300.0 |
| 2007-06-22 | ARB | ETF | 50.75 | 50.77 | 49.96 | 50.01 | 322800.0 |
| 2007-06-22 | BBH | ETF | 59.3333 | 59.3633 | 58.5267 | 58.7733 | 1195200.0 |
| 2007-06-22 | BIL | ETF | 91.9 | 91.96 | 91.9 | 91.96 | 2200.0 |
| 2007-06-22 | BITS | ETF | 31.16 | 31.4 | 30.36 | 30.8 | 12832.0 |
| 2007-06-22 | BIV | ETF | 73.19 | 73.5 | 73.19 | 73.38 | 8100.0 |
| 2007-06-22 | BLV | ETF | 71.97 | 72.22 | 71.69 | 72.22 | 12200.0 |
| 2007-06-22 | BMVP | ETF | 17.8433 | 17.8628 | 17.7163 | 17.7567 | 30400.0 |
| 2007-06-22 | BND | ETF | 73.73 | 74.0 | 73.69 | 73.9 | 55800.0 |
| 2007-06-22 | BNE | ETF | 19.49 | 19.56 | 19.07 | 19.21 | 243200.0 |
| 2007-06-22 | BRF | ETF | 14.49 | 14.5 | 14.47 | 14.4982 | 11000.0 |
| 2007-06-22 | BSV | ETF | 74.69 | 74.8 | 74.68 | 74.8 | 41900.0 |
| 2007-06-22 | BTF | ETF | 109.04999999999998 | 109.04999999999998 | 107.05 | 107.6 | 1100.0 |
| 2007-06-22 | CBON | ETF | 28.99 | 29.1 | 28.06 | 28.36 | 325502.0 |
| 2007-06-22 | CDL | ETF | 6.06 | 6.25 | 6.04 | 6.24 | 6761688.0 |
| 2007-06-22 | CEF | ETF | 9.26 | 9.32 | 9.23 | 9.25 | 148200.0 |
| 2007-06-22 | CGO | ETF | 18.05 | 18.15 | 17.95 | 18.13 | 31500.0 |
| 2007-06-22 | CGW | ETF | 25.36 | 25.55 | 25.21 | 25.21 | 1084300.0 |
| 2007-06-22 | CHB | ETF | 10.62 | 10.62 | 10.09 | 10.33 | 1508000.0 |
| 2007-06-22 | CHI | ETF | 19.71 | 19.89 | 19.67 | 19.78 | 81100.0 |
| 2007-06-22 | CHIC | ETF | 27.08 | 27.75 | 26.92 | 27.33 | 1484129.0 |
| 2007-06-22 | CHY | ETF | 16.05 | 16.17 | 16.02 | 16.06 | 183500.0 |
| 2007-06-22 | CN | ETF | 58.79 | 58.79 | 57.6884 | 57.8 | 51500.0 |
| 2007-06-22 | CNXT | ETF | 1.44 | 1.47 | 1.37 | 1.42 | 21931081.0 |
| 2007-06-22 | CPST | ETF | 1.07 | 1.1 | 1.04 | 1.06 | 15793981.0 |
| 2007-06-22 | CSA | ETF | 19.59 | 20.15 | 19.59 | 20.0 | 42100.0 |
| 2007-06-22 | CSB | ETF | 32.55 | 32.55 | 32.02 | 32.07 | 14700.0 |
| 2007-06-22 | CSD | ETF | 31.01 | 31.06 | 30.77 | 30.83 | 21600.0 |
| 2007-06-22 | CSM | ETF | 1.4175 | 1.4175 | 1.4175 | 1.4175 | 4800.0 |
| 2007-06-22 | CSQ | ETF | 15.29 | 15.29 | 14.99 | 15.08 | 279100.0 |
| 2007-06-22 | CTEC | ETF | 110.99999999999999 | 111.45049999999999 | 109.60000000000001 | 110.29999999999998 | 39274.8 |
| 2007-06-22 | CVY | ETF | 27.96 | 27.96 | 27.71 | 27.75 | 16400.0 |
| 2007-06-22 | CWI | ETF | 27.3067 | 27.3067 | 27.0267 | 27.08 | 64350.0 |
| 2007-06-22 | CZA | ETF | 26.98 | 26.98 | 26.98 | 26.98 | 400.0 |
| 2007-06-22 | DBA | ETF | 27.15 | 27.26 | 26.34 | 26.69 | 535100.0 |
| 2007-06-22 | DBB | ETF | 26.65 | 26.7 | 26.44 | 26.62 | 13700.0 |
| 2007-06-22 | DBC | ETF | 26.26 | 26.3199 | 26.0 | 26.24 | 783200.0 |
| 2007-06-22 | DBE | ETF | 28.98 | 29.06 | 28.8 | 29.05 | 16500.0 |
| 2007-06-22 | DBO | ETF | 26.96 | 27.26 | 26.96 | 27.22 | 14300.0 |
| 2007-06-22 | DBP | ETF | 25.81 | 25.81 | 25.7 | 25.73 | 5300.0 |
| 2007-06-22 | DBS | ETF | 25.81 | 25.84 | 25.796 | 25.8399 | 1200.0 |
> showing 50 of 494 rows — these rows as CSV