PREVIEW / etf_daily / 2009-12-03
file: by_date/etf_daily/2009/2009-12-03.parquet size: 30 KB rows: 699
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-12-03 | SPY | ETF | 111.55 | 112.18 | 110.29 | 110.38 | 167324900.0 |
| 2009-12-03 | QQQ | ETF | 44.24 | 44.5 | 43.88 | 43.89 | 72460358.0 |
| 2009-12-03 | IWM | ETF | 59.98 | 60.37 | 58.93 | 58.96 | 53866100.0 |
| 2009-12-03 | DIA | ETF | 104.85 | 105.18 | 103.59 | 103.69 | 9723500.0 |
| 2009-12-03 | GLD | ETF | 118.57 | 119.54 | 118.03 | 118.7 | 28864000.0 |
| 2009-12-03 | TLT | ETF | 94.43 | 94.84 | 94.24 | 94.34 | 3947300.0 |
| 2009-12-03 | AAXJ | ETF | 56.14 | 57.0 | 55.76 | 55.93 | 146700.0 |
| 2009-12-03 | ACWI | ETF | 43.02 | 43.23 | 42.5 | 42.54 | 532300.0 |
| 2009-12-03 | ACWX | ETF | 42.13 | 42.209 | 41.5684 | 41.63 | 42864.0 |
| 2009-12-03 | ADRE | ETF | 45.8 | 45.82 | 44.85 | 44.94 | 115263.0 |
| 2009-12-03 | AFK | ETF | 29.0 | 29.02 | 28.74 | 28.74 | 4745.0 |
| 2009-12-03 | AGG | ETF | 104.95 | 105.03 | 104.77 | 105.03 | 744800.0 |
| 2009-12-03 | AGQ | ETF | 143.66 | 146.22 | 141.46 | 143.76 | 319750.0 |
| 2009-12-03 | AGZ | ETF | 108.51 | 108.89 | 108.51 | 108.705 | 27086.0 |
| 2009-12-03 | AIA | ETF | 40.06 | 40.25 | 39.59 | 39.59 | 46095.0 |
| 2009-12-03 | AIQ | ETF | 28.55 | 29.05 | 28.35 | 28.8 | 42767.0 |
| 2009-12-03 | AIS | ETF | 1.2 | 1.2 | 1.14 | 1.16 | 289069.0 |
| 2009-12-03 | AIVI | ETF | 45.16 | 45.27 | 44.64 | 44.64 | 45000.0 |
| 2009-12-03 | AMJ | ETF | 26.93 | 26.93 | 26.7 | 26.7 | 231096.0 |
| 2009-12-03 | AOA | ETF | 29.93 | 29.93 | 29.62 | 29.67 | 3100.0 |
| 2009-12-03 | AOK | ETF | 27.63 | 27.63 | 27.47 | 27.51 | 6513.0 |
| 2009-12-03 | AOM | ETF | 28.53 | 28.53 | 28.4 | 28.4 | 20782.0 |
| 2009-12-03 | AOR | ETF | 29.26 | 29.26 | 28.95 | 28.97 | 32534.0 |
| 2009-12-03 | ARB | ETF | 21.81 | 22.25 | 21.31 | 21.42 | 429226.0 |
| 2009-12-03 | BAB | ETF | 24.98 | 24.98 | 24.83 | 24.85 | 138115.0 |
| 2009-12-03 | BAL | ETF | 36.14 | 36.66 | 36.14 | 36.4 | 7413.0 |
| 2009-12-03 | BBH | ETF | 32.7533 | 32.9133 | 32.4767 | 32.4933 | 81000.0 |
| 2009-12-03 | BIL | ETF | 91.7 | 91.74 | 91.7 | 91.7 | 80400.0 |
| 2009-12-03 | BITS | ETF | 27.4 | 27.4 | 26.8 | 27.4 | 1640.0 |
| 2009-12-03 | BIV | ETF | 80.69 | 80.91 | 80.57 | 80.91 | 471800.0 |
| 2009-12-03 | BJK | ETF | 25.2 | 25.32 | 24.99 | 25.05 | 16200.0 |
| 2009-12-03 | BKF | ETF | 47.54 | 47.7 | 46.62 | 46.76 | 181800.0 |
| 2009-12-03 | BLV | ETF | 78.24 | 78.33 | 77.7 | 78.27 | 58600.0 |
| 2009-12-03 | BMVP | ETF | 12.34 | 12.39 | 12.19 | 12.19 | 18263.0 |
| 2009-12-03 | BND | ETF | 79.7 | 79.71 | 79.6 | 79.7 | 454800.0 |
| 2009-12-03 | BNE | ETF | 6.11 | 6.21 | 5.92 | 6.0 | 104452.0 |
| 2009-12-03 | BOSS | ETF | 19.01 | 19.29 | 19.01 | 19.29 | 100.0 |
| 2009-12-03 | BRF | ETF | 50.27 | 50.54 | 48.96 | 49.24 | 397828.0 |
| 2009-12-03 | BSV | ETF | 80.27 | 80.32 | 80.21 | 80.31 | 365400.0 |
| 2009-12-03 | BTF | ETF | 63.15 | 63.25 | 63.05 | 63.15 | 4445.0 |
| 2009-12-03 | BWX | ETF | 30.12 | 30.22 | 30.08 | 30.08 | 320296.0 |
| 2009-12-03 | BWZ | ETF | 38.12 | 38.2 | 37.92 | 38.1473 | 31960.0 |
| 2009-12-03 | BZQ | ETF | 3462.4 | 3609.6 | 3422.4 | 3595.2 | 82.0 |
| 2009-12-03 | CEF | ETF | 15.24 | 15.29 | 15.02 | 15.11 | 1273200.0 |
| 2009-12-03 | CEW | ETF | 22.407 | 22.47 | 22.3408 | 22.4 | 38418.0 |
| 2009-12-03 | CGO | ETF | 14.15 | 14.25 | 13.91 | 13.95 | 25089.0 |
| 2009-12-03 | CGW | ETF | 18.7 | 18.8 | 18.41 | 18.41 | 106583.0 |
| 2009-12-03 | CHI | ETF | 12.35 | 12.36 | 12.06 | 12.06 | 145675.0 |
| 2009-12-03 | CHII | ETF | 16.69 | 16.69 | 16.4 | 16.4 | 730816.0 |
| 2009-12-03 | CHIQ | ETF | 16.55 | 16.55 | 16.31 | 16.35 | 36427.0 |
> showing 50 of 699 rows — these rows as CSV