PREVIEW / etf_daily / 2009-01-30
file: by_date/etf_daily/2009/2009-01-30.parquet size: 28 KB rows: 637
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-30 | SPY | ETF | 84.98 | 85.4 | 82.21 | 82.83 | 383383600.0 |
| 2009-01-30 | QQQ | ETF | 29.82 | 29.93 | 28.94 | 29.06 | 140355212.0 |
| 2009-01-30 | IWM | ETF | 45.76 | 46.01 | 44.11 | 44.48 | 58185500.0 |
| 2009-01-30 | DIA | ETF | 81.83 | 81.96 | 79.6 | 80.08 | 26172600.0 |
| 2009-01-30 | GLD | ETF | 90.7 | 91.49 | 89.65 | 91.31 | 21279300.0 |
| 2009-01-30 | TLT | ETF | 104.55 | 104.87 | 103.44 | 103.75 | 2630000.0 |
| 2009-01-30 | AAXJ | ETF | 30.94 | 31.66 | 30.39 | 30.79 | 29000.0 |
| 2009-01-30 | ACWI | ETF | 29.43 | 29.57 | 28.62 | 28.73 | 149300.0 |
| 2009-01-30 | ACWX | ETF | 27.41 | 27.41 | 26.45 | 26.6 | 142743.0 |
| 2009-01-30 | ADRE | ETF | 26.19 | 26.51 | 25.68 | 25.83 | 1048925.0 |
| 2009-01-30 | AFK | ETF | 18.03 | 18.04 | 17.52 | 17.68 | 20604.0 |
| 2009-01-30 | AGG | ETF | 101.65 | 102.33 | 101.63 | 102.13 | 608300.0 |
| 2009-01-30 | AGQ | ETF | 75.2 | 77.22 | 72.94 | 77.16 | 37600.0 |
| 2009-01-30 | AGZ | ETF | 107.352 | 107.69 | 107.352 | 107.46 | 9505.0 |
| 2009-01-30 | AIA | ETF | 23.47 | 23.7 | 23.0 | 23.29 | 17703.0 |
| 2009-01-30 | AIQ | ETF | 45.4 | 45.9 | 44.05 | 44.3 | 37979.0 |
| 2009-01-30 | AIS | ETF | 0.52 | 0.52 | 0.47 | 0.48 | 14400.0 |
| 2009-01-30 | AIVI | ETF | 28.96 | 29.15 | 28.46 | 28.49 | 13100.0 |
| 2009-01-30 | AOA | ETF | 22.35 | 22.69 | 22.3 | 22.31 | 3600.0 |
| 2009-01-30 | AOK | ETF | 25.01 | 25.01 | 25.01 | 25.01 | 200.0 |
| 2009-01-30 | AOM | ETF | 24.21 | 24.34 | 24.06 | 24.34 | 4355.0 |
| 2009-01-30 | AOR | ETF | 23.74 | 23.74 | 23.46 | 23.46 | 1108.0 |
| 2009-01-30 | ARB | ETF | 15.28 | 15.44 | 14.8 | 15.02 | 453597.0 |
| 2009-01-30 | BAL | ETF | 29.31 | 30.9 | 28.17 | 29.3 | 33391.0 |
| 2009-01-30 | BBH | ETF | 57.08 | 57.12 | 56.3933 | 56.5133 | 226200.0 |
| 2009-01-30 | BIL | ETF | 91.68 | 91.76 | 91.68 | 91.76 | 141800.0 |
| 2009-01-30 | BITS | ETF | 19.6 | 20.1936 | 19.56 | 20.0 | 1301.0 |
| 2009-01-30 | BIV | ETF | 77.54 | 77.66 | 76.76 | 77.11 | 152400.0 |
| 2009-01-30 | BJK | ETF | 15.87 | 15.87 | 15.5 | 15.5 | 500.0 |
| 2009-01-30 | BKF | ETF | 23.31 | 23.42 | 22.45 | 22.45 | 34023.0 |
| 2009-01-30 | BLV | ETF | 75.49 | 75.49 | 74.79 | 75.1 | 21300.0 |
| 2009-01-30 | BMVP | ETF | 10.39 | 10.47 | 10.07 | 10.09 | 41990.0 |
| 2009-01-30 | BND | ETF | 77.04 | 77.46 | 77.03 | 77.33 | 337400.0 |
| 2009-01-30 | BNE | ETF | 2.95 | 3.02 | 2.68 | 2.8 | 339249.0 |
| 2009-01-30 | BSV | ETF | 79.74 | 79.8 | 79.49 | 79.67 | 172600.0 |
| 2009-01-30 | BTF | ETF | 47.15 | 47.15 | 46.5 | 46.5 | 2536.0 |
| 2009-01-30 | BWX | ETF | 25.525 | 25.525 | 25.275 | 25.375 | 298664.0 |
| 2009-01-30 | BWZ | ETF | 32.77 | 32.77 | 32.77 | 32.77 | 150.0 |
| 2009-01-30 | CBON | ETF | 2.99 | 2.99 | 2.62 | 2.7 | 16442.0 |
| 2009-01-30 | CDL | ETF | 0.18 | 0.2 | 0.17 | 0.18 | 463328.0 |
| 2009-01-30 | CEF | ETF | 11.09 | 11.18 | 10.89 | 11.15 | 1267100.0 |
| 2009-01-30 | CGO | ETF | 9.97 | 9.99 | 9.48 | 9.5492 | 9689.0 |
| 2009-01-30 | CGW | ETF | 13.27 | 13.4267 | 12.77 | 12.79 | 138418.0 |
| 2009-01-30 | CHB | ETF | 0.48 | 0.51 | 0.46 | 0.46 | 270698.0 |
| 2009-01-30 | CHI | ETF | 9.2 | 9.24 | 9.12 | 9.14 | 222133.0 |
| 2009-01-30 | CHIC | ETF | 4.98 | 5.22 | 4.8 | 5.15 | 236593.0 |
| 2009-01-30 | CHW | ETF | 6.2 | 6.2 | 5.9139 | 6.11 | 255248.0 |
| 2009-01-30 | CHY | ETF | 9.15 | 9.19 | 8.9 | 8.99 | 201357.0 |
| 2009-01-30 | CMF | ETF | 50.495 | 50.942 | 50.495 | 50.685 | 8162.0 |
| 2009-01-30 | CNXT | ETF | 0.7 | 0.7 | 0.66 | 0.66 | 196316.0 |
> showing 50 of 637 rows — these rows as CSV