PREVIEW / etf_daily / 2001-09-07
file: by_date/etf_daily/2001/2001-09-07.parquet size: 9 KB rows: 108
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-09-07 | SPY | ETF | 110.02 | 111.25 | 108.63 | 108.72 | 33133900.0 |
| 2001-09-07 | QQQ | ETF | 33.621 | 35.1 | 33.35 | 33.7 | 95531000.0 |
| 2001-09-07 | IWM | ETF | 44.65 | 45.05 | 44.085 | 44.265 | 4950200.0 |
| 2001-09-07 | DIA | ETF | 97.61 | 98.23 | 95.7 | 95.85 | 10479200.0 |
| 2001-09-07 | BBH | ETF | 40.0833 | 40.3833 | 39.39 | 39.9 | 5063100.0 |
| 2001-09-07 | BITS | ETF | 11.6 | 12.6 | 10.76 | 12.4 | 8850.0 |
| 2001-09-07 | CEF | ETF | 3.2 | 3.24 | 3.19 | 3.2 | 17200.0 |
| 2001-09-07 | CHB | ETF | 9.95 | 10.0 | 8.95 | 9.05 | 371900.0 |
| 2001-09-07 | CNXT | ETF | 9.9 | 10.55 | 9.82 | 10.45 | 3101700.0 |
| 2001-09-07 | CSB | ETF | 3.75 | 3.75 | 3.45000004768372 | 3.45000004768372 | 200.0 |
| 2001-09-07 | DGT | ETF | 63.15 | 63.15 | 62.4 | 62.77 | 500.0 |
| 2001-09-07 | EFA | ETF | 39.4667 | 39.4667 | 39.1667 | 39.3 | 99900.0 |
| 2001-09-07 | EWA | ETF | 9.05 | 9.06 | 9.02 | 9.05 | 11500.0 |
| 2001-09-07 | EWC | ETF | 10.62 | 10.62 | 10.62 | 10.62 | 8600.0 |
| 2001-09-07 | EWD | ETF | 11.75 | 11.75 | 11.6 | 11.6 | 500.0 |
| 2001-09-07 | EWG | ETF | 13.85 | 14.0 | 13.7 | 13.84 | 27300.0 |
| 2001-09-07 | EWH | ETF | 8.33 | 8.38 | 8.11 | 8.21 | 48400.0 |
| 2001-09-07 | EWI | ETF | 32.6 | 33.1 | 32.6 | 33.08 | 1400.0 |
| 2001-09-07 | EWJ | ETF | 34.6 | 35.04 | 34.48 | 34.6 | 123600.0 |
| 2001-09-07 | EWK | ETF | 11.06 | 11.06 | 11.03 | 11.06 | 1200.0 |
| 2001-09-07 | EWL | ETF | 12.4 | 12.45 | 12.21 | 12.21 | 52600.0 |
| 2001-09-07 | EWM | ETF | 19.92 | 20.32 | 19.92 | 20.2 | 17950.0 |
| 2001-09-07 | EWN | ETF | 17.05 | 17.11 | 17.05 | 17.11 | 900.0 |
| 2001-09-07 | EWO | ETF | 7.93 | 7.93 | 7.93 | 7.93 | 4900.0 |
| 2001-09-07 | EWP | ETF | 19.5 | 19.55 | 19.5 | 19.55 | 4600.0 |
| 2001-09-07 | EWQ | ETF | 18.45 | 18.45 | 18.2 | 18.25 | 8600.0 |
| 2001-09-07 | EWS | ETF | 10.26 | 10.3 | 10.04 | 10.16 | 14400.0 |
| 2001-09-07 | EWT | ETF | 17.5 | 17.5 | 17.2 | 17.24 | 1150.0 |
| 2001-09-07 | EWU | ETF | 28.98 | 29.24 | 28.78 | 28.8 | 20700.0 |
| 2001-09-07 | EWW | ETF | 13.75 | 14.05 | 13.65 | 13.91 | 19700.0 |
| 2001-09-07 | EWY | ETF | 13.3 | 13.54 | 13.2 | 13.21 | 4400.0 |
| 2001-09-07 | EWZ | ETF | 10.8 | 10.81 | 10.79 | 10.79 | 52400.0 |
| 2001-09-07 | EZU | ETF | 26.2 | 26.525 | 26.2 | 26.255 | 23200.0 |
| 2001-09-07 | FCTR | ETF | 16.9 | 16.9 | 16.35 | 16.4 | 27100.0 |
| 2001-09-07 | FMAR | ETF | 9.1 | 9.45 | 8.85 | 9.0 | 2800.0 |
| 2001-09-07 | GLDB | ETF | 7.55 | 7.65 | 7.39 | 7.49 | 55000.0 |
| 2001-09-07 | GRNB | ETF | 18.6514 | 18.6514 | 18.6514 | 18.6514 | 202.0 |
| 2001-09-07 | GSIG | ETF | 8.13 | 8.18 | 7.94 | 8.1 | 165300.0 |
| 2001-09-07 | IBB | ETF | 28.4167 | 28.4167 | 27.7 | 28.0667 | 1167600.0 |
| 2001-09-07 | ICF | ETF | 21.4125 | 21.4125 | 21.1375 | 21.2575 | 225200.0 |
| 2001-09-07 | IDU | ETF | 36.075 | 36.55 | 36.075 | 36.315 | 18400.0 |
| 2001-09-07 | IEV | ETF | 28.3 | 28.675 | 28.075 | 28.105 | 121600.0 |
| 2001-09-07 | IGLD | ETF | 62.0 | 65.0 | 62.0 | 62.0 | 56.0 |
| 2001-09-07 | IGM | ETF | 7.2 | 7.325 | 7.1417 | 7.1417 | 72000.0 |
| 2001-09-07 | IGN | ETF | 26.6 | 27.05 | 26.6 | 27.05 | 8100.0 |
| 2001-09-07 | IGV | ETF | 7.09 | 7.178 | 7.09 | 7.178 | 27500.0 |
| 2001-09-07 | IJH | ETF | 9.505 | 9.533 | 9.362 | 9.421 | 211000.0 |
| 2001-09-07 | IJJ | ETF | 21.625 | 21.685 | 21.3525 | 21.375 | 87200.0 |
| 2001-09-07 | IJK | ETF | 12.8312 | 12.9525 | 12.7925 | 12.8438 | 88800.0 |
| 2001-09-07 | IJR | ETF | 17.825 | 17.9083 | 17.56 | 17.6533 | 604800.0 |
> showing 50 of 108 rows — these rows as CSV