PREVIEW / etf_daily / 2002-08-19
file: by_date/etf_daily/2002/2002-08-19.parquet size: 9 KB rows: 123
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-08-19 | SPY | ETF | 93.46 | 95.75 | 93.1 | 95.4 | 33669900.0 |
| 2002-08-19 | QQQ | ETF | 24.77 | 25.59 | 24.68 | 25.3 | 76035900.0 |
| 2002-08-19 | IWM | ETF | 39.705 | 40.14 | 39.535 | 40.025 | 3215600.0 |
| 2002-08-19 | DIA | ETF | 87.53 | 90.13 | 87.5 | 89.92 | 9593900.0 |
| 2002-08-19 | TLT | ETF | 85.05 | 85.34 | 84.71 | 85.32 | 47300.0 |
| 2002-08-19 | ARB | ETF | 33.4 | 34.1 | 33.4 | 33.81 | 65500.0 |
| 2002-08-19 | BBH | ETF | 28.9667 | 29.0333 | 28.4167 | 28.95 | 5518800.0 |
| 2002-08-19 | BITS | ETF | 8.204 | 8.76 | 8.204 | 8.4 | 625.0 |
| 2002-08-19 | CEF | ETF | 4.1 | 4.11 | 4.01 | 4.05 | 87500.0 |
| 2002-08-19 | CHB | ETF | 2.92 | 3.14 | 2.92 | 2.92 | 186700.0 |
| 2002-08-19 | CNXT | ETF | 1.675 | 1.7152 | 1.6048 | 1.645 | 4011900.0 |
| 2002-08-19 | CSB | ETF | 5.44999980926514 | 5.80000019073486 | 5.44999980926514 | 5.80000019073486 | 16000.0 |
| 2002-08-19 | DGT | ETF | 54.0 | 54.7 | 54.0 | 54.0 | 1200.0 |
| 2002-08-19 | EFA | ETF | 35.95 | 36.7333 | 35.9033 | 36.7167 | 710100.0 |
| 2002-08-19 | ELV | ETF | 29.5 | 31.225 | 29.5 | 30.995 | 1960500.0 |
| 2002-08-19 | EPP | ETF | 17.73 | 17.8833 | 17.73 | 17.8767 | 9000.0 |
| 2002-08-19 | EWA | ETF | 9.33 | 9.45 | 9.3 | 9.45 | 9700.0 |
| 2002-08-19 | EWC | ETF | 9.64 | 9.65 | 9.6 | 9.64 | 8500.0 |
| 2002-08-19 | EWD | ETF | 9.21 | 9.21 | 9.21 | 9.21 | 2600.0 |
| 2002-08-19 | EWG | ETF | 11.9 | 12.53 | 11.9 | 12.53 | 18700.0 |
| 2002-08-19 | EWH | ETF | 7.92 | 8.23 | 7.92 | 8.23 | 30000.0 |
| 2002-08-19 | EWI | ETF | 30.42 | 30.9 | 30.42 | 30.9 | 2700.0 |
| 2002-08-19 | EWJ | ETF | 32.0 | 32.0 | 31.2 | 31.6 | 134250.0 |
| 2002-08-19 | EWK | ETF | 10.45 | 10.5 | 10.45 | 10.5 | 5500.0 |
| 2002-08-19 | EWL | ETF | 12.01 | 12.25 | 12.01 | 12.21 | 3100.0 |
| 2002-08-19 | EWM | ETF | 23.68 | 23.84 | 23.4 | 23.84 | 15775.0 |
| 2002-08-19 | EWN | ETF | 14.66 | 15.19 | 14.66 | 15.19 | 4900.0 |
| 2002-08-19 | EWO | ETF | 8.24 | 8.24 | 7.99 | 8.15 | 15800.0 |
| 2002-08-19 | EWQ | ETF | 15.7 | 16.0 | 15.7 | 15.85 | 5400.0 |
| 2002-08-19 | EWS | ETF | 10.48 | 10.48 | 10.3 | 10.34 | 9000.0 |
| 2002-08-19 | EWT | ETF | 18.62 | 18.72 | 18.62 | 18.68 | 23300.0 |
| 2002-08-19 | EWU | ETF | 26.6 | 26.9 | 26.36 | 26.9 | 30000.0 |
| 2002-08-19 | EWW | ETF | 13.89 | 14.19 | 13.89 | 13.9 | 144700.0 |
| 2002-08-19 | EWY | ETF | 20.9 | 21.05 | 20.71 | 21.05 | 18500.0 |
| 2002-08-19 | EWZ | ETF | 7.58 | 7.65 | 7.25 | 7.48 | 338300.0 |
| 2002-08-19 | EZU | ETF | 23.11 | 23.915 | 23.11 | 23.915 | 37800.0 |
| 2002-08-19 | FCTR | ETF | 17.02 | 17.28 | 16.45 | 16.45 | 22600.0 |
| 2002-08-19 | FMAR | ETF | 10.89 | 10.89 | 10.48 | 10.6 | 6000.0 |
| 2002-08-19 | GLDB | ETF | 10.35 | 10.888 | 10.0 | 10.78 | 148000.0 |
| 2002-08-19 | GSIG | ETF | 6.7 | 6.91 | 6.62 | 6.68 | 584100.0 |
| 2002-08-19 | IBB | ETF | 17.4833 | 17.4833 | 17.0867 | 17.1 | 2675400.0 |
| 2002-08-19 | ICF | ETF | 21.5125 | 21.5125 | 21.375 | 21.4975 | 49200.0 |
| 2002-08-19 | IDU | ETF | 25.85 | 26.325 | 25.85 | 26.175 | 91000.0 |
| 2002-08-19 | IEF | ETF | 83.51 | 83.51 | 83.13 | 83.46 | 41600.0 |
| 2002-08-19 | IEV | ETF | 25.75 | 26.37 | 25.745 | 26.295 | 77400.0 |
| 2002-08-19 | IGE | ETF | 14.225 | 14.225 | 14.225 | 14.225 | 6600.0 |
| 2002-08-19 | IGLD | ETF | 104.0 | 104.0 | 102.0 | 103.0 | 112.0 |
| 2002-08-19 | IGM | ETF | 5.3 | 5.5167 | 5.3 | 5.4833 | 1704600.0 |
| 2002-08-19 | IGN | ETF | 13.2 | 13.68 | 13.2 | 13.62 | 7500.0 |
| 2002-08-19 | IGV | ETF | 4.88 | 5.072 | 4.88 | 5.028 | 560000.0 |
> showing 50 of 123 rows — these rows as CSV