PREVIEW / etf_daily / 2005-01-05
file: by_date/etf_daily/2005/2005-01-05.parquet size: 14 KB rows: 253
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-05 | SPY | ETF | 118.74 | 119.25 | 118.0 | 118.01 | 65667300.0 |
| 2005-01-05 | QQQ | ETF | 38.68 | 38.96 | 38.47 | 38.54 | 128424276.0 |
| 2005-01-05 | IWM | ETF | 62.47 | 62.64 | 61.29 | 61.29 | 29884200.0 |
| 2005-01-05 | DIA | ETF | 106.3 | 106.78 | 105.71 | 105.71 | 10885300.0 |
| 2005-01-05 | GLD | ETF | 42.75 | 42.88 | 42.6 | 42.67 | 2033600.0 |
| 2005-01-05 | TLT | ETF | 87.99 | 88.55 | 87.94 | 88.28 | 1094100.0 |
| 2005-01-05 | AAA | ETF | 61.8 | 61.8 | 61.3 | 61.3 | 1700.0 |
| 2005-01-05 | ADRE | ETF | 80.39 | 80.39 | 79.18 | 79.349 | 64840.0 |
| 2005-01-05 | AFK | ETF | 26.58 | 26.58 | 26.5 | 26.5 | 2500.0 |
| 2005-01-05 | AGG | ETF | 102.2 | 102.35 | 102.06 | 102.26 | 69900.0 |
| 2005-01-05 | AIQ | ETF | 62.4 | 62.4 | 58.75 | 59.0 | 80160.0 |
| 2005-01-05 | ARB | ETF | 37.97 | 38.08 | 37.68 | 37.94 | 217100.0 |
| 2005-01-05 | BAB | ETF | 43.78 | 43.82 | 43.18 | 43.39 | 77000.0 |
| 2005-01-05 | BBH | ETF | 49.7667 | 49.9533 | 49.2733 | 49.5 | 3942600.0 |
| 2005-01-05 | BCM | ETF | 58.8 | 59.14 | 58.57 | 58.6 | 30700.0 |
| 2005-01-05 | BIS | ETF | 944.0 | 944.0 | 944.0 | 944.0 | 0.625 |
| 2005-01-05 | BITS | ETF | 10.4 | 10.44 | 8.6 | 9.0 | 56172.0 |
| 2005-01-05 | BKF | ETF | 36.79 | 36.79 | 36.01 | 36.09 | 8400.0 |
| 2005-01-05 | BNE | ETF | 15.56 | 15.61 | 15.05 | 15.06 | 319500.0 |
| 2005-01-05 | BRF | ETF | 16.0 | 16.0 | 15.88 | 15.9 | 13700.0 |
| 2005-01-05 | BTF | ETF | 91.95 | 91.95 | 90.25 | 90.89999999999999 | 1780.0 |
| 2005-01-05 | CBON | ETF | 29.9 | 29.9 | 29.4 | 29.41 | 11100.0 |
| 2005-01-05 | CDC | ETF | 12.1 | 12.1 | 11.6 | 11.7 | 13800.0 |
| 2005-01-05 | CDL | ETF | 15.3 | 15.3 | 14.99 | 15.0 | 448900.0 |
| 2005-01-05 | CEF | ETF | 5.3 | 5.54 | 5.26 | 5.28 | 234500.0 |
| 2005-01-05 | CEW | ETF | 27.2 | 27.2 | 27.2 | 27.2 | 400.0 |
| 2005-01-05 | CHB | ETF | 12.04 | 12.04 | 11.68 | 11.78 | 438100.0 |
| 2005-01-05 | CHIC | ETF | 10.48 | 10.48 | 9.99 | 10.04 | 336207.0 |
| 2005-01-05 | CHIR | ETF | 34.89 | 35.7501 | 34.23 | 34.8 | 4096134.0 |
| 2005-01-05 | CID | ETF | 9.58 | 9.58 | 9.56 | 9.56 | 1200.0 |
| 2005-01-05 | CIZ | ETF | 20.75 | 20.75 | 20.75 | 20.75 | 200.0 |
| 2005-01-05 | CN | ETF | 25.5 | 25.65 | 25.3 | 25.65 | 166400.0 |
| 2005-01-05 | CNXT | ETF | 1.85 | 1.88 | 1.78 | 1.81 | 9779583.0 |
| 2005-01-05 | CSB | ETF | 36.55 | 36.61 | 36.35 | 36.59 | 7200.0 |
| 2005-01-05 | CSM | ETF | 2.375 | 2.375 | 2.375 | 2.375 | 800.0 |
| 2005-01-05 | CTEC | ETF | 40.14999999999999 | 40.65 | 38.45 | 40.14999999999999 | 8087.400000000001 |
| 2005-01-05 | CURE | ETF | 0.8638 | 0.89 | 0.795 | 0.7963 | 2077984.0 |
| 2005-01-05 | CYA | ETF | 242.0 | 242.0 | 232.0 | 235.2 | 1385.0 |
| 2005-01-05 | CYB | ETF | 4.09 | 4.09 | 4.03 | 4.08 | 2300.0 |
| 2005-01-05 | CZA | ETF | 10.37 | 10.37 | 10.37 | 10.37 | 500.0 |
| 2005-01-05 | DGT | ETF | 63.53 | 63.59 | 63.3 | 63.3 | 5400.0 |
| 2005-01-05 | DIG | ETF | 12.325 | 12.325 | 12.3125 | 12.3125 | 1200.0 |
| 2005-01-05 | DIV | ETF | 14.18 | 14.32 | 14.1 | 14.18 | 32300.0 |
| 2005-01-05 | DRIV | ETF | 36.0 | 37.06 | 35.15 | 36.36 | 1478141.0 |
| 2005-01-05 | DSI | ETF | 5.915 | 5.915 | 5.91 | 5.91 | 5000.0 |
| 2005-01-05 | DTH | ETF | 25.18 | 25.34 | 25.18 | 25.34 | 3300.0 |
| 2005-01-05 | DUSA | ETF | 14.4 | 14.7 | 14.18 | 14.29 | 146167.0 |
| 2005-01-05 | DVY | ETF | 60.15 | 60.2 | 59.61 | 59.68 | 2245700.0 |
| 2005-01-05 | EDEN | ETF | 1.25 | 1.38 | 1.2 | 1.3 | 329318.0 |
| 2005-01-05 | EDV | ETF | 26.53 | 26.53 | 26.3 | 26.3 | 13000.0 |
> showing 50 of 253 rows — these rows as CSV