PREVIEW / etf_daily / 2001-04-27
file: by_date/etf_daily/2001/2001-04-27.parquet size: 8 KB rows: 94
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-04-27 | SPY | ETF | 124.92 | 125.84 | 124.2 | 125.78 | 7938700.0 |
| 2001-04-27 | QQQ | ETF | 45.15 | 45.47 | 44.241 | 45.15 | 56469800.0 |
| 2001-04-27 | IWM | ETF | 48.125 | 48.45 | 47.95 | 48.45 | 1658400.0 |
| 2001-04-27 | DIA | ETF | 107.65 | 108.29 | 107.1 | 108.23 | 3045100.0 |
| 2001-04-27 | BBH | ETF | 40.0833 | 41.16 | 40.01 | 41.0 | 2326500.0 |
| 2001-04-27 | BITS | ETF | 7.4 | 7.4 | 7.08 | 7.4 | 900.0 |
| 2001-04-27 | CEF | ETF | 3.09 | 3.15 | 3.09 | 3.11 | 16300.0 |
| 2001-04-27 | CHB | ETF | 7.52 | 8.3 | 7.52 | 8.1 | 260400.0 |
| 2001-04-27 | CNXT | ETF | 9.685 | 9.785 | 9.255 | 9.675 | 1584410.0 |
| 2001-04-27 | EWA | ETF | 9.32 | 9.32 | 9.25 | 9.25 | 10600.0 |
| 2001-04-27 | EWC | ETF | 11.9 | 11.9 | 11.75 | 11.75 | 23200.0 |
| 2001-04-27 | EWD | ETF | 14.9 | 14.95 | 14.9 | 14.91 | 4200.0 |
| 2001-04-27 | EWG | ETF | 17.66 | 17.7 | 17.55 | 17.68 | 12900.0 |
| 2001-04-27 | EWH | ETF | 10.71 | 10.8 | 10.7 | 10.73 | 101600.0 |
| 2001-04-27 | EWI | ETF | 40.46 | 40.5 | 40.34 | 40.5 | 600.0 |
| 2001-04-27 | EWJ | ETF | 44.28 | 44.36 | 44.04 | 44.36 | 121575.0 |
| 2001-04-27 | EWL | ETF | 14.35 | 14.35 | 14.13 | 14.17 | 7400.0 |
| 2001-04-27 | EWM | ETF | 16.6 | 16.64 | 16.44 | 16.64 | 26475.0 |
| 2001-04-27 | EWN | ETF | 20.8 | 21.05 | 20.75 | 21.05 | 2900.0 |
| 2001-04-27 | EWO | ETF | 8.3 | 8.3 | 8.3 | 8.3 | 2100.0 |
| 2001-04-27 | EWP | ETF | 24.25 | 24.25 | 23.87 | 23.87 | 17300.0 |
| 2001-04-27 | EWQ | ETF | 22.28 | 22.28 | 22.1 | 22.1 | 6800.0 |
| 2001-04-27 | EWS | ETF | 10.88 | 11.0 | 10.78 | 11.0 | 2750.0 |
| 2001-04-27 | EWT | ETF | 22.3 | 22.48 | 22.3 | 22.48 | 100.0 |
| 2001-04-27 | EWU | ETF | 33.5 | 33.6 | 33.18 | 33.5 | 30100.0 |
| 2001-04-27 | EWW | ETF | 15.35 | 15.35 | 15.0 | 15.19 | 111400.0 |
| 2001-04-27 | EWY | ETF | 13.37 | 13.38 | 13.16 | 13.16 | 11700.0 |
| 2001-04-27 | EWZ | ETF | 15.2 | 15.28 | 15.19 | 15.2 | 3200.0 |
| 2001-04-27 | EZU | ETF | 33.55 | 33.55 | 32.975 | 33.205 | 14800.0 |
| 2001-04-27 | FCTR | ETF | 16.5 | 16.65 | 16.4 | 16.65 | 93600.0 |
| 2001-04-27 | FMAR | ETF | 7.35 | 7.6 | 7.1 | 7.38 | 6400.0 |
| 2001-04-27 | GLDB | ETF | 7.01 | 7.04 | 7.01 | 7.04 | 61700.0 |
| 2001-04-27 | GSIG | ETF | 8.51 | 8.6 | 8.15 | 8.18 | 232500.0 |
| 2001-04-27 | IBB | ETF | 28.7 | 29.3167 | 28.7 | 29.1333 | 38100.0 |
| 2001-04-27 | ICF | ETF | 19.9125 | 19.9125 | 19.9125 | 19.9125 | 2800.0 |
| 2001-04-27 | IDU | ETF | 43.075 | 43.075 | 42.635 | 42.7 | 96000.0 |
| 2001-04-27 | IEV | ETF | 34.1 | 34.175 | 34.0 | 34.04 | 61200.0 |
| 2001-04-27 | IGLD | ETF | 83.0 | 83.0 | 83.0 | 83.0 | 28.0 |
| 2001-04-27 | IGM | ETF | 10.0 | 10.0083 | 9.925 | 10.0083 | 184800.0 |
| 2001-04-27 | IJH | ETF | 10.065 | 10.131 | 10.04 | 10.131 | 570000.0 |
| 2001-04-27 | IJJ | ETF | 22.17 | 22.3075 | 22.135 | 22.3025 | 97200.0 |
| 2001-04-27 | IJK | ETF | 14.1675 | 14.215 | 14.1488 | 14.215 | 60800.0 |
| 2001-04-27 | IJR | ETF | 18.08 | 18.2217 | 18.0333 | 18.2217 | 327000.0 |
| 2001-04-27 | IJS | ETF | 20.075 | 20.1875 | 19.9875 | 20.1875 | 134000.0 |
| 2001-04-27 | IJT | ETF | 18.4875 | 18.4975 | 18.38 | 18.425 | 152000.0 |
| 2001-04-27 | IOO | ETF | 33.175 | 33.175 | 32.95 | 32.95 | 97800.0 |
| 2001-04-27 | IUSG | ETF | 22.595 | 22.7 | 22.505 | 22.7 | 4000.0 |
| 2001-04-27 | IUSV | ETF | 24.9767 | 25.13 | 24.9667 | 25.13 | 11100.0 |
| 2001-04-27 | IVE | ETF | 63.36 | 63.75 | 63.26 | 63.75 | 31400.0 |
| 2001-04-27 | IVV | ETF | 124.85 | 125.73 | 124.42 | 125.73 | 852000.0 |
> showing 50 of 94 rows — these rows as CSV