PREVIEW / etf_daily / 2008-11-21
file: by_date/etf_daily/2008/2008-11-21.parquet size: 27 KB rows: 622
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-11-21 | SPY | ETF | 77.46 | 80.9 | 74.34 | 79.52 | 718536500.0 |
| 2008-11-21 | QQQ | ETF | 25.96 | 26.68 | 25.05 | 26.67 | 282766446.0 |
| 2008-11-21 | IWM | ETF | 39.29 | 40.85 | 37.12 | 40.64 | 160636700.0 |
| 2008-11-21 | DIA | ETF | 77.13 | 80.73 | 74.5 | 80.54 | 91695200.0 |
| 2008-11-21 | GLD | ETF | 76.0 | 79.0 | 75.45 | 78.85 | 30467400.0 |
| 2008-11-21 | TLT | ETF | 103.25 | 103.98 | 101.45 | 102.92 | 3249300.0 |
| 2008-11-21 | AAXJ | ETF | 27.28 | 28.5 | 26.2 | 28.5 | 282700.0 |
| 2008-11-21 | ACWI | ETF | 26.21 | 28.06 | 26.21 | 27.83 | 124500.0 |
| 2008-11-21 | ACWX | ETF | 25.09 | 25.7 | 24.08 | 25.7 | 259721.0 |
| 2008-11-21 | ADRE | ETF | 22.02 | 22.92 | 21.13 | 22.92 | 675112.0 |
| 2008-11-21 | AFK | ETF | 19.8201 | 20.72 | 19.8201 | 20.72 | 500.0 |
| 2008-11-21 | AGG | ETF | 97.4 | 97.86 | 96.42 | 96.62 | 1015200.0 |
| 2008-11-21 | AGZ | ETF | 102.45 | 102.61 | 102.45 | 102.61 | 14200.0 |
| 2008-11-21 | AIA | ETF | 21.1 | 22.72 | 20.505 | 22.32 | 32696.0 |
| 2008-11-21 | AIQ | ETF | 37.85 | 38.4 | 30.75 | 37.25 | 73779.0 |
| 2008-11-21 | AIS | ETF | 0.34 | 0.38 | 0.33 | 0.35 | 209805.0 |
| 2008-11-21 | AIVI | ETF | 31.41 | 31.72 | 30.14 | 31.72 | 50600.0 |
| 2008-11-21 | AOA | ETF | 20.36 | 20.36 | 20.36 | 20.36 | 1400.0 |
| 2008-11-21 | AOM | ETF | 23.09 | 23.09 | 22.96 | 22.96 | 947.0 |
| 2008-11-21 | AOR | ETF | 22.0 | 22.0 | 22.0 | 22.0 | 100.0 |
| 2008-11-21 | ARB | ETF | 15.2 | 15.44 | 13.17 | 13.95 | 1038761.0 |
| 2008-11-21 | BAL | ETF | 24.37 | 24.37 | 24.076 | 24.076 | 1000.0 |
| 2008-11-21 | BBH | ETF | 51.3567 | 52.9133 | 49.3533 | 51.5667 | 751800.0 |
| 2008-11-21 | BIL | ETF | 91.88 | 91.9 | 91.8 | 91.86 | 233750.0 |
| 2008-11-21 | BITS | ETF | 15.4 | 16.4 | 15.0 | 16.0 | 9925.0 |
| 2008-11-21 | BIV | ETF | 73.6 | 74.05 | 73.31 | 73.86 | 160900.0 |
| 2008-11-21 | BJK | ETF | 13.87 | 14.16 | 13.61 | 14.16 | 2900.0 |
| 2008-11-21 | BKF | ETF | 19.32 | 20.5 | 19.19 | 20.5 | 58890.0 |
| 2008-11-21 | BLV | ETF | 71.06 | 71.25 | 70.02 | 70.7 | 30900.0 |
| 2008-11-21 | BMVP | ETF | 8.94 | 9.3766 | 8.6433 | 9.3766 | 120816.0 |
| 2008-11-21 | BND | ETF | 74.33 | 75.05 | 74.17 | 74.5 | 269000.0 |
| 2008-11-21 | BNE | ETF | 2.06 | 2.09 | 1.86 | 1.97 | 286546.0 |
| 2008-11-21 | BRF | ETF | 14.91 | 14.92 | 14.87 | 14.91 | 22200.0 |
| 2008-11-21 | BSV | ETF | 78.0 | 78.19 | 77.1 | 77.89 | 249900.0 |
| 2008-11-21 | BTF | ETF | 40.7 | 40.7 | 34.65 | 37.85 | 36550.4 |
| 2008-11-21 | BWX | ETF | 24.695 | 24.695 | 24.4 | 24.5 | 350474.0 |
| 2008-11-21 | CBON | ETF | 2.59 | 2.65 | 2.25 | 2.3 | 137399.0 |
| 2008-11-21 | CDL | ETF | 0.22 | 0.23 | 0.18 | 0.23 | 2095073.0 |
| 2008-11-21 | CEF | ETF | 9.0 | 9.63 | 8.85 | 9.43 | 1219400.0 |
| 2008-11-21 | CGO | ETF | 7.51 | 7.7 | 7.05 | 7.48 | 31922.0 |
| 2008-11-21 | CGW | ETF | 12.62 | 13.36 | 12.33 | 13.35 | 95369.0 |
| 2008-11-21 | CHB | ETF | 0.53 | 0.76 | 0.4 | 0.68 | 1897659.0 |
| 2008-11-21 | CHI | ETF | 6.61 | 6.7 | 5.66 | 6.01 | 439683.0 |
| 2008-11-21 | CHIC | ETF | 4.4 | 4.7 | 4.21 | 4.62 | 498494.0 |
| 2008-11-21 | CHW | ETF | 4.33 | 4.39 | 3.57 | 4.39 | 485768.0 |
| 2008-11-21 | CHY | ETF | 5.64 | 5.98 | 5.1 | 5.92 | 633965.0 |
| 2008-11-21 | CMF | ETF | 50.29 | 50.29 | 48.82 | 49.39 | 4794.0 |
| 2008-11-21 | CNXT | ETF | 0.74 | 0.82 | 0.68 | 0.68 | 409842.0 |
| 2008-11-21 | COW | ETF | 34.22 | 34.55 | 34.04 | 34.04 | 59776.0 |
| 2008-11-21 | CPST | ETF | 0.66 | 0.7 | 0.6101 | 0.68 | 1822562.0 |
> showing 50 of 622 rows — these rows as CSV