PREVIEW / etf_daily / 2009-01-28
file: by_date/etf_daily/2009/2009-01-28.parquet size: 28 KB rows: 636
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-28 | SPY | ETF | 86.4 | 87.95 | 86.07 | 87.39 | 330007000.0 |
| 2009-01-28 | QQQ | ETF | 29.83 | 30.65 | 29.81 | 30.35 | 139797234.0 |
| 2009-01-28 | IWM | ETF | 46.25 | 47.49 | 45.49 | 47.25 | 71034500.0 |
| 2009-01-28 | DIA | ETF | 83.04 | 84.04 | 82.59 | 83.68 | 21080000.0 |
| 2009-01-28 | GLD | ETF | 88.27 | 88.38 | 86.84 | 87.42 | 18449600.0 |
| 2009-01-28 | TLT | ETF | 109.31 | 109.81 | 105.72 | 106.53 | 4348100.0 |
| 2009-01-28 | AAXJ | ETF | 32.07 | 32.47 | 30.67 | 32.47 | 40900.0 |
| 2009-01-28 | ACWI | ETF | 30.25 | 30.66 | 30.11 | 30.54 | 93700.0 |
| 2009-01-28 | ACWX | ETF | 28.22 | 28.41 | 27.96 | 28.25 | 237581.0 |
| 2009-01-28 | ADRE | ETF | 26.45 | 27.21 | 26.45 | 27.05 | 242880.0 |
| 2009-01-28 | AFK | ETF | 18.42 | 18.42 | 18.37 | 18.37 | 585.0 |
| 2009-01-28 | AGG | ETF | 102.74 | 102.77 | 102.13 | 102.4 | 478400.0 |
| 2009-01-28 | AGQ | ETF | 69.72 | 71.08 | 68.02 | 69.18 | 24000.0 |
| 2009-01-28 | AGZ | ETF | 108.16 | 111.85 | 107.68 | 107.99 | 6967.0 |
| 2009-01-28 | AIA | ETF | 23.52 | 24.35 | 23.5 | 24.17 | 79533.0 |
| 2009-01-28 | AIQ | ETF | 44.45 | 45.5 | 44.2 | 45.15 | 44014.0 |
| 2009-01-28 | AIS | ETF | 0.49 | 0.49 | 0.4708 | 0.48 | 20233.0 |
| 2009-01-28 | AIVI | ETF | 30.82 | 30.99 | 30.11 | 30.37 | 14200.0 |
| 2009-01-28 | AOA | ETF | 22.96 | 23.12 | 22.0 | 23.0 | 36400.0 |
| 2009-01-28 | AOK | ETF | 25.89 | 25.89 | 25.22 | 25.344 | 5461.0 |
| 2009-01-28 | AOM | ETF | 24.78 | 24.85 | 24.7499 | 24.85 | 645.0 |
| 2009-01-28 | AOR | ETF | 24.0 | 24.044 | 23.89 | 23.98 | 6512.0 |
| 2009-01-28 | ARB | ETF | 14.97 | 15.77 | 14.8 | 15.55 | 391146.0 |
| 2009-01-28 | BAL | ETF | 29.7 | 30.19 | 29.7 | 30.19 | 705.0 |
| 2009-01-28 | BBH | ETF | 56.96 | 57.4033 | 56.8367 | 57.2533 | 177900.0 |
| 2009-01-28 | BIL | ETF | 91.76 | 91.76 | 91.66 | 91.68 | 67450.0 |
| 2009-01-28 | BITS | ETF | 19.84 | 20.4 | 19.44 | 20.0 | 3900.0 |
| 2009-01-28 | BIV | ETF | 77.78 | 78.54 | 77.78 | 77.99 | 107100.0 |
| 2009-01-28 | BJK | ETF | 16.55 | 16.55 | 16.54 | 16.54 | 300.0 |
| 2009-01-28 | BKF | ETF | 23.52 | 23.83 | 23.218 | 23.74 | 24317.0 |
| 2009-01-28 | BLV | ETF | 77.13 | 77.59 | 76.0 | 76.38 | 15700.0 |
| 2009-01-28 | BMVP | ETF | 10.53 | 10.71 | 10.5 | 10.66 | 37274.0 |
| 2009-01-28 | BND | ETF | 77.8 | 77.9 | 77.51 | 77.81 | 283700.0 |
| 2009-01-28 | BNE | ETF | 2.6 | 3.75 | 2.6 | 3.7 | 541687.0 |
| 2009-01-28 | BSV | ETF | 80.14 | 80.14 | 79.47 | 79.74 | 140100.0 |
| 2009-01-28 | BTF | ETF | 46.74999999999999 | 48.75 | 46.74999999999999 | 47.85 | 6790.8 |
| 2009-01-28 | BWX | ETF | 25.905 | 26.025 | 25.64 | 25.86 | 291830.0 |
| 2009-01-28 | CBON | ETF | 2.81 | 2.94 | 2.81 | 2.94 | 12236.0 |
| 2009-01-28 | CDL | ETF | 0.201 | 0.21 | 0.1899 | 0.2 | 570789.0 |
| 2009-01-28 | CEF | ETF | 10.62 | 10.68 | 10.42 | 10.57 | 1032800.0 |
| 2009-01-28 | CGO | ETF | 10.17 | 10.39 | 9.9013 | 10.15 | 22822.0 |
| 2009-01-28 | CGW | ETF | 13.42 | 13.57 | 13.2119 | 13.45 | 154459.0 |
| 2009-01-28 | CHB | ETF | 0.53 | 0.53 | 0.44 | 0.48 | 4292449.0 |
| 2009-01-28 | CHI | ETF | 9.25 | 9.355 | 9.0 | 9.2 | 271152.0 |
| 2009-01-28 | CHIC | ETF | 4.64 | 5.25 | 4.64 | 5.2 | 144046.0 |
| 2009-01-28 | CHW | ETF | 6.24 | 6.35 | 6.13 | 6.31 | 295860.0 |
| 2009-01-28 | CHY | ETF | 9.03 | 9.2 | 8.91 | 9.17 | 211063.0 |
| 2009-01-28 | CMF | ETF | 51.17 | 51.18 | 50.625 | 50.625 | 10262.0 |
| 2009-01-28 | CNXT | ETF | 0.72 | 0.72 | 0.69 | 0.7001 | 191663.0 |
| 2009-01-28 | COW | ETF | 31.2012 | 31.4384 | 31.17 | 31.28 | 12819.0 |
> showing 50 of 636 rows — these rows as CSV