PREVIEW / etf_daily / 2001-07-25
file: by_date/etf_daily/2001/2001-07-25.parquet size: 8 KB rows: 98
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-07-25 | SPY | ETF | 117.92 | 119.48 | 117.46 | 119.1 | 12088500.0 |
| 2001-07-25 | QQQ | ETF | 40.141 | 40.72 | 39.4 | 40.5 | 68860900.0 |
| 2001-07-25 | IWM | ETF | 47.45 | 47.65 | 46.955 | 47.625 | 603600.0 |
| 2001-07-25 | DIA | ETF | 102.7 | 104.24 | 102.57 | 103.95 | 2227400.0 |
| 2001-07-25 | BBH | ETF | 37.5833 | 38.5367 | 37.5167 | 38.46 | 4694400.0 |
| 2001-07-25 | BITS | ETF | 13.64 | 14.4 | 13.6 | 14.2 | 80025.0 |
| 2001-07-25 | CEF | ETF | 3.08 | 3.12 | 3.07 | 3.12 | 4400.0 |
| 2001-07-25 | CHB | ETF | 10.9 | 10.9 | 10.62 | 10.78 | 412700.0 |
| 2001-07-25 | CNXT | ETF | 8.09 | 8.44 | 7.938 | 8.33 | 1900900.0 |
| 2001-07-25 | CSB | ETF | 2.51999998092651 | 2.51999998092651 | 2.49000000953674 | 2.5 | 16200.0 |
| 2001-07-25 | DGT | ETF | 67.74 | 67.9 | 67.74 | 67.9 | 1000.0 |
| 2001-07-25 | EWA | ETF | 9.27 | 9.28 | 9.18 | 9.26 | 13600.0 |
| 2001-07-25 | EWC | ETF | 11.01 | 11.3 | 11.01 | 11.3 | 10600.0 |
| 2001-07-25 | EWD | ETF | 12.45 | 12.69 | 12.45 | 12.5 | 4700.0 |
| 2001-07-25 | EWG | ETF | 15.81 | 15.9 | 15.72 | 15.86 | 12100.0 |
| 2001-07-25 | EWH | ETF | 9.5 | 9.81 | 9.45 | 9.81 | 41800.0 |
| 2001-07-25 | EWI | ETF | 35.22 | 35.68 | 35.22 | 35.3 | 1600.0 |
| 2001-07-25 | EWJ | ETF | 37.76 | 37.92 | 37.32 | 37.92 | 72175.0 |
| 2001-07-25 | EWK | ETF | 11.7 | 11.7 | 11.69 | 11.69 | 1000.0 |
| 2001-07-25 | EWL | ETF | 12.85 | 12.9 | 12.85 | 12.87 | 3900.0 |
| 2001-07-25 | EWM | ETF | 18.2 | 18.44 | 18.2 | 18.24 | 1825.0 |
| 2001-07-25 | EWN | ETF | 18.25 | 18.44 | 18.25 | 18.31 | 4000.0 |
| 2001-07-25 | EWP | ETF | 20.1 | 20.4 | 20.1 | 20.21 | 2800.0 |
| 2001-07-25 | EWQ | ETF | 19.01 | 19.08 | 18.94 | 18.97 | 6100.0 |
| 2001-07-25 | EWS | ETF | 10.0 | 10.3 | 9.84 | 10.3 | 1948150.0 |
| 2001-07-25 | EWT | ETF | 16.92 | 16.92 | 16.7 | 16.7 | 2300.0 |
| 2001-07-25 | EWU | ETF | 29.26 | 29.82 | 29.26 | 29.82 | 14850.0 |
| 2001-07-25 | EWW | ETF | 15.5 | 15.59 | 15.41 | 15.59 | 5800.0 |
| 2001-07-25 | EWY | ETF | 12.2 | 12.78 | 12.2 | 12.78 | 1000.0 |
| 2001-07-25 | EWZ | ETF | 12.65 | 12.86 | 12.65 | 12.7 | 3100.0 |
| 2001-07-25 | EZU | ETF | 28.9 | 28.9 | 28.65 | 28.65 | 6800.0 |
| 2001-07-25 | FCTR | ETF | 17.86 | 18.1 | 17.86 | 18.09 | 28700.0 |
| 2001-07-25 | FMAR | ETF | 9.03 | 9.1 | 9.0 | 9.0 | 6700.0 |
| 2001-07-25 | GLDB | ETF | 7.56 | 7.85 | 7.5 | 7.8 | 86500.0 |
| 2001-07-25 | GSIG | ETF | 7.23 | 7.3 | 7.07 | 7.13 | 69900.0 |
| 2001-07-25 | IBB | ETF | 27.4667 | 28.2333 | 27.4667 | 28.2333 | 420900.0 |
| 2001-07-25 | ICF | ETF | 20.8625 | 20.91 | 20.84 | 20.91 | 15600.0 |
| 2001-07-25 | IDU | ETF | 35.35 | 36.59 | 35.3 | 36.5 | 6000.0 |
| 2001-07-25 | IEV | ETF | 29.995 | 30.05 | 29.75 | 29.99 | 22000.0 |
| 2001-07-25 | IGLD | ETF | 70.0 | 70.0 | 70.0 | 70.0 | 1.0 |
| 2001-07-25 | IGM | ETF | 8.665 | 8.8583 | 8.665 | 8.8583 | 27000.0 |
| 2001-07-25 | IGV | ETF | 9.376 | 9.376 | 9.376 | 9.376 | 25000.0 |
| 2001-07-25 | IJH | ETF | 9.9 | 9.987 | 9.835 | 9.987 | 196000.0 |
| 2001-07-25 | IJJ | ETF | 22.0375 | 22.23 | 21.9 | 22.23 | 57200.0 |
| 2001-07-25 | IJK | ETF | 13.7562 | 13.8775 | 13.7312 | 13.8775 | 41600.0 |
| 2001-07-25 | IJR | ETF | 18.3667 | 18.4417 | 18.2083 | 18.4167 | 509400.0 |
| 2001-07-25 | IJS | ETF | 20.6 | 20.7625 | 20.5025 | 20.7625 | 110000.0 |
| 2001-07-25 | IJT | ETF | 18.425 | 18.425 | 18.195 | 18.33 | 23600.0 |
| 2001-07-25 | IOO | ETF | 29.825 | 29.97 | 29.715 | 29.97 | 28200.0 |
| 2001-07-25 | IUSV | ETF | 24.2667 | 24.3733 | 24.2233 | 24.35 | 16200.0 |
> showing 50 of 98 rows — these rows as CSV