PREVIEW / etf_daily / 2001-03-21
file: by_date/etf_daily/2001/2001-03-21.parquet size: 8 KB rows: 95
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-21 | SPY | ETF | 114.18 | 115.26 | 111.9 | 112.26 | 19004600.0 |
| 2001-03-21 | QQQ | ETF | 40.52 | 41.8 | 39.71 | 40.35 | 96204900.0 |
| 2001-03-21 | IWM | ETF | 44.125 | 44.3 | 43.075 | 43.425 | 494800.0 |
| 2001-03-21 | DIA | ETF | 96.96 | 97.32 | 94.5 | 94.8 | 7788600.0 |
| 2001-03-21 | BBH | ETF | 38.5333 | 38.7667 | 35.0333 | 35.6667 | 4615500.0 |
| 2001-03-21 | BITS | ETF | 7.75 | 7.875 | 7.5 | 7.5 | 5250.0 |
| 2001-03-21 | CEF | ETF | 3.06 | 3.08 | 3.06 | 3.08 | 7500.0 |
| 2001-03-21 | CHB | ETF | 5.15 | 5.26 | 5.14 | 5.16 | 125700.0 |
| 2001-03-21 | CNXT | ETF | 9.72 | 10.44 | 9.44 | 10.06 | 3104150.0 |
| 2001-03-21 | DGT | ETF | 67.0 | 67.0 | 66.6 | 66.6 | 1400.0 |
| 2001-03-21 | EWA | ETF | 8.6 | 8.7 | 8.6 | 8.7 | 15200.0 |
| 2001-03-21 | EWC | ETF | 11.0 | 11.1 | 11.0 | 11.1 | 8500.0 |
| 2001-03-21 | EWD | ETF | 13.6 | 13.8 | 13.6 | 13.8 | 300.0 |
| 2001-03-21 | EWG | ETF | 16.34 | 16.5 | 16.2 | 16.25 | 41100.0 |
| 2001-03-21 | EWH | ETF | 10.65 | 10.81 | 10.58 | 10.58 | 58300.0 |
| 2001-03-21 | EWI | ETF | 37.62 | 37.82 | 37.62 | 37.82 | 2650.0 |
| 2001-03-21 | EWJ | ETF | 40.32 | 40.96 | 40.2 | 40.48 | 152350.0 |
| 2001-03-21 | EWK | ETF | 10.85 | 10.85 | 10.85 | 10.85 | 100.0 |
| 2001-03-21 | EWL | ETF | 14.0 | 14.0 | 13.4 | 13.4 | 25300.0 |
| 2001-03-21 | EWM | ETF | 19.6 | 20.0 | 19.6 | 19.6 | 6600.0 |
| 2001-03-21 | EWN | ETF | 19.2 | 19.5 | 19.15 | 19.15 | 22800.0 |
| 2001-03-21 | EWO | ETF | 7.78 | 7.9 | 7.78 | 7.9 | 1900.0 |
| 2001-03-21 | EWP | ETF | 22.45 | 22.7 | 22.2 | 22.3 | 7900.0 |
| 2001-03-21 | EWQ | ETF | 20.13 | 20.15 | 19.95 | 19.95 | 41400.0 |
| 2001-03-21 | EWS | ETF | 11.04 | 11.28 | 11.04 | 11.12 | 55550.0 |
| 2001-03-21 | EWT | ETF | 23.08 | 23.58 | 23.08 | 23.4 | 3400.0 |
| 2001-03-21 | EWU | ETF | 31.2 | 31.2 | 30.42 | 30.8 | 17900.0 |
| 2001-03-21 | EWW | ETF | 13.95 | 14.0 | 13.71 | 13.81 | 8400.0 |
| 2001-03-21 | EWY | ETF | 12.4 | 12.4 | 12.12 | 12.12 | 1900.0 |
| 2001-03-21 | EWZ | ETF | 15.55 | 15.64 | 15.07 | 15.07 | 5400.0 |
| 2001-03-21 | EZU | ETF | 30.4219 | 30.4219 | 30.2031 | 30.2031 | 79600.0 |
| 2001-03-21 | FCTR | ETF | 14.0625 | 14.6094 | 13.8125 | 13.9844 | 15700.0 |
| 2001-03-21 | GLDB | ETF | 6.875 | 7.0 | 6.5 | 6.75 | 60800.0 |
| 2001-03-21 | GSIG | ETF | 8.62 | 8.69 | 7.94 | 7.94 | 262400.0 |
| 2001-03-21 | IBB | ETF | 25.1979 | 25.1979 | 22.9323 | 23.0833 | 72600.0 |
| 2001-03-21 | ICF | ETF | 19.6016 | 19.6016 | 19.375 | 19.375 | 102400.0 |
| 2001-03-21 | IDU | ETF | 39.075 | 39.42 | 38.625 | 38.625 | 59600.0 |
| 2001-03-21 | IEV | ETF | 31.5 | 31.575 | 31.05 | 31.235 | 26000.0 |
| 2001-03-21 | IGLD | ETF | 140.625 | 140.625 | 137.5 | 137.5 | 140.0 |
| 2001-03-21 | IGM | ETF | 8.9083 | 8.9317 | 8.745 | 8.9217 | 483000.0 |
| 2001-03-21 | IJH | ETF | 9.164 | 9.192 | 8.998 | 8.998 | 148000.0 |
| 2001-03-21 | IJJ | ETF | 20.545 | 20.545 | 20.145 | 20.1625 | 107600.0 |
| 2001-03-21 | IJK | ETF | 12.625 | 12.735 | 12.4238 | 12.4625 | 32800.0 |
| 2001-03-21 | IJR | ETF | 16.7333 | 16.7833 | 16.3333 | 16.4417 | 176400.0 |
| 2001-03-21 | IJS | ETF | 18.93 | 18.93 | 18.5 | 18.525 | 166000.0 |
| 2001-03-21 | IJT | ETF | 16.775 | 16.775 | 16.2125 | 16.285 | 44000.0 |
| 2001-03-21 | IOO | ETF | 30.2734 | 30.2734 | 29.5234 | 29.5234 | 2400.0 |
| 2001-03-21 | IUSG | ETF | 20.165 | 20.185 | 19.92 | 19.925 | 4200.0 |
| 2001-03-21 | IUSV | ETF | 23.2333 | 23.3533 | 23.0767 | 23.0767 | 21600.0 |
| 2001-03-21 | IVE | ETF | 58.77 | 58.94 | 57.52 | 57.65 | 138000.0 |
> showing 50 of 95 rows — these rows as CSV