PREVIEW / etf_daily / 2001-10-10
file: by_date/etf_daily/2001/2001-10-10.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-10 | SPY | ETF | 105.8 | 108.55 | 105.52 | 108.32 | 19987400.0 |
| 2001-10-10 | QQQ | ETF | 30.871 | 32.54 | 30.751 | 32.5 | 73844600.0 |
| 2001-10-10 | IWM | ETF | 40.55 | 42.0 | 40.55 | 42.0 | 638600.0 |
| 2001-10-10 | DIA | ETF | 90.2 | 92.79 | 90.07 | 92.55 | 6862500.0 |
| 2001-10-10 | BBH | ETF | 37.1667 | 38.45 | 37.1667 | 38.45 | 4740300.0 |
| 2001-10-10 | BITS | ETF | 14.52 | 15.48 | 14.2 | 14.2 | 2100.0 |
| 2001-10-10 | CEF | ETF | 3.55 | 3.55 | 3.45 | 3.46 | 30300.0 |
| 2001-10-10 | CHB | ETF | 8.15 | 9.1 | 8.1 | 9.1 | 172500.0 |
| 2001-10-10 | CNXT | ETF | 8.43 | 9.65 | 8.43 | 9.55 | 4064400.0 |
| 2001-10-10 | DGT | ETF | 63.85 | 64.4 | 63.85 | 64.4 | 2100.0 |
| 2001-10-10 | EFA | ETF | 38.5 | 38.8667 | 38.5 | 38.8 | 84600.0 |
| 2001-10-10 | EWA | ETF | 8.45 | 8.5 | 8.45 | 8.5 | 16600.0 |
| 2001-10-10 | EWC | ETF | 9.75 | 10.15 | 9.75 | 10.15 | 400.0 |
| 2001-10-10 | EWD | ETF | 11.35 | 11.35 | 11.34 | 11.34 | 4400.0 |
| 2001-10-10 | EWG | ETF | 13.2 | 13.54 | 13.2 | 13.41 | 48500.0 |
| 2001-10-10 | EWH | ETF | 8.09 | 8.27 | 8.09 | 8.25 | 13000.0 |
| 2001-10-10 | EWI | ETF | 31.1 | 31.78 | 31.1 | 31.78 | 1900.0 |
| 2001-10-10 | EWJ | ETF | 33.48 | 33.92 | 33.4 | 33.88 | 183550.0 |
| 2001-10-10 | EWK | ETF | 10.8 | 11.15 | 10.8 | 11.0 | 6100.0 |
| 2001-10-10 | EWL | ETF | 12.02 | 12.17 | 11.92 | 12.17 | 159300.0 |
| 2001-10-10 | EWM | ETF | 17.4 | 17.4 | 17.24 | 17.32 | 14125.0 |
| 2001-10-10 | EWN | ETF | 16.25 | 16.55 | 16.25 | 16.55 | 6200.0 |
| 2001-10-10 | EWO | ETF | 7.06 | 7.06 | 7.06 | 7.06 | 100.0 |
| 2001-10-10 | EWP | ETF | 18.8 | 19.0 | 18.66 | 19.0 | 3400.0 |
| 2001-10-10 | EWQ | ETF | 17.4 | 18.0 | 17.4 | 18.0 | 31400.0 |
| 2001-10-10 | EWS | ETF | 8.72 | 8.86 | 8.72 | 8.72 | 6150.0 |
| 2001-10-10 | EWT | ETF | 14.0 | 14.14 | 13.52 | 14.14 | 104200.0 |
| 2001-10-10 | EWU | ETF | 28.2 | 29.3 | 28.2 | 29.3 | 407450.0 |
| 2001-10-10 | EWW | ETF | 13.2 | 13.37 | 13.15 | 13.37 | 57600.0 |
| 2001-10-10 | EWY | ETF | 11.64 | 11.8 | 11.22 | 11.8 | 9600.0 |
| 2001-10-10 | EWZ | ETF | 8.57 | 9.14 | 8.57 | 8.88 | 400.0 |
| 2001-10-10 | EZU | ETF | 25.34 | 26.125 | 25.34 | 26.125 | 502600.0 |
| 2001-10-10 | FCTR | ETF | 16.04 | 16.55 | 15.9 | 16.15 | 48700.0 |
| 2001-10-10 | FMAR | ETF | 7.51 | 8.0 | 7.51 | 7.76 | 24300.0 |
| 2001-10-10 | GLDB | ETF | 7.46 | 7.61 | 7.4 | 7.6 | 100200.0 |
| 2001-10-10 | GSIG | ETF | 7.22 | 7.23 | 7.15 | 7.2 | 188700.0 |
| 2001-10-10 | IBB | ETF | 25.4 | 26.55 | 25.3667 | 26.5333 | 285900.0 |
| 2001-10-10 | ICF | ETF | 20.275 | 20.425 | 20.24 | 20.425 | 34800.0 |
| 2001-10-10 | IDU | ETF | 34.225 | 34.445 | 34.17 | 34.44 | 3600.0 |
| 2001-10-10 | IEV | ETF | 27.5 | 28.55 | 27.5 | 28.55 | 90400.0 |
| 2001-10-10 | IGLD | ETF | 70.0 | 73.0 | 67.0 | 73.0 | 99.0 |
| 2001-10-10 | IGM | ETF | 6.7083 | 6.915 | 6.7 | 6.8983 | 10800.0 |
| 2001-10-10 | IGN | ETF | 26.0 | 26.24 | 26.0 | 26.0 | 3000.0 |
| 2001-10-10 | IGV | ETF | 6.97 | 6.99 | 6.912 | 6.978 | 51500.0 |
| 2001-10-10 | IJH | ETF | 8.724 | 8.97 | 8.724 | 8.97 | 348000.0 |
| 2001-10-10 | IJJ | ETF | 19.9375 | 20.3125 | 19.88 | 20.31 | 654400.0 |
| 2001-10-10 | IJK | ETF | 11.875 | 12.2775 | 11.875 | 12.2775 | 78400.0 |
| 2001-10-10 | IJR | ETF | 16.0267 | 16.5667 | 16.0267 | 16.52 | 659400.0 |
| 2001-10-10 | IJS | ETF | 17.775 | 18.1525 | 17.775 | 18.1525 | 32800.0 |
| 2001-10-10 | IJT | ETF | 16.5575 | 16.8575 | 16.5575 | 16.8575 | 34000.0 |
> showing 50 of 106 rows — these rows as CSV