PREVIEW / etf_daily / 2009-11-24
file: by_date/etf_daily/2009/2009-11-24.parquet size: 30 KB rows: 696
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-24 | SPY | ETF | 111.0 | 111.2 | 110.01 | 110.99 | 138420100.0 |
| 2009-11-24 | QQQ | ETF | 44.14 | 44.15 | 43.73 | 43.99 | 60669943.0 |
| 2009-11-24 | IWM | ETF | 59.62 | 59.63 | 58.62 | 59.34 | 45238000.0 |
| 2009-11-24 | DIA | ETF | 104.44 | 104.56 | 103.59 | 104.36 | 10211800.0 |
| 2009-11-24 | GLD | ETF | 114.73 | 114.81 | 113.97 | 114.73 | 22618000.0 |
| 2009-11-24 | TLT | ETF | 95.11 | 95.7 | 94.99 | 95.6 | 2895200.0 |
| 2009-11-24 | AAXJ | ETF | 55.37 | 55.73 | 55.05 | 55.73 | 925400.0 |
| 2009-11-24 | ACWI | ETF | 42.54 | 42.54 | 41.95 | 42.35 | 295100.0 |
| 2009-11-24 | ACWX | ETF | 41.35 | 41.35 | 40.89 | 41.16 | 42507.0 |
| 2009-11-24 | ADRE | ETF | 44.68 | 44.68 | 44.03 | 44.55 | 216388.0 |
| 2009-11-24 | AFK | ETF | 28.7 | 28.8 | 28.6864 | 28.78 | 7832.0 |
| 2009-11-24 | AGG | ETF | 105.26 | 105.46 | 105.03 | 105.46 | 508000.0 |
| 2009-11-24 | AGQ | ETF | 139.18 | 139.18 | 135.12 | 138.44 | 284550.0 |
| 2009-11-24 | AGZ | ETF | 109.0 | 109.11 | 108.74 | 108.915 | 63612.0 |
| 2009-11-24 | AIA | ETF | 39.91 | 39.91 | 39.5536 | 39.77 | 32169.0 |
| 2009-11-24 | AIQ | ETF | 29.0 | 30.6 | 28.8985 | 30.0 | 98615.0 |
| 2009-11-24 | AIS | ETF | 1.15 | 1.15 | 1.1 | 1.13 | 354027.0 |
| 2009-11-24 | AIVI | ETF | 44.57 | 44.6 | 44.12 | 44.39 | 27900.0 |
| 2009-11-24 | AMJ | ETF | 26.79 | 27.0 | 26.7023 | 27.0 | 252676.0 |
| 2009-11-24 | AOA | ETF | 29.63 | 29.66 | 29.6 | 29.65 | 50600.0 |
| 2009-11-24 | AOK | ETF | 27.43 | 27.57 | 27.43 | 27.51 | 27226.0 |
| 2009-11-24 | AOM | ETF | 28.37 | 28.37 | 28.2279 | 28.31 | 8429.0 |
| 2009-11-24 | AOR | ETF | 29.08 | 29.08 | 28.8273 | 28.96 | 35566.0 |
| 2009-11-24 | ARB | ETF | 22.62 | 22.64 | 21.93 | 22.42 | 212724.0 |
| 2009-11-24 | BAB | ETF | 24.95 | 24.95 | 24.89 | 24.92 | 96262.0 |
| 2009-11-24 | BAL | ETF | 37.1299 | 37.1299 | 36.8 | 36.94 | 16330.0 |
| 2009-11-24 | BBH | ETF | 32.44 | 32.7367 | 32.3567 | 32.68 | 144300.0 |
| 2009-11-24 | BIL | ETF | 91.7 | 91.72 | 91.7 | 91.7 | 197200.0 |
| 2009-11-24 | BITS | ETF | 26.84 | 28.2 | 26.0 | 27.6 | 5380.0 |
| 2009-11-24 | BIV | ETF | 80.85 | 81.37 | 80.79 | 81.23 | 173000.0 |
| 2009-11-24 | BJK | ETF | 24.88 | 25.13 | 24.7 | 24.87 | 6800.0 |
| 2009-11-24 | BKF | ETF | 46.83 | 46.83 | 46.18 | 46.76 | 459255.0 |
| 2009-11-24 | BLV | ETF | 78.1 | 78.29 | 77.8 | 78.19 | 66900.0 |
| 2009-11-24 | BMVP | ETF | 12.32 | 12.35 | 12.24 | 12.32 | 15769.0 |
| 2009-11-24 | BND | ETF | 79.86 | 80.0 | 79.8 | 79.99 | 586900.0 |
| 2009-11-24 | BNE | ETF | 6.29 | 6.34 | 5.95 | 6.13 | 99492.0 |
| 2009-11-24 | BOSS | ETF | 19.47 | 19.5 | 19.47 | 19.5 | 100.0 |
| 2009-11-24 | BRF | ETF | 47.42 | 47.42 | 46.59 | 47.36 | 659818.0 |
| 2009-11-24 | BSV | ETF | 80.39 | 80.48 | 80.33 | 80.46 | 563900.0 |
| 2009-11-24 | BTF | ETF | 64.1 | 64.45 | 63.75 | 63.821 | 1535.4 |
| 2009-11-24 | BWX | ETF | 29.84 | 29.86 | 29.759 | 29.827 | 426718.0 |
| 2009-11-24 | BWZ | ETF | 37.93 | 37.95 | 37.866 | 37.94 | 27239.0 |
| 2009-11-24 | BZQ | ETF | 3907.2 | 4001.6 | 3833.6 | 3833.6 | 402.5 |
| 2009-11-24 | CEF | ETF | 14.61 | 14.69 | 14.41 | 14.57 | 1346400.0 |
| 2009-11-24 | CEW | ETF | 22.33 | 22.92 | 22.2154 | 22.28 | 71300.0 |
| 2009-11-24 | CGO | ETF | 13.64 | 13.64 | 13.33 | 13.5 | 38233.0 |
| 2009-11-24 | CGW | ETF | 18.2 | 18.28 | 18.05 | 18.23 | 79594.0 |
| 2009-11-24 | CHI | ETF | 12.05 | 12.0992 | 11.94 | 11.97 | 161539.0 |
| 2009-11-24 | CHW | ETF | 7.7 | 7.76 | 7.67 | 7.73 | 250991.0 |
| 2009-11-24 | CHY | ETF | 11.24 | 11.36 | 11.2 | 11.26 | 215696.0 |
> showing 50 of 696 rows — these rows as CSV