PREVIEW / etf_daily / 2001-03-22
file: by_date/etf_daily/2001/2001-03-22.parquet size: 8 KB rows: 97
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-03-22 | SPY | ETF | 112.02 | 112.6 | 108.04 | 111.12 | 28624800.0 |
| 2001-03-22 | QQQ | ETF | 40.6 | 42.8 | 39.49 | 42.8 | 130210700.0 |
| 2001-03-22 | IWM | ETF | 43.125 | 43.375 | 41.575 | 43.0 | 1193000.0 |
| 2001-03-22 | DIA | ETF | 94.5 | 95.04 | 91.0 | 93.45 | 12445300.0 |
| 2001-03-22 | BBH | ETF | 34.0 | 35.5 | 30.8367 | 35.1667 | 8208300.0 |
| 2001-03-22 | BITS | ETF | 7.5 | 7.875 | 6.0 | 7.0 | 9575.0 |
| 2001-03-22 | CEF | ETF | 3.06 | 3.1 | 3.04 | 3.06 | 4500.0 |
| 2001-03-22 | CHB | ETF | 5.2 | 5.29 | 5.2 | 5.29 | 335200.0 |
| 2001-03-22 | CNXT | ETF | 10.13 | 11.44 | 10.06 | 11.31 | 2360770.0 |
| 2001-03-22 | DGT | ETF | 65.1 | 65.1 | 64.37 | 64.37 | 1000.0 |
| 2001-03-22 | EWA | ETF | 8.54 | 8.54 | 8.35 | 8.44 | 17600.0 |
| 2001-03-22 | EWC | ETF | 10.8 | 10.8 | 10.55 | 10.75 | 7300.0 |
| 2001-03-22 | EWD | ETF | 13.3 | 13.3 | 12.7 | 13.25 | 25100.0 |
| 2001-03-22 | EWG | ETF | 15.75 | 16.0 | 15.2 | 15.65 | 118000.0 |
| 2001-03-22 | EWH | ETF | 10.5 | 10.5 | 10.03 | 10.2 | 72000.0 |
| 2001-03-22 | EWI | ETF | 36.4 | 36.4 | 35.6 | 35.6 | 1300.0 |
| 2001-03-22 | EWJ | ETF | 39.92 | 40.4 | 39.0 | 40.0 | 371275.0 |
| 2001-03-22 | EWK | ETF | 10.25 | 10.55 | 10.2 | 10.2 | 1900.0 |
| 2001-03-22 | EWL | ETF | 13.1 | 13.1 | 12.81 | 13.0 | 9000.0 |
| 2001-03-22 | EWM | ETF | 19.68 | 19.68 | 19.0 | 19.24 | 34850.0 |
| 2001-03-22 | EWN | ETF | 18.45 | 18.55 | 18.1 | 18.55 | 11500.0 |
| 2001-03-22 | EWO | ETF | 7.7 | 7.7 | 7.6 | 7.6 | 32600.0 |
| 2001-03-22 | EWP | ETF | 21.95 | 21.95 | 21.15 | 21.4 | 32300.0 |
| 2001-03-22 | EWQ | ETF | 19.5 | 19.5 | 18.9 | 19.45 | 42200.0 |
| 2001-03-22 | EWS | ETF | 10.98 | 11.0 | 10.2 | 10.6 | 65400.0 |
| 2001-03-22 | EWT | ETF | 23.8 | 24.3 | 23.5 | 24.3 | 28200.0 |
| 2001-03-22 | EWU | ETF | 30.3 | 30.3 | 29.1 | 29.86 | 86150.0 |
| 2001-03-22 | EWW | ETF | 13.5 | 13.55 | 13.2 | 13.41 | 79700.0 |
| 2001-03-22 | EWY | ETF | 12.2 | 12.24 | 11.87 | 12.24 | 7000.0 |
| 2001-03-22 | EWZ | ETF | 14.77 | 14.77 | 14.05 | 14.35 | 170700.0 |
| 2001-03-22 | EZU | ETF | 29.0469 | 29.25 | 28.4219 | 29.25 | 53000.0 |
| 2001-03-22 | FCTR | ETF | 14.0 | 14.375 | 13.875 | 14.25 | 24600.0 |
| 2001-03-22 | FMAR | ETF | 5.06 | 5.69 | 5.0 | 5.06 | 4900.0 |
| 2001-03-22 | GLDB | ETF | 6.75 | 6.9688 | 6.5 | 6.6875 | 35300.0 |
| 2001-03-22 | GSIG | ETF | 8.0 | 8.06 | 6.31 | 7.28 | 606000.0 |
| 2001-03-22 | IBB | ETF | 22.5 | 22.6354 | 20.3333 | 22.6354 | 206700.0 |
| 2001-03-22 | ICF | ETF | 19.086 | 19.1133 | 19.086 | 19.1133 | 100400.0 |
| 2001-03-22 | IDU | ETF | 38.5 | 38.5 | 36.8 | 36.91 | 135600.0 |
| 2001-03-22 | IEV | ETF | 30.125 | 30.475 | 29.51 | 30.475 | 23400.0 |
| 2001-03-22 | IGLD | ETF | 137.5 | 146.875 | 137.5 | 143.75 | 101.0 |
| 2001-03-22 | IGM | ETF | 8.6833 | 9.2083 | 8.68 | 9.2083 | 1875000.0 |
| 2001-03-22 | IJH | ETF | 8.912 | 8.93 | 8.656 | 8.91 | 958000.0 |
| 2001-03-22 | IJJ | ETF | 20.005 | 20.005 | 19.3475 | 19.875 | 270400.0 |
| 2001-03-22 | IJK | ETF | 12.25 | 12.415 | 11.8888 | 12.3975 | 37600.0 |
| 2001-03-22 | IJR | ETF | 16.425 | 16.425 | 15.6333 | 16.25 | 415800.0 |
| 2001-03-22 | IJS | ETF | 18.55 | 18.55 | 17.9125 | 18.53 | 295200.0 |
| 2001-03-22 | IJT | ETF | 16.225 | 16.225 | 15.82 | 16.09 | 9200.0 |
| 2001-03-22 | IOO | ETF | 29.3281 | 29.4219 | 28.7969 | 29.0234 | 15000.0 |
| 2001-03-22 | IUSG | ETF | 19.7 | 20.35 | 19.34 | 20.35 | 21600.0 |
| 2001-03-22 | IUSV | ETF | 22.7667 | 22.7667 | 22.17 | 22.17 | 29700.0 |
> showing 50 of 97 rows — these rows as CSV