PREVIEW / etf_daily / 2001-08-15
file: by_date/etf_daily/2001/2001-08-15.parquet size: 8 KB rows: 101
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 |
|---|---|---|---|---|---|---|---|
| 2001-08-15 | SPY | ETF | 119.23 | 119.61 | 118.08 | 118.24 | 8520600.0 |
| 2001-08-15 | QQQ | ETF | 40.62 | 40.93 | 39.07 | 39.1 | 58811300.0 |
| 2001-08-15 | IWM | ETF | 47.875 | 48.115 | 47.51 | 47.79 | 931600.0 |
| 2001-08-15 | DIA | ETF | 104.31 | 104.84 | 103.52 | 103.57 | 2354500.0 |
| 2001-08-15 | BBH | ETF | 40.1833 | 40.23 | 39.0333 | 39.0367 | 4386300.0 |
| 2001-08-15 | BITS | ETF | 14.64 | 15.2 | 14.36 | 15.0 | 1450.0 |
| 2001-08-15 | CEF | ETF | 3.12 | 3.18 | 3.11 | 3.15 | 16400.0 |
| 2001-08-15 | CHB | ETF | 10.07 | 10.1 | 9.7 | 9.72 | 111200.0 |
| 2001-08-15 | CNXT | ETF | 10.33 | 10.43 | 9.91 | 9.91 | 3331800.0 |
| 2001-08-15 | CSB | ETF | 2.5 | 2.5 | 2.5 | 2.5 | 21100.0 |
| 2001-08-15 | EWA | ETF | 9.7 | 9.74 | 9.67 | 9.67 | 5200.0 |
| 2001-08-15 | EWC | ETF | 11.24 | 11.24 | 11.24 | 11.24 | 200.0 |
| 2001-08-15 | EWD | ETF | 13.84 | 13.85 | 13.84 | 13.85 | 800.0 |
| 2001-08-15 | EWG | ETF | 16.21 | 16.21 | 16.1 | 16.1 | 74800.0 |
| 2001-08-15 | EWH | ETF | 9.23 | 9.26 | 9.13 | 9.13 | 10300.0 |
| 2001-08-15 | EWI | ETF | 37.34 | 37.34 | 37.34 | 37.34 | 6550.0 |
| 2001-08-15 | EWJ | ETF | 38.88 | 38.88 | 38.32 | 38.52 | 136875.0 |
| 2001-08-15 | EWK | ETF | 11.85 | 11.85 | 11.85 | 11.85 | 300.0 |
| 2001-08-15 | EWL | ETF | 13.25 | 13.5 | 13.25 | 13.36 | 2100.0 |
| 2001-08-15 | EWM | ETF | 18.68 | 19.48 | 18.68 | 18.68 | 1125.0 |
| 2001-08-15 | EWP | ETF | 21.75 | 21.75 | 21.75 | 21.75 | 300.0 |
| 2001-08-15 | EWQ | ETF | 20.42 | 20.52 | 20.38 | 20.4 | 1900.0 |
| 2001-08-15 | EWS | ETF | 10.76 | 10.76 | 10.7 | 10.72 | 7400.0 |
| 2001-08-15 | EWT | ETF | 18.76 | 19.0 | 18.76 | 18.76 | 56750.0 |
| 2001-08-15 | EWU | ETF | 31.22 | 31.4 | 31.06 | 31.06 | 5350.0 |
| 2001-08-15 | EWW | ETF | 16.35 | 16.35 | 15.91 | 15.92 | 17700.0 |
| 2001-08-15 | EWY | ETF | 14.09 | 14.09 | 14.02 | 14.02 | 1100.0 |
| 2001-08-15 | EZU | ETF | 30.0 | 30.245 | 29.885 | 30.245 | 15400.0 |
| 2001-08-15 | FCTR | ETF | 18.3 | 18.34 | 17.99 | 18.1 | 12500.0 |
| 2001-08-15 | FMAR | ETF | 9.2 | 9.47 | 9.2 | 9.47 | 10700.0 |
| 2001-08-15 | GLDB | ETF | 7.88 | 7.94 | 7.83 | 7.85 | 43600.0 |
| 2001-08-15 | GRNB | ETF | 23.5598 | 23.5598 | 23.5598 | 23.5598 | 101.0 |
| 2001-08-15 | GSIG | ETF | 8.47 | 8.67 | 8.16 | 8.25 | 255900.0 |
| 2001-08-15 | IBB | ETF | 28.2667 | 28.2667 | 27.5167 | 27.5833 | 674400.0 |
| 2001-08-15 | ICF | ETF | 21.9 | 22.015 | 21.875 | 22.015 | 5200.0 |
| 2001-08-15 | IDU | ETF | 36.425 | 36.425 | 35.8 | 35.95 | 3400.0 |
| 2001-08-15 | IEV | ETF | 31.47 | 31.47 | 31.025 | 31.05 | 23200.0 |
| 2001-08-15 | IGLD | ETF | 70.0 | 81.0 | 70.0 | 74.0 | 134.0 |
| 2001-08-15 | IGM | ETF | 8.7417 | 8.7417 | 8.5 | 8.5 | 10800.0 |
| 2001-08-15 | IGV | ETF | 8.9 | 8.9 | 8.69 | 8.69 | 7500.0 |
| 2001-08-15 | IJH | ETF | 10.112 | 10.112 | 10.014 | 10.057 | 407000.0 |
| 2001-08-15 | IJJ | ETF | 22.85 | 22.855 | 22.61 | 22.7325 | 32000.0 |
| 2001-08-15 | IJK | ETF | 13.8725 | 13.8725 | 13.6825 | 13.7975 | 91200.0 |
| 2001-08-15 | IJR | ETF | 18.8333 | 18.8333 | 18.68 | 18.8 | 58200.0 |
| 2001-08-15 | IJS | ETF | 21.2375 | 21.2825 | 21.03 | 21.2825 | 95200.0 |
| 2001-08-15 | IJT | ETF | 18.775 | 18.775 | 18.54 | 18.695 | 18000.0 |
| 2001-08-15 | IOO | ETF | 30.33 | 30.33 | 30.105 | 30.125 | 41600.0 |
| 2001-08-15 | IUSG | ETF | 20.775 | 20.825 | 20.67 | 20.67 | 3000.0 |
| 2001-08-15 | IUSV | ETF | 24.7233 | 24.73 | 24.6 | 24.72 | 23400.0 |
| 2001-08-15 | IVE | ETF | 59.55 | 59.55 | 58.82 | 59.1 | 84300.0 |
> showing 50 of 101 rows — these rows as CSV