PREVIEW / etf_daily / 2001-03-14
file: by_date/etf_daily/2001/2001-03-14.parquet size: 8 KB rows: 93
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-14 | SPY | ETF | 117.05 | 119.29 | 115.75 | 117.65 | 19883400.0 |
| 2001-03-14 | QQQ | ETF | 42.7 | 45.19 | 42.31 | 43.75 | 97190000.0 |
| 2001-03-14 | IWM | ETF | 44.875 | 46.15 | 44.85 | 45.0 | 655800.0 |
| 2001-03-14 | DIA | ETF | 100.25 | 102.3 | 99.13 | 100.19 | 9402900.0 |
| 2001-03-14 | BBH | ETF | 40.9333 | 43.3333 | 40.17 | 41.4167 | 4550700.0 |
| 2001-03-14 | BITS | ETF | 9.25 | 9.75 | 8.25 | 9.75 | 2725.0 |
| 2001-03-14 | CEF | ETF | 3.17 | 3.2 | 3.15 | 3.19 | 20000.0 |
| 2001-03-14 | CHB | ETF | 5.15 | 5.3 | 4.83 | 4.85 | 145600.0 |
| 2001-03-14 | CNXT | ETF | 11.75 | 12.69 | 11.56 | 12.06 | 1671310.0 |
| 2001-03-14 | DGT | ETF | 68.22 | 68.22 | 68.22 | 68.22 | 100.0 |
| 2001-03-14 | EWA | ETF | 8.75 | 8.75 | 8.5 | 8.5 | 19900.0 |
| 2001-03-14 | EWC | ETF | 11.5 | 11.5 | 11.2 | 11.2 | 7900.0 |
| 2001-03-14 | EWD | ETF | 14.5 | 14.9 | 14.35 | 14.35 | 5600.0 |
| 2001-03-14 | EWG | ETF | 17.05 | 17.4 | 16.75 | 16.8 | 133000.0 |
| 2001-03-14 | EWH | ETF | 10.51 | 10.8 | 10.51 | 10.74 | 58700.0 |
| 2001-03-14 | EWI | ETF | 38.8 | 39.0 | 38.3 | 38.3 | 11850.0 |
| 2001-03-14 | EWJ | ETF | 36.4 | 37.8 | 36.2 | 36.64 | 328900.0 |
| 2001-03-14 | EWK | ETF | 11.95 | 12.15 | 11.85 | 11.85 | 2100.0 |
| 2001-03-14 | EWL | ETF | 14.2 | 14.6 | 14.2 | 14.3 | 15800.0 |
| 2001-03-14 | EWM | ETF | 19.6 | 19.68 | 19.6 | 19.68 | 15775.0 |
| 2001-03-14 | EWN | ETF | 20.4 | 20.55 | 20.15 | 20.15 | 5100.0 |
| 2001-03-14 | EWO | ETF | 8.3 | 8.4 | 8.15 | 8.15 | 11400.0 |
| 2001-03-14 | EWP | ETF | 23.45 | 24.05 | 23.45 | 23.61 | 35800.0 |
| 2001-03-14 | EWQ | ETF | 20.5 | 21.0 | 20.35 | 20.6 | 49300.0 |
| 2001-03-14 | EWS | ETF | 11.86 | 11.88 | 11.4 | 11.42 | 19600.0 |
| 2001-03-14 | EWT | ETF | 23.5 | 23.5 | 22.76 | 23.1 | 23350.0 |
| 2001-03-14 | EWU | ETF | 31.0 | 32.1 | 31.0 | 31.68 | 30600.0 |
| 2001-03-14 | EWW | ETF | 13.8 | 14.21 | 13.8 | 14.01 | 219200.0 |
| 2001-03-14 | EWY | ETF | 12.92 | 12.92 | 12.7 | 12.7 | 13800.0 |
| 2001-03-14 | EWZ | ETF | 15.76 | 16.0 | 15.7 | 15.71 | 451100.0 |
| 2001-03-14 | EZU | ETF | 30.5 | 31.2265 | 30.5 | 30.8985 | 26800.0 |
| 2001-03-14 | FCTR | ETF | 13.875 | 14.875 | 13.875 | 14.875 | 60900.0 |
| 2001-03-14 | FMAR | ETF | 5.25 | 5.25 | 5.25 | 5.25 | 1100.0 |
| 2001-03-14 | GLDB | ETF | 7.2969 | 7.375 | 7.0313 | 7.125 | 62800.0 |
| 2001-03-14 | GSIG | ETF | 8.91 | 9.0 | 8.12 | 8.87 | 275800.0 |
| 2001-03-14 | IBB | ETF | 26.1667 | 27.9844 | 26.1667 | 26.7813 | 42900.0 |
| 2001-03-14 | ICF | ETF | 19.5586 | 19.5586 | 19.5586 | 19.5586 | 4000.0 |
| 2001-03-14 | IDU | ETF | 39.325 | 39.325 | 38.925 | 39.015 | 4600.0 |
| 2001-03-14 | IEV | ETF | 32.375 | 32.695 | 31.9 | 32.55 | 100400.0 |
| 2001-03-14 | IGLD | ETF | 159.375 | 162.5 | 159.375 | 159.375 | 130.0 |
| 2001-03-14 | IJH | ETF | 9.447 | 9.627 | 9.398 | 9.452 | 459000.0 |
| 2001-03-14 | IJJ | ETF | 20.7725 | 21.1575 | 20.7725 | 20.7875 | 82400.0 |
| 2001-03-14 | IJK | ETF | 13.5625 | 13.5625 | 13.2538 | 13.375 | 31200.0 |
| 2001-03-14 | IJR | ETF | 17.1333 | 17.4333 | 17.0167 | 17.0417 | 259200.0 |
| 2001-03-14 | IJS | ETF | 19.25 | 19.58 | 19.1875 | 19.225 | 84800.0 |
| 2001-03-14 | IJT | ETF | 17.0125 | 17.3875 | 16.95 | 17.125 | 11600.0 |
| 2001-03-14 | IOO | ETF | 29.8984 | 30.3984 | 29.8984 | 30.1719 | 7600.0 |
| 2001-03-14 | IUSG | ETF | 20.775 | 21.13 | 20.755 | 21.04 | 15800.0 |
| 2001-03-14 | IUSV | ETF | 23.8167 | 23.9667 | 23.4667 | 23.67 | 8700.0 |
| 2001-03-14 | IVE | ETF | 59.62 | 60.28 | 58.85 | 59.62 | 203400.0 |
> showing 50 of 93 rows — these rows as CSV