PREVIEW / etf_daily / 2001-01-03
file: by_date/etf_daily/2001/2001-01-03.parquet size: 8 KB rows: 91
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-01-03 | SPY | ETF | 128.3125 | 136.0 | 127.6562 | 135.0 | 19431600.0 |
| 2001-01-03 | QQQ | ETF | 52.1875 | 65.25 | 52.1563 | 62.4375 | 118239200.0 |
| 2001-01-03 | IWM | ETF | 45.75 | 48.75 | 45.7188 | 48.1172 | 1409800.0 |
| 2001-01-03 | DIA | ETF | 106.4062 | 112.5 | 105.625 | 109.5312 | 4409300.0 |
| 2001-01-03 | BBH | ETF | 53.5417 | 60.6667 | 50.0417 | 56.5417 | 10414800.0 |
| 2001-01-03 | BITS | ETF | 8.5 | 11.25 | 8.5 | 11.0 | 7050.0 |
| 2001-01-03 | CEF | ETF | 3.125 | 3.1875 | 3.0625 | 3.125 | 30600.0 |
| 2001-01-03 | CHB | ETF | 2.88 | 3.69 | 2.88 | 3.69 | 116300.0 |
| 2001-01-03 | CNXT | ETF | 13.0 | 16.75 | 12.63 | 16.44 | 9088140.0 |
| 2001-01-03 | EWA | ETF | 9.75 | 9.9375 | 9.75 | 9.9375 | 18600.0 |
| 2001-01-03 | EWC | ETF | 12.9375 | 13.375 | 12.75 | 13.3125 | 25900.0 |
| 2001-01-03 | EWD | ETF | 17.25 | 18.0 | 17.0 | 18.0 | 8500.0 |
| 2001-01-03 | EWG | ETF | 19.25 | 20.125 | 19.1875 | 19.9375 | 235500.0 |
| 2001-01-03 | EWH | ETF | 11.125 | 12.0625 | 11.125 | 12.0 | 124400.0 |
| 2001-01-03 | EWI | ETF | 44.0 | 44.75 | 44.0 | 44.75 | 19100.0 |
| 2001-01-03 | EWJ | ETF | 44.0 | 46.25 | 43.5 | 46.0 | 146200.0 |
| 2001-01-03 | EWL | ETF | 17.125 | 17.75 | 16.9375 | 17.625 | 22200.0 |
| 2001-01-03 | EWM | ETF | 19.5 | 20.0 | 19.25 | 19.75 | 6650.0 |
| 2001-01-03 | EWN | ETF | 22.625 | 23.375 | 22.625 | 23.375 | 3800.0 |
| 2001-01-03 | EWO | ETF | 7.6875 | 7.6875 | 7.5 | 7.6875 | 42000.0 |
| 2001-01-03 | EWP | ETF | 23.6875 | 24.75 | 23.6875 | 24.25 | 33700.0 |
| 2001-01-03 | EWQ | ETF | 24.0 | 24.4375 | 23.6875 | 24.3125 | 94100.0 |
| 2001-01-03 | EWS | ETF | 12.625 | 13.625 | 12.625 | 13.625 | 57000.0 |
| 2001-01-03 | EWT | ETF | 21.375 | 23.625 | 20.875 | 23.5 | 40650.0 |
| 2001-01-03 | EWU | ETF | 35.75 | 37.125 | 35.125 | 36.375 | 49100.0 |
| 2001-01-03 | EWW | ETF | 13.1875 | 14.0625 | 12.75 | 14.0625 | 128200.0 |
| 2001-01-03 | EWY | ETF | 12.6875 | 13.8125 | 12.625 | 13.8125 | 14900.0 |
| 2001-01-03 | EWZ | ETF | 16.625 | 18.0 | 16.625 | 18.0 | 2700.0 |
| 2001-01-03 | EZU | ETF | 35.6875 | 37.75 | 35.625 | 37.75 | 43800.0 |
| 2001-01-03 | FCTR | ETF | 13.25 | 14.875 | 13.1875 | 14.8125 | 31600.0 |
| 2001-01-03 | FMAR | ETF | 4.5 | 5.12 | 4.4995 | 5.12 | 33210.0 |
| 2001-01-03 | GLDB | ETF | 4.6875 | 5.25 | 4.5 | 5.0625 | 107800.0 |
| 2001-01-03 | GSIG | ETF | 7.94 | 9.0 | 7.87 | 8.94 | 328100.0 |
| 2001-01-03 | IDU | ETF | 43.375 | 43.375 | 40.9688 | 40.9688 | 178200.0 |
| 2001-01-03 | IEV | ETF | 37.75 | 40.25 | 37.625 | 40.25 | 207400.0 |
| 2001-01-03 | IGLD | ETF | 215.625 | 218.75 | 206.25 | 212.5 | 339.0 |
| 2001-01-03 | IJH | ETF | 9.7969 | 10.2906 | 9.7 | 10.2375 | 742000.0 |
| 2001-01-03 | IJJ | ETF | 20.6875 | 21.4258 | 20.6875 | 21.4258 | 57200.0 |
| 2001-01-03 | IJK | ETF | 14.4688 | 15.3047 | 14.2441 | 15.2402 | 324000.0 |
| 2001-01-03 | IJR | ETF | 17.2917 | 18.0417 | 17.2917 | 18.0417 | 622800.0 |
| 2001-01-03 | IJS | ETF | 18.586 | 19.25 | 18.586 | 19.1875 | 374000.0 |
| 2001-01-03 | IJT | ETF | 18.2188 | 19.2734 | 18.2188 | 19.2734 | 32000.0 |
| 2001-01-03 | IOO | ETF | 34.6562 | 36.0234 | 34.2734 | 36.0234 | 3000.0 |
| 2001-01-03 | IUSG | ETF | 24.0625 | 26.1719 | 24.0625 | 26.1719 | 2600.0 |
| 2001-01-03 | IUSV | ETF | 25.0104 | 25.75 | 25.0104 | 25.4167 | 4500.0 |
| 2001-01-03 | IVE | ETF | 63.0625 | 66.0312 | 62.5156 | 65.1875 | 102800.0 |
| 2001-01-03 | IVV | ETF | 128.2344 | 135.125 | 128.0 | 135.0938 | 194500.0 |
| 2001-01-03 | IVW | ETF | 16.5312 | 17.5469 | 16.4141 | 17.375 | 272400.0 |
| 2001-01-03 | IWB | ETF | 68.0 | 71.5 | 67.35 | 71.33 | 13600.0 |
| 2001-01-03 | IWD | ETF | 59.1875 | 60.5 | 58.7031 | 60.1094 | 165400.0 |
> showing 50 of 91 rows — these rows as CSV