PREVIEW / etf_daily / 2001-04-24
file: by_date/etf_daily/2001/2001-04-24.parquet size: 8 KB rows: 97
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-04-24 | SPY | ETF | 122.52 | 123.65 | 121.1 | 121.58 | 10044700.0 |
| 2001-04-24 | QQQ | ETF | 45.1 | 46.42 | 43.75 | 44.3 | 88888300.0 |
| 2001-04-24 | IWM | ETF | 46.1 | 46.515 | 45.75 | 46.15 | 319200.0 |
| 2001-04-24 | DIA | ETF | 105.61 | 106.48 | 104.45 | 104.8 | 2812900.0 |
| 2001-04-24 | BBH | ETF | 39.9 | 39.9 | 38.2367 | 38.2367 | 2779200.0 |
| 2001-04-24 | BITS | ETF | 7.24 | 7.6 | 7.2 | 7.56 | 1350.0 |
| 2001-04-24 | CEF | ETF | 3.11 | 3.12 | 3.08 | 3.11 | 18300.0 |
| 2001-04-24 | CHB | ETF | 7.04 | 7.2 | 7.01 | 7.12 | 131900.0 |
| 2001-04-24 | CNXT | ETF | 9.95 | 10.88 | 9.41 | 9.58 | 4470440.0 |
| 2001-04-24 | CSB | ETF | 1.39999997615814 | 1.5 | 1.39999997615814 | 1.39999997615814 | 62700.0 |
| 2001-04-24 | DGT | ETF | 72.47 | 72.47 | 72.47 | 72.47 | 200.0 |
| 2001-04-24 | EWA | ETF | 9.25 | 9.25 | 9.15 | 9.15 | 9700.0 |
| 2001-04-24 | EWC | ETF | 11.6 | 11.75 | 11.6 | 11.7 | 7800.0 |
| 2001-04-24 | EWD | ETF | 14.1 | 14.3 | 14.1 | 14.1 | 6300.0 |
| 2001-04-24 | EWG | ETF | 17.6 | 17.76 | 17.55 | 17.65 | 69000.0 |
| 2001-04-24 | EWH | ETF | 10.68 | 10.81 | 10.63 | 10.74 | 44900.0 |
| 2001-04-24 | EWI | ETF | 40.1 | 40.48 | 40.0 | 40.0 | 6950.0 |
| 2001-04-24 | EWJ | ETF | 43.4 | 43.8 | 43.12 | 43.12 | 169475.0 |
| 2001-04-24 | EWK | ETF | 11.55 | 11.55 | 11.3 | 11.3 | 5500.0 |
| 2001-04-24 | EWL | ETF | 14.25 | 14.37 | 14.15 | 14.36 | 11400.0 |
| 2001-04-24 | EWM | ETF | 16.2 | 16.28 | 16.0 | 16.2 | 12950.0 |
| 2001-04-24 | EWN | ETF | 20.2 | 20.5 | 20.2 | 20.3 | 7500.0 |
| 2001-04-24 | EWO | ETF | 8.34 | 8.34 | 8.34 | 8.34 | 1200.0 |
| 2001-04-24 | EWP | ETF | 23.35 | 23.57 | 23.35 | 23.37 | 52800.0 |
| 2001-04-24 | EWQ | ETF | 21.55 | 21.85 | 21.46 | 21.5 | 90700.0 |
| 2001-04-24 | EWS | ETF | 10.8 | 10.98 | 10.76 | 10.8 | 26600.0 |
| 2001-04-24 | EWT | ETF | 22.6 | 22.98 | 22.6 | 22.88 | 48000.0 |
| 2001-04-24 | EWU | ETF | 33.08 | 33.34 | 32.7 | 32.98 | 36300.0 |
| 2001-04-24 | EWW | ETF | 14.4 | 14.84 | 14.4 | 14.5 | 13100.0 |
| 2001-04-24 | EWY | ETF | 13.25 | 13.6 | 13.25 | 13.5 | 3200.0 |
| 2001-04-24 | EWZ | ETF | 14.1 | 14.1 | 14.05 | 14.1 | 23400.0 |
| 2001-04-24 | EZU | ETF | 32.525 | 32.675 | 32.2 | 32.2 | 9600.0 |
| 2001-04-24 | FCTR | ETF | 15.95 | 16.07 | 15.95 | 15.97 | 60800.0 |
| 2001-04-24 | FMAR | ETF | 8.0 | 8.0 | 7.05 | 7.05 | 10800.0 |
| 2001-04-24 | GLDB | ETF | 6.97 | 7.0 | 6.96 | 6.96 | 36600.0 |
| 2001-04-24 | GSIG | ETF | 9.55 | 9.85 | 9.4 | 9.68 | 78000.0 |
| 2001-04-24 | IBB | ETF | 27.7333 | 27.8 | 26.6833 | 26.6833 | 149100.0 |
| 2001-04-24 | ICF | ETF | 19.4825 | 19.4825 | 19.3625 | 19.4625 | 1600.0 |
| 2001-04-24 | IDU | ETF | 42.29 | 42.43 | 42.09 | 42.2 | 17600.0 |
| 2001-04-24 | IEV | ETF | 33.55 | 33.815 | 33.175 | 33.4 | 122400.0 |
| 2001-04-24 | IGLD | ETF | 93.0 | 93.0 | 86.0 | 90.0 | 27.0 |
| 2001-04-24 | IGM | ETF | 10.1 | 10.1083 | 9.775 | 9.775 | 178800.0 |
| 2001-04-24 | IJH | ETF | 9.7 | 9.83 | 9.634 | 9.634 | 309000.0 |
| 2001-04-24 | IJJ | ETF | 21.4975 | 21.675 | 21.2775 | 21.355 | 46800.0 |
| 2001-04-24 | IJK | ETF | 13.795 | 13.795 | 13.4688 | 13.4688 | 236800.0 |
| 2001-04-24 | IJR | ETF | 17.4317 | 17.4733 | 17.28 | 17.2817 | 123600.0 |
| 2001-04-24 | IJS | ETF | 19.25 | 19.375 | 19.1575 | 19.1575 | 113200.0 |
| 2001-04-24 | IJT | ETF | 17.57 | 17.8475 | 17.5 | 17.5 | 173600.0 |
| 2001-04-24 | IOO | ETF | 32.4 | 32.775 | 32.075 | 32.075 | 93200.0 |
| 2001-04-24 | IUSG | ETF | 22.285 | 22.535 | 21.825 | 21.855 | 24200.0 |
> showing 50 of 97 rows — these rows as CSV