PREVIEW / etf_daily / 2005-01-14
file: by_date/etf_daily/2005/2005-01-14.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-14 | SPY | ETF | 117.97 | 118.53 | 117.76 | 118.24 | 42032500.0 |
| 2005-01-14 | QQQ | ETF | 38.2 | 38.52 | 38.19 | 38.43 | 93530063.0 |
| 2005-01-14 | IWM | ETF | 61.045 | 61.55 | 60.915 | 61.445 | 13541000.0 |
| 2005-01-14 | DIA | ETF | 105.13 | 105.65 | 105.05 | 105.44 | 5986900.0 |
| 2005-01-14 | GLD | ETF | 42.19 | 42.32 | 42.13 | 42.32 | 1262300.0 |
| 2005-01-14 | TLT | ETF | 89.9 | 90.4 | 89.81 | 90.17 | 1043800.0 |
| 2005-01-14 | AAA | ETF | 57.45 | 57.99 | 57.45 | 57.99 | 4800.0 |
| 2005-01-14 | ADRE | ETF | 83.0 | 83.0 | 79.811 | 80.89 | 3280.0 |
| 2005-01-14 | AFK | ETF | 26.54 | 26.64 | 26.54 | 26.61 | 3100.0 |
| 2005-01-14 | AGG | ETF | 102.67 | 102.71 | 102.37 | 102.42 | 124200.0 |
| 2005-01-14 | AIQ | ETF | 67.75 | 69.25 | 66.95 | 68.5 | 48860.0 |
| 2005-01-14 | ARB | ETF | 37.09 | 37.53 | 37.01 | 37.33 | 116900.0 |
| 2005-01-14 | BAB | ETF | 47.16 | 47.5 | 46.9 | 47.33 | 52500.0 |
| 2005-01-14 | BBH | ETF | 49.1867 | 49.2867 | 48.57 | 49.15 | 1821600.0 |
| 2005-01-14 | BCM | ETF | 57.47 | 57.8 | 57.29 | 57.53 | 21600.0 |
| 2005-01-14 | BIS | ETF | 964.8 | 966.4 | 964.8 | 966.4 | 6.25 |
| 2005-01-14 | BITS | ETF | 10.96 | 10.96 | 9.72 | 10.56 | 22608.0 |
| 2005-01-14 | BKF | ETF | 35.0 | 35.0 | 34.8 | 34.85 | 7400.0 |
| 2005-01-14 | BNE | ETF | 15.08 | 15.26 | 15.08 | 15.26 | 136200.0 |
| 2005-01-14 | BRF | ETF | 15.6 | 15.72 | 15.6 | 15.72 | 5400.0 |
| 2005-01-14 | BTF | ETF | 89.25 | 89.85 | 89.25 | 89.85 | 980.0 |
| 2005-01-14 | CBON | ETF | 28.7 | 28.7 | 28.25 | 28.28 | 6350.0 |
| 2005-01-14 | CDC | ETF | 10.57 | 10.57 | 10.32 | 10.35 | 2200.0 |
| 2005-01-14 | CDL | ETF | 14.24 | 14.3 | 14.01 | 14.15 | 549700.0 |
| 2005-01-14 | CEF | ETF | 5.36 | 5.36 | 5.25 | 5.25 | 316800.0 |
| 2005-01-14 | CEW | ETF | 27.45 | 27.45 | 27.45 | 27.45 | 100.0 |
| 2005-01-14 | CGW | ETF | 29.45 | 29.45 | 28.4 | 28.58 | 11400.0 |
| 2005-01-14 | CHB | ETF | 11.62 | 11.83 | 11.51 | 11.65 | 434300.0 |
| 2005-01-14 | CHIC | ETF | 10.19 | 10.19 | 9.86 | 9.95 | 269305.0 |
| 2005-01-14 | CHIR | ETF | 34.2999 | 34.7001 | 34.2501 | 34.6299 | 1410676.0 |
| 2005-01-14 | CID | ETF | 9.25 | 9.25 | 9.25 | 9.25 | 3000.0 |
| 2005-01-14 | CIZ | ETF | 20.3 | 20.3 | 20.3 | 20.3 | 200.0 |
| 2005-01-14 | CN | ETF | 28.35 | 28.5 | 28.35 | 28.45 | 173100.0 |
| 2005-01-14 | CNXT | ETF | 1.635 | 1.67 | 1.61 | 1.63 | 7337253.0 |
| 2005-01-14 | CSB | ETF | 35.93 | 36.65 | 35.91 | 36.26 | 8200.0 |
| 2005-01-14 | CSM | ETF | 2.375 | 2.375 | 2.375 | 2.375 | 6000.0 |
| 2005-01-14 | CTEC | ETF | 41.699999999999996 | 44.5 | 40.9 | 44.5 | 7654.0 |
| 2005-01-14 | CURE | ETF | 0.7 | 0.7063 | 0.6713 | 0.685 | 1350704.0 |
| 2005-01-14 | CYA | ETF | 220.0 | 220.0 | 206.0 | 207.0 | 910.0 |
| 2005-01-14 | CYB | ETF | 4.5 | 4.63 | 4.4 | 4.63 | 38600.0 |
| 2005-01-14 | CZA | ETF | 10.45 | 10.45 | 10.4 | 10.44 | 7200.0 |
| 2005-01-14 | DGT | ETF | 62.9 | 63.03 | 62.9 | 63.03 | 1300.0 |
| 2005-01-14 | DIV | ETF | 14.16 | 14.19 | 14.06 | 14.1 | 31100.0 |
| 2005-01-14 | DJP | ETF | 26.66 | 26.66 | 26.66 | 26.66 | 100.0 |
| 2005-01-14 | DRIV | ETF | 33.91 | 35.26 | 33.659 | 35.085 | 683661.0 |
| 2005-01-14 | DSI | ETF | 5.9 | 5.9 | 5.895 | 5.895 | 1800.0 |
| 2005-01-14 | DTH | ETF | 25.37 | 25.37 | 25.3 | 25.3 | 600.0 |
| 2005-01-14 | DUSA | ETF | 14.75 | 15.0 | 14.5 | 14.91 | 108588.0 |
| 2005-01-14 | DVY | ETF | 59.4 | 59.4 | 59.01 | 59.39 | 458200.0 |
| 2005-01-14 | EDEN | ETF | 1.22 | 1.22 | 1.15 | 1.16 | 41700.0 |
> showing 50 of 249 rows — these rows as CSV