PREVIEW / etf_daily / 2002-01-31
file: by_date/etf_daily/2002/2002-01-31.parquet size: 9 KB rows: 116
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-31 | SPY | ETF | 112.15 | 113.3 | 111.62 | 113.18 | 19909200.0 |
| 2002-01-31 | QQQ | ETF | 38.578 | 38.75 | 38.02 | 38.51 | 69655500.0 |
| 2002-01-31 | IWM | ETF | 47.8 | 48.1 | 47.505 | 48.1 | 2674000.0 |
| 2002-01-31 | DIA | ETF | 98.05 | 99.31 | 97.79 | 99.24 | 3945600.0 |
| 2002-01-31 | ARB | ETF | 31.3 | 31.55 | 31.21 | 31.49 | 68000.0 |
| 2002-01-31 | BBH | ETF | 39.6667 | 40.0 | 39.1667 | 39.6333 | 4358700.0 |
| 2002-01-31 | BITS | ETF | 18.4 | 19.0 | 18.4 | 18.64 | 3225.0 |
| 2002-01-31 | BOSS | ETF | 23.7 | 23.7 | 23.7 | 23.7 | 200.0 |
| 2002-01-31 | CEF | ETF | 3.52 | 3.57 | 3.45 | 3.56 | 20900.0 |
| 2002-01-31 | CHB | ETF | 11.75 | 12.39 | 11.75 | 12.36 | 518200.0 |
| 2002-01-31 | CNXT | ETF | 13.45 | 13.5 | 12.95 | 13.04 | 3136350.0 |
| 2002-01-31 | CSB | ETF | 4.0 | 4.09999990463257 | 4.0 | 4.09999990463257 | 5200.0 |
| 2002-01-31 | DGT | ETF | 63.38 | 63.38 | 63.38 | 63.38 | 200.0 |
| 2002-01-31 | EFA | ETF | 37.6167 | 37.6167 | 37.2167 | 37.4667 | 734100.0 |
| 2002-01-31 | ELV | ETF | 26.3 | 26.6 | 25.9 | 26.6 | 1035900.0 |
| 2002-01-31 | EPP | ETF | 18.4433 | 18.5 | 18.3667 | 18.4967 | 16500.0 |
| 2002-01-31 | EWA | ETF | 9.52 | 9.6 | 9.42 | 9.59 | 80400.0 |
| 2002-01-31 | EWC | ETF | 10.7 | 10.7 | 10.51 | 10.6 | 2700.0 |
| 2002-01-31 | EWD | ETF | 12.64 | 12.64 | 12.64 | 12.64 | 600.0 |
| 2002-01-31 | EWG | ETF | 14.35 | 14.41 | 14.2 | 14.41 | 208800.0 |
| 2002-01-31 | EWH | ETF | 9.08 | 9.09 | 8.9 | 9.09 | 36300.0 |
| 2002-01-31 | EWI | ETF | 31.2 | 31.3 | 31.2 | 31.3 | 3850.0 |
| 2002-01-31 | EWJ | ETF | 28.64 | 28.88 | 28.48 | 28.56 | 63975.0 |
| 2002-01-31 | EWL | ETF | 11.99 | 11.99 | 11.91 | 11.92 | 3100.0 |
| 2002-01-31 | EWM | ETF | 21.2 | 21.4 | 21.2 | 21.4 | 2450.0 |
| 2002-01-31 | EWN | ETF | 16.5 | 16.5 | 16.5 | 16.5 | 1600.0 |
| 2002-01-31 | EWO | ETF | 7.39 | 7.39 | 7.38 | 7.38 | 400.0 |
| 2002-01-31 | EWP | ETF | 19.5 | 19.5 | 19.5 | 19.5 | 3900.0 |
| 2002-01-31 | EWQ | ETF | 17.7 | 17.74 | 17.65 | 17.74 | 51800.0 |
| 2002-01-31 | EWS | ETF | 11.46 | 11.54 | 11.24 | 11.46 | 21650.0 |
| 2002-01-31 | EWT | ETF | 23.0 | 23.04 | 22.58 | 22.7 | 49400.0 |
| 2002-01-31 | EWU | ETF | 28.28 | 28.48 | 28.16 | 28.34 | 123600.0 |
| 2002-01-31 | EWW | ETF | 16.07 | 16.59 | 16.0 | 16.58 | 105000.0 |
| 2002-01-31 | EWY | ETF | 19.25 | 19.25 | 18.98 | 19.19 | 71200.0 |
| 2002-01-31 | EWZ | ETF | 11.58 | 11.58 | 11.55 | 11.55 | 3900.0 |
| 2002-01-31 | EZU | ETF | 26.575 | 26.575 | 26.375 | 26.45 | 66000.0 |
| 2002-01-31 | FCTR | ETF | 17.66 | 17.9 | 17.66 | 17.8802 | 21500.0 |
| 2002-01-31 | GLDB | ETF | 7.05 | 7.1 | 6.98 | 7.05 | 91500.0 |
| 2002-01-31 | GSIG | ETF | 8.12 | 8.3 | 7.78 | 7.99 | 438000.0 |
| 2002-01-31 | IBB | ETF | 26.1333 | 26.2833 | 25.8 | 26.1 | 71700.0 |
| 2002-01-31 | ICF | ETF | 20.97 | 21.05 | 20.84 | 21.05 | 35200.0 |
| 2002-01-31 | IDU | ETF | 30.275 | 30.725 | 30.195 | 30.725 | 280200.0 |
| 2002-01-31 | IEV | ETF | 28.235 | 28.28 | 28.0 | 28.28 | 22800.0 |
| 2002-01-31 | IGLD | ETF | 175.0 | 189.0 | 175.0 | 180.0 | 1746.0 |
| 2002-01-31 | IGM | ETF | 8.3833 | 8.3833 | 8.2833 | 8.3567 | 31800.0 |
| 2002-01-31 | IGN | ETF | 29.41 | 29.65 | 29.25 | 29.6 | 402900.0 |
| 2002-01-31 | IGV | ETF | 9.2 | 9.27 | 9.094 | 9.19 | 1033500.0 |
| 2002-01-31 | IJH | ETF | 10.107 | 10.138 | 10.066 | 10.121 | 620000.0 |
| 2002-01-31 | IJJ | ETF | 22.505 | 22.625 | 22.4825 | 22.5575 | 82800.0 |
| 2002-01-31 | IJK | ETF | 14.0812 | 14.0988 | 14.0 | 14.075 | 110400.0 |
> showing 50 of 116 rows — these rows as CSV