PREVIEW / etf_daily / 2001-12-19
file: by_date/etf_daily/2001/2001-12-19.parquet size: 9 KB rows: 119
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-12-19 | SPY | ETF | 114.09 | 115.92 | 114.0 | 115.79 | 20143400.0 |
| 2001-12-19 | QQQ | ETF | 40.56 | 41.32 | 40.32 | 40.51 | 79596200.0 |
| 2001-12-19 | IWM | ETF | 47.875 | 48.19 | 47.565 | 47.9 | 1551600.0 |
| 2001-12-19 | DIA | ETF | 99.6 | 101.17 | 99.36 | 101.16 | 2250900.0 |
| 2001-12-19 | ARB | ETF | 32.6 | 33.0 | 31.9 | 32.08 | 134100.0 |
| 2001-12-19 | BBH | ETF | 44.5667 | 45.3333 | 44.2567 | 44.8367 | 3154200.0 |
| 2001-12-19 | BITS | ETF | 25.88 | 25.9096 | 24.2 | 24.32 | 6925.0 |
| 2001-12-19 | CEF | ETF | 3.29 | 3.44 | 3.29 | 3.39 | 24300.0 |
| 2001-12-19 | CHB | ETF | 12.95 | 13.35 | 12.93 | 13.09 | 645600.0 |
| 2001-12-19 | CNXT | ETF | 15.52 | 15.55 | 14.11 | 14.18 | 7647600.0 |
| 2001-12-19 | CSB | ETF | 3.79999995231628 | 3.79999995231628 | 3.74000000953674 | 3.75 | 94000.0 |
| 2001-12-19 | DGT | ETF | 66.25 | 66.25 | 66.25 | 66.25 | 100.0 |
| 2001-12-19 | EFA | ETF | 39.0 | 39.2167 | 38.9233 | 39.15 | 772500.0 |
| 2001-12-19 | ELV | ETF | 24.65 | 24.675 | 23.875 | 24.0 | 736600.0 |
| 2001-12-19 | EPP | ETF | 17.98 | 17.98 | 17.9167 | 17.9167 | 2400.0 |
| 2001-12-19 | EWA | ETF | 9.25 | 9.25 | 9.15 | 9.2 | 31100.0 |
| 2001-12-19 | EWC | ETF | 10.65 | 10.85 | 10.65 | 10.79 | 7600.0 |
| 2001-12-19 | EWD | ETF | 13.15 | 13.54 | 13.15 | 13.4 | 2500.0 |
| 2001-12-19 | EWG | ETF | 14.49 | 14.74 | 14.49 | 14.67 | 365700.0 |
| 2001-12-19 | EWH | ETF | 9.34 | 9.42 | 9.29 | 9.37 | 76900.0 |
| 2001-12-19 | EWI | ETF | 31.4 | 31.72 | 31.4 | 31.62 | 2850.0 |
| 2001-12-19 | EWJ | ETF | 31.0 | 31.32 | 30.8 | 31.24 | 354375.0 |
| 2001-12-19 | EWL | ETF | 12.3 | 12.4 | 12.21 | 12.4 | 12500.0 |
| 2001-12-19 | EWM | ETF | 19.56 | 19.8 | 19.52 | 19.6 | 2625.0 |
| 2001-12-19 | EWN | ETF | 16.31 | 16.58 | 16.31 | 16.46 | 2600.0 |
| 2001-12-19 | EWO | ETF | 7.4 | 7.4 | 7.24 | 7.35 | 1700.0 |
| 2001-12-19 | EWP | ETF | 20.88 | 20.99 | 20.81 | 20.95 | 500.0 |
| 2001-12-19 | EWQ | ETF | 18.07 | 18.38 | 18.07 | 18.26 | 7300.0 |
| 2001-12-19 | EWS | ETF | 10.18 | 10.22 | 9.96 | 10.08 | 15950.0 |
| 2001-12-19 | EWT | ETF | 20.8 | 20.92 | 20.38 | 20.8 | 17800.0 |
| 2001-12-19 | EWU | ETF | 29.08 | 29.34 | 29.04 | 29.26 | 177250.0 |
| 2001-12-19 | EWW | ETF | 14.85 | 14.92 | 14.76 | 14.91 | 6900.0 |
| 2001-12-19 | EWY | ETF | 16.65 | 16.65 | 16.37 | 16.41 | 88200.0 |
| 2001-12-19 | EWZ | ETF | 12.48 | 12.49 | 12.42 | 12.47 | 1100.0 |
| 2001-12-19 | EZU | ETF | 27.125 | 27.42 | 27.1 | 27.4 | 71000.0 |
| 2001-12-19 | FCTR | ETF | 17.82 | 18.37 | 17.82 | 18.14 | 28200.0 |
| 2001-12-19 | FMAR | ETF | 8.7 | 9.29 | 8.6 | 9.25 | 47800.0 |
| 2001-12-19 | GLDB | ETF | 7.26 | 7.5 | 7.25 | 7.44 | 102400.0 |
| 2001-12-19 | GRNB | ETF | 17.179 | 17.179 | 17.179 | 17.179 | 807.0 |
| 2001-12-19 | GSIG | ETF | 7.91 | 8.0 | 7.71 | 7.72 | 96900.0 |
| 2001-12-19 | IBB | ETF | 30.6667 | 31.1333 | 30.5 | 30.8 | 379200.0 |
| 2001-12-19 | ICF | ETF | 20.875 | 20.935 | 20.845 | 20.9025 | 10000.0 |
| 2001-12-19 | IDU | ETF | 30.175 | 31.24 | 30.125 | 31.175 | 241200.0 |
| 2001-12-19 | IEV | ETF | 28.775 | 29.18 | 28.775 | 28.99 | 133200.0 |
| 2001-12-19 | IGE | ETF | 15.1083 | 15.2333 | 15.1083 | 15.2333 | 14400.0 |
| 2001-12-19 | IGLD | ETF | 86.0 | 90.0 | 85.0 | 87.0 | 97.0 |
| 2001-12-19 | IGM | ETF | 8.6333 | 8.7333 | 8.5583 | 8.63 | 4854000.0 |
| 2001-12-19 | IGN | ETF | 30.77 | 31.25 | 30.55 | 30.55 | 607600.0 |
| 2001-12-19 | IGV | ETF | 9.38 | 9.504 | 9.38 | 9.42 | 15500.0 |
| 2001-12-19 | IJH | ETF | 9.965 | 10.099 | 9.95 | 10.06 | 127000.0 |
> showing 50 of 119 rows — these rows as CSV