PREVIEW / etf_daily / 2009-08-24
file: by_date/etf_daily/2009/2009-08-24.parquet size: 30 KB rows: 673
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-08-24 | SPY | ETF | 103.39 | 103.95 | 102.59 | 102.96 | 191279000.0 |
| 2009-08-24 | QQQ | ETF | 40.36 | 40.57 | 40.1 | 40.25 | 109904874.0 |
| 2009-08-24 | IWM | ETF | 58.4 | 58.77 | 57.84 | 58.13 | 33986500.0 |
| 2009-08-24 | DIA | ETF | 95.43 | 95.91 | 94.89 | 95.13 | 9349100.0 |
| 2009-08-24 | GLD | ETF | 93.64 | 93.7 | 91.64 | 92.34 | 8548000.0 |
| 2009-08-24 | TLT | ETF | 93.49 | 95.47 | 93.46 | 95.47 | 4460200.0 |
| 2009-08-24 | AAXJ | ETF | 49.66 | 49.84 | 49.33 | 49.62 | 150800.0 |
| 2009-08-24 | ACWI | ETF | 39.3 | 39.5 | 39.03 | 39.14 | 100800.0 |
| 2009-08-24 | ACWX | ETF | 38.13 | 38.3999 | 37.9 | 37.929 | 33559.0 |
| 2009-08-24 | ADRE | ETF | 39.15 | 39.31 | 38.64 | 38.79 | 294661.0 |
| 2009-08-24 | AFK | ETF | 27.5 | 28.0 | 27.5 | 27.9 | 4952.0 |
| 2009-08-24 | AGG | ETF | 103.1 | 103.56 | 102.95 | 103.42 | 434400.0 |
| 2009-08-24 | AGQ | ETF | 88.12 | 88.5 | 83.74 | 84.58 | 128050.0 |
| 2009-08-24 | AGZ | ETF | 107.3 | 107.8 | 107.0201 | 107.632 | 16139.0 |
| 2009-08-24 | AIA | ETF | 36.96 | 36.96 | 36.1042 | 36.22 | 36312.0 |
| 2009-08-24 | AIQ | ETF | 25.9 | 26.2 | 25.75 | 26.1 | 143479.0 |
| 2009-08-24 | AIS | ETF | 0.96 | 1.0 | 0.93 | 0.94 | 151876.0 |
| 2009-08-24 | AIVI | ETF | 40.76 | 40.89 | 40.15 | 40.15 | 36300.0 |
| 2009-08-24 | AMJ | ETF | 24.5999 | 24.75 | 24.5995 | 24.66 | 296268.0 |
| 2009-08-24 | AOA | ETF | 28.01 | 28.15 | 27.9 | 27.99 | 10500.0 |
| 2009-08-24 | AOK | ETF | 26.85 | 26.9699 | 26.6894 | 26.77 | 51260.0 |
| 2009-08-24 | AOM | ETF | 27.36 | 27.36 | 27.1661 | 27.1661 | 2126.0 |
| 2009-08-24 | AOR | ETF | 27.7 | 27.7199 | 27.56 | 27.56 | 6695.0 |
| 2009-08-24 | ARB | ETF | 17.51 | 18.1392 | 17.39 | 17.65 | 190174.0 |
| 2009-08-24 | BAL | ETF | 30.58 | 31.2 | 30.54 | 30.6 | 13869.0 |
| 2009-08-24 | BBH | ETF | 33.6267 | 33.6267 | 33.28 | 33.4367 | 188100.0 |
| 2009-08-24 | BIL | ETF | 91.7 | 91.72 | 91.7 | 91.7 | 202300.0 |
| 2009-08-24 | BITS | ETF | 21.68 | 21.68 | 20.628 | 21.52 | 1388.0 |
| 2009-08-24 | BIV | ETF | 78.51 | 79.04 | 78.49 | 79.04 | 138000.0 |
| 2009-08-24 | BJK | ETF | 24.4 | 24.4 | 23.47 | 23.47 | 25700.0 |
| 2009-08-24 | BKF | ETF | 39.42 | 39.47 | 38.697 | 38.84 | 359215.0 |
| 2009-08-24 | BLV | ETF | 76.34 | 77.14 | 76.1 | 77.1 | 38600.0 |
| 2009-08-24 | BMVP | ETF | 11.8233 | 11.8933 | 11.7914 | 11.8167 | 16913.0 |
| 2009-08-24 | BND | ETF | 78.4 | 78.75 | 78.25 | 78.57 | 760500.0 |
| 2009-08-24 | BNE | ETF | 6.22 | 6.23 | 5.98 | 6.14 | 212242.0 |
| 2009-08-24 | BOSS | ETF | 19.9 | 20.01 | 19.9 | 20.01 | 200.0 |
| 2009-08-24 | BRF | ETF | 37.82 | 37.9858 | 37.13 | 37.22 | 545850.0 |
| 2009-08-24 | BSV | ETF | 79.51 | 79.67 | 79.4 | 79.65 | 343800.0 |
| 2009-08-24 | BTF | ETF | 59.05 | 59.5 | 58.2 | 58.2495 | 12264.400000000001 |
| 2009-08-24 | BWX | ETF | 28.12 | 28.335 | 28.12 | 28.31 | 227124.0 |
| 2009-08-24 | BWZ | ETF | 36.1 | 36.13 | 35.98 | 35.98 | 8883.0 |
| 2009-08-24 | BZQ | ETF | 6432.0 | 6646.4 | 6380.8 | 6646.4 | 20.75 |
| 2009-08-24 | CEF | ETF | 12.11 | 12.2 | 11.95 | 11.95 | 691200.0 |
| 2009-08-24 | CEW | ETF | 21.4 | 21.42 | 21.3407 | 21.38 | 17363.0 |
| 2009-08-24 | CGO | ETF | 13.23 | 13.3489 | 13.16 | 13.24 | 42761.0 |
| 2009-08-24 | CGW | ETF | 16.97 | 17.0901 | 16.8301 | 16.92 | 215748.0 |
| 2009-08-24 | CHB | ETF | 0.51 | 0.54 | 0.45 | 0.48 | 3302619.0 |
| 2009-08-24 | CHI | ETF | 11.22 | 11.45 | 11.22 | 11.36 | 138369.0 |
| 2009-08-24 | CHIC | ETF | 17.38 | 17.4 | 17.35 | 17.36 | 13217097.0 |
| 2009-08-24 | CHW | ETF | 7.44 | 7.45 | 7.31 | 7.31 | 226740.0 |
> showing 50 of 673 rows — these rows as CSV