PREVIEW / etf_daily / 2002-03-18
file: by_date/etf_daily/2002/2002-03-18.parquet size: 9 KB rows: 120
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 |
|---|---|---|---|---|---|---|---|
| 2002-03-18 | SPY | ETF | 117.1 | 117.56 | 116.1 | 116.67 | 17548900.0 |
| 2002-03-18 | QQQ | ETF | 37.635 | 37.94 | 37.05 | 37.44 | 78963600.0 |
| 2002-03-18 | IWM | ETF | 49.745 | 50.18 | 49.55 | 49.905 | 1362400.0 |
| 2002-03-18 | DIA | ETF | 106.35 | 106.78 | 105.27 | 105.65 | 4856100.0 |
| 2002-03-18 | ARB | ETF | 32.35 | 33.02 | 32.35 | 32.88 | 23500.0 |
| 2002-03-18 | BBH | ETF | 42.2667 | 42.8 | 42.1733 | 42.7333 | 4703100.0 |
| 2002-03-18 | BITS | ETF | 14.0 | 14.0 | 13.4 | 13.4 | 3700.0 |
| 2002-03-18 | CEF | ETF | 3.63 | 3.74 | 3.63 | 3.72 | 16100.0 |
| 2002-03-18 | CHB | ETF | 8.2 | 8.51 | 8.2 | 8.3 | 151900.0 |
| 2002-03-18 | CNXT | ETF | 12.67 | 13.0 | 12.34 | 12.53 | 2002580.0 |
| 2002-03-18 | CSB | ETF | 4.07999992370605 | 4.07999992370605 | 4.07999992370605 | 4.07999992370605 | 900.0 |
| 2002-03-18 | DGT | ETF | 66.35 | 66.4 | 65.75 | 65.78 | 6700.0 |
| 2002-03-18 | EFA | ETF | 40.6333 | 40.6367 | 40.3867 | 40.56 | 387600.0 |
| 2002-03-18 | ELV | ETF | 28.375 | 29.225 | 28.375 | 29.15 | 923600.0 |
| 2002-03-18 | EPP | ETF | 18.9133 | 18.9133 | 18.8833 | 18.9133 | 17100.0 |
| 2002-03-18 | EWA | ETF | 9.84 | 9.85 | 9.78 | 9.84 | 5000.0 |
| 2002-03-18 | EWC | ETF | 11.27 | 11.27 | 11.24 | 11.24 | 3000.0 |
| 2002-03-18 | EWD | ETF | 13.74 | 13.74 | 13.56 | 13.64 | 3000.0 |
| 2002-03-18 | EWG | ETF | 15.7 | 15.7 | 15.49 | 15.68 | 59400.0 |
| 2002-03-18 | EWH | ETF | 9.3 | 9.34 | 9.21 | 9.23 | 35900.0 |
| 2002-03-18 | EWI | ETF | 33.12 | 33.4 | 32.98 | 33.4 | 5400.0 |
| 2002-03-18 | EWJ | ETF | 33.16 | 33.24 | 32.88 | 32.88 | 331425.0 |
| 2002-03-18 | EWK | ETF | 10.75 | 10.75 | 10.75 | 10.75 | 600.0 |
| 2002-03-18 | EWL | ETF | 13.22 | 13.29 | 13.06 | 13.13 | 11300.0 |
| 2002-03-18 | EWM | ETF | 23.68 | 23.68 | 23.32 | 23.64 | 6150.0 |
| 2002-03-18 | EWN | ETF | 18.07 | 18.1 | 17.91 | 17.97 | 12800.0 |
| 2002-03-18 | EWO | ETF | 7.93 | 7.96 | 7.93 | 7.95 | 3800.0 |
| 2002-03-18 | EWP | ETF | 20.93 | 20.93 | 20.76 | 20.76 | 200.0 |
| 2002-03-18 | EWQ | ETF | 18.9 | 18.91 | 18.71 | 18.91 | 10600.0 |
| 2002-03-18 | EWS | ETF | 11.62 | 11.68 | 11.38 | 11.38 | 32150.0 |
| 2002-03-18 | EWT | ETF | 22.96 | 22.96 | 22.42 | 22.76 | 45700.0 |
| 2002-03-18 | EWU | ETF | 29.48 | 29.72 | 29.38 | 29.44 | 28050.0 |
| 2002-03-18 | EWW | ETF | 17.65 | 17.68 | 17.51 | 17.61 | 327100.0 |
| 2002-03-18 | EWY | ETF | 22.68 | 22.7 | 22.38 | 22.44 | 99600.0 |
| 2002-03-18 | EWZ | ETF | 14.15 | 14.15 | 13.66 | 13.78 | 683100.0 |
| 2002-03-18 | EZU | ETF | 28.16 | 28.245 | 28.0 | 28.215 | 38400.0 |
| 2002-03-18 | FCTR | ETF | 18.87 | 19.49 | 18.75 | 19.44 | 25300.0 |
| 2002-03-18 | FMAR | ETF | 10.55 | 10.55 | 10.347 | 10.39 | 6400.0 |
| 2002-03-18 | GLDB | ETF | 7.885 | 8.21 | 7.885 | 8.15 | 225100.0 |
| 2002-03-18 | GRNB | ETF | 16.1974 | 16.1974 | 16.1974 | 16.1974 | 606.0 |
| 2002-03-18 | GSIG | ETF | 9.43 | 9.85 | 9.36 | 9.65 | 21000.0 |
| 2002-03-18 | IBB | ETF | 27.1333 | 27.4333 | 27.0167 | 27.2833 | 584700.0 |
| 2002-03-18 | ICF | ETF | 22.25 | 22.325 | 22.145 | 22.2975 | 71200.0 |
| 2002-03-18 | IDU | ETF | 31.75 | 32.15 | 31.55 | 32.13 | 63600.0 |
| 2002-03-18 | IEV | ETF | 29.75 | 29.975 | 29.75 | 29.935 | 133800.0 |
| 2002-03-18 | IGE | ETF | 17.1833 | 17.29 | 17.1833 | 17.1983 | 19800.0 |
| 2002-03-18 | IGLD | ETF | 126.0 | 135.0 | 126.0 | 135.0 | 139.0 |
| 2002-03-18 | IGM | ETF | 8.0083 | 8.0417 | 7.9183 | 7.9433 | 43200.0 |
| 2002-03-18 | IGN | ETF | 25.8 | 25.8 | 24.9 | 25.22 | 3600.0 |
| 2002-03-18 | IGV | ETF | 8.4 | 8.44 | 8.28 | 8.366 | 57000.0 |
> showing 50 of 120 rows — these rows as CSV