PREVIEW / etf_daily / 2009-06-29
file: by_date/etf_daily/2009/2009-06-29.parquet size: 29 KB rows: 658
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-06-29 | SPY | ETF | 92.11 | 92.82 | 91.6 | 92.7 | 168481300.0 |
| 2009-06-29 | QQQ | ETF | 36.44 | 36.75 | 36.12 | 36.45 | 93817585.0 |
| 2009-06-29 | IWM | ETF | 51.33 | 51.58 | 50.4 | 51.23 | 49196600.0 |
| 2009-06-29 | DIA | ETF | 84.51 | 85.35 | 84.3 | 85.25 | 7529200.0 |
| 2009-06-29 | GLD | ETF | 92.32 | 92.4 | 91.71 | 92.04 | 6528700.0 |
| 2009-06-29 | TLT | ETF | 95.07 | 95.37 | 94.58 | 94.73 | 4334900.0 |
| 2009-06-29 | AAXJ | ETF | 44.75 | 44.92 | 44.23 | 44.91 | 214000.0 |
| 2009-06-29 | ACWI | ETF | 34.68 | 34.87 | 34.48 | 34.77 | 69300.0 |
| 2009-06-29 | ACWX | ETF | 33.5 | 33.67 | 33.279 | 33.63 | 234089.0 |
| 2009-06-29 | ADRE | ETF | 34.76 | 35.07 | 34.68 | 34.96 | 146643.0 |
| 2009-06-29 | AFK | ETF | 26.56 | 27.48 | 26.323 | 27.075 | 18517.0 |
| 2009-06-29 | AGG | ETF | 102.03 | 102.37 | 102.03 | 102.13 | 398400.0 |
| 2009-06-29 | AGQ | ETF | 86.16 | 86.18 | 84.44 | 84.6 | 76450.0 |
| 2009-06-29 | AGZ | ETF | 107.538 | 107.63 | 107.262 | 107.56 | 11264.0 |
| 2009-06-29 | AIA | ETF | 32.04 | 32.334 | 31.96 | 32.334 | 10043.0 |
| 2009-06-29 | AIQ | ETF | 37.0 | 37.4 | 35.2 | 36.8 | 62069.0 |
| 2009-06-29 | AIS | ETF | 1.05 | 1.21 | 0.98 | 1.06 | 11294776.0 |
| 2009-06-29 | AIVI | ETF | 35.29 | 35.52 | 34.83 | 35.38 | 18700.0 |
| 2009-06-29 | AMJ | ETF | 22.1605 | 22.39 | 22.1605 | 22.22 | 87029.0 |
| 2009-06-29 | AOA | ETF | 25.35 | 25.41 | 25.19 | 25.3 | 14400.0 |
| 2009-06-29 | AOK | ETF | 26.34 | 26.34 | 25.72 | 25.82 | 1750.0 |
| 2009-06-29 | AOM | ETF | 25.6 | 25.68 | 25.1388 | 25.64 | 1979.0 |
| 2009-06-29 | AOR | ETF | 25.65 | 25.65 | 25.451 | 25.56 | 4324.0 |
| 2009-06-29 | ARB | ETF | 16.15 | 16.43 | 16.08 | 16.16 | 293632.0 |
| 2009-06-29 | BAL | ETF | 29.67 | 29.67 | 29.235 | 29.235 | 1846.0 |
| 2009-06-29 | BBH | ETF | 31.3133 | 31.41 | 30.8367 | 31.31 | 703800.0 |
| 2009-06-29 | BIL | ETF | 91.76 | 91.76 | 91.74 | 91.76 | 136600.0 |
| 2009-06-29 | BITS | ETF | 18.96 | 20.72 | 18.96 | 19.28 | 9290.0 |
| 2009-06-29 | BIV | ETF | 77.35 | 77.41 | 77.02 | 77.12 | 131100.0 |
| 2009-06-29 | BJK | ETF | 21.49 | 21.49 | 20.37 | 21.13 | 15100.0 |
| 2009-06-29 | BKF | ETF | 36.04 | 36.265 | 35.6386 | 36.06 | 98520.0 |
| 2009-06-29 | BLV | ETF | 74.91 | 75.03 | 74.39 | 74.5 | 35300.0 |
| 2009-06-29 | BMVP | ETF | 10.96 | 11.04 | 10.92 | 11.03 | 5185.0 |
| 2009-06-29 | BND | ETF | 77.83 | 77.84 | 77.58 | 77.82 | 392500.0 |
| 2009-06-29 | BNE | ETF | 6.7 | 6.73 | 6.5 | 6.59 | 161388.0 |
| 2009-06-29 | BOSS | ETF | 15.8 | 16.19 | 15.8 | 16.19 | 200.0 |
| 2009-06-29 | BRF | ETF | 28.13 | 28.13 | 27.73 | 27.88 | 46069.0 |
| 2009-06-29 | BSV | ETF | 79.17 | 79.22 | 78.94 | 78.94 | 349500.0 |
| 2009-06-29 | BTF | ETF | 46.3 | 47.300000000000004 | 46.3 | 46.95 | 3537.0 |
| 2009-06-29 | BWX | ETF | 27.36 | 27.43 | 27.27 | 27.285 | 288658.0 |
| 2009-06-29 | BWZ | ETF | 35.2699 | 35.36 | 35.2342 | 35.36 | 17400.0 |
| 2009-06-29 | CBON | ETF | 1.0 | 1.0 | 0.9 | 0.93 | 22271.0 |
| 2009-06-29 | CEF | ETF | 11.96 | 12.02 | 11.82 | 11.82 | 377400.0 |
| 2009-06-29 | CEW | ETF | 21.0 | 21.0599 | 20.82 | 20.84 | 41584.0 |
| 2009-06-29 | CGO | ETF | 11.7 | 11.73 | 11.6258 | 11.6354 | 19911.0 |
| 2009-06-29 | CGW | ETF | 15.54 | 15.88 | 15.54 | 15.75 | 54333.0 |
| 2009-06-29 | CHB | ETF | 0.3399 | 0.35 | 0.32 | 0.34 | 688468.0 |
| 2009-06-29 | CHI | ETF | 10.42 | 10.5799 | 10.42 | 10.51 | 109387.0 |
| 2009-06-29 | CHIC | ETF | 12.48 | 12.83 | 12.16 | 12.71 | 201198.0 |
| 2009-06-29 | CHW | ETF | 6.96 | 6.99 | 6.86 | 6.99 | 182572.0 |
> showing 50 of 658 rows — these rows as CSV