PREVIEW / etf_daily / 2001-12-24
file: by_date/etf_daily/2001/2001-12-24.parquet size: 9 KB rows: 115
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-12-24 | SPY | ETF | 114.83 | 115.04 | 114.61 | 114.73 | 5728800.0 |
| 2001-12-24 | QQQ | ETF | 39.54 | 39.63 | 39.15 | 39.32 | 13660400.0 |
| 2001-12-24 | IWM | ETF | 48.225 | 48.425 | 48.105 | 48.325 | 319000.0 |
| 2001-12-24 | DIA | ETF | 100.52 | 100.78 | 100.4 | 100.49 | 372500.0 |
| 2001-12-24 | ARB | ETF | 31.8 | 32.49 | 31.7 | 32.49 | 18800.0 |
| 2001-12-24 | BBH | ETF | 44.5033 | 44.9333 | 44.5033 | 44.5367 | 1023000.0 |
| 2001-12-24 | BITS | ETF | 23.64 | 24.6 | 23.4 | 24.6 | 2275.0 |
| 2001-12-24 | CEF | ETF | 3.42 | 3.44 | 3.34 | 3.43 | 10200.0 |
| 2001-12-24 | CHB | ETF | 12.35 | 12.85 | 12.2 | 12.45 | 140300.0 |
| 2001-12-24 | CNXT | ETF | 13.28 | 13.4 | 13.06 | 13.1 | 1607000.0 |
| 2001-12-24 | CSB | ETF | 3.70000004768372 | 3.70000004768372 | 3.70000004768372 | 3.70000004768372 | 30200.0 |
| 2001-12-24 | DGT | ETF | 66.1 | 66.2 | 66.1 | 66.2 | 500.0 |
| 2001-12-24 | EFA | ETF | 38.8 | 39.05 | 38.8 | 38.9833 | 291300.0 |
| 2001-12-24 | ELV | ETF | 22.875 | 22.975 | 22.8 | 22.8 | 450100.0 |
| 2001-12-24 | EPP | ETF | 17.7833 | 17.86 | 17.7833 | 17.86 | 3000.0 |
| 2001-12-24 | EWA | ETF | 9.23 | 9.29 | 9.16 | 9.28 | 1700.0 |
| 2001-12-24 | EWC | ETF | 10.5 | 10.74 | 10.5 | 10.74 | 3100.0 |
| 2001-12-24 | EWD | ETF | 13.05 | 13.09 | 13.05 | 13.09 | 400.0 |
| 2001-12-24 | EWG | ETF | 14.22 | 14.22 | 14.17 | 14.19 | 6800.0 |
| 2001-12-24 | EWH | ETF | 9.15 | 9.19 | 9.09 | 9.09 | 11300.0 |
| 2001-12-24 | EWJ | ETF | 30.72 | 31.16 | 30.68 | 30.92 | 30300.0 |
| 2001-12-24 | EWL | ETF | 12.2 | 12.2 | 12.15 | 12.15 | 2600.0 |
| 2001-12-24 | EWM | ETF | 19.8 | 19.8 | 19.4 | 19.4 | 525.0 |
| 2001-12-24 | EWN | ETF | 16.26 | 16.26 | 16.26 | 16.26 | 300.0 |
| 2001-12-24 | EWO | ETF | 7.12 | 7.12 | 7.12 | 7.12 | 1000.0 |
| 2001-12-24 | EWQ | ETF | 17.9 | 17.9 | 17.88 | 17.9 | 1300.0 |
| 2001-12-24 | EWS | ETF | 9.98 | 9.98 | 9.88 | 9.96 | 5050.0 |
| 2001-12-24 | EWT | ETF | 20.5 | 20.68 | 20.5 | 20.56 | 2700.0 |
| 2001-12-24 | EWU | ETF | 28.6 | 28.94 | 28.6 | 28.7 | 2250.0 |
| 2001-12-24 | EWW | ETF | 15.15 | 15.34 | 15.1 | 15.2 | 7500.0 |
| 2001-12-24 | EWY | ETF | 16.21 | 16.34 | 16.21 | 16.33 | 6200.0 |
| 2001-12-24 | EWZ | ETF | 12.24 | 12.24 | 12.24 | 12.24 | 200.0 |
| 2001-12-24 | EZU | ETF | 26.875 | 26.9 | 26.68 | 26.68 | 31600.0 |
| 2001-12-24 | FCTR | ETF | 18.2 | 18.42 | 18.14 | 18.4 | 4600.0 |
| 2001-12-24 | FMAR | ETF | 9.02 | 9.27 | 8.76 | 8.78 | 7400.0 |
| 2001-12-24 | GLDB | ETF | 7.3 | 7.4 | 7.25 | 7.3 | 30700.0 |
| 2001-12-24 | GSIG | ETF | 7.5 | 8.35 | 7.5 | 8.19 | 108600.0 |
| 2001-12-24 | IBB | ETF | 31.0 | 31.0767 | 30.85 | 31.0 | 18000.0 |
| 2001-12-24 | ICF | ETF | 20.925 | 20.99 | 20.925 | 20.99 | 4400.0 |
| 2001-12-24 | IDU | ETF | 30.875 | 31.225 | 30.875 | 31.2 | 10800.0 |
| 2001-12-24 | IEV | ETF | 28.8 | 28.925 | 28.71 | 28.79 | 52600.0 |
| 2001-12-24 | IGE | ETF | 15.5 | 15.5 | 15.5 | 15.5 | 600.0 |
| 2001-12-24 | IGLD | ETF | 89.0 | 90.0 | 88.0 | 90.0 | 209.0 |
| 2001-12-24 | IGM | ETF | 8.4667 | 8.4667 | 8.3833 | 8.4 | 69600.0 |
| 2001-12-24 | IGN | ETF | 30.0 | 30.0 | 29.7 | 29.85 | 6200.0 |
| 2001-12-24 | IGV | ETF | 9.15 | 9.15 | 9.04 | 9.05 | 11000.0 |
| 2001-12-24 | IJH | ETF | 10.06 | 10.074 | 10.043 | 10.06 | 134000.0 |
| 2001-12-24 | IJJ | ETF | 22.275 | 22.355 | 22.2525 | 22.34 | 150400.0 |
| 2001-12-24 | IJK | ETF | 14.1188 | 14.1188 | 14.065 | 14.1038 | 127200.0 |
| 2001-12-24 | IJR | ETF | 19.0083 | 19.0917 | 18.97 | 19.07 | 130800.0 |
> showing 50 of 115 rows — these rows as CSV