PREVIEW / etf_daily / 2002-01-22
file: by_date/etf_daily/2002/2002-01-22.parquet size: 9 KB rows: 114
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-01-22 | SPY | ETF | 113.75 | 113.93 | 112.02 | 112.37 | 11689300.0 |
| 2002-01-22 | QQQ | ETF | 39.0 | 39.02 | 37.33 | 37.4 | 81773800.0 |
| 2002-01-22 | IWM | ETF | 47.375 | 47.545 | 46.555 | 46.65 | 1331400.0 |
| 2002-01-22 | DIA | ETF | 98.34 | 98.55 | 97.0 | 97.28 | 1951100.0 |
| 2002-01-22 | ARB | ETF | 32.0 | 32.09 | 31.43 | 31.43 | 22900.0 |
| 2002-01-22 | BBH | ETF | 40.8 | 41.3267 | 40.1333 | 41.0 | 4740900.0 |
| 2002-01-22 | BITS | ETF | 19.8 | 20.88 | 19.6 | 19.6 | 5000.0 |
| 2002-01-22 | CEF | ETF | 3.5 | 3.54 | 3.47 | 3.5 | 19700.0 |
| 2002-01-22 | CHB | ETF | 11.35 | 11.38 | 10.99 | 11.15 | 161000.0 |
| 2002-01-22 | CNXT | ETF | 13.185 | 13.285 | 11.675 | 11.695 | 6419650.0 |
| 2002-01-22 | CSB | ETF | 4.75 | 4.75 | 4.75 | 4.75 | 1000.0 |
| 2002-01-22 | DGT | ETF | 64.9 | 64.9 | 64.9 | 64.9 | 2900.0 |
| 2002-01-22 | EFA | ETF | 38.5433 | 38.5433 | 37.8567 | 38.05 | 561900.0 |
| 2002-01-22 | ELV | ETF | 25.365 | 25.94 | 25.025 | 25.875 | 806500.0 |
| 2002-01-22 | EPP | ETF | 18.4 | 18.41 | 18.3433 | 18.36 | 3300.0 |
| 2002-01-22 | EWA | ETF | 9.51 | 9.6 | 9.5 | 9.59 | 131100.0 |
| 2002-01-22 | EWC | ETF | 10.5 | 10.7 | 10.5 | 10.7 | 5000.0 |
| 2002-01-22 | EWD | ETF | 12.95 | 12.95 | 12.8 | 12.82 | 900.0 |
| 2002-01-22 | EWG | ETF | 14.75 | 14.81 | 14.56 | 14.58 | 29500.0 |
| 2002-01-22 | EWH | ETF | 9.05 | 9.22 | 9.05 | 9.14 | 246300.0 |
| 2002-01-22 | EWI | ETF | 31.7 | 31.96 | 31.7 | 31.7 | 6600.0 |
| 2002-01-22 | EWJ | ETF | 29.36 | 29.36 | 29.04 | 29.28 | 146125.0 |
| 2002-01-22 | EWK | ETF | 10.95 | 10.95 | 10.85 | 10.85 | 400.0 |
| 2002-01-22 | EWL | ETF | 12.49 | 12.49 | 12.25 | 12.27 | 10700.0 |
| 2002-01-22 | EWM | ETF | 20.4 | 20.52 | 20.32 | 20.52 | 21450.0 |
| 2002-01-22 | EWN | ETF | 16.4 | 16.65 | 16.4 | 16.55 | 2700.0 |
| 2002-01-22 | EWO | ETF | 7.47 | 7.47 | 7.38 | 7.46 | 5200.0 |
| 2002-01-22 | EWP | ETF | 20.0 | 20.0 | 19.75 | 19.94 | 3000.0 |
| 2002-01-22 | EWQ | ETF | 18.05 | 18.19 | 17.9 | 17.9 | 14700.0 |
| 2002-01-22 | EWS | ETF | 10.46 | 10.66 | 10.36 | 10.38 | 340500.0 |
| 2002-01-22 | EWT | ETF | 22.3 | 22.3 | 21.8 | 22.0 | 40050.0 |
| 2002-01-22 | EWU | ETF | 28.46 | 28.66 | 28.18 | 28.2 | 8000.0 |
| 2002-01-22 | EWW | ETF | 15.7 | 15.9 | 15.55 | 15.55 | 7400.0 |
| 2002-01-22 | EWY | ETF | 18.45 | 18.49 | 18.25 | 18.29 | 31100.0 |
| 2002-01-22 | EWZ | ETF | 12.09 | 12.09 | 12.01 | 12.01 | 500.0 |
| 2002-01-22 | EZU | ETF | 26.925 | 26.93 | 26.45 | 26.5 | 203000.0 |
| 2002-01-22 | FCTR | ETF | 17.25 | 17.38 | 17.25 | 17.25 | 16700.0 |
| 2002-01-22 | GLDB | ETF | 7.01 | 7.11 | 6.97 | 6.97 | 96000.0 |
| 2002-01-22 | GSIG | ETF | 9.82 | 9.95 | 9.58 | 9.64 | 22800.0 |
| 2002-01-22 | IBB | ETF | 26.6667 | 26.9 | 26.2667 | 26.9 | 123600.0 |
| 2002-01-22 | ICF | ETF | 21.025 | 21.065 | 20.9525 | 21.0625 | 52000.0 |
| 2002-01-22 | IDU | ETF | 31.06 | 31.215 | 30.765 | 30.925 | 128600.0 |
| 2002-01-22 | IEV | ETF | 28.65 | 28.735 | 28.275 | 28.28 | 174400.0 |
| 2002-01-22 | IGE | ETF | 14.8667 | 14.8667 | 14.7583 | 14.7617 | 10200.0 |
| 2002-01-22 | IGLD | ETF | 121.0 | 144.0 | 120.0 | 134.0 | 3489.0 |
| 2002-01-22 | IGM | ETF | 8.5333 | 8.5333 | 8.1083 | 8.1233 | 152400.0 |
| 2002-01-22 | IGN | ETF | 30.4 | 30.4 | 29.03 | 29.09 | 402400.0 |
| 2002-01-22 | IGV | ETF | 9.38 | 9.382 | 8.948 | 8.962 | 2721500.0 |
| 2002-01-22 | IJH | ETF | 9.999 | 10.002 | 9.85 | 9.87 | 282000.0 |
| 2002-01-22 | IJJ | ETF | 22.25 | 22.25 | 21.9475 | 22.0075 | 173600.0 |
> showing 50 of 114 rows — these rows as CSV