PREVIEW / etf_daily / 2007-10-18
file: by_date/etf_daily/2007/2007-10-18.parquet size: 23 KB rows: 510
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-10-18 | SPY | ETF | 153.45 | 154.19 | 153.08 | 153.69 | 148367500.0 |
| 2007-10-18 | QQQ | ETF | 53.33 | 53.89 | 53.12 | 53.78 | 144501834.0 |
| 2007-10-18 | IWM | ETF | 81.68 | 82.39 | 81.39 | 82.02 | 68562200.0 |
| 2007-10-18 | DIA | ETF | 138.53 | 139.16 | 138.22 | 138.8 | 11615700.0 |
| 2007-10-18 | GLD | ETF | 75.38 | 76.0 | 75.33 | 76.0 | 5646900.0 |
| 2007-10-18 | TLT | ETF | 89.11 | 89.34 | 89.02 | 89.13 | 1374100.0 |
| 2007-10-18 | ADRE | ETF | 57.3 | 57.52 | 56.0 | 57.49 | 296947.0 |
| 2007-10-18 | AGG | ETF | 100.28 | 100.3 | 100.07 | 100.27 | 270000.0 |
| 2007-10-18 | AIQ | ETF | 45.95 | 48.55 | 45.95 | 48.1 | 161920.0 |
| 2007-10-18 | AIS | ETF | 1.35 | 1.38 | 1.33 | 1.34 | 145200.0 |
| 2007-10-18 | AIVI | ETF | 74.84 | 75.28 | 74.67 | 75.2 | 34800.0 |
| 2007-10-18 | ARB | ETF | 46.25 | 47.35 | 45.0 | 46.54 | 587600.0 |
| 2007-10-18 | BBH | ETF | 59.53 | 59.79 | 59.2467 | 59.57 | 647100.0 |
| 2007-10-18 | BIL | ETF | 91.82 | 91.84 | 91.76 | 91.76 | 12400.0 |
| 2007-10-18 | BITS | ETF | 26.0 | 26.44 | 25.76 | 26.0 | 3480.0 |
| 2007-10-18 | BIV | ETF | 75.98 | 76.04 | 75.95 | 76.03 | 10400.0 |
| 2007-10-18 | BLV | ETF | 75.49 | 75.62 | 75.43 | 75.58 | 13300.0 |
| 2007-10-18 | BMVP | ETF | 17.43 | 17.5666 | 17.4167 | 17.4867 | 70500.0 |
| 2007-10-18 | BND | ETF | 75.89 | 75.95 | 75.85 | 75.93 | 92000.0 |
| 2007-10-18 | BNE | ETF | 17.74 | 17.84 | 17.49 | 17.51 | 130700.0 |
| 2007-10-18 | BRF | ETF | 14.6 | 14.6001 | 14.55 | 14.56 | 25300.0 |
| 2007-10-18 | BSV | ETF | 76.19 | 76.21 | 76.11 | 76.16 | 58500.0 |
| 2007-10-18 | BTF | ETF | 112.5 | 116.44999999999999 | 111.99999999999999 | 115.95 | 24480.0 |
| 2007-10-18 | BWX | ETF | 26.19 | 26.22 | 26.125 | 26.175 | 71000.0 |
| 2007-10-18 | CBON | ETF | 22.26 | 22.32 | 21.17 | 21.37 | 100306.0 |
| 2007-10-18 | CDL | ETF | 4.2 | 4.22 | 4.15 | 4.19 | 2008500.0 |
| 2007-10-18 | CEF | ETF | 10.0 | 10.09 | 9.97 | 10.09 | 374600.0 |
| 2007-10-18 | CGO | ETF | 18.59 | 18.82 | 18.51 | 18.82 | 28300.0 |
| 2007-10-18 | CGW | ETF | 26.33 | 26.35 | 26.16 | 26.35 | 46600.0 |
| 2007-10-18 | CHB | ETF | 13.55 | 13.86 | 13.37 | 13.42 | 2802900.0 |
| 2007-10-18 | CHI | ETF | 16.85 | 16.98 | 16.85 | 16.91 | 130300.0 |
| 2007-10-18 | CHIC | ETF | 14.68 | 14.74 | 14.35 | 14.44 | 448560.0 |
| 2007-10-18 | CHW | ETF | 13.19 | 13.42 | 13.17 | 13.22 | 234300.0 |
| 2007-10-18 | CHY | ETF | 14.97 | 15.1 | 14.9001 | 15.04 | 112700.0 |
| 2007-10-18 | CMF | ETF | 51.89 | 51.945 | 51.89 | 51.945 | 7600.0 |
| 2007-10-18 | CN | ETF | 66.5 | 67.72 | 66.12 | 67.17 | 269900.0 |
| 2007-10-18 | CNXT | ETF | 1.45 | 1.46 | 1.41 | 1.45 | 4750452.0 |
| 2007-10-18 | CPST | ETF | 1.06 | 1.13 | 1.05 | 1.1 | 6786292.0 |
| 2007-10-18 | CSA | ETF | 17.71 | 18.14 | 17.5 | 18.06 | 35000.0 |
| 2007-10-18 | CSD | ETF | 29.14 | 29.27 | 29.09 | 29.23 | 12400.0 |
| 2007-10-18 | CSM | ETF | 1.4675 | 1.4675 | 1.465 | 1.465 | 8000.0 |
| 2007-10-18 | CSQ | ETF | 14.84 | 14.9 | 14.78 | 14.89 | 185000.0 |
| 2007-10-18 | CVY | ETF | 25.83 | 26.01 | 25.83 | 25.97 | 16800.0 |
| 2007-10-18 | CWI | ETF | 29.0333 | 29.26 | 29.0333 | 29.26 | 18150.0 |
| 2007-10-18 | CZA | ETF | 27.01 | 27.01 | 27.01 | 27.01 | 300.0 |
| 2007-10-18 | DBA | ETF | 29.14 | 29.37 | 28.96 | 29.36 | 254200.0 |
| 2007-10-18 | DBB | ETF | 25.92 | 26.2 | 25.89 | 26.13 | 14200.0 |
| 2007-10-18 | DBC | ETF | 28.59 | 29.03 | 28.59 | 28.99 | 337500.0 |
| 2007-10-18 | DBE | ETF | 32.01 | 32.4 | 31.98 | 32.33 | 48900.0 |
| 2007-10-18 | DBO | ETF | 31.22 | 31.65 | 30.24 | 31.62 | 7400.0 |
> showing 50 of 510 rows — these rows as CSV