PREVIEW / etf_daily / 2001-11-09
file: by_date/etf_daily/2001/2001-11-09.parquet size: 9 KB rows: 109
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-11-09 | SPY | ETF | 112.25 | 112.96 | 111.44 | 112.72 | 15895800.0 |
| 2001-11-09 | QQQ | ETF | 37.598 | 38.08 | 37.12 | 37.73 | 74121900.0 |
| 2001-11-09 | IWM | ETF | 43.53 | 43.745 | 43.415 | 43.7 | 421400.0 |
| 2001-11-09 | DIA | ETF | 95.77 | 96.5 | 95.28 | 96.31 | 2739100.0 |
| 2001-11-09 | ARB | ETF | 28.25 | 28.7 | 28.25 | 28.5 | 51100.0 |
| 2001-11-09 | BBH | ETF | 43.0 | 43.23 | 41.86 | 42.6 | 4765200.0 |
| 2001-11-09 | BITS | ETF | 16.602 | 17.0 | 15.88 | 17.0 | 5325.0 |
| 2001-11-09 | CEF | ETF | 3.33 | 3.35 | 3.31 | 3.35 | 7700.0 |
| 2001-11-09 | CHB | ETF | 10.0 | 10.0 | 9.6 | 9.61 | 223800.0 |
| 2001-11-09 | CNXT | ETF | 13.04 | 13.75 | 12.91 | 13.37 | 6369500.0 |
| 2001-11-09 | DGT | ETF | 66.51 | 66.65 | 66.51 | 66.65 | 2100.0 |
| 2001-11-09 | EFA | ETF | 39.4333 | 39.7767 | 39.4167 | 39.7333 | 970200.0 |
| 2001-11-09 | ELV | ETF | 21.25 | 21.25 | 20.5 | 21.0 | 1645800.0 |
| 2001-11-09 | EWA | ETF | 9.12 | 9.12 | 9.05 | 9.05 | 24100.0 |
| 2001-11-09 | EWC | ETF | 10.01 | 10.24 | 10.0 | 10.05 | 2400.0 |
| 2001-11-09 | EWD | ETF | 12.31 | 12.54 | 12.31 | 12.4 | 5600.0 |
| 2001-11-09 | EWG | ETF | 13.97 | 14.12 | 13.97 | 14.05 | 47900.0 |
| 2001-11-09 | EWH | ETF | 8.4 | 8.4 | 8.3 | 8.4 | 16000.0 |
| 2001-11-09 | EWI | ETF | 31.76 | 32.06 | 31.4 | 31.68 | 4250.0 |
| 2001-11-09 | EWJ | ETF | 33.56 | 33.56 | 33.24 | 33.24 | 109300.0 |
| 2001-11-09 | EWL | ETF | 12.47 | 12.74 | 12.43 | 12.59 | 8600.0 |
| 2001-11-09 | EWM | ETF | 17.4 | 17.56 | 17.4 | 17.4 | 2075.0 |
| 2001-11-09 | EWN | ETF | 16.82 | 16.94 | 16.75 | 16.94 | 6400.0 |
| 2001-11-09 | EWO | ETF | 6.88 | 6.89 | 6.88 | 6.89 | 600.0 |
| 2001-11-09 | EWP | ETF | 20.33 | 20.33 | 20.29 | 20.29 | 2100.0 |
| 2001-11-09 | EWQ | ETF | 18.2 | 18.28 | 18.1 | 18.14 | 6200.0 |
| 2001-11-09 | EWS | ETF | 8.44 | 8.66 | 8.42 | 8.62 | 12150.0 |
| 2001-11-09 | EWT | ETF | 17.0 | 17.0 | 16.4 | 16.4 | 5800.0 |
| 2001-11-09 | EWU | ETF | 29.64 | 29.9 | 29.64 | 29.9 | 8000.0 |
| 2001-11-09 | EWW | ETF | 13.59 | 13.59 | 13.4 | 13.5 | 6800.0 |
| 2001-11-09 | EWY | ETF | 14.17 | 14.34 | 14.15 | 14.34 | 4800.0 |
| 2001-11-09 | EWZ | ETF | 11.04 | 11.15 | 11.03 | 11.15 | 11300.0 |
| 2001-11-09 | EZU | ETF | 26.65 | 27.075 | 26.65 | 26.995 | 25200.0 |
| 2001-11-09 | FCTR | ETF | 17.0 | 17.15 | 16.57 | 17.1 | 40900.0 |
| 2001-11-09 | FMAR | ETF | 8.15 | 8.3 | 8.15 | 8.17 | 16200.0 |
| 2001-11-09 | GLDB | ETF | 7.51 | 7.6 | 7.42 | 7.43 | 71600.0 |
| 2001-11-09 | GRNB | ETF | 16.4428 | 16.4428 | 16.4428 | 16.4428 | 202.0 |
| 2001-11-09 | GSIG | ETF | 8.55 | 8.55 | 8.21 | 8.35 | 57600.0 |
| 2001-11-09 | IBB | ETF | 28.9333 | 28.9333 | 28.0667 | 28.5 | 1618800.0 |
| 2001-11-09 | ICF | ETF | 20.35 | 20.3975 | 20.25 | 20.2625 | 48400.0 |
| 2001-11-09 | IDU | ETF | 32.685 | 33.145 | 32.45 | 32.905 | 19000.0 |
| 2001-11-09 | IEV | ETF | 29.125 | 29.265 | 28.95 | 29.245 | 37200.0 |
| 2001-11-09 | IGLD | ETF | 92.0 | 100.0 | 89.0 | 94.0 | 1048.0 |
| 2001-11-09 | IGM | ETF | 8.1333 | 8.2133 | 8.0833 | 8.1267 | 199200.0 |
| 2001-11-09 | IGN | ETF | 30.55 | 31.15 | 30.55 | 30.85 | 12300.0 |
| 2001-11-09 | IGV | ETF | 8.2 | 8.2 | 8.16 | 8.16 | 1500.0 |
| 2001-11-09 | IJH | ETF | 9.365 | 9.407 | 9.318 | 9.379 | 243000.0 |
| 2001-11-09 | IJJ | ETF | 20.825 | 20.8875 | 20.6925 | 20.815 | 146800.0 |
| 2001-11-09 | IJK | ETF | 13.1375 | 13.1588 | 13.0812 | 13.1312 | 46400.0 |
| 2001-11-09 | IJR | ETF | 17.225 | 17.2317 | 17.1183 | 17.175 | 144600.0 |
> showing 50 of 109 rows — these rows as CSV