PREVIEW / etf_daily / 2009-01-22
file: by_date/etf_daily/2009/2009-01-22.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-22 | SPY | ETF | 82.42 | 84.04 | 81.17 | 82.75 | 427940300.0 |
| 2009-01-22 | QQQ | ETF | 28.52 | 29.23 | 28.26 | 28.76 | 200602616.0 |
| 2009-01-22 | IWM | ETF | 44.52 | 45.33 | 43.37 | 44.17 | 69790800.0 |
| 2009-01-22 | DIA | ETF | 80.9 | 82.04 | 79.55 | 81.16 | 40157400.0 |
| 2009-01-22 | GLD | ETF | 84.03 | 84.97 | 83.83 | 84.58 | 18569600.0 |
| 2009-01-22 | TLT | ETF | 110.6 | 110.77 | 107.88 | 108.54 | 4016600.0 |
| 2009-01-22 | AAXJ | ETF | 29.14 | 30.06 | 29.14 | 29.43 | 113500.0 |
| 2009-01-22 | ACWI | ETF | 28.63 | 28.96 | 28.02 | 28.53 | 343500.0 |
| 2009-01-22 | ACWX | ETF | 26.29 | 26.75 | 25.88 | 26.34 | 387858.0 |
| 2009-01-22 | ADRE | ETF | 25.01 | 25.32 | 24.36 | 24.95 | 328080.0 |
| 2009-01-22 | AFK | ETF | 18.46 | 18.47 | 17.7601 | 17.7601 | 600.0 |
| 2009-01-22 | AGG | ETF | 102.69 | 102.69 | 101.8 | 102.08 | 446800.0 |
| 2009-01-22 | AGQ | ETF | 62.94 | 63.98 | 61.92 | 63.4 | 19200.0 |
| 2009-01-22 | AGZ | ETF | 107.61 | 107.93 | 107.402 | 107.92 | 7079.0 |
| 2009-01-22 | AIA | ETF | 22.24 | 22.7 | 22.2 | 22.7 | 14821.0 |
| 2009-01-22 | AIQ | ETF | 42.9 | 43.6 | 41.7 | 42.95 | 26033.0 |
| 2009-01-22 | AIS | ETF | 0.47 | 0.48 | 0.45 | 0.4799 | 26860.0 |
| 2009-01-22 | AIVI | ETF | 29.45 | 29.45 | 27.83 | 28.26 | 161700.0 |
| 2009-01-22 | AOA | ETF | 21.93 | 22.65 | 20.86 | 22.65 | 24400.0 |
| 2009-01-22 | AOK | ETF | 24.95 | 24.95 | 24.83 | 24.95 | 2445.0 |
| 2009-01-22 | AOM | ETF | 24.15 | 24.15 | 24.13 | 24.13 | 1199.0 |
| 2009-01-22 | AOR | ETF | 23.05 | 23.8 | 23.05 | 23.7 | 1726.0 |
| 2009-01-22 | ARB | ETF | 14.72 | 14.94 | 14.1 | 14.27 | 347175.0 |
| 2009-01-22 | BAL | ETF | 27.72 | 28.65 | 27.72 | 28.65 | 600.0 |
| 2009-01-22 | BBH | ETF | 56.4833 | 57.0367 | 56.05 | 56.7467 | 157800.0 |
| 2009-01-22 | BIL | ETF | 91.68 | 91.8 | 91.68 | 91.8 | 116900.0 |
| 2009-01-22 | BITS | ETF | 18.44 | 19.36 | 16.44 | 19.36 | 2650.0 |
| 2009-01-22 | BIV | ETF | 77.87 | 77.87 | 77.25 | 77.36 | 88400.0 |
| 2009-01-22 | BJK | ETF | 15.83 | 15.95 | 15.83 | 15.95 | 300.0 |
| 2009-01-22 | BKF | ETF | 21.26 | 21.94 | 21.1535 | 21.627 | 34876.0 |
| 2009-01-22 | BLV | ETF | 76.83 | 76.83 | 75.66 | 76.19 | 19200.0 |
| 2009-01-22 | BMVP | ETF | 10.1058 | 10.2767 | 9.9489 | 10.1021 | 47016.0 |
| 2009-01-22 | BND | ETF | 77.62 | 77.83 | 77.17 | 77.71 | 373600.0 |
| 2009-01-22 | BNE | ETF | 3.4 | 3.48 | 2.91 | 2.92 | 179258.0 |
| 2009-01-22 | BSV | ETF | 79.57 | 79.73 | 78.8 | 79.56 | 152000.0 |
| 2009-01-22 | BTF | ETF | 45.99999999999999 | 48.49999999999999 | 45.65 | 46.39999999999999 | 8291.0 |
| 2009-01-22 | BWX | ETF | 25.355 | 25.705 | 25.3 | 25.7 | 180282.0 |
| 2009-01-22 | CBON | ETF | 2.3 | 2.48 | 2.24 | 2.24 | 21037.0 |
| 2009-01-22 | CDL | ETF | 0.2 | 0.21 | 0.2 | 0.2 | 368071.0 |
| 2009-01-22 | CEF | ETF | 10.49 | 10.68 | 10.47 | 10.59 | 545200.0 |
| 2009-01-22 | CGO | ETF | 9.6 | 9.6 | 9.26 | 9.39 | 17179.0 |
| 2009-01-22 | CGW | ETF | 13.0 | 13.0 | 12.52 | 12.8364 | 28019.0 |
| 2009-01-22 | CHB | ETF | 0.52 | 0.55 | 0.49 | 0.49 | 371584.0 |
| 2009-01-22 | CHI | ETF | 8.95 | 8.95 | 8.7 | 8.84 | 271481.0 |
| 2009-01-22 | CHIC | ETF | 5.02 | 5.09 | 4.5 | 4.6 | 550725.0 |
| 2009-01-22 | CHW | ETF | 5.8 | 5.83 | 5.6 | 5.77 | 198085.0 |
| 2009-01-22 | CHY | ETF | 8.95 | 8.95 | 8.54 | 8.78 | 402058.0 |
| 2009-01-22 | CMF | ETF | 50.1775 | 51.05 | 50.1775 | 50.8 | 9500.0 |
| 2009-01-22 | CNXT | ETF | 0.68 | 0.69 | 0.651 | 0.67 | 110024.0 |
| 2009-01-22 | COW | ETF | 32.2 | 32.25 | 32.0 | 32.15 | 74004.0 |
> showing 50 of 636 rows — these rows as CSV