PREVIEW / etf_daily / 2001-12-13
file: by_date/etf_daily/2001/2001-12-13.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-13 | SPY | ETF | 113.45 | 113.7 | 112.04 | 112.06 | 19026700.0 |
| 2001-12-13 | QQQ | ETF | 40.71 | 41.0 | 39.76 | 39.76 | 79587600.0 |
| 2001-12-13 | IWM | ETF | 46.975 | 47.27 | 46.55 | 46.555 | 796400.0 |
| 2001-12-13 | DIA | ETF | 98.3 | 98.79 | 97.52 | 97.6 | 2976500.0 |
| 2001-12-13 | ARB | ETF | 30.51 | 31.0 | 30.51 | 30.6 | 60700.0 |
| 2001-12-13 | BBH | ETF | 43.1667 | 44.9333 | 43.1667 | 43.6667 | 5328900.0 |
| 2001-12-13 | BITS | ETF | 25.72 | 28.36 | 25.0 | 26.6 | 39225.0 |
| 2001-12-13 | BOSS | ETF | 20.0 | 20.0 | 19.0 | 19.0 | 100.0 |
| 2001-12-13 | CEF | ETF | 3.27 | 3.35 | 3.26 | 3.28 | 30100.0 |
| 2001-12-13 | CHB | ETF | 12.68 | 12.68 | 12.4 | 12.55 | 122300.0 |
| 2001-12-13 | CNXT | ETF | 16.79 | 16.85 | 15.7 | 15.77 | 5385300.0 |
| 2001-12-13 | DGT | ETF | 64.95 | 65.37 | 64.95 | 65.37 | 400.0 |
| 2001-12-13 | EFA | ETF | 39.0 | 39.0833 | 38.6867 | 38.77 | 728100.0 |
| 2001-12-13 | ELV | ETF | 23.805 | 24.05 | 23.45 | 24.05 | 480300.0 |
| 2001-12-13 | EPP | ETF | 17.8433 | 17.86 | 17.8433 | 17.86 | 5400.0 |
| 2001-12-13 | EWA | ETF | 9.2 | 9.32 | 9.17 | 9.17 | 18000.0 |
| 2001-12-13 | EWC | ETF | 10.8 | 10.8 | 10.55 | 10.55 | 6400.0 |
| 2001-12-13 | EWD | ETF | 13.76 | 13.8 | 13.6 | 13.6 | 6600.0 |
| 2001-12-13 | EWG | ETF | 14.41 | 14.56 | 14.35 | 14.45 | 87100.0 |
| 2001-12-13 | EWH | ETF | 9.19 | 9.19 | 9.08 | 9.13 | 31100.0 |
| 2001-12-13 | EWI | ETF | 31.3 | 31.34 | 31.3 | 31.32 | 600.0 |
| 2001-12-13 | EWJ | ETF | 31.36 | 31.6 | 31.36 | 31.52 | 83500.0 |
| 2001-12-13 | EWK | ETF | 10.45 | 10.45 | 10.45 | 10.45 | 2000.0 |
| 2001-12-13 | EWL | ETF | 12.4 | 12.54 | 12.31 | 12.31 | 11000.0 |
| 2001-12-13 | EWM | ETF | 19.4 | 19.4 | 18.8 | 18.8 | 8225.0 |
| 2001-12-13 | EWN | ETF | 16.44 | 16.44 | 16.05 | 16.06 | 1600.0 |
| 2001-12-13 | EWO | ETF | 7.35 | 7.39 | 7.35 | 7.39 | 9000.0 |
| 2001-12-13 | EWP | ETF | 20.66 | 20.88 | 20.51 | 20.51 | 1600.0 |
| 2001-12-13 | EWQ | ETF | 17.83 | 17.98 | 17.82 | 17.85 | 62200.0 |
| 2001-12-13 | EWS | ETF | 10.0 | 10.0 | 9.78 | 9.98 | 27050.0 |
| 2001-12-13 | EWT | ETF | 21.1 | 21.78 | 21.1 | 21.24 | 42100.0 |
| 2001-12-13 | EWU | ETF | 28.56 | 28.72 | 28.34 | 28.66 | 13850.0 |
| 2001-12-13 | EWW | ETF | 14.56 | 14.79 | 14.52 | 14.52 | 7500.0 |
| 2001-12-13 | EWY | ETF | 17.7 | 17.7 | 17.51 | 17.67 | 19100.0 |
| 2001-12-13 | EWZ | ETF | 11.8 | 12.22 | 11.8 | 11.9 | 146400.0 |
| 2001-12-13 | EZU | ETF | 26.75 | 26.97 | 26.55 | 26.655 | 20600.0 |
| 2001-12-13 | FCTR | ETF | 17.95 | 17.95 | 17.45 | 17.45 | 7600.0 |
| 2001-12-13 | FMAR | ETF | 8.13 | 8.25 | 8.06 | 8.2 | 75900.0 |
| 2001-12-13 | GLDB | ETF | 7.2 | 7.35 | 7.18 | 7.28 | 242000.0 |
| 2001-12-13 | GSIG | ETF | 8.2 | 8.22 | 7.8 | 7.8 | 135300.0 |
| 2001-12-13 | IBB | ETF | 29.7 | 30.5733 | 29.7 | 30.15 | 1827600.0 |
| 2001-12-13 | ICF | ETF | 21.2 | 21.2 | 21.0 | 21.015 | 230400.0 |
| 2001-12-13 | IDU | ETF | 30.175 | 30.67 | 30.16 | 30.54 | 115200.0 |
| 2001-12-13 | IEV | ETF | 28.825 | 28.945 | 28.385 | 28.385 | 103400.0 |
| 2001-12-13 | IGLD | ETF | 90.0 | 91.0 | 88.0 | 91.0 | 84.0 |
| 2001-12-13 | IGM | ETF | 8.75 | 8.765 | 8.5783 | 8.6067 | 78000.0 |
| 2001-12-13 | IGN | ETF | 32.5 | 32.59 | 31.37 | 31.55 | 832200.0 |
| 2001-12-13 | IGV | ETF | 9.22 | 9.23 | 9.05 | 9.05 | 46500.0 |
| 2001-12-13 | IJH | ETF | 9.815 | 9.922 | 9.778 | 9.778 | 249000.0 |
| 2001-12-13 | IJJ | ETF | 21.725 | 21.895 | 21.5875 | 21.5875 | 264400.0 |
> showing 50 of 115 rows — these rows as CSV