PREVIEW / etf_daily / 2001-12-12
file: by_date/etf_daily/2001/2001-12-12.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-12 | SPY | ETF | 114.55 | 114.78 | 113.11 | 114.28 | 16171500.0 |
| 2001-12-12 | QQQ | ETF | 41.5 | 41.94 | 40.6 | 41.56 | 76093400.0 |
| 2001-12-12 | IWM | ETF | 47.45 | 47.565 | 46.865 | 47.4 | 249400.0 |
| 2001-12-12 | DIA | ETF | 99.4 | 99.65 | 98.11 | 99.23 | 3120800.0 |
| 2001-12-12 | ARB | ETF | 30.85 | 30.85 | 30.5 | 30.66 | 38300.0 |
| 2001-12-12 | BBH | ETF | 43.8333 | 44.06 | 42.6167 | 43.71 | 6519600.0 |
| 2001-12-12 | BITS | ETF | 22.2 | 26.4 | 20.4 | 25.4 | 50525.0 |
| 2001-12-12 | CEF | ETF | 3.28 | 3.35 | 3.27 | 3.35 | 5600.0 |
| 2001-12-12 | CHB | ETF | 12.6 | 12.8 | 12.6 | 12.68 | 106600.0 |
| 2001-12-12 | CNXT | ETF | 17.38 | 17.86 | 16.9 | 17.3 | 6286630.0 |
| 2001-12-12 | DGT | ETF | 65.9 | 65.9 | 65.38 | 65.38 | 1300.0 |
| 2001-12-12 | EFA | ETF | 39.8333 | 39.8333 | 39.4333 | 39.71 | 447900.0 |
| 2001-12-12 | ELV | ETF | 24.125 | 24.125 | 23.925 | 23.93 | 239400.0 |
| 2001-12-12 | EWA | ETF | 9.33 | 9.33 | 9.24 | 9.25 | 12400.0 |
| 2001-12-12 | EWC | ETF | 10.9 | 10.9 | 10.81 | 10.81 | 1400.0 |
| 2001-12-12 | EWD | ETF | 14.03 | 14.03 | 13.81 | 14.0 | 2300.0 |
| 2001-12-12 | EWG | ETF | 14.8 | 14.86 | 14.57 | 14.8 | 28700.0 |
| 2001-12-12 | EWH | ETF | 9.43 | 9.53 | 9.27 | 9.31 | 38800.0 |
| 2001-12-12 | EWI | ETF | 32.32 | 32.36 | 31.9 | 32.36 | 7450.0 |
| 2001-12-12 | EWJ | ETF | 32.32 | 32.44 | 31.8 | 32.36 | 186650.0 |
| 2001-12-12 | EWK | ETF | 10.44 | 10.44 | 10.44 | 10.44 | 300.0 |
| 2001-12-12 | EWL | ETF | 12.52 | 12.69 | 12.51 | 12.51 | 3500.0 |
| 2001-12-12 | EWM | ETF | 19.4 | 19.76 | 19.4 | 19.48 | 2700.0 |
| 2001-12-12 | EWN | ETF | 16.52 | 16.59 | 16.51 | 16.59 | 1600.0 |
| 2001-12-12 | EWO | ETF | 7.35 | 7.36 | 7.35 | 7.36 | 18000.0 |
| 2001-12-12 | EWP | ETF | 21.32 | 21.34 | 21.21 | 21.21 | 800.0 |
| 2001-12-12 | EWQ | ETF | 18.34 | 18.48 | 18.26 | 18.48 | 14100.0 |
| 2001-12-12 | EWS | ETF | 10.1 | 10.2 | 10.06 | 10.16 | 7700.0 |
| 2001-12-12 | EWT | ETF | 22.0 | 22.6 | 21.98 | 22.34 | 43200.0 |
| 2001-12-12 | EWU | ETF | 29.28 | 29.28 | 28.92 | 29.18 | 19950.0 |
| 2001-12-12 | EWW | ETF | 14.92 | 14.95 | 14.66 | 14.8 | 14500.0 |
| 2001-12-12 | EWY | ETF | 17.85 | 17.86 | 17.65 | 17.73 | 19400.0 |
| 2001-12-12 | EWZ | ETF | 12.4 | 12.41 | 12.21 | 12.4 | 403000.0 |
| 2001-12-12 | EZU | ETF | 27.675 | 27.675 | 27.17 | 27.67 | 10400.0 |
| 2001-12-12 | FCTR | ETF | 17.43 | 17.93 | 17.36 | 17.93 | 11700.0 |
| 2001-12-12 | FMAR | ETF | 8.11 | 8.15 | 8.11 | 8.15 | 5000.0 |
| 2001-12-12 | GLDB | ETF | 7.16 | 7.23 | 7.16 | 7.22 | 11400.0 |
| 2001-12-12 | GSIG | ETF | 8.39 | 8.6 | 8.08 | 8.25 | 138600.0 |
| 2001-12-12 | IBB | ETF | 30.35 | 30.4167 | 29.2167 | 30.0333 | 1464600.0 |
| 2001-12-12 | ICF | ETF | 21.475 | 21.475 | 21.1275 | 21.285 | 131200.0 |
| 2001-12-12 | IDU | ETF | 30.2 | 30.32 | 29.375 | 30.32 | 150400.0 |
| 2001-12-12 | IEV | ETF | 29.35 | 29.395 | 29.075 | 29.385 | 146600.0 |
| 2001-12-12 | IGE | ETF | 15.05 | 15.05 | 15.0083 | 15.0083 | 1800.0 |
| 2001-12-12 | IGLD | ETF | 90.0 | 93.0 | 90.0 | 92.0 | 289.0 |
| 2001-12-12 | IGM | ETF | 8.8833 | 9.0 | 8.7933 | 8.9483 | 38400.0 |
| 2001-12-12 | IGN | ETF | 34.72 | 34.89 | 33.75 | 34.32 | 971500.0 |
| 2001-12-12 | IGV | ETF | 9.27 | 9.388 | 9.196 | 9.388 | 40000.0 |
| 2001-12-12 | IJH | ETF | 9.96 | 9.96 | 9.822 | 9.93 | 186000.0 |
| 2001-12-12 | IJJ | ETF | 21.975 | 21.975 | 21.75 | 21.935 | 436400.0 |
| 2001-12-12 | IJK | ETF | 14.025 | 14.0675 | 13.7775 | 13.95 | 2200000.0 |
> showing 50 of 115 rows — these rows as CSV