PREVIEW / etf_daily / 2008-05-19
file: by_date/etf_daily/2008/2008-05-19.parquet size: 27 KB rows: 593
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-05-19 | SPY | ETF | 142.81 | 144.3 | 142.3 | 143.05 | 165664400.0 |
| 2008-05-19 | QQQ | ETF | 50.05 | 50.47 | 49.34 | 49.65 | 140179612.0 |
| 2008-05-19 | IWM | ETF | 74.03 | 74.74 | 73.47 | 73.97 | 102762700.0 |
| 2008-05-19 | DIA | ETF | 129.71 | 131.26 | 129.51 | 130.23 | 10824800.0 |
| 2008-05-19 | GLD | ETF | 89.57 | 89.7 | 88.87 | 89.39 | 5931200.0 |
| 2008-05-19 | TLT | ETF | 92.26 | 92.26 | 91.3 | 91.96 | 1348200.0 |
| 2008-05-19 | ACWI | ETF | 54.6 | 55.24 | 54.6 | 54.71 | 12300.0 |
| 2008-05-19 | ACWX | ETF | 56.47 | 56.63 | 56.35 | 56.4 | 4972.0 |
| 2008-05-19 | ADRE | ETF | 57.83 | 58.56 | 57.63 | 57.84 | 283421.0 |
| 2008-05-19 | AGG | ETF | 102.15 | 102.19 | 101.8 | 102.08 | 630400.0 |
| 2008-05-19 | AIA | ETF | 48.75 | 48.75 | 47.89 | 48.39 | 8568.0 |
| 2008-05-19 | AIQ | ETF | 43.75 | 44.45 | 43.0 | 44.05 | 29383.0 |
| 2008-05-19 | AIS | ETF | 0.84 | 0.84 | 0.77 | 0.79 | 104246.0 |
| 2008-05-19 | AIVI | ETF | 68.45 | 68.67 | 68.04 | 68.14 | 50200.0 |
| 2008-05-19 | ARB | ETF | 49.17 | 49.26 | 48.1 | 48.73 | 277063.0 |
| 2008-05-19 | BBH | ETF | 55.25 | 55.6867 | 54.93 | 55.4333 | 453900.0 |
| 2008-05-19 | BIL | ETF | 91.6 | 91.68 | 91.58 | 91.62 | 22950.0 |
| 2008-05-19 | BITS | ETF | 26.2 | 26.52 | 24.56 | 25.12 | 9142.0 |
| 2008-05-19 | BIV | ETF | 78.16 | 78.16 | 77.65 | 78.12 | 47100.0 |
| 2008-05-19 | BJK | ETF | 40.01 | 40.02 | 39.8 | 39.8 | 3200.0 |
| 2008-05-19 | BKF | ETF | 60.41 | 60.96 | 60.11 | 60.11 | 69943.0 |
| 2008-05-19 | BLV | ETF | 76.36 | 76.36 | 75.64 | 75.91 | 25200.0 |
| 2008-05-19 | BMVP | ETF | 16.5467 | 16.7023 | 16.5367 | 16.5707 | 21822.0 |
| 2008-05-19 | BND | ETF | 77.4 | 77.45 | 77.13 | 77.44 | 548600.0 |
| 2008-05-19 | BNE | ETF | 16.13 | 16.17 | 15.42 | 15.78 | 416015.0 |
| 2008-05-19 | BRF | ETF | 14.7 | 14.7 | 14.7 | 14.7 | 700.0 |
| 2008-05-19 | BSV | ETF | 77.84 | 78.05 | 77.84 | 78.03 | 66600.0 |
| 2008-05-19 | BTF | ETF | 102.10000000000001 | 103.24999999999999 | 102.10000000000001 | 102.35 | 10765.0 |
| 2008-05-19 | BWX | ETF | 28.05 | 28.14 | 27.86 | 27.9545 | 244090.0 |
| 2008-05-19 | CBON | ETF | 8.66 | 8.83 | 8.01 | 8.41 | 263721.0 |
| 2008-05-19 | CDL | ETF | 1.7 | 1.79 | 1.67 | 1.7 | 1182555.0 |
| 2008-05-19 | CEF | ETF | 12.44 | 12.58 | 12.38 | 12.44 | 520000.0 |
| 2008-05-19 | CGO | ETF | 17.1 | 17.2 | 16.97 | 16.99 | 19825.0 |
| 2008-05-19 | CGW | ETF | 25.55 | 25.57 | 25.25 | 25.33 | 115050.0 |
| 2008-05-19 | CHB | ETF | 8.99 | 9.15 | 8.73 | 8.93 | 1214999.0 |
| 2008-05-19 | CHI | ETF | 15.41 | 15.55 | 15.35 | 15.53 | 123453.0 |
| 2008-05-19 | CHIC | ETF | 17.5 | 18.1 | 17.34 | 18.02 | 395067.0 |
| 2008-05-19 | CHW | ETF | 12.52 | 12.59 | 12.41 | 12.5818 | 170734.0 |
| 2008-05-19 | CHY | ETF | 14.08 | 14.3 | 14.01 | 14.25 | 135330.0 |
| 2008-05-19 | CMF | ETF | 52.43 | 52.7 | 52.43 | 52.62 | 16550.0 |
| 2008-05-19 | CN | ETF | 60.71 | 60.71 | 59.88 | 59.96 | 499367.0 |
| 2008-05-19 | CNXT | ETF | 0.47 | 0.48 | 0.46 | 0.48 | 2825480.0 |
| 2008-05-19 | COW | ETF | 43.87 | 43.89 | 43.29 | 43.47 | 84889.0 |
| 2008-05-19 | CPI | ETF | 20.6 | 20.7661 | 20.6 | 20.7661 | 700.0 |
| 2008-05-19 | CPST | ETF | 3.63 | 3.88 | 3.6101 | 3.72 | 11019140.0 |
| 2008-05-19 | CSA | ETF | 17.75 | 18.22 | 17.59 | 17.99 | 26859.0 |
| 2008-05-19 | CSB | ETF | 23.25 | 23.6 | 23.25 | 23.6 | 36772.0 |
| 2008-05-19 | CSD | ETF | 25.0 | 25.16 | 24.91 | 24.95 | 8200.0 |
| 2008-05-19 | CSQ | ETF | 13.01 | 13.14 | 13.01 | 13.11 | 302767.0 |
| 2008-05-19 | CUT | ETF | 22.25 | 22.4 | 22.15 | 22.17 | 28600.0 |
> showing 50 of 593 rows — these rows as CSV