PREVIEW / etf_daily / 2002-08-09
file: by_date/etf_daily/2002/2002-08-09.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-08-09 | SPY | ETF | 90.1 | 91.94 | 89.35 | 91.29 | 41879200.0 |
| 2002-08-09 | QQQ | ETF | 23.207 | 23.717 | 22.88 | 23.33 | 93579500.0 |
| 2002-08-09 | IWM | ETF | 38.3 | 39.095 | 38.22 | 38.505 | 4054000.0 |
| 2002-08-09 | DIA | ETF | 86.55 | 88.24 | 85.82 | 87.6 | 12693100.0 |
| 2002-08-09 | TLT | ETF | 84.0 | 84.88 | 84.0 | 84.88 | 35900.0 |
| 2002-08-09 | ARB | ETF | 33.6 | 33.99 | 33.12 | 33.36 | 115800.0 |
| 2002-08-09 | BBH | ETF | 28.7 | 29.8333 | 28.59 | 29.4167 | 5212800.0 |
| 2002-08-09 | BITS | ETF | 8.8 | 8.8 | 8.8 | 8.8 | 500.0 |
| 2002-08-09 | CEF | ETF | 4.14 | 4.24 | 4.14 | 4.17 | 97200.0 |
| 2002-08-09 | CHB | ETF | 2.97 | 3.29 | 2.9 | 3.2 | 150800.0 |
| 2002-08-09 | CNXT | ETF | 1.6949 | 1.6969 | 1.5952 | 1.6151 | 2570570.0 |
| 2002-08-09 | DGT | ETF | 51.53 | 52.4 | 51.53 | 51.91 | 600.0 |
| 2002-08-09 | EFA | ETF | 34.8333 | 35.9667 | 34.8333 | 35.7 | 954000.0 |
| 2002-08-09 | ELV | ETF | 31.975 | 32.5 | 31.25 | 31.68 | 1022800.0 |
| 2002-08-09 | EPP | ETF | 17.1233 | 17.38 | 17.1 | 17.38 | 89400.0 |
| 2002-08-09 | EWA | ETF | 9.11 | 9.12 | 9.11 | 9.12 | 18700.0 |
| 2002-08-09 | EWC | ETF | 9.3 | 9.5 | 9.3 | 9.5 | 2100.0 |
| 2002-08-09 | EWD | ETF | 9.29 | 9.3 | 9.01 | 9.01 | 104000.0 |
| 2002-08-09 | EWG | ETF | 11.59 | 12.03 | 11.59 | 12.03 | 210400.0 |
| 2002-08-09 | EWH | ETF | 8.0 | 8.09 | 7.77 | 7.99 | 33400.0 |
| 2002-08-09 | EWI | ETF | 29.58 | 30.2 | 29.58 | 30.2 | 1850.0 |
| 2002-08-09 | EWJ | ETF | 31.68 | 32.0 | 31.52 | 31.84 | 162025.0 |
| 2002-08-09 | EWK | ETF | 9.96 | 10.15 | 9.96 | 10.14 | 1500.0 |
| 2002-08-09 | EWL | ETF | 11.61 | 11.91 | 11.61 | 11.85 | 12200.0 |
| 2002-08-09 | EWM | ETF | 23.32 | 23.32 | 22.96 | 23.32 | 11325.0 |
| 2002-08-09 | EWN | ETF | 14.29 | 14.3 | 14.29 | 14.3 | 5200.0 |
| 2002-08-09 | EWO | ETF | 7.98 | 8.2 | 7.98 | 8.14 | 28000.0 |
| 2002-08-09 | EWP | ETF | 17.51 | 17.8 | 17.51 | 17.8 | 2400.0 |
| 2002-08-09 | EWQ | ETF | 15.79 | 15.8 | 15.55 | 15.8 | 73400.0 |
| 2002-08-09 | EWS | ETF | 9.8 | 10.08 | 9.72 | 10.08 | 41300.0 |
| 2002-08-09 | EWT | ETF | 17.6 | 18.1 | 17.6 | 17.84 | 8600.0 |
| 2002-08-09 | EWU | ETF | 25.5 | 26.22 | 25.5 | 26.14 | 79150.0 |
| 2002-08-09 | EWW | ETF | 13.11 | 13.4 | 13.09 | 13.22 | 186000.0 |
| 2002-08-09 | EWY | ETF | 19.8 | 19.95 | 19.56 | 19.71 | 48700.0 |
| 2002-08-09 | EWZ | ETF | 8.39 | 8.39 | 8.06 | 8.15 | 129300.0 |
| 2002-08-09 | EZU | ETF | 22.5 | 23.2 | 22.48 | 23.055 | 67400.0 |
| 2002-08-09 | FCTR | ETF | 16.299 | 16.48 | 16.17 | 16.38 | 57400.0 |
| 2002-08-09 | FMAR | ETF | 10.49 | 10.5 | 10.49 | 10.5 | 900.0 |
| 2002-08-09 | GLDB | ETF | 10.09 | 10.25 | 9.99 | 10.2 | 52700.0 |
| 2002-08-09 | GSIG | ETF | 6.54 | 6.7 | 6.54 | 6.67 | 38100.0 |
| 2002-08-09 | IBB | ETF | 17.3467 | 18.0 | 17.0533 | 17.7333 | 4188600.0 |
| 2002-08-09 | ICF | ETF | 20.9625 | 21.0725 | 20.815 | 21.0475 | 160800.0 |
| 2002-08-09 | IDU | ETF | 25.55 | 26.035 | 25.355 | 25.73 | 238600.0 |
| 2002-08-09 | IEF | ETF | 83.32 | 83.88 | 83.32 | 83.83 | 99600.0 |
| 2002-08-09 | IEV | ETF | 24.8 | 25.525 | 24.65 | 25.495 | 147200.0 |
| 2002-08-09 | IGE | ETF | 13.6667 | 13.9 | 13.6667 | 13.9 | 22200.0 |
| 2002-08-09 | IGLD | ETF | 98.0 | 100.0 | 96.0 | 96.0 | 98.0 |
| 2002-08-09 | IGM | ETF | 4.85 | 4.9283 | 4.8417 | 4.9017 | 13800.0 |
| 2002-08-09 | IGN | ETF | 12.36 | 12.36 | 12.36 | 12.36 | 500.0 |
| 2002-08-09 | IGV | ETF | 4.54 | 4.66 | 4.504 | 4.636 | 55500.0 |
> showing 50 of 120 rows — these rows as CSV