PREVIEW / etf_daily / 2001-10-25
file: by_date/etf_daily/2001/2001-10-25.parquet size: 9 KB rows: 111
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-10-25 | SPY | ETF | 107.45 | 110.6 | 106.74 | 110.57 | 27467900.0 |
| 2001-10-25 | QQQ | ETF | 34.705 | 36.82 | 34.23 | 36.8 | 118552200.0 |
| 2001-10-25 | IWM | ETF | 42.2 | 43.625 | 42.0 | 43.625 | 1195000.0 |
| 2001-10-25 | DIA | ETF | 92.5 | 94.99 | 91.74 | 94.98 | 3775300.0 |
| 2001-10-25 | ARB | ETF | 27.4 | 27.4 | 26.69 | 27.14 | 75600.0 |
| 2001-10-25 | BBH | ETF | 41.2 | 43.2167 | 40.9167 | 43.1667 | 4406100.0 |
| 2001-10-25 | BITS | ETF | 16.84 | 16.84 | 16.08 | 16.08 | 2225.0 |
| 2001-10-25 | CEF | ETF | 3.46 | 3.5 | 3.37 | 3.47 | 19100.0 |
| 2001-10-25 | CHB | ETF | 7.66 | 7.8 | 7.21 | 7.71 | 350900.0 |
| 2001-10-25 | CNXT | ETF | 11.01 | 12.06 | 10.5 | 11.98 | 5285860.0 |
| 2001-10-25 | CSB | ETF | 3.84999990463257 | 3.85999989509583 | 3.84999990463257 | 3.84999990463257 | 18500.0 |
| 2001-10-25 | DGT | ETF | 63.55 | 63.55 | 63.55 | 63.55 | 100.0 |
| 2001-10-25 | EFA | ETF | 38.75 | 39.2333 | 38.5833 | 39.1733 | 63900.0 |
| 2001-10-25 | EWA | ETF | 8.8 | 8.85 | 8.8 | 8.85 | 5300.0 |
| 2001-10-25 | EWC | ETF | 9.62 | 9.81 | 9.62 | 9.81 | 3100.0 |
| 2001-10-25 | EWD | ETF | 12.0 | 12.0 | 11.86 | 11.86 | 300.0 |
| 2001-10-25 | EWG | ETF | 13.38 | 13.55 | 13.25 | 13.55 | 98700.0 |
| 2001-10-25 | EWH | ETF | 8.12 | 8.38 | 7.96 | 8.22 | 58100.0 |
| 2001-10-25 | EWI | ETF | 31.42 | 31.42 | 31.3 | 31.3 | 2050.0 |
| 2001-10-25 | EWJ | ETF | 34.76 | 35.32 | 34.48 | 35.32 | 257875.0 |
| 2001-10-25 | EWK | ETF | 10.44 | 10.44 | 10.44 | 10.44 | 1100.0 |
| 2001-10-25 | EWL | ETF | 12.23 | 12.45 | 12.16 | 12.26 | 16900.0 |
| 2001-10-25 | EWM | ETF | 17.6 | 18.0 | 17.44 | 18.0 | 6475.0 |
| 2001-10-25 | EWN | ETF | 15.9 | 16.0 | 15.9 | 16.0 | 4100.0 |
| 2001-10-25 | EWO | ETF | 6.8 | 6.8 | 6.72 | 6.8 | 15700.0 |
| 2001-10-25 | EWP | ETF | 19.4 | 19.55 | 19.31 | 19.55 | 700.0 |
| 2001-10-25 | EWQ | ETF | 17.7 | 18.05 | 17.7 | 17.96 | 29600.0 |
| 2001-10-25 | EWS | ETF | 8.96 | 9.1 | 8.9 | 8.92 | 11600.0 |
| 2001-10-25 | EWT | ETF | 16.34 | 16.34 | 15.6 | 15.98 | 15300.0 |
| 2001-10-25 | EWU | ETF | 28.2 | 28.78 | 28.18 | 28.68 | 35550.0 |
| 2001-10-25 | EWW | ETF | 13.64 | 13.74 | 13.21 | 13.74 | 137700.0 |
| 2001-10-25 | EWY | ETF | 12.8 | 13.11 | 12.77 | 13.11 | 8600.0 |
| 2001-10-25 | EWZ | ETF | 9.86 | 9.86 | 9.86 | 9.86 | 1000.0 |
| 2001-10-25 | EZU | ETF | 26.195 | 26.45 | 25.5 | 26.3 | 38400.0 |
| 2001-10-25 | FCTR | ETF | 17.05 | 18.0 | 16.95 | 18.0 | 32100.0 |
| 2001-10-25 | FMAR | ETF | 7.9 | 7.99 | 7.85 | 7.99 | 31600.0 |
| 2001-10-25 | GLDB | ETF | 7.45 | 7.65 | 7.45 | 7.6 | 51900.0 |
| 2001-10-25 | GRNB | ETF | 14.7249 | 14.7249 | 14.7249 | 14.7249 | 20388.0 |
| 2001-10-25 | GSIG | ETF | 7.67 | 7.74 | 7.47 | 7.61 | 33900.0 |
| 2001-10-25 | IBB | ETF | 28.3 | 29.4667 | 27.99 | 29.4167 | 880800.0 |
| 2001-10-25 | ICF | ETF | 19.4375 | 19.6125 | 19.4375 | 19.55 | 161600.0 |
| 2001-10-25 | IDU | ETF | 31.95 | 32.715 | 31.95 | 32.55 | 3800.0 |
| 2001-10-25 | IEV | ETF | 28.095 | 28.42 | 27.67 | 28.385 | 97200.0 |
| 2001-10-25 | IGLD | ETF | 70.0 | 75.0 | 70.0 | 75.0 | 57.0 |
| 2001-10-25 | IGM | ETF | 7.475 | 7.8317 | 7.4333 | 7.83 | 112800.0 |
| 2001-10-25 | IGN | ETF | 29.3 | 30.99 | 29.0 | 30.99 | 14500.0 |
| 2001-10-25 | IGV | ETF | 7.6 | 7.618 | 7.57 | 7.618 | 20500.0 |
| 2001-10-25 | IJH | ETF | 9.01 | 9.26 | 8.965 | 9.258 | 221000.0 |
| 2001-10-25 | IJJ | ETF | 20.0775 | 20.53 | 19.9375 | 20.5025 | 82000.0 |
| 2001-10-25 | IJK | ETF | 12.5688 | 12.9588 | 12.4825 | 12.9588 | 118400.0 |
> showing 50 of 111 rows — these rows as CSV