PREVIEW / etf_daily / 2001-10-30
file: by_date/etf_daily/2001/2001-10-30.parquet size: 9 KB rows: 110
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-30 | SPY | ETF | 107.35 | 107.7 | 105.56 | 106.16 | 26178600.0 |
| 2001-10-30 | QQQ | ETF | 33.71 | 34.09 | 32.84 | 33.38 | 96092200.0 |
| 2001-10-30 | IWM | ETF | 42.4 | 42.4 | 41.675 | 41.85 | 887200.0 |
| 2001-10-30 | DIA | ETF | 92.1 | 92.15 | 90.68 | 91.15 | 4090800.0 |
| 2001-10-30 | ARB | ETF | 26.96 | 26.96 | 26.2 | 26.55 | 48000.0 |
| 2001-10-30 | BBH | ETF | 41.8667 | 42.4333 | 40.8667 | 41.7833 | 3424800.0 |
| 2001-10-30 | BITS | ETF | 16.0 | 16.44 | 15.68 | 16.0 | 9700.0 |
| 2001-10-30 | CEF | ETF | 3.47 | 3.55 | 3.47 | 3.54 | 16400.0 |
| 2001-10-30 | CHB | ETF | 7.91 | 8.2 | 7.79 | 8.1 | 292100.0 |
| 2001-10-30 | CNXT | ETF | 10.53 | 10.56 | 9.73 | 9.91 | 4398690.0 |
| 2001-10-30 | DGT | ETF | 63.28 | 63.28 | 63.28 | 63.28 | 100.0 |
| 2001-10-30 | EFA | ETF | 38.3667 | 38.4667 | 38.02 | 38.1667 | 260100.0 |
| 2001-10-30 | ELV | ETF | 20.25 | 20.45 | 20.175 | 20.45 | 22720900.0 |
| 2001-10-30 | EPP | ETF | 16.5667 | 16.5667 | 16.5667 | 16.5667 | 600.0 |
| 2001-10-30 | EWA | ETF | 8.9 | 8.9 | 8.8 | 8.8 | 2400.0 |
| 2001-10-30 | EWC | ETF | 9.85 | 9.85 | 9.85 | 9.85 | 200.0 |
| 2001-10-30 | EWG | ETF | 13.25 | 13.25 | 13.0 | 13.14 | 52400.0 |
| 2001-10-30 | EWH | ETF | 7.91 | 7.91 | 7.8 | 7.8 | 27800.0 |
| 2001-10-30 | EWI | ETF | 31.4 | 31.4 | 30.82 | 30.82 | 8300.0 |
| 2001-10-30 | EWJ | ETF | 33.88 | 33.92 | 33.28 | 33.28 | 40950.0 |
| 2001-10-30 | EWK | ETF | 10.45 | 10.45 | 10.45 | 10.45 | 1700.0 |
| 2001-10-30 | EWL | ETF | 12.05 | 12.17 | 12.01 | 12.14 | 3500.0 |
| 2001-10-30 | EWM | ETF | 17.52 | 17.88 | 17.52 | 17.52 | 4750.0 |
| 2001-10-30 | EWN | ETF | 16.09 | 16.09 | 16.09 | 16.09 | 1400.0 |
| 2001-10-30 | EWO | ETF | 6.7 | 6.7 | 6.69 | 6.7 | 3300.0 |
| 2001-10-30 | EWP | ETF | 19.1 | 19.2 | 19.1 | 19.15 | 7100.0 |
| 2001-10-30 | EWQ | ETF | 17.61 | 17.61 | 17.5 | 17.5 | 20900.0 |
| 2001-10-30 | EWS | ETF | 8.7 | 8.8 | 8.68 | 8.68 | 7700.0 |
| 2001-10-30 | EWT | ETF | 15.4 | 15.4 | 15.04 | 15.22 | 3550.0 |
| 2001-10-30 | EWU | ETF | 28.4 | 28.4 | 28.08 | 28.08 | 65300.0 |
| 2001-10-30 | EWW | ETF | 13.06 | 13.06 | 12.8 | 12.9 | 5700.0 |
| 2001-10-30 | EWY | ETF | 12.3 | 12.75 | 12.3 | 12.73 | 7700.0 |
| 2001-10-30 | EWZ | ETF | 9.41 | 9.41 | 9.35 | 9.35 | 600.0 |
| 2001-10-30 | EZU | ETF | 25.75 | 25.75 | 25.41 | 25.54 | 144800.0 |
| 2001-10-30 | FCTR | ETF | 16.91 | 17.09 | 16.25 | 16.25 | 22200.0 |
| 2001-10-30 | FMAR | ETF | 7.9 | 7.95 | 7.9 | 7.95 | 42800.0 |
| 2001-10-30 | GLDB | ETF | 7.59 | 7.59 | 7.36 | 7.36 | 25400.0 |
| 2001-10-30 | GRNB | ETF | 16.6882 | 16.6882 | 16.6882 | 16.6882 | 505.0 |
| 2001-10-30 | GSIG | ETF | 7.73 | 7.81 | 7.64 | 7.64 | 24000.0 |
| 2001-10-30 | IBB | ETF | 28.7 | 28.7967 | 27.8333 | 28.4 | 697800.0 |
| 2001-10-30 | ICF | ETF | 19.675 | 19.7125 | 19.5525 | 19.7025 | 40800.0 |
| 2001-10-30 | IDU | ETF | 32.125 | 32.25 | 31.87 | 31.97 | 11200.0 |
| 2001-10-30 | IEV | ETF | 27.725 | 27.9 | 27.47 | 27.5 | 21000.0 |
| 2001-10-30 | IGLD | ETF | 71.25 | 76.0 | 71.25 | 76.0 | 5.0 |
| 2001-10-30 | IGM | ETF | 7.2917 | 7.3083 | 7.175 | 7.3083 | 41400.0 |
| 2001-10-30 | IGN | ETF | 28.3 | 28.34 | 28.01 | 28.2 | 8200.0 |
| 2001-10-30 | IGV | ETF | 7.26 | 7.322 | 7.23 | 7.31 | 17000.0 |
| 2001-10-30 | IJH | ETF | 9.015 | 9.016 | 8.883 | 8.959 | 242000.0 |
| 2001-10-30 | IJJ | ETF | 20.15 | 20.15 | 19.8375 | 20.0125 | 51200.0 |
| 2001-10-30 | IJK | ETF | 12.5375 | 12.575 | 12.365 | 12.4812 | 189600.0 |
> showing 50 of 110 rows — these rows as CSV