PREVIEW / etf_daily / 2001-03-27
file: by_date/etf_daily/2001/2001-03-27.parquet size: 8 KB rows: 96
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-03-27 | SPY | ETF | 115.62 | 118.65 | 115.28 | 118.31 | 12880700.0 |
| 2001-03-27 | QQQ | ETF | 41.8 | 43.72 | 41.42 | 43.25 | 69945300.0 |
| 2001-03-27 | IWM | ETF | 44.8 | 45.3 | 44.05 | 45.085 | 633200.0 |
| 2001-03-27 | DIA | ETF | 96.7 | 99.6 | 96.4 | 99.19 | 7042500.0 |
| 2001-03-27 | BBH | ETF | 37.0333 | 38.1667 | 36.5 | 38.1 | 3498000.0 |
| 2001-03-27 | BITS | ETF | 6.75 | 8.125 | 6.75 | 7.5 | 3025.0 |
| 2001-03-27 | CEF | ETF | 3.1 | 3.14 | 3.06 | 3.13 | 14300.0 |
| 2001-03-27 | CHB | ETF | 5.64 | 5.79 | 5.55 | 5.67 | 35000.0 |
| 2001-03-27 | CNXT | ETF | 10.44 | 10.63 | 9.81 | 10.06 | 3371150.0 |
| 2001-03-27 | CSB | ETF | 1.51999998092651 | 1.51999998092651 | 1.5 | 1.5 | 28200.0 |
| 2001-03-27 | DGT | ETF | 69.18 | 69.95 | 68.77 | 69.95 | 1300.0 |
| 2001-03-27 | EWA | ETF | 8.65 | 8.75 | 8.56 | 8.75 | 35000.0 |
| 2001-03-27 | EWC | ETF | 11.1 | 11.23 | 11.02 | 11.15 | 6600.0 |
| 2001-03-27 | EWD | ETF | 14.85 | 15.2 | 14.7 | 15.2 | 6400.0 |
| 2001-03-27 | EWG | ETF | 16.86 | 17.0 | 16.85 | 17.0 | 450400.0 |
| 2001-03-27 | EWH | ETF | 10.6 | 10.98 | 10.6 | 10.98 | 50700.0 |
| 2001-03-27 | EWI | ETF | 38.46 | 38.98 | 38.46 | 38.98 | 7550.0 |
| 2001-03-27 | EWJ | ETF | 42.96 | 44.08 | 42.8 | 44.08 | 196450.0 |
| 2001-03-27 | EWK | ETF | 11.5 | 11.5 | 11.5 | 11.5 | 5800.0 |
| 2001-03-27 | EWL | ETF | 14.1 | 14.2 | 13.83 | 14.2 | 17300.0 |
| 2001-03-27 | EWM | ETF | 19.6 | 19.8 | 19.52 | 19.52 | 10525.0 |
| 2001-03-27 | EWN | ETF | 19.95 | 20.15 | 19.7 | 20.15 | 7300.0 |
| 2001-03-27 | EWO | ETF | 8.1 | 8.1 | 8.0 | 8.0 | 1600.0 |
| 2001-03-27 | EWP | ETF | 23.0 | 23.2 | 23.0 | 23.2 | 2500.0 |
| 2001-03-27 | EWQ | ETF | 20.8 | 20.95 | 20.75 | 20.9 | 245200.0 |
| 2001-03-27 | EWS | ETF | 11.1 | 11.1 | 10.9 | 11.1 | 24650.0 |
| 2001-03-27 | EWT | ETF | 24.4 | 24.74 | 24.26 | 24.26 | 19800.0 |
| 2001-03-27 | EWU | ETF | 31.44 | 32.7 | 31.44 | 32.7 | 163300.0 |
| 2001-03-27 | EWW | ETF | 13.7 | 14.05 | 13.62 | 13.7 | 26500.0 |
| 2001-03-27 | EWY | ETF | 12.6 | 12.9 | 12.59 | 12.73 | 11200.0 |
| 2001-03-27 | EWZ | ETF | 15.43 | 15.59 | 15.43 | 15.59 | 900.0 |
| 2001-03-27 | EZU | ETF | 31.3985 | 31.7265 | 31.1485 | 31.7031 | 61200.0 |
| 2001-03-27 | FCTR | ETF | 15.0 | 15.25 | 15.0 | 15.125 | 26600.0 |
| 2001-03-27 | GLDB | ETF | 6.625 | 7.0 | 6.625 | 6.8125 | 59800.0 |
| 2001-03-27 | GSIG | ETF | 8.37 | 8.5 | 8.06 | 8.31 | 481700.0 |
| 2001-03-27 | IBB | ETF | 25.0 | 25.651 | 24.7656 | 25.651 | 48300.0 |
| 2001-03-27 | ICF | ETF | 19.4766 | 19.5312 | 19.4766 | 19.5312 | 104400.0 |
| 2001-03-27 | IDU | ETF | 39.49 | 40.005 | 39.49 | 39.875 | 4800.0 |
| 2001-03-27 | IEV | ETF | 32.615 | 32.925 | 32.225 | 32.885 | 499400.0 |
| 2001-03-27 | IGLD | ETF | 134.375 | 143.75 | 134.375 | 134.375 | 18.0 |
| 2001-03-27 | IJH | ETF | 9.193 | 9.351 | 9.163 | 9.335 | 89000.0 |
| 2001-03-27 | IJJ | ETF | 20.53 | 20.7775 | 20.3625 | 20.7125 | 163200.0 |
| 2001-03-27 | IJK | ETF | 12.85 | 13.0462 | 12.7625 | 13.0462 | 293600.0 |
| 2001-03-27 | IJR | ETF | 16.9 | 17.12 | 16.8083 | 17.1167 | 84600.0 |
| 2001-03-27 | IJS | ETF | 18.9375 | 19.135 | 18.8225 | 19.0675 | 71200.0 |
| 2001-03-27 | IJT | ETF | 17.0 | 17.185 | 16.8575 | 17.175 | 30000.0 |
| 2001-03-27 | IOO | ETF | 30.8281 | 31.5938 | 30.8281 | 31.5469 | 25000.0 |
| 2001-03-27 | IUSG | ETF | 21.11 | 21.32 | 21.105 | 21.26 | 3200.0 |
| 2001-03-27 | IUSV | ETF | 23.31 | 23.8933 | 23.31 | 23.8667 | 5700.0 |
| 2001-03-27 | IVE | ETF | 58.76 | 60.22 | 58.76 | 60.03 | 21400.0 |
> showing 50 of 96 rows — these rows as CSV