PREVIEW / etf_daily / 2001-04-11
file: by_date/etf_daily/2001/2001-04-11.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-04-11 | SPY | ETF | 118.78 | 118.99 | 116.14 | 116.73 | 12722300.0 |
| 2001-04-11 | QQQ | ETF | 42.16 | 42.5 | 40.45 | 41.0 | 92829500.0 |
| 2001-04-11 | IWM | ETF | 45.9 | 45.9 | 44.56 | 44.9 | 526800.0 |
| 2001-04-11 | DIA | ETF | 102.49 | 102.5 | 99.6 | 100.18 | 4623500.0 |
| 2001-04-11 | BBH | ETF | 38.4333 | 38.4333 | 36.35 | 36.5833 | 3104100.0 |
| 2001-04-11 | BITS | ETF | 6.8 | 7.48 | 6.8 | 7.48 | 6525.0 |
| 2001-04-11 | BOSS | ETF | 26.5 | 27.5 | 26.5 | 27.5 | 100.0 |
| 2001-04-11 | CEF | ETF | 3.02 | 3.1 | 3.02 | 3.08 | 21400.0 |
| 2001-04-11 | CHB | ETF | 5.0 | 5.0 | 4.76 | 4.76 | 105100.0 |
| 2001-04-11 | CNXT | ETF | 8.14 | 8.99 | 7.95 | 8.31 | 3820430.0 |
| 2001-04-11 | CSB | ETF | 1.5 | 1.5 | 1.5 | 1.5 | 106000.0 |
| 2001-04-11 | DGT | ETF | 70.17 | 70.17 | 69.42 | 69.42 | 4700.0 |
| 2001-04-11 | EWA | ETF | 9.0 | 9.09 | 9.0 | 9.02 | 39400.0 |
| 2001-04-11 | EWC | ETF | 11.4 | 11.4 | 11.2 | 11.25 | 12900.0 |
| 2001-04-11 | EWD | ETF | 14.05 | 14.2 | 14.0 | 14.0 | 6200.0 |
| 2001-04-11 | EWG | ETF | 16.96 | 17.0 | 16.86 | 16.86 | 9000.0 |
| 2001-04-11 | EWH | ETF | 10.44 | 10.5 | 10.3 | 10.32 | 23100.0 |
| 2001-04-11 | EWI | ETF | 39.2 | 39.2 | 39.2 | 39.2 | 100.0 |
| 2001-04-11 | EWJ | ETF | 42.0 | 42.0 | 41.04 | 41.2 | 104375.0 |
| 2001-04-11 | EWL | ETF | 14.15 | 14.35 | 14.15 | 14.35 | 7200.0 |
| 2001-04-11 | EWM | ETF | 17.0 | 17.12 | 16.52 | 16.52 | 11875.0 |
| 2001-04-11 | EWN | ETF | 20.0 | 20.2 | 20.0 | 20.15 | 1200.0 |
| 2001-04-11 | EWO | ETF | 8.25 | 8.25 | 8.12 | 8.12 | 9200.0 |
| 2001-04-11 | EWP | ETF | 23.8 | 23.8 | 23.8 | 23.8 | 200.0 |
| 2001-04-11 | EWQ | ETF | 21.25 | 21.25 | 21.15 | 21.21 | 3300.0 |
| 2001-04-11 | EWS | ETF | 10.5 | 10.66 | 10.48 | 10.48 | 63650.0 |
| 2001-04-11 | EWT | ETF | 22.6 | 23.18 | 22.6 | 23.18 | 14700.0 |
| 2001-04-11 | EWU | ETF | 32.5 | 32.64 | 32.2 | 32.5 | 8200.0 |
| 2001-04-11 | EWW | ETF | 15.09 | 15.09 | 14.88 | 15.0 | 57600.0 |
| 2001-04-11 | EWY | ETF | 11.62 | 11.99 | 11.62 | 11.99 | 36200.0 |
| 2001-04-11 | EWZ | ETF | 15.4 | 15.4 | 15.24 | 15.24 | 200.0 |
| 2001-04-11 | EZU | ETF | 31.65 | 31.8 | 31.65 | 31.75 | 8200.0 |
| 2001-04-11 | FCTR | ETF | 15.35 | 15.48 | 15.07 | 15.37 | 20800.0 |
| 2001-04-11 | FMAR | ETF | 5.5 | 5.5 | 5.0 | 5.45 | 700.0 |
| 2001-04-11 | GLDB | ETF | 6.46 | 6.65 | 6.46 | 6.48 | 434400.0 |
| 2001-04-11 | GSIG | ETF | 8.11 | 8.9 | 8.11 | 8.63 | 139800.0 |
| 2001-04-11 | IBB | ETF | 26.7667 | 26.7667 | 25.5833 | 25.7333 | 120600.0 |
| 2001-04-11 | ICF | ETF | 19.345 | 19.345 | 19.0875 | 19.0875 | 35200.0 |
| 2001-04-11 | IDU | ETF | 41.375 | 41.375 | 41.045 | 41.225 | 24400.0 |
| 2001-04-11 | IEV | ETF | 33.075 | 33.1 | 32.765 | 32.99 | 21600.0 |
| 2001-04-11 | IGLD | ETF | 122.0 | 122.0 | 99.0 | 100.0 | 120.0 |
| 2001-04-11 | IGM | ETF | 9.2167 | 9.225 | 8.9917 | 8.9917 | 185400.0 |
| 2001-04-11 | IJH | ETF | 9.5 | 9.503 | 9.322 | 9.323 | 288000.0 |
| 2001-04-11 | IJJ | ETF | 21.0775 | 21.0775 | 20.76 | 20.7925 | 60800.0 |
| 2001-04-11 | IJK | ETF | 13.2588 | 13.2588 | 12.9162 | 12.9162 | 62400.0 |
| 2001-04-11 | IJR | ETF | 17.25 | 17.2617 | 16.8383 | 16.8833 | 225000.0 |
| 2001-04-11 | IJS | ETF | 19.1875 | 19.205 | 18.725 | 18.8975 | 76800.0 |
| 2001-04-11 | IJT | ETF | 17.475 | 17.475 | 17.05 | 17.1825 | 27600.0 |
| 2001-04-11 | IOO | ETF | 31.45 | 31.515 | 31.0 | 31.1 | 204200.0 |
| 2001-04-11 | IUSG | ETF | 20.8 | 20.925 | 20.525 | 20.525 | 4400.0 |
> showing 50 of 97 rows — these rows as CSV