PREVIEW / etf_daily / 2005-01-03
file: by_date/etf_daily/2005/2005-01-03.parquet size: 14 KB rows: 249
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-03 | SPY | ETF | 121.56 | 121.76 | 119.9 | 120.3 | 55748000.0 |
| 2005-01-03 | QQQ | ETF | 40.07 | 40.292 | 39.37 | 39.499 | 101052208.0 |
| 2005-01-03 | IWM | ETF | 65.095 | 65.21 | 63.57 | 63.91 | 16062600.0 |
| 2005-01-03 | DIA | ETF | 108.15 | 108.59 | 106.93 | 107.32 | 11691300.0 |
| 2005-01-03 | GLD | ETF | 42.98 | 43.17 | 42.74 | 43.02 | 4750400.0 |
| 2005-01-03 | TLT | ETF | 88.18 | 88.84 | 88.16 | 88.74 | 1168000.0 |
| 2005-01-03 | AAA | ETF | 62.8 | 62.9 | 62.5 | 62.5 | 2000.0 |
| 2005-01-03 | ADRE | ETF | 86.0 | 86.0 | 82.841 | 82.9 | 11828.0 |
| 2005-01-03 | AFK | ETF | 26.5 | 26.57 | 26.5 | 26.56 | 2300.0 |
| 2005-01-03 | AGG | ETF | 102.34 | 102.55 | 102.12 | 102.4 | 479600.0 |
| 2005-01-03 | AIQ | ETF | 57.8 | 61.75 | 57.35 | 61.75 | 97480.0 |
| 2005-01-03 | ARB | ETF | 39.18 | 39.41 | 38.73 | 39.01 | 214000.0 |
| 2005-01-03 | BAB | ETF | 44.99 | 45.55 | 44.99 | 45.28 | 15300.0 |
| 2005-01-03 | BBH | ETF | 50.9167 | 51.3033 | 50.2333 | 50.5 | 2088000.0 |
| 2005-01-03 | BCM | ETF | 60.15 | 60.15 | 59.7 | 59.7 | 5400.0 |
| 2005-01-03 | BIS | ETF | 964.8 | 969.6 | 948.8 | 968.0 | 23.75 |
| 2005-01-03 | BITS | ETF | 10.64 | 11.96 | 10.64 | 11.04 | 49155.0 |
| 2005-01-03 | BKF | ETF | 37.81 | 37.81 | 37.2 | 37.5 | 11200.0 |
| 2005-01-03 | BNE | ETF | 16.0 | 16.0 | 15.93 | 15.95 | 432100.0 |
| 2005-01-03 | BRF | ETF | 15.9 | 15.96 | 15.86 | 15.94 | 5500.0 |
| 2005-01-03 | BTF | ETF | 93.39999999999999 | 93.39999999999999 | 92.79999999999998 | 92.94999999999999 | 2520.0 |
| 2005-01-03 | CBON | ETF | 30.6 | 30.9 | 29.54 | 29.8 | 40508.0 |
| 2005-01-03 | CDC | ETF | 12.2 | 12.49 | 11.95 | 12.26 | 10100.0 |
| 2005-01-03 | CDL | ETF | 16.1 | 16.11 | 15.43 | 15.52 | 756800.0 |
| 2005-01-03 | CEF | ETF | 5.4 | 5.41 | 5.35 | 5.37 | 449700.0 |
| 2005-01-03 | CEW | ETF | 27.16 | 27.16 | 27.16 | 27.16 | 200.0 |
| 2005-01-03 | CHB | ETF | 11.82 | 12.25 | 11.82 | 12.09 | 957200.0 |
| 2005-01-03 | CHIC | ETF | 10.1 | 10.17 | 9.92 | 10.06 | 283850.0 |
| 2005-01-03 | CHIR | ETF | 33.5601 | 33.75 | 32.3001 | 33.0099 | 2240248.0 |
| 2005-01-03 | CID | ETF | 9.58 | 9.63 | 9.58 | 9.63 | 500.0 |
| 2005-01-03 | CIL | ETF | 26.39 | 26.4 | 26.39 | 26.4 | 700.0 |
| 2005-01-03 | CIZ | ETF | 20.65 | 20.65 | 20.65 | 20.65 | 100.0 |
| 2005-01-03 | CN | ETF | 26.8 | 26.8 | 26.42 | 26.7 | 233600.0 |
| 2005-01-03 | CNXT | ETF | 2.03 | 2.05 | 1.94 | 1.96 | 8472011.0 |
| 2005-01-03 | CSB | ETF | 37.7 | 37.82 | 37.7 | 37.73 | 5300.0 |
| 2005-01-03 | CSM | ETF | 2.375 | 2.375 | 2.375 | 2.375 | 2000.0 |
| 2005-01-03 | CTEC | ETF | 40.849999999999994 | 43.105 | 40.849999999999994 | 41.74999999999999 | 8276.0 |
| 2005-01-03 | CURE | ETF | 0.85 | 0.8775 | 0.8187 | 0.8263 | 2586944.0 |
| 2005-01-03 | CYA | ETF | 236.0 | 250.0 | 236.0 | 246.2 | 1555.0 |
| 2005-01-03 | CYB | ETF | 4.05 | 4.05 | 3.85 | 4.0 | 10400.0 |
| 2005-01-03 | CZA | ETF | 10.35 | 10.36 | 10.29 | 10.36 | 1900.0 |
| 2005-01-03 | DGT | ETF | 64.52 | 64.61 | 63.94 | 63.94 | 8200.0 |
| 2005-01-03 | DIG | ETF | 12.6875 | 12.6875 | 12.6875 | 12.6875 | 1360.0 |
| 2005-01-03 | DIV | ETF | 14.46 | 14.5 | 14.36 | 14.4 | 59500.0 |
| 2005-01-03 | DJP | ETF | 26.66 | 26.68 | 26.65 | 26.65 | 2400.0 |
| 2005-01-03 | DRIV | ETF | 41.75 | 41.82 | 39.77 | 40.44 | 524795.0 |
| 2005-01-03 | DSI | ETF | 6.06 | 6.1 | 6.06 | 6.07 | 14400.0 |
| 2005-01-03 | DTH | ETF | 25.2 | 25.35 | 25.17 | 25.17 | 2100.0 |
| 2005-01-03 | DUSA | ETF | 14.3 | 14.34 | 13.95 | 14.26 | 63438.0 |
| 2005-01-03 | DVY | ETF | 61.74 | 61.75 | 60.61 | 60.7 | 768900.0 |
> showing 50 of 249 rows — these rows as CSV