PREVIEW / etf_daily / 2009-05-27
file: by_date/etf_daily/2009/2009-05-27.parquet size: 29 KB rows: 655
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-05-27 | SPY | ETF | 91.44 | 91.75 | 89.53 | 89.67 | 246015800.0 |
| 2009-05-27 | QQQ | ETF | 34.68 | 35.19 | 34.43 | 34.55 | 121393094.0 |
| 2009-05-27 | IWM | ETF | 49.76 | 50.37 | 49.01 | 49.1 | 48207700.0 |
| 2009-05-27 | DIA | ETF | 84.97 | 85.07 | 82.97 | 83.16 | 13708200.0 |
| 2009-05-27 | GLD | ETF | 93.73 | 94.28 | 93.1 | 93.45 | 13688100.0 |
| 2009-05-27 | TLT | ETF | 92.24 | 92.58 | 90.38 | 90.49 | 7490200.0 |
| 2009-05-27 | AAXJ | ETF | 43.62 | 43.96 | 42.86 | 43.05 | 180500.0 |
| 2009-05-27 | ACWI | ETF | 34.75 | 34.94 | 34.17 | 34.17 | 562800.0 |
| 2009-05-27 | ACWX | ETF | 33.97 | 33.97 | 33.25 | 33.302 | 140099.0 |
| 2009-05-27 | ADRE | ETF | 35.24 | 35.47 | 34.55 | 34.65 | 231428.0 |
| 2009-05-27 | AFK | ETF | 26.69 | 27.9 | 26.41 | 26.75 | 38589.0 |
| 2009-05-27 | AGG | ETF | 101.45 | 101.56 | 100.75 | 100.91 | 636200.0 |
| 2009-05-27 | AGQ | ETF | 95.9 | 101.0 | 95.4 | 98.34 | 114450.0 |
| 2009-05-27 | AGZ | ETF | 107.3 | 107.64 | 106.8 | 106.848 | 142825.0 |
| 2009-05-27 | AIA | ETF | 32.08 | 32.4399 | 31.84 | 31.84 | 8214.0 |
| 2009-05-27 | AIQ | ETF | 34.25 | 34.9 | 34.0 | 34.4 | 31662.0 |
| 2009-05-27 | AIS | ETF | 0.55 | 0.55 | 0.49 | 0.49 | 139057.0 |
| 2009-05-27 | AIVI | ETF | 36.07 | 36.07 | 35.35 | 35.35 | 5400.0 |
| 2009-05-27 | AMJ | ETF | 22.12 | 22.16 | 21.892 | 21.93 | 145336.0 |
| 2009-05-27 | AOA | ETF | 25.03 | 25.27 | 24.75 | 24.77 | 11600.0 |
| 2009-05-27 | AOK | ETF | 25.98 | 25.98 | 25.5 | 25.5 | 8330.0 |
| 2009-05-27 | AOM | ETF | 26.09 | 26.09 | 25.41 | 25.52 | 14950.0 |
| 2009-05-27 | AOR | ETF | 25.4499 | 25.48 | 25.18 | 25.21 | 12766.0 |
| 2009-05-27 | ARB | ETF | 20.83 | 21.04 | 20.22 | 20.52 | 166252.0 |
| 2009-05-27 | BAL | ETF | 30.95 | 31.23 | 30.91 | 30.96 | 10703.0 |
| 2009-05-27 | BBH | ETF | 29.83 | 30.08 | 29.48 | 29.5467 | 462300.0 |
| 2009-05-27 | BIL | ETF | 91.7 | 91.78 | 91.7 | 91.76 | 175100.0 |
| 2009-05-27 | BITS | ETF | 18.48 | 19.0 | 18.2404 | 19.0 | 16164.0 |
| 2009-05-27 | BIV | ETF | 76.2 | 76.3 | 75.31 | 75.56 | 93100.0 |
| 2009-05-27 | BJK | ETF | 22.11 | 22.11 | 20.94 | 20.94 | 40700.0 |
| 2009-05-27 | BKF | ETF | 35.15 | 38.0 | 34.5 | 34.57 | 188432.0 |
| 2009-05-27 | BLV | ETF | 71.98 | 71.99 | 70.67 | 70.77 | 40000.0 |
| 2009-05-27 | BMVP | ETF | 10.78 | 10.85 | 10.64 | 10.64 | 24738.0 |
| 2009-05-27 | BND | ETF | 77.18 | 77.22 | 76.62 | 76.73 | 473700.0 |
| 2009-05-27 | BNE | ETF | 5.69 | 5.96 | 5.5 | 5.69 | 162209.0 |
| 2009-05-27 | BOSS | ETF | 15.56 | 15.61 | 15.56 | 15.61 | 100.0 |
| 2009-05-27 | BRF | ETF | 27.4 | 27.48 | 26.65 | 26.72 | 115101.0 |
| 2009-05-27 | BSV | ETF | 79.0 | 79.12 | 78.85 | 78.97 | 185800.0 |
| 2009-05-27 | BTF | ETF | 48.05 | 48.05 | 46.74999999999999 | 46.95 | 3980.2000000000003 |
| 2009-05-27 | BWX | ETF | 26.95 | 27.0 | 26.85 | 26.92 | 300374.0 |
| 2009-05-27 | BWZ | ETF | 34.95 | 35.0 | 34.751 | 35.0 | 2588.0 |
| 2009-05-27 | CBON | ETF | 1.28 | 1.35 | 1.28 | 1.35 | 18690.0 |
| 2009-05-27 | CEF | ETF | 12.12 | 12.24 | 12.07 | 12.09 | 923800.0 |
| 2009-05-27 | CEW | ETF | 20.62 | 20.62 | 20.52 | 20.6 | 25240.0 |
| 2009-05-27 | CGO | ETF | 10.99 | 11.08 | 10.85 | 11.08 | 55456.0 |
| 2009-05-27 | CGW | ETF | 14.95 | 15.2 | 14.79 | 14.8 | 40169.0 |
| 2009-05-27 | CHB | ETF | 0.44 | 0.45 | 0.43 | 0.43 | 451506.0 |
| 2009-05-27 | CHI | ETF | 10.44 | 10.48 | 10.26 | 10.27 | 180760.0 |
| 2009-05-27 | CHIC | ETF | 10.71 | 11.11 | 9.95 | 9.98 | 276284.0 |
| 2009-05-27 | CHW | ETF | 6.98 | 6.98 | 6.85 | 6.86 | 199035.0 |
> showing 50 of 655 rows — these rows as CSV