PREVIEW / etf_daily / 2002-09-19
file: by_date/etf_daily/2002/2002-09-19.parquet size: 9 KB rows: 124
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-09-19 | SPY | ETF | 85.99 | 86.8 | 84.7 | 84.7 | 48510500.0 |
| 2002-09-19 | QQQ | ETF | 21.7 | 22.13 | 21.55 | 21.58 | 86322300.0 |
| 2002-09-19 | IWM | ETF | 36.75 | 37.285 | 36.3 | 36.395 | 1405200.0 |
| 2002-09-19 | DIA | ETF | 80.49 | 81.49 | 79.5 | 79.64 | 12834900.0 |
| 2002-09-19 | TLT | ETF | 89.7 | 89.77 | 89.26 | 89.72 | 109900.0 |
| 2002-09-19 | AAA | ETF | 40.86 | 41.25 | 40.86 | 41.25 | 700.0 |
| 2002-09-19 | ARB | ETF | 31.7 | 31.79 | 31.11 | 31.23 | 49800.0 |
| 2002-09-19 | BBH | ETF | 26.9 | 27.0 | 25.6667 | 25.6767 | 3879900.0 |
| 2002-09-19 | BITS | ETF | 10.0 | 10.0 | 7.84 | 9.876 | 9475.0 |
| 2002-09-19 | CEF | ETF | 4.33 | 4.37 | 4.27 | 4.33 | 108600.0 |
| 2002-09-19 | CHB | ETF | 2.49 | 2.51 | 2.2 | 2.2 | 124200.0 |
| 2002-09-19 | CNXT | ETF | 1.2269 | 1.2367 | 1.0207 | 1.06 | 6124430.0 |
| 2002-09-19 | CSB | ETF | 6.67000007629395 | 6.67000007629395 | 6.63000011444092 | 6.65000009536743 | 8600.0 |
| 2002-09-19 | DGT | ETF | 48.35 | 48.35 | 47.07 | 47.07 | 1500.0 |
| 2002-09-19 | EFA | ETF | 32.4033 | 32.5 | 32.1833 | 32.25 | 1235400.0 |
| 2002-09-19 | ELV | ETF | 34.245 | 34.35 | 32.81 | 32.845 | 1567700.0 |
| 2002-09-19 | EPP | ETF | 17.3267 | 17.38 | 17.1667 | 17.2 | 46200.0 |
| 2002-09-19 | EWA | ETF | 9.3 | 9.3 | 9.18 | 9.21 | 104300.0 |
| 2002-09-19 | EWC | ETF | 8.94 | 8.94 | 8.89 | 8.89 | 4000.0 |
| 2002-09-19 | EWD | ETF | 8.94 | 8.94 | 8.76 | 8.76 | 1000.0 |
| 2002-09-19 | EWG | ETF | 10.0 | 10.0 | 9.75 | 9.75 | 40700.0 |
| 2002-09-19 | EWH | ETF | 7.34 | 7.44 | 7.28 | 7.28 | 57100.0 |
| 2002-09-19 | EWI | ETF | 27.3 | 27.5 | 27.22 | 27.24 | 4250.0 |
| 2002-09-19 | EWJ | ETF | 30.16 | 30.48 | 30.12 | 30.12 | 195200.0 |
| 2002-09-19 | EWK | ETF | 9.2 | 9.25 | 9.19 | 9.19 | 7100.0 |
| 2002-09-19 | EWL | ETF | 10.45 | 10.5 | 10.4 | 10.42 | 6600.0 |
| 2002-09-19 | EWM | ETF | 21.8 | 21.8 | 21.36 | 21.36 | 5700.0 |
| 2002-09-19 | EWN | ETF | 12.46 | 12.46 | 12.45 | 12.45 | 700.0 |
| 2002-09-19 | EWP | ETF | 16.2 | 16.2 | 16.2 | 16.2 | 1200.0 |
| 2002-09-19 | EWQ | ETF | 13.79 | 13.84 | 13.55 | 13.55 | 16600.0 |
| 2002-09-19 | EWS | ETF | 9.22 | 9.26 | 9.16 | 9.16 | 12300.0 |
| 2002-09-19 | EWT | ETF | 16.3 | 16.3 | 15.8 | 15.8 | 9300.0 |
| 2002-09-19 | EWU | ETF | 23.0 | 23.28 | 23.0 | 23.02 | 50900.0 |
| 2002-09-19 | EWW | ETF | 12.9 | 12.9 | 12.1 | 12.2 | 172400.0 |
| 2002-09-19 | EWY | ETF | 20.0 | 20.25 | 20.0 | 20.0 | 52600.0 |
| 2002-09-19 | EWZ | ETF | 7.2 | 7.2 | 6.83 | 6.85 | 365900.0 |
| 2002-09-19 | EZU | ETF | 20.15 | 20.15 | 19.9 | 19.99 | 60400.0 |
| 2002-09-19 | FCTR | ETF | 16.66 | 16.66 | 16.23 | 16.23 | 23300.0 |
| 2002-09-19 | FMAR | ETF | 10.5 | 10.5 | 10.45 | 10.45 | 7800.0 |
| 2002-09-19 | GLDB | ETF | 9.87 | 9.949 | 9.76 | 9.76 | 36900.0 |
| 2002-09-19 | GSIG | ETF | 5.35 | 5.44 | 5.12 | 5.13 | 56100.0 |
| 2002-09-19 | IBB | ETF | 15.85 | 16.0 | 15.2667 | 15.2667 | 3201300.0 |
| 2002-09-19 | ICF | ETF | 21.1625 | 21.2475 | 21.04 | 21.04 | 38000.0 |
| 2002-09-19 | IDU | ETF | 23.85 | 24.185 | 23.62 | 23.64 | 194800.0 |
| 2002-09-19 | IEF | ETF | 86.42 | 86.47 | 86.12 | 86.43 | 61100.0 |
| 2002-09-19 | IEV | ETF | 22.375 | 22.47 | 22.105 | 22.105 | 47400.0 |
| 2002-09-19 | IGE | ETF | 12.9917 | 13.0367 | 12.9683 | 13.0 | 8400.0 |
| 2002-09-19 | IGLD | ETF | 101.0 | 101.0 | 101.0 | 101.0 | 1.0 |
| 2002-09-19 | IGM | ETF | 4.475 | 4.475 | 4.4183 | 4.4217 | 45000.0 |
| 2002-09-19 | IGN | ETF | 10.55 | 10.67 | 10.55 | 10.65 | 1700.0 |
> showing 50 of 124 rows — these rows as CSV