PREVIEW / etf_daily / 2002-03-20
file: by_date/etf_daily/2002/2002-03-20.parquet size: 9 KB rows: 121
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-20 | SPY | ETF | 116.5 | 116.58 | 115.19 | 115.24 | 17114500.0 |
| 2002-03-20 | QQQ | ETF | 36.879 | 37.08 | 36.04 | 36.06 | 61839900.0 |
| 2002-03-20 | IWM | ETF | 49.975 | 50.025 | 49.425 | 49.435 | 1805600.0 |
| 2002-03-20 | DIA | ETF | 105.93 | 105.93 | 104.93 | 104.94 | 5363300.0 |
| 2002-03-20 | ARB | ETF | 33.25 | 33.4 | 32.25 | 32.26 | 34600.0 |
| 2002-03-20 | BBH | ETF | 42.1667 | 42.2967 | 41.4167 | 41.4167 | 3333000.0 |
| 2002-03-20 | BITS | ETF | 13.52 | 15.6 | 13.4 | 15.0 | 1550.0 |
| 2002-03-20 | BOSS | ETF | 24.0 | 24.0 | 24.0 | 24.0 | 100.0 |
| 2002-03-20 | CEF | ETF | 3.63 | 3.75 | 3.63 | 3.66 | 6100.0 |
| 2002-03-20 | CHB | ETF | 8.51 | 8.51 | 8.25 | 8.45 | 558400.0 |
| 2002-03-20 | CNXT | ETF | 12.08 | 12.09 | 11.37 | 11.41 | 3139700.0 |
| 2002-03-20 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 14100.0 |
| 2002-03-20 | DGT | ETF | 65.7 | 65.7 | 65.03 | 65.03 | 2800.0 |
| 2002-03-20 | EFA | ETF | 40.4833 | 40.4833 | 40.24 | 40.24 | 295500.0 |
| 2002-03-20 | ELV | ETF | 28.15 | 28.37 | 27.875 | 28.2 | 472500.0 |
| 2002-03-20 | EPP | ETF | 19.0933 | 19.1167 | 19.0033 | 19.0633 | 17100.0 |
| 2002-03-20 | EWA | ETF | 9.9 | 10.0 | 9.9 | 9.9 | 71000.0 |
| 2002-03-20 | EWC | ETF | 11.28 | 11.34 | 11.28 | 11.34 | 2100.0 |
| 2002-03-20 | EWG | ETF | 15.52 | 15.52 | 15.37 | 15.4 | 71500.0 |
| 2002-03-20 | EWH | ETF | 9.11 | 9.24 | 9.04 | 9.15 | 45200.0 |
| 2002-03-20 | EWI | ETF | 33.14 | 33.14 | 33.14 | 33.14 | 900.0 |
| 2002-03-20 | EWJ | ETF | 33.08 | 33.08 | 32.84 | 32.84 | 64600.0 |
| 2002-03-20 | EWK | ETF | 10.82 | 10.83 | 10.82 | 10.83 | 3800.0 |
| 2002-03-20 | EWL | ETF | 13.07 | 13.24 | 13.07 | 13.24 | 6700.0 |
| 2002-03-20 | EWM | ETF | 23.4 | 23.72 | 23.4 | 23.6 | 5625.0 |
| 2002-03-20 | EWN | ETF | 18.09 | 18.09 | 17.86 | 17.99 | 1900.0 |
| 2002-03-20 | EWO | ETF | 7.96 | 7.96 | 7.96 | 7.96 | 200.0 |
| 2002-03-20 | EWP | ETF | 20.9 | 21.04 | 20.9 | 21.04 | 300.0 |
| 2002-03-20 | EWQ | ETF | 18.67 | 18.8 | 18.61 | 18.75 | 4100.0 |
| 2002-03-20 | EWS | ETF | 11.68 | 11.68 | 11.5 | 11.6 | 12150.0 |
| 2002-03-20 | EWT | ETF | 23.22 | 23.48 | 22.92 | 23.02 | 45600.0 |
| 2002-03-20 | EWU | ETF | 29.46 | 29.6 | 29.22 | 29.5 | 26950.0 |
| 2002-03-20 | EWW | ETF | 17.97 | 18.1 | 17.72 | 17.79 | 449300.0 |
| 2002-03-20 | EWY | ETF | 23.15 | 23.19 | 22.3 | 22.3 | 181200.0 |
| 2002-03-20 | EWZ | ETF | 13.67 | 13.67 | 13.2 | 13.31 | 1243300.0 |
| 2002-03-20 | EZU | ETF | 27.95 | 28.005 | 27.82 | 27.875 | 39000.0 |
| 2002-03-20 | FCTR | ETF | 19.3 | 19.33 | 18.8 | 18.8 | 21400.0 |
| 2002-03-20 | FMAR | ETF | 9.65 | 10.0 | 9.65 | 9.75 | 1700.0 |
| 2002-03-20 | GLDB | ETF | 8.18 | 8.4 | 8.1 | 8.3 | 167800.0 |
| 2002-03-20 | GRNB | ETF | 15.8538 | 15.8538 | 15.7065 | 15.8538 | 2019.0 |
| 2002-03-20 | GSIG | ETF | 9.43 | 9.7 | 9.43 | 9.7 | 9900.0 |
| 2002-03-20 | IBB | ETF | 27.1667 | 27.1667 | 26.6333 | 26.6667 | 566400.0 |
| 2002-03-20 | ICF | ETF | 22.2375 | 22.33 | 22.2375 | 22.3225 | 15200.0 |
| 2002-03-20 | IDU | ETF | 32.075 | 32.35 | 31.8 | 32.195 | 74000.0 |
| 2002-03-20 | IEV | ETF | 29.665 | 29.85 | 29.59 | 29.71 | 48000.0 |
| 2002-03-20 | IGE | ETF | 17.35 | 17.4417 | 17.3333 | 17.4417 | 4200.0 |
| 2002-03-20 | IGLD | ETF | 127.0 | 130.0 | 117.0 | 130.0 | 100.0 |
| 2002-03-20 | IGM | ETF | 7.875 | 7.875 | 7.7167 | 7.7167 | 88200.0 |
| 2002-03-20 | IGN | ETF | 24.3 | 24.3 | 23.76 | 23.76 | 24500.0 |
| 2002-03-20 | IGV | ETF | 8.35 | 8.35 | 8.164 | 8.164 | 26500.0 |
> showing 50 of 121 rows — these rows as CSV