PREVIEW / etf_daily / 2001-10-11
file: by_date/etf_daily/2001/2001-10-11.parquet size: 9 KB rows: 106
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-10-11 | SPY | ETF | 108.95 | 110.3 | 108.95 | 110.0 | 23006300.0 |
| 2001-10-11 | QQQ | ETF | 33.192 | 35.25 | 33.14 | 34.7 | 117265300.0 |
| 2001-10-11 | IWM | ETF | 42.5 | 43.2 | 42.5 | 42.675 | 1523400.0 |
| 2001-10-11 | DIA | ETF | 93.1 | 94.55 | 92.95 | 94.2 | 14720200.0 |
| 2001-10-11 | BBH | ETF | 39.9667 | 40.4167 | 39.7167 | 40.4 | 3975000.0 |
| 2001-10-11 | BITS | ETF | 14.04 | 14.72 | 14.0 | 14.4 | 2850.0 |
| 2001-10-11 | CEF | ETF | 3.45 | 3.45 | 3.4 | 3.41 | 30000.0 |
| 2001-10-11 | CHB | ETF | 9.1 | 9.46 | 9.05 | 9.35 | 71300.0 |
| 2001-10-11 | CNXT | ETF | 9.81 | 10.31 | 9.47 | 10.0 | 5082500.0 |
| 2001-10-11 | DGT | ETF | 64.46 | 64.46 | 64.46 | 64.46 | 1000.0 |
| 2001-10-11 | EFA | ETF | 39.2167 | 39.3133 | 38.8333 | 39.0667 | 197400.0 |
| 2001-10-11 | EWA | ETF | 8.62 | 8.65 | 8.5 | 8.65 | 21700.0 |
| 2001-10-11 | EWC | ETF | 10.0 | 10.0 | 10.0 | 10.0 | 1500.0 |
| 2001-10-11 | EWG | ETF | 13.55 | 13.64 | 13.35 | 13.6 | 39500.0 |
| 2001-10-11 | EWH | ETF | 8.35 | 8.42 | 8.21 | 8.3 | 71000.0 |
| 2001-10-11 | EWI | ETF | 31.42 | 31.42 | 31.4 | 31.4 | 9850.0 |
| 2001-10-11 | EWJ | ETF | 34.4 | 34.72 | 34.24 | 34.6 | 114800.0 |
| 2001-10-11 | EWK | ETF | 11.09 | 11.09 | 11.09 | 11.09 | 100.0 |
| 2001-10-11 | EWL | ETF | 12.28 | 12.28 | 12.05 | 12.24 | 4200.0 |
| 2001-10-11 | EWM | ETF | 17.76 | 17.76 | 17.28 | 17.72 | 2500.0 |
| 2001-10-11 | EWN | ETF | 16.76 | 16.94 | 16.76 | 16.94 | 200.0 |
| 2001-10-11 | EWP | ETF | 18.91 | 18.91 | 18.78 | 18.78 | 5100.0 |
| 2001-10-11 | EWQ | ETF | 18.05 | 18.15 | 17.71 | 17.75 | 47700.0 |
| 2001-10-11 | EWS | ETF | 8.96 | 9.0 | 8.9 | 9.0 | 4450.0 |
| 2001-10-11 | EWT | ETF | 14.82 | 15.48 | 14.82 | 15.14 | 110100.0 |
| 2001-10-11 | EWU | ETF | 29.6 | 29.74 | 28.7 | 29.04 | 26250.0 |
| 2001-10-11 | EWW | ETF | 13.55 | 13.89 | 13.55 | 13.8 | 9200.0 |
| 2001-10-11 | EWY | ETF | 12.36 | 12.36 | 12.3 | 12.3 | 1500.0 |
| 2001-10-11 | EWZ | ETF | 9.17 | 9.21 | 9.17 | 9.21 | 3100.0 |
| 2001-10-11 | EZU | ETF | 26.475 | 26.475 | 25.875 | 26.175 | 8400.0 |
| 2001-10-11 | FCTR | ETF | 16.15 | 16.3 | 16.0 | 16.24 | 32000.0 |
| 2001-10-11 | FMAR | ETF | 7.95 | 8.11 | 7.76 | 8.0 | 87100.0 |
| 2001-10-11 | GLDB | ETF | 7.5 | 7.68 | 7.45 | 7.6 | 145600.0 |
| 2001-10-11 | GRNB | ETF | 16.6882 | 16.6882 | 16.6882 | 16.6882 | 1009.0 |
| 2001-10-11 | GSIG | ETF | 7.2 | 7.29 | 7.2 | 7.26 | 103200.0 |
| 2001-10-11 | IBB | ETF | 27.4667 | 27.8867 | 27.4667 | 27.77 | 127200.0 |
| 2001-10-11 | ICF | ETF | 20.5125 | 20.6875 | 20.5125 | 20.65 | 50000.0 |
| 2001-10-11 | IDU | ETF | 34.825 | 34.96 | 34.775 | 34.775 | 4800.0 |
| 2001-10-11 | IEV | ETF | 28.65 | 28.725 | 28.05 | 28.385 | 103400.0 |
| 2001-10-11 | IGLD | ETF | 71.0 | 71.0 | 70.0 | 70.0 | 35.0 |
| 2001-10-11 | IGM | ETF | 7.2917 | 7.465 | 7.2917 | 7.465 | 31800.0 |
| 2001-10-11 | IGN | ETF | 27.5 | 28.75 | 27.5 | 28.75 | 11400.0 |
| 2001-10-11 | IGV | ETF | 7.24 | 7.53 | 7.24 | 7.508 | 32500.0 |
| 2001-10-11 | IJH | ETF | 9.172 | 9.214 | 9.12 | 9.171 | 464000.0 |
| 2001-10-11 | IJJ | ETF | 20.5 | 20.85 | 20.5 | 20.72 | 67200.0 |
| 2001-10-11 | IJK | ETF | 12.5625 | 12.635 | 12.4588 | 12.5162 | 32000.0 |
| 2001-10-11 | IJR | ETF | 16.8167 | 17.0217 | 16.8167 | 16.96 | 1490400.0 |
| 2001-10-11 | IJS | ETF | 18.4375 | 18.795 | 18.4375 | 18.725 | 144400.0 |
| 2001-10-11 | IJT | ETF | 17.0625 | 17.3975 | 17.0625 | 17.2475 | 48000.0 |
| 2001-10-11 | IOO | ETF | 28.35 | 28.425 | 28.2 | 28.36 | 53400.0 |
> showing 50 of 106 rows — these rows as CSV