PREVIEW / etf_daily / 2001-03-12
file: by_date/etf_daily/2001/2001-03-12.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-12 | SPY | ETF | 122.34 | 122.5 | 117.75 | 118.08 | 13972900.0 |
| 2001-03-12 | QQQ | ETF | 44.0 | 44.95 | 41.8 | 42.3 | 80674200.0 |
| 2001-03-12 | IWM | ETF | 46.625 | 46.625 | 45.33 | 45.625 | 1006400.0 |
| 2001-03-12 | DIA | ETF | 105.45 | 107.84 | 101.4 | 101.9 | 4689200.0 |
| 2001-03-12 | BBH | ETF | 43.3333 | 43.5933 | 39.6667 | 39.9333 | 5588400.0 |
| 2001-03-12 | BITS | ETF | 9.0 | 9.75 | 8.75 | 9.75 | 2775.0 |
| 2001-03-12 | BOSS | ETF | 29.0 | 29.5 | 29.0 | 29.5 | 100.0 |
| 2001-03-12 | CEF | ETF | 3.2 | 3.25 | 3.18 | 3.25 | 60400.0 |
| 2001-03-12 | CHB | ETF | 5.01 | 5.09 | 4.75 | 4.77 | 121500.0 |
| 2001-03-12 | CNXT | ETF | 12.06 | 12.88 | 11.69 | 11.753 | 2759370.0 |
| 2001-03-12 | DGT | ETF | 70.4 | 70.55 | 70.4 | 70.5 | 9800.0 |
| 2001-03-12 | EWA | ETF | 9.05 | 9.18 | 9.05 | 9.18 | 24400.0 |
| 2001-03-12 | EWC | ETF | 11.5 | 11.5 | 11.47 | 11.5 | 10400.0 |
| 2001-03-12 | EWD | ETF | 15.9 | 15.9 | 15.2 | 15.2 | 30500.0 |
| 2001-03-12 | EWG | ETF | 18.2 | 18.5 | 18.05 | 18.2 | 57400.0 |
| 2001-03-12 | EWH | ETF | 11.1 | 11.18 | 10.65 | 10.65 | 109100.0 |
| 2001-03-12 | EWI | ETF | 40.0 | 40.3 | 39.9 | 40.3 | 3300.0 |
| 2001-03-12 | EWJ | ETF | 39.2 | 39.6 | 38.84 | 38.96 | 181425.0 |
| 2001-03-12 | EWK | ETF | 12.45 | 12.7 | 12.45 | 12.5 | 2200.0 |
| 2001-03-12 | EWL | ETF | 14.9 | 15.2 | 14.9 | 15.15 | 73200.0 |
| 2001-03-12 | EWM | ETF | 20.0 | 20.04 | 19.8 | 19.92 | 13300.0 |
| 2001-03-12 | EWN | ETF | 21.1 | 21.4 | 20.9 | 20.9 | 63400.0 |
| 2001-03-12 | EWO | ETF | 8.5 | 8.55 | 8.47 | 8.5 | 6300.0 |
| 2001-03-12 | EWP | ETF | 24.45 | 24.75 | 24.15 | 24.15 | 13800.0 |
| 2001-03-12 | EWQ | ETF | 21.6 | 21.7 | 21.45 | 21.58 | 21700.0 |
| 2001-03-12 | EWS | ETF | 12.1 | 12.2 | 11.8 | 11.8 | 17800.0 |
| 2001-03-12 | EWT | ETF | 23.48 | 23.96 | 23.1 | 23.1 | 16400.0 |
| 2001-03-12 | EWU | ETF | 33.0 | 33.08 | 32.56 | 32.98 | 19700.0 |
| 2001-03-12 | EWW | ETF | 14.75 | 14.8 | 14.1 | 14.1 | 15000.0 |
| 2001-03-12 | EWY | ETF | 13.0 | 13.0 | 12.5 | 12.55 | 54000.0 |
| 2001-03-12 | EWZ | ETF | 16.98 | 16.98 | 16.35 | 16.45 | 2300.0 |
| 2001-03-12 | EZU | ETF | 32.6016 | 32.75 | 32.2734 | 32.2734 | 79400.0 |
| 2001-03-12 | FCTR | ETF | 15.375 | 15.75 | 15.0 | 15.0469 | 18400.0 |
| 2001-03-12 | FMAR | ETF | 5.72 | 5.94 | 5.12 | 5.19 | 5900.0 |
| 2001-03-12 | GLDB | ETF | 7.4375 | 7.5625 | 7.4375 | 7.4688 | 154100.0 |
| 2001-03-12 | GSIG | ETF | 9.87 | 9.87 | 9.0 | 9.03 | 130500.0 |
| 2001-03-12 | IBB | ETF | 28.4167 | 28.4167 | 26.3333 | 26.3333 | 49500.0 |
| 2001-03-12 | ICF | ETF | 19.836 | 19.836 | 19.7383 | 19.7383 | 120400.0 |
| 2001-03-12 | IDU | ETF | 41.07 | 41.07 | 40.41 | 40.41 | 50400.0 |
| 2001-03-12 | IEV | ETF | 34.075 | 34.125 | 33.8 | 33.965 | 57600.0 |
| 2001-03-12 | IGLD | ETF | 171.875 | 175.0 | 171.875 | 171.875 | 172.0 |
| 2001-03-12 | IJH | ETF | 9.82 | 9.82 | 9.512 | 9.528 | 803000.0 |
| 2001-03-12 | IJJ | ETF | 21.63 | 21.63 | 21.0975 | 21.1075 | 134400.0 |
| 2001-03-12 | IJK | ETF | 13.7475 | 13.75 | 13.3312 | 13.3312 | 147200.0 |
| 2001-03-12 | IJR | ETF | 17.65 | 17.65 | 17.235 | 17.29 | 113400.0 |
| 2001-03-12 | IJS | ETF | 19.8375 | 19.8375 | 19.4025 | 19.405 | 163600.0 |
| 2001-03-12 | IJT | ETF | 17.6875 | 17.6875 | 17.26 | 17.26 | 38000.0 |
| 2001-03-12 | IOO | ETF | 31.5469 | 31.5469 | 30.8281 | 30.8281 | 7400.0 |
| 2001-03-12 | IUSG | ETF | 21.35 | 21.415 | 21.12 | 21.26 | 10800.0 |
| 2001-03-12 | IUSV | ETF | 24.68 | 24.72 | 24.1167 | 24.1167 | 35700.0 |
> showing 50 of 97 rows — these rows as CSV