PREVIEW / etf_daily / 2024-06-05
file: by_date/etf_daily/2024/2024-06-05.parquet size: 121 KB rows: 3,385
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 |
|---|---|---|---|---|---|---|---|
| 2024-06-05 | SPY | ETF | 530.77 | 534.69 | 528.73 | 534.67 | 47610400.0 |
| 2024-06-05 | QQQ | ETF | 457.98 | 463.61 | 454.408 | 463.53 | 33817409.0 |
| 2024-06-05 | IWM | ETF | 203.3 | 205.06 | 201.79 | 205.06 | 20707600.0 |
| 2024-06-05 | DIA | ETF | 388.6 | 388.97 | 385.97 | 388.53 | 2181400.0 |
| 2024-06-05 | GLD | ETF | 216.69 | 218.08 | 215.93 | 217.82 | 5479200.0 |
| 2024-06-05 | TLT | ETF | 93.0 | 93.35 | 92.39 | 93.35 | 43153900.0 |
| 2024-06-05 | AAA | ETF | 25.09 | 25.12 | 25.08 | 25.11 | 5800.0 |
| 2024-06-05 | AAAU | ETF | 23.18 | 23.33 | 23.1 | 23.3 | 3041700.0 |
| 2024-06-05 | AADR | ETF | 63.36 | 63.73 | 63.36 | 63.73 | 500.0 |
| 2024-06-05 | AAPB | ETF | 22.12 | 22.46 | 22.05 | 22.25 | 138458.0 |
| 2024-06-05 | AAPD | ETF | 19.94 | 19.9922 | 19.8 | 19.9 | 106890.0 |
| 2024-06-05 | AAPR | ETF | 24.925 | 25.03 | 24.9156 | 25.0 | 16987.0 |
| 2024-06-05 | AAPU | ETF | 28.58 | 29.04 | 28.48 | 28.75 | 495367.0 |
| 2024-06-05 | AAPX | ETF | 25.92 | 26.225 | 25.74 | 25.9425 | 37624.0 |
| 2024-06-05 | AAXJ | ETF | 71.1 | 71.46 | 70.79 | 71.46 | 365300.0 |
| 2024-06-05 | ABCS | ETF | 26.1839 | 26.4004 | 26.1839 | 26.4004 | 4495.0 |
| 2024-06-05 | ABEQ | ETF | 30.32 | 30.411 | 30.31 | 30.411 | 7400.0 |
| 2024-06-05 | ACES | ETF | 31.31 | 31.76 | 31.14 | 31.74 | 29000.0 |
| 2024-06-05 | ACIO | ETF | 36.61 | 36.86 | 36.53 | 36.855 | 136100.0 |
| 2024-06-05 | ACSI | ETF | 53.819 | 53.985 | 53.819 | 53.985 | 200.0 |
| 2024-06-05 | ACT | ETF | 30.69 | 31.64 | 30.18 | 30.57 | 295736.0 |
| 2024-06-05 | ACTV | ETF | 32.95 | 33.139 | 32.76 | 33.139 | 8800.0 |
| 2024-06-05 | ACVF | ETF | 40.3 | 40.5 | 40.11 | 40.494 | 5700.0 |
| 2024-06-05 | ACWF | ETF | 42.1 | 42.25 | 42.1 | 42.23 | 4539.0 |
| 2024-06-05 | ACWI | ETF | 111.82 | 112.43 | 111.34 | 112.43 | 2322800.0 |
| 2024-06-05 | ACWV | ETF | 105.0 | 105.16 | 104.61 | 105.16 | 67700.0 |
| 2024-06-05 | ACWX | ETF | 54.53 | 54.65 | 54.24 | 54.64 | 344300.0 |
| 2024-06-05 | ADFI | ETF | 8.48 | 8.57 | 8.48 | 8.539 | 31700.0 |
| 2024-06-05 | ADIV | ETF | 14.71 | 14.744 | 14.71 | 14.744 | 300.0 |
| 2024-06-05 | ADME | ETF | 42.74 | 42.753 | 42.68 | 42.753 | 1900.0 |
| 2024-06-05 | ADPV | ETF | 29.95 | 30.435 | 29.95 | 30.4197 | 6215.0 |
| 2024-06-05 | AEMB | ETF | 38.47 | 38.47 | 38.47 | 38.47 | 100.0 |
| 2024-06-05 | AESR | ETF | 15.88 | 16.001 | 15.87 | 16.001 | 28500.0 |
| 2024-06-05 | AETH | ETF | 50.0607 | 50.959 | 49.65 | 50.8813 | 33720.0 |
| 2024-06-05 | AFIF | ETF | 9.11 | 9.14 | 9.11 | 9.12 | 41500.0 |
| 2024-06-05 | AFK | ETF | 15.45 | 15.74 | 15.36 | 15.52 | 14800.0 |
| 2024-06-05 | AFLG | ETF | 31.02 | 31.269 | 31.02 | 31.227 | 9700.0 |
| 2024-06-05 | AFMC | ETF | 29.38 | 29.542 | 29.38 | 29.542 | 300.0 |
| 2024-06-05 | AFSM | ETF | 28.62 | 28.81 | 28.61 | 28.754 | 12400.0 |
| 2024-06-05 | AFTY | ETF | 14.5 | 14.5 | 14.44 | 14.472 | 900.0 |
| 2024-06-05 | AGG | ETF | 97.29 | 97.45 | 97.04 | 97.45 | 4602500.0 |
| 2024-06-05 | AGGH | ETF | 20.99 | 21.0 | 20.9522 | 21.0 | 24280.0 |
| 2024-06-05 | AGGY | ETF | 43.18 | 43.27 | 43.145 | 43.27 | 63600.0 |
| 2024-06-05 | AGMI | ETF | 26.4694 | 26.86 | 26.4694 | 26.8275 | 7004.0 |
| 2024-06-05 | AGNG | ETF | 30.159 | 30.37 | 30.159 | 30.25 | 6800.0 |
| 2024-06-05 | AGOX | ETF | 26.736 | 27.22 | 26.736 | 27.19 | 17600.0 |
| 2024-06-05 | AGQ | ETF | 39.4 | 40.32 | 38.75 | 40.16 | 1403500.0 |
| 2024-06-05 | AGQI | ETF | 14.38 | 14.4686 | 14.38 | 14.4686 | 38505.0 |
| 2024-06-05 | AGRH | ETF | 25.93 | 25.93 | 25.915 | 25.915 | 763.0 |
| 2024-06-05 | AGZ | ETF | 107.66 | 107.81 | 107.61 | 107.81 | 12500.0 |
> showing 50 of 3,385 rows — these rows as CSV