PREVIEW / etf_daily / 2001-08-22
file: by_date/etf_daily/2001/2001-08-22.parquet size: 9 KB rows: 103
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-22 | SPY | ETF | 116.75 | 117.43 | 115.78 | 117.02 | 11752300.0 |
| 2001-08-22 | QQQ | ETF | 37.45 | 37.84 | 36.54 | 37.69 | 65235400.0 |
| 2001-08-22 | IWM | ETF | 47.45 | 47.675 | 46.89 | 47.675 | 1277800.0 |
| 2001-08-22 | DIA | ETF | 102.2 | 103.23 | 101.45 | 102.88 | 5700500.0 |
| 2001-08-22 | BBH | ETF | 38.7 | 39.7667 | 38.3033 | 39.6833 | 4770900.0 |
| 2001-08-22 | BITS | ETF | 15.6 | 17.12 | 15.6 | 16.0 | 25000.0 |
| 2001-08-22 | CEF | ETF | 3.24 | 3.24 | 3.21 | 3.21 | 7500.0 |
| 2001-08-22 | CHB | ETF | 9.43 | 9.5 | 9.05 | 9.3 | 133300.0 |
| 2001-08-22 | CNXT | ETF | 9.99 | 10.454 | 9.76 | 10.31 | 2707770.0 |
| 2001-08-22 | DGT | ETF | 66.95 | 66.95 | 66.46 | 66.59 | 4200.0 |
| 2001-08-22 | EWA | ETF | 9.74 | 9.83 | 9.66 | 9.8 | 31800.0 |
| 2001-08-22 | EWC | ETF | 11.1 | 11.1 | 10.87 | 10.95 | 25800.0 |
| 2001-08-22 | EWD | ETF | 13.49 | 13.49 | 13.49 | 13.49 | 400.0 |
| 2001-08-22 | EWG | ETF | 15.85 | 15.85 | 15.6 | 15.7 | 5600.0 |
| 2001-08-22 | EWH | ETF | 9.27 | 9.3 | 9.09 | 9.2 | 11600.0 |
| 2001-08-22 | EWI | ETF | 37.2 | 37.2 | 37.18 | 37.18 | 5200.0 |
| 2001-08-22 | EWJ | ETF | 38.24 | 38.44 | 38.08 | 38.16 | 41850.0 |
| 2001-08-22 | EWL | ETF | 13.3 | 13.3 | 13.25 | 13.25 | 800.0 |
| 2001-08-22 | EWM | ETF | 19.0 | 19.2 | 18.8 | 19.0 | 24125.0 |
| 2001-08-22 | EWN | ETF | 19.37 | 19.37 | 19.26 | 19.26 | 400.0 |
| 2001-08-22 | EWO | ETF | 8.4 | 8.4 | 8.4 | 8.4 | 3100.0 |
| 2001-08-22 | EWP | ETF | 21.7 | 21.7 | 21.7 | 21.7 | 300.0 |
| 2001-08-22 | EWQ | ETF | 20.4 | 20.4 | 20.25 | 20.25 | 10800.0 |
| 2001-08-22 | EWS | ETF | 10.66 | 10.72 | 10.56 | 10.6 | 7800.0 |
| 2001-08-22 | EWT | ETF | 18.54 | 18.54 | 18.12 | 18.2 | 1400.0 |
| 2001-08-22 | EWU | ETF | 31.32 | 31.8 | 31.0 | 31.0 | 26700.0 |
| 2001-08-22 | EWW | ETF | 15.52 | 15.64 | 15.43 | 15.64 | 6900.0 |
| 2001-08-22 | EWY | ETF | 13.73 | 14.04 | 13.73 | 13.94 | 16300.0 |
| 2001-08-22 | EWZ | ETF | 12.32 | 12.34 | 12.01 | 12.23 | 3900.0 |
| 2001-08-22 | EZU | ETF | 29.95 | 29.97 | 29.34 | 29.34 | 25400.0 |
| 2001-08-22 | FCTR | ETF | 18.29 | 18.47 | 18.13 | 18.45 | 16900.0 |
| 2001-08-22 | FMAR | ETF | 9.25 | 9.85 | 9.1 | 9.1 | 24900.0 |
| 2001-08-22 | GLDB | ETF | 7.6 | 7.88 | 7.6 | 7.71 | 64000.0 |
| 2001-08-22 | GRNB | ETF | 15.7065 | 15.7065 | 15.7065 | 15.7065 | 202.0 |
| 2001-08-22 | GSIG | ETF | 8.06 | 8.24 | 7.97 | 8.05 | 84600.0 |
| 2001-08-22 | IBB | ETF | 27.3333 | 28.1133 | 27.05 | 28.1133 | 216300.0 |
| 2001-08-22 | ICF | ETF | 22.4875 | 22.51 | 22.37 | 22.4125 | 137600.0 |
| 2001-08-22 | IDU | ETF | 36.5 | 36.905 | 36.495 | 36.905 | 55000.0 |
| 2001-08-22 | IEV | ETF | 31.2 | 31.325 | 30.715 | 30.715 | 19800.0 |
| 2001-08-22 | IGLD | ETF | 64.0 | 68.0 | 58.0 | 68.0 | 137.0 |
| 2001-08-22 | IGM | ETF | 8.0167 | 8.0917 | 8.0167 | 8.0667 | 16200.0 |
| 2001-08-22 | IGV | ETF | 8.02 | 8.02 | 8.018 | 8.02 | 3500.0 |
| 2001-08-22 | IJH | ETF | 9.918 | 9.979 | 9.857 | 9.964 | 113000.0 |
| 2001-08-22 | IJJ | ETF | 22.6375 | 22.7225 | 22.53 | 22.6675 | 27600.0 |
| 2001-08-22 | IJK | ETF | 13.475 | 13.5538 | 13.4375 | 13.5538 | 9600.0 |
| 2001-08-22 | IJR | ETF | 18.7417 | 18.7967 | 18.5433 | 18.7967 | 675600.0 |
| 2001-08-22 | IJS | ETF | 21.175 | 21.21 | 20.9375 | 21.21 | 133200.0 |
| 2001-08-22 | IJT | ETF | 18.625 | 18.655 | 18.415 | 18.655 | 18400.0 |
| 2001-08-22 | IOO | ETF | 29.615 | 29.735 | 29.46 | 29.59 | 67800.0 |
| 2001-08-22 | IUSG | ETF | 20.085 | 20.245 | 20.085 | 20.245 | 4200.0 |
> showing 50 of 103 rows — these rows as CSV