PREVIEW / etf_daily / 2001-10-22
file: by_date/etf_daily/2001/2001-10-22.parquet size: 9 KB rows: 105
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-10-22 | SPY | ETF | 107.3 | 109.57 | 107.21 | 109.47 | 17540600.0 |
| 2001-10-22 | QQQ | ETF | 33.44 | 34.5 | 33.22 | 34.45 | 74109400.0 |
| 2001-10-22 | IWM | ETF | 42.375 | 42.875 | 42.34 | 42.68 | 369600.0 |
| 2001-10-22 | DIA | ETF | 91.9 | 94.15 | 91.7 | 94.05 | 3788200.0 |
| 2001-10-22 | ARB | ETF | 28.15 | 28.7 | 27.98 | 28.05 | 136900.0 |
| 2001-10-22 | BBH | ETF | 40.0333 | 41.58 | 40.0333 | 41.47 | 2147400.0 |
| 2001-10-22 | BITS | ETF | 17.4 | 17.6 | 15.32 | 16.6 | 10250.0 |
| 2001-10-22 | BOSS | ETF | 20.0 | 20.0 | 20.0 | 20.0 | 900.0 |
| 2001-10-22 | CEF | ETF | 3.5 | 3.5 | 3.4 | 3.41 | 13400.0 |
| 2001-10-22 | CHB | ETF | 7.05 | 7.15 | 7.02 | 7.06 | 117200.0 |
| 2001-10-22 | CNXT | ETF | 10.0 | 10.74 | 9.85 | 10.53 | 3650500.0 |
| 2001-10-22 | EFA | ETF | 38.0 | 38.5333 | 38.0 | 38.5333 | 393000.0 |
| 2001-10-22 | EWA | ETF | 8.61 | 8.7 | 8.61 | 8.65 | 4200.0 |
| 2001-10-22 | EWC | ETF | 9.74 | 9.74 | 9.72 | 9.72 | 6700.0 |
| 2001-10-22 | EWG | ETF | 13.0 | 13.1 | 12.95 | 13.05 | 93000.0 |
| 2001-10-22 | EWH | ETF | 7.81 | 7.99 | 7.81 | 7.98 | 32600.0 |
| 2001-10-22 | EWI | ETF | 30.62 | 31.2 | 30.62 | 30.82 | 3550.0 |
| 2001-10-22 | EWJ | ETF | 34.36 | 34.6 | 34.28 | 34.56 | 93900.0 |
| 2001-10-22 | EWK | ETF | 10.49 | 10.49 | 10.31 | 10.31 | 700.0 |
| 2001-10-22 | EWL | ETF | 12.24 | 12.24 | 12.02 | 12.2 | 10100.0 |
| 2001-10-22 | EWM | ETF | 17.8 | 17.84 | 17.6 | 17.8 | 4200.0 |
| 2001-10-22 | EWN | ETF | 15.51 | 15.74 | 15.51 | 15.65 | 1900.0 |
| 2001-10-22 | EWO | ETF | 7.0 | 7.0 | 6.85 | 6.85 | 4100.0 |
| 2001-10-22 | EWP | ETF | 18.92 | 19.26 | 18.92 | 19.16 | 3900.0 |
| 2001-10-22 | EWQ | ETF | 17.35 | 17.69 | 17.35 | 17.69 | 6400.0 |
| 2001-10-22 | EWS | ETF | 8.72 | 8.92 | 8.72 | 8.78 | 3550.0 |
| 2001-10-22 | EWT | ETF | 15.02 | 15.52 | 15.02 | 15.52 | 52350.0 |
| 2001-10-22 | EWU | ETF | 28.12 | 28.38 | 28.02 | 28.38 | 18500.0 |
| 2001-10-22 | EWW | ETF | 13.21 | 13.45 | 13.15 | 13.15 | 24500.0 |
| 2001-10-22 | EWZ | ETF | 9.5 | 9.55 | 9.5 | 9.55 | 51400.0 |
| 2001-10-22 | EZU | ETF | 25.2 | 25.935 | 25.2 | 25.755 | 7600.0 |
| 2001-10-22 | FCTR | ETF | 17.5 | 17.8 | 16.8 | 17.8 | 94700.0 |
| 2001-10-22 | FMAR | ETF | 8.0 | 8.0 | 7.9 | 8.0 | 5000.0 |
| 2001-10-22 | GLDB | ETF | 7.49 | 7.6 | 7.36 | 7.4 | 42600.0 |
| 2001-10-22 | GSIG | ETF | 7.3 | 7.5 | 7.21 | 7.42 | 49200.0 |
| 2001-10-22 | IBB | ETF | 27.7 | 28.7167 | 27.7 | 28.7167 | 175200.0 |
| 2001-10-22 | ICF | ETF | 19.5 | 19.7375 | 19.5 | 19.725 | 23200.0 |
| 2001-10-22 | IDU | ETF | 33.5 | 33.55 | 33.465 | 33.5 | 12200.0 |
| 2001-10-22 | IEV | ETF | 28.0 | 28.0 | 27.34 | 27.825 | 26800.0 |
| 2001-10-22 | IGLD | ETF | 80.0 | 80.0 | 71.0 | 78.0 | 75.0 |
| 2001-10-22 | IGM | ETF | 7.2167 | 7.4333 | 7.2 | 7.4333 | 24000.0 |
| 2001-10-22 | IGN | ETF | 28.85 | 28.85 | 28.85 | 28.85 | 300.0 |
| 2001-10-22 | IGV | ETF | 7.48 | 7.5 | 7.47 | 7.49 | 20500.0 |
| 2001-10-22 | IJH | ETF | 8.96 | 9.115 | 8.96 | 9.115 | 260000.0 |
| 2001-10-22 | IJJ | ETF | 20.0875 | 20.4275 | 20.0875 | 20.4125 | 487600.0 |
| 2001-10-22 | IJK | ETF | 12.375 | 12.63 | 12.375 | 12.63 | 28000.0 |
| 2001-10-22 | IJR | ETF | 16.6667 | 16.8967 | 16.6533 | 16.8967 | 278400.0 |
| 2001-10-22 | IJS | ETF | 18.3625 | 18.6225 | 18.3625 | 18.555 | 51200.0 |
| 2001-10-22 | IJT | ETF | 16.8875 | 17.2525 | 16.8875 | 17.175 | 51600.0 |
| 2001-10-22 | IOO | ETF | 28.115 | 28.36 | 27.97 | 28.285 | 43600.0 |
> showing 50 of 105 rows — these rows as CSV