PREVIEW / etf_daily / 2010-03-30
file: by_date/etf_daily/2010/2010-03-30.parquet size: 32 KB rows: 729
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-30 | SPY | ETF | 117.46 | 117.83 | 116.91 | 117.4 | 145772500.0 |
| 2010-03-30 | QQQ | ETF | 48.36 | 48.55 | 48.06 | 48.39 | 49455022.0 |
| 2010-03-30 | IWM | ETF | 68.29 | 68.74 | 67.87 | 68.39 | 35773100.0 |
| 2010-03-30 | DIA | ETF | 109.01 | 109.38 | 108.67 | 109.13 | 5781300.0 |
| 2010-03-30 | GLD | ETF | 108.57 | 108.66 | 107.87 | 107.97 | 9817700.0 |
| 2010-03-30 | TLT | ETF | 88.52 | 88.95 | 88.27 | 88.89 | 3254600.0 |
| 2010-03-30 | AAXJ | ETF | 57.15 | 57.24 | 56.73 | 57.11 | 74600.0 |
| 2010-03-30 | ACWI | ETF | 43.61 | 43.81 | 43.53 | 43.68 | 175100.0 |
| 2010-03-30 | ACWX | ETF | 41.75 | 41.89 | 41.54 | 41.72 | 30795.0 |
| 2010-03-30 | ADRE | ETF | 43.9 | 44.05 | 43.69 | 43.95 | 83310.0 |
| 2010-03-30 | AFK | ETF | 31.55 | 31.76 | 31.44 | 31.5 | 12996.0 |
| 2010-03-30 | AGG | ETF | 104.12 | 104.2 | 104.02 | 104.14 | 460500.0 |
| 2010-03-30 | AGQ | ETF | 114.14 | 114.48 | 112.42 | 113.42 | 155750.0 |
| 2010-03-30 | AGZ | ETF | 108.15 | 108.15 | 108.005 | 108.1 | 12767.0 |
| 2010-03-30 | AIA | ETF | 40.55 | 40.65 | 40.26 | 40.62 | 30448.0 |
| 2010-03-30 | AIQ | ETF | 29.25 | 29.7755 | 28.55 | 29.2 | 30516.0 |
| 2010-03-30 | AIS | ETF | 1.4 | 1.41 | 1.35 | 1.37 | 175414.0 |
| 2010-03-30 | AIVI | ETF | 42.57 | 42.61 | 42.34 | 42.47 | 15800.0 |
| 2010-03-30 | AMJ | ETF | 30.04 | 30.27 | 29.98 | 30.24 | 615250.0 |
| 2010-03-30 | AOA | ETF | 31.63 | 31.63 | 31.4 | 31.54 | 5900.0 |
| 2010-03-30 | AOK | ETF | 27.87 | 27.88 | 27.7701 | 27.87 | 10057.0 |
| 2010-03-30 | AOM | ETF | 28.75 | 28.77 | 28.66 | 28.73 | 9255.0 |
| 2010-03-30 | AOR | ETF | 29.78 | 29.84 | 29.68 | 29.77 | 14586.0 |
| 2010-03-30 | ARB | ETF | 26.61 | 26.92 | 26.28 | 26.56 | 294438.0 |
| 2010-03-30 | BAB | ETF | 24.85 | 24.88 | 24.77 | 24.88 | 190581.0 |
| 2010-03-30 | BAL | ETF | 38.58 | 38.7 | 38.244 | 38.35 | 7053.0 |
| 2010-03-30 | BALT | ETF | 13.7 | 13.8 | 13.6 | 13.7 | 166565.0 |
| 2010-03-30 | BBH | ETF | 34.6033 | 34.62 | 34.3467 | 34.57 | 75900.0 |
| 2010-03-30 | BIL | ETF | 91.7 | 91.72 | 91.68 | 91.68 | 231300.0 |
| 2010-03-30 | BITS | ETF | 32.72 | 32.84 | 32.04 | 32.48 | 675.0 |
| 2010-03-30 | BIV | ETF | 79.93 | 80.15 | 79.86 | 80.15 | 83100.0 |
| 2010-03-30 | BJK | ETF | 25.99 | 25.99 | 25.63 | 25.66 | 56300.0 |
| 2010-03-30 | BKF | ETF | 46.5 | 46.56 | 46.1777 | 46.4 | 120335.0 |
| 2010-03-30 | BLV | ETF | 76.45 | 76.52 | 76.11 | 76.52 | 20600.0 |
| 2010-03-30 | BMVP | ETF | 13.207 | 13.24 | 13.173 | 13.225 | 14556.0 |
| 2010-03-30 | BND | ETF | 79.09 | 79.14 | 78.98 | 79.13 | 465600.0 |
| 2010-03-30 | BNE | ETF | 11.27 | 11.28 | 11.16 | 11.17 | 880698.0 |
| 2010-03-30 | BRF | ETF | 45.52 | 45.7 | 45.09 | 45.32 | 262046.0 |
| 2010-03-30 | BSV | ETF | 79.98 | 79.99 | 79.87 | 79.96 | 402700.0 |
| 2010-03-30 | BTF | ETF | 74.64999999999999 | 74.64999999999999 | 73.94999999999999 | 74.3 | 10298.0 |
| 2010-03-30 | BWX | ETF | 28.035 | 28.035 | 27.83 | 27.875 | 240224.0 |
| 2010-03-30 | BWZ | ETF | 35.3485 | 35.45 | 35.3485 | 35.428 | 22845.0 |
| 2010-03-30 | BZQ | ETF | 3648.0 | 3721.6 | 3572.8 | 3675.2 | 616.0 |
| 2010-03-30 | CEF | ETF | 13.92 | 13.98 | 13.8 | 13.81 | 611900.0 |
| 2010-03-30 | CEW | ETF | 22.14 | 22.14 | 22.076 | 22.1 | 102064.0 |
| 2010-03-30 | CGO | ETF | 14.81 | 15.0 | 14.77 | 14.8401 | 17408.0 |
| 2010-03-30 | CGW | ETF | 18.59 | 18.59 | 18.39 | 18.5 | 85544.0 |
| 2010-03-30 | CHI | ETF | 12.62 | 12.7 | 12.5301 | 12.58 | 123146.0 |
| 2010-03-30 | CHIE | ETF | 14.63 | 14.78 | 14.63 | 14.75 | 7850.0 |
| 2010-03-30 | CHII | ETF | 15.34 | 15.4099 | 15.29 | 15.4 | 27875.0 |
> showing 50 of 729 rows — these rows as CSV