PREVIEW / etf_daily / 2001-08-01
file: by_date/etf_daily/2001/2001-08-01.parquet size: 9 KB rows: 101
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-08-01 | SPY | ETF | 121.97 | 122.7 | 121.55 | 122.11 | 11940800.0 |
| 2001-08-01 | QQQ | ETF | 42.637 | 43.5 | 42.41 | 43.1 | 53864800.0 |
| 2001-08-01 | IWM | ETF | 48.525 | 48.9 | 48.225 | 48.85 | 439000.0 |
| 2001-08-01 | DIA | ETF | 105.78 | 106.06 | 104.87 | 105.29 | 2099400.0 |
| 2001-08-01 | BBH | ETF | 40.0667 | 40.4633 | 39.72 | 40.0633 | 1576500.0 |
| 2001-08-01 | BITS | ETF | 18.76 | 19.12 | 14.72 | 16.0 | 13575.0 |
| 2001-08-01 | CEF | ETF | 3.07 | 3.09 | 3.07 | 3.09 | 6100.0 |
| 2001-08-01 | CHB | ETF | 10.85 | 11.25 | 10.82 | 11.15 | 117700.0 |
| 2001-08-01 | CNXT | ETF | 9.8 | 10.49 | 9.76 | 10.36 | 4225840.0 |
| 2001-08-01 | CSB | ETF | 2.40000009536743 | 2.40000009536743 | 2.40000009536743 | 2.40000009536743 | 10000.0 |
| 2001-08-01 | DGT | ETF | 69.87 | 69.87 | 69.8 | 69.8 | 400.0 |
| 2001-08-01 | EWA | ETF | 9.5 | 9.68 | 9.5 | 9.68 | 15600.0 |
| 2001-08-01 | EWC | ETF | 11.28 | 11.54 | 11.28 | 11.42 | 27200.0 |
| 2001-08-01 | EWD | ETF | 13.9 | 13.97 | 13.76 | 13.97 | 15400.0 |
| 2001-08-01 | EWG | ETF | 16.68 | 16.69 | 16.56 | 16.59 | 19000.0 |
| 2001-08-01 | EWH | ETF | 10.0 | 10.0 | 9.87 | 9.93 | 24300.0 |
| 2001-08-01 | EWI | ETF | 37.06 | 37.1 | 36.7 | 36.7 | 2900.0 |
| 2001-08-01 | EWJ | ETF | 38.16 | 38.36 | 38.12 | 38.28 | 53875.0 |
| 2001-08-01 | EWK | ETF | 11.75 | 11.94 | 11.75 | 11.94 | 32800.0 |
| 2001-08-01 | EWL | ETF | 13.45 | 13.45 | 13.31 | 13.44 | 7000.0 |
| 2001-08-01 | EWM | ETF | 19.2 | 19.4 | 19.2 | 19.4 | 10875.0 |
| 2001-08-01 | EWN | ETF | 19.5 | 19.5 | 19.26 | 19.49 | 5500.0 |
| 2001-08-01 | EWP | ETF | 21.45 | 21.5 | 21.3 | 21.45 | 9800.0 |
| 2001-08-01 | EWQ | ETF | 20.38 | 20.44 | 20.25 | 20.44 | 19000.0 |
| 2001-08-01 | EWS | ETF | 10.62 | 10.72 | 10.6 | 10.72 | 12350.0 |
| 2001-08-01 | EWT | ETF | 17.88 | 18.4 | 17.88 | 18.02 | 73750.0 |
| 2001-08-01 | EWU | ETF | 31.7 | 31.7 | 31.3 | 31.58 | 16350.0 |
| 2001-08-01 | EWW | ETF | 15.7 | 15.95 | 15.7 | 15.85 | 21300.0 |
| 2001-08-01 | EWY | ETF | 13.64 | 13.83 | 13.6 | 13.83 | 16300.0 |
| 2001-08-01 | EWZ | ETF | 13.0 | 13.0 | 12.7 | 12.9 | 234700.0 |
| 2001-08-01 | EZU | ETF | 30.24 | 30.37 | 30.15 | 30.34 | 6600.0 |
| 2001-08-01 | FCTR | ETF | 18.07 | 18.4754 | 17.51 | 17.53 | 15900.0 |
| 2001-08-01 | FMAR | ETF | 9.334 | 9.988 | 9.266 | 9.51 | 17840.0 |
| 2001-08-01 | GLDB | ETF | 7.7 | 8.05 | 7.6 | 7.95 | 236400.0 |
| 2001-08-01 | GRNB | ETF | 24.5414 | 24.5414 | 24.5414 | 24.5414 | 101.0 |
| 2001-08-01 | GSIG | ETF | 7.6 | 8.78 | 7.6 | 8.42 | 144000.0 |
| 2001-08-01 | IBB | ETF | 29.0833 | 29.2 | 28.77 | 29.0 | 60300.0 |
| 2001-08-01 | ICF | ETF | 20.8625 | 20.9575 | 20.8625 | 20.9575 | 2800.0 |
| 2001-08-01 | IDU | ETF | 37.325 | 37.72 | 37.325 | 37.575 | 3000.0 |
| 2001-08-01 | IEV | ETF | 31.25 | 31.52 | 31.25 | 31.47 | 24200.0 |
| 2001-08-01 | IGLD | ETF | 66.0 | 66.0 | 65.0 | 65.0 | 14.0 |
| 2001-08-01 | IGM | ETF | 9.2667 | 9.415 | 9.2667 | 9.35 | 450000.0 |
| 2001-08-01 | IGV | ETF | 9.93 | 9.99 | 9.78 | 9.78 | 103500.0 |
| 2001-08-01 | IJH | ETF | 10.236 | 10.322 | 10.236 | 10.263 | 105000.0 |
| 2001-08-01 | IJJ | ETF | 22.875 | 23.0575 | 22.8625 | 22.9875 | 144800.0 |
| 2001-08-01 | IJK | ETF | 14.2062 | 14.3175 | 14.2062 | 14.25 | 16000.0 |
| 2001-08-01 | IJR | ETF | 18.8833 | 19.0367 | 18.8283 | 18.955 | 526800.0 |
| 2001-08-01 | IJS | ETF | 21.1875 | 21.3475 | 21.1875 | 21.3325 | 94400.0 |
| 2001-08-01 | IJT | ETF | 19.005 | 19.0975 | 18.9375 | 18.9625 | 68800.0 |
| 2001-08-01 | IOO | ETF | 30.79 | 30.855 | 30.74 | 30.74 | 20200.0 |
> showing 50 of 101 rows — these rows as CSV