PREVIEW / etf_daily / 2007-07-10
file: by_date/etf_daily/2007/2007-07-10.parquet size: 22 KB rows: 492
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-07-10 | SPY | ETF | 152.29 | 152.61 | 150.77 | 150.92 | 180362600.0 |
| 2007-07-10 | QQQ | ETF | 48.62 | 48.9 | 48.43 | 48.48 | 104397346.0 |
| 2007-07-10 | IWM | ETF | 84.27 | 84.88 | 83.21 | 83.33 | 101069100.0 |
| 2007-07-10 | DIA | ETF | 136.07 | 136.25 | 134.87 | 135.02 | 12622800.0 |
| 2007-07-10 | GLD | ETF | 65.7 | 65.86 | 65.36 | 65.61 | 4016200.0 |
| 2007-07-10 | TLT | ETF | 84.48 | 85.2 | 84.43 | 85.2 | 2258000.0 |
| 2007-07-10 | ADRE | ETF | 47.85 | 47.89 | 47.09 | 47.12 | 224278.0 |
| 2007-07-10 | AGG | ETF | 97.95 | 98.11 | 97.78 | 98.1 | 712600.0 |
| 2007-07-10 | AIQ | ETF | 50.4 | 51.1495 | 49.65 | 49.75 | 39160.0 |
| 2007-07-10 | AIS | ETF | 1.7 | 1.7 | 1.65 | 1.69 | 261600.0 |
| 2007-07-10 | ARB | ETF | 53.8 | 53.86 | 52.93 | 52.95 | 186200.0 |
| 2007-07-10 | BBH | ETF | 56.0333 | 56.4 | 55.73 | 55.74 | 404400.0 |
| 2007-07-10 | BIL | ETF | 91.66 | 91.7 | 91.66 | 91.7 | 5250.0 |
| 2007-07-10 | BITS | ETF | 27.4 | 27.92 | 26.8 | 27.2 | 25715.0 |
| 2007-07-10 | BIV | ETF | 73.47 | 73.74 | 73.47 | 73.74 | 8400.0 |
| 2007-07-10 | BLV | ETF | 72.71 | 72.78 | 72.58 | 72.77 | 11300.0 |
| 2007-07-10 | BMVP | ETF | 18.1033 | 18.1523 | 17.96 | 17.97 | 36500.0 |
| 2007-07-10 | BND | ETF | 73.96 | 74.09 | 73.89 | 74.09 | 110400.0 |
| 2007-07-10 | BNE | ETF | 19.46 | 19.7 | 19.36 | 19.5 | 358500.0 |
| 2007-07-10 | BRF | ETF | 14.51 | 14.52 | 14.51 | 14.51 | 2600.0 |
| 2007-07-10 | BSV | ETF | 74.65 | 74.81 | 74.65 | 74.81 | 33900.0 |
| 2007-07-10 | BTF | ETF | 109.0 | 109.0 | 107.5 | 107.79999999999998 | 1440.0 |
| 2007-07-10 | CBON | ETF | 27.3 | 27.34 | 26.89 | 26.97 | 85026.0 |
| 2007-07-10 | CDL | ETF | 6.5 | 6.54 | 6.3 | 6.32 | 2726863.0 |
| 2007-07-10 | CEF | ETF | 9.16 | 9.25 | 9.15 | 9.25 | 270400.0 |
| 2007-07-10 | CGO | ETF | 18.15 | 18.15 | 18.01 | 18.063 | 24700.0 |
| 2007-07-10 | CGW | ETF | 25.89 | 25.9 | 25.6 | 25.76 | 140600.0 |
| 2007-07-10 | CHB | ETF | 9.65 | 9.65 | 9.16 | 9.16 | 1881700.0 |
| 2007-07-10 | CHI | ETF | 19.45 | 19.454 | 19.21 | 19.25 | 66700.0 |
| 2007-07-10 | CHIC | ETF | 25.19 | 25.3 | 24.34 | 24.67 | 1097015.0 |
| 2007-07-10 | CHY | ETF | 16.3 | 16.3499 | 16.04 | 16.04 | 131600.0 |
| 2007-07-10 | CN | ETF | 55.15 | 55.15 | 54.15 | 54.21 | 50300.0 |
| 2007-07-10 | CNXT | ETF | 1.51 | 1.54 | 1.49 | 1.51 | 5557929.0 |
| 2007-07-10 | CPI | ETF | 23.5 | 23.5 | 23.5 | 23.5 | 100.0 |
| 2007-07-10 | CPST | ETF | 1.23 | 1.23 | 1.16 | 1.2 | 4343344.0 |
| 2007-07-10 | CSA | ETF | 19.55 | 19.62 | 18.99 | 19.2 | 126200.0 |
| 2007-07-10 | CSB | ETF | 32.27 | 32.46 | 32.04 | 32.04 | 30200.0 |
| 2007-07-10 | CSD | ETF | 31.08 | 31.19 | 30.97 | 30.97 | 16200.0 |
| 2007-07-10 | CSQ | ETF | 15.34 | 15.42 | 15.18 | 15.24 | 286900.0 |
| 2007-07-10 | CTEC | ETF | 111.8 | 111.8 | 108.69999999999999 | 108.94999999999999 | 15560.2 |
| 2007-07-10 | CVY | ETF | 27.91 | 27.91 | 27.61 | 27.61 | 28800.0 |
| 2007-07-10 | CWI | ETF | 27.98 | 28.0533 | 27.7333 | 27.78 | 10950.0 |
| 2007-07-10 | CZA | ETF | 27.53 | 27.53 | 27.31 | 27.31 | 2200.0 |
| 2007-07-10 | DBA | ETF | 26.73 | 27.24 | 26.55 | 27.16 | 425200.0 |
| 2007-07-10 | DBB | ETF | 27.3 | 27.46 | 27.17 | 27.46 | 17400.0 |
| 2007-07-10 | DBC | ETF | 26.2 | 26.52 | 26.19 | 26.48 | 228400.0 |
| 2007-07-10 | DBE | ETF | 29.42 | 29.84 | 29.42 | 29.79 | 144600.0 |
| 2007-07-10 | DBO | ETF | 27.6 | 27.86 | 27.49 | 27.79 | 15700.0 |
| 2007-07-10 | DBP | ETF | 25.95 | 26.01 | 25.93 | 26.0 | 21300.0 |
| 2007-07-10 | DBS | ETF | 25.27 | 25.52 | 25.27 | 25.34 | 11100.0 |
> showing 50 of 492 rows — these rows as CSV