PREVIEW / etf_daily / 2009-08-05
file: by_date/etf_daily/2009/2009-08-05.parquet size: 29 KB rows: 666
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-05 | SPY | ETF | 100.77 | 100.86 | 99.58 | 100.41 | 184726400.0 |
| 2009-08-05 | QQQ | ETF | 40.13 | 40.14 | 39.46 | 39.73 | 118092996.0 |
| 2009-08-05 | IWM | ETF | 57.17 | 57.17 | 56.0 | 56.54 | 54105900.0 |
| 2009-08-05 | DIA | ETF | 93.13 | 93.22 | 92.12 | 92.83 | 11396200.0 |
| 2009-08-05 | GLD | ETF | 94.88 | 95.05 | 94.01 | 94.78 | 8987000.0 |
| 2009-08-05 | TLT | ETF | 91.31 | 92.75 | 90.87 | 90.94 | 4458300.0 |
| 2009-08-05 | AAXJ | ETF | 50.5 | 50.5 | 49.68 | 50.18 | 179800.0 |
| 2009-08-05 | ACWI | ETF | 38.58 | 38.59 | 38.06 | 38.44 | 86600.0 |
| 2009-08-05 | ACWX | ETF | 37.61 | 37.61 | 37.0 | 37.52 | 32236.0 |
| 2009-08-05 | ADRE | ETF | 39.15 | 39.19 | 38.39 | 39.1 | 192060.0 |
| 2009-08-05 | AFK | ETF | 28.1201 | 28.24 | 27.79 | 28.0001 | 39157.0 |
| 2009-08-05 | AGG | ETF | 102.33 | 102.33 | 102.0 | 102.15 | 608200.0 |
| 2009-08-05 | AGQ | ETF | 94.52 | 94.66 | 91.9 | 93.62 | 148350.0 |
| 2009-08-05 | AGZ | ETF | 107.52 | 107.7723 | 106.75 | 106.7779 | 11953.0 |
| 2009-08-05 | AIA | ETF | 36.41 | 36.41 | 35.65 | 35.75 | 65177.0 |
| 2009-08-05 | AIQ | ETF | 26.75 | 27.4 | 26.25 | 26.4 | 102453.0 |
| 2009-08-05 | AIS | ETF | 0.9 | 1.02 | 0.895 | 0.96 | 1208615.0 |
| 2009-08-05 | AIVI | ETF | 39.65 | 39.84 | 39.08 | 39.74 | 29200.0 |
| 2009-08-05 | AMJ | ETF | 25.37 | 25.37 | 24.7118 | 24.9 | 290262.0 |
| 2009-08-05 | AOA | ETF | 27.47 | 27.47 | 27.2 | 27.44 | 11100.0 |
| 2009-08-05 | AOK | ETF | 26.36 | 26.36 | 26.332 | 26.332 | 1952.0 |
| 2009-08-05 | AOM | ETF | 26.76 | 26.82 | 26.72 | 26.8 | 3406.0 |
| 2009-08-05 | AOR | ETF | 27.25 | 27.25 | 26.9739 | 27.13 | 12910.0 |
| 2009-08-05 | ARB | ETF | 16.67 | 16.69 | 15.78 | 16.06 | 293506.0 |
| 2009-08-05 | BAL | ETF | 32.3568 | 32.6135 | 32.14 | 32.6135 | 920.0 |
| 2009-08-05 | BBH | ETF | 34.1133 | 34.1567 | 33.47 | 33.47 | 451500.0 |
| 2009-08-05 | BIL | ETF | 91.7 | 91.72 | 91.68 | 91.7 | 188900.0 |
| 2009-08-05 | BITS | ETF | 22.6 | 23.24 | 22.04 | 22.4 | 4182.0 |
| 2009-08-05 | BIV | ETF | 77.64 | 78.14 | 77.6 | 77.72 | 90800.0 |
| 2009-08-05 | BJK | ETF | 24.05 | 24.05 | 23.39 | 23.66 | 12700.0 |
| 2009-08-05 | BKF | ETF | 39.97 | 39.97 | 38.9 | 39.73 | 835123.0 |
| 2009-08-05 | BLV | ETF | 74.54 | 75.89 | 74.54 | 75.06 | 13200.0 |
| 2009-08-05 | BMVP | ETF | 11.7 | 11.7 | 11.54 | 11.6 | 16394.0 |
| 2009-08-05 | BND | ETF | 77.74 | 77.85 | 77.6 | 77.68 | 485200.0 |
| 2009-08-05 | BNE | ETF | 7.95 | 7.95 | 6.33 | 6.72 | 719674.0 |
| 2009-08-05 | BOSS | ETF | 17.21 | 17.53 | 17.21 | 17.53 | 1300.0 |
| 2009-08-05 | BRF | ETF | 35.9 | 36.1 | 34.94 | 36.07 | 316904.0 |
| 2009-08-05 | BSV | ETF | 79.11 | 79.34 | 79.0 | 79.16 | 484300.0 |
| 2009-08-05 | BTF | ETF | 57.8 | 60.49999999999999 | 56.74999999999999 | 59.349999999999994 | 15364.0 |
| 2009-08-05 | BWX | ETF | 28.205 | 28.3 | 28.09 | 28.3 | 651754.0 |
| 2009-08-05 | BWZ | ETF | 36.03 | 36.08 | 35.97 | 36.0 | 5869.0 |
| 2009-08-05 | BZQ | ETF | 7028.8 | 7032.0 | 6721.6 | 6721.6 | 8.25 |
| 2009-08-05 | CBON | ETF | 0.75 | 0.9 | 0.69 | 0.9 | 84889.0 |
| 2009-08-05 | CEF | ETF | 12.23 | 12.35 | 12.17 | 12.29 | 817800.0 |
| 2009-08-05 | CEW | ETF | 21.37 | 21.454 | 21.32 | 21.4499 | 131168.0 |
| 2009-08-05 | CGO | ETF | 12.86 | 13.0 | 12.86 | 12.98 | 18441.0 |
| 2009-08-05 | CGW | ETF | 16.62 | 16.69 | 16.39 | 16.58 | 40848.0 |
| 2009-08-05 | CHB | ETF | 0.5 | 0.5 | 0.45 | 0.48 | 1047013.0 |
| 2009-08-05 | CHI | ETF | 11.31 | 11.4 | 11.27 | 11.28 | 174049.0 |
| 2009-08-05 | CHIC | ETF | 15.1 | 15.31 | 14.92 | 15.24 | 170255.0 |
> showing 50 of 666 rows — these rows as CSV