PREVIEW / etf_daily / 2005-03-29
file: by_date/etf_daily/2005/2005-03-29.parquet size: 14 KB rows: 261
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-03-29 | SPY | ETF | 117.14 | 117.9 | 116.25 | 116.53 | 71160300.0 |
| 2005-03-29 | QQQ | ETF | 36.26 | 36.58 | 35.94 | 36.05 | 119633330.0 |
| 2005-03-29 | IWM | ETF | 60.98 | 61.545 | 59.925 | 60.2 | 21808800.0 |
| 2005-03-29 | DIA | ETF | 104.61 | 105.13 | 103.86 | 104.07 | 7659600.0 |
| 2005-03-29 | GLD | ETF | 42.61 | 42.63 | 42.54 | 42.56 | 1197800.0 |
| 2005-03-29 | TLT | ETF | 88.08 | 88.28 | 87.99 | 88.25 | 1135000.0 |
| 2005-03-29 | AAA | ETF | 62.67 | 63.0 | 62.52 | 62.52 | 10500.0 |
| 2005-03-29 | ADRE | ETF | 84.01 | 84.01 | 82.04 | 82.04 | 6380.0 |
| 2005-03-29 | AFK | ETF | 25.55 | 25.69 | 25.43 | 25.6 | 29900.0 |
| 2005-03-29 | AGG | ETF | 100.79 | 100.87 | 100.51 | 100.58 | 270600.0 |
| 2005-03-29 | AIQ | ETF | 45.5 | 47.2 | 45.5 | 47.05 | 21220.0 |
| 2005-03-29 | ARB | ETF | 42.7 | 43.29 | 42.52 | 42.55 | 317100.0 |
| 2005-03-29 | BAB | ETF | 49.55 | 49.96 | 49.1 | 49.13 | 12600.0 |
| 2005-03-29 | BBH | ETF | 47.3933 | 47.8467 | 46.9167 | 47.1333 | 2616000.0 |
| 2005-03-29 | BCM | ETF | 58.72 | 59.2 | 58.72 | 58.86 | 10700.0 |
| 2005-03-29 | BIS | ETF | 689.6 | 689.6 | 680.0 | 680.0 | 10.6 |
| 2005-03-29 | BITS | ETF | 13.52 | 15.2 | 12.2 | 12.684 | 131838.0 |
| 2005-03-29 | BKF | ETF | 39.95 | 39.95 | 39.62 | 39.85 | 23800.0 |
| 2005-03-29 | BNE | ETF | 14.69 | 14.85 | 14.48 | 14.49 | 969100.0 |
| 2005-03-29 | BRF | ETF | 15.36 | 15.53 | 15.36 | 15.53 | 6400.0 |
| 2005-03-29 | BTF | ETF | 87.2 | 87.2 | 86.05 | 86.6 | 560.0 |
| 2005-03-29 | CBON | ETF | 25.52 | 25.8 | 25.031 | 25.75 | 64127.0 |
| 2005-03-29 | CDC | ETF | 8.1 | 8.3 | 8.1 | 8.3 | 4900.0 |
| 2005-03-29 | CDL | ETF | 13.88 | 13.95 | 13.7 | 13.78 | 230600.0 |
| 2005-03-29 | CEF | ETF | 5.29 | 5.35 | 5.28 | 5.29 | 385900.0 |
| 2005-03-29 | CEW | ETF | 26.55 | 26.55 | 26.55 | 26.55 | 400.0 |
| 2005-03-29 | CGW | ETF | 29.61 | 29.61 | 29.6 | 29.6 | 13200.0 |
| 2005-03-29 | CHB | ETF | 9.62 | 9.77 | 9.49 | 9.51 | 719200.0 |
| 2005-03-29 | CHIC | ETF | 11.81 | 12.42 | 11.81 | 11.95 | 365986.0 |
| 2005-03-29 | CHIR | ETF | 35.2899 | 35.8701 | 34.8999 | 35.1399 | 1331905.0 |
| 2005-03-29 | CID | ETF | 9.64 | 9.96 | 9.64 | 9.95 | 116200.0 |
| 2005-03-29 | CIL | ETF | 26.06 | 26.06 | 26.06 | 26.06 | 400.0 |
| 2005-03-29 | CIZ | ETF | 20.75 | 20.75 | 20.5 | 20.5 | 800.0 |
| 2005-03-29 | CN | ETF | 27.75 | 27.78 | 27.75 | 27.75 | 30500.0 |
| 2005-03-29 | CNXT | ETF | 1.38 | 1.48 | 1.36 | 1.44 | 8394547.0 |
| 2005-03-29 | CSB | ETF | 32.54 | 32.54 | 32.2 | 32.2 | 18800.0 |
| 2005-03-29 | CSM | ETF | 2.3775 | 2.3775 | 2.375 | 2.375 | 4800.0 |
| 2005-03-29 | CTEC | ETF | 50.3 | 51.1 | 49.55 | 49.800000000000004 | 6351.400000000001 |
| 2005-03-29 | CURE | ETF | 0.3825 | 0.3825 | 0.37 | 0.3787 | 1908000.0 |
| 2005-03-29 | CYA | ETF | 164.0 | 166.0 | 162.0 | 165.0 | 630.0 |
| 2005-03-29 | CYB | ETF | 3.95 | 4.0 | 3.95 | 4.0 | 2600.0 |
| 2005-03-29 | DGT | ETF | 62.82 | 63.25 | 62.49 | 62.49 | 11100.0 |
| 2005-03-29 | DIV | ETF | 12.57 | 12.57 | 12.4 | 12.49 | 45400.0 |
| 2005-03-29 | DRIV | ETF | 31.2 | 31.33 | 30.05 | 30.22 | 993404.0 |
| 2005-03-29 | DSI | ETF | 5.94 | 5.94 | 5.94 | 5.94 | 2000.0 |
| 2005-03-29 | DUSA | ETF | 9.29 | 9.31 | 9.0 | 9.03 | 86166.0 |
| 2005-03-29 | DVY | ETF | 59.25 | 59.62 | 58.81 | 58.92 | 392400.0 |
| 2005-03-29 | EDEN | ETF | 0.75 | 0.8 | 0.65 | 0.75 | 175213.0 |
| 2005-03-29 | EDV | ETF | 25.6 | 25.7 | 25.57 | 25.66 | 11400.0 |
| 2005-03-29 | EEM | ETF | 22.2889 | 22.2889 | 21.7611 | 21.7978 | 9969300.0 |
> showing 50 of 261 rows — these rows as CSV