PREVIEW / etf_daily / 2005-01-25
file: by_date/etf_daily/2005/2005-01-25.parquet size: 14 KB rows: 254
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-25 | SPY | ETF | 116.91 | 117.47 | 116.72 | 116.88 | 68245000.0 |
| 2005-01-25 | QQQ | ETF | 36.77 | 37.09 | 36.66 | 36.71 | 120045513.0 |
| 2005-01-25 | IWM | ETF | 60.58 | 61.1 | 60.23 | 60.47 | 22059200.0 |
| 2005-01-25 | DIA | ETF | 104.09 | 105.01 | 104.05 | 104.59 | 9751100.0 |
| 2005-01-25 | GLD | ETF | 42.53 | 42.56 | 42.1 | 42.24 | 1332500.0 |
| 2005-01-25 | TLT | ETF | 91.36 | 91.4 | 90.51 | 90.54 | 1942200.0 |
| 2005-01-25 | AAA | ETF | 57.5 | 57.68 | 57.35 | 57.59 | 8300.0 |
| 2005-01-25 | ADRE | ETF | 79.932 | 80.259 | 79.8 | 79.86 | 5168.0 |
| 2005-01-25 | AFK | ETF | 26.44 | 26.48 | 26.41 | 26.41 | 6900.0 |
| 2005-01-25 | AGG | ETF | 102.94 | 102.97 | 102.77 | 102.87 | 79600.0 |
| 2005-01-25 | AIQ | ETF | 62.5 | 65.75 | 62.25 | 65.0 | 30140.0 |
| 2005-01-25 | ARB | ETF | 37.5 | 40.54 | 37.5 | 40.36 | 632600.0 |
| 2005-01-25 | BAB | ETF | 46.42 | 46.86 | 46.34 | 46.66 | 22000.0 |
| 2005-01-25 | BBH | ETF | 47.3433 | 48.21 | 47.0867 | 47.5333 | 2945100.0 |
| 2005-01-25 | BCM | ETF | 55.21 | 55.37 | 55.0 | 55.36 | 20700.0 |
| 2005-01-25 | BITS | ETF | 9.8 | 9.92 | 9.6 | 9.6 | 4664.0 |
| 2005-01-25 | BKF | ETF | 36.9 | 37.4 | 36.65 | 36.66 | 29500.0 |
| 2005-01-25 | BNE | ETF | 14.72 | 14.75 | 14.15 | 14.3 | 206900.0 |
| 2005-01-25 | BRF | ETF | 15.61 | 15.66 | 15.61 | 15.66 | 5100.0 |
| 2005-01-25 | BTF | ETF | 90.6 | 90.6 | 90.25 | 90.44999999999999 | 820.0 |
| 2005-01-25 | CBON | ETF | 28.01 | 28.01 | 27.3 | 27.5 | 88116.0 |
| 2005-01-25 | CDC | ETF | 8.7 | 9.1 | 8.7 | 9.1 | 6100.0 |
| 2005-01-25 | CDL | ETF | 14.09 | 14.18 | 14.0 | 14.0 | 275400.0 |
| 2005-01-25 | CEF | ETF | 5.26 | 5.28 | 5.23 | 5.23 | 182200.0 |
| 2005-01-25 | CEW | ETF | 27.45 | 27.45 | 27.41 | 27.41 | 800.0 |
| 2005-01-25 | CGW | ETF | 27.6 | 27.6 | 27.6 | 27.6 | 100.0 |
| 2005-01-25 | CHB | ETF | 10.2 | 10.66 | 10.19 | 10.5 | 318800.0 |
| 2005-01-25 | CHIC | ETF | 9.56 | 9.71 | 9.45 | 9.68 | 596834.0 |
| 2005-01-25 | CHIR | ETF | 33.7599 | 34.4601 | 33.36 | 33.7401 | 1339669.0 |
| 2005-01-25 | CID | ETF | 9.12 | 9.12 | 9.12 | 9.12 | 1000.0 |
| 2005-01-25 | CIL | ETF | 26.4 | 26.4 | 26.4 | 26.4 | 300.0 |
| 2005-01-25 | CIZ | ETF | 20.2 | 20.3 | 20.2 | 20.3 | 400.0 |
| 2005-01-25 | CN | ETF | 27.9 | 28.1 | 27.9 | 28.0 | 313700.0 |
| 2005-01-25 | CNXT | ETF | 1.565 | 1.58 | 1.5 | 1.51 | 5811384.0 |
| 2005-01-25 | CPI | ETF | 20.4 | 20.4 | 20.0 | 20.0 | 1200.0 |
| 2005-01-25 | CSB | ETF | 35.65 | 35.65 | 35.15 | 35.45 | 4500.0 |
| 2005-01-25 | CSM | ETF | 2.3825 | 2.3825 | 2.3825 | 2.3825 | 2000.0 |
| 2005-01-25 | CTEC | ETF | 51.3 | 56.449999999999996 | 51.25 | 56.25 | 38377.8 |
| 2005-01-25 | CURE | ETF | 0.64 | 0.6488 | 0.6312 | 0.6375 | 1343200.0 |
| 2005-01-25 | CYA | ETF | 174.0 | 183.8 | 174.0 | 182.8 | 890.0 |
| 2005-01-25 | CYB | ETF | 4.15 | 4.15 | 3.9 | 3.95 | 17600.0 |
| 2005-01-25 | CZA | ETF | 10.21 | 10.22 | 10.17 | 10.22 | 2600.0 |
| 2005-01-25 | DGT | ETF | 62.75 | 62.87 | 62.75 | 62.75 | 2600.0 |
| 2005-01-25 | DIG | ETF | 12.1375 | 12.1375 | 12.125 | 12.125 | 7440.0 |
| 2005-01-25 | DIV | ETF | 14.13 | 14.2 | 14.11 | 14.13 | 10700.0 |
| 2005-01-25 | DJP | ETF | 26.59 | 26.68 | 26.59 | 26.65 | 1600.0 |
| 2005-01-25 | DRIV | ETF | 32.4 | 33.9 | 32.33 | 33.73 | 1031762.0 |
| 2005-01-25 | DSI | ETF | 5.91 | 5.91 | 5.91 | 5.91 | 600.0 |
| 2005-01-25 | DTH | ETF | 25.33 | 25.39 | 25.3 | 25.31 | 2400.0 |
| 2005-01-25 | DUSA | ETF | 13.8 | 14.13 | 13.45 | 13.65 | 136250.0 |
> showing 50 of 254 rows — these rows as CSV