PREVIEW / etf_daily / 2008-01-31
file: by_date/etf_daily/2008/2008-01-31.parquet size: 25 KB rows: 568
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-01-31 | SPY | ETF | 133.4 | 138.54 | 133.2 | 137.37 | 343680800.0 |
| 2008-01-31 | QQQ | ETF | 43.87 | 45.59 | 43.82 | 45.13 | 246824010.0 |
| 2008-01-31 | IWM | ETF | 68.11 | 71.56 | 68.0 | 70.94 | 117643600.0 |
| 2008-01-31 | DIA | ETF | 122.67 | 126.9 | 122.41 | 126.0 | 22253400.0 |
| 2008-01-31 | GLD | ETF | 90.92 | 91.66 | 90.74 | 91.4 | 7791500.0 |
| 2008-01-31 | TLT | ETF | 95.3 | 95.43 | 94.63 | 94.99 | 11441000.0 |
| 2008-01-31 | ADRE | ETF | 48.33 | 50.62 | 48.04 | 50.27 | 619536.0 |
| 2008-01-31 | AGG | ETF | 103.48 | 103.62 | 103.07 | 103.51 | 649200.0 |
| 2008-01-31 | AIA | ETF | 42.18 | 43.62 | 41.82 | 43.62 | 10000.0 |
| 2008-01-31 | AIQ | ETF | 48.75 | 53.6 | 48.0 | 52.95 | 142780.0 |
| 2008-01-31 | AIS | ETF | 1.0 | 1.08 | 1.0 | 1.06 | 187685.0 |
| 2008-01-31 | AIVI | ETF | 63.01 | 65.05 | 62.89 | 64.73 | 55500.0 |
| 2008-01-31 | ARB | ETF | 39.11 | 40.49 | 38.65 | 39.81 | 335685.0 |
| 2008-01-31 | BBH | ETF | 53.2833 | 54.8733 | 53.2833 | 54.5567 | 662700.0 |
| 2008-01-31 | BIL | ETF | 91.84 | 91.98 | 91.84 | 91.94 | 26150.0 |
| 2008-01-31 | BITS | ETF | 23.44 | 24.76 | 23.44 | 24.28 | 8850.0 |
| 2008-01-31 | BIV | ETF | 79.75 | 79.76 | 79.3 | 79.5 | 52000.0 |
| 2008-01-31 | BJK | ETF | 41.75 | 42.85 | 41.75 | 42.85 | 7200.0 |
| 2008-01-31 | BKF | ETF | 49.72 | 51.64 | 48.98 | 51.22 | 45600.0 |
| 2008-01-31 | BLV | ETF | 77.87 | 77.99 | 77.7 | 77.99 | 12900.0 |
| 2008-01-31 | BMVP | ETF | 15.6333 | 16.2033 | 15.6333 | 16.04 | 81645.0 |
| 2008-01-31 | BND | ETF | 78.61 | 78.63 | 78.29 | 78.35 | 120800.0 |
| 2008-01-31 | BNE | ETF | 12.35 | 12.62 | 12.19 | 12.3 | 372900.0 |
| 2008-01-31 | BRF | ETF | 14.71 | 14.73 | 14.64 | 14.73 | 28900.0 |
| 2008-01-31 | BSV | ETF | 78.86 | 78.87 | 78.61 | 78.8 | 46600.0 |
| 2008-01-31 | BTF | ETF | 108.64999999999999 | 111.5 | 108.0 | 110.74999999999999 | 4300.0 |
| 2008-01-31 | BWX | ETF | 27.54 | 27.575 | 27.385 | 27.465 | 147198.0 |
| 2008-01-31 | CBON | ETF | 15.5 | 17.07 | 15.5 | 16.7 | 176174.0 |
| 2008-01-31 | CDL | ETF | 1.46 | 1.56 | 1.44 | 1.46 | 2759254.0 |
| 2008-01-31 | CEF | ETF | 12.37 | 12.65 | 12.27 | 12.56 | 1471100.0 |
| 2008-01-31 | CGO | ETF | 17.23 | 18.0 | 17.169 | 18.0 | 15709.0 |
| 2008-01-31 | CGW | ETF | 23.42 | 23.76 | 22.92 | 23.6501 | 73350.0 |
| 2008-01-31 | CHB | ETF | 9.38 | 9.95 | 8.87 | 9.73 | 2734582.0 |
| 2008-01-31 | CHI | ETF | 15.87 | 16.15 | 15.7201 | 16.0 | 87095.0 |
| 2008-01-31 | CHIC | ETF | 17.11 | 18.27 | 16.7624 | 18.03 | 823656.0 |
| 2008-01-31 | CHW | ETF | 12.38 | 12.77 | 12.31 | 12.61 | 99378.0 |
| 2008-01-31 | CHY | ETF | 14.22 | 14.41 | 14.13 | 14.32 | 170056.0 |
| 2008-01-31 | CMF | ETF | 53.065 | 53.065 | 52.845 | 53.015 | 6600.0 |
| 2008-01-31 | CN | ETF | 60.63 | 63.39 | 60.6 | 62.35 | 221724.0 |
| 2008-01-31 | CNXT | ETF | 0.65 | 0.69 | 0.65 | 0.69 | 2591055.0 |
| 2008-01-31 | COW | ETF | 46.31 | 46.51 | 45.78 | 46.43 | 105700.0 |
| 2008-01-31 | CPST | ETF | 1.53 | 1.59 | 1.48 | 1.49 | 2792548.0 |
| 2008-01-31 | CSA | ETF | 16.65 | 17.45 | 16.37 | 16.92 | 72700.0 |
| 2008-01-31 | CSD | ETF | 25.04 | 25.15 | 25.04 | 25.15 | 600.0 |
| 2008-01-31 | CSQ | ETF | 13.49 | 13.88 | 13.42 | 13.78 | 278400.0 |
| 2008-01-31 | CUT | ETF | 21.44 | 21.8 | 21.25 | 21.8 | 12900.0 |
| 2008-01-31 | CVY | ETF | 22.98 | 23.86 | 22.82 | 23.69 | 24300.0 |
| 2008-01-31 | CWI | ETF | 23.9333 | 25.4467 | 23.9333 | 25.34 | 97350.0 |
| 2008-01-31 | CZA | ETF | 23.6 | 24.21 | 23.6 | 24.14 | 20400.0 |
| 2008-01-31 | DBA | ETF | 36.65 | 37.0 | 36.3 | 36.99 | 1260800.0 |
> showing 50 of 568 rows — these rows as CSV