PREVIEW / etf_daily / 2009-02-12
file: by_date/etf_daily/2009/2009-02-12.parquet size: 28 KB rows: 634
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-02-12 | SPY | ETF | 82.17 | 83.82 | 81.05 | 83.66 | 469302200.0 |
| 2009-02-12 | QQQ | ETF | 29.83 | 30.61 | 29.64 | 30.57 | 201151398.0 |
| 2009-02-12 | IWM | ETF | 44.1 | 45.21 | 43.47 | 45.14 | 79209300.0 |
| 2009-02-12 | DIA | ETF | 78.43 | 79.62 | 77.15 | 79.5 | 45482100.0 |
| 2009-02-12 | GLD | ETF | 93.04 | 93.74 | 92.52 | 93.17 | 38786800.0 |
| 2009-02-12 | TLT | ETF | 105.98 | 106.18 | 104.74 | 105.21 | 1818400.0 |
| 2009-02-12 | AAXJ | ETF | 31.19 | 31.25 | 30.47 | 31.22 | 129800.0 |
| 2009-02-12 | ACWI | ETF | 28.86 | 29.35 | 28.39 | 29.35 | 154600.0 |
| 2009-02-12 | ACWX | ETF | 26.72 | 27.1699 | 26.38 | 27.02 | 88468.0 |
| 2009-02-12 | ADRE | ETF | 26.77 | 27.49 | 26.54 | 27.41 | 277921.0 |
| 2009-02-12 | AFK | ETF | 18.49 | 18.49 | 18.39 | 18.39 | 200.0 |
| 2009-02-12 | AGG | ETF | 101.9 | 102.2 | 101.65 | 102.1 | 366900.0 |
| 2009-02-12 | AGQ | ETF | 86.92 | 88.2 | 85.62 | 87.58 | 33750.0 |
| 2009-02-12 | AGZ | ETF | 107.89 | 108.12 | 107.47 | 107.5 | 13187.0 |
| 2009-02-12 | AIA | ETF | 23.8 | 23.8 | 23.3 | 23.72 | 10241.0 |
| 2009-02-12 | AIQ | ETF | 45.15 | 47.1 | 44.55 | 46.95 | 25803.0 |
| 2009-02-12 | AIS | ETF | 0.4 | 0.42 | 0.3997 | 0.42 | 32400.0 |
| 2009-02-12 | AIVI | ETF | 28.31 | 29.17 | 28.31 | 29.17 | 8500.0 |
| 2009-02-12 | AOA | ETF | 22.0 | 22.54 | 22.0 | 22.24 | 500.0 |
| 2009-02-12 | AOK | ETF | 24.11 | 25.09 | 24.11 | 24.94 | 10240.0 |
| 2009-02-12 | AOM | ETF | 24.28 | 24.41 | 24.01 | 24.23 | 1760.0 |
| 2009-02-12 | AOR | ETF | 23.288 | 23.34 | 23.288 | 23.32 | 2230.0 |
| 2009-02-12 | ARB | ETF | 13.51 | 13.87 | 13.21 | 13.85 | 198249.0 |
| 2009-02-12 | BAL | ETF | 26.75 | 26.89 | 26.53 | 26.64 | 1600.0 |
| 2009-02-12 | BBH | ETF | 57.5367 | 58.8367 | 57.5367 | 58.8367 | 301200.0 |
| 2009-02-12 | BIL | ETF | 91.72 | 91.74 | 91.68 | 91.68 | 161100.0 |
| 2009-02-12 | BITS | ETF | 19.0404 | 19.0404 | 19.0 | 19.0004 | 375.0 |
| 2009-02-12 | BIV | ETF | 77.55 | 77.92 | 77.37 | 77.65 | 56100.0 |
| 2009-02-12 | BKF | ETF | 23.35 | 23.99 | 23.28 | 23.75 | 17548.0 |
| 2009-02-12 | BLV | ETF | 75.48 | 75.6 | 74.26 | 74.26 | 66400.0 |
| 2009-02-12 | BMVP | ETF | 10.1367 | 10.4033 | 10.0779 | 10.4033 | 95100.0 |
| 2009-02-12 | BND | ETF | 77.48 | 77.6 | 77.22 | 77.32 | 238100.0 |
| 2009-02-12 | BNE | ETF | 2.75 | 3.01 | 2.75 | 2.99 | 194239.0 |
| 2009-02-12 | BOSS | ETF | 12.35 | 12.5 | 12.35 | 12.5 | 100.0 |
| 2009-02-12 | BSV | ETF | 79.58 | 79.58 | 79.06 | 79.34 | 192300.0 |
| 2009-02-12 | BTF | ETF | 46.5 | 47.449999999999996 | 45.75 | 46.849999999999994 | 23302.0 |
| 2009-02-12 | BWX | ETF | 25.325 | 25.375 | 25.2 | 25.375 | 228338.0 |
| 2009-02-12 | CBON | ETF | 1.75 | 1.85 | 1.68 | 1.85 | 39740.0 |
| 2009-02-12 | CDL | ETF | 0.15 | 0.16 | 0.15 | 0.15 | 301094.0 |
| 2009-02-12 | CEF | ETF | 11.65 | 11.86 | 11.54 | 11.85 | 1571800.0 |
| 2009-02-12 | CGO | ETF | 9.89 | 10.3 | 9.5 | 10.2 | 41040.0 |
| 2009-02-12 | CGW | ETF | 12.84 | 13.25 | 12.77 | 13.12 | 120796.0 |
| 2009-02-12 | CHB | ETF | 0.46 | 0.47 | 0.39 | 0.4 | 396851.0 |
| 2009-02-12 | CHI | ETF | 8.75 | 8.96 | 8.4 | 8.77 | 309277.0 |
| 2009-02-12 | CHIC | ETF | 5.16 | 5.56 | 5.12 | 5.39 | 153531.0 |
| 2009-02-12 | CHW | ETF | 6.38 | 6.46 | 6.2 | 6.42 | 206264.0 |
| 2009-02-12 | CHY | ETF | 8.85 | 8.95 | 8.466 | 8.95 | 387919.0 |
| 2009-02-12 | CMF | ETF | 51.9075 | 51.93 | 51.345 | 51.538 | 6082.0 |
| 2009-02-12 | CNXT | ETF | 0.63 | 0.63 | 0.61 | 0.61 | 88868.0 |
| 2009-02-12 | COW | ETF | 32.07 | 32.45 | 32.01 | 32.42 | 4478.0 |
> showing 50 of 634 rows — these rows as CSV