PREVIEW / etf_daily / 2009-01-15
file: by_date/etf_daily/2009/2009-01-15.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-01-15 | SPY | ETF | 84.12 | 85.25 | 81.72 | 84.4 | 532647300.0 |
| 2009-01-15 | QQQ | ETF | 28.55 | 29.34 | 28.07 | 29.099 | 192790728.0 |
| 2009-01-15 | IWM | ETF | 45.31 | 46.52 | 43.81 | 45.97 | 100622800.0 |
| 2009-01-15 | DIA | ETF | 82.07 | 82.98 | 80.04 | 82.18 | 44216600.0 |
| 2009-01-15 | GLD | ETF | 79.97 | 80.7 | 78.87 | 80.39 | 16714700.0 |
| 2009-01-15 | TLT | ETF | 116.2 | 116.92 | 115.58 | 116.09 | 2827200.0 |
| 2009-01-15 | AAXJ | ETF | 30.97 | 31.34 | 29.83 | 30.67 | 36500.0 |
| 2009-01-15 | ACWI | ETF | 29.82 | 29.97 | 28.75 | 29.74 | 268500.0 |
| 2009-01-15 | ACWX | ETF | 27.49 | 27.97 | 26.83 | 27.76 | 179642.0 |
| 2009-01-15 | ADRE | ETF | 25.54 | 26.07 | 24.57 | 25.88 | 276808.0 |
| 2009-01-15 | AFK | ETF | 19.35 | 19.52 | 19.32 | 19.52 | 9100.0 |
| 2009-01-15 | AGG | ETF | 102.85 | 103.52 | 102.65 | 103.07 | 1047400.0 |
| 2009-01-15 | AGQ | ETF | 53.54 | 55.32 | 51.7 | 54.8 | 27900.0 |
| 2009-01-15 | AGZ | ETF | 108.8 | 108.84 | 108.235 | 108.235 | 3844.0 |
| 2009-01-15 | AIA | ETF | 23.0 | 23.65 | 22.68 | 23.54 | 28900.0 |
| 2009-01-15 | AIQ | ETF | 40.5 | 42.05 | 39.55 | 42.05 | 82877.0 |
| 2009-01-15 | AIS | ETF | 0.47 | 0.48 | 0.45 | 0.4502 | 72800.0 |
| 2009-01-15 | AIVI | ETF | 30.61 | 30.91 | 29.56 | 30.4 | 10100.0 |
| 2009-01-15 | AOA | ETF | 22.5 | 22.99 | 21.37 | 22.25 | 15300.0 |
| 2009-01-15 | AOK | ETF | 25.1364 | 26.15 | 25.1364 | 25.46 | 4879.0 |
| 2009-01-15 | AOM | ETF | 24.44 | 24.71 | 24.404 | 24.564 | 1021.0 |
| 2009-01-15 | AOR | ETF | 23.41 | 23.8 | 22.69 | 22.7 | 2309.0 |
| 2009-01-15 | ARB | ETF | 14.42 | 14.74 | 13.3 | 14.74 | 354020.0 |
| 2009-01-15 | BAL | ETF | 27.62 | 28.16 | 27.62 | 28.16 | 700.0 |
| 2009-01-15 | BBH | ETF | 57.1667 | 57.4533 | 56.1867 | 57.4533 | 326700.0 |
| 2009-01-15 | BIL | ETF | 91.76 | 91.84 | 91.7 | 91.84 | 207800.0 |
| 2009-01-15 | BITS | ETF | 18.84 | 18.84 | 17.68 | 17.68 | 2405.0 |
| 2009-01-15 | BIV | ETF | 79.5 | 79.5 | 78.72 | 79.06 | 91400.0 |
| 2009-01-15 | BJK | ETF | 16.14 | 16.14 | 16.03 | 16.03 | 1100.0 |
| 2009-01-15 | BKF | ETF | 22.03 | 24.06 | 21.59 | 22.72 | 40946.0 |
| 2009-01-15 | BLV | ETF | 79.22 | 79.66 | 79.14 | 79.37 | 24000.0 |
| 2009-01-15 | BMVP | ETF | 10.13 | 10.35 | 9.91 | 10.26 | 42242.0 |
| 2009-01-15 | BND | ETF | 78.84 | 78.84 | 78.16 | 78.3 | 317500.0 |
| 2009-01-15 | BNE | ETF | 3.21 | 3.68 | 3.0 | 3.28 | 304028.0 |
| 2009-01-15 | BSV | ETF | 80.61 | 80.64 | 80.26 | 80.56 | 137800.0 |
| 2009-01-15 | BTF | ETF | 47.949999999999996 | 48.15 | 44.949999999999996 | 47.5 | 21623.4 |
| 2009-01-15 | BWX | ETF | 25.98 | 26.265 | 25.9604 | 26.095 | 886890.0 |
| 2009-01-15 | CBON | ETF | 2.2 | 2.28 | 2.15 | 2.15 | 50722.0 |
| 2009-01-15 | CDL | ETF | 0.22 | 0.23 | 0.2 | 0.22 | 475402.0 |
| 2009-01-15 | CEF | ETF | 9.95 | 10.24 | 9.9 | 10.05 | 793000.0 |
| 2009-01-15 | CGO | ETF | 9.8 | 9.8076 | 9.35 | 9.59 | 38455.0 |
| 2009-01-15 | CGW | ETF | 13.51 | 13.64 | 12.9 | 13.29 | 62368.0 |
| 2009-01-15 | CHB | ETF | 0.63 | 0.6499 | 0.55 | 0.57 | 481527.0 |
| 2009-01-15 | CHI | ETF | 8.7 | 8.71 | 7.9 | 8.27 | 317123.0 |
| 2009-01-15 | CHIC | ETF | 4.92 | 4.95 | 4.29 | 4.74 | 383503.0 |
| 2009-01-15 | CHW | ETF | 5.95 | 5.95 | 5.47 | 5.94 | 287262.0 |
| 2009-01-15 | CHY | ETF | 8.39 | 8.39 | 7.66 | 8.27 | 433341.0 |
| 2009-01-15 | CMF | ETF | 52.0 | 52.0 | 51.85 | 51.95 | 1600.0 |
| 2009-01-15 | CNXT | ETF | 0.69 | 0.7196 | 0.67 | 0.71 | 233840.0 |
| 2009-01-15 | COW | ETF | 32.68 | 32.91 | 32.41 | 32.83 | 8951.0 |
> showing 50 of 634 rows — these rows as CSV