PREVIEW / etf_daily / 2006-03-24
file: by_date/etf_daily/2006/2006-03-24.parquet size: 16 KB rows: 311
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-24 | SPY | ETF | 129.99 | 130.57 | 129.74 | 130.21 | 43209200.0 |
| 2006-03-24 | QQQ | ETF | 41.23 | 41.5001 | 41.02 | 41.3 | 81809167.0 |
| 2006-03-24 | IWM | ETF | 74.28 | 74.94 | 74.1 | 74.9 | 27560100.0 |
| 2006-03-24 | DIA | ETF | 112.67 | 113.08 | 112.34 | 112.75 | 4651600.0 |
| 2006-03-24 | GLD | ETF | 55.15 | 55.83 | 55.1 | 55.71 | 3785000.0 |
| 2006-03-24 | TLT | ETF | 88.53 | 89.29 | 88.5 | 89.09 | 954800.0 |
| 2006-03-24 | AAA | ETF | 60.64 | 60.99 | 60.4 | 60.97 | 4400.0 |
| 2006-03-24 | ADRE | ETF | 128.09 | 128.68 | 125.0 | 128.42 | 23576.0 |
| 2006-03-24 | AFK | ETF | 25.12 | 25.19 | 25.12 | 25.16 | 2600.0 |
| 2006-03-24 | AGG | ETF | 99.58 | 99.9 | 99.5 | 99.57 | 109300.0 |
| 2006-03-24 | AIQ | ETF | 32.7 | 34.4 | 32.7 | 33.9 | 12260.0 |
| 2006-03-24 | AIS | ETF | 1.61 | 1.75 | 1.61 | 1.73 | 609500.0 |
| 2006-03-24 | AOM | ETF | 6.29 | 6.35 | 6.16 | 6.24 | 63000.0 |
| 2006-03-24 | ARB | ETF | 33.82 | 34.12 | 33.59 | 34.04 | 242900.0 |
| 2006-03-24 | BAB | ETF | 61.59 | 62.24 | 61.42 | 61.87 | 31800.0 |
| 2006-03-24 | BBC | ETF | 18.25 | 18.29 | 18.0 | 18.0 | 116200.0 |
| 2006-03-24 | BBH | ETF | 64.8667 | 65.2167 | 64.4933 | 64.7467 | 604800.0 |
| 2006-03-24 | BCM | ETF | 72.52 | 72.81 | 72.32 | 72.57 | 21200.0 |
| 2006-03-24 | BITS | ETF | 31.88 | 32.6 | 31.24 | 32.6 | 12551.0 |
| 2006-03-24 | BKF | ETF | 12.98 | 13.1399 | 12.86 | 12.9 | 32600.0 |
| 2006-03-24 | BNE | ETF | 15.9 | 16.1 | 15.8 | 15.95 | 107900.0 |
| 2006-03-24 | BRF | ETF | 14.33 | 14.41 | 14.29 | 14.41 | 9800.0 |
| 2006-03-24 | BTF | ETF | 89.0 | 89.0 | 88.45 | 88.45 | 2200.0 |
| 2006-03-24 | CBON | ETF | 31.02 | 31.98 | 30.54 | 31.39 | 23509.0 |
| 2006-03-24 | CDL | ETF | 11.28 | 11.29 | 11.17 | 11.24 | 196400.0 |
| 2006-03-24 | CEF | ETF | 7.7 | 7.81 | 7.68 | 7.75 | 556600.0 |
| 2006-03-24 | CEW | ETF | 25.59 | 25.6 | 25.48 | 25.6 | 1000.0 |
| 2006-03-24 | CFO | ETF | 9.84 | 9.84 | 9.75 | 9.8 | 8600.0 |
| 2006-03-24 | CGO | ETF | 14.42 | 14.47 | 14.36 | 14.45 | 23900.0 |
| 2006-03-24 | CHB | ETF | 15.3 | 15.8 | 15.05 | 15.71 | 457700.0 |
| 2006-03-24 | CHI | ETF | 20.51 | 20.75 | 20.51 | 20.7 | 114400.0 |
| 2006-03-24 | CHIC | ETF | 18.86 | 19.24 | 18.81 | 18.9 | 228430.0 |
| 2006-03-24 | CHIR | ETF | 45.6999 | 46.0101 | 45.51 | 45.8199 | 812383.0 |
| 2006-03-24 | CHY | ETF | 16.3 | 16.37 | 16.27 | 16.36 | 142700.0 |
| 2006-03-24 | CIL | ETF | 25.62 | 25.62 | 25.62 | 25.62 | 100.0 |
| 2006-03-24 | CIZ | ETF | 23.6 | 24.0 | 23.6 | 24.0 | 2200.0 |
| 2006-03-24 | CN | ETF | 35.12 | 35.62 | 35.12 | 35.31 | 23800.0 |
| 2006-03-24 | CNXT | ETF | 3.22 | 3.28 | 3.22 | 3.26 | 9221205.0 |
| 2006-03-24 | COMB | ETF | 8.56 | 8.65 | 8.56 | 8.65 | 1681.0 |
| 2006-03-24 | CPST | ETF | 3.48 | 3.8 | 3.42 | 3.66 | 9186386.0 |
| 2006-03-24 | CSA | ETF | 21.4 | 21.6 | 21.32 | 21.51 | 74900.0 |
| 2006-03-24 | CSB | ETF | 30.49 | 30.65 | 30.4 | 30.44 | 6100.0 |
| 2006-03-24 | CSQ | ETF | 14.26 | 14.29 | 14.18 | 14.24 | 429700.0 |
| 2006-03-24 | CTEC | ETF | 60.49999999999999 | 62.4 | 60.0 | 62.15 | 8353.4 |
| 2006-03-24 | CYB | ETF | 6.43 | 6.58 | 6.4 | 6.45 | 67800.0 |
| 2006-03-24 | DBC | ETF | 23.22 | 23.39 | 23.13 | 23.22 | 310800.0 |
| 2006-03-24 | DGT | ETF | 67.45 | 67.45 | 67.45 | 67.45 | 300.0 |
| 2006-03-24 | DIG | ETF | 17.3625 | 17.375 | 17.3625 | 17.375 | 2400.0 |
| 2006-03-24 | DIV | ETF | 12.52 | 12.59 | 12.52 | 12.58 | 4400.0 |
| 2006-03-24 | DRIV | ETF | 42.83 | 42.83 | 42.2 | 42.5 | 744795.0 |
> showing 50 of 311 rows — these rows as CSV