PREVIEW / etf_daily / 2008-03-31
file: by_date/etf_daily/2008/2008-03-31.parquet size: 26 KB rows: 584
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-03-31 | SPY | ETF | 131.29 | 132.73 | 131.09 | 131.97 | 166692100.0 |
| 2008-03-31 | QQQ | ETF | 43.65 | 44.02 | 43.45 | 43.72 | 113644759.0 |
| 2008-03-31 | IWM | ETF | 68.21 | 69.22 | 67.81 | 68.29 | 64266300.0 |
| 2008-03-31 | DIA | ETF | 121.9 | 123.17 | 121.68 | 122.4 | 11656500.0 |
| 2008-03-31 | GLD | ETF | 92.56 | 92.65 | 89.96 | 90.41 | 11165000.0 |
| 2008-03-31 | TLT | ETF | 96.11 | 96.32 | 95.67 | 95.89 | 2546300.0 |
| 2008-03-31 | ACWI | ETF | 50.0 | 50.0 | 49.32 | 49.32 | 400.0 |
| 2008-03-31 | ACWX | ETF | 50.29 | 50.29 | 50.29 | 50.29 | 300.0 |
| 2008-03-31 | ADRE | ETF | 48.28 | 48.8 | 48.24 | 48.64 | 262405.0 |
| 2008-03-31 | AGG | ETF | 102.94 | 103.15 | 102.68 | 102.68 | 555900.0 |
| 2008-03-31 | AIA | ETF | 44.16 | 44.16 | 43.01 | 43.2 | 14200.0 |
| 2008-03-31 | AIQ | ETF | 42.75 | 43.6 | 42.45 | 43.0 | 26070.0 |
| 2008-03-31 | AIS | ETF | 0.9118 | 1.07 | 0.91 | 1.07 | 104200.0 |
| 2008-03-31 | AIVI | ETF | 63.64 | 64.09 | 63.64 | 63.83 | 5300.0 |
| 2008-03-31 | ARB | ETF | 42.72 | 43.41 | 42.5 | 43.16 | 228000.0 |
| 2008-03-31 | BBH | ETF | 56.8333 | 58.13 | 56.8333 | 57.85 | 454500.0 |
| 2008-03-31 | BIL | ETF | 91.88 | 91.94 | 91.82 | 91.9 | 64950.0 |
| 2008-03-31 | BITS | ETF | 21.0 | 22.4 | 21.0 | 22.32 | 5491.0 |
| 2008-03-31 | BIV | ETF | 80.26 | 80.26 | 79.54 | 79.6 | 39700.0 |
| 2008-03-31 | BJK | ETF | 39.36 | 39.36 | 39.25 | 39.25 | 900.0 |
| 2008-03-31 | BKF | ETF | 49.11 | 49.52 | 48.78 | 49.52 | 24200.0 |
| 2008-03-31 | BLV | ETF | 77.39 | 77.39 | 76.8 | 77.09 | 3500.0 |
| 2008-03-31 | BMVP | ETF | 15.26 | 15.38 | 15.22 | 15.36 | 26800.0 |
| 2008-03-31 | BND | ETF | 78.38 | 78.38 | 77.66 | 78.14 | 101600.0 |
| 2008-03-31 | BNE | ETF | 14.64 | 15.63 | 14.64 | 15.25 | 315600.0 |
| 2008-03-31 | BOSS | ETF | 34.5 | 34.5 | 34.5 | 34.5 | 100.0 |
| 2008-03-31 | BRF | ETF | 14.59 | 14.66 | 14.59 | 14.66 | 5800.0 |
| 2008-03-31 | BSV | ETF | 79.02 | 79.12 | 78.93 | 79.03 | 55400.0 |
| 2008-03-31 | BTF | ETF | 100.74999999999999 | 101.25 | 99.39999999999999 | 100.39999999999999 | 6360.0 |
| 2008-03-31 | BWX | ETF | 28.88 | 29.075 | 28.88 | 28.98 | 521552.0 |
| 2008-03-31 | CBON | ETF | 13.54 | 13.82 | 12.8195 | 13.56 | 273829.0 |
| 2008-03-31 | CDL | ETF | 1.56 | 1.66 | 1.54 | 1.66 | 1318983.0 |
| 2008-03-31 | CEF | ETF | 13.07 | 13.1 | 12.45 | 12.58 | 826100.0 |
| 2008-03-31 | CGO | ETF | 16.25 | 16.45 | 16.03 | 16.45 | 9400.0 |
| 2008-03-31 | CGW | ETF | 23.32 | 23.6514 | 23.3 | 23.5 | 62400.0 |
| 2008-03-31 | CHB | ETF | 9.44 | 10.2 | 9.3 | 10.03 | 1389115.0 |
| 2008-03-31 | CHI | ETF | 13.42 | 13.87 | 13.41 | 13.72 | 69100.0 |
| 2008-03-31 | CHIC | ETF | 17.25 | 17.5 | 17.12 | 17.34 | 956248.0 |
| 2008-03-31 | CHW | ETF | 11.14 | 11.26 | 11.02 | 11.2 | 111092.0 |
| 2008-03-31 | CHY | ETF | 12.4 | 12.7 | 12.4 | 12.66 | 117248.0 |
| 2008-03-31 | CMF | ETF | 51.83 | 51.85 | 51.75 | 51.79 | 18200.0 |
| 2008-03-31 | CN | ETF | 57.95 | 58.5 | 57.36 | 57.99 | 281916.0 |
| 2008-03-31 | CNXT | ETF | 0.56 | 0.5925 | 0.56 | 0.5799 | 2301064.0 |
| 2008-03-31 | COW | ETF | 40.16 | 40.29 | 39.69 | 40.08 | 51300.0 |
| 2008-03-31 | CPI | ETF | 17.75 | 17.9 | 17.75 | 17.75 | 64800.0 |
| 2008-03-31 | CPST | ETF | 2.13 | 2.23 | 2.1 | 2.12 | 2148364.0 |
| 2008-03-31 | CSA | ETF | 15.7 | 15.81 | 15.65 | 15.72 | 17000.0 |
| 2008-03-31 | CSB | ETF | 21.5 | 21.52 | 20.0 | 21.35 | 97800.0 |
| 2008-03-31 | CSD | ETF | 22.98 | 22.98 | 21.7 | 22.95 | 17900.0 |
| 2008-03-31 | CSQ | ETF | 11.98 | 12.17 | 11.98 | 12.11 | 246900.0 |
> showing 50 of 584 rows — these rows as CSV