PREVIEW / etf_daily / 2008-07-24
file: by_date/etf_daily/2008/2008-07-24.parquet size: 27 KB rows: 603
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-24 | SPY | ETF | 128.34 | 128.41 | 125.16 | 125.51 | 248634500.0 |
| 2008-07-24 | QQQ | ETF | 45.59 | 45.61 | 44.65 | 44.69 | 145560926.0 |
| 2008-07-24 | IWM | ETF | 71.87 | 71.93 | 69.86 | 70.11 | 112118900.0 |
| 2008-07-24 | DIA | ETF | 116.25 | 116.29 | 113.37 | 113.6 | 22459100.0 |
| 2008-07-24 | GLD | ETF | 91.08 | 91.62 | 90.25 | 91.33 | 13072100.0 |
| 2008-07-24 | TLT | ETF | 90.35 | 91.25 | 90.35 | 91.05 | 2613300.0 |
| 2008-07-24 | ACWI | ETF | 48.81 | 48.81 | 47.75 | 47.75 | 13200.0 |
| 2008-07-24 | ACWX | ETF | 49.42 | 49.42 | 48.44 | 48.44 | 97902.0 |
| 2008-07-24 | ADRE | ETF | 48.85 | 48.85 | 46.35 | 46.39 | 1219957.0 |
| 2008-07-24 | AFK | ETF | 40.19 | 40.2 | 39.31 | 39.31 | 2200.0 |
| 2008-07-24 | AGG | ETF | 99.41 | 100.01 | 99.35 | 99.97 | 320200.0 |
| 2008-07-24 | AIA | ETF | 42.99 | 42.99 | 41.21 | 41.39 | 561439.0 |
| 2008-07-24 | AIQ | ETF | 44.8 | 45.35 | 44.0 | 44.35 | 40779.0 |
| 2008-07-24 | AIS | ETF | 0.68 | 0.7 | 0.67 | 0.69 | 47000.0 |
| 2008-07-24 | AIVI | ETF | 61.43 | 61.44 | 60.28 | 60.28 | 33900.0 |
| 2008-07-24 | ARB | ETF | 46.26 | 46.36 | 45.13 | 45.25 | 456086.0 |
| 2008-07-24 | BAL | ETF | 45.74 | 45.74 | 45.74 | 45.74 | 100.0 |
| 2008-07-24 | BBH | ETF | 64.3367 | 65.2667 | 64.0 | 65.0 | 442800.0 |
| 2008-07-24 | BIL | ETF | 91.84 | 91.84 | 91.76 | 91.82 | 44500.0 |
| 2008-07-24 | BITS | ETF | 23.72 | 23.84 | 22.32 | 23.76 | 2945.0 |
| 2008-07-24 | BIV | ETF | 75.56 | 76.26 | 75.56 | 76.22 | 69300.0 |
| 2008-07-24 | BJK | ETF | 33.61 | 33.61 | 31.75 | 31.85 | 700.0 |
| 2008-07-24 | BKF | ETF | 50.26 | 50.26 | 48.0601 | 48.31 | 30362.0 |
| 2008-07-24 | BLV | ETF | 73.28 | 73.68 | 73.08 | 73.68 | 13000.0 |
| 2008-07-24 | BMVP | ETF | 14.963 | 14.963 | 14.66 | 14.678 | 53840.0 |
| 2008-07-24 | BND | ETF | 75.49 | 75.86 | 75.44 | 75.79 | 132400.0 |
| 2008-07-24 | BNE | ETF | 13.1 | 13.15 | 12.13 | 12.17 | 185524.0 |
| 2008-07-24 | BRF | ETF | 14.75 | 14.75 | 14.75 | 14.75 | 1000.0 |
| 2008-07-24 | BSV | ETF | 77.03 | 77.3 | 77.02 | 77.3 | 109600.0 |
| 2008-07-24 | BTF | ETF | 84.94999999999999 | 84.94999999999999 | 82.90050000000001 | 83.2 | 6100.200000000001 |
| 2008-07-24 | BWX | ETF | 27.65 | 27.75 | 27.58 | 27.75 | 169842.0 |
| 2008-07-24 | CBON | ETF | 4.54 | 4.585 | 2.8 | 3.0 | 1205958.0 |
| 2008-07-24 | CDL | ETF | 1.06 | 1.07 | 0.96 | 0.96 | 1089571.0 |
| 2008-07-24 | CEF | ETF | 12.55 | 13.05 | 12.55 | 12.99 | 875300.0 |
| 2008-07-24 | CGO | ETF | 15.33 | 15.33 | 14.63 | 14.82 | 13459.0 |
| 2008-07-24 | CGW | ETF | 23.96 | 23.96 | 23.23 | 23.29 | 40183.0 |
| 2008-07-24 | CHB | ETF | 3.57 | 3.87 | 3.55 | 3.61 | 4246044.0 |
| 2008-07-24 | CHI | ETF | 13.4 | 13.47 | 13.25 | 13.39 | 132099.0 |
| 2008-07-24 | CHIC | ETF | 13.06 | 13.59 | 12.05 | 12.47 | 1816627.0 |
| 2008-07-24 | CHW | ETF | 11.15 | 11.15 | 10.83 | 10.88 | 81320.0 |
| 2008-07-24 | CHY | ETF | 12.94 | 13.03 | 12.75 | 12.81 | 198939.0 |
| 2008-07-24 | CMF | ETF | 50.865 | 51.3 | 50.86 | 51.225 | 36814.0 |
| 2008-07-24 | CN | ETF | 57.49 | 60.38 | 57.49 | 58.22 | 424808.0 |
| 2008-07-24 | COW | ETF | 43.25 | 43.6 | 43.07 | 43.54 | 116557.0 |
| 2008-07-24 | CPST | ETF | 3.07 | 3.1 | 2.72 | 2.91 | 15385145.0 |
| 2008-07-24 | CSA | ETF | 18.76 | 18.89 | 18.1 | 18.2 | 37212.0 |
| 2008-07-24 | CSB | ETF | 18.0599 | 18.43 | 17.7 | 18.43 | 37470.0 |
| 2008-07-24 | CSD | ETF | 21.67 | 21.67 | 20.79 | 20.79 | 2300.0 |
| 2008-07-24 | CSQ | ETF | 11.11 | 11.164 | 10.96 | 11.06 | 323313.0 |
| 2008-07-24 | CUT | ETF | 18.74 | 18.82 | 18.4 | 18.55 | 12900.0 |
> showing 50 of 603 rows — these rows as CSV